Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

2025-01-15 Thread Enrico Schenone
Il 15/01/25 17:03, Adrian Klaver ha scritto: On 1/14/25 23:46, Enrico Schenone wrote: Which environment did you run the recent prolonged test against? The first one: Distinct application server and DB server on distinct subnets. Is that the same as where you saw the errors? Yes

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

2025-01-14 Thread Enrico Schenone
Il 14/01/25 18:56, Adrian Klaver ha scritto: On 1/13/25 11:56 PM, Enrico Schenone wrote: Il 13/01/25 18:26, Adrian Klaver ha scritto: In your OP you stated: "Production environments can be:  * Distinct application server and DB server on distinct subnets (no     dropped packet det

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

2025-01-13 Thread Enrico Schenone
Il 13/01/25 18:26, Adrian Klaver ha scritto: On 1/13/25 08:59, Enrico Schenone wrote: Il 13/01/25 17:19, Adrian Klaver ha scritto: On 1/13/25 00:45, Enrico Schenone wrote: Hello, Adrian. As I said days ago, I have arranged a kind of stress test in production environment. I wrote a program

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

2025-01-13 Thread Enrico Schenone
Il 13/01/25 17:19, Adrian Klaver ha scritto: On 1/13/25 00:45, Enrico Schenone wrote: Hello, Adrian. As I said days ago, I have arranged a kind of stress test in production environment. I wrote a program that loads a temporary table, loads 2049 rows into them from a baseline_table and

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

2025-01-13 Thread Enrico Schenone
27;ll make no other test unless the error is knocking back to my door. *Enrico Schenone* Software Architect *Cleis Tech s.r.l.* - www.gruppocleis.it Sede di Genova, Via Paolo Emilio Bensa, 2 - 16124 Genova, ITALY Tel: +39-0104071400   Fax: +39-0104073276 Mobile: +39-320 7709352file:///home/en

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

2024-12-24 Thread Enrico Schenone
1. no-one throws an error 2. only the 4Js Genero version throws an error 3. only the pure C version throws an error 4. both versions throws the error This stress test should address further investigations. I'll keep you informed. Regards. Enrico Schenone Il 20/12/24 17:43, Adrian Klaver ha

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

2024-12-20 Thread Enrico Schenone
At 19/12/24 22:47, Adrian Klaver wrote: On 12/19/24 11:40 AM, Enrico Schenone wrote: Hello, my answers in line along your message ... Thanks a lot again. Enrico On 12/19/24 10:11, Enrico Schenone wrote: Good day, Adrian. I get the error inside the program by catching the exception and

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

2024-12-20 Thread Enrico Schenone
ther info ? Do you think it can be useful to include in this thread the 4Js Suppory guys ? Thanks again and best regards. Enrico *Enrico Schenone* Software Architect *Cleis Tech s.r.l.* - www.gruppocleis.it Sede di Genova, Via Paolo Emilio Bensa, 2 - 16124 Genova, ITALY Tel: +39-0104071400  

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

2024-12-20 Thread Enrico Schenone
+1     postgresql-client-common:all/jammy-pgdg 262.pgdg22.04+1 upgradeable to 267.pgdg22.04+1 Best regards. Enrico *Enrico Schenone* Software Architect *Cleis Tech s.r.l.* - www.gruppocleis.it Sede di Genova, Via Paolo Emilio Bensa, 2 - 16124 Genova, ITALY Tel: +39-0104071400   Fax: +39-01040

Intermittent errors when fetching cursor rows on PostgreSQL 16

2024-12-18 Thread Enrico Schenone
Good day. My name is Enrico Schenone, from Genoa, Italy. I'm a software achitect working at Cleis Tech - Genoa - Italy  - http://gruppocleis.it Me and my team are using PostgreSQL v12 to v16 on Debian 10-12 and Ubuntu Server 22.04 LTS with no-cluster configuration. Our application