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

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

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

前天将集群从4.0.0升级至4.0.4,之前一直存在的报错:(从3.0.11升级至4.0.0后就一直存在这个报错)

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

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

辛苦提供下 display 结果

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

1、报错存在的

2、数据是通过DM同步

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

tidb.log.tar.gz (5.5 MB)

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

@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

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

确认了打印 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

好的,谢谢

:call_me_hand:

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