Error_occured & max database connections

Since this afternoon, my cscart adminpanel and storefront is not reachable. When visiting my homepage the message ‘Error_occured’ appears.

I have checked the config.local.php and everything is perfectly configured, I also haven’t changed theses configurations after the error appeared.

If I trie to login to my phpmyadmin at my hosting. I get the message ‘#1203 - User u47884_cart already has more than ‘max_user_connections’ active connections’.



I have called the company, and they said that a possible reason could be that connections to the database can’t be closed.



I hope someone could help me solve this problem.



Yours sincerely,





Michiel

Problem seems to be solved. The add-on 'Cron Jobs' from Alt-Team seems to be the problem for now. This addon caused 32 database backups/optimalisation today and 18 backups/optimalisation yesterday.

For the developer of this addon please set a maximum backup/optimalisation.





22-06-2013, 14:19


Database (backup)



22-06-2013, 14:10
-
Database (optimize)
-

22-06-2013, 14:10
-
Database (backup)
-

22-06-2013, 14:07
-
Database (optimize)
-

22-06-2013, 14:07
-
Database (backup)
-

22-06-2013, 13:22
-
Database (optimize)
-

22-06-2013, 13:22
-
Database (backup)
-

22-06-2013, 13:02
-
Database (optimize)
-

22-06-2013, 13:02
-
Database (backup)
-

22-06-2013, 11:33
-
Database (optimize)
-

22-06-2013, 11:33
-
Database (backup)
-

22-06-2013, 11:18
-
Database (optimize)
-

22-06-2013, 11:18
-
Database (backup)
-

22-06-2013, 01:05
-
Database (optimize)
-

22-06-2013, 01:05
-
Database (backup)
-

21-06-2013, 22:28
-
Database (optimize)
-

21-06-2013, 22:28
-
Database (backup)
-

21-06-2013, 22:27
-
Database (optimize)
-

21-06-2013, 22:27
-
Database (backup)
-

21-06-2013, 22:27
-
Database (optimize)
-

21-06-2013, 22:27
-
Database (backup)
-

21-06-2013, 14:49
-
Database (optimize)
-

21-06-2013, 14:49
-
Database (backup)
-

21-06-2013, 14:41
-
Database (optimize)
-

21-06-2013, 14:41
-
Database (backup)
-

21-06-2013, 14:03
-
Database (optimize)
-

21-06-2013, 14:03
-
Database (backup)
-

21-06-2013, 12:26
-
Database (backup)
-

21-06-2013, 12:22
-
Database (optimize)
-

21-06-2013, 12:22
-
Database (backup)
-

21-06-2013, 08:18
-
Database (optimize)
-

21-06-2013, 08:18
-
Database (backup)
-

20-06-2013, 22:40
-
Database (optimize)
-

20-06-2013, 22:40
-
Database (backup)
-

20-06-2013, 22:40
-
Database (optimize)
-

20-06-2013, 22:40
-
Database (backup)
-

20-06-2013, 21:21
-
Database (optimize)
-

20-06-2013, 21:21
-
Database (backup)
-

20-06-2013, 21:20
-
Database (optimize)
-

20-06-2013, 21:20
-
Database (backup)
-

20-06-2013, 21:06
-
Database (optimize)
-

20-06-2013, 21:06
-
Database (backup)
-

20-06-2013, 20:52
-
Database (optimize)
-

20-06-2013, 20:52
-
Database (backup)
-

20-06-2013, 20:50
-
Database (optimize)
-

20-06-2013, 20:50
-
Database (backup)
-

20-06-2013, 09:25
-
Database (optimize)
-

20-06-2013, 09:25
-
Database (backup)
-

20-06-2013, 09:24
-
Database (optimize)
-

20-06-2013, 09:24
-
Database (backup)
-

Facing same problem from last 4 months intermittently,

version is cs-cart 4.0.3 without any extra addon (third party addon )



Also noticed that cannot take database backup from cs-cart admin panel when all tables are selected - the backup is simply not completed.



But when table - cscart_logs is unselected the backup goes fine and is completed properly within 2 minutes



Any suggestion ?

Go to Administration/Logs and select the “clear logs” from the menu.

Alternatively you can use our EZ Admin Helper addon which will allow you to clear logs but preserve some number of days (default 30). It's just one of the nice features of this addon.

Thanks Tony



I have bought the EZ Admin Helper long ago but could not find enough time to install it .

Does the EZ Admin helper overwrite any default files ?



Also, do you believe the error #1203 could be due to big size of log file ?

[quote]Does the EZ Admin helper overwrite any default files ?[/quote]

No, it doesn't.


[quote]Also, do you believe the error #1203 could be due to big size of log file ?[/quote]

Doubtful… This would be caused by a (or several) processes retrying their connection to your database. If you're not, you should be using mysqli which will reuse DB connections that exist versus always getting a new one for each new page-load.