RTTL SQL errors etc?

What can the Admins do to help, any requests for changes, updates, etc.
User avatar
Taipan
Posts: 13945
Joined: Sat Mar 14, 2020 1:48 pm
Location: Essex Riviera!
Has thanked: 15949 times
Been thanked: 10243 times

RTTL SQL errors etc?

Post by Taipan »

Dunno if its a sign of impending doom or just me, but I couldn't get on earlier and was getting these messages?

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.

This site can’t be reached
revtothelimit.co.uk refused to connect.
Try:

Checking the connection
Checking the proxy and the firewall
ERR_CONNECTION_REFUSED
User avatar
Yorick
Posts: 16736
Joined: Sat Mar 14, 2020 8:20 pm
Location: Paradise
Has thanked: 10263 times
Been thanked: 6885 times

Re: RTTL SQL errors etc?

Post by Yorick »

We need a DBA ;)
User avatar
weeksy
Site Admin
Posts: 23416
Joined: Sat Mar 14, 2020 12:08 pm
Has thanked: 5450 times
Been thanked: 13085 times

Re: RTTL SQL errors etc?

Post by weeksy »

Yeah we had a few timeouts at the same time.

I pinged them a message but i know the reply will be something along the lines of

"yeah should be working now"

I'll then press them again and they'll blame a service restart.

My guess is that it's hosted on a specific virtual machine and every now and again it's patched and rebooted, which gives a 3-4 mins downtime. Obviously this shouldn't actually be the case... but it happens every 2-3 months.
User avatar
weeksy
Site Admin
Posts: 23416
Joined: Sat Mar 14, 2020 12:08 pm
Has thanked: 5450 times
Been thanked: 13085 times

Re: RTTL SQL errors etc?

Post by weeksy »

Hello,

Thank you for your update.

Inedeed, there were MySQL overload which caused several connections to your database dropped:

2021-02-16 9:41:46 140583578679040 [Warning] Aborted connection 9354116 to db: 'revtothe_phpb103' user: 'revtothe_phpb103' host: 'localhost' (Got an error reading communication packets) 2021-02-16 9:41:46 140582727898880 [Warning] Aborted connection 9354045 to db: 'revtothe_phpb103' user: 'revtothe_phpb103' host: 'localhost' (Got an error reading communication packets) 2021-02-16 9:41:46 140584283576064 [Warning] Aborted connection 9353868 to db: 'revtothe_phpb103' user: 'revtothe_phpb103' host: 'localhost' (Got an error reading communication packets)

It's back to normal, we will continue to monitor service status.