pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.





view thread (16+ messages)  latest in thread

Message-ID: <2348.66.106.27.14.1070571171.squirrel@matth.zeut.net>
Permalink:  ../2348.66.106.27.14.1070571171.squirrel@matth.zeut.net/
Also on:    postgresql.org/message-id/2348.66.106.27.14.1070571171.squirrel@matth.zeut.net

 · 

reply

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