Additional Information: Got a packet bigger than ‘max_allowed_packet’ bytes worker[none:1225] exit with status 64000 Workerman[yii] has been stopped
1、查看日志，如下所示
#0 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/yiisoft/yii2/db/Command.php(1325): yii\db\Schema->convertException()
#1 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/yiisoft/yii2/db/Command.php(1120): yii\db\Command->internalExecute()
#2 /home/wwwroot/www.kuaihuiwu.com/object/src/console/controllers/ServiceController.php(150): yii\db\Command->execute()
#3 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/workerman/workerman/Events/Select.php(238): console\controllers\ServiceController->console\controllers\{closure}()
#4 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/workerman/workerman/Events/Select.php(299): Workerman\Events\Select->tick()
#5 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/workerman/workerman/Worker.php(1638): Workerman\Events\Select->loop()
#6 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/workerman/workerman/Worker.php(1429): Workerman\Worker::forkOneWorkerForLinux()
#7 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/workerman/workerman/Worker.php(1403): Workerman\Worker::forkWorkersForLinux()
#8 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/workerman/workerman/Worker.php(1788): Workerman\Worker::forkWorkers()
#9 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/workerman/workerman/Worker.php(1724): Workerman\Worker::monitorWorkersForLinux()
#10 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/workerman/workerman/Worker.php(562): Workerman\Worker::monitorWorkers()
#11 /home/wwwroot/www.kuaihuiwu.com/object/src/console/controllers/ServiceController.php(259): Workerman\Worker::runAll()
#12 [internal function]: console\controllers\ServiceController->actionIndex()
#13 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
#14 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
#15 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/yiisoft/yii2/console/Controller.php(180): yii\base\Controller->runAction()
#16 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/yiisoft/yii2/base/Module.php(552): yii\console\Controller->runAction()
#17 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction()
#18 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction()
#19 /home/wwwroot/www.kuaihuiwu.com/object/src/vendor/yiisoft/yii2/base/Application.php(384): yii\console\Application->handleRequest()
#20 /home/wwwroot/www.kuaihuiwu.com/object/src/yii(23): yii\base\Application->run()
#21 {main}
Additional Information:
Array
(
[0] => 08S01
[1] => 1153
[2] => Got a packet bigger than 'max_allowed_packet' bytes
)
worker[none:1225] exit with status 64000
Workerman[yii] has been stopped
2、查找到更为具体的报错原因，原因为 INSERT INTO 语句中一次性插入了 2000 多条记录。最多决定一次插入 200 条记录，问题得以解决。array_chunk($data, 200)，将一个数组分割成多个
Next yii\db\Exception: SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes
The SQL being executed was: INSERT INTO `phone_messages` (`id`, `company_id`, `business_type`, `business_id`, `task_id`, `pure_phone_number`, `phone_country_code`, `content`, `result`, `content_length`, `count`, `state`, `created_at`, `sent_at`, `receipted_at`) VALUES ('1812574085951145', '1812574083157189', '2', '1812574083157191', '1812574083385563', '13425230016', '86', '【快会务】尊敬的嘉宾：\n您好，Cleer新品发布会温馨提醒您，诚挚欢迎您参加戴上Cleer AI听新世界 Cleer新一代开放式AI耳机发布会。\n大会时间：2025-4-22 14:30\n大会地点：深圳国际低碳城气膜馆\n大会信息请查看链接：\nhttp://www.kuaihuiwu.com/convention/#/?id=1812574083157191\n期待您的光临！', '', 188, 3, 1, '2025-04-22 01:10:19', '2025-04-21 22:57:27', NULL), ('1812574085951146', '1812574083157189', '2', '1812574083157191', '1812574083385563', '13480260582', '86', '【快会务】尊敬的嘉宾：\n您好，Cleer新品发布会温馨提醒您，诚挚欢迎您参加戴上Cleer AI听新世界 Cleer新一代开放式AI耳机发布会。\n大会时间：2025-4-22 14:30\n大会地点：深圳国际低碳城气膜馆\n大会信息请查看链接：\nhttp://www.kuaihuiwu.com/convention/#/?id=1812574083157191\n期待您的光临！', '', 188, 3, 1, '2025-04-22 01:10:19', '2025-04-21 22:57:27', NULL), ('1812574085951147', '1812574083157189', '2', '1812574083157191', '1812574083385563', '13267320016', '86', '【快会务】尊敬的嘉宾：\n您好，Cleer新品发布会温馨提醒您，诚挚欢迎您参加戴上Cleer AI听新世界 Cleer新一代开放式AI耳机发布会。\n大会时间：2025-4-22 14:30\n大会地点：深圳国际低碳城气膜馆\n大会信息请查看链接：\nhttp://www.kuaihuiwu.com/convention/#/?id=1812574083157191\n期待您的光临！', '', 188, 3, 1, '2025-04-22 01:10:19', '2025-04-21 22:57:27', NULL), ('1812574085951148', '1812574083157189', '2', '1812574083157191', '1812574083385563', '17369416950', '86', '【快会务】尊敬的嘉宾：\n您好，Cleer新品发布会温馨提醒您，诚挚欢迎您参加戴上Cleer AI听新世界 Cleer新一代开放式AI耳机发布会。\n大会时间：2025-4-22 14:30\n大会地点：深圳国际低碳城气膜馆\n大会信息请查看链接：\nhttp://www.kuaihuiwu.com/convention/#/?id=1812574083157191\n期待您的光临！', '', 188, 3, 1, '2025-04-22 01:10:19', '2025-04-21 22:57:27', NULL),
近期评论