KADB锁冲突查看及解决

test=# select * from gp_toolkit.gp_locks_on_relation where lorrelname like '%data_table%';

 lorlocktype | lordatabase | lorrelname | lorrelation | lortransaction | lorpid |       lormode       | lorgranted |                lorcurrentque

ry                

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

 relation    |       18097 | data_table |       18334 |                |   3059 | AccessExclusiveLock | f          | alter table data_table add t

est varchar(20);

 relation    |       18097 | data_table |       18334 |                |   3055 | AccessShareLock     | t          | update data_table set addr='

test' where id=89;

 relation    |       18097 | data_table |       18334 |                |   3055 | ExclusiveLock       | t          | update data_table set addr='

test' where id=89;

(3 rows)

上一篇:关于未成年人玩游戏充值的小讨论