adnanhamdussalam opened a new issue, #1712: URL: https://github.com/apache/cloudberry/issues/1712
Hi, I am trying to get a data simple select query from remote database PG 16.4 using dblink it crashes the CB database. PFB below error: 2026-04-30 02:11:01.343994 EDT,"myuser","gpafiniti",p2082995,th-1681663808,"10.32.1.20","50445",2026-04-30 02:11:01 EDT,0,,,seg-1,,,,,"FATAL","57P03","the database system is resetting",,,,,,,0,,"postmaster.c",2796, 2026-04-30 02:11:01.354664 EDT,"myuser","gpafiniti",p2082999,th-1681663808,"10.32.1.20","50446",2026-04-30 02:11:01 EDT,0,,,seg-1,,,,,"FATAL","57P03","the database system is resetting",,,,,,,0,,"postmaster.c",2796, 2026-04-30 02:11:01.366028 EDT,"myuser","gpafiniti",p2083000,th-1681663808,"10.32.1.20","50447",2026-04-30 02:11:01 EDT,0,,,seg-1,,,,,"FATAL","57P03","the database system is resetting",,,,,,,0,,"postmaster.c",2796, 2026-04-30 02:11:01.375267 EDT,"myuser","gpafiniti",p2083001,th-1681663808,"10.32.1.20","50448",2026-04-30 02:11:01 EDT,0,,,seg-1,,,,,"FATAL","57P03","the database system is resetting",,,,,,,0,,"postmaster.c",2796, 2026-04-30 02:11:01.387172 EDT,"myuser","gpafiniti",p2083002,th-1681663808,"10.32.1.20","50449",2026-04-30 02:11:01 EDT,0,,,seg-1,,,,,"FATAL","57P03","the database system is resetting",,,,,,,0,,"postmaster.c",2796, 2026-04-30 02:11:01.759462 EDT,,,p1257454,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","all server processes terminated; reinitializing",,,,,,,0,,"postmaster.c",4571, 2026-04-30 02:11:02.439818 EDT,,,p2083009,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","database system was interrupted; last known up at 2026-04-30 01:48:27 EDT",,,,,,,0,,"xlog.c",6822, 2026-04-30 02:11:02.440107 EDT,,,p2083009,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","Synchronization of the wal directory starts.",,,,,,,0,,"fd.c",3452, 2026-04-30 02:11:02.444365 EDT,,,p2083009,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","synchronization of the wal directory finishes.",,,,,,,0,,"fd.c",3454, 2026-04-30 02:11:02.446480 EDT,,,p2083009,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","database system was not properly shut down; automatic recovery in progress",,,,,,,0,,"xlog.c",7391, 2026-04-30 02:11:02.586261 EDT,,,p2083009,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","redo starts at 1/27A31A40",,,,,,,0,,"xlog.c",7671, 2026-04-30 02:11:02.613573 EDT,,,p2083009,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","redo done at 1/27A9F290 system usage: CPU: user: 0.00 s, system: 0.01 s, elapsed: 0.02 s",,,,,,,0,,"xlog.c",7959, 2026-04-30 02:11:03.562749 EDT,,,p2083009,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","end of transaction log location is 1/27A9F448",,,,,,,0,,"xlog.c",8048, 2026-04-30 02:11:03.564087 EDT,,,p2083009,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","checkpoint starting: end-of-recovery immediate",,,,,,,0,,"xlog.c",9239, 2026-04-30 02:11:03.591465 EDT,,,p2083009,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","checkpoint complete: wrote 47 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.014 s, sync=0.010 s, total=0.029 s; sync files=25, longest=0.002 s, average=0.001 s; distance=441 kB, estimate=441 kB",,,,,,,0,,"xlog.c",9320, 2026-04-30 02:11:03.591586 EDT,,,p2083009,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","latest completed transaction id is 75040 and next transaction id is 75041",,,,,,,0,,"xlog.c",8446, 2026-04-30 02:11:03.591738 EDT,,,p2083009,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","database system is ready",,,,,,,0,,"xlog.c",8473, 2026-04-30 02:11:03.602880 EDT,,,p1257454,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","PostgreSQL 14.4 (Apache Cloudberry 2.0.0-incubating build 1) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5.0.1), 64-bit compiled on Aug 28 2025 15:24:15",,,,,,,0,,"postmaster.c",3564, 2026-04-30 02:11:03.603005 EDT,,,p1257454,th-1681663808,,,,0,,,seg-1,,,,,"LOG","00000","database system is ready to accept connections","PostgreSQL 14.4 (Apache Cloudberry 2.0.0-incubating build 1) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5.0.1), 64-bit compiled on Aug 28 2025 15:24:15",,,,,,0,,"postmaster.c",3566, -- 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]
