Problem on PG7.2.2
От | Roberto Fichera |
---|---|
Тема | Problem on PG7.2.2 |
Дата | |
Msg-id | 5.1.1.6.0.20020923122042.04477080@mail.isolaweb.it обсуждение исходный текст |
Ответы |
Re: Problem on PG7.2.2
|
Список | 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@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 whileprocessing the request. The connection to the server was lost. Attempting reset: Succeeded. database=# Roberto Fichera.
В списке pgsql-hackers по дате отправления: