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 <klep...@gmail.com> 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 <yu...@komyakino.ru> 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 debian-i18n-requ...@lists.debian.org >> with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org >> >> > > > > -- > Martijn van Oosterhout <klep...@gmail.com> http://svana.org/kleptog/ > -- Martijn van Oosterhout <klep...@gmail.com> http://svana.org/kleptog/ -- To UNSUBSCRIBE, email to debian-i18n-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
