On 11/21/19 6:20 PM, Mark Dilger wrote:
Hackers,
I stumbled upon an assertion while testing master for possible
bugs. I am reporting it here in the hope that this report will
be useful. The attached small regression test patch consistently
triggers an assert in predicate.c:
TRAP: FailedAssertion("!isCommit ||
SxactIsPrepared(MySerializableXact)", File: "predicate.c", Line: 3372)
I have winnowed down the test a bit further. The attached
smaller patch still triggers the same assertion as the prior
patch did.
--
Mark Dilger
diff --git a/src/test/regress/expected/nonsense.out
b/src/test/regress/expected/nonsense.out
new file mode 100644
index 0000000000..10ce3496e8
--- /dev/null
+++ b/src/test/regress/expected/nonsense.out
@@ -0,0 +1,3 @@
+SET SESSION CHARACTERISTICS AS TRANSACTION DEFERRABLE , ISOLATION LEVEL
SERIALIZABLE;
+SET SESSION CHARACTERISTICS AS TRANSACTION NOT DEFERRABLE;
+LISTEN mouse;
diff --git a/src/test/regress/parallel_schedule
b/src/test/regress/parallel_schedule
index d33a4e143d..0a47f299bf 100644
--- a/src/test/regress/parallel_schedule
+++ b/src/test/regress/parallel_schedule
@@ -121,3 +121,5 @@ test: fast_default
# run stats by itself because its delay may be insufficient under heavy load
test: stats
+
+test: nonsense
diff --git a/src/test/regress/serial_schedule b/src/test/regress/serial_schedule
index f86f5c5682..3cfebd7842 100644
--- a/src/test/regress/serial_schedule
+++ b/src/test/regress/serial_schedule
@@ -196,3 +196,4 @@ test: tuplesort
test: event_trigger
test: fast_default
test: stats
+test: nonsense
diff --git a/src/test/regress/sql/nonsense.sql
b/src/test/regress/sql/nonsense.sql
new file mode 100644
index 0000000000..10ce3496e8
--- /dev/null
+++ b/src/test/regress/sql/nonsense.sql
@@ -0,0 +1,3 @@
+SET SESSION CHARACTERISTICS AS TRANSACTION DEFERRABLE , ISOLATION LEVEL
SERIALIZABLE;
+SET SESSION CHARACTERISTICS AS TRANSACTION NOT DEFERRABLE;
+LISTEN mouse;
