At or around 15:00 UTC, kept getting an SQL error

About this bulletin board and the Pale Moon website

Moderators: FranklinDM, Lootyhoof

RJARRRPCGP
Lunatic
Lunatic
Posts: 400
Joined: 2015-06-22, 19:48
Location: USA (North Springfield, Vermont)
Contact:

At or around 15:00 UTC, kept getting an SQL error

Unread post by RJARRRPCGP » 2017-09-18, 01:36

phpBB kept saying that error message "too many connections" was returned from the SQL server. Was the SQL server DoS'ed or just maintenance?
I didn't see anything about the board having maintenance on 9/17. (17/9)

User avatar
rabnbeinn
Lunatic
Lunatic
Posts: 350
Joined: 2011-11-18, 20:38
Location: Scotland

Re: At or around 15:00 UTC, kept getting an SQL error

Unread post by rabnbeinn » 2017-09-18, 07:45

I had the same issue last night, checked back an hr later and all was well...

User avatar
Moonchild
Pale Moon guru
Pale Moon guru
Posts: 35602
Joined: 2011-08-28, 17:27
Location: Motala, SE
Contact:

Re: At or around 15:00 UTC, kept getting an SQL error

Unread post by Moonchild » 2017-09-18, 07:53

Some kind of glitch; I initially thought DoS as well but didn't see anything in the logs to support that. I ran some db maintenance afterward but all looked OK. I'm keeping an eye on it.
"Sometimes, the best way to get what you want is to be a good person." -- Louis Rossmann
"Seek wisdom, not knowledge. Knowledge is of the past; wisdom is of the future." -- Native American proverb
"Linux makes everything difficult." -- Lyceus Anubite

User avatar
Moonchild
Pale Moon guru
Pale Moon guru
Posts: 35602
Joined: 2011-08-28, 17:27
Location: Motala, SE
Contact:

Re: At or around 15:00 UTC, kept getting an SQL error

Unread post by Moonchild » 2017-09-18, 10:20

Update: seems like it was a lingering issue from abuse happening on the 15th. Someone on Comcast hammering the server with invalid requests, saturating the SQL server with stale connections. I'll have a look at blocking the type of request causing this.
"Sometimes, the best way to get what you want is to be a good person." -- Louis Rossmann
"Seek wisdom, not knowledge. Knowledge is of the past; wisdom is of the future." -- Native American proverb
"Linux makes everything difficult." -- Lyceus Anubite

Locked