Jeff Frost jeff at frostconsultingllc.com
Mon Oct 1 12:29:52 PDT 2007
On Fri, 28 Sep 2007, Christopher Browne wrote:

> If you could check as to what relation it was reporting it deadlocked
> on (e.g. - "select * from pg_class where oid = [relation number that
> was in the log];"), that would be somewhat interesting to know.  If it
> was a Slony-I-created table, and you have reinitialized replication,
> then you won't be able to find out :-(.
>
> I would expect to find it somewhat surprising which relation this was.

Hooray on the fix.

But, I wasn't surprised at all to find out what was causing the deadlock as it 
was the products and man tables which were being used in the search queries. 
:-(


-- 
Jeff Frost, Owner 	<jeff at frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954


More information about the Slony1-bugs mailing list