[GENERAL] Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227

2009-12-02 Thread Tech 2010
On 29 nov., 07:02, Tech 2010 wrote: > What is this? > > PANIC:  corrupted item lengths: total 8192, available space 8068 for the others... find the selected row and replace/delete it -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227

2009-11-29 Thread Tech 2010
What is this? PANIC: corrupted item lengths: total 8192, available space 8068 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227

2009-11-28 Thread Tech 2010
On 19 nov., 16:36, t...@sss.pgh.pa.us (Tom Lane) wrote: > Tech 2010 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 dum

Re: [GENERAL] Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227

2009-11-19 Thread Tom Lane
Tech 2010 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.

Re: [GENERAL] Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227

2009-11-19 Thread Thom Brown
2009/11/19 Tech 2010 : > On 18 nov., 16:48, Tech 2010 wrote: >> On 18 nov., 13:40, thombr...@gmail.com (Thom Brown) wrote:> 2009/11/18 Tech >> 2010 : >> >> > > Hello! >> >> > > How do I location of this pointer and how do I zero it so I can access >> > > the rest of the data? >> >> > > "zero_dama

[GENERAL] Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227

2009-11-19 Thread Tech 2010
On 18 nov., 16:48, Tech 2010 wrote: > On 18 nov., 13:40, thombr...@gmail.com (Thom Brown) wrote:> 2009/11/18 Tech > 2010 : > > > > 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

[GENERAL] Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227

2009-11-18 Thread Tech 2010
On 18 nov., 13:40, thombr...@gmail.com (Thom Brown) wrote: > 2009/11/18 Tech 2010 : > > > 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