会话空闲超时报错

当前会话空闲时间超过指定阈值时，系统将主动关闭当前连接，本文为您介绍会话空闲超时的相关报错及处理方式。

报错：ERROR 2013

错误码

2013

示例

当前会话空闲超时后执行查看 t1 表的 SQL 语句报错。

obclient>  SELECT * FROM t1;
ERROR 2013 (HY000): Lost connection to MySQL server during query

如何处理

1. 查看系统与时间相关的参数。

   obclient> SHOW VARIABLES LIKE '%time%';
   +---------------------------------+------------------+
   | Variable_name                   | Value            |
   +---------------------------------+------------------+
   | connect_timeout                 | 10               |
   | default_password_lifetime       | 0                |
   | error_on_overlap_time           | OFF              |
   | explicit_defaults_for_timestamp | ON               |
   | interactive_timeout             | 28800            |
   | lock_wait_timeout               | 31536000         |
   | long_query_time                 | 10               |
   | max_execution_time              | 0                |
   | net_read_timeout                | 30               |
   | net_write_timeout               | 60               |
   | ob_pl_block_timeout             | 3216672000000000 |
   | ob_query_timeout                | 10000000         |
   | ob_trx_idle_timeout             | 120000000        |
   | ob_trx_lock_timeout             | -1               |
   | ob_trx_timeout                  | 100000000        |
   | system_time_zone                | +08:00           |
   | timestamp                       | 0                |
   | time_format                     | %H:%i:%s         |
   | time_zone                       | +8:00            |
   | wait_timeout                    | 28800            |
   +---------------------------------+------------------+
   20 rows in set
   

2. 将 wait_timeout 参数设置为 28800。

   obclient>  set wait_timeout = 28800;
   Query OK, 0 rows affected
   

   说明

   服务器关闭交互式连接前等待活动的秒数。

3. 将 interactive_timeout 参数设置为 28800。

   obclient> set interactive_timeout = 28800;
   Query OK, 0 rows affected
   

   说明

   服务器关闭非交互连接之前等待活动的秒数。

4. 再次查看 t1 表。

   obclient> SELECT * FROM t1;
   +----+---------------------+---------------------+
   | id | gmt_create          | gmt_modified        |
   +----+---------------------+---------------------+
   |  1 | 2022-03-16 14:23:10 | 2022-03-16 14:23:10 |
   |  2 | 2022-03-16 14:23:10 | 2022-03-16 14:23:10 |
   |  3 | 2022-03-16 14:23:10 | 2022-03-16 14:23:10 |
   +----+---------------------+---------------------+
   3 rows in set