ERROR: found two entries in pg_aocsseg_73427122

[liyxbeijing]

Cloudberry Database version

postgres=# select version(); version

PostgreSQL 14.4 (Cloudberry Database 1.4.0 build commit:e83e3ffc22d538deb2dbceeeae0138ca2de064e6) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Anolis 8.3.1-5.0.1.1) , 64-bit compiled on Sep 17 2023 23:10:22 (with assert checking)

What happened

Below errors found while doing a insert:

2024-01-10 18:11:06.142405 CST,,p88111,th1232114560,"48193",2024-01-10 17:58:10 CST,1974924,con1694,cmd4,seg48,,dx6414314,x1974925,sx2,"ERROR","XX000","found two entries in pg_aocsseg_73427122 with segno 1: ctid (0,18) and ctid (0,19) (aocssegfiles.c:194)",,,,,,"insert into xxxxxx ^M (^M starttime ,^M period ,^M effectiveconnmax ,^M

connmax ",0,,"aocssegfiles.c",194,"Stack trace: 1 0xe2ea31 postgres errstart (elog.c:589) 2 0x6fd0c4 postgres (aocssegfiles.c:188) 3 0x8ef474 postgres (aocsam.c:957) 4 0x8f6039 postgres aocs_insert_init (discriminator 2) 5 0x8ed26f postgres (ilist.h:280) 6 0x8ed4c8 postgres (aocsam_handler.c:761) 7 0xa8f33c postgres (nodeModifyTable.c:972) 8 0xa90173 postgres (nodeModifyTable.c:2777) 9 0xa59faf postgres (execProcnode.c:630) 10 0xa501db postgres (execMain.c:2530) 11 0xa50c4c postgres standard_ExecutorRun (execMain.c:920) 12 0xcb0b17 postgres (pquery.c:243) 13 0xcb105c postgres (pquery.c:1476) 14 0xcb251f postgres PortalRun (pquery.c:970) 15 0xcab69c postgres (postgres.c:1424) 16 0xcaf885 postgres PostgresMain (postgres.c:5736) 17 0xbf73f8 postgres (postmaster.c:4997) 18 0xbf857e postgres PostmasterMain (postmaster.c:1658) 19 0x7c6196 postgres main (main.c:200) 20 0x7fa845f4a6a3 libc.so.6 __libc_start_main + 0xf3 21 0x7d1c0e postgres _start + 0x2e "

What you think should happen instead

No response

How to reproduce

repeat the insert.

Operating System

BELinux.

Anything else

No response

Are you willing to submit PR?

• [ ] Yes, I am willing to submit a PR!

Code of Conduct

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

[avamingli]

What's the reproduce SQL: DDL & DML ?