Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id DE0809FC314 for ; Thu, 9 Aug 2007 18:55:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 79708-03-3 for ; Thu, 9 Aug 2007 18:55:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 12CE69FBEBA for ; Thu, 9 Aug 2007 18:55:08 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id EB5A956448; Thu, 9 Aug 2007 16:55:06 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Thu, 9 Aug 2007 16:55:04 -0500 Date: Thu, 9 Aug 2007 16:55:04 -0500 From: Decibel! To: Magnus Hagander Cc: pgsql-www@postgresql.org Subject: Re: Archive search seems borked Message-ID: <20070809215504.GD20424@nasby.net> References: <20070808215624.GW20424@nasby.net> <20070809080843.GD20437@svr2.hagander.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="L977DYpOHGH1NqKf" Content-Disposition: inline In-Reply-To: <20070809080843.GD20437@svr2.hagander.net> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070809:magnus@hagander.net::lH4NHVCWNa5ETOth:000000000000000000 0000000000000000000000002Zfh X-Hashcash: 1:20:070809:pgsql-www@postgresql.org::6/H/PpCIxYP5tXky:0000000000000 0000000000000000000000007Yp5 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/110 X-Sequence-Number: 12351 --L977DYpOHGH1NqKf Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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: > >=20 > > http://archives.postgresql.org/pgsql-general/2007-08/msg00343.php >=20 > 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 connectio= ns > properly. >=20 > 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 agai= n. Search is pretty critical... can we setup some kind of monitoring for it? --=20 Decibel!, aka Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --L977DYpOHGH1NqKf Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFGu404dO30qud8SkgRAivvAJ9bkLZ84Uh66ZEq2uy0NBH62dvs6ACg1/t7 tPFbibSaSiSbVnS1fq9M/uU= =99u8 -----END PGP SIGNATURE----- --L977DYpOHGH1NqKf--