Error Could Not Open Relation No Such File Or Directory
Contents |
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project
Error Could Not Open File Dev I2c 1 Or Dev I2c 1 No Such File Or Directory
lists Inactive lists IRC Local User Groups Featured Users could not open /dev/vmmon no such file or directory International Sites Propaganda Resources Weekly News Re: could not open relation...No such file or directory could not open /dev/vmmon no such file or directory osx From: Sim Zacks
Could Not Open /dev/vmmon No Such File Or Directory Linux
raw or whole thread) Thread: 2010-12-22 15:59:57 from Sim Zacks
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project lists Inactive lists IRC Local User Groups Featured Users International Sites Propaganda Resources Weekly News ERROR: could not open relation base/2757655/6930168: No such file or directory -- during warm standby setup From: bricklen
file or directory after alter table - PostgreSQL / PGSQL This is Postgresql 8 RC 1 on freebsd 5.3. I changed the type of a column from varchar(128) http://www.justskins.com/forums/could-not-open-relation-106481.html 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 could not 1663/17231/126958: No such file or directory <>CONTEXT: writing block 2919 of relation 1663/17231/126958 <>ERROR: could not open relation ... Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode January 10th,05:15 AM #1 could not open relation No such file or directory after alter table This is Postgresql 8 RC 1 on could not open 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 0x08