Transaction execution mismatches-20250618

[mppdb@ecs-8869-0009 gaussdb]$ cat txninfer1.log

--java.lang.AssertionError: Transaction execution mismatches its oracle

-- at dbmsforge.gaussdb.oracle.GaussDBTxInferOracle.check(GaussDBTxInferOracle.java:102)

-- 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/06/18 19:37:38

-- Database: txninfer1

============Bug Report============

CREATE TABLE IF NOT EXISTS t5 (c1 DOUBLE PRECISION UNIQUE, c2 BIGSERIAL, UNIQUE (c2, c1)) WITH (ORIENTATION=COLUMN, COLVERSION=2.0, ENABLE_DELTA=ON, COMPRESSION=LOW) DISTRIBUTE BY REPLICATION

INSERT INTO t5 (c1,c2) VALUES (4.727158628373388E307,1)

INSERT INTO t5 (c1,c2) VALUES (1.2934733217378891E308,2)

INSERT INTO t5 (c1,c2) VALUES (1.6129805437329568E308,3)

 -- Transaction 2, with statements:

BEGIN

UPDATE ONLY t5 SET c1 = -1.1860269025865979E308, c2 = 3698365341386264655

UPDATE ONLY t5 SET c2 = 5526085489937822112, c1 = 1.310364812945943E308 WHERE FALSE

ROLLBACK

 -- Transaction 3, with statements:

BEGIN

INSERT INTO t5 (c1,c2) VALUES (-1.3496744816747641E308,4), (-3.4479401953972357E307,5)

UPDATE ONLY t5 SET c1 = -1.3442708890982768E308, c2 = 48795893603108354

UPDATE ONLY t5 SET c1 = -4.717113626470742E307, c2 = 345748580054161959 WHERE FALSE

SELECT ta6.ca3 AS ca1, ca3 AS ca2 FROM t5, ONLY t5 AS ta1, (SELECT ALL ta3.ca5 AS ca3, ta3.ca5 AS ca4 FROM (SELECT ta2.c2 AS ca5 FROM ONLY t5, ONLY t5 AS ta2 WHERE FALSE) AS ta3, t5, (SELECT DISTINCT t5.c1 AS ca6, ta4.c2 AS ca7 FROM ONLY t5, ONLY t5 AS ta4 LIMIT 1373616993, ALL) AS ta5 WHERE ((+(84))) :: BOOLEAN LIMIT 2076916824) ta6 WHERE FALSE

COMMIT

Input schedule: [2-0, 2-1, 3-0, 3-1, 2-2, 2-3, 3-2, 3-3, 3-4, 3-5]

Error: Inconsistent final database state in t5

Error: The size of query results is different

Execution Result:

Schedule: [2-0, 2-1: (Error): (Deadlock), 3-0, 3-1, 3-2: (Error): (Deadlock)]

Isolation Level: READ_UNCOMMITTED

Transaction Statement Results:

DB Final State: [t5: [4.72715862837339E307, 1, 1.29347332173789E308, 2, 1.61298054373296E308, 3] ]

Oracle Result:

Schedule: [2-0, 2-1, 3-0, 3-1, 3-2]

Isolation Level: READ_UNCOMMITTED

Transaction Statement Results:

DB Final State: [t5: [4.72715862837339E307, 1, 1, 1.29347332173789E308, 2, 2, 1.61298054373296E308, 3, 3] ]