---
title: "服务器交互连接超时报错 | OceanBase 文档中心"
description: 服务器交互连接超时报错 当前会话空闲时间超过指定阈值时，系统将主动关闭当前连接，本文为您介绍会话空闲超时的相关报错及处理方式。 报错：ERROR 2013 错误码 2013 示例 当前会话空闲超时后执行查看 t1 表的 SQL 语句报错。 obclient> SELECT * FROM t1; ERROR-02013…
---
切换语言

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

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

# 服务器交互连接超时报错

更新时间：2026-04-25 13:33:43

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

## 报错：ERROR 2013

### 错误码

2013

### 示例

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

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

```

## 如何处理

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

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

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

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

   ```
 4. 再次查看 `t1` 表。

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

   ```

## 相关文档

- `wait_timeout` 参数的详细信息，请参见 [wait_timeout](https://www.oceanbase.com/docs/enterprise-oceanbase-database-cn-10000000000881252)。
 - `interactive_timeout` 参数的详细信息，请参见 [interactive_timeout](https://www.oceanbase.com/docs/enterprise-oceanbase-database-cn-10000000000880953)。

 上一篇 下一篇 ![有帮助](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) 咨询热线