Home > database >  Gbase 8 a manual unlock method
Gbase 8 a manual unlock method

Time:01-05

Often found in using gbase 8 a process SQL statements deal with checking the state of the permission, and no other SQL statements in the table; Is caused by the table has the lock;
Can through the following way processing
A, gcadmin showlock | grep tb_name lock condition can be obtained
Second, through the python interface to get the details of the lock and unlock, specific operation is as follows:
1, python
2, the import gcware
3, gcware getlocks ()
4, gcware. Unlocktableforce (' lock name ', 'lock ID)

  • Related