db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Manjula Kutty" <manjula.ku...@gmail.com>
Subject Re: Strange exception during simple insert statement
Date Tue, 31 Jul 2007 19:47:47 GMT
Hi John,

You can find some information regarding the locking issue here

http://db.apache.org/derby/faq.html#debug_lock_timeout

If you still have questions, please let me know

Thanks
Manjula


On 7/31/07, John C. Turnbull <ozemale@ozemail.com.au> wrote:
>
>  I have been getting some spurious exceptions in a 10.2.2.0 embedded
> database namely:
>
>
>
> State = 40XL1, Message = A lock could not be obtained within the time
> requested, Code = 3000
>
>
>
> during a simple insert statement like
>
>
>
> INSERT INTO TableA(id, name, createTime) VALUES (1, 'Name', CURRENT
> TIMESTAMP)
>
>
>
> where id is an int, name is a varchar and createTime is a timestamp.
>
>
>
> It has only happened twice and the problems went away by themselves after
> restarting the database three times but I am concerned that they will come
> back.
>
>
>
> Can anyone suggest why these might be happening and what to do about
> them?  The Derby reference manual doesn't shed any more light on this
> exception unfortunately.
>
>
>
> And loving it,
>
>
>
> John C. Turnbull
>



-- 
Thanks,
Manjula.

Mime
View raw message