matrixorigin / matrixone

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

[Bug]: mo_user_defined_function has database #20262

Open daviszhen opened 15 hours ago

daviszhen commented 15 hours ago

Is there an existing issue for the same bug?

Branch Name

main

Commit ID

pr commit

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior


2024-11-21 08:22:00 INFO  ScriptParser:67 - The delimiter has been set to [;].
2024-11-21 08:22:00 INFO  Executor:37 - Start to execute the script file[/home/runner/work/matrixone/matrixone/head/test/distributed/cases/snapshot/snapshot_restore_system_table.sql] now, and it will take a few moment,pleas wait......
2024-11-21 08:22:03 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-11-21 08:22:03 ERROR RSSet:164 - The row count does not equal with each other, one is 2, the other is 0
2024-11-21 08:22:03 ERROR Executor:199 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/snapshot/snapshot_restore_system_table.sql][row:253][select name, db from mo_catalog.mo_user_defined_function;] was executed failed, con[id=1, user=acc01:test_account, ***
2024-11-21 08:22:03 ERROR Executor:201 - [EXPECT RESULT]:
name    db
helloworld    db1
helloworld5    db1
2024-11-21 08:22:03 ERROR Executor:202 - [ACTUAL RESULT]:
name    db
2024-11-21 08:22:05 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-11-21 08:22:06 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-11-21 08:22:07 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-11-21 08:22:07 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-11-21 08:22:07 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-11-21 08:22:07 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-11-21 08:22:07 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-11-21 08:22:07 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-11-21 08:22:07 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-11-21 08:22:07 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.

Expected Behavior

no error

Steps to Reproduce

https://github.com/matrixorigin/matrixone/actions/runs/11949006999/job/33307610057?pr=20062

Additional information

No response

YANGGMM commented 15 hours ago

与 #19867 一样,pr #https://github.com/matrixorigin/matrixone/pull/20187 刚合进去,麻烦再观察一下