Re: BDR: ALTER statement hanging

> Selim Tuvi <stuvi(at)ilm(dot)com> 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
> ------------------------------------------+--------+-----------+--------+----------+--------+------+--------------+-------------
> 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 that could 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=5432 dbname=deliver
> user=deliver_admin password=xxxxx |
> 6223770712502831127 | 1 | 16389 | i |
> pe-deliverdb-sing-01v | host=pe-deliverdb-sing-01v port=5432 dbname=deliver
> user=deliver_admin password=xxxxx | host=pe-deliverdb-sf-01v port=5432
> dbname=deliver user=deliver_admin password=xxxxx
> 6223800735012265413 | 1 | 16389 | i |
> pe-deliverdb-lon-01v | host=pe-deliverdb-lon-01v port=5432 dbname=deliver
> user=deliver_admin password=xxxxx | host=pe-deliverdb-sf-01v port=5432
> dbname=deliver user=deliver_admin password=xxxxx
>
> -Selim
>

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