Sudden Fatal Errors

[Nikki72]

All of a sudden today i've been getting this fatal error message as shown in the screenshot (I've abscured database name for security) attached.

I've contacted my host and they say:

You've got a number of processes in the sleep state:-

l 19186060 database_oc1 localhost database_ccshop Sleep 5 --- ---

Kill 19186061 database_oc1 localhost database_ccshop Sleep 4 --- ---

Kill 19186062 database_oc1 localhost database_ccshop Sleep 4 --- ---

Kill 19186063 database_oc1 localhost database_ccshop Sleep 5 --- ---

Kill 19186064 database_oc1 localhost database_ccshop Sleep 5 --- ---

Kill 19186066 database_oc1 localhost database_ccshop Sleep 5 --- ---

Kill 19186069 database_oc1 localhost database_ccshop Sleep 5 --- ---

Kill 19186070 database_oc1 localhost database_ccshop Sleep 5 --- ---

Kill 19186071 database_oc1 localhost database_ccshop Sleep 4 --- ---

Kill 19186072 database_oc1 localhost database_ccshop Sleep 5 --- ---

Kill 19186078 database_oc1 localhost database_ccshop Sleep 5 --- ---

Kill 19186081 database_oc1 localhost database_ccshop Sleep 4 --- ---

Kill 19186086 database_oc1 localhost database_ccshop Sleep 3 --- ---

Kill 19186088 database_oc1 localhost database_ccshop Sleep 4 --- ---

Kill 19186089 database_oc1 localhost database_ccshop Sleep 4 --- ---

Kill 19186093 database_oc1 localhost database_ccshop Sleep 3 --- ---

Kill 19186094 database_oc1 localhost database_ccshop Sleep 3 --- ---

Kill 19186095 database_oc1 localhost database_ccshop Sleep 3 --- ---

Kill 19186096 database_oc1 localhost database_ccshop Sleep 3 --- ---

Kill 19186101 database_oc1 localhost database_ccshop Sleep 3 --- ---

Kill 19186102 database_oc1 localhost database_ccshop Sleep 3 --- ---

Kill 19186105 database_oc1 localhost database_ccshop Sleep 3 --- ---

Kill 19186108 database_oc1 localhost database_ccshop Sleep 3 --- ---

Kill 19186110 database_oc1 localhost database_ccshop Sleep 3 --- ---

It sounds like your script is opening but not closing the connections.

[bsmither]

I think this looks familiar enough - the Sleep # indicates the query 'session' that an application opened. But PHP, when it finishes what it needs to do (such as processing data then building a web page with that data), and begins to go to shutdown, closes any database connection.

For PHP to not automatically close a connection when shutting down, I would ask if PHP is instead crashing, and even when that happens, closing database connections almost always happens.

So, in addition to the log entries you've shown us, you should also ask the hosting provider to activate normal query logging. Then report back to you with that log. The query log will show who opened the session and what queries were executed for that session.

In addition to knowing that you are running CC514, what mods, if any, have you installed?

Does database_oc1 and database_ccshop mean anything to you?

And this is after clearing out the image cache? I am confident that these two events are 0% related.

[Nikki72]

Thanks so much for your reply. Devillion should give you a job as it seems you're the only person to ever offer support!

I am running a third party banner module but other than a custom skin thats all and everything has been fine for the last month.

Does database_oc1 and database_ccshop mean anything to you?

ccshop is the shop database and oc1 is the database user.

I've passed your comments over to my hosting support and i'll post back when i have a reply.

Many thanks again :D

[Nikki72]

It appears to be down to the banner module with my host saying it's not closing connections properly. I've disabled that and everyting seems to be fine for now. Fingers crossed but i'll keep an eye on it and see if it continues with that disabled or not.

Thanks again for taking the time to reply. You really are a cubecart angel lol :wub: