为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:v4.0.4
- 【问题描述】:
前天将集群从4.0.0升级至4.0.4,之前一直存在的报错:(从3.0.11升级至4.0.0后就一直存在这个报错)
Data truncated for column '%s' at row %d
仍然存在,不知道这个对集群到底有没有隐患?
为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
前天将集群从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,我们排查下。
好的,正在内部排查,有结论及时同步。
@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
好的,谢谢
此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。