issue-20251024
【摘要】 cat txinfer9.log--java.lang.AssertionError: Transaction execution mismatches its oracle-- at dbmsforge.gaussdb.oracle.GaussDBTxInferOracle.check(GaussDBTxInferOracle.java:119)-- at dbmsforge.common...
cat txinfer9.log
--java.lang.AssertionError: Transaction execution mismatches its oracle
-- at dbmsforge.gaussdb.oracle.GaussDBTxInferOracle.check(GaussDBTxInferOracle.java:119)
-- at dbmsforge.common.DatabaseTestTask.runDatabaseTest(DatabaseTestTask.java:70)
-- at dbmsforge.common.DatabaseTestTask.run(DatabaseTestTask.java:38)
-- 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:829)
---- Time: 2025/10/24 12:00:01
-- Database: txinfer9
============Bug Report============
CREATE TABLE IF NOT EXISTS t54 (c1 SMALLINT NULL, UNIQUE (c1)) WITH (ORIENTATION=ROW) DISTRIBUTE BY REPLICATION;
CREATE UNIQUE INDEX i24 ON t54 USING btree (c1) COMMENT 'text';
INSERT INTO t54 (c1) VALUES (1), (2), (3);
-- Transaction 68, with statements:
BEGIN TRANSACTION;
INSERT INTO t54 (c1) VALUES (16);
UPDATE t54 SET c1 = -8634 WHERE (- (1.7976931348623157E308) NOT BETWEEN ||/ (+ (7)) AND ~ ((+(div(-1.1107520195179063E308, 17)))));
SELECT c1 AS ca1, c1 AS ca2, c1 AS ca3 FROM ONLY t54 WHERE ((+(2))) :: BOOLEAN LIMIT 506578271, 2994144533;
DELETE FROM ONLY t54 WHERE ((- c1) IS NOT NULL);
COMMIT;
-- Transaction 69, with statements:
BEGIN;
DELETE FROM t54 WHERE (('QmGxp') IS NOT NULL);
INSERT INTO t54 (c1) VALUES (17);
SELECT ALL ta1.c1 AS ca1 FROM t54, ONLY t54 AS ta1, ONLY t54 AS ta2;
COMMIT;
Input schedule: [69-0, 68-0, 69-1, 69-2, 68-1, 68-2, 69-3, 69-4, 68-3, 68-4, 68-5]
Error: Inconsistent reporting error
68-2: UPDATE t54 SET c1 = -8634 WHERE (- (1.7976931348623157E308) NOT BETWEEN ||/ (+ (7)) AND ~ ((+(div(-1.1107520195179063E308, 17)))))
Exec: null
Oracle: ERROR: dn_6001: duplicate key value violates unique constraint "t54_c1_key"
Detail: Key (c1)=(-8634) already exists.
Error: Inconsistent final database state in t54
Error: One query result is NULL
Execution Result:
Schedule: [69-0, 68-0, 69-1, 69-2, 68-1, 68-2: (Blocked), 69-3, 69-4, 68-2, 68-3, 68-4, 68-5]
Isolation Level: READ_COMMITTED
Transaction Statement Results:
69-0: null
68-0: null
69-1: null
69-2: null
68-1: null
68-2: null
69-3: [17]
69-4: null
68-2: null
68-3: empty
68-4: null
68-5: null
DB Final State: [t54: empty ]
Oracle Result:
Schedule: [69-0, 68-0, 69-1, 69-2, 68-1, 68-2: (Blocked): (Error), 69-3, 69-4, 68-2: (Error), 68-3, 68-4, 68-5]
Isolation Level: READ_COMMITTED
Transaction Statement Results:
69-0: null
68-0: null
69-1: null
69-2: null
68-1: null
68-2: null
69-3: [17]
69-4: null
68-2: null
68-3: null
68-4: null
68-5: null
DB Final State: [t54: [17] ]
【声明】本内容来自华为云开发者社区博主，不代表华为云及华为云开发者社区的观点和立场。转载时必须标注文章的来源（华为云社区）、文章链接、文章作者等基本信息，否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容，欢迎发送邮件进行举报，并提供相关证据，一经查实，本社区将立刻删除涉嫌侵权内容，举报邮箱：
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论（0）