Results 1 to 8 of 8

Hybrid View

  1. #1
    Join Date
    May 2009
    Posts
    186
    Plugin Contributions
    0

    Default Re: PHP Warning: MySQL user already has more than 'max_user_connections' active conne

    Update: So, I took DrByte's advice and started by looking at my raw access logs. I found for this 1 minute time period all were from the same IP. There was over 350 hits from that IP during the 1 minute. I'm not sure what that means. However, a little googling, etc and I found webmasters have been complaining about that IP for years. The IP is 4.79.204.xx which I have partially masked for privacy reasons. Please check your raw access logs and let me know if you have a similar finding.

    Quote Originally Posted by Zean View Post
    I too am on Blue Host and very recently upgraded to 1.5.4 and coincidentally threw over 50 identical PHP Warnings in less than 1 minute on July 2.

    PHP Warning: mysqli_connect(): (42000/1203): User xxxx_yyyy already has more than 'max_user_connections' active connections in /zzzz/xxxx/public_html/shop/includes/classes/db/mysql/query_factory.php on line 62

    So, Whitebear and Lat9, what have you found out?

    PS. I do not have any reason to suspect it is a 1.5.4 issue.

    Zen Cart v1.5.4
    No plugins
    Zen Cart installed via FTP and run zc_install
    Blue Host Shared Server Apache
    PHP Version: 5.2.17 (Zend: 2.2.0)
    MySQL 5.5.42-37.1-log

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,873
    Plugin Contributions
    96

    Default Re: PHP Warning: MySQL user already has more than 'max_user_connections' active conne

    Quote Originally Posted by Zean View Post
    Update: So, I took DrByte's advice and started by looking at my raw access logs. I found for this 1 minute time period all were from the same IP. There was over 350 hits from that IP during the 1 minute. I'm not sure what that means. However, a little googling, etc and I found webmasters have been complaining about that IP for years. The IP is 4.79.204.xx which I have partially masked for privacy reasons. Please check your raw access logs and let me know if you have a similar finding.
    @Zean, thanks for making me look, too! I've seen another similar PHP warning on a couple of sites:
    Code:
    PHP Warning:  mysqli_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
    At least on one site, the log occurs during a multitude of accesses by
    Code:
    Mozilla/5.0 (compatible; MJ12bot/v1.4.5; http://www.majestic12.co.uk/bot.php?+)
    .

  3. #3
    Join Date
    Jul 2012
    Posts
    16,816
    Plugin Contributions
    17

    Default Re: PHP Warning: MySQL user already has more than 'max_user_connections' active conne

    Unfortunately don't have the details immediately available, but also in the last week or two saw a similar issue on fatcow. Had 80+ similar messages. ZC 1.5.1.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

 

 

Similar Threads

  1. v154 Concurrent admin access / more than one simultaneous user
    By Haggis in forum Customization from the Admin
    Replies: 2
    Last Post: 1 May 2016, 09:38 PM
  2. Why have more than one admin user?
    By edwinlloyd in forum Basic Configuration
    Replies: 4
    Last Post: 26 Aug 2010, 11:00 AM
  3. How to set up different shipping options than what UPS has already?
    By bnieukirk in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 6 Sep 2009, 06:03 AM
  4. Replies: 0
    Last Post: 12 Nov 2008, 09:46 PM
  5. Customer bought more than the stock has, how?
    By yellow1912 in forum General Questions
    Replies: 3
    Last Post: 26 Jan 2007, 03:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg