---
title: "会话空闲超时报错 | OceanBase 文档中心"
description: "会话空闲超时报错 本文为您介绍会话空闲超时的相关报错及处理方式。 报错：ERROR 2013 错误码 2013 错误信息 ERROR 2013 (HY000): Lost connection to MySQL server during query 示例 当前会话空闲超时后执行查看 t1 表的 SQL 语句报错。 …"
image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 3.1.4 社区版

# 会话空闲超时报错

更新时间：2023-08-03 17:20:32

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V3.1.4/zh-CN/1400.developer-guide/700.common-errors-and-solutions/300.timeout/100.session-idle-timeout-reporting-error.md)  

本文为您介绍会话空闲超时的相关报错及处理方式。

## 报错：ERROR 2013

### 错误码

2013

### 错误信息

```sql
ERROR 2013 (HY000): Lost connection to MySQL server during query

```

### 示例

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

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

```

### 如何处理

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

   ```sql
   +---------------------------------+------------------+
   | Variable_name                   | Value            |
   +---------------------------------+------------------+
   | connect_timeout                 | 10               |
   | default_password_lifetime       | 0                |
   | error_on_overlap_time           | OFF              |
   | explicit_defaults_for_timestamp | ON               |
   | interactive_timeout             | 1                |
   | 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_timestamp_service            | GTS              |
   | 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                    | 1                |
   +---------------------------------+------------------+
   21 rows in set

   ```
 2. 将 `wait_timeout` 参数设置为 `28800`。

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

   ```

   > **说明**
   >
   >  
   >
   > 服务器关闭交互式连接前等待活动的秒数。
 3. 将 `interactive_timeout` 参数设置为 `28800`。

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

   ```

   > **说明**
   >
   >  
   >
   > 服务器关闭非交互连接之前等待活动的秒数。
 4. 再次查看 `t1` 表。

   ```sql
   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

   ```

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线