reshke commented on PR #1801: URL: https://github.com/apache/cloudberry/pull/1801#issuecomment-4616556509
> Looks like this was already fixed in [fc8aab8](https://github.com/apache/cloudberry/commit/fc8aab88de647933ea60999d8b8cf54d4f622359), but then re-introduced quite interesting that this does reproduce for me on master without additional CHECKPOINT spam, but does reproduce on REL_2_STABLE. 16.9 repro: ``` reshke@yezzey-cbdb-bench:~/cloudberry$ /usr/local/gpdb/bin/postgres --single postgres -D /home/reshke/cloudberry/gpAux/gpdemo/datadirs/demoDataDir3 2026-06-03 20:44:28.477343 UTC,,,p1083267,th-1554549696,,,,0,,,seg3,,,,,"LOG","00000","database system was interrupted while in recovery at 2026-06-03 20:44:16 UTC",,"This probably means that some data is corrupted and you will have to use the last backup for recovery.",,,,,,"StartupXLOG","xlog.c",5380, 2026-06-03 20:44:28.477589 UTC,,,p1083267,th-1554549696,,,,0,,,seg3,,,,,"LOG","00000","Synchronization of the wal directory starts.",,,,,,,,"SyncAllXLogFiles","fd.c",3673, 2026-06-03 20:44:28.477746 UTC,,,p1083267,th-1554549696,,,,0,,,seg3,,,,,"LOG","00000","synchronization of the wal directory finishes.",,,,,,,,"SyncAllXLogFiles","fd.c",3675, 2026-06-03 20:44:28.477848 UTC,,,p1083267,th-1554549696,,,,0,,,seg3,,,,,"LOG","00000","restarting backup recovery with redo LSN 0/10000110",,,,,,,,"InitWalRecovery","xlogrecovery.c",794, 2026-06-03 20:44:28.478354 UTC,,,p1083267,th-1554549696,,,,0,,,seg3,,,,,"LOG","00000","database system was not properly shut down; automatic recovery in progress",,,,,,,,"InitWalRecovery","xlogrecovery.c",943, 2026-06-03 20:44:28.481791 UTC,,,p1083267,th-1554549696,,,,0,,,seg3,,,,,"LOG","00000","redo starts at 0/10000110",,,,,,,,"PerformWalRecovery","xlogrecovery.c",1760, 2026-06-03 20:44:28.481927 UTC,,,p1083267,th-1554549696,,,,0,,,seg3,,,,,"FATAL","XX000","the limit of 0 distributed transactions has been reached while adding gid = 191. Committed gid array length: 0, dump: ","It should not happen. Temporarily increase max_connections (need postmaster reboot) on the postgres (master or standby) to work around this issue and then report a bug",,,,"WAL redo at 0/10000110 for Transaction/DISTRIBUTED_COMMIT: distributed commit 2026-06-03 20:43:37.46535+00 gxid = 191",,,"redoDistributedCommitRecord","cdbdtxrecovery.c",529,1 0x60f1761b9e56 postgres errstart + 0x286 2 0x60f175aed5b7 postgres <symbol not found> + 0x75aed5b7 3 0x60f175bcaa43 postgres xact_redo + 0x293 4 0x60f175be415a postgres PerformWalRecovery + 0x3fa 5 0x60f175bd5584 postgres StartupXLOG + 0x364 6 0x60f1761ce53a postgres InitPostgres + 0x26a 7 0x60f176017041 postgres PostgresMain + 0x101 8 0x60f1760199ce postgres PostgresSingleUserMain + 0xfe 9 0x60f175aee7c5 postgres main + 0x605 10 0x75fca362a1ca libc.so.6 <symbol not found> + 0xa362a1ca 11 0x75fca362a28b libc.so.6 __libc_start_main + 0x8b 12 0x60f175af23d5 postgres _start + 0x25 reshke@yezzey-cbdb-bench:~/cloudberry$ /usr/local/gpdb/bin/postgres --version postgres (Apache Cloudberry) 16.9 ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
