What happens when you try to run:
Code:
/usr/bin/test -x /scripts/update_db_cache && /scripts/update_db_cache[email protected] [~]# /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.
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
Just a follow up on this. We have seen some client's servers kick out this error:
and we have fixed it by raising this value:
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.
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.
Code:
max_allowed_packet = 128M