php-reque:worker“MySQL服务器已经消失”
问题描述:
我开始使用php-resque(https://github.com/chrisboulton/php-resque)以及php和mysql服务器。我看到工作人员发现“MySQL服务器已经消失”的错误。php-reque:worker“MySQL服务器已经消失”
工作排队代码:
if ($request->command == 'custom_script') {
//error_log("before queue");
Resque::enqueue($queue, 'AsyncTest', array('text'=>'yolo'));
//error_log("after queue");
}
作业类:
class AsyncTest{
public function setUp() {
# Set up something before perform, like establishing a database connection
$mysql = Mysql::getInstance();
EH::setErrorHandler();
}
public function perform()
{
// $mysql = Mysql::getInstance();
// EH::setErrorHandler();
//error_log($this->args['text']);
$haiku_step_query= $mysql->query("SELECT id FROM haiku LIMIT 10 OFFSET 1");
$row = $mysql->fetch_assoc($haiku_step_query);
$haiku_id = $row['id'];
}
public function tearDown() {
# Run after perform, like closing resources
}
}
之我见 “MySQL服务器消失” 的错误消息:
MySQL ERROR №2006 MySQL server has gone away[qs:SELECT id FROM haiku LIMIT 10 OFFSET 1]
(/var/www/html/haiku_server/vendor/chrisboulton/php-resque/resque.php line 77
Resque_Worker->work(5) >> /var/www/html/haiku_server/vendor/chrisboulton/php-resque/lib/Resque/Worker.php line 199
Resque_Worker->perform(Object) >> /var/www/html/haiku_server/vendor/chrisboulton/php-resque/lib/Resque/Worker.php line 237
Resque_Job->perform() >> /var/www/html/haiku_server/vendor/chrisboulton/php-resque/lib/Resque/Job.php line 182
AsyncTest->perform() >> /var/www/html/haiku_server/includes/bgJobs/AsyncThreads.php line 48
Mysql->query("SELECT id FROM haiku LIMIT 10 OFFSET 1") >> /var/www/html/haiku_server/includes/Mysql.class.php line 113 )
请注意,这不发生,那是MySQL工作正常,当我做的操作无白皮书 - resque,如:
if ($request->command == 'custom_script') {
$mysql = Mysql::getInstance();
EH::setErrorHandler();
$haiku_step_query= $mysql->query("SELECT id FROM haiku LIMIT 10 OFFSET 1");
$row = $mysql->fetch_assoc($haiku_step_query);
$haiku_id = $row['id'];
}
答
看看这个问题: https://github.com/chrisboulton/php-resque/issues/269
一个可能的原因是,因为这项工作是第一次运行之后,你的对象将保持加载到内存中,包括你的MySQL连接。解决方案是在执行方法中重新连接到MySQL。
大声笑,这个线程有我与php-resque的开发人员之间的互动,他的解决方案确实解决了我的问题。所以,可能会接受你的答案。 –