search

matrixorigin / matrixone

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

[Bug]: `create database func_aggr_variance is failed.cause: ExpectedDup` #18998

Open daviszhen opened 5 days ago

daviszhen commented 5 days ago

Is there an existing issue for the same bug?

Branch Name

daviszhen:0924-fix-dashboard

Commit ID

lastest

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

2024-09-25T01:43:45.4036939Z 2024-09-25 01:43:45 INFO  Executor:37 - Start to execute the script file[/home/runner/work/matrixone/matrixone/head/test/distributed/cases/function/func_aggr_var_pop.test] now, and it will take a few moment,pleas wait......
2024-09-25T01:43:45.8852533Z 2024-09-25 01:43:45 INFO  Executor:291 - The script file[/home/runner/work/matrixone/matrixone/head/test/distributed/cases/function/func_aggr_var_pop.test] has been executed, and cost: 0.475s, total:125, success:125, failed:0, ignored:0, abnoraml:0
2024-09-25T01:43:45.8856298Z 2024-09-25 01:43:45 INFO  Executor:37 - Start to execute the script file[/home/runner/work/matrixone/matrixone/head/test/distributed/cases/function/func_aggr_variance.test] now, and it will take a few moment,pleas wait......
2024-09-25T01:43:45.8867410Z 2024-09-25 01:43:45 ERROR Executor:658 - create database func_aggr_variance is failed.cause: ExpectedDup
2024-09-25T01:43:45.8895211Z 2024-09-25 01:43:45 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/function/func_aggr_variance.test][row:5][create table t1(a tinyint, b SMALLINT, c BIGINT, d INT, e BIGINT, f FLOAT, g DOUBLE, h decimal(38,10), i DATE, k datetime, l TIMESTAMP, m char(255), n varchar(255));] was executed failed, con[id=0, user=dump, ***
2024-09-25T01:43:45.8897793Z 2024-09-25 01:43:45 ERROR Executor:271 - [EXPECT RESULT]:
2024-09-25T01:43:45.8898496Z null
2024-09-25T01:43:45.8899172Z 2024-09-25 01:43:45 ERROR Executor:272 - [ACTUAL RESULT]:
2024-09-25T01:43:45.8899900Z not connect to a database
2024-09-25T01:43:45.8902074Z 2024-09-25 01:43:45 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/function/func_aggr_variance.test][row:6][insert into t1 values(1, 1, 2, 43, 5, 35.5, 31.133, 14.314, "2012-03-10", "2012-03-12 10:03:12", "2022-03-12 13:03:12", "ab23c", "d5cf");] was executed failed, con[id=0, user=dump, ***
2024-09-25T01:43:45.8904613Z 2024-09-25 01:43:45 ERROR Executor:271 - [EXPECT RESULT]:
2024-09-25T01:43:45.8905495Z null
2024-09-25T01:43:45.8906184Z 2024-09-25 01:43:45 ERROR Executor:272 - [ACTUAL RESULT]:
2024-09-25T01:43:45.8906901Z no such table .t1
2024-09-25T01:43:45.8909879Z 2024-09-25 01:43:45 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/function/func_aggr_variance.test][row:7][insert into t1 values(71, 1, 2, 34, 5, 5.5, 341.13, 15.314, "2012-03-22", "2013-03-12 10:03:12", "2032-03-12 13:04:12", "abr23c", "3dcf");] was executed failed, con[id=0, user=dump, ***
2024-09-25T01:43:45.8913095Z 2024-09-25 01:43:45 ERROR Executor:271 - [EXPECT RESULT]:
2024-09-25T01:43:45.8913759Z null
2024-09-25T01:43:45.8914390Z 2024-09-25 01:43:45 ERROR Executor:272 - [ACTUAL RESULT]:
2024-09-25T01:43:45.8915071Z no such table .t1
2024-09-25T01:43:45.8918507Z 2024-09-25 01:43:45 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/function/func_aggr_variance.test][row:8][insert into t1 values(1, 1, 21, 4, 54, 53.5, 431.13, 14.394, "2011-03-12", "2015-03-12 10:03:12", "2002-03-12 13:03:12", "afbc", "dct5f");] was executed failed, con[id=0, user=dump, ***
2024-09-25T01:43:45.8921650Z 2024-09-25 01:43:45 ERROR Executor:271 - [EXPECT RESULT]:
2024-09-25T01:43:45.8922329Z null
2024-09-25T01:43:45.8922970Z 2024-09-25 01:43:45 ERROR Executor:272 - [ACTUAL RESULT]:
2024-09-25T01:43:45.8923631Z no such table .t1
2024-09-25T01:43:45.8927317Z 2024-09-25 01:43:45 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/function/func_aggr_variance.test][row:9][insert into t1 values(1, 71, 2, 34, 5, 5.5, 31.313, 124.314, "2012-01-12", "2019-03-12 10:03:12", "2013-03-12 13:03:12", "3abd1c", "dcvf");] was executed failed, con[id=0, user=dump, ***
2024-09-25T01:43:45.8929891Z 2024-09-25 01:43:45 ERROR Executor:271 - [EXPECT RESULT]:
2024-09-25T01:43:45.8930553Z null
2024-09-25T01:43:45.8931094Z 2024-09-25 01:43:45 ERROR Executor:272 - [ACTUAL RESULT]:
2024-09-25T01:43:45.8931812Z no such table .t1
2024-09-25T01:43:45.8934458Z 2024-09-25 01:43:45 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/function/func_aggr_variance.test][row:10][select variance(a) from t1;] was executed failed, con[id=0, user=dump, ***
2024-09-25T01:43:45.8936621Z 2024-09-25 01:43:45 ERROR Executor:271 - [EXPECT RESULT]:
2024-09-25T01:43:45.8937139Z variance(a)
2024-09-25T01:43:45.8937361Z 918.7500000000001
2024-09-25T01:43:45.8938041Z 2024-09-25 01:43:45 ERROR Executor:272 - [ACTUAL RESULT]:
2024-09-25T01:43:45.8938728Z not connect to a database
2024-09-25T01:43:45.8941149Z 2024-09-25 01:43:45 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/function/func_aggr_variance.test][row:11][select variance(b) from t1;] was executed failed, con[id=0, user=dump, ***
2024-09-25T01:43:45.8943984Z 2024-09-25 01:43:45 ERROR Executor:271 - [EXPECT RESULT]:
2024-09-25T01:43:45.8944681Z variance(b)
2024-09-25T01:43:45.8945072Z 918.75
2024-09-25T01:43:45.8945911Z 2024-09-25 01:43:45 ERROR Executor:272 - [ACTUAL RESULT]:
2024-09-25T01:43:45.8946641Z not connect to a database
2024-09-25T01:43:45.8948451Z 2024-09-25 01:43:45 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/function/func_aggr_variance.test][row:12][select variance(c) from t1;] was executed failed, con[id=0, user=dump, ***
2024-09-25T01:43:45.8949943Z 2024-09-25 01:43:45 ERROR Executor:271 - [EXPECT RESULT]:
2024-09-25T01:43:45.8950671Z variance(c)
2024-09-25T01:43:45.8953202Z 67.6875
2024-09-25T01:43:45.8953920Z 2024-09-25 01:43:45 ERROR Executor:272 - [ACTUAL RESULT]:
2024-09-25T01:43:45.8954539Z not connect to a database
2024-09-25T01:43:45.8957266Z 2024-09-25 01:43:45 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/function/func_aggr_variance.test][row:13][select variance(d) from t1;] was executed failed, con[id=0, user=dump, ***
2024-09-25T01:43:45.8959690Z 2024-09-25 01:43:45 ERROR Executor:271 - [EXPECT RESULT]:
2024-09-25T01:43:45.8960310Z variance(d)
2024-09-25T01:43:45.8960526Z 217.6875
2024-09-25T01:43:45.8960915Z 2024-09-25 01:43:45 ERROR Executor:272 - [ACTUAL RESULT]:
2024-09-25T01:43:45.8961329Z not connect to a database
2024-09-25T01:43:45.8968111Z 2024-09-25 01:43:45 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/function/func_aggr_variance.test][row:14][select variance(e) from t1;] was executed failed, con[id=0, user=dump, ***

Expected Behavior

no failure

Steps to Reproduce

https://github.com/matrixorigin/matrixone/actions/runs/11024581454/job/30617993765?pr=18973

Additional information

No response

ouyuanning commented 4 days ago

期间报错的日志如下：

{"level":"ERROR","time":"2024/09/25 01:43:45.888390 +0000","name":"cn-service","caller":"frontend/publication_subscription.go:1390","msg":"Get Subscription database  meta error: ExpectedEOB","service":"dd1dccb4-4d3c-41f8-b482-5251dc7a41bf","uuid":"dd1dccb4-4d3c-41f8-b482-5251dc7a41bf","session_info":"connectionId 403||account sys:dump|goRoutineId 0|migrate-goRoutineId 0|019226d5-5478-74a5-acf7-d98c1743f97a","role":"moadmin","session_id":"019226d5-5478-74a5-acf7-d98c1743f97a","statement_id":"019226d9-43df-77bb-ac27-344fdd812fb3","txn_id":"70f70f4866a9b62a17f8590ad97bb4f6","span":{"trace_id":"957029f9-2887-1ac4-1dd3-3f64f312927d","span_id":"f543ca61e0077284"}}
{"level":"ERROR","time":"2024/09/25 01:43:45.888441 +0000","caller":"frontend/publication_subscription.go:1391","msg":"error: not connect to a database","span":{"trace_id":"957029f9-2887-1ac4-1dd3-3f64f312927d","span_id":"f543ca61e0077284"}}
{"level":"ERROR","time":"2024/09/25 01:43:45.888461 +0000","name":"cn-service","caller":"frontend/txn.go:63","msg":"not connect to a database","service":"dd1dccb4-4d3c-41f8-b482-5251dc7a41bf","uuid":"dd1dccb4-4d3c-41f8-b482-5251dc7a41bf","session_info":"connectionId 403||account sys:dump|goRoutineId 0|migrate-goRoutineId 0|019226d5-5478-74a5-acf7-d98c1743f97a","role":"moadmin","session_id":"019226d5-5478-74a5-acf7-d98c1743f97a","statement_id":"019226d9-43df-77bb-ac27-344fdd812fb3","txn_id":"70f70f4866a9b62a17f8590ad97bb4f6","span":{"trace_id":"957029f9-2887-1ac4-1dd3-3f64f312927d","span_id":"f543ca61e0077284"}}