muyongshi Posted September 10, 2007 at 08:07 AM Report Posted September 10, 2007 at 08:07 AM For the last couple weeks at least I have been getting many "database error" messages. Won't let me connect for anywhere between 2 and 10 minutes and then I have to re-login. Any idea what is going on? Quote
woliveri Posted September 19, 2007 at 02:29 PM Report Posted September 19, 2007 at 02:29 PM I just got the same thing about 20 minutes ago.. now it's ok (without relogging in). Quote
muyongshi Posted September 19, 2007 at 02:34 PM Author Report Posted September 19, 2007 at 02:34 PM I had it again (I've lost count by now) for about 5 min over an hour ago and i was on of the first to log back on because there was NO users online. Quote
gato Posted September 19, 2007 at 03:09 PM Report Posted September 19, 2007 at 03:09 PM Server problem probably. Quote
roddy Posted September 19, 2007 at 09:24 PM Report Posted September 19, 2007 at 09:24 PM Yeah, I'm currently trying to clear my inbox of several thousand automated error reports, seems like a server problem caused a bit of trouble. Hopefully back to normal now. Muyongshi, are you getting any specific error message? Or just a generic 'database error'. If there's anything specific can you email it to admin@ when it happens - it seems this happens to you more often. I can see that there have been almost daily episodes of this, but it's normally something like a minute at a time and it would be unusual for any one user to repeatedly come across it. Plus it shouldn't require logging back in, hence I'm wondering if there's something else at work (though I have no idea what ) Quote
muyongshi Posted September 19, 2007 at 10:25 PM Author Report Posted September 19, 2007 at 10:25 PM I am pretty sure that it is just a generic database error but I will check carefully if it happens again (keeping my fingers crossed). In regards as it seems to happen to me more often...I think I just get unlucky more often. Quote
roddy Posted September 19, 2007 at 10:33 PM Report Posted September 19, 2007 at 10:33 PM Well, someone's got to be unlucky. Fortunately, it's not me Sometimes database records can get mixed up and cause problems, but I've only seen it happen with topics before, never a user so I doubt it's that Usage figures are up quite a bit (maybe 25% over the last couple of months) so it's also possibly we're outgrowing the current hosting set up. As for this particular episode, seems to be associated with a massive number of requests from someone in the Ukraine. IP ban in place . . . Quote
muyongshi Posted September 19, 2007 at 10:45 PM Author Report Posted September 19, 2007 at 10:45 PM Good. For a minute I was worried that I was doing it. You never know with this being Mianyang. All the military set-up's, nuclear research, space program, and the like. Oh is that top secret? (sh) Quote
muyongshi Posted September 23, 2007 at 10:33 PM Author Report Posted September 23, 2007 at 10:33 PM Just happened again and it is just a general error. The error reads as follows: Database Error The database has encountered a problem Wonder if our Ukraine friend is back... Quote
roddy Posted October 11, 2007 at 12:09 PM Report Posted October 11, 2007 at 12:09 PM Nobody worry about the five minute outage just then, I know exactly why it happened. Oh yes, exactly why . . . Quote
roddy Posted October 12, 2007 at 10:36 AM Report Posted October 12, 2007 at 10:36 AM I've made a few changes to try and stop this happening - had the hosting company up the number of connections to the database we have, and also banned a few of the less friendly search engine indexers (the kind that think it's amusing to download the entire site in five minutes and then send us one visitor per year by way of a thank you). I'm also going to be keeping a closer eye on the error reports now, but if you have any issues do let me know - squeaky wheels get the oil, after all. Quote
muyongshi Posted October 13, 2007 at 01:01 PM Author Report Posted October 13, 2007 at 01:01 PM Great! So what are these search engines?? I think I want to try one out (j/k) Quote
roddy Posted October 27, 2007 at 12:37 PM Report Posted October 27, 2007 at 12:37 PM Myriam, first, please stop making posts and then deleting them. Secondly, the forum is working perfectly. Quote
gato Posted October 28, 2007 at 04:34 AM Report Posted October 28, 2007 at 04:34 AM "Database Error" just now. Quote
roddy Posted October 28, 2007 at 06:56 AM Report Posted October 28, 2007 at 06:56 AM Consider yourself honored - we're averaging 20 a day on over 200,000 (edit: Have no idea where I got that number from. Nearer 40,000 including bots) page views, not everyone is lucky enough to see one . . . Quote
muyongshi Posted October 28, 2007 at 08:35 AM Author Report Posted October 28, 2007 at 08:35 AM So I get most of the luck huh??? Quote
roddy Posted October 28, 2007 at 10:01 AM Report Posted October 28, 2007 at 10:01 AM Yep. Number of database errors has dropped significantly since I made the changes mentioned above - I haven't seen a single one. I get emailed reports, we're averaging 20 a day, all due to server restarts. I do see timeouts now and then, but I seem to get those on a number of websites, particularly international ones and I wouldn't be too worried unless I was getting consistent reports from people closer to the server - ie, the US or UK (server is in Manchester). Quote
roddy Posted November 4, 2007 at 02:20 PM Report Posted November 4, 2007 at 02:20 PM Banned a few more IP ranges after a couple of hiccups this evening . . . Quote
muyongshi Posted November 4, 2007 at 02:24 PM Author Report Posted November 4, 2007 at 02:24 PM I was wondering if more changes were coming after I got those hiccups...thanks roddy! Quote
roddy Posted November 4, 2007 at 02:27 PM Report Posted November 4, 2007 at 02:27 PM Do flag them up when you notice them, at least if it lasts more than a minute or two - although I do get emails every time there's an error they get filtered into a 'don't need to read' folder and I'm not necessarily checking that every day. That said, when you do get a database error message, don't sit there pressing F5 - that ain't helping Quote
Recommended Posts
Join the conversation
You can post now and select your username and password later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.