René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"2006 mysql server has gone away","articleBody":"2006 mysql server has gone away\r\n===============================\r\n\r\n### 场景\r\n\r\nphp `yii` 框架，一个 `console` 任务，执行的时候，报 `2006 mysql server has gone away` 错误.\r\n\r\n\r\n### 方案\r\n\r\n导致报错的原因是，这个 `console` 任务处理的数据太多，大量的错误测试数据发送到 `mysql`，超出了包大小的限制.\r\n\r\n```php\r\n...\r\n$task-\u003estatus = TaskModel::STATUS_FAIL;\r\n$task-\u003emessage = json_encode($object-\u003eerrors);\r\n$task-\u003esave();\r\nreturn self::DELETE;\r\n...\r\n```\r\n\r\n上面的 `$task-\u003emessage = json_encode($object-\u003eerrors);` 文本内容过大，导致 `save()` 之后，超出了 `mysql` 限制的大小，  \r\n从而导致 `2006 mysql server has gone away`.\r\n\r\n查看 `mysql` `max_allowed_packet` 的大小：\r\n```\r\nazoya_product_system\u003e show variables like '%max_allowed_packet%';\r\n+--------------------------+------------+\r\n| Variable_name            | Value      |\r\n+--------------------------+------------+\r\n| max_allowed_packet       | 16777216   |\r\n| slave_max_allowed_packet | 1073741824 |\r\n+--------------------------+------------+\r\n```\r\n\r\n修改 `max_allowed_packet` 的大小\r\n```\r\nazoya_product_system\u003e set global max_allowed_packet = 1073741824;\r\n```\r\n\r\n修改之后，退出 `mysql`，重新登录即可.\r\n\r\n\r\n或者，限制 `$object-\u003eerros` 的大小\r\n```\r\nif (count($object-\u003eerros) \u003e 50) {\r\n    $object-\u003eerros = array_slice($object-\u003eerros, 0, 50);\r\n}\r\n```\r\n","author":{"url":"https://github.com/codcodog","@type":"Person","name":"codcodog"},"datePublished":"2021-12-14T13:23:44.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/131/Blog/issues/131"}