Problem on PG7.2.2

From: Roberto Fichera <kernel(at)tekno-soft(dot)it>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Problem on PG7.2.2
Date: 2002-09-23 10:27:47
Message-ID: 5.1.1.6.0.20020923122042.04477080@mail.isolaweb.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi All,

When I try 2 or 3 consecutive select count(*) on my database I've the
problem shown below.
Here is a psql session log:

[root(at)foradada root]# psql -d database
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

database=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

database=# select count(*) from detail;
count
--------
181661
(1 row)

database=# select count(*) from detail;
count
--------
181660
(1 row)

database=# select count(*) from detail;
FATAL 2: open of /var/lib/pgsql/data/pg_clog/0303 failed: No such file or
directo
ry
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
database=#

Roberto Fichera.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 2002-09-23 10:30:16 Re: ECPG
Previous Message Hannu Krosing 2002-09-23 09:54:41 Re: DROP COLUMN misbehaviour with multiple inheritance