From: Matthew T. O'Connor <matthew@zeut.net>
To: khera@kcilink.com
Cc: pgsql-performance@postgresql.org
Subject: Re: autovacuum daemon stops doing work after about an hour
Date: Thu, 4 Dec 2003 15:52:51 -0500 (EST)
Message-ID: <2348.66.106.27.14.1070571171.squirrel@matth.zeut.net> (raw)
In-Reply-To: <x7wu9cid06.fsf@yertle.int.kciLink.com>
References: <16332.63508.196365.801418@yertle.int.kciLink.com>
<1070516326.1455.11.camel@zedora.zeut.net>
<x7wu9cid06.fsf@yertle.int.kciLink.com>
>>>>>> "MTO" == Matthew T O'Connor <matthew@zeut.net> writes:
>
> MTO> I don't run FreeBSD, so I haven't tested with FreeBSD. Recently
> Craig MTO> Boston reported and submitted a patch for a crash on FreeBSD,
> but that
>
> some more debugging data:
>
> (gdb) print now
> $2 = {tv_sec = 1070565077, tv_usec = 216477}
> (gdb) print then
> $3 = {tv_sec = 1070561568, tv_usec = 668963}
> (gdb) print diff
> $4 = -5459981371352
> (gdb) print sleep_secs
> $5 = -1272
>
> so for some reason, instead of calculating 3508547514 as the diff, it
> got a hugely negative number.
>
> I'll bet it has something to do with the compiler... more debugging to
> follow (without -O compilation...)
Could this be the recently reported bug where time goes backwards on
FreeBSD? Can anyone who knows more about this problem chime in, I know it
was recently discussed on Hackers.
The simple fix is to just make sure it's a positive number. If not, then
just sleep for some small positive amount. I can make a patch for this,
probably sometime this weekend.
Thanks for tracking this down.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: matthew@zeut.net, khera@kcilink.com
Subject: Re: autovacuum daemon stops doing work after about an hour
In-Reply-To: <2348.66.106.27.14.1070571171.squirrel@matth.zeut.net>
References: <16332.63508.196365.801418@yertle.int.kciLink.com> <1070516326.1455.11.camel@zedora.zeut.net> <x7wu9cid06.fsf@yertle.int.kciLink.com> <2348.66.106.27.14.1070571171.squirrel@matth.zeut.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox