之前咨询过 mysqltest 的问题,社区版提交pr 前自测与 mysqltest 测试问题
最新的mysqltest 目录中的测试案例,使用最新社区版OBD(1.5.0) 和 Oceanbase的代码(gitee commitid: 4ad6e00),执行case 大部分都 FAILED(Result (Total 163, Passed 45, Failed 118) ),貌似还是不可用状态?
例如,如下错误需要如何排查?./var/log/px_basic.log 中也只是部分SQL语句
[ RUN ]Running case: static_engine.px_basic ( 1 / 163 ) x
– local execute: obclient -h10.144.3.151 -P12881 -uroot -A -Doceanbase -e “select value from __all_virtual_sys_parameter_stat where name like ‘_enable_static_typing_engine’;” – exited code 0
– query engine result: value
True
True
True
– local execute: timeout 3600 /u01/obclient/bin/mysqltest --host=10.144.3.151 --port=12881 --tmpdir=./tmp --logdir=./var/log --silent --user=admin@mysql --password=admin --database=test --timer-file=./var/log/timer --test-file=./mysql_test/test_suite/static_engine/t/px_basic.test --tail-lines=20 --result-file=./mysql_test/test_suite/static_engine/r/mysql/px_basic.result
– exited code 1
mysqltest: At line 85: Version format 4 has not yet been implemented
The result from queries just before the failure was:
< snip >
insert into t5 values(4,4);
insert into t5 values(5,5);
insert into t5 values(6,6);
commit;
create table t1(c1 int,c2 int) partition by hash(c1) partitions 5;
create table t2(c1 int,c2 int) partition by hash(c2) partitions 6;
insert into t1 values(1,1);
insert into t1 values(2,2);
insert into t1 values(3,3);
insert into t1 values(4,4);
insert into t1 values(5,5);
insert into t1 values(6,6);
insert into t2 values(1,1);
insert into t2 values(2,2);
insert into t2 values(3,3);
insert into t2 values(4,4);
insert into t2 values(5,5);
insert into t2 values(6,6);
commit;
connection syscon;
More results from queries before failure can be found in ./var/log/px_basic.log
[ FAILED ]static_engine.px_basic peihan.dph ( 4.477835 s )