could not open relation No such file or directory after alter table

From: Chris <pglist(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: could not open relation No such file or directory after alter table
Date: 2005-01-10 05:15:38
Message-ID: 9a0c82c6050109211571ef3d4b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This is Postgresql 8 RC 1 on freebsd 5.3.

I changed the type of a column from varchar(128) to varchar(256), and
right after that I got the following messages when doing inserts on
the table in question.

<41e0e2c3.fd54>ERROR: SMgrRelation hashtable corrupted
<41e0e2c3.fd54>STATEMENT: commit
<41e0e2c3.fd54>ERROR: SMgrRelation hashtable corrupted
<41e0e2c3.fd54>STATEMENT: begin
<41e0e2c3.fd54>WARNING: StartTransaction while in START state
<41e0e2c3.fd54>WARNING: there is no transaction in progress

These went on for a few queries, then stopped and I then started getting this:

<>ERROR: could not open relation 1663/17231/126958: No such file or directory
<>CONTEXT: writing block 2919 of relation 1663/17231/126958
<>ERROR: could not open relation 1663/17231/126958: No such file or directory
<>CONTEXT: writing block 2919 of relation 1663/17231/126958
<>WARNING: could not write block 2919 of 1663/17231/126958
<>DETAIL: Multiple failures --- write error may be permanent.

I then ran vacuum and got this message, and after that the errors stopped:

WARNING: relation "cart_groups" page 1 is uninitialized --- fixing

Somewhere along the line postgres dumped core once and this is the backtrace:

#0 0x2850005f in kill () from /lib/libc.so.5
#1 0x284f3c96 in raise () from /lib/libc.so.5
#2 0x28573c62 in abort () from /lib/libc.so.5
#3 0x082158cb in errfinish ()
#4 0x0819d228 in mdextend ()
#5 0x0819db22 in RememberFsyncRequest ()
#6 0x0819d3d0 in mdwrite ()
#7 0x0819e53b in smgrwrite ()
#8 0x0818e024 in BufferGetFileNode ()
#9 0x0818db28 in BufferSync ()
#10 0x0818deba in FlushBufferPool ()
#11 0x080a16ef in CreateCheckPoint ()
#12 0x080a139f in ShutdownXLOG ()
#13 0x08177bd6 in BackgroundWriterMain ()
#14 0x080a736e in BootstrapMain ()
#15 0x081776bd in ClosePostmasterPorts ()
#16 0x08175ff3 in ClosePostmasterPorts ()
#17 0xbfbfff94 in ?? ()
#18 0x00000014 in ?? ()
#19 0x00000000 in ?? ()
#20 0xbfbfe7e0 in ?? ()
#21 0x00000002 in ?? ()
#22 0x08175ed0 in ClosePostmasterPorts ()
#23 0x081743b7 in PostmasterMain ()
#24 0x0813f309 in main ()

Chris

Responses

Browse pgsql-general by date

  From Date Subject
Next Message brunotavila 2005-01-10 05:58:15 Postgres 8 release
Previous Message Jeff Davis 2005-01-10 02:35:51 Re: PostgreSQL users on webhosting