没有明显的额外报错
[2023/08/02 19:25:55.342 +08:00] [ERROR] [adapter.go:148] ["execute sql panic"] [conn=2966429595181515201] [sql="SELECT `estimate_year_month`,\n`a_manager_yid`
AS `manager_yid`,\n`real_t1_volume`,\n`real_t0_volume`,\n`a_estimate_volume` + IFNULL(`b_estimate_volume`, 0) AS `estimate_volume`,
\nIFNULL(`a`.`increase_sum`, 0) + IFNULL(`b`.`increase_sum`, 0) AS `increase_sum`,\nIFNULL(`a`.`decrease_sum`, 0) + IFNULL(`b`.`decrease_sum`, 0) AS `decrease_sum`\nFROM (SE
LECT `estimate_year_month`,\n`manager_yid` AS `a_manager_yid`,\nSUM(`real_t1_volume`) AS `real_t1_volume`,\nSUM(`real_t0_volume`) AS `real_t0_volume`,\nSUM(`estim
ate_volume`) AS `a_estimate_volume`,\nSUM(IF(`estimate_volume` > `real_t1_volume`,`estimate_volume` - `real_t1_volume`,0)) AS `increase_sum`,\nSUM(IF(`estimate_v
olume` < `real_t1_volume`,`estimate_volume` - `real_t1_volume`,0)) AS `decrease_sum`\nFROM `rd_crm`.`signed_estimate_volume`\nWHERE `estimate_year_month` = DATE_
FORMAT(NOW(), _UTF8MB4'%Y%m')\nAND `is_dropped` = 0\nAND `data_type` = 1\nGROUP BY `manager_yid`) AS `a`\nLEFT JOIN (SELECT `manager_yid` AS `b_manager_yid`,\nSUM(`
estimate_volume`) AS `b_estimate_volume`,\nSUM(`estimate_volume`) AS `increase_sum`,\n0 AS `decrease_sum`\nFROM `rd_crm`.`unsigned_estimate_volume`\nWHE
RE `estimate_year_month` = DATE_FORMAT(NOW(), '%Y%m')\nAND `is_dropped` = 0\nAND `data_type` = 1\nGROUP BY `manager_yid`) AS `b`\nON a.`a_manager_yid` = b.`b_manager_yid`"]
[stack="github.com/pingcap/tidb/executor.(*recordSet).Next.func1\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:148\nruntim
e.gopanic\n\t/usr/local/go/src/runtime/panic.go:884\nruntime.goPanicIndex\n\t/usr/local/go/src/runtime/panic.go:113\ngithub.com/pingcap/tidb/util/chunk.(*Column).IsNull\n\t/
home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/chunk/column.go:169\ngithub.com/pingcap/tidb/expression.(*builtinIfNullIntSig).vecEvalInt\n\t/h
ome/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/builtin_control_vec_generated.go:846\ngithub.com/pingcap/tidb/expression.(*ScalarFunction)
.VecEvalInt\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/scalar_function.go:48\ngithub.com/pingcap/tidb/expression.(*builtinCastIn
tAsDecimalSig).vecEvalDecimal\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/builtin_cast_vec.go:1081\ngithub.com/pingcap/tidb/expre
ssion.(*ScalarFunction).VecEvalDecimal\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/scalar_function.go:63\ngithub.com/pingcap/tidb
/expression.(*builtinArithmeticPlusDecimalSig).vecEvalDecimal\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/builtin_arithmetic_vec.
go:994\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalDecimal\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/scalar_fu
nction.go:63\ngithub.com/pingcap/tidb/expression.evalOneVec\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/chunk_executor.go:163\ngi
thub.com/pingcap/tidb/expression.(*defaultEvaluator).run\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/evaluator.go:53\ngithub.com/
pingcap/tidb/expression.(*EvaluatorSuite).Run\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/evaluator.go:125\ngithub.com/pingcap/ti
db/executor.(*ProjectionExec).unParallelExecute\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/projection.go:205\ngithub.com/pingcap/t
idb/executor.(*ProjectionExec).Next\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/projection.go:183\ngithub.com/pingcap/tidb/executor
.Next\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/executor.go:326\ngithub.com/pingcap/tidb/executor.(*ExecStmt).next\n\t/home/jenki
ns/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:1202\ngithub.com/pingcap/tidb/executor.(*recordSet).Next\n\t/home/jenkins/agent/workspace/
build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:151\ngithub.com/pingcap/tidb/server.(*tidbResultSet).Next\n\t/home/jenkins/agent/workspace/build-common/go/sr
c/github.com/pingcap/tidb/server/driver_tidb.go:469\ngithub.com/pingcap/tidb/server.(*clientConn).writeChunks\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com
/pingcap/tidb/server/conn.go:2313\ngithub.com/pingcap/tidb/server.(*clientConn).writeResultSet\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/s
erver/conn.go:2256\ngithub.com/pingcap/tidb/server.(*clientConn).handleStmt\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:2124\
ngithub.com/pingcap/tidb/server.(*clientConn).handleQuery\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1885\ngithub.com/pingca
p/tidb/server.(*clientConn).dispatch\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1372\ngithub.com/pingcap/tidb/server.(*clien
tConn).Run\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1153\ngithub.com/pingcap/tidb/server.(*Server).onConn\n\t/home/jenkins
/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/server.go:677"]
[2023/08/02 19:25:55.343 +08:00] [INFO] [conn.go:1184] ["command dispatched failed"] [conn=2966429595181515201] [connInfo="id:2966429595181515201, addr:127.0.0.1:25170 statu
s:10, collation:utf8_general_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="SELECT `estimate_year_month`,\n`a_manager_yid` AS `manager_yid`,\n`real_t1_volume`,\n`real_t0_volume`,\n`a_estimate_volume` + IFNULL(`b_estimate_volume`, 0) AS `estimate_volume`,\nIFNULL(`a`.`increase_sum`, 0) + IFNULL(`b`.`increase_sum`, 0) AS `increase_sum`,\nIFNULL(`a`.`decrease_sum`, 0) + IFNULL(`b`.`decrease_sum`, 0) AS `decrease_sum`\nFROM (SELECT `estimate_year_month`,\n`manager_yid` AS `a_manager_yid`,\nSUM(`real_t1_volume`) AS `real_t1_volume`,\nSUM(`real_t0_volume`) AS `real_t0_volume`,\nSUM(`estimate_volume`) AS `a_estimate_volume`,\nSUM(IF(`estimate_volume` > `real_t1_volume`,`estimate_volume` - `real_t1_volume`,0)) AS `increase_sum`,\nSUM(IF(`estimate_volume` < `real_t1_volume`,`estimate_volume` - `real_t1_volume`,0)) AS `decrease_sum`\nFROM `rd_crm`.`signed_estimate_volume`\nWHERE `estimate_year_month` = DATE_FORMAT(NOW(), _UTF8MB4'%Y%m')\nAND `is_dropped` = 0\nAND `data_type` = 1\nGROUP BY `manager_yid`) AS `a`\nLEFT JOIN (SELECT `manager_yid` AS `b_manager_yid`,\nSUM(`estimate_volume`) AS `b_estimate_volume`,\nSUM(`estimate_volume`) AS `increase_sum`,\n0 AS `decrease_sum`\nFROM `rd_crm`.`unsigned_estimate_volume`\nWHERE `estimate_year_month` = DATE_FORMAT(NOW(), '%Y%m')\nAND `is_dropped` = 0\nAND `data_type` = 1\nGROUP BY `manager_yid`) AS `b`\nON a.`a_manager_yid` = b.`b_manager_yid`"] [txn_mode=PESSIMISTIC] [timestamp=443279095937105953] [err="runtime error: index out of range [0] with length 0\ngithub.com/pingcap/tidb/executor.(*recordSet).Next.func1\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:147\nruntime.gopanic\n\t/usr/local/go/src/runtime/panic.go:884\nruntime.goPanicIndex\n\t/usr/local/go/src/runtime/panic.go:113\ngithub.com/pingcap/tidb/util/chunk.(*Column).IsNull\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/chunk/column.go:169\ngithub.com/pingcap/tidb/expression.(*builtinIfNullIntSig).vecEvalInt\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/builtin_control_vec_generated.go:846\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalInt\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/scalar_function.go:48\ngithub.com/pingcap/tidb/expression.(*builtinCastIntAsDecimalSig).vecEvalDecimal\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/builtin_cast_vec.go:1081\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalDecimal\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/scalar_function.go:63\ngithub.com/pingcap/tidb/expression.(*builtinArithmeticPlusDecimalSig).vecEvalDecimal\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/builtin_arithmetic_vec.go:994\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalDecimal\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/scalar_function.go:63\ngithub.com/pingcap/tidb/expression.evalOneVec\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/chunk_executor.go:163\ngithub.com/pingcap/tidb/expression.(*defaultEvaluator).run\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/evaluator.go:53\ngithub.com/pingcap/tidb/expression.(*EvaluatorSuite).Run\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/expression/evaluator.go:125\ngithub.com/pingcap/tidb/executor.(*ProjectionExec).unParallelExecute\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/projection.go:205\ngithub.com/pingcap/tidb/executor.(*ProjectionExec).Next\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/projection.go:183\ngithub.com/pingcap/tidb/executor.Next\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/executor.go:326\ngithub.com/pingcap/tidb/executor.(*ExecStmt).next\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:1202\ngithub.com/pingcap/tidb/executor.(*recordSet).Next\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:151\ngithub.com/pingcap/tidb/server.(*tidbResultSet).Next\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/driver_tidb.go:469\ngithub.com/pingcap/tidb/server.(*clientConn).writeChunks\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:2313\ngithub.com/pingcap/tidb/server.(*clientConn).writeResultSet\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:2256\ngithub.com/pingcap/tidb/server.(*clientConn).handleStmt\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:2124\ngithub.com/pingcap/tidb/server.(*clientConn).handleQuery\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1885\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1372\ngithub.com/pingcap/tidb/server.(*clientConn).Run\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1153\ngithub.com/pingcap/tidb/server.(*Server).onConn\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/server.go:677\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1598"]