Re: [Sequoiadb-discuss] Request blocked forever in Sequoia

[Emmanuel C. <ma...@fr...>]

Hi Richard,

> I'm sending you the debug log of the problem.
> I noticed that an error that repeatedly occurs about table 
> 'alfresco.sequoiaSABase' does not exists. In fact I don't know where 
> this comes from because there is no reference to such a table anywhere 
> in our modules.
This was a prototype implementation of stored procedure semantic in the 
database that has been deprecated. The message was not removed but it 
can be safely ignored.

The problem comes from there:
2009-05-14 16:26:55,338 WARN  backend.DatabaseBackend.mysql1 Task 
execution failed (java.sql.SQLException: Backend mysql1 does not support 
auto generated keys.)

What is strange is that the error does not get propagated back to the 
client and get stuck.

It might well be that your version of MySQL does not support generated 
keys or that the JDBC driver is not compliant to the spec and when we 
test Statement.getGeneratedKeys() it throws an exception rather than 
returning a null ResultSet.

Which version of MySQL are you using, with which driver?

Thanks for the feedback,
Emmanuel

-- 
Emmanuel Cecchet
FTO @ Frog Thinker 
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: ma...@fr...
Skype: emmanuel_cecchet