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?
Code of Conduct
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?
Code of Conduct