[PATCH v1] Fix hang on deferred constraint errors in pipeline mode

From: Koshino Taiki <koshino(at)sraoss(dot)co(dot)jp>
To: "pgpool-hackers(at)lists(dot)postgresql(dot)org" <pgpool-hackers(at)lists(dot)postgresql(dot)org>
Subject: [PATCH v1] Fix hang on deferred constraint errors in pipeline mode
Date: 2026-08-20 08:15:52
Message-ID: OS9P286MB6486B54CF8A848176B90539C94A42@OS9P286MB6486.JPNP286.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-hackers

Hi,

When PostgreSQL 19's psql_pipeline regression test is run through
Pgpool-II,
it can hang after a deferred constraint violation is
reported at commit time.

The attached patch fixes the issue by keeping the pending Sync message
in the queue when an ErrorResponse is received,
allowing processing to
continue through ReadyForQuery.

I have confirmed that the patch applies to
master and V4_7_STABLE through V4_3_STABLE.

Best regards,

Taiki Koshino<koshino(at)sraoss(dot)co(dot)jp>
SRA OSS K.K.
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/

Attachment Content-Type Size
v1-0001-Fix-hang-on-deferred-constraint-errors-in-pipelin.patch application/octet-stream 2.8 KB

Responses

Browse pgpool-hackers by date

  From Date Subject
Next Message Koshino Taiki 2026-08-20 08:44:44 Feature: Import PostgreSQL 19 new parser.
Previous Message Tatsuo Ishii 2026-08-17 09:31:10 Fixing pool_read2