FATAL: mysql_stmt_execute() returned error 8028

salahgao · 2020 年7 月 8 日 08:12

【TiDB 版本】： 5.7.25-TiDB-v4.0.1

【问题描述】：
按照线上负载与 ADD INDEX 相互影响测试机型测试，同时执行oltp_read_write与add index：

sysbench oltp_read_write \
	--threads=16 \
	--time=300000 \
	--report-interval=2 \
	--rand-type=uniform \
	--rand-seed=0 \
	--db-driver=mysql \
	--mysql-db=sbtest \
	--mysql-host=10.5.74.58 \
	--mysql-port=3390 \
	--mysql-user=root \
	run --tables=1 --table-size=2000000

alter table sbtest1 add index c_idx(c);

错误如下：
FATAL: mysql_stmt_execute() returned error 8028 (Information schema is changed during the execution of the statement(for example, table definition may be updated by other DDL ran in parallel). If you see this error often, try increasing `tidb_max_delta_schema_count`. [try again later]) for query 'COMMIT'
FATAL: `thread_run' function failed: ./oltp_common.lua:409: SQL error, errno = 8028, state = 'HY000': Information schema is changed during the execution of the statement(for example, table definition may be updated by other DDL ran in parallel). If you see this error often, try increasing `tidb_max_delta_schema_count`. [try again later]
FATAL: mysql_stmt_execute() returned error 8028 (Information schema is changed during the execution of the statement(for example, table definition may be updated by other DDL ran in parallel). If you see this error often, try increasing `tidb_max_delta_schema_count`. [try again later]) for query 'COMMIT'
FATAL: `thread_run' function failed: ./oltp_common.lua:409: SQL error, errno = 8028, state = 'HY000': Information schema is changed during the execution of the statement(for example, table definition may be updated by other DDL ran in parallel). If you see this error often, try increasing `tidb_max_delta_schema_count`. [try again later]

set @@global.tidb_max_delta_schema_count = 5120; 后依然报错

yilong · 2020 年7 月 8 日 08:53

请问您的机器配置如何？
请上传 grafana 的 over-view tidb detail-tikv 监控
(1)、chrome 安装这个插件https://chrome.google.com/webstore/detail/full-page-screen-capture/fdpohaocaechififmbbbbbknoalclacl

(2)、鼠标焦点置于 Dashboard 上，按 ?可显示所有快捷键，先按 d 再按 E 可将所有 Rows 的 Panels 打开，需等待一段时间待页面加载完成。

(3)、使用这个 full-page-screen-capture 插件进行截屏保存

麻烦上传执行 add index 后一段时间的 tidb.log 日志，多谢。

salahgao · 2020 年7 月 10 日 07:14

机器配置
| IP | 服务 | 配置 |
|:-----------|:----------|:--------------|
| 10.5.74.51 | TiDB1 PD1 | 8C16G50GSSD |
| 10.5.74.52 | TiDB1 PD1 | 8C16G50GSSD |
| 10.5.74.53 | TiDB1 PD1 | 8C16G50GSSD |
| 10.5.74.54 | TiKV1 | 8C32G200GSSD |
| 10.5.74.55 | TiKV2 | 8C32G200GSSD |
| 10.5.74.56 | TiKV3 | 8C32G200GSSD |
| 10.5.74.57 | 监控 | 4C8G100GSSD |
| 10.5.74.58 | 测试客户端 | 16C16G100GSSD |