Hi guys, i got on multiple instances of OC v4 strange error, based on max connections to database. I knew, it is a thing of shared hosting policies etc, but, there is probably some leak or underlying problem inside octobercms, that not close connections correctly in some circumstances.
im not able to find correct problem, because i think it is PDO based… but, i think there is problem with dashboard that may be a performance problem.
Hey @snipi
This is almost certainly related to your database configuration.
i.e Too many requests VS not enough available database connections.
150 for standard website is quite enough, right?
not sure, how there even can be that much connections.
only heavy load requests i can track down was related to dashboard
Same here. I’m running on the same host a heavy-loaded WP-instance without this issue. Only OCMS 4.2.x is throwing “max connections to database”
This is almost certainly not an OctoberCMS issue itself, and without being able to reproduce it we’d just be guessing at causes. You’ll need to dig on your end to find out what’s actually holding the connections open.
SHOW PROCESSLIST; while the error is happening is the best starting point - it’ll show you exactly which connections are stuck and where they’re coming from.