Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Error_occured & max database connections Rate Topic   - - - - -

 
  • MichielTG
  • Advanced Member
  • Members
  • Join Date: 17-Aug 12
  • 65 posts

Posted 22 June 2013 - 12:51 PM #1

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

 
  • MichielTG
  • Advanced Member
  • Members
  • Join Date: 17-Aug 12
  • 65 posts

Posted 22 June 2013 - 01:18 PM #2

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)
-

 
  • newuser
  • Member
  • Trial users
  • Join Date: 07-Dec 13
  • 47 posts

Posted 20 December 2014 - 04:11 PM #3

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 ?

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12001 posts

Posted 21 December 2014 - 10:49 AM #4

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.

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • newuser
  • Member
  • Trial users
  • Join Date: 07-Dec 13
  • 47 posts

Posted 23 December 2014 - 06:08 PM #5

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 ?

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12001 posts

Posted 23 December 2014 - 10:56 PM #6

Does the EZ Admin helper overwrite any default files ?

No, it doesn't.

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

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.

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.