Results 1 to 5 of 5

Thread: Cron <root@srv> /usr/bin/test -x /scripts/update_db_cache && /scripts/update_db_cache

  1. #1
    Registered Member
    Join Date
    Feb 2005
    Posts
    13

    Question Cron <root@srv> /usr/bin/test -x /scripts/update_db_cache && /scripts/update_db_cache

    How to fix it?

    DBD::mysql::st execute failed: Lost connection to MySQL server during query at /scripts/update_db_cache line 48.
    DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /scripts/update_db_cache line 49.
    Regards,
    SulNet NetWorks
    http://www.sulnet.net

  2. #2
    Registered Member cPanel Partner NOC Badge WiredTree Joe's Avatar
    Join Date
    Dec 2006
    Location
    Chicago, IL
    Posts
    68

    Default

    Quote Originally Posted by sulnet View Post
    How to fix it?

    DBD::mysql::st execute failed: Lost connection to MySQL server during query at /scripts/update_db_cache line 48.
    DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /scripts/update_db_cache line 49.
    What happens when you try to run:

    Code:
    /usr/bin/test -x /scripts/update_db_cache && /scripts/update_db_cache
    manually via command line?
    Joe Doss
    www.wiredtree.com
    Fully Managed Dedicated Servers and VPS Hosting

  3. #3
    Registered Member
    Join Date
    Feb 2005
    Posts
    13

    Default

    root@srv [~]# /usr/bin/test -x /scripts/update_db_cache && /scripts/update_db_cache
    DBD::mysql::st execute failed: Lost connection to MySQL server during query at /scripts/update_db_cache line 48.
    DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /scripts/update_db_cache line 49.
    Regards,
    SulNet NetWorks
    http://www.sulnet.net

  4. #4
    Registered Member cPanel Partner NOC Badge WiredTree Joe's Avatar
    Join Date
    Dec 2006
    Location
    Chicago, IL
    Posts
    68

    Default

    Quote Originally Posted by sulnet View Post
    root@srv [~]# /usr/bin/test -x /scripts/update_db_cache && /scripts/update_db_cache
    DBD::mysql::st execute failed: Lost connection to MySQL server during query at /scripts/update_db_cache line 48.
    DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /scripts/update_db_cache line 49.
    Try raising any connection time outs in your /etc/my.cnf:

    interactive_timeout
    wait_timeout
    connect_timeout
    etc...

    save the changes and restart mysql and run the command again.

    MySQL :: MySQL 5.0 Reference Manual :: B.5.2.9 MySQL server has gone away
    Joe Doss
    www.wiredtree.com
    Fully Managed Dedicated Servers and VPS Hosting

  5. #5
    Registered Member cPanel Partner NOC Badge WiredTree Joe's Avatar
    Join Date
    Dec 2006
    Location
    Chicago, IL
    Posts
    68

    Default

    Just a follow up on this. We have seen some client's servers kick out this error:

    Code:
    Subject: Cron /usr/bin/test -x /scripts/update_db_cache && /scripts/update_db_cache
    
    DBD::mysql::st execute failed: Out of memory (Needed 4194756 bytes) at /scripts/update_db_cache line 48.
    DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /scripts/update_db_cache line 49.
    and we have fixed it by raising this value:

    Code:
    max_allowed_packet = 128M
    in /etc/my.cnf and restarting mySQL. Running /usr/bin/test -x /scripts/update_db_cache && /scripts/update_db_cache after the adjustment to mySQL caused it to run finish without issue.
    Joe Doss
    www.wiredtree.com
    Fully Managed Dedicated Servers and VPS Hosting

Similar Threads

  1. /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache
    By johnsap in forum Database Discussions
    Replies: 5
    Last Post: 08-13-2014, 11:21 AM
  2. Problem with /usr/local/cpanel/scripts/update_db_cache
    By ITGabs in forum cPanel & WHM Discussions
    Replies: 15
    Last Post: 07-24-2014, 05:49 PM
  3. Replies: 2
    Last Post: 08-31-2011, 08:58 AM
  4. server overload via cPanel cron /scripts/update_db_cache
    By 9xlinux in forum cPanel & WHM Discussions
    Replies: 2
    Last Post: 07-19-2010, 02:48 AM
  5. Replies: 2
    Last Post: 07-04-2007, 08:12 AM
bargain