On Sat Dec 10 16:39:50 2011, Andrus Adamchik wrote:
Could be a bug (in Derby?). Probably worth opening a bug report at 
https://issues.apache.org/jira/browse/CAY ... Also would be helpful if you 
could take a thread dump when the app is frozen to see what the app is doing at 
this moment. IIRC we had people using CreateIfNoSchemaStrategy with Derby, so 
there may be a special case causing this condition.

Andrus

On Dec 8, 2011, at 10:04 PM, Mathias Clerc wrote:

I am using an embedded Derby DB together with Cayenne
CreateIfNoSchemaStrategy feature.

If I start with an empty DB, on the first query the DB is created but
at the moment of actually running the query, Derby freezes waiting for
a lock.
If I use JDBC to manually create the table before the first connection
(manually injecting a copy/paste of the debug output of cayenne), then
the query works perfectly.

Any idea ?



I also recommend searching the Derby Jira database for "deadlock". There are a number of deadlock issues in recent Derby versions. Although I've never seen it in the situation the original poster reported, I've seen other similar deadlocks when trying to alter the schema of a Derby database.

--
-------------------------->
Aristedes Maniatis
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A

Reply via email to