Message-ID: <937d27e10803120943x6cbdc310p624bf37251ae0acd@mail.gmail.com>
Date: Wed, 12 Mar 2008 16:43:09 +0000
From: "Dave Page" <dpage@pgadmin.org>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Subject: Re: Email not searchable in our archives
Cc: "Alvaro Herrera" <alvherre@commandprompt.com>,
	"Bruce Momjian" <bruce@momjian.us>,
	"PostgreSQL www" <pgsql-www@postgresql.org>,
	"Stefan Kaltenbrunner" <stefan@kaltenbrunner.cc>
In-Reply-To: <20051.1205338017@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <200803112135.m2BLZ6625071@momjian.us>
	<20080312130902.GC4926@alvh.no-ip.org>
	<937d27e10803120714h21f1f661s657fad641f35c3d5@mail.gmail.com>
	<937d27e10803120825k67fc19c1h27f977a8038dfdd7@mail.gmail.com>
	<19584.1205336481@sss.pgh.pa.us>
	<937d27e10803120904g3198fd51vd4a51a36e556eca7@mail.gmail.com>
	<20051.1205338017@sss.pgh.pa.us>

On Wed, Mar 12, 2008 at 4:06 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

>  OK, that seems to support your theory.  Might as well go ahead and
>  reindex.  +1 for getting some monitoring in there somewhere.

Yeah. Tried that - on the first attempt it died with a deadlock:

----------------
[search@community2 search]$ php archives.php -f
Indexing list 42 (atlpug)
Indexing list 43 (lapug)
Indexing list 41 (pdxpug)
Indexing list 40 (persianpug)
PHP Warning:  pg_execute(): Query failed: ERROR:  deadlock detected
DETAIL:  Process 9245 waits for ShareLock on transaction 378698;
blocked by process 9297.
Process 9297 waits for ShareLock on transaction 378690; blocked by process =
9245.
CONTEXT:  SQL statement "SELECT 1 FROM ONLY "public"."lists" x WHERE
"id" OPERATOR(pg_catalog.=3D) $1 FOR SHARE OF x" in
/home/search/portal/tools/search/classes/SearchDB.class.php on line 60
#0  SearchDB::mydie(Query failed: 0.94209700 1205339104
) called at [/home/search/portal/tools/search/classes/SearchDB.class.php:61=
]
#1  SearchDB::ExecutePrepared(0.94209700 1205339104, Array ([0] =3D>
0,[1] =3D> 1183059217,[2] =3D> PostgreSQL & our ML,[3] =3D> Mohsen
Pahlevanzadeh <mohsen@pahlevanzadeh.org>,[4] =3D>

=D8=B3=D9=84=D8=A7=D9=85 =D8=A8=D8=B1 =D8=AF=D9=88=D8=B3=D8=AA=D8=A7=D9=86 =
=D9=81=D8=A7=D8=B1=D8=B3=DB=8C =D8=B2=D8=A8=D8=A7=D9=86=D8=8C
=D8=A7=DB=8C=D9=86 =D8=A7=DB=8C=D9=85=DB=8C=D9=84 =D8=B1=D9=88 =D8=B2=D8=AF=
=D9=85 =D8=AA=D8=A7 =DA=86=D9=86=D8=AF =D8=AA=D8=A7 =D9=86=DA(c)=D8=AA=D9=
=87 =D8=B1=D9=88 =DB=8C=D8=A7=D8=AF
=D8=A2=D9=88=D8=B1 =D8=A8=D8=B4=D9=85:
=DB=B1. =D9=82=D8=B1=D8=A7=D8=B1=D9=87 =D9=81=D8=A7=D8=B1=D8=B3=DB=8C =D9=
=86=D9=88=D8=B4=D8=AA=D9=87 =D8=A8=D8=B4=D9=87.
=DB=B2. =D9=82=D8=B1=D8=A7=D8=B1=D9=87 =D8=AC=D8=A7=DB=8C=DB=8C =D8=A8=D8=
=B4=D9=87 =D8=AA=D8=A7 =DA(c)=D8=A7=D8=B1=D8=A8=D8=B1=D8=A7=DB=8C pg =D8=AF=
=DB=8C=DA=AF=D9=87
=D9=86=D8=B1=D9=86 =D8=B1=D9=88 ML =D9=87=D8=A7=DB=8C =D8=B2=D8=A8=D8=A7=D9=
=86=E2=80=8C=D9=87=D8=A7=DB=8C =D8=AF=DB=8C=DA=AF=D9=87 =D9=BE=D8=B3=D8=AA
=D8=A8=DA=AF=D8=B0=D8=A7=D8=B1=D9=86=D8=AF.

=DB=B3. =D8=AA=D8=B1=D9=88=DB=8C=D8=AC DB =D9=87=D8=A7=DB=8C FOSS=DB=8C =D8=
=AF=D8=B1 =D8=A7=DB=8C=D8=B1=D8=A7=D9=86.
=DB=B4. =D8=A7=DA=AF=D8=B1 =D8=A8=D8=B4=D9=87 =D8=AA=D8=B1=D8=AC=D9=85=D9=
=87 Doc =D8=A7=D9=88=D9=86 =D8=A8=D9=87 =D9=81=D8=A7=D8=B1=D8=B3=DB=8C
--=D9=85=D8=AD=D8=B3=D9=86
--
-------------------------
Mohsen Pahlevanzadeh
email address : mohsen ( at ) pahlevanzadeh ( dot ) org
web site : http://pahlevanzadeh.org
IRC IM : m_pahlevanzadeh
yahoo IM : linuxorbsd
----------------------------


,[5] =3D> PostgreSQL & our ML,[6] =3D>

=D8=B3=D9=84=D8=A7=D9=85 =D8=A8=D8=B1 =D8=AF=D9=88=D8=B3=D8=AA=D8=A7=D9=86 =
=D9=81=D8=A7=D8=B1=D8=B3=DB=8C =D8=B2=D8=A8=D8=A7=D9=86=D8=8C
=D8=A7=DB=8C=D9=86 =D8=A7=DB=8C=D9=85=DB=8C=D9=84 =D8=B1=D9=88 =D8=B2=D8=AF=
=D9=85 =D8=AA=D8=A7 =DA=86=D9=86=D8=AF =D8=AA=D8=A7 =D9=86=DA(c)=D8=AA=D9=
=87 =D8=B1=D9=88 =DB=8C=D8=A7=D8=AF
=D8=A2=D9=88=D8=B1 =D8=A8=D8=B4=D9=85:
=DB=B1. =D9=82=D8=B1=D8=A7=D8=B1=D9=87 =D9=81=D8=A7=D8=B1=D8=B3=DB=8C =D9=
=86=D9=88=D8=B4=D8=AA=D9=87 =D8=A8=D8=B4=D9=87.
=DB=B2. =D9=82=D8=B1=D8=A7=D8=B1=D9=87 =D8=AC=D8=A7=DB=8C=DB=8C =D8=A8=D8=
=B4=D9=87 =D8=AA=D8=A7 =DA(c)=D8=A7=D8=B1=D8=A8=D8=B1=D8=A7=DB=8C pg =D8=AF=
=DB=8C=DA=AF=D9=87
=D9=86=D8=B1=D9=86 =D8=B1=D9=88 ML =D9=87=D8=A7=DB=8C =D8=B2=D8=A8=D8=A7=D9=
=86=E2=80=8C=D9=87=D8=A7=DB=8C =D8=AF=DB=8C=DA=AF=D9=87 =D9=BE=D8=B3=D8=AA
=D8=A8=DA=AF=D8=B0=D8=A7=D8=B1=D9=86=D8=AF.

=DB=B3. =D8=AA=D8=B1=D9=88=DB=8C=D8=AC DB =D9=87=D8=A7=DB=8C FOSS=DB=8C =D8=
=AF=D8=B1 =D8=A7=DB=8C=D8=B1=D8=A7=D9=86.
=DB=B4. =D8=A7=DA=AF=D8=B1 =D8=A8=D8=B4=D9=87 =D8=AA=D8=B1=D8=AC=D9=85=D9=
=87 Doc =D8=A7=D9=88=D9=86 =D8=A8=D9=87 =D9=81=D8=A7=D8=B1=D8=B3=DB=8C
--=D9=85=D8=AD=D8=B3=D9=86
--
-------------------------
Mohsen Pahlevanzadeh
email address : mohsen ( at ) pahlevanzadeh ( dot ) org
web site : http://pahlevanzadeh.org
IRC IM : m_pahlevanzadeh
yahoo IM : linuxorbsd
----------------------------


)) called at [/home/search/portal/tools/search/classes/ArchiveIndexer.class=
.php:114]
#2  ArchiveIndexer->IndexSinglePage(40, persianpug, 2007, 6, 0) called
at [/home/search/portal/tools/search/classes/ArchiveIndexer.class.php:62]
#3  ArchiveIndexer->IndexMonth(40, persianpug, 2007, 6) called at
[/home/search/portal/tools/search/classes/ArchiveIndexer.class.php:40]
#4  ArchiveIndexer->Index(1, , -1, -1) called at
[/home/search/portal/tools/search/archives.php:28]
Query failed: 0.94209700 1205339104
----------------

Running it again now and it's up to 4000+ messages indexed  (ie. ones
that weren't already indexed) and is still working on pgsql-advocacy.
We'll see how it goes....

--=20
Dave Page
EnterpriseDB UK Ltd: http://www.enterprisedb.com
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk