[Postgres-xc-general] pgxc seems to be running into a deadlock

[Sandeep G. <gup...@gm...>]

Hi,

 I was debugging an outstanding issue with pgxc (
http://sourceforge.net/mailarchive/forum.php?thread_name=CABEZHFtr_YoWb22UAnPGQz8M5KqpwzbviYiAgq_%3DY...@ma...&forum_name=postgres-xc-general).


I couldn't reproduce that error. But I do get this error.


LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
LOG:  sending cancel to blocking autovacuum PID 17222
DETAIL:  Process 13896 waits for AccessExclusiveLock on relation 16388 of
database 12626.
STATEMENT:  drop index mdn
ERROR:  canceling autovacuum task
CONTEXT:  automatic analyze of table "postgres.public.la_directednetwork"
PreAbort Remote


It seems to be a deadlock issue and may be related to the earlier problem
as well.
Please let me know your comments.

-Sandeep