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

[Koichi S. <koi...@gm...>]

Did you configure XC cluster manually?   Then could you share how you did?

To save your effort, pgxc_ctl provides simpler way to configure and
run XC cluster.   It is a contrib module and the document will be
found at http://postgres-xc.sourceforge.net/docs/1_1/pgxc-ctl.html

Regards;
---
Koichi Suzuki


2014-02-01 Sandeep Gupta <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
>
>
> ------------------------------------------------------------------------------
> WatchGuard Dimension instantly turns raw network data into actionable
> security intelligence. It gives you real-time visual feedback on key
> security issues and trends.  Skip the complicated setup - simply import
> a virtual appliance and go from zero to informed in seconds.
> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>