一些语句在某些时刻出现dispatch error

🪐 TiDB 技术问题 性能调优
1

为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。

  • 【TiDB 版本】：v2.1
  • 【问题描述】：语句用到了索引，日志中发现了此类报错
schema:1146]Table 'observation.SELECT * FROM cloud_lightning_cimiss where 1=1  and data_time >= '2020-08-25 07:56:00.000000' and data_time <= '2020-08-25 08:04:49.000000'' doesn't exist
DESCRIBE `SELECT * FROM cloud_lightning_cimiss where 1=1  and data_time >= '2020-08-25 07:56:00.000000' and data_time <= '2020-08-25 08:04:49.000000'`
2020/08/25 16:06:09.308 conn.go:499: [warning] con:441319 dispatch error:
id:441319, addr:172.16.18.16:39995 status:1, collation:utf8_general_ci, user:tidbu4
"DESCRIBE `SELECT * FROM cloud_lightning_cimiss where 1=1  and data_time >= '2020-08-25 07:56:00.000000' and data_time <= '2020-08-25 08:04:49.000000'`"
[schema:1146]Table 'observation.SELECT * FROM cloud_lightning_cimiss where 1=1  and data_time >= '2020-08-25 07:56:00.000000' and data_time <= '2020-08-25 08:04:49.000000'' doesn't exist
github.com/pingcap/errors.AddStack
  /home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/errors@v0.11.0/errors.go:174
github.com/pingcap/parser/terror.(*Error).GenWithStackByArgs
  /home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190305073013-4f60445a0550/terror/terror.go:231
github.com/pingcap/tidb/infoschema.(*infoSchema).TableByName
  /home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/infoschema/infoschema.go:177
github.com/pingcap/tidb/planner/core.(*preprocessor).handleTableName
  /home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:584
github.com/pingcap/tidb/planner/core.(*preprocessor).Leave
  /home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:118
github.com/pingcap/parser/ast.(*TableName).Accept
  /home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190305073013-4f60445a0550/ast/dml.go:163
github.com/pingcap/parser/ast.(*ShowStmt).Accept
  /home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190305073013-4f60445a0550/ast/dml.go:1015
github.com/pingcap/parser/ast.(*ExplainStmt).Accept
  /home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190305073013-4f60445a0550/ast/misc.go:133
github.com/pingcap/tidb/planner/core.Preprocess
  /home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:35
github.com/pingcap/tidb/executor.(*Compiler).Compile
  /home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/compiler.go:44
github.com/pingcap/tidb/session.(*session).execute
  /home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/session/session.go:848
github.com/pingcap/tidb/session.(*session).Execute
  /home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/session/session.go:810
github.com/pingcap/tidb/server.(*TiDBContext).Execute
  /home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/driver_tidb.go:234
github.com/pingcap/tidb/server.(*clientConn).handleQuery
  /home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:881
github.com/pingcap/tidb/server.(*clientConn).dispatch
  /home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:628
github.com/pingcap/tidb/server.(*clientConn).Run
  /home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:481
github.com/pingcap/tidb/server.(*Server).onConn
  /home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/server.go:324
runtime.goexit
  /usr/local/go/src/runtime/asm_amd64.s:1333
2

提供下 tidb 版本，前端是否有什么报错，辛苦提供下

3

2.1

4

此信息呢？

上面的报错，请反馈下 sql_mode 情况

字段包含 0 这种非法数值

5

前端没有发现报错，sql modeimage
还有类似select o.temp as t2m, o.precip_1h as tp, o.weather_id as weather, o.wind_s_avg_10mi as wind_speed, o.wind_d_avg_10mi as wind_direction,
s.lon, s.lat, s.alti, s.station_id from observation_cimiss_cn o left join
station_info_cimiss_new s on o.station_id=s.station_id
where o.obs_time=‘2019-05-23 20:00:00’ and s.country_code=2250
也出现了此类报错

6

  1. 看报错展示的是 observation 是数据名吗？ 后面的一长串被解析为了表名？
    Table ‘observation.SELECT * FROM cloud_lightning_cimiss where 1=1 and data_time >= ‘2020-08-25 07:56:00.000000’ and data_time <= ‘2020-08-25 08:04:49.000000’’ doesn’t exist

  2. 是在执行什么命令时报的错，麻烦完整展示下，多谢。

  3. 如果是select 可以重新执行下，完整的日志发一下，多谢。

7

执行的就是SELECT * FROM cloud_lightning_cimiss where 1=1 and data_time >= ‘2020-08-25 07:56:00.000000’ and data_time <= ‘2020-08-25 08:04:49.000000这个语句，都是写的原生sql没有做拼接操作，log中显示的看上去很奇怪

8

您的是2.1-ga 的版本吗？ 看起来可能是一些 bug ，建议升级到高版本试一下，2.1.1 应该就修复过类似问题。

9

好的，谢谢

10

:handshake: