lock timeout on an insert with auto-id

[gordon wilcox]

Hi - can anyone answer  my question - I have serched Jira but cant find
the answer.

In March 08 there was discussion about a timeout that occurred when
processing lots of Inserts, when the ID of the row was auto. This caused
a lock timeout in syscolumns.

My question is simple - has this issue been resolved or a satisfactory
'workaround' developed in the latest 10.5 release of Derby.

Regards
Gordon Wilcox

[Knut Anders Hatlen]

gordon wilcox <gordon@...> writes:

> Hi - can anyone answer  my question - I have serched Jira but cant
> find the answer.
>
> In March 08 there was discussion about a timeout that occurred when
> processing lots of Inserts, when the ID of the row was auto. This
> caused a lock timeout in syscolumns.
>
> My question is simple - has this issue been resolved or a satisfactory
> workaround' developed in the latest 10.5 release of Derby.

Hi Gordon,

I don't remember that discussion, but no changes have been made in that
area lately as far as I can recall. If you could file a bug report in
JIRA with the specifics of the problem, the chances that someone picks
it up and fixes it will increase.

Thanks,

--
Knut Anders