Page 1 of 1

Dbeaver locking table

PostPosted: Tue Feb 02, 2016 4:11 pm
by davide
Hey guys occurred multiple times where dbeaver is creating a table lock, I think happens when I edit a field, can't replicate it though is very occasional, db connection were all production type, any idea?

Re: Dbeaver locking table

PostPosted: Wed Feb 10, 2016 9:35 pm
by Serge
When you work in transactional mode and perform any table data modification table becomes locked on database-side. It is not a DBeaver issue.
To release lock you need to commit or rollback current transaction.

Actually this behavior depends on transactions isolation level. For instance default isolation for MySQL is "repeatable read" and it works like this.