Bug #922: PANIC: open of /scratch/production_2/pg_clog/0996 failed: No such file or directory - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #922: PANIC: open of /scratch/production_2/pg_clog/0996 failed: No such file or directory
Date
Msg-id 20030327103020.E90FA4758C9@postgresql.org
Whole thread Raw
Responses Re: Bug #922: PANIC: open of /scratch/production_2/pg_clog/0996 failed: No such file or directory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
A. Hackmann (andre.hackmann@ntlworld.com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
PANIC:  open of /scratch/production_2/pg_clog/0996 failed: No such file or directory

Long Description
Hi,
I'm loading aprrox. 20GB into a Postgresql 7.3.2 db (using COPY command). Copying works fine, but when I tried to
createindices, I get the error message above. Postmaster is running under Red Hat Linux 7.1 on a dual Xeon machine
having2GB RAM. 1 GB ist reserved for shared memory, where 600Mb is used for this particular db instance. I changed wlog
parameters,but this had no effect. Source has been compilied on gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-85).  

Thanks,
  Andre.

Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #921: Default value not available in RULE
Next
From: Tom Lane
Date:
Subject: Re: Postgresql 7.3.2 Crash