Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uNvgO-00C4bE-Gy for pgsql-bugs@arkaria.postgresql.org; Sat, 07 Jun 2025 15:42:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uNvgM-00DrGc-JC for pgsql-bugs@arkaria.postgresql.org; Sat, 07 Jun 2025 15:42:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uNlgx-007Bn8-A9 for pgsql-bugs@lists.postgresql.org; Sat, 07 Jun 2025 05:02:04 +0000 Received: from mail-pg1-x533.google.com ([2607:f8b0:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uNlgv-000eyP-10 for pgsql-bugs@lists.postgresql.org; Sat, 07 Jun 2025 05:02:02 +0000 Received: by mail-pg1-x533.google.com with SMTP id 41be03b00d2f7-af908bb32fdso1898346a12.1 for ; Fri, 06 Jun 2025 22:02:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1749272517; x=1749877317; darn=lists.postgresql.org; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=Cw7jm5xECTzdtKydjBwTrz5ZsD282+RsUBu/FhVD3VE=; b=LH6xZZ0Ht0Hl1A8juFQHmEzz9YIOBcIVFE2bnDM0eGc05c4jd7S//gu3BRJrglsrX8 j0+5nOU5c/Wq5/vuP1aYbzTm0SliK2JqdsJFg+lrVdVPoKzIuTYR5U/SpxM2Z+wYkEXO QFmSCcQMb/l/HgIgG+AAKoT5E5lHJgUBo1Q1TycT2QL5HpRGKeIUdpuQnCZWCTn5Yde3 ahOpWxLvp0BIHHUXhSpv3tNwmEHb6BHwzfu2yp0Ud7xF3FBH1V9kkQgOA+rU9iXrRkCH 1QTFl790ENjZluPy8QexdXQQZSl6u2FVD33e9rymgts38qWbeGqIkatf80+TPBoRdfRa 8I2Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749272517; x=1749877317; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=Cw7jm5xECTzdtKydjBwTrz5ZsD282+RsUBu/FhVD3VE=; b=kyNUXDar5UDOfmCfWjWILTCZujTjdnl73FKGzOGDcC+CUXiC6aQq+Cekt3s/M5E3Am lNGqdFZvw5mY3HnZAifzOpHrbDBdN6lSZYonbXeV5oMfUSReApS0dWv5R6TjECnBsdc1 TFRVukBngs447NQJnv2ohOuOUbZPWldi0CM7fPaaGFX47fbqkDReH8/vmRUKy75KJzqn bgdIV7639eoGbTMSTIOWxUGi/daRg1HbLHMxQzPq/SXsiBCi1dvMMdpvHlSIAnALWOxs yvbws+acOPQcO0aCLWKlqbTS3NCGZKDkvCjCJTi+DA3Yts43/BJgQ8+2CMarAcwTd8zE yXGQ== X-Gm-Message-State: AOJu0YzUcL+tCoTzIegPq/kJXNPdvPwYzC7PPxsDmZ2uaY1eY7vnnCXJ NkVPVKAg2DPItbSz0kE69U8pn8Xjfp//Wm5fsQGEM18stMUKtrW3nGqb2idFBOyq X-Gm-Gg: ASbGncvBzb/iLvSbfd946ulaWx6/DQvqvJ/ap32YGKBw49j9M2ZOwCDSVHDXv/9S8gz wWr54/uMfjC6TA1gcImglz7oR9kcSlvcIYvqXVeDVIhqJ59X0onQRzHrCue15XAON0TqWs791TK UkG/QsdERzbLvOq6kBn9CoEHNVgcRi9Zrafa6/IBFZ5e3P5kexJrp+gb++0loS3gH5SIFeX1DEN HSJS+E0GqcI/8CNBYnCI/KtD6JjDD8ZzsNOze2pcUPf1WFMkrOFa8rpMO26h8Pm3B4YD9LIxTVI 77KWv96dT29PBQKfolvwzdAB2gOC/Ej3tYpJbqlEReDxSFmv83aE4r27Y5XYvWGqKLzQ3jJBEL8 wVMesqDKEnuXAqu4gReoQ8GlT2yYp06ZnLdYrEyjrhI1Z+iM= X-Google-Smtp-Source: AGHT+IG9GjW0OFD9zrQwjD/omGdNo/Ui5RnC2v7zkJyEaoh/Rde7Rf/iEXPLvT2IKneTmZ0/W0NqdQ== X-Received: by 2002:a17:90b:38c9:b0:2fa:1e56:5d82 with SMTP id 98e67ed59e1d1-31349fda5e9mr7875560a91.17.1749272517133; Fri, 06 Jun 2025 22:01:57 -0700 (PDT) Received: from [172.30.4.163] (p11222-ipngnfx01marunouchi.tokyo.ocn.ne.jp. [114.160.213.222]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-23603077ef1sm20776355ad.17.2025.06.06.22.01.55 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 06 Jun 2025 22:01:56 -0700 (PDT) Content-Type: multipart/mixed; boundary="------------OIwB4Y6vCgBNH1BOrkD4eMVg" Message-ID: <1ba0f64a-9f35-4fb4-83b0-6c11a1b88740@gmail.com> Date: Sat, 7 Jun 2025 14:01:53 +0900 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: BUG #18907: SSL error: bad length failure during transfer data in pipeline mode with libpq To: Jacob Champion Cc: pgsql-bugs@lists.postgresql.org, Tom Lane References: <18907-d41b9bcf6f29edda@postgresql.org> <1055821.1745949960@sss.pgh.pa.us> Content-Language: en-US From: BATBAATAR Dorjpalam In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------OIwB4Y6vCgBNH1BOrkD4eMVg Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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 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 --------------OIwB4Y6vCgBNH1BOrkD4eMVg Content-Type: application/x-compressed; name="query-data-send-error.tgz" Content-Disposition: attachment; filename="query-data-send-error.tgz" Content-Transfer-Encoding: base64 H4sIAAAAAAAAA+0b/XfaRjK/wl+x4WgKDmBkO192aGs72OWKAQNum+vl8WSxgM5CwpIIdVv/ 7zezH9KuBDYkae/1HXovkdidnZ2d751d386pf1cemqFZDqg7LFPf9/yK9eRLPlV4Xh4csDc8 iff+gbG/98R4Ud2rvtp/ubdvPKkaB9UXB09I9YtSseKZB6HpE/LE97zwIbjH+v+mzz9s13Lm Q0reBuHQsa8rk2+ycVtoT6neMndtANTboMH29KaZ5zjYojUF4dinQRKQtw5GiYmAltltmbdm Lc8NQmJNQFI7p+1Wq37ab7Rbg16/S2okJ3Ec7u5Gn/LjO+PVXmW/WjmovHoZ9X4bBM7UG9Ka T2/ntk9zR2IG2w1J57h7fDE4bV+1+oDcMNS+RqtX7/YH3fZPMUC1qkJcHP886NUveYfe9eNx c3BydTbo/Qt69/fUrnf1s+OrZn8g8Dfb7c6qCSToVefdcb++BDQbhP7cCsnQN93hwesB2rb2 Y3A9H42oD/C/kyq5hxEfPXtIYNipGRY4k3fC6ax365RIYP9GByHZCX4rCf7D6OIRH2IOh11v 0TF9cxoUkDjfW0iwJRhgGO+zfGqGtOEG1A8v0QHJwa359Jr6AIe/VSgxh0A9w18/ms6cBiXG lJ2A3mqjrmawUvrIKD6IrWQC7HFoywvtkW2ZoQ3sLnTOgesu2ZmNT+ENkNee5xA76NJgBv20 fQMgoE1zBwjgbwlkOdT0u6xpFZ7gzrU69ow6tkvTIIyomQ9UdsZ1dMkJkBKJp56Nu2JBiCti YXZ3h1zQqQfuHUVAzIXpU5Sy7Y4J4IJlUpctlezsbq4C2d+zBB7R6VD3HShoDVHAd0EMBjJ0 oJ5vxUBckxiEPSKFgkDyXAAWyTc1pjYMgk+HDzQBjhQ4fIB19Rr/ImViFMmu+FUkO+LrKMbA qQMsoCyO41mFaLFcTRHonlMGtAKnYgBO9H320yxAcI0pqocEVI+iBqafXHxImbcAylVn9JwN eU4MPoRNAtT8sr/3QXAxYBozQsaWSK6Q/2qYK6lopTi4mCPyfpOrYr0jzycFTpxxxKZ8q5LB mp4/TwplQ+LT1JZWUfsgxbqgkjC5Yo7LandnJwsEnTLfQEwX+I1ehdyi8yHB3JqQcGKGsHbQ hgUaSOiBbowh1sF6Ul4flhdUECH+473w6rdJSIOQO9wCOJcSwc+qId574r0v3gfi/UK8X4r3 K/F+Ld5v+NuoFjGEXNV7bNpCHvDmAWce8OUBVx7w5AFHHsbnYWwexuWNKv5nFEsIj8AGQFcq lSL7P4uWv55LVhQXGjWzZuaomhjHGNnYlJtYZFhoUbO7SFC5L8HAXKQq6pPbkK85zQZQidFA mTa/jXmB/oU1pq1AcwfMFTyTy3wWrV9RVrUXbSAXqfRa2BiUT8O57xLeI7Sd9KjwJxQUOGDr SWo9ti3VbFSKT4m/iorYw1+PVEd3pCpPj96SGhvCm4fe/Nqh5KPpqOoD9q0KAzByYeDH2xTh rD0tD0ACoxRyf8Hhmmf6oAjFVT2Skq6BwEE6zD9x+mEmQdymHlOnb00aufdUKGVsEymdX3i2 JLsDFQGGFvUh0EJ2WJpYqeo9jy29YrwYwep1lPeq+0V5cs/fk4IVmplSMm1tD2jsnCVxQl01 pVw7vdPj7Xr6lhZIVbB+HQXhSeVnRNL09LrsN5T7cplvLO97zdkk5bduDi3E0Tl3EQqEyt+C X6AFABXMpxCiHYe4KqYSoR+pSxYT+C+cUMhk7QAgyGjuWiyHldGaDlFVMouJDTIuFMRENdK5 5PhoUBDEFMnTGmldNZtJCXQuRz6lUzoVoyMWwErX2APAIjP1X6nVC81wHvTvZpTwHt7AaFEb CtHeIZth6L0bUstmMvogGHXerfcGvUbrvFkf9K86zTr544+VcAygN2j/8BDQabvzfnDS7n// MNDFxXHrHaBCCoUGeDfCcFlexaUWiHUGBORh4h7DpVw4cze0HcZrFBtHQYcshWqMMDKxspPa R+xQfIMvMJ2A8mTl0d0VMh83E53LgDNXtONylMrByfG7YjYDsBkQtu3awaQQ7b0yco1sXvgN 65T6BFtrKgbC0jMZ9GWQEXREYQF8iwWMcEOmtIfkvTcnwcSbO8MSmXgLUGEwUB9VC/MIyDGt CbVuBJ5IQYk5wrSTmpCWdi7HNORrJcChziUFzSrh0IBS3DaZ7h0fr5kLscCRgtsjwznb74HJ wHbSs2gQ4E9vxFosbzoFo60wBGA0mQIacnGpJUfsQZ4lVJ6pdESnBoqykEDS2jKMf8BA0BNK HBM2cVho4iSsRQOAXUMguMGveznNU80shVFFs3UumdrExpZZLvuk8Dn+9Oj72BZQKY4i5/DQ xj7WzpmA6AF0pKPgjwymXdITaRUAufNHJpbIYNBstOqDwSqFZRHQs26YbPCDKoJhMRHoYABv STW1m1trXgmtzy6iRSZiRpda1P4IJl2TIFlmPEznNT4UydQeT0Ju4ExDA+qAC8Ft+pD9B5AB xILAIwtKXApIQ49hskTgwEG2O5uH6IPwx8j2sXIGBsWUqILQbER/ghh+VfoCsrAh7khUEo1z x8MO1jSBROmVkByGKKKL4d4VK8fWu74nA1pNaAkXjPSTbP/POCb8y1OVYVIqiq+5tIOTeXDH CQWLB+KBReAFwpBOZyHftgKv2BZq5HtTwUUfPM8Rx8GiJ6QmFLCJpTbYSqdzYNQ1rvujdwOc ZZwroddBHNc4LfpUytFwCtCjESpdCOlSSEGoa9FDMgnDGVZkF4tFRdZdb52K5493wUkGu9bc B8hwl9d5TVx3ZRJOncgXcc+hMfGPPyIOqH7diIyc25a6KhWuinAZPfvexMrSvoE7By4eXH8b tEQoNMECcwnVFMtuKKqF5/s28NW89oDbyFPPHwL7vJEYjU2JpAeG/wfFsjBdJlxFzaf420Rn KYaPQCLS16toCM8MKxxsAx/LFidVr8tNkOutTMNkBOHJWMiUJI4mQqeXiawa+2U1lqwMJKq4 REiJ44nayXAKgSDZLOfw6QwGgLZBaEVtxfgnZmU7Y4JB0RE7DSwthUJuEoudkCvBNQOIBanL xPwIjYDLnjky0wsqYqRE8FPkrVCEoe3OqZAlSoynR4APlg7U9N63TgmkU4E5phLRLlO0jBys 7964Fm6ac/IArUToZOLXaXTqTP2RIGE7SETCqUvHpgfZpNTY1kbGbGE3S6N2cRMr9XGzt56R 6rRprJM6rkhpYdpcOZj/ZOETm68pd+ysizv+MbhI9KkLOxCuUQQK5iEFMfZ0Soc2OE8IJkJ3 WDfzqo7nzaTVSLrEIQ6iGg3lKzqxkVCQQgUOpTNGjlGdBhrpWhyMUlSxGGUujEiYgKFbwp2i Ijk+cYXNjQOPkj24K2OBrNNughR4zocRDvewyIdnHLCE+0oxiZIZMl+Afh0+IQ8hz57hVgD2 ddBeb7T63aKaLo49NA9JKqwwsMeu6VRYLLdgzwjelLEV7ejahNzGAZb7FeH1UiE5SkdUw0J9 yWQo9HBPw/OjpEaOxP45CMGFQ1KfOzPB2THVwQUDmXHQEyyviKUdkq+G/3Zhd81+cqXFmbRt jdyjpp0bfqQT17Q7WJrHAhPruLJoC21a4RwYd8czBqErsYosYRo3dzEPvpJZ8GefXWGWzIsy wDyWchDu6mVdJcn7JvrliK36KZiMGDhTvOFnKqVgl96R0XtmU2dY4KR1zgfvGsfng95ls9c/ 7tcVVrMEWqJ4mgxGj6iLxIdkB4xsiUpzTkxqnBciIDBi2Xb5gjeks3oJuaK8kaJFECCGxQWf zAq+SU+KXWIrJKdercNaeWWJ8t4r5zRXSMchD8fJuynkl7ItCtlldJxly4Pw+QGa56JgmGi2 lEJEmR9/fsjKcuLUtF120mH6Yys6uIMfH7UTD6bhUSg14nI2J6QJE57ifNC58ig/HsTJXDYo daivVijjZfT4Ia5mFLzi6fLDG/1gUavG8zKt0js1f+0l21j1URIn2ttg1bzIiulFEM0eE6jU LE/kFQNRnS2KQ6CHa8HwKy5FFlXUKu4Y6/po8ajKG0lipF/Q/ZK2It1FaV2JPCsIj6IDSAzZ TGtbWH6JVZ7P60LjUaItuBVV6Hs+sGkH4S8fMNKv8CQ5BmbkSlpr+vguyZLYM92XHkS9l0Cd 40qpHM316n1xMFfLyzO5vVpeHsvt1/LyZO6glpenmy9qeDj54DldLS+P6F7V8vKU7nUt/0Ye 2NXYeSY/tINvg/z0fb1bFyqdN2Lk4mQiriuz3YvcrIB5syJdIJMgVHlvFh6pO/ECNABWyCTg o8DdA/oFWIN9OD+0DnO8gFw2kv4tWNihNSGIYFk4sEyIv1/bXx/qm5qUIzFDz0YcMGkivos0 Wkc4TyBMO5kNEVoJhEvcj7QnS5zw8msdYgo87C+phldMzCrOgZN4S2QdGrWzJ4w8SQa+raXL Wht76/sIfZKdy9Bv7NcF+ZH7YaULZMbwOsUWud0l35LEDbjDlGjUvCdVCH+qFcLbP3xe7Q9S co/Uu91B86SpLWo3vm5BQhMP3PiWSdypQG/Cc05hg8LN8gK3nHe5tzjt1tEh9Y9PmnXSOCOt dp/Uf270+j31/sAKV4POAhZIx1i27zYujrvvyQ/19w+7JkMeGs58atkBMPph+L0N4fc3hD/Y EP7FhvAvN4R/tSH86w3h32wGb1RT8EV5tSII08UQkcjGZfEQrSR5+rWWofBdw5qGgv8nkmlp O2esbD2kDg35aShTapvvz7g9PWQ4JNfvXrVOYzOJDONvxoe6i95CL77JqM28G0UAed5yAd2J 05Q1aP0k54b3FVzYUVxD5LtB/5wmLaAhQEiAaDqDkfaZZy6PkDafxZcpIG3xTV6xiq5SIOSy ezWPZNLFFfdsErdXPugXGMRm4DnhF1viFD9JeMenM6yWI5l4DvoAoXsrKJGcd4cCWcTKOL1G CiuYjKcaA7xbVeVsl3VqiVnPlTeT1nKJxcovrzBGVzuwxlVgVJTIsmseioXwpD8dUJdxLZEA reChuo3kvGS/xHWbyMOc1M8brVzEr2X/V5PlkhjzX8JbXUFlVrbkYpt2eegZ3xInaFc5wVVr uES3qlKz4hlLeAlI/v0C7Fm1uXRu/dVsWVPS6Psb/b+JqNmhgnYIn6qlPlKb+04UEj/dkMEs W94Cq/z8cBkLrr43H09Y8V/ca8OojtEcUhTPHwZLg/syI05sM/5/jJgxQ9av2K7/rahesV+r r1gusX7tBqFmkYFm+XLR61m/8SWtP72OT+Prat5y/i7h9NYvkD/FLywvfSfKy3j+JtAcRtlk qhywqrjvU5oC1m6VMwhFC0VnsvlE5hlRpxbkAvbHPQr52irwHOh//ZeN22ed58K8oSPboX/m HA///W/V2N+Tf/+7t/9qH9oNY88wtn//+1c89Z/rZ41mHdzO0tO2bPvkn71VnRUv2zmHjWHr rHEOMLvzwN+djcEzlI1Xu9e2Cz8G4IpG9jibPT3FEn0hmFDIevKFaFyRlMuWVcxmZan09Kx5 fI5TlsHv1qw3b0j53eC8dTXota+6p3VSHidBnwNsYxVu8ffEQ9svfuK4Mr89ByQ2Gyc9gpQ1 V42a3Ywd+5pNxoCfPwSchFwFNhw55jhQMP7klMonwzvINGyLlJ3Z7aMo7GsYn/VgGb49pEQw 4BAH6EwpQov4ymYhQT2E30JFigT8/VcVdn+hYmUzAHiqgJMy0OKR/Hck/zabjUchBlSiYnqE 6IB3813UhEspckzZLJaE3MNsxp+S8kiBl8iz2Urn+3br/SFLphn0Nu5sn+2zfbbP9tk+22f7 bJ/ts322z/bZPqnnv41Ch6cAUAAA --------------OIwB4Y6vCgBNH1BOrkD4eMVg--