DBlink Issue
メンテナーはふだん 3 日以内に返信
まだ誰も着手していません。
評価
- 難易度
- 4/5
- 見積もり時間
- 3〜5日
- 初心者へのやさしさ
- 38/100
- issue の種類
- バグ
- 明瞭さ
- 説明が足りない
- 活発さ
- 静か
- 技術スタック
- postgresql
- 領域
- databases
調査の方向性
まず PostgreSQL 16.4 に対する dblink SELECT を再現し、reset と recovery が報告される postmaster.c と xlog.c 周辺の Cloudberry ログを比較します。リモートクエリによって Cloudberry データベースがリセットされなくなり、その障害が回帰テストでカバーされた時点で issue は完了です。
索引モデルが 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,
- 主要言語
- C
- スター
- 1.4k
- フォーク
- 260
- 平均マージ
- 4日 5時間
- マージ済み PR（30日）
- 58
環境構築
- Dockerfile・Docker Compose ファイルなし
- プルリクエストのテンプレートあり
- コントリビューションガイドを読む
はじめの一歩
- issue を最後まで読み、次にプロジェクトのコントリビューションガイドを読みます。
- 着手することを issue にコメントします — 二人が同じ作業をするのを防げます。
- リポジトリをフォークし、ブランチを切って変更します。
- issue 番号を参照したプルリクエストを送ります。
apache/cloudberry のほかの issue
-
[Bug] Expand fails to recognize user-defined tablespaces対応中かも @nix-oss が 57 日前に担当しました。 オープンtype: Bug
難易度 2/5 1〜3時間 初心者へのやさしさ 76/100
apache/cloudberry#1885 · リアクション 2 件 ·
メンテナーはふだん 3 日以内に返信
-
gpexpand first stage fails: 'SyncPackages' object has no attribute 'ret' (extension sync never runs; regression)対応中かも @talmacschen-arch が 118 日前に担当しました。 オープン
難易度 2/5 1〜3時間 初心者へのやさしさ 86/100
apache/cloudberry#1825 ·
メンテナーはふだん 3 日以内に返信
-
type: Bug
難易度 4/5 3〜5日 初心者へのやさしさ 32/100
apache/cloudberry#2126 ·
メンテナーはふだん 3 日以内に返信
-
[Issues] When Initializing a new Cloudberry cluster we are encountering issues対応中かも @yjhjstz が 2 日前に担当しました。 オープンtype: Bug
難易度 4/5 3〜5日 初心者へのやさしさ 12/100
apache/cloudberry#2101 · コメント 7 件 ·
メンテナーはふだん 3 日以内に返信
-
難易度 4/5 3〜5日 初心者へのやさしさ 12/100
apache/cloudberry#2097 · コメント 1 件 ·
メンテナーはふだん 3 日以内に返信
apache/cloudberry の issue をすべて見る
似ている issue
-
難易度 2/5 1〜3時間 初心者へのやさしさ 62/100
-
難易度 2/5 1〜3時間 初心者へのやさしさ 72/100
fluent/fluent-bit#12579 ·
メンテナーはふだん 1 日以内に返信
-
難易度 2/5 1〜3時間 初心者へのやさしさ 72/100
obsproject/obs-studio#14036 ·
メンテナーはふだん 1 日以内に返信
-
難易度 2/5 1〜3時間 初心者へのやさしさ 68/100
メンテナーはふだん 1 日以内に返信
-
難易度 1/5 1時間未満 初心者へのやさしさ 72/100