Re: DDTP stats is not updated anymore.
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
<kleptog@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 <yuray@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-REQUEST@lists.debian.org
>> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>>
>>
>
>
>
> --
> Martijn van Oosterhout <kleptog@gmail.com> http://svana.org/kleptog/
>
--
Martijn van Oosterhout <kleptog@gmail.com> http://svana.org/kleptog/
Reply to: