Bug #922: PANIC: open of /scratch/production_2/pg_clog/0996 failed: No such file or directory

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #922: PANIC: open of /scratch/production_2/pg_clog/0996 failed: No such file or directory
Date: 2003-03-27 10:30:20
Message-ID: 20030327103020.E90FA4758C9@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

A. Hackmann (andre(dot)hackmann(at)ntlworld(dot)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 create indices, I get the error message above. Postmaster is running under Red Hat Linux 7.1 on a dual Xeon machine having 2GB 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-03-27 15:22:01 Re: Postgresql 7.3.2 Crash
Previous Message Tom Lane 2003-03-27 06:34:30 Re: Bug #921: Default value not available in RULE