DBlink Issue

Inizia riproducendo il dblink SELECT su PostgreSQL 16.4 e confrontando i log di Cloudberry relativi a postmaster.c e xlog.c, dove vengono segnalati il reset e il recovery. L’issue è completata quando la query remota non resetta più il database Cloudberry e il failure è coperto da test di regressione.

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,