Dbeaver locking table

Note: please leave bug reports and feature requests on

Dbeaver locking table

Postby davide » Tue Feb 02, 2016 4:11 pm

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?
davide
 
Posts: 1
Joined: Tue Feb 02, 2016 4:06 pm

Re: Dbeaver locking table

Postby Serge » Wed Feb 10, 2016 9:35 pm

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Support



Who is online

Users browsing this forum: No registered users and 4 guests