Re: BDR: ALTER statement hanging - Mailing list pgsql-general

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 

------------------------------------------+--------+-----------+--------+----------+--------+------+--------------+-------------
 bdr_533136_6223770712502831127_1_16389__ | bdr    | logical   | 533136 | deliver  | t      |      |       182302 |
0/9C8A5598  
 bdr_533136_6223800735012265413_1_16389__ | bdr    | logical   | 533136 | deliver  | t      |      |       182302 |
0/9C8A5598  
(2 rows)

Although when I look at bdr.bdr_nodes I see the status as still initializing for the other two nodes, I don't know if
thatcould cause this problem: 

deliver=# select * from bdr.bdr_nodes;
     node_sysid      | node_timeline | node_dboid | node_status |              node_name              |
                           node_local_dsn 
                                         |                                          node_init_from_dsn

---------------------+---------------+------------+-------------+-------------------------------------+---------------------------------------------------------------

-----------------------------------------+------------------------------------------------------------------------------------------------------
 6212648563684174798 |             1 |     533136 | r           | pe-deliverdb-sf-01v | host=pe-deliverdb-sf-01v
port=5432dbname=deliver user=deliver_admin password=xxxxx   | 
 6223770712502831127 |             1 |      16389 | i           | pe-deliverdb-sing-01v | host=pe-deliverdb-sing-01v
port=5432dbname=deliver user=deliver_admin password=xxxxx | host=pe-deliverdb-sf-01v port=5432 dbname=deliver
user=deliver_adminpassword=xxxxx 
 6223800735012265413 |             1 |      16389 | i           | pe-deliverdb-lon-01v | host=pe-deliverdb-lon-01v
port=5432dbname=deliver user=deliver_admin password=xxxxx  | host=pe-deliverdb-sf-01v port=5432 dbname=deliver
user=deliver_adminpassword=xxxxx 

-Selim

________________________________________
From: pgsql-general-owner@postgresql.org [pgsql-general-owner@postgresql.org] on behalf of Andreas Kretschmer
[akretschmer@spamfence.net]
Sent: Thursday, December 03, 2015 10:49 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] BDR: ALTER statement hanging

Selim Tuvi <stuvi@ilm.com> 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 MUST be active in replication, so have you
checked that in pg_replication_slots?



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general