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

[Richard V. <ric...@va...>]

Emmanuel,

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.

      2009-05-14 16:26:40,663 DEBUG DatabaseBackend.alfresco.mysql1  
Failed to get stored procedure semantics from database backend (Table  
'alfresco.sequoiaSABase' doesn't exist)
      com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table  
'alfresco.sequoiaSABase' doesn't exist

Again I want to thank you for your time,

Richard




On May 14, 2009, at 3:36 PM, Emmanuel Cecchet wrote:

> Richard,
>
>>   2- The query that blocks in Sequoia's write request queue is  
>> slightly different in Sequoia than in direct MySQL:
>>            In mysql: insert into alf_attributes (version, acl_id,  
>> type) values (0, null, 'M')
>>            In Sequoia: insert into alf_attributes (version, acl_id,  
>> type) values (?, ?, 'M') | <!%L|0|!%><!%N|-5|!%>
> Actually it's the same query. The %N tag is to encode null so that  
> the code called is PreparedStatement.setNull(param, sqlType) with  
> sqlType being equal to -5 (which corresponds to BIGINT in  
> java.sql.Types). In both cases, you are exactly executing the same  
> query.
>
> Otherwise your configuration seems fine so we probably have to look  
> somewhere else.
> Set the scheduler, loadbalancer and DatabaseBackend loggers to DEBUG  
> in log4j.properties and send the trace so that we can see what is  
> going on.
>
> Thanks for your feedback,
> Emmanuel
>
> -- 
> Emmanuel Cecchet
> FTO @ Frog Thinker Open Source Development & Consulting
> --
> Web: http://www.frogthinker.org
> email: ma...@fr...
> Skype: emmanuel_cecchet
>