--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

> >As far as I can tell, there are no open transactions when the hang
> >occurs. isc_start_transaction is called with this TPB:
> >
> > static char transParamBuf[] =
> > {
> > isc_tpb_version3, // Version, always 3
> > isc_tpb_write, // Read-write access
> > isc_tpb_concurrency, // Concurrency-mode transaction
> > isc_tpb_read_committed, // High throughput, high

concurrency transaction

> > isc_tpb_wait // Wait on lock
> > };
> >
> >The "wait on lock" looks suspicious, but where could a lock be held
> >except in another transaction?
>
> Well, at least one has to wonder why a wait transaction is used in a

single-user scenario....

Multiple threads? Altho in this particular situation there is only
one. In which case, the wait shouldn't matter, since it won't happen.

> but I'd be more dubious about a TPB that tries to start with two

isolation levels!!

What values would be more appropriate here?