Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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

Discussion in 'General Discussion' started by sulnet, May 14, 2010.

  1. sulnet

    sulnet Member

    Joined:
    Feb 11, 2005
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    151
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. WiredTree Joe

    WiredTree Joe Well-Known Member

    Joined:
    Dec 13, 2006
    Messages:
    68
    Likes Received:
    1
    Trophy Points:
    158
    Location:
    Chicago, IL
    What happens when you try to run:

    Code:
    /usr/bin/test -x /scripts/update_db_cache && /scripts/update_db_cache
    manually via command line?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. sulnet

    sulnet Member

    Joined:
    Feb 11, 2005
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    151
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. WiredTree Joe

    WiredTree Joe Well-Known Member

    Joined:
    Dec 13, 2006
    Messages:
    68
    Likes Received:
    1
    Trophy Points:
    158
    Location:
    Chicago, IL
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. WiredTree Joe

    WiredTree Joe Well-Known Member

    Joined:
    Dec 13, 2006
    Messages:
    68
    Likes Received:
    1
    Trophy Points:
    158
    Location:
    Chicago, IL
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice