tidb log：Data truncated for column '%s' at row %d

hanson · 2020 年8 月 27 日 07:22

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

【TiDB 版本】：v4.0.4
【问题描述】：

前天将集群从4.0.0升级至4.0.4，之前一直存在的报错：（从3.0.11升级至4.0.0后就一直存在这个报错）

Data truncated for column '%s' at row %d

仍然存在，不知道这个对集群到底有没有隐患？

来了老弟 · 2020 年8 月 27 日 09:11

辛苦提供下 display 结果

hanson · 2020 年8 月 27 日 10:17

不懂就问 · 2020 年8 月 28 日 02:54

确认下，这个报错在 4.0.4 版本还存在吗？另外报错数据是通过 DM 同步的吗？

hanson · 2020 年8 月 28 日 03:00

1、报错存在的

2、数据是通过DM同步

不懂就问 · 2020 年8 月 28 日 03:03

好的，麻烦提供下包含报错信息的 tidb.log，我们排查下。

hanson · 2020 年8 月 28 日 03:14

tidb.log.tar.gz (5.5 MB)

不懂就问 · 2020 年8 月 28 日 03:19

好的，正在内部排查，有结论及时同步。

tiancaiamao · 2020 年8 月 31 日 03:47

@hanson 你好，可以尝试改一下 TiDB 的配置文件的这里

[log]
# Enable annotating logs with the full stack error message, if not set, it will be defaulted to false.
# enable-error-stack = false

改成

enable-error-stack = true

然后看看日志里面的错误是从代码的哪个地方抛出来的。

tiancaiamao · 2020 年9 月 2 日 09:23

确认了打印 Error 的栈，这个不影响实际使用。@hanson
我们会把不必要的日志打印干掉 https://github.com/pingcap/tidb/pull/19707

[types:1265]Data truncated for column '%s' at row %d
github.com/pingcap/parser/terror.Log
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20200623164729-3a18f1e5dceb/terror/terror.go:363
github.com/pingcap/tidb/expression.(*builtinUnixTimestampCurrentSig).evalInt
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/expression/builtin_time.go:4763
github.com/pingcap/tidb/expression.(*ScalarFunction).EvalInt
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/expression/scalar_function.go:349
github.com/pingcap/tidb/expression.(*ScalarFunction).Eval
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/expression/scalar_function.go:316
github.com/pingcap/tidb/expression.foldConstant
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/expression/constant_fold.go:197
github.com/pingcap/tidb/expression.FoldConstant
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/expression/constant_fold.go:36
github.com/pingcap/tidb/expression.newFunctionImpl
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/expression/scalar_function.go:214
github.com/pingcap/tidb/expression.NewFunction
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/expression/scalar_function.go:221
github.com/pingcap/tidb/planner/core.(*expressionRewriter).newFunction
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/core/expression_rewriter.go:1041
github.com/pingcap/tidb/planner/core.(*expressionRewriter).funcCallToExpression
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/core/expression_rewriter.go:1540
github.com/pingcap/tidb/planner/core.(*expressionRewriter).Leave
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/core/expression_rewriter.go:933
github.com/pingcap/parser/ast.(*FuncCallExpr).Accept
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20200623164729-3a18f1e5dceb/ast/functions.go:499
github.com/pingcap/parser/ast.(*BinaryOperationExpr).Accept
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20200623164729-3a18f1e5dceb/ast/expressions.go:205
github.com/pingcap/parser/ast.(*ParenthesesExpr).Accept
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20200623164729-3a18f1e5dceb/ast/expressions.go:994
github.com/pingcap/parser/ast.(*BinaryOperationExpr).Accept
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20200623164729-3a18f1e5dceb/ast/expressions.go:211
github.com/pingcap/tidb/planner/core.(*PlanBuilder).rewriteExprNode
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/core/expression_rewriter.go:170
github.com/pingcap/tidb/planner/core.(*PlanBuilder).rewriteWithPreprocess
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/core/expression_rewriter.go:119
github.com/pingcap/tidb/planner/core.(*PlanBuilder).rewrite
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/core/expression_rewriter.go:87
github.com/pingcap/tidb/planner/core.(*PlanBuilder).buildSelection
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/core/logical_plan_builder.go:798
github.com/pingcap/tidb/planner/core.(*PlanBuilder).buildSelect
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/core/logical_plan_builder.go:2504
github.com/pingcap/tidb/planner/core.(*PlanBuilder).buildResultSetNode
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/core/logical_plan_builder.go:264
github.com/pingcap/tidb/planner/core.(*PlanBuilder).buildJoin
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/core/logical_plan_builder.go:582
github.com/pingcap/tidb/planner/core.(*PlanBuilder).buildResultSetNode
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/core/logical_plan_builder.go:259
github.com/pingcap/tidb/planner/core.(*PlanBuilder).buildSelect
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/core/logical_plan_builder.go:2457
github.com/pingcap/tidb/planner/core.(*PlanBuilder).Build
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/core/planbuilder.go:494
github.com/pingcap/tidb/planner.optimize
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/optimize.go:198
github.com/pingcap/tidb/planner.Optimize
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/planner/optimize.go:107
github.com/pingcap/tidb/executor.(*Compiler).Compile
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/executor/compiler.go:62
github.com/pingcap/tidb/session.(*session).execute
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/session/session.go:1129
github.com/pingcap/tidb/session.(*session).Execute
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/session/session.go:1081
github.com/pingcap/tidb/server.(*TiDBContext).Execute
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/server/driver_tidb.go:248
github.com/pingcap/tidb/server.(*clientConn).handleQuery
	/home/jenkins/agent/workspace/tidb_v4.0.4/go/src/github.com/pingcap/tidb/server/conn.go:1272

hanson · 2020 年9 月 2 日 09:49

好的，谢谢

来了老弟 · 2020 年9 月 2 日 11:38

system · 2022 年10 月 31 日 19:15

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。