Re: ALTER statement hanging
| От | Selim Tuvi |
|---|---|
| Тема | Re: ALTER statement hanging |
| Дата | |
| Msg-id | D702486C6BC79C40A9C6FF4F0315ABC035966A@mailbox09.lucas.alllucas.com обсуждение исходный текст |
| Ответ на | Re: ALTER statement hanging (Selim Tuvi <stuvi@ilm.com>) |
| Список | pgsql-general |
I stopped the other two nodes and restarted the instance and pg_locks shows the following.
deliver=# select * from pg_locks;
locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted |
fastpath
------------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-------+-----------------+---------+-
---------
relation | 533136 | 11189 | | | | | | | | 5/68 | 10229 | AccessShareLock | t |
t
virtualxid | | | | | 5/68 | | | | | 5/68 | 10229 | ExclusiveLock | t |
t
(2 rows)
-Selim
deliver=# select * from pg_locks;
locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted |
fastpath
------------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-------+-----------------+---------+-
---------
relation | 533136 | 11189 | | | | | | | | 5/68 | 10229 | AccessShareLock | t |
t
virtualxid | | | | | 5/68 | | | | | 5/68 | 10229 | ExclusiveLock | t |
t
(2 rows)
-Selim
From: pgsql-general-owner@postgresql.org [pgsql-general-owner@postgresql.org] on behalf of Selim Tuvi [stuvi@ilm.com]
Sent: Thursday, December 03, 2015 4:31 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] ALTER statement hanging
Sent: Thursday, December 03, 2015 4:31 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] ALTER statement hanging
And I tried running the same statement on another node, while one node was running it and I got the following:
ERROR: database is locked against ddl by another node
HINT: Node (6223770712502831127,1,16389) in the cluster is already performing DDL
Terminating the statement in one node and running it on another results in a hang as well.
-Selim
ERROR: database is locked against ddl by another node
HINT: Node (6223770712502831127,1,16389) in the cluster is already performing DDL
Terminating the statement in one node and running it on another results in a hang as well.
-Selim
From: Selim Tuvi
Sent: Thursday, December 03, 2015 4:03 PM
To: pgsql-general@postgresql.org
Subject: BDR: ALTER statement hanging
Sent: Thursday, December 03, 2015 4:03 PM
To: pgsql-general@postgresql.org
Subject: BDR: ALTER statement hanging
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:
alter table pts alter column shot drop not null;
I also tried to add a column but that hangs as well:
alter table pts add column shot_tmp text;
Thanks
-Selim
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:
alter table pts alter column shot drop not null;
I also tried to add a column but that hangs as well:
alter table pts add column shot_tmp text;
Thanks
-Selim
В списке pgsql-general по дате отправления: