Yep, there appears to be some true database corruption: ddtp=> select xmin,xmax,cmin,cmax,description_tag_id,description_id,ctid from description_tag_tb where ctid > '(918,216)' and ctid<'(918,219)'; xmin | xmax | cmin | cmax | description_tag_id | description_id | ctid -----------+------------+------+------+--------------------+----------------+----------- 203113489 | 1702520064 | 6 | 6 | 203113489 | 1702520064 | (918,217) 203113631 | 209615949 | 0 | 0 | 203113631 | 209615949 | (918,218) (2 rows)
Those values are clearly bunk and trying to display the tags for those rows causes the errors. To fix this properly requires someone with admin (root) privileges since you can't delete the rows either. However, I'm going to try to recover the table another way. Have a nice day, On Tue, Mar 3, 2009 at 10:32 PM, Martijn van Oosterhout <[email protected]> wrote: > Hmm, running the scripts by hand gives a corruption error: > > DBD::Pg::st execute failed: ERROR: compressed data is corrupt at > /home/kleptog/stats/ddts-stats line 269. > > Which is quite weird... That indicates some kind of database > corruption but I don't think anything happened on that machine at the > time. > > I'll see what I can do to fix it. > > Have a nice day, > > On Tue, Mar 3, 2009 at 6:55 PM, Yuri Kozlov <[email protected]> wrote: >> Hello. >> >> Last update of the http://ddtp.debian.net/stats/stats-sid.html is >> 2009-02-26 14:21:12 CET (+0100). >> >> Anybody can fix this? >> >> -- >> Best Regards, >> Yuri Kozlov >> >> >> -- >> To UNSUBSCRIBE, email to [email protected] >> with a subject of "unsubscribe". Trouble? Contact [email protected] >> >> > > > > -- > Martijn van Oosterhout <[email protected]> http://svana.org/kleptog/ > -- Martijn van Oosterhout <[email protected]> http://svana.org/kleptog/ -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
