mysql unexpected if_mysql出现一个很奇怪的错误

最新推荐文章于 2022-04-13 13:04:29 发布

生活分享家小瑞

最新推荐文章于 2022-04-13 13:04:29 发布

阅读量283

点赞数

文章标签： mysql unexpected if

本文链接：https://blog.csdn.net/weixin_42299728/article/details/113226184

版权

每次客户端连接后，第一次发送聊天信息，服务器那里执行插入就会出错，再发一次他就正常了。两次发送的信息都是一样的，除了时间。

错误如下：

用的GatewayWorker

INSERT INTO `xf_user_im` (`send_id`,`accept_id`,`sender`,`time`,`type`,`content`,`msg_time`) VALUES ('4','5','guwen','1467941111','txt','7','2016-07-08 09:25:09')exception 'PDOException' with message 'SQLSTATE: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.' in /home/socket/GatewayWorker/Lib/DbConnection.php:1720

Stack trace:

#0 /home/socket/GatewayWorker/Lib/DbConnection.php(1720): PDO->prepare('INSERT INTO `xf...')

#1 /home/socket/GatewayWorker/Lib/DbConnection.php(1808): GatewayWorker\Lib\DbConnection->execute('INSERT INTO `xf...', NULL)

#2 /home/socket/Applications/IM/Events.php(126): GatewayWorker\Lib\DbConnection->query('INSERT INTO `xf...')

#3 : Events::onMessage('7f0000010b54000...', '{"accept_id":"5...')

#4 /home/socket/GatewayWorker/BusinessWorker.php(360): call_user_func('Events::onMessa...', '7f0000010b54000...', '{"accept_id":"5...')

#5 : GatewayWorker\BusinessWorker->onGatewayMessage(Object(Workerman\Connection\AsyncTcpConnection), Array)

#6 /home/socket/Workerman/Connection/TcpConnection.php(422): call_user_func(Array, Object(Workerman\Connection\AsyncTcpConnection), Array)

#7 : Workerman\Connection\TcpConnection->baseRead(Resource id #38)

#8 /home/socket/Workerman/Events/Select.php(250): call_user_func_array(Array, Array)

#9 /home/socket/Workerman/Worker.php(1472): Workerman\Events\Select->loop()

#10 /home/socket/GatewayWorker/BusinessWorker.php(174): Workerman\Worker->run()