[regression reindex_gpfastsequence] could not create unique index "gp_fastsequence_objid_objmod_index"

[avamingli]

Cloudberry Database version

No response

What happened

diff -I HINT: -I CONTEXT: -I GP_IGNORE: -U3 /code/gpdb_src/src/test/isolation2/expected/reindex_gpfastsequence.out /code/gpdb_src/src/test/isolation2/results/reindex_gpfastsequence.out
--- /code/gpdb_src/src/test/isolation2/expected/reindex_gpfastsequence.out	2023-08-09 08:55:49.663583934 +0000
+++ /code/gpdb_src/src/test/isolation2/results/reindex_gpfastsequence.out	2023-08-09 08:55:49.665583943 +0000
@@ -16,13 +16,14 @@
 
 -- The reindex_relation fault should be hit
 1&: reindex table gp_fastsequence;  <waiting ...>
+FAILED:  Forked command is not blocking; got output: ERROR:  could not create unique index "gp_fastsequence_objid_objmod_index"
+DETAIL:  Key (objid, objmod)=(98317, 2) is duplicated.
 2: select gp_wait_until_triggered_fault('reindex_relation', 1, 2);
- gp_wait_until_triggered_fault 
--------------------------------
- Success:                      
-(1 row)
+DETAIL:  Timed-out as 10 minutes max wait happens until triggered. (gp_inject_fault.c:255)
+ERROR:  failed to inject fault: ERROR:  fault not triggered, fault name:'reindex_relation' fault type:'wait_until_triggered'
 -- The insert should for reindex in session 1
 2&: insert into test_fastseqence select i , 'aa'||i from generate_series(1,100) i;  <waiting ...>
+FAILED:  Forked command is not blocking; got output: INSERT 100
 
 select gp_inject_fault('reindex_relation', 'reset', 2);
  gp_inject_fault 
@@ -31,9 +32,9 @@
 (1 row)
 
 1<:  <... completed>
-REINDEX
+FAILED:  Execution failed
 2<:  <... completed>
-INSERT 100
+FAILED:  Execution failed
 
 -- Validate that gp_fastsequence works as expected after reindex
 SELECT 1 AS oid_same_on_all_segs from gp_dist_random('pg_class') WHERE relname = 'gp_fastsequence_objid_objmod_index' GROUP BY oid having count(*) = (SELECT count(*) FROM gp_segment_configuration WHERE role='p' AND content > -1);

What you think should happen instead

No response

How to reproduce

https://github.com/cloudberrydb/cloudberrydb/actions/runs/5805035027/job/15739091747?pr=128

Operating System

as ci

Anything else

No response

Are you willing to submit PR?

• Yes, I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct.