[Sequoiadb-discuss] Request blocked forever in Sequoia

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

Hi,

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