Re: Email not searchable in our archives

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.=) $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] =>
0,[1] => 1183059217,[2] => PostgreSQL & our ML,[3] => Mohsen
Pahlevanzadeh <mohsen@pahlevanzadeh.org>,[4] =>

سلام بر دوستان فارسی زبان،
این ایمیل رو زدم تا چند تا نÚ(c)ته رو یاد
آور بشم:
۱. قراره فارسی نوشته بشه.
Û². قراره جایی بشه تا Ú(c)اربرای pg دیگه
نرن رو ML های زبان‌های دیگه پست
بگذارند.

۳. ترویج DB های FOSSی در ایران.
۴. اگر بشه ترجمه Doc اون به فارسی
--محسن
--
-------------------------
Mohsen Pahlevanzadeh
email address : mohsen ( at ) pahlevanzadeh ( dot ) org
web site : http://pahlevanzadeh.org
IRC IM : m_pahlevanzadeh
yahoo IM : linuxorbsd
----------------------------



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

سلام بر دوستان فارسی زبان،
این ایمیل رو زدم تا چند تا نÚ(c)ته رو یاد
آور بشم:
۱. قراره فارسی نوشته بشه.
Û². قراره جایی بشه تا Ú(c)اربرای pg دیگه
نرن رو ML های زبان‌های دیگه پست
بگذارند.

۳. ترویج DB های FOSSی در ایران.
۴. اگر بشه ترجمه Doc اون به فارسی
--محسن
--
-------------------------
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....

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