Voltar
-
Título
select * from table results in lock which cannot be released -
Descrição
Select * from table results in lock which cannot be released.
Tools | Options | Database | General:
- Number = 1000
- Apply to editor is checked
- Commit after each statement is checkedselect * from large_table shows 1000 rows and the query is cancelled automatically.. This can cause an exclusive lock on the tables involved.ÂIn DB2M query shows as "Last operaton = SQL Static Commit" and "Locks currently held = 4".ÂA Load started by a different user then fails because of deadlock.ÂSometimes "Disconnect all" resolves the problem, sometimes it doesn't.
Login necessário
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.