Re: [BUGS] ERROR: invalid page header in block 502758 of relation base/16388/16403
hi again i've stopped postgres and done this dd if=16403.3.orig of=16403.3 bs=8192 count=109541 dd if=/dev/zero bs=8192 count=1 16403.3 dd if=16403.3.orig skip=109542 bs=8192 16403.3 then started postgres, but did not help, the same error appears. ERROR: invalid page header in block 502758 of relation base/16388/16403 am i doing anything wrong? regards, fous Right, so it would be in the .3 file at block number 109542. regression=# select 502758 / 131072; ?column? -- 3 (1 row) regression=# select 502758 % 131072; ?column? -- 109542 (1 row) regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] ERROR: invalid page header in block 502758 of relation base/16388/16403
ok, fault on my side this is maybe better code dd if=16403.3.orig of=16403.3 bs=8192 count=109542 dd if=/dev/zero bs=8192 count=1 16403.3 dd if=16403.3.orig skip=109543 bs=8192 16403.3 but now, it says ERROR: index day contains unexpected zero page at block 502758 HINT: Please REINDEX it. ok, so i did reindexing ending with following error proxylog=# REINDEX TABLE user_record ; ERROR: concurrent insert in progress what should i do now? i think it's not the problem of hw thanks for help fous -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] ERROR: invalid page header in block 502758 of relation base/16388/16403
hi, i got following error while selecting from my db ERROR: invalid page header in block 502758 of relation base/16388/16403 i've found some solution in this thread http://www.mail-archive.com/pgsql-gene...@postgresql.org/msg101644.html but my problem is, that there are multiple files with similar name in the base/16388 directory. 16403 (1Gb) 16403.1 (1Gb) 16403.2 (1Gb) 16403.3 (almost 1 Gb) so the question is, where can i find the right 502758 position (i assume that this is the number of 8k block position). each file with size 1Gb has 131072 of 8k blocks. thanx for help fous -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] Re: ERROR: invalid page header in block 502758 of relation base/16388/16403
i forgot the system informations postgresql-server-8.4.0-1PGDG.rhel5 linux kernel 2.6.18-128.4.1.el5xen x86_64 centos release 5.3 (final) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #4948: getting error while vacuuming the database
well, i knew how to fix it (probably the reindexing, that you mentioned;)) but i think this happens often in our database, so what informations would you like to know? i'm awaiting orders :) fous Nope. If you just want to fix it, reindexing that index should do the trick. If you want us to look into what caused it and whether there's a fixable bug there, we'll need a whole lot more information than the error message. regards, tom lane