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.
*Enric
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?
*Enrico Schenone*
Software Architect
--
Adrian Klaver
adr
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 detected
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 detected on firewall, no memory/disk/network failure
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 th
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 that loads a temporary table, loads 2049 rows in
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 finall
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 finally declare two nested cursors.
The first cursor i
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 finally declare two nested cursors.
The first cursor is on the temp table as parent while the se
On 12/24/24 14:23, Enrico Schenone wrote:
Hi, Adrian.
I'm arranging a test program with two nested cursors in two versions:
1. 4Js Genero BDL language
2. pure C with libpq language
I'll put both programs in stress execution into the production
environment looking for some hours how they beha
Hi, Adrian.
I'm arranging a test program with two nested cursors in two versions:
1. 4Js Genero BDL language
2. pure C with libpq language
I'll put both programs in stress execution into the production
environment looking for some hours how they behaves.
Possible combinations are:
1. no-one t
On 12/20/24 12:05, mark bradley wrote:
I'm getting a strange error message when I try to insert a date using
the view/edit grid in pgadmin. See below. I've tried quotes, no quotes
and various formats. The column type is clearly "date."
Don't hijack a thread, start a new one.
Mark Brady,
: Intermittent errors when fetching cursor rows on PostgreSQL 16
Hi, Adrian.
Today I have collected a tcpdump at client side with communications
between application server and db server while the issue was occurring
one time per second on another program.
I send you two files.
The first one is a zipped t
On 12/20/24 07:02, Enrico Schenone wrote:
Hi, Adrian.
Today I have collected a tcpdump at client side with communications
between application server and db server while the issue was occurring
one time per second on another program.
I send you two files.
The first one is a zipped tarball (.tgz
On 12/19/24 23:57, Enrico Schenone wrote:
At 19/12/24 22:47, Adrian Klaver wrote:
So are they building their own driver over libpq?
I think so.
They wrote ...
<
/The error “no connection to the server“ is definitively a PostgreSQL
error:/
/||/
/|./src/interfaces/libpq/fe-exec.c: libpq_
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
l
Good day, Adrian.
I get the error inside the program by catching the exception and logging
it with diagnostic info provided by the DVM (a runtime interpreter
similar in concept to a JVM) that embed the PG driver.
This is the fragment of the source code where the error occurs ...
comments are
Good day, Adrian.
First of all I thank-you for you answer.
Yes, the client is running on Ubuntu 22.04 LTS in this case, bu I have
observed the same problem on Debian 10 and 12 and Postgres versions 12,
13 and 16.
In the reported case no relevant info has been reported on syslog
and/or kern.l
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
logging it with diagnostic info provided
On 12/19/24 10:11, Enrico Schenone wrote:
Good day, Adrian.
I get the error inside the program by catching the exception and logging
it with diagnostic info provided by the DVM (a runtime interpreter
similar in concept to a JVM) that embed the PG driver.
DVM is this?:
https://www.geeksforgee
On 12/18/24 23:52, Enrico Schenone wrote:
Good day, Adrian.
First of all I thank-you for you answer.
At the time the error occurs, dozens of other SQL sessions are active &
running on DB server, and no-one is reporting any error at-all (not only
fetch errors).
This happens sometimes also in
On 12/17/24 08:30, Enrico Schenone wrote:
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 co
On Wed, Dec 18, 2024 at 5:01 AM Enrico Schenone
wrote:
> 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
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 applications are developed
24 matches
Mail list logo
