postgresql-xl 无法删除表
在Coordinator上执行删表操作
postgres=# drop table graph.r_credit_info;
过程一直卡着,查看Coordinator上的锁,发现这个语句已经拿到这个对象的AccessExclusiveLock锁
postgres=# select locktype,pid,relation,virtualtransaction,mode,granted from pg_locks where relation='16420';
locktype | pid | relation | virtualtransaction | mode | granted
----------+-------+----------+--------------------+---------------------+---------
relation | 64075 | 16420 | 97/766 | AccessExclusiveLock | t
(1 row)
但是在多个datanode上都发现有个没有pid的行级排它锁阻塞了这个ddl语句
postgres=# select locktype,pid,relation,virtualtransaction,mode,granted from pg_locks where relation='16420';
locktype | pid | relation | virtualtransaction | mode | granted
----------+-------+----------+--------------------+---------------------+---------
relation | 60435 | 16420 | 141/27963 | AccessExclusiveLock | f
relation | | 16420 | -1/31739584 | RowExclusiveLock | t
(2 rows)
尝试过重启集群,这个没有pid的行级排他锁一直存在。
现在这个表只能进行dml操作,但是无法进行ddl操作,各路大神有没有解决的思路?在线等!