[mppdb@ecs-8869-0009 gaussdb-transaction]$ cat logs/gaussdb/txinfer18.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:834)
---- Time: 2025/09/23 11:35:09
-- Database: txinfer18
============Bug Report============
CREATE TABLE IF NOT EXISTS t57 (c1 BIGSERIAL, UNIQUE (c1)) WITH (ORIENTATION=ROW) DISTRIBUTE BY REPLICATION;
CREATE TABLE t59 (c1 SMALLSERIAL, c2 BIGSERIAL, c3 NVARCHAR2 (10)) WITH (ORIENTATION=COLUMN, COLVERSION=2.0, ENABLE_DELTA=ON, COMPRESSION=HIGH) DISTRIBUTE BY REPLICATION;
CREATE TABLE t60 (c1 CHAR, c2 SMALLSERIAL, c3 INTERVAL NOT NULL, PRIMARY KEY (c1, c2), UNIQUE (c3)) WITH (ORIENTATION=ROW) DISTRIBUTE BY REPLICATION;
CREATE INDEX IF NOT EXISTS i51 ON t57 (c1) COMMENT 'text';
CREATE INDEX i52 ON t59 USING btree (c1, c3);
CREATE INDEX IF NOT EXISTS i53 ON t57 (c1) NULLS NOT DISTINCT COMMENT 'text';
INSERT INTO t57 (c1) VALUES (1);
INSERT INTO t60 (c1,c2,c3) VALUES ('u',1,INTERVAL '0 year 3 months 6 days 22 hours 10 minutes 28 seconds');
INSERT INTO t57 (c1) VALUES (2), (3), (4);
INSERT INTO t60 (c1,c2,c3) VALUES ('R',2,INTERVAL '48 year 11 months 9 days 6 hours 49 minutes 51 seconds');
INSERT INTO t57 (c1) VALUES (5);
INSERT INTO t57 (c1) VALUES (6);
INSERT INTO t57 (c1) VALUES (7);
-- Transaction 61, with statements:
BEGIN;
INSERT INTO t57 (c1) VALUES (8), (9);
ROLLBACK;
-- Transaction 62, with statements:
START TRANSACTION;
INSERT INTO t59 (c1,c2,c3) VALUES (15586,6766788182057376082,'s'), (18507,9221748315308452023,'zRFIszXgjo'), (14062,5722545612576912726,'Aj');
UPDATE ONLY t59 SET c3 = 'SPJbpi6', c1 = 23297, c2 = 3183840374981966895;
ROLLBACK TRANSACTION;
-- Transaction 63, with statements:
BEGIN TRANSACTION;
SELECT ALL t60.c1 AS ca1, t60.c2 AS ca2 FROM ONLY t59, t60 LIMIT 3646165132, 2269537380;
COMMIT TRANSACTION;
Input schedule: [63-0, 62-0, 62-1, 62-2, 61-0, 63-1, 62-3, 61-1, 61-2, 63-2]
Error: Inconsistent final database state in t57
Error: The size of query results is different
Execution Result:
Schedule: [63-0, 62-0: (Blocked), 61-0, 62-0, 62-1: (Blocked), 63-1, 62-1, 62-2, 62-3, 61-1, 61-2, 63-2]
Isolation Level: READ_COMMITTED
Transaction Statement Results:
63-0: null
62-0: null
61-0: null
62-0: null
62-1: null
63-1: empty
62-1: null
62-2: null
62-3: null
61-1: null
61-2: null
63-2: null
DB Final State: [t57: [1, 2, 3, 4, 5, 6, 7] t59: empty t60: [u, 1, 0 years 3 mons 6 days 22 hours 10 mins 28.0 secs, R, 2, 48 years 11 mons 9 days 6 hours 49 mins 51.0 secs] ]
Oracle Result:
Schedule: [63-0, 62-0: (Blocked), 61-0, 62-0, 62-1: (Blocked), 63-1, 62-1, 62-2, 62-3, 61-1, 61-2, 63-2]
Isolation Level: READ_COMMITTED
Transaction Statement Results:
63-0: null
62-0: null
61-0: null
62-0: null
62-1: null
63-1: empty
62-1: null
62-2: null
62-3: null
61-1: null
61-2: null
63-2: null
DB Final State: [t57: [1, 1, 2, 2, 3, 3, 4, 4, 5, 5, 6, 6, 7, 7] t59: empty t60: [u, 1, 0 years 3 mons 6 days 22 hours 10 mins 28.0 secs, 1, R, 2, 48 years 11 mons 9 days 6 hours 49 mins 51.0 secs, 2] ]
dn日志
2025-09-23 11:34:52.314667 +3460771 68d2151d.804 txinfer18 acid@gmail.com TID:139631574711424/139630875789056 LWP:8024 PostgreSQL JDBC Driver XID:563982 cn_5001 0A000 QUERYID:72902018972705010 [BACKEND] ERROR: Row tables do not support column level encryption.
2025-09-23 11:34:52.314688 +000021 68d2151d.804 txinfer18 acid@gmail.com TID:139631574711424/139630875789056 LWP:8024 PostgreSQL JDBC Driver XID:563982 cn_5001 0A000 QUERYID:72902018972705010 [BACKEND] LOCATION: CheckRowTableColumnEncryption, alter_table_reloptions.cpp:1700
2025-09-23 11:34:52.314708 +000020 68d2151d.804 txinfer18 acid@gmail.com TID:139631574711424/139630875789056 LWP:8024 PostgreSQL JDBC Driver XID:563982 cn_5001 0A000 QUERYID:72902018972705010 [BACKEND] STATEMENT: ALTER TABLE _infer_t57 DROP COLUMN rid
2025-09-23 11:34:52.314889 +000181 68d2151d.804 txinfer18 acid@gmail.com TID:139631574711424/139630875789056 LWP:8024 PostgreSQL JDBC Driver XID:563982 cn_5001 00000 QUERYID:72902018972705010 [BACKEND] LOG: AbortTransaction
2025-09-23 11:34:52.314908 +000019 68d2151d.804 txinfer18 acid@gmail.com TID:139631574711424/139630875789056 LWP:8024 PostgreSQL JDBC Driver XID:563982 cn_5001 00000 QUERYID:72902018972705010 [BACKEND] STATEMENT: ALTER TABLE _infer_t57 DROP COLUMN rid
评论（0）