search

matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.79k stars 276 forks source link

[Bug]: data race detected during bvt #6853

Closed sukki37 closed 1 year ago

sukki37 commented 1 year ago

Is there an existing issue for the same bug?

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93): b13440ebc66471642119070c503f652960f14610
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

2022/11/22 12:51:42.940054 +0000 DEBUG dn-service morpc/server.go:178 received request {"uuid": "dd4dccb4-4d3c-41f8-b482-5251dc7a41bf", "name": "txn-server", "sequence": 31249, "client": "127.0.0.1:40106", "request-id": 31249, "request": "31249: <a8f16644789f4c12a620d3f7f3882db3/Active/S:1669121502927014512-0>/Read/F-0/<O:1000-D:441>/=><2-262146-0-127.0.0.1:22000>"}
2022/11/22 12:51:42.940196 +0000 DEBUG dn-service util/log.go:96 txn handle request {"uuid": "dd4dccb4-4d3c-41f8-b482-5251dc7a41bf", "dn-shard": "2-262146-1-127.0.0.1:22000", "dn-shard": "2-262146-1-127.0.0.1:22000", "dn-shard": "2-262146-1-127.0.0.1:22000", "txn-id": "a8f16644789f4c12a620d3f7f3882db3", "request": "31249: <a8f16644789f4c12a620d3f7f3882db3/Active/S:1669121502927014512-0>/Read/F-0/<O:1000-D:441>/=><2-262146-0-127.0.0.1:22000>"}
2022/11/22 12:51:42.940711 +0000 DEBUG logtail/handle.go:58 [Logtail] begin handle {CnHave:PhysicalTime:1669121502833890299 NodeID:33571  CnWant:PhysicalTime:1669121502927014512 NodeID:33571  Table:db_id:1 tb_id:2  XXX_NoUnkeyedLiteral:{} XXX_unrecognized:[] XXX_sizecache:0}
==================
WARNING: DATA RACE
Write at 0x00c04beefd30 by goroutine 19:
  github.com/matrixorigin/matrixone/pkg/util/trace.(*StatementInfo).Free()
      /home/runner/work/matrixone/matrixone/head/pkg/util/trace/report_statement.go:84 +0xc4
  github.com/matrixorigin/matrixone/pkg/util/trace.(*buffer2Sql).Reset()
      /home/runner/work/matrixone/matrixone/head/pkg/util/trace/buffer_pipe.go:280 +0x189
  github.com/matrixorigin/matrixone/pkg/util/export.(*bufferHolder).FlushAndReset()
      /home/runner/work/matrixone/matrixone/head/pkg/util/export/batch_processor.go:151 +0x233
  github.com/matrixorigin/matrixone/pkg/util/export.(*MOCollector).handleBatch()
      /home/runner/work/matrixone/matrixone/head/pkg/util/export/batch_processor.go:366 +0x30
  github.com/matrixorigin/matrixone/pkg/util/export.(*MOCollector).doExport()
      /home/runner/work/matrixone/matrixone/head/pkg/util/export/batch_processor.go:345 +0x10e
  github.com/matrixorigin/matrixone/pkg/util/export.(*MOCollector).Start.func5()
      /home/runner/work/matrixone/matrixone/head/pkg/util/export/batch_processor.go:267 +0x47

Previous read at 0x00c04beefd30 by goroutine 2948:
  github.com/matrixorigin/matrixone/pkg/frontend.logStatementStatus()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/util.go:479 +0x86
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3649 +0x4b84
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*BackgroundHandler).Exec()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/session.go:1930 +0x1ad
  github.com/matrixorigin/matrixone/pkg/frontend.doDropAccount()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/authenticate.go:1960 +0xe76
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).handleDropAccount()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:1954 +0x52
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3267 +0x2149
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).ExecRequest()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3823 +0x1131
  github.com/matrixorigin/matrixone/pkg/frontend.(*Routine).Loop()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:160 +0x7e4
  github.com/matrixorigin/matrixone/pkg/sql/plan/function/builtin/unary.Cot()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/function/builtin/unary/math.go:79 +0x51
  github.com/matrixorigin/matrixone/pkg/sql/plan/function.Function.VecFn()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/function/function.go:160 +0x6d
  github.com/matrixorigin/matrixone/pkg/sql/colexec.EvalExpr()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/colexec/expr_eval.go:177 +0xe93
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).constantFold()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:91 +0x3be
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).Apply()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:67 +0x516
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).exploreNode()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:76 +0x202
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:62 +0xfc
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).Optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:54 +0xe4
  github.com/matrixorigin/matrixone/pkg/frontend.buildPlan()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2357 +0x52e
  github.com/matrixorigin/matrixone/pkg/frontend.(*TxnComputationWrapper).Compile()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2180 +0x1c4
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3335 +0x279c
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).ExecRequest()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3823 +0x1131
  github.com/matrixorigin/matrixone/pkg/frontend.(*Routine).Loop()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:160 +0x7e4
  github.com/matrixorigin/matrixone/pkg/sql/plan/function.Function.VecFn()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/function/function.go:160 +0x6d
  github.com/matrixorigin/matrixone/pkg/sql/colexec.EvalExpr()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/colexec/expr_eval.go:177 +0xe93
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).constantFold()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:91 +0x3be
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).Apply()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:67 +0x516
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).exploreNode()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:76 +0x202
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:62 +0xfc
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).Optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:54 +0xe4
  github.com/matrixorigin/matrixone/pkg/frontend.buildPlan()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2357 +0x52e
  github.com/matrixorigin/matrixone/pkg/frontend.(*TxnComputationWrapper).Compile()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2180 +0x1c4
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3335 +0x279c
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).ExecRequest()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3823 +0x1131
  github.com/matrixorigin/matrixone/pkg/frontend.(*Routine).Loop()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:160 +0x7e4
  github.com/matrixorigin/matrixone/pkg/sql/plan/function.Function.VecFn()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/function/function.go:160 +0x6d
  github.com/matrixorigin/matrixone/pkg/sql/colexec.EvalExpr()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/colexec/expr_eval.go:177 +0xe93
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).constantFold()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:91 +0x3be
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).Apply()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:67 +0x516
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).exploreNode()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:76 +0x202
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:62 +0xfc
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).Optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:54 +0xe4
  github.com/matrixorigin/matrixone/pkg/frontend.buildPlan()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2357 +0x52e
  github.com/matrixorigin/matrixone/pkg/frontend.(*TxnComputationWrapper).Compile()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2180 +0x1c4
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3335 +0x279c
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).ExecRequest()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3823 +0x1131
  github.com/matrixorigin/matrixone/pkg/frontend.(*Routine).Loop()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:160 +0x7e4
  github.com/matrixorigin/matrixone/pkg/sql/plan/function.Function.VecFn()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/function/function.go:160 +0x6d
  github.com/matrixorigin/matrixone/pkg/sql/colexec.EvalExpr()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/colexec/expr_eval.go:177 +0xe93
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).constantFold()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:91 +0x3be
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).Apply()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:67 +0x516
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).exploreNode()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:76 +0x202
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:62 +0xfc
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).Optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:54 +0xe4
  github.com/matrixorigin/matrixone/pkg/frontend.buildPlan()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2357 +0x52e
  github.com/matrixorigin/matrixone/pkg/frontend.(*TxnComputationWrapper).Compile()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2180 +0x1c4
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3335 +0x279c
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).ExecRequest()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3823 +0x1131
  github.com/matrixorigin/matrixone/pkg/frontend.(*Routine).Loop()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:160 +0x7e4
  github.com/matrixorigin/matrixone/pkg/sql/plan/function.Function.VecFn()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/function/function.go:160 +0x6d
  github.com/matrixorigin/matrixone/pkg/sql/colexec.EvalExpr()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/colexec/expr_eval.go:177 +0xe93
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).constantFold()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:91 +0x3be
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).Apply()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:67 +0x516
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).exploreNode()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:76 +0x202
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:62 +0xfc
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).Optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:54 +0xe4
  github.com/matrixorigin/matrixone/pkg/frontend.buildPlan()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2357 +0x52e
  github.com/matrixorigin/matrixone/pkg/frontend.(*TxnComputationWrapper).Compile()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2180 +0x1c4
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3335 +0x279c
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).ExecRequest()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3823 +0x1131
  github.com/matrixorigin/matrixone/pkg/frontend.(*Routine).Loop()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:160 +0x7e4
  github.com/matrixorigin/matrixone/pkg/sql/plan/function.Function.VecFn()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/function/function.go:160 +0x6d
  github.com/matrixorigin/matrixone/pkg/sql/colexec.EvalExpr()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/colexec/expr_eval.go:177 +0xe93
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).constantFold()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:91 +0x3be
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).Apply()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:67 +0x516
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).exploreNode()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:76 +0x202
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:62 +0xfc
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).Optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:54 +0xe4
  github.com/matrixorigin/matrixone/pkg/frontend.buildPlan()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2357 +0x52e
  github.com/matrixorigin/matrixone/pkg/frontend.(*TxnComputationWrapper).Compile()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2180 +0x1c4
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3335 +0x279c
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).ExecRequest()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3823 +0x1131
  github.com/matrixorigin/matrixone/pkg/frontend.(*Routine).Loop()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:160 +0x7e4
  github.com/matrixorigin/matrixone/pkg/sql/plan/function.Function.VecFn()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/function/function.go:160 +0x6d
  github.com/matrixorigin/matrixone/pkg/sql/colexec.EvalExpr()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/colexec/expr_eval.go:177 +0xe93
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).constantFold()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:91 +0x3be
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).Apply()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:67 +0x516
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).exploreNode()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:76 +0x202
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:62 +0xfc
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).Optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:54 +0xe4
  github.com/matrixorigin/matrixone/pkg/frontend.buildPlan()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2357 +0x52e
  github.com/matrixorigin/matrixone/pkg/frontend.(*TxnComputationWrapper).Compile()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2180 +0x1c4
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3335 +0x279c
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).ExecRequest()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3823 +0x1131
  github.com/matrixorigin/matrixone/pkg/frontend.(*Routine).Loop()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:160 +0x7e4
  github.com/matrixorigin/matrixone/pkg/sql/plan/function.Function.VecFn()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/function/function.go:160 +0x6d
  github.com/matrixorigin/matrixone/pkg/sql/colexec.EvalExpr()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/colexec/expr_eval.go:177 +0xe93
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).constantFold()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:91 +0x3be
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).Apply()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:67 +0x516
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).exploreNode()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:76 +0x202
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:62 +0xfc
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).Optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:54 +0xe4
  github.com/matrixorigin/matrixone/pkg/frontend.buildPlan()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2357 +0x52e
  github.com/matrixorigin/matrixone/pkg/frontend.(*TxnComputationWrapper).Compile()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2180 +0x1c4
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3335 +0x279c
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).ExecRequest()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3823 +0x1131
  github.com/matrixorigin/matrixone/pkg/frontend.(*Routine).Loop()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:160 +0x7e4
  github.com/matrixorigin/matrixone/pkg/sql/plan/function.Function.VecFn()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/function/function.go:160 +0x6d
  github.com/matrixorigin/matrixone/pkg/sql/colexec.EvalExpr()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/colexec/expr_eval.go:177 +0xe93
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).constantFold()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:91 +0x3be
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).Apply()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:67 +0x516
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).exploreNode()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:76 +0x202
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:62 +0xfc
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).Optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:54 +0xe4
  github.com/matrixorigin/matrixone/pkg/frontend.buildPlan()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2357 +0x52e
  github.com/matrixorigin/matrixone/pkg/frontend.(*TxnComputationWrapper).Compile()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2180 +0x1c4
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3335 +0x279c
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).ExecRequest()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3823 +0x1131
  github.com/matrixorigin/matrixone/pkg/frontend.(*Routine).Loop()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:160 +0x7e4
  github.com/matrixorigin/matrixone/pkg/sql/plan/function.Function.VecFn()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/function/function.go:160 +0x6d
  github.com/matrixorigin/matrixone/pkg/sql/colexec.EvalExpr()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/colexec/expr_eval.go:177 +0xe93
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).constantFold()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:91 +0x3be
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).Apply()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:67 +0x516
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).exploreNode()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:76 +0x202
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:62 +0xfc
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).Optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:54 +0xe4
  github.com/matrixorigin/matrixone/pkg/frontend.buildPlan()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2357 +0x52e
  github.com/matrixorigin/matrixone/pkg/frontend.(*TxnComputationWrapper).Compile()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2180 +0x1c4
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3335 +0x279c
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).ExecRequest()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3823 +0x1131
  github.com/matrixorigin/matrixone/pkg/frontend.(*Routine).Loop()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:160 +0x7e4
  github.com/matrixorigin/matrixone/pkg/sql/plan/function.Function.VecFn()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/function/function.go:160 +0x6d
  github.com/matrixorigin/matrixone/pkg/sql/colexec.EvalExpr()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/colexec/expr_eval.go:177 +0xe93
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).constantFold()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:91 +0x3be
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).Apply()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:67 +0x516
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).exploreNode()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:76 +0x202
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:62 +0xfc
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).Optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:54 +0xe4
  github.com/matrixorigin/matrixone/pkg/frontend.buildPlan()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2357 +0x52e
  github.com/matrixorigin/matrixone/pkg/frontend.(*TxnComputationWrapper).Compile()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2180 +0x1c4
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3335 +0x279c
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).ExecRequest()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3823 +0x1131
  github.com/matrixorigin/matrixone/pkg/frontend.(*Routine).Loop()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:160 +0x7e4
  github.com/matrixorigin/matrixone/pkg/sql/plan/function.Function.VecFn()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/function/function.go:160 +0x6d
  github.com/matrixorigin/matrixone/pkg/sql/colexec.EvalExpr()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/colexec/expr_eval.go:177 +0xe93
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).constantFold()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:91 +0x3be
  github.com/matrixorigin/matrixone/pkg/sql/plan/rule.(*ConstantFold).Apply()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/rule/constant_fold.go:67 +0x516
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).exploreNode()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:76 +0x202
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:62 +0xfc
  github.com/matrixorigin/matrixone/pkg/sql/plan.(*BaseOptimizer).Optimize()
      /home/runner/work/matrixone/matrixone/head/pkg/sql/plan/optimize.go:54 +0xe4
  github.com/matrixorigin/matrixone/pkg/frontend.buildPlan()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2357 +0x52e
  github.com/matrixorigin/matrixone/pkg/frontend.(*TxnComputationWrapper).Compile()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:2180 +0x1c4
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3335 +0x279c
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).doComQuery-fm()
      <autogenerated>:1 +0x6d
  github.com/matrixorigin/matrixone/pkg/frontend.(*MysqlCmdExecutor).ExecRequest()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/mysql_cmd_executor.go:3823 +0x1131
  github.com/matrixorigin/matrixone/pkg/frontend.(*Routine).Loop()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:160 +0x7e4
  github.com/matrixorigin/matrixone/pkg/frontend.NewRoutine.func1()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:232 +0x58

Goroutine 19 (running) created at:
  github.com/matrixorigin/matrixone/pkg/util/export.(*MOCollector).Start()
      /home/runner/work/matrixone/matrixone/head/pkg/util/export/batch_processor.go:267 +0x424
  github.com/matrixorigin/matrixone/pkg/util/trace.initExporter()
      /home/runner/work/matrixone/matrixone/head/pkg/util/trace/trace.go:123 +0xef6
  github.com/matrixorigin/matrixone/pkg/util/trace.Init()
      /home/runner/work/matrixone/matrixone/head/pkg/util/trace/trace.go:83 +0x5ce
  main.initTraceMetric.func1()
      /home/runner/work/matrixone/matrixone/head/cmd/mo-service/main.go:276 +0x707
  github.com/matrixorigin/matrixone/pkg/common/stopper.(*Stopper).doRunCancelableTask.func1()
      /home/runner/work/matrixone/matrixone/head/pkg/common/stopper/stopper.go:258 +0xd1

Goroutine 2948 (running) created at:
  github.com/matrixorigin/matrixone/pkg/frontend.NewRoutine()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine.go:232 +0x2d4
  github.com/matrixorigin/matrixone/pkg/frontend.(*RoutineManager).Created()
      /home/runner/work/matrixone/matrixone/head/pkg/frontend/routine_manager.go:92 +0x284
  github.com/fagongzi/goetty/v2.NewIOSession()
      /home/runner/go/pkg/mod/github.com/fagongzi/goetty/v2@v2.0.3-0.20221121133015-81355a910e4a/session.go:231 +0x334
  github.com/fagongzi/goetty/v2.(*server).doStart.func2()
      /home/runner/go/pkg/mod/github.com/fagongzi/goetty/v2@v2.0.3-0.20221121133015-81355a910e4a/application.go:324 +0x4c9
  github.com/fagongzi/goetty/v2.(*server).doStart.func3()
      /home/runner/go/pkg/mod/github.com/fagongzi/goetty/v2@v2.0.3-0.20221121133015-81355a910e4a/application.go:353 +0x58
==================
2022/11/22 12:51:42.957753 +0000 DEBUG cn-service morpc/backend.go:431 write request {"uuid": "dd1dccb4-4d3c-41f8-b482-5251dc7a41bf", "remote": "127.0.0.1:22000", "backend-id": "1e721c44-706b-4463-9655-a50543f32b2c", "request-id": 189076, "request": "189076: <d93b83d0ce364c759ea88b9e1062a566/Active/S:1669121502939238806-0>/Read/F-0/<O:1000-D:441>/=><2-262146-0-127.0.0.1:22000>"}

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

xzxiong commented 1 year ago

fixed