DBlink Issue

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,

Start by reproducing the dblink SELECT against PostgreSQL 16.4 and compare the Cloudberry logs around postmaster.c and xlog.c, where the reset and recovery are reported. The issue is done when the remote query no longer resets the Cloudberry database and the failure has regression coverage.

Written by the indexing model from the issue text.