Re: BUG #18907: SSL error: bad length failure during transfer data in pipeline mode with libpq
BATBAATAR Dorjpalam <htgn.dbat.95@gmail.com>
From: BATBAATAR Dorjpalam <htgn.dbat.95@gmail.com>
To: Jacob Champion <jacob.champion@enterprisedb.com>
Cc: pgsql-bugs@lists.postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2025-06-07T05:01:53Z
Lists: pgsql-bugs
Attachments
- query-data-send-error.tgz (application/x-compressed)
I am sending a sample program to reproduce the this phenomenon. The attached archive contains a Makefile to build with PostgreSQL17. To run the program, all you need is a PostgreSQL17 server with SSL connection. After building, you will have an executable file named query-data-send-error. Please execute it as follows. ./query-data-send-error -i 200 -u 200 -c "postgres://postgres:postgres@192.168.0.10/postgres?sslmode=require" The -i is the number of times to create a test data record, -u is the number of times to update the test data record, -c specifies the connection string of the PostgreSQL server to connect to, respectively. The sample program does the following 1) Create the test_data table. 2) Register test data in units of 100 records for the number of times specified by -i. 3) Repeat updating the registered records for the number of times specified by -u. My environment is as follows PostgreSQL Server: 17.2 OS: Rocky Linux 9.5 (Blue Onyx) Kernel: Linux 5.14.0-503.22.1.el9_5.x86_64 Spec: CPU 4vCore/Memory 8G/HDD 400G At runtime, the following error occurs when updating. Line : 552 SSL error: bad length SSL SYSCALL error: EOF detected Depending on the timing, this error may not occur, but if the number of times is increased, will occur almost every time. On 2025/04/30 3:48, Jacob Champion wrote: > On Tue, Apr 29, 2025 at 11:06 AM Tom Lane <tgl@sss.pgh.pa.us> wrote: >> Could you provide a self-contained test case demonstrating such >> failures? This is not the kind of code that we like to change >> on the basis of undocumented claims. > Agreed -- but also, let us know if the answer is "no, I can't", or if > you get stuck and need some additional collaboration. These corner > cases can be really nasty to track down and record. > > Thanks, > --Jacob
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Don't reduce output request size on non-Unix-socket connections.
- f09fea386ce9 13.22 landed
- 6a4d93edad4b 15.14 landed
- 3f37400cfb87 16.10 landed
- 30e0d9ee904d 17.6 landed
- 137935bd1167 18.0 landed
- 0703c9385ba0 14.19 landed
-
Fix timing-dependent failure in GSSAPI data transmission.
- d053a879bb36 17.0 cited