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

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

Hi Richard,

Can you reproduce the problem systematically?
Could you post your virtual database configuration file?
As the request is executing, it might be blocked on a lock (that would 
be a bug) or waiting for MySQL backends to complete (we would then have 
to figure out why MySQL is blocked).

Do you see any pending request on any MySQL backend (when you log 
directly on MySQL)?
Both backends show as enabled in Sequoia?

Thanks for your feedback,
Emmanuel

> I encounter a strange problem when using Alfresco that uses Hibernate 
> with Sequoia.
> Sequoia is configured with 1 virtual database using 2 MySQL backends.
> What happens is that when Alfresco first starts, it creates its 
> tables successfully, then issues a number of SELECTS successfully and 
> then issues a "INSERT" which gets stuck in Sequoia request queue forever.
>
> Is there anything I can do to find out what Sequoia is waiting for?
>
> Here are the details of the request:
>
> insert into alf_attributes (version, acl_id, type) values (?, ?, 'M'): 
> Id=523, query=insert into alf_attributes (version, acl_id, type) 
> values (?, ?, 'M'), params=<!%L|0|!%><!%N|-5|!%>, transaction id=324, 
> persistent connection id=0
>
> alfresco(admin) > dump scheduler queues 
> Active transactions: 1
> +-----+-------------+
> | tid   | time (in s) | 
> +-----+-------------+
> | 324 | 76247       | 
> +-----+-------------+
>
> ----------------
>
> Pending read requests: 0
> Read request id list:
>
> Pending write requests: 1
> Write request id list:
>  523
>
> ----------------
>
> alfresco(admin) > dump transaction 324
> +--------+----------+-----------------------------------------------------------------------+-----------------------+----------------+----------------+------------+-------------+-----------+--------------+
> | log_id | vlogin   | sqlStmt                                         
>                       | sqlStmt_param         | auto_conn_tran | 
> transaction_id | request_id | exec_status | exec_time | update_count | 
> +--------+----------+-----------------------------------------------------------------------+-----------------------+----------------+----------------+------------+-------------+-----------+--------------+
> | 1      | alfresco | begin                                           
>                       | null                  | T              | 324   
>          | 0          | S           | 0         | -1           | 
> | 2      | alfresco | insert into alf_attributes (version, acl_id, 
> type) values (?, ?, 'M') | <!%L|0|!%><!%N|-5|!%> | T              | 
> 324            | 523        | E           | 2         | 0            | 
> +--------+----------+-----------------------------------------------------------------------+-----------------------+----------------+----------------+------------+-------------+-----------+--------------+
>
> ----------------
> alfresco(admin) > dump request 523
> Request id: 523
>    query: insert into alf_attributes (version, acl_id, type) values 
> (?, ?, 'M')
>    parameters: <!%L|0|!%><!%N|-5|!%>
>    login: alfresco
>    autocommit: false
>    transaction id: 324
>    cacheable status: CACHEABLE
>    isolation level: TRANSACTION_UNDEFINED
>    start time: 1242150743853
>    end time: 0
>    timeout in seconds: 0
>    locked tables:
>       alf_attributes
>    persistent connection id: 0
>    client ip address: /127.0.0.1
>
>
> Thanks for any help.
>
> Richard Vigeant
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
> Series Scanner you'll get full speed at 300 dpi even with all image 
> processing features enabled. http://p.sf.net/sfu/kodak-com
> ------------------------------------------------------------------------
>
> _______________________________________________
> Sequoiadb-discuss mailing list
> Seq...@li...
> https://lists.sourceforge.net/lists/listinfo/sequoiadb-discuss
>   


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