public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dave Page <[email protected]>
To: Tom Lane <[email protected]>
Cc: Alvaro Herrera <[email protected]>
Cc: Bruce Momjian <[email protected]>
Cc: PostgreSQL www <[email protected]>
Cc: Stefan Kaltenbrunner <[email protected]>
Subject: Re: Email not searchable in our archives
Date: Wed, 12 Mar 2008 16:43:09 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

On Wed, Mar 12, 2008 at 4:06 PM, Tom Lane <[email protected]> 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 <[email protected]>,[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

view thread (51+ messages)  latest in thread

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 using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Email not searchable in our archives
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox