issue-20250701
【摘要】 [mppdb@ecs-8869-0009 gaussdb]$ cat txninfer2.log--java.lang.AssertionError: Transaction execution mismatches its oracle-- at dbmsforge.gaussdb.oracle.GaussDBTxInferOracle.check(GaussDBTxInferOracle...
[mppdb@ecs-8869-0009 gaussdb]$ cat txninfer2.log
--java.lang.AssertionError: Transaction execution mismatches its oracle
-- at dbmsforge.gaussdb.oracle.GaussDBTxInferOracle.check(GaussDBTxInferOracle.java:99)
-- at dbmsforge.common.DatabaseTestTask.runDatabaseTest(DatabaseTestTask.java:66)
-- at dbmsforge.common.DatabaseTestTask.run(DatabaseTestTask.java:34)
-- at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
-- at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
-- at java.base/java.lang.Thread.run(Thread.java:834)
---- Time: 2025/07/01 20:51:36
-- Database: txninfer2
============Bug Report============
CREATE TABLE t7 (c1 BIGSERIAL, c2 BIGSERIAL, c3 CHAR NULL, UNIQUE (c1, c2)) WITH (ORIENTATION=ROW) DISTRIBUTE BY REPLICATION;
CREATE TABLE t8 (c1 NVARCHAR2 (10), c2 CLOB, c3 CHAR, PRIMARY KEY (c1, c2)) WITH (ORIENTATION=ROW) DISTRIBUTE BY REPLICATION;
CREATE TABLE IF NOT EXISTS t10 (c1 DOUBLE PRECISION PRIMARY KEY) WITH (ORIENTATION=ROW) DISTRIBUTE BY REPLICATION;
INSERT INTO t10 (c1) VALUES (1.7749539659813057E307);
INSERT INTO t10 (c1) VALUES (-1.49419593947649E307), (-1.1226236251025774E308), (8.880589994007267E307);
INSERT INTO t8 (c1,c2,c3) VALUES ('tB','8','G');
INSERT INTO t10 (c1) VALUES (1.691462932751134E307);
INSERT INTO t10 (c1) VALUES (-1.6576978545904025E308);
INSERT INTO t10 (c1) VALUES (1.507951261153688E308);
INSERT INTO t10 (c1) VALUES (1.661512236512248E308);
INSERT INTO t7 (c1,c2,c3) VALUES (1,1,'p');
INSERT INTO t10 (c1) VALUES (-1.4927457956614954E308), (-1.1106386299645827E308);
INSERT INTO t8 (c1,c2,c3) VALUES ('cY','o','T');
INSERT INTO t10 (c1) VALUES (-1.1258485716058789E308);
INSERT INTO t10 (c1) VALUES (-6.793169629677613E307);
INSERT INTO t8 (c1,c2,c3) VALUES ('2q','q','E');
INSERT INTO t8 (c1,c2,c3) VALUES ('5SsEWNyu','1','V'), ('JWgY','Z','B'), ('stZt3vvq','l','7');
INSERT INTO t7 (c1,c2,c3) VALUES (2,2,'U');
INSERT INTO t7 (c1,c2,c3) VALUES (3,3,'s'), (4,4,'K');
INSERT INTO t7 (c1,c2,c3) VALUES (5,5,'2'), (6,6,'p');
INSERT INTO t7 (c1,c2,c3) VALUES (7,7,'c'), (8,8,'m');
INSERT INTO t8 (c1,c2,c3) VALUES ('Fylvjp1UF','0','Z');
INSERT INTO t7 (c1,c2,c3) VALUES (9,9,'H'), (10,10,'q'), (11,11,'G');
INSERT INTO t7 (c1,c2,c3) VALUES (12,12,'U');
CREATE UNIQUE INDEX IF NOT EXISTS i7 ON t7 USING btree (c1, c2);
CREATE UNIQUE INDEX IF NOT EXISTS i8 ON t10 USING btree (c1) WITH (INVISIBLE = OFF);
-- Transaction 18, with statements:
START TRANSACTION;
SELECT ALL c1 AS ca1 FROM ONLY t10 WHERE (8 BETWEEN -1.7025278602001456E38 AND ((-3.578247404829605E307) & (-1.5199027707700033E38)) / (round(c1, 1538590272))) LIMIT 953474229, 2298856484;
UPDATE ONLY t8 SET c3 = 'h' WHERE (((2) !) ! BETWEEN + (5) AND -1.5329353897673244E308);
UPDATE ONLY t7 SET c2 = 4667718252255215621, c3 = 'p' WHERE TRUE;
COMMIT;
-- Transaction 19, with statements:
BEGIN;
UPDATE ONLY t8 SET c2 = 'F9zEm8', c1 = 'fV70e4', c3 = 'D' WHERE (c3) LIKE (c3);
COMMIT WORK;
-- Transaction 20, with statements:
START TRANSACTION;
UPDATE t10 SET c1 = -8.65381142199752E307 WHERE (4) :: BOOLEAN;
DELETE FROM ONLY t8;
UPDATE ONLY t8 SET c1 = 'EcJ76rK' WHERE TRUE;
INSERT INTO t7 (c1,c2,c3) VALUES (16,16,'e');
ROLLBACK WORK;
-- Transaction 21, with statements:
BEGIN;
UPDATE t10 SET c1 = -1.6078586844459685E308 WHERE TRUE;
ROLLBACK;
-- Transaction 22, with statements:
BEGIN;
DELETE FROM ONLY t8;
DELETE FROM t8 WHERE (64) :: BOOLEAN;
DELETE FROM ONLY t10;
DELETE FROM t7 WHERE (13) :: BOOLEAN;
COMMIT;
Input schedule: [20-0, 20-1, 22-0, 22-1, 19-0, 18-0, 21-0, 18-1, 19-1, 19-2, 22-2, 20-2, 21-1, 21-2, 18-2, 18-3, 20-3, 22-3, 18-4, 20-4, 20-5, 22-4, 22-5]
Error: Inconsistent reporting error
19-1: UPDATE ONLY t8 SET c2 = 'F9zEm8', c1 = 'fV70e4', c3 = 'D' WHERE (c3) LIKE (c3)
Exec: null
Oracle: ERROR: dn_6002: duplicate key value violates unique constraint "t8_pkey"
Detail: Key (c1, c2)=(fV70e4, F9zEm8) already exists.
Execution Result:
Schedule: [20-0, 20-1: (Error): (Deadlock), 22-0, 22-1, 19-0, 18-0, 21-0, 18-1: (Error): (Deadlock), 19-1: (Blocked), 22-2, 21-1: (Error): (Deadlock), 22-3, 22-4, 22-5, 19-1, 19-2]
Isolation Level: READ_COMMITTED
Transaction Statement Results:
20-0: null
20-1: null
22-0: null
22-1: null
19-0: null
18-0: null
21-0: null
18-1: empty
19-1: null
22-2: null
21-1: null
22-3: null
22-4: null
22-5: null
19-1: null
19-2: null
DB Final State: [t10: empty t7: empty t8: empty ]
Oracle Result:
Schedule: [20-0, 20-1: (Error): (Deadlock), 22-0, 22-1, 19-0, 18-0, 21-0, 18-1: (Error): (Deadlock), 19-1: (Blocked): (Error): (Deadlock), 22-2, 21-1: (Error): (Deadlock), 22-3, 22-4, 22-5, 19-1, 19-2]
Isolation Level: READ_COMMITTED
Transaction Statement Results:
20-0: null
20-1: null
22-0: null
22-1: null
19-0: null
18-0: null
21-0: null
18-1: empty
19-1: null
22-2: null
21-1: null
22-3: null
22-4: null
22-5: null
19-1: null
19-2: null
DB Final State: [t10: empty t7: empty t8: empty ]
【声明】本内容来自华为云开发者社区博主，不代表华为云及华为云开发者社区的观点和立场。转载时必须标注文章的来源（华为云社区）、文章链接、文章作者等基本信息，否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容，欢迎发送邮件进行举报，并提供相关证据，一经查实，本社区将立刻删除涉嫌侵权内容，举报邮箱：
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论（0）