Re: [GENERAL] BDR: ALTER statement hanging

2015-12-08 Thread Selim Tuvi
x27;t result in any log messages and the replication was working as it should. -Selim From: Craig Ringer [cr...@2ndquadrant.com] Sent: Sunday, December 06, 2015 7:05 PM To: Selim Tuvi Cc: Sylvain MARECHAL; pgsql-general@postgresql.org Subject: Re: [GENERAL] BDR:

Re: [GENERAL] BDR: ALTER statement hanging

2015-12-06 Thread Craig Ringer
​If you're not sure what's going on on a node, look at its logs. The background worker API and PostgreSQL's lack of autonomous transactions makes it quite challenging for BDR workers to capture logs and expose them to users at the SQL level. So always, if in doubt, examine the log files.

Re: [GENERAL] BDR: ALTER statement hanging

2015-12-04 Thread Selim Tuvi
-general@postgresql.org Subject: Re: [GENERAL] BDR: ALTER statement hanging Le 04/12/2015 18:59, Andreas Kretschmer a écrit : > > > I think, the state 'i' is the main reason for your problem, because of: "i- > Joining: The node is doing initial slot creation or an initia

Re: [GENERAL] BDR: ALTER statement hanging

2015-12-04 Thread Selim Tuvi
[pgsql-general-ow...@postgresql.org] on behalf of Andreas Kretschmer [andr...@a-kretschmer.de] Sent: Friday, December 04, 2015 9:59 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] BDR: ALTER statement hanging > Selim Tuvi hat am 4. Dezember 2015 um 18:46 geschrieben: > > &

Re: [GENERAL] BDR: ALTER statement hanging

2015-12-04 Thread Sylvain MARECHAL
Le 04/12/2015 18:59, Andreas Kretschmer a écrit : I think, the state 'i' is the main reason for your problem, because of: "i- Joining: The node is doing initial slot creation or an initial dump and load". But i can't tell you why this nodes are in this state. Regards, Andreas Did-you chec

Re: [GENERAL] BDR: ALTER statement hanging

2015-12-04 Thread Andreas Kretschmer
> Selim Tuvi hat am 4. Dezember 2015 um 18:46 geschrieben: > > > Yes they seem to be active: > > deliver=# select * from pg_replication_slots; > slot_name | plugin | slot_type | datoid | > database | active | xmin | catalog_xmin | restart_lsn > ---

Re: [GENERAL] BDR: ALTER statement hanging

2015-12-04 Thread Selim Tuvi
Selim From: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql.org] on behalf of Andreas Kretschmer [akretsch...@spamfence.net] Sent: Thursday, December 03, 2015 10:49 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] BDR: ALTER stat

Re: [GENERAL] BDR: ALTER statement hanging

2015-12-03 Thread Andreas Kretschmer
Selim Tuvi wrote: > Hi, I am running a three node BDR cluster. BDR version is 0.9.3. Postgres > version is 9.4.5. > > With 0.9.2, I used to be able to issue ALTER statements using psql and it > would > go through. This time it is just hanging. The statement is this: for ddl-commands all nodes