ERROR MESSAGE

[atoamotos]

Hello everyone, i am having this problem. I will try to be as specific as possible in order to hopefully recieve as much help as i can:

 

I am currently experiencing a problem with my prestashop site www.atoamotos.com .Yesterday (1/17/16) i experienced the following error which has crashed my site entirely and displayed on a plain, blank screen:

 

Link to database cannot be established: SQLSTATE[HY000] [1203] User dbo659734916 already has more than 'max_user_connections' active connections

 

Neither the front or backoffice was availalbe, nor the MySQL database via myphpadmin

 

I reported the issue to my hosting provider, but they couldn't help me as the issue was gone by the time they checked it and could not reproduce it

 

In the morning i realized i had issues adding products; with the page taking too long to load (5min approx), sometimes loading successfully but most of the time returning the following error:

 

                       The page you are looking for is temporarily unavailable.

Please try again later. 

f56e4edf06d1bc33ad55f2d59e081464 067816e7431a49b33db71a51ca55ca45 f8e0dfdec0511345bee7fb3789b7bb3d

 

Even when the error message showed up, sometimes the item does get added, sometimes even twice.

 

On the "associations" tab, the following message is present:

 

Link to database cannot be established: SQLSTATE[HY000] [1203] User dbo659734916 already has more than 'max_user_connections' active connections

 

I also reported the issue to the hosting provider which did the following fix:

 

"We are processing a reboot in your package or killing mutliple processes running in it"

 

That fix did work for about 30 minutes, after which the product-adding error showed up again. Please note that the issue was only present when adding products, everything else on the site was working flawless.

 

After about an hour, the original error showed up again, which has crashed my site entirely (both front and backoffice) and displayed on a plain, blank screen:

 

Link to database cannot be established: SQLSTATE[HY000] [1203] User dbo659734916 already has more than 'max_user_connections' active connections

 

At this point i am going back and forth with my hosting company (1&1) and they're trying to detect if it is an issue on their side.

 

The max user connection limit on my plan is 18, and cannot be increased since it is a shared host. However i do not believe my website is that large or has that much traffic to be using the entire 18 connections.

 

One response i got from the hosting provider is "With regards to your concern, the issue is with regards to the database, it seems that you have exceeded the maximum number of user connections. Please be informed that to rectify/fix this, you would need to optimize you scripts."

 

What i do not understand is why this issue was caused. Everythging was working beyond perfect, as mentioned this started yesterday 1/17.

 

The last things we did before the error started showing up are:

 

* One employee was trying to import customers from a csv file, which resulted in an error as there were some repeated ID's

*Another was just adding products as usual.

 

Please help me out as this is causing a massive backlash on my business, as the page is absolutely necessary for us.

 

We have not modified any code on this prestashop installation, only the max_user_vars.

[Jignesh.aakoliya]

It tells you what the problem is on the first line - you have too many active connections to your MySQL database.

A quick google search gave the following suggestions:

In your php ini file you can increase MAX_USER_CONNECTIONS and MAX_CONNECTIONS

You also can check following Stackoverflow
http://stackoverflow.com/questions/4079531/mysqli-error-user-already-has-more-than-max-user-connections-active-connectio