Subject Re: Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to
Author Dmitry Yemanov
21.09.2014 20:46, Mark Rotteveel wrote:

> I don't know enough about reading below The Firebird stacktraces, but it
> looks like apart for process 14830 that they are all waiting for a lock.

More precisely, they're waiting for active transaction # 17348466 that
blocks concurrent inserts into some index.

Selecting from MON$TRANSACTIONS may give an idea when and by whom that
"stuck" transaction was started.