Postgres Pro
Downloads
Home   >   mailing lists

Thread: Archive search seems borked

Archive search seems borked

From
Decibel!
Date:
Something's wrong with archive searching. I can't find this message
anywhere through search if I specify a post date of within the last
week:

http://archives.postgresql.org/pgsql-general/2007-08/msg00343.php
--
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Re: Archive search seems borked

From
Magnus Hagander
Date:
On Wed, Aug 08, 2007 at 04:56:24PM -0500, Decibel! wrote:
> Something's wrong with archive searching. I can't find this message
> anywhere through search if I specify a post date of within the last
> week:
> 
> http://archives.postgresql.org/pgsql-general/2007-08/msg00343.php

The indexer was stuck indexing pgfoundry based sites. It hung one of the
times the hub.org datanceter dropped, seems PHP didn't time out connections
properly.

I kicked it in the head and it's reindexing now. Should be done in a
minute or two - general is done, and searches for that mail shows up again.

//Magnus

Re: Archive search seems borked

From
Decibel!
Date:
On Thu, Aug 09, 2007 at 10:08:43AM +0200, Magnus Hagander wrote:
> On Wed, Aug 08, 2007 at 04:56:24PM -0500, Decibel! wrote:
> > Something's wrong with archive searching. I can't find this message
> > anywhere through search if I specify a post date of within the last
> > week:
> >
> > http://archives.postgresql.org/pgsql-general/2007-08/msg00343.php
>
> The indexer was stuck indexing pgfoundry based sites. It hung one of the
> times the hub.org datanceter dropped, seems PHP didn't time out connections
> properly.
>
> I kicked it in the head and it's reindexing now. Should be done in a
> minute or two - general is done, and searches for that mail shows up again.

Search is pretty critical... can we setup some kind of monitoring for
it?
--
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Re: Archive search seems borked

From
"Magnus Hagander"
Date:
> > > Something's wrong with archive searching. I can't find this message
> > > anywhere through search if I specify a post date of within the last
> > > week:
> > > 
> > > http://archives.postgresql.org/pgsql-general/2007-08/msg00343.php
> > 
> > The indexer was stuck indexing pgfoundry based sites. It hung one of the
> > times the hub.org datanceter dropped, seems PHP didn't time out connections
> > properly.
> > 
> > I kicked it in the head and it's reindexing now. Should be done in a
> > minute or two - general is done, and searches for that mail shows up again.
> 
> Search is pretty critical... can we setup some kind of monitoring for
> it?

Yeah, working on that already.

/Magnus

Re: Archive search seems borked

From
Stefan Kaltenbrunner
Date:
Decibel! wrote:
> On Thu, Aug 09, 2007 at 10:08:43AM +0200, Magnus Hagander wrote:
>> On Wed, Aug 08, 2007 at 04:56:24PM -0500, Decibel! wrote:
>>> Something's wrong with archive searching. I can't find this message
>>> anywhere through search if I specify a post date of within the last
>>> week:
>>>
>>> http://archives.postgresql.org/pgsql-general/2007-08/msg00343.php
>> The indexer was stuck indexing pgfoundry based sites. It hung one of the
>> times the hub.org datanceter dropped, seems PHP didn't time out connections
>> properly.
>>
>> I kicked it in the head and it's reindexing now. Should be done in a
>> minute or two - general is done, and searches for that mail shows up again.
> 
> Search is pretty critical... can we setup some kind of monitoring for
> it?

we are monitoring it on a general base - filed a ticket for magnus to
improve the indexer check more closely about 30min after he reported the
fix ...


Stefan