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@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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
