Thread: Instant Search

Page 23 of 23 FirstFirst ... 13212223
Results 221 to 222 of 222
  1. #221
    Join Date
    Sep 2013
    Devon, UK
    Plugin Contributions

    Default Re: Instant Search

    Using Zen Cart 1.58a and PHP 8.1 I have occasionally seen huge numbers of the following error logged, usually within the space of 1 or 2 seconds:

    PHP Warning: mysqli_connect(): (42000/1203): User saabcom_zencart already has more than 'max_user_connections' active connections in /home/saabcom/ on line 76.
    When this happens, of course the user sees nddbc.html ("problem connecting to our database") and can't do anything.

    Sometimes there is more information showing which function was trying to access the database but it varies and I'm not sure any of them are relevant. It looks like something is hitting the database really hard and locking everything else out. I have the Typesense plug-in installed and I'm not sure if that is the culprit or not. I wondered if the full-sync was doing it since we have about 18,000 products and that's a fair amount of data to look up. However, last night's episode was at 00:42 while the last full-sync was at 05:45. Full-sync is set to run every 12 hours.

  2. #222
    Join Date
    Aug 2007
    Gijón, Asturias, Spain
    Plugin Contributions

    Default Re: Instant Search

    >more than 'max_user_connections' active connections

    I also get this error occasionally. The raw access logs show a legitimate IP.
    my max_user_connections is 25, set by the hosting.

    I was until recently on a over-specified VPS, but I'd set this to 25 for a long time, as a test, with no occurrences, so reverted to shared hosting. Now I've had a couple of cases in the last two weeks.

    Steve Spanish Language Pack, Google reCaptcha, Structured Data, Multiple Copy-Move-Delete, Image Checker, BackupMySQL Admin/Auto...


Page 23 of 23 FirstFirst ... 13212223

Similar Threads

  1. Instant Quote
    By Congerman in forum General Questions
    Replies: 2
    Last Post: 15 Aug 2012, 12:29 PM
  2. Instant Coupon
    By Mickmo68 in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 4
    Last Post: 22 Dec 2008, 08:19 PM
  3. Instant Delivery?
    By eaglewu in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 30 Jul 2007, 09:30 AM
  4. changes instant
    By chufty bill in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 5 Sep 2006, 07:12 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Zen-Cart, Internet Selling Services, Klamath Falls, OR