Обсуждение: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227
Hello! How do I location of this pointer and how do I zero it so I can access the rest of the data? "zero_damaged_pages = true" did not help in this case, because I always get same numbers being zeroed. This is with 8.4.0 and 8.4.1. Thanks.
2009/11/18 Tech 2010 <tch072@gmail.com>: > Hello! > > How do I location of this pointer and how do I zero it so I can access > the rest of the data? > > "zero_damaged_pages = true" did not help in this case, because I > always get same numbers being zeroed. This is with 8.4.0 and 8.4.1. > > Thanks. > You probably just need to reindex a table. Try vacuuming each table individually until you get this error, or just check the vacuum log output to identify it, then just run a REINDEX on it. Regards Thom
On 18 nov., 13:40, thombr...@gmail.com (Thom Brown) wrote: > 2009/11/18 Tech 2010 <tch...@gmail.com>: > > > Hello! > > > How do I location of this pointer and how do I zero it so I can access > > the rest of the data? > > > "zero_damaged_pages = true" did not help in this case, because I > > always get same numbers being zeroed. This is with 8.4.0 and 8.4.1. > > > Thanks. > > You probably just need to reindex a table. Try vacuuming each table > individually until you get this error, or just check the vacuum log > output to identify it, then just run a REINDEX on it. xy=# reindex table xy_data; ERROR: concurrent insert in progress
On 18 nov., 16:48, Tech 2010 <tch...@gmail.com> wrote: > On 18 nov., 13:40, thombr...@gmail.com (Thom Brown) wrote:> 2009/11/18 Tech 2010 <tch...@gmail.com>: > > > > Hello! > > > > How do I location of this pointer and how do I zero it so I can access > > > the rest of the data? > > > > "zero_damaged_pages = true" did not help in this case, because I > > > always get same numbers being zeroed. This is with 8.4.0 and 8.4.1. > > > > Thanks. > > > You probably just need to reindex a table. Try vacuuming each table > > individually until you get this error, or just check the vacuum log > > output to identify it, then just run a REINDEX on it. > > xy=# reindex table xy_data; > ERROR: concurrent insert in progress Should I drop and recreate indexes?
2009/11/19 Tech 2010 <tch072@gmail.com>: > On 18 nov., 16:48, Tech 2010 <tch...@gmail.com> wrote: >> On 18 nov., 13:40, thombr...@gmail.com (Thom Brown) wrote:> 2009/11/18 Tech 2010 <tch...@gmail.com>: >> >> > > Hello! >> >> > > How do I location of this pointer and how do I zero it so I can access >> > > the rest of the data? >> >> > > "zero_damaged_pages = true" did not help in this case, because I >> > > always get same numbers being zeroed. This is with 8.4.0 and 8.4.1. >> >> > > Thanks. >> >> > You probably just need to reindex a table. Try vacuuming each table >> > individually until you get this error, or just check the vacuum log >> > output to identify it, then just run a REINDEX on it. >> >> xy=# reindex table xy_data; >> ERROR: concurrent insert in progress > > Should I drop and recreate indexes? > That might be a good idea. Use the CREATE INDEX CONCURRENTLY command to prevent that previous error message from appearing. Regards Thom
Tech 2010 <tch072@gmail.com> writes:
>> xy=# reindex table xy_data;
>> ERROR: �concurrent insert in progress
> Should I drop and recreate indexes?
I think that database is pretty well hosed. (What happened to it to
cause all this, anyway?) A dump/initdb/reload is probably indicated
at this point.
regards, tom lane
On 19 nov., 16:36, t...@sss.pgh.pa.us (Tom Lane) wrote: > Tech 2010 <tch...@gmail.com> writes: > >> xy=# reindex table xy_data; > >> ERROR: concurrent insert in progress > > Should I drop and recreate indexes? > > I think that database is pretty well hosed. (What happened to it to > cause all this, anyway?) A dump/initdb/reload is probably indicated > at this point. reindex did not help. pg_dump crashes and select * into new_tables crashes as well. Any idea? Thanks.
What is this? PANIC: corrupted item lengths: total 8192, available space 8068
On 29 nov., 07:02, Tech 2010 <tch...@gmail.com> wrote: > What is this? > > PANIC: corrupted item lengths: total 8192, available space 8068 for the others... find the selected row and replace/delete it....