Closed (fixed)
Project:
Bot
Version:
5.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
13 Aug 2007 at 22:59 UTC
Updated:
12 Nov 2007 at 22:41 UTC
I'm getting this in terminal after running the bot_start... Any ideas?
PS. the bot "works", and is irc yet I imagine these issues are bad.
PHP Warning: MySQL server has gone away
query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>MySQL server has gone away\nquery: SELECT * FROM variable</em> in <em>/home/noob/public_html/includes/database.mysqli.inc</em> on line <em>151</em>.', 2, '', 'http://example.org//bot_start.php', '', '', 1187045526) in /home/noob/public_html/includes/database.mysqli.inc on line 151
Comments
Comment #1
czarphanguye commentedNote; this seems to match my.conf's
wait_timeout. If set to 30seconds and no one speaks to the bot in 30seconds the db connection is lost. is this right?Comment #2
morbus iffYes, that would be correct. You should either a) increase the timeout to something like 2 minutes, then b) run your cron.php every 1 minute (the bot.module ships with a keepalive that is triggered via cron), or add it to more active rooms ;)
Comment #3
czarphanguye commentedI dunno, w/ a one minute crontab and mysql time'out set to 180 the bot still times out a little after 3 minutes. Cron reports success every (single) minute to the watchdog.
Comment #4
morbus iffThis was fixed in a recent commit - we're now setting the wait_timeout in the bot_start.php ourselves.
Comment #5
(not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.