在jenkins中Fullsync 超时

[jd-zhang]

Issue migrated from trac ticket # 834

component: kunlun-storage | priority: major

2022-06-17 15:17:14: vito@zettadb.com created the issue

---

sql code:

create table selfconflict (f1 int primary key, f2 int);

begin transaction isolation level read committed;
insert into selfconflict values (1,1), (1,2) on conflict do nothing;
commit;

begin transaction isolation level read committed;
insert into selfconflict values (4,1), (4,2) on conflict(f1) do update set f2 = 0;
commit;

< psql:sql/insert_conflict.sql:379: WARNING:  Error(2600) doing 1st phase prepare of transaction 1-1655416846-2816, will abort it.
< psql:sql/insert_conflict.sql:379: ERROR:  Kunlun-db: MySQL storage node (1, 1) returned error: 9000, Fullsync in thread 57 timed out running command COM_QUERY: '<unknown query>', got 0 ACKs..
< ERROR:  Kunlun-db: MySQL storage node (1, 1) returned error: 1397, XAER_NOTA: Unknown XID.

http://192.168.0.104:8080/job/enterprise_centos_dailytest_oneshard_rbr/96/consoleText
输入insert_conflict.sql到指定位置

[jd-zhang]

2022-06-17 16:16:50: vito@zettadb.com changed component from computing nodes to kunlun-storage

[jd-zhang]

2022-06-17 16:57:32: vito@zettadb.com changed owner from smith to snow