could not open relation No such file or directory after alter table
От | Chris |
---|---|
Тема | could not open relation No such file or directory after alter table |
Дата | |
Msg-id | 9a0c82c6050109211571ef3d4b@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: could not open relation No such file or directory after alter table
|
Список | 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
В списке pgsql-general по дате отправления: