| 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 |
| Post date | 2014-09-21T19:05:40Z |
21.09.2014 20:46, Mark Rotteveel wrote:
blocks concurrent inserts into some index.
Selecting from MON$TRANSACTIONS may give an idea when and by whom that
"stuck" transaction was started.
Dmitry
> I don't know enough about reading below The Firebird stacktraces, but itMore precisely, they're waiting for active transaction # 17348466 that
> looks like apart for process 14830 that they are all waiting for a lock.
blocks concurrent inserts into some index.
Selecting from MON$TRANSACTIONS may give an idea when and by whom that
"stuck" transaction was started.
Dmitry