Page 1 of 1

Database glitches

Posted: Sat Nov 17, 2018 3:23 pm
by Bookworm
I'm not sure what's causing them. I've just taken down the web server and sql server, and restarted them.

What's odd is that this isn't the normal overload, which pounds the server into submission until the internal system crashes mysql and restarts it. The system itself let me in with no problems.

I'll do some log checking later on today.

Re: Database glitches

Posted: Tue Nov 20, 2018 12:37 pm
by Bookworm
Has anyone seen a glitch since Monday morning? I did some database repairs (on a different database) to fix a few errors.

Re: Database glitches

Posted: Tue Nov 20, 2018 10:22 pm
by Warrl
Bookworm wrote: Tue Nov 20, 2018 12:37 pm Has anyone seen a glitch since Monday morning? I did some database repairs (on a different database) to fix a few errors.
I've seen messages from Glytch since then...

Re: Database glitches

Posted: Tue Nov 20, 2018 11:07 pm
by lake_wrangler
Warrl wrote: Tue Nov 20, 2018 10:22 pm
Bookworm wrote: Tue Nov 20, 2018 12:37 pm Has anyone seen a glitch since Monday morning? I did some database repairs (on a different database) to fix a few errors.
I've seen messages from Glytch since then...
So have I, but none of the "too many connections" kind that I was getting before.

Re: Database glitches

Posted: Wed Nov 21, 2018 2:29 am
by GlytchMeister
I can’t remember if it was after Monday morning, but I do recall some MySQL errors of some sort recently. Is that what you’re referring to?

It has been a while, though, so I think it’s been taken care of.

Re: Database glitches

Posted: Wed Nov 21, 2018 12:35 pm
by lake_wrangler
GlytchMeister wrote: Wed Nov 21, 2018 2:29 am I can’t remember if it was after Monday morning, but I do recall some MySQL errors of some sort recently. Is that what you’re referring to?

It has been a while, though, so I think it’s been taken care of.
I don't know if that is specifically what he is referring to, but I was the following error recently:
General Error

SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
So I sent a PM to Bookworm, to let him know. By the time I had enough time to return to the forum again, the error was no longer occurring. (Yay!)

Re: Database glitches

Posted: Wed Nov 21, 2018 9:21 pm
by Atomic
I've gotten a few of those SQL connection errors as well. A short wait and reload fixed it.

Guess the SQL hamsters are constipated or something!

Re: Database glitches

Posted: Wed Nov 21, 2018 10:13 pm
by Bookworm
Corrupt index in the database for thezombiehunters.com forum.

Re: Database glitches

Posted: Wed Nov 21, 2018 11:12 pm
by GlytchMeister
Wait... a completely different forum can crash our forum?

Re: Database glitches

Posted: Wed Nov 21, 2018 11:24 pm
by Bookworm
Apparently as MySQL/MariaDB keeps trying and trying to autorepair a table, it can overload itself with database queries. Weird, yes.