Thread: No rows returned when rows are there!

No rows returned when rows are there!

From
Michael Andreasen
Date:
I have been using Postgres for several years now and am running quiet a
large system, with a sustained number of users around 50, in constant
use. I am using 7.1.3 on a Linux 2.2 Kernel. I have had no real problems
until now. Recently, at arbitary times in the day, "all" queries return
no rows. I do not get any error messages on the server or on the the
clients, they execute the query just fine but no rows are retuned. This
happens on serveral unconnected tables, and seems to be system wide.
This lasts for a fews seconds (10-60) then starts working again.

This is very worrying as no errors seem to be generated, and it put the
integrety of the whole database in jeopardy.

Does anyone know what's happening or how I can get some idea of what is
actually happening?




Re: No rows returned when rows are there!

From
"Dave Cramer"
Date:
Michael,

You may want to send this to the hackers list; but without more
information it will be difficult to figure out what is going on.

Thanks,
Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Michael Andreasen
Sent: Tuesday, November 20, 2001 9:19 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] No rows returned when rows are there!


I have been using Postgres for several years now and am running quiet a
large system, with a sustained number of users around 50, in constant
use. I am using 7.1.3 on a Linux 2.2 Kernel. I have had no real problems

until now. Recently, at arbitary times in the day, "all" queries return
no rows. I do not get any error messages on the server or on the the
clients, they execute the query just fine but no rows are retuned. This
happens on serveral unconnected tables, and seems to be system wide.
This lasts for a fews seconds (10-60) then starts working again.

This is very worrying as no errors seem to be generated, and it put the
integrety of the whole database in jeopardy.

Does anyone know what's happening or how I can get some idea of what is
actually happening?




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org