服务器交互连接超时报错

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

报错：ERROR 2013

错误码

2013

示例

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

obclient>  SELECT * FROM t1;
ERROR-02013: Lost connection to MySQL server during query

如何处理

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

   obclient [USER001]> 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             | 10                           |
   | net_read_timeout                | 30                           |
   | net_write_timeout               | 60                           |
   | nls_timestamp_format            | DD-MON-RR HH.MI.SSXFF AM     |
   | nls_timestamp_tz_format         | DD-MON-RR HH.MI.SSXFF AM TZR |
   | ob_pl_block_timeout             | 3216672000000000             |
   | ob_query_timeout                | 10000000                     |
   | ob_trx_idle_timeout             | 86400000000                  |
   | ob_trx_lock_timeout             | -1                           |
   | ob_trx_timeout                  | 86400000000                  |
   | system_time_zone                | +08:00                       |
   | time_zone                       | +8:00                        |
   | timestamp                       | 0                            |
   | wait_timeout                    | 10                           |
   +---------------------------------+------------------------------+
   18 rows in set
   

2. 将 wait_timeout 参数设置为 28800。

   obclient [USER001]> set wait_timeout = 28800;
   ERROR-02006: MySQL server has gone away
   No connection. Trying to reconnect...
   Connection id:    3221613831
   Current database: USER001
   
   Query OK, 0 rows affected
   

3. 将 interactive_timeout 参数设置为 28800。

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

4. 再次查看 t1 表。

   obclient [USER001]> SELECT * FROM t1;
   +------+------+
   | C1   | C2   |
   +------+------+
   |    1 |   11 |
   |    2 |   22 |
   +------+------+
   2 rows in set
   

相关文档

• wait_timeout 参数的详细信息，请参见 wait_timeout。

• interactive_timeout 参数的详细信息，请参见 interactive_timeout。