执行analyze table表整理命令后tidb服务oom再也启动不了了

看堆栈是已知bug,tidb can not restart after create global binding · Issue #40368 · pingcap/tidb · GitHub

可以先看看有没有partition table的binding

goroutine 1 [running]:
github.com/pingcap/tidb/executor.(*Compiler).Compile.func1()
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/compiler.go:72 +0x445
panic({0x4318e40, 0x6ec6870})
/usr/local/go/src/runtime/panic.go:884 +0x212
github.com/pingcap/tidb/statistics/handle.(*Handle).GetPartitionStats(0xc00011b400?, 0x4f8da00?, 0x4f72898?, {0x0?, 0xc001cdab70?, 0x18?})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/statistics/handle/handle.go:997 +0x2e
github.com/pingcap/tidb/statistics/handle.(*Handle).GetTableStats(...)
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/statistics/handle/handle.go:992
github.com/pingcap/tidb/planner/core.(*PlanBuilder).buildDataSource(0xc0072ff1e0, {0x4fafbb0, 0xc0062bbdd0}, 0xc0079f1ad0, 0xc008935d30)
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/logical_plan_builder.go:4456 +0x9ce
github.com/pingcap/tidb/planner/core.(*PlanBuilder).buildResultSetNode(0xc0072ff1e0, {0x4fafbb0?, 0xc0062bbdd0?}, {0x4fc96b0?, 0xc008935ce0?}, 0x0?)
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/logical_plan_builder.go:380 +0x19d
github.com/pingcap/tidb/planner/core.(*PlanBuilder).buildJoin(0xc00765af50?, {0x4fafbb0?, 0xc0062bbdd0?}, 0x0?)
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/logical_plan_builder.go:720 +0x71d
github.com/pingcap/tidb/planner/core.(*PlanBuilder).buildResultSetNode(0x0?, {0x4fafbb0?, 0xc0062bbdd0?}, {0x4fc8948?, 0xc002798870?}, 0x0?)
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/logical_plan_builder.go:367 +0x271
github.com/pingcap/tidb/planner/core.(*PlanBuilder).buildTableRefs(0xc0072ff1e0?, {0x4fafbb0?, 0xc0062bbdd0?}, 0x393cf94?)
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/logical_plan_builder.go:359 +0x85
github.com/pingcap/tidb/planner/core.(*PlanBuilder).buildSelect(0xc0072ff1e0, {0x4fafbb0, 0xc0062bbdd0}, 0xc00747d0e0)
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/logical_plan_builder.go:3916 +0x6c7
github.com/pingcap/tidb/planner/core.(*PlanBuilder).Build(0xc0072ff1e0, {0x4fafbb0, 0xc0062bbdd0}, {0x4fc4080?, 0xc00747d0e0?})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/planbuilder.go:804 +0x745
github.com/pingcap/tidb/planner.buildLogicalPlan({0x4fafbb0, 0xc0062bbdd0}, {0x501e818?, 0xc00011b400}, {0x4fc4080, 0xc00747d0e0}, 0xc0072ff1e0)
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/optimize.go:461 +0x12f
github.com/pingcap/tidb/planner.optimize({0x4fafbb0, 0xc0062bbdd0}, {0x501e818?, 0xc00011b400}, {0x4fc4080?, 0xc00747d0e0?}, {0x4fe5b50, 0xc0062bbe60})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/optimize.go:382 +0x473
github.com/pingcap/tidb/planner.Optimize({0x4fafbb0, 0xc0062bbdd0}, {0x501e818, 0xc00011b400}, {0x4fc4080, 0xc00747d0e0}, {0x4fe5b50, 0xc0062bbe60})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/optimize.go:245 +0xf11
github.com/pingcap/tidb/planner/core.(*PlanBuilder).buildExplain(0xc0072ff040, {0x4fafbb0, 0xc0062bbdd0}, 0xc008935dc0)
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/planbuilder.go:4783 +0xd9
github.com/pingcap/tidb/planner/core.(*PlanBuilder).Build(0xc0072ff040, {0x4fafbb0, 0xc0062bbdd0}, {0x4fc2c80?, 0xc008935dc0?})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/planbuilder.go:779 +0x432
github.com/pingcap/tidb/planner.buildLogicalPlan({0x4fafbb0, 0xc0062bbdd0}, {0x501e818?, 0xc00011b400}, {0x4fc2c80, 0xc008935dc0}, 0xc0072ff040)
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/optimize.go:461 +0x12f
github.com/pingcap/tidb/planner.optimize({0x4fafbb0, 0xc0062bbdd0}, {0x501e818?, 0xc00011b400}, {0x4fc2c80?, 0xc008935dc0?}, {0x4fe5b50, 0xc0062bbe60})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/optimize.go:382 +0x473
github.com/pingcap/tidb/planner.Optimize({0x4fafbb0, 0xc0062bbdd0}, {0x501e818, 0xc00011b400}, {0x4fc2c80, 0xc008935dc0}, {0x4fe5b50, 0xc0062bbe60})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/planner/optimize.go:245 +0xf11
github.com/pingcap/tidb/executor.(*Compiler).Compile(0xc00765cfc8, {0x4fafbb0, 0xc0062bbdd0}, {0x4fc8580, 0xc008935dc0?})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/compiler.go:116 +0x6f8
github.com/pingcap/tidb/session.(*session).ExecuteStmt(0xc00011b400, {0x4fafbb0, 0xc0062bbdd0}, {0x4fc8580?, 0xc008935dc0})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:2171 +0x54e
github.com/pingcap/tidb/session.(*session).ExecuteInternal(0xc00011b400, {0x4fafbb0, 0xc0062bbdd0}, {0xc0004e5100, 0x614}, {0x0, 0x0, 0x0})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:1674 +0x3f2
GitHub - pingcap/tidb: TiDB - the open-source, cloud-native, distributed SQL database designed for modern applications.bindinfo.getHintsForSQL({0x501e818, 0xc00011b400}, {0xc000495480, 0x5fe})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/bindinfo/handle.go:951 +0x177
github.com/pingcap/tidb/bindinfo.(*BindRecord).prepareHints(0xc007411100, {0x501e818, 0xc00011b400})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/bindinfo/bind_record.go:178 +0x1e7
github.com/pingcap/tidb/bindinfo.(*BindHandle).newBindRecord(0xc007303b00, {0xc0099e0140?, 0x40?})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/bindinfo/handle.go:723 +0xbcf
github.com/pingcap/tidb/bindinfo.(*BindHandle).Update(0xc007303b00, 0x1)
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/bindinfo/handle.go:173 +0x6c5
github.com/pingcap/tidb/domain.(*Domain).LoadBindInfoLoop(0xc000cdec00, {0x501e818, 0xc00011b400}, {0x501e818, 0xc000123b80})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/domain/domain.go:1444 +0xe5
github.com/pingcap/tidb/session.BootstrapSession({0x4fd95f0, 0xc000d1a960})
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:3301 +0x648
main.createStoreAndDomain()
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:314 +0x1cb
main.main()
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:214 +0x2ca

v6.5.1已经修复

3 个赞