Getting database error often while trying to load Subsim

[Castout]

Any problem?

But I think it's only on my end.

Obviously some highly corrupt people in Singapore aren't too happy with my sig on this forum. Been having problem loading subsim quite often nowadays.

[Hottentot]

Not to dwell on the fact that my sarcasm radar went off the scale when reading the first post and I hope it was right...

I'm having the same problem.

Edit: Yay, I've always wanted that avatar.

[Jimbuna]

Edit: Yay, I've always wanted that avatar.

Very nice :DL

[Gerald]

Look like S.....

[Hottentot]

That does it, I will never post anything again. I will only edit my old posts and keep at the magic number forever.

Edit: Balls...

[Jimbuna]

That does it, I will never post anything again. I will only edit my old posts and keep at the magic number forever.

Edit: Balls...

Better off looking like the monkey man :DL

[Castout]

Ah same problem huh then I'm glad.

[Reece]

This database error is getting much worse!!:hmmm:

[Onkel Neal]

I need proper reports! Times! Durations!
http://www.celluloidheroreviews.com/images/das-boot.jpg

[Reece]

Times are GMT/UTC
Between 10:24 and 10:28 this fault was occurring spasmodically.
This error for subsim forums:
http://i66.photobucket.com/albums/h244/Reecehk/databaseerror.jpg

and this error for Subsim.com:
http://i66.photobucket.com/albums/h244/Reecehk/databaseerror2.jpg

Edit: Viewing pages are taking long periods (10:34, 10:41)
10:45 - 10:57 No problems.

[Jimbuna]

Probably of little if any use but I've yet to experience the problem...will report details if encountered :hmmm:

[Flaxpants]

FYI happening occasionally to me here in Thailand lately. Will post report next time it happens.

[Hottentot]

This hasn't been going on for too long, I'd estimate just a week or two. It's very occasional and infrequent. Some times it affects just specific forums, so I can for example access Silent Hunter 3 forum, but not the General Topics.

Last time it happened yesterday when I was posting in the D-day thread for the first time. The post went trough, though, so from that I can deduce that it started at 04:03 pm (GMT +3) and lasted for approximately ten minutes. During that time I couldn't access Subsim forums at all.

[kranz]

I get this quite often when I want to check someone's profile.

[Herr-Berbunch]

This happened to me last week, I'd also been having t'interweb issues generally but even when I could see other sites I had the mysql and the db return.

Hang on, I posted on Steam about this so can find out the time (for me at least!)...

3 June 2011, 2233 BST, so that's 2133 GMT/Zulu/UTC, and after a few rounds of Bad Company 2 I'd posted it was up at 0011 BST, 2311 GMT/Etc./Etc.

Please don't disappear again, you've suckered me in to your subsim bosom and I like it here :doh: ;)

[Onkel Neal]

Ok, checking the logs, I see there are about 5 times each day during a 6 hour window where the db is hitting max connections. I'll check into it, stay tuned.

thanks! :salute:
Neal

[Herr-Berbunch]

Ok, checking the logs, I see there are about 5 times each day during a 6 hour window where the db is hitting max connections. I'll check into it, stay tuned.

thanks! :salute:
Neal

That'll be when Feuer Frei! and Vendor have just read the news! :D

[Gerald]

Hey ... I have actually myself have had some problems with the page, not always but it happens now and then :yep:

[Flaxpants]

That'll be when Feuer Frei! and Vendor have just read the news! :D

:haha:

[Jimbuna]

That'll be when Feuer Frei! and Vendor have just read the news! :D

LOL :DL

@Neal...been unable to get on all day until just now 1640 GMT

[TLAM Strike]

Yea been getting this error all morning until now:
http://img815.imageshack.us/img815/1825/errorjy.th.jpg (http://imageshack.us/photo/my-images/815/errorjy.jpg/)

[Onkel Neal]

Yeah, thanks. Been a long night :(

[Jimbuna]

Yea been getting this error all morning until now:
http://img815.imageshack.us/img815/1825/errorjy.th.jpg (http://imageshack.us/photo/my-images/815/errorjy.jpg/)

Yeah...that's the one.

[Gerald]

Me too,THX for PM :yep:

[TLAM Strike]

Yeah, thanks. Been a long night :(
Yea and I've seen the photos to prove it...
http://img88.imageshack.us/img88/8679/28534d1306119492imagine.jpg

:doh:

[Gerald]

:haha:

[Jimbuna]

Yea and I've seen the photos to prove it...


:doh:

When Reece sees that I reckon you'll be in big trouble :DL

[Reece]

When Reece sees that I reckon you'll be in big trouble :DL
:dead: Noooo! (http://www.nooooooooooooooo.com/)

[Onkel Neal]

Ok, I have not gotten any error emails from the server over the last 3 days. Anyone else?

[FIREWALL]

Probably of little if any use but I've yet to experience the problem...will report details if encountered :hmmm:

Same here. :yep:

[Gerald]

I've had problems now for 10 minutes, and it is simply impossible to load the page, :hmmm:

[Onkel Neal]

Ok, I am no longer getting the error, too many connections, emails, but the server is still loading up and becoming unresponsive around the same times. I know one of the times is 1:07am CST, because the emails always used to have that time/date.

Just now the server was under super-heavy load
top - 01:18:01 up 7 days, 48 min, 1 user, load average: 42.50, 20.90, 9.80
Tasks: 814 total, 1 running, 805 sleeping, 3 stopped, 5 zombie
Cpu(s): 0.2%us, 0.1%sy, 0.0%ni, 86.3%id, 13.4%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 12292132k total, 12161568k used, 130564k free, 26300k buffers
Swap: 14346004k total, 260k used, 14345744k free, 7528652k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17578 mysql 15 0 2188m 547m 4684 S 2.0 4.6 215:07.79 mysqld
20825 subsimc 18 0 128m 16m 6828 S 1.3 0.1 0:00.04 php
20660 root 15 0 13292 1700 824 R 0.7 0.0 0:00.70 top
978 root 10 -5 0 0 0 S 0.3 0.0 2:58.24 scsi_eh_1
1083 root 10 -5 0 0 0 S 0.3 0.0 0:11.81 kjournald



So, it must be running the backups or something around then. I don't think the server tech fixed anything, he probably just shut off the email error message function :haha: