Re: [Sequoiadb-discuss] [Sequoia] Known bug ?

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

Hi Pierre,

Note that the Sequoia mailing list has moved to 
seq...@li....

There were known bugs in the JGroups version that shipped with 2.10.9. 
It might be due to a lost message by JGroups. You should at least try to 
upgrade JGroups or best move to Sequoia 2.10.10 (config is backward 
compatible with 2.10.9).

Hope this helps,
Emmanuel

>
>
> On our configuration (2 controllers (2.10.9) in raidb1), all update queries hanged. We had to restart controllers to unblock database.
>
> I took a look on logs and I can see where controller hangs : on the 'slave controller' (the one which did not receive request directly from client)
>
> the last request without hang logged those lines :
> 15 Oct 2008 08:15:43,094 | LEVEL3 | sequoia debug: Executing task Autocommit StatementExecuteUpdateTask 384 (delete from ...)
> 15 Oct 2008 08:15:43,096 | LEVEL3 | sequoia debug: Task Autocommit StatementExecuteUpdateTask 384 (delete from ...) completed
> 15 Oct 2008 08:15:43,096 | LEVEL3 | sequoia debug: Removed delete from ... from total order queue
> 15 Oct 2008 08:15:43,097 | LEVEL3 | sequoia debug: Logging request 18054
> 15 Oct 2008 08:15:43,097 | LEVEL3 | sequoia debug: org.hsqldb.jdbc.jdbcPreparedStatement@199d8[sql=[UPDATE RECOVERY SET exec_status=?,update_count=?,exec_time=? WHERE log_id=?], parameters=[[S], [0], [4], [18054]]]
> 15 Oct 2008 08:15:43,097 | LEVEL3 | sequoia debug: Write completed, remaining pending writes: 0
>
> the first request with hang only logged those lines
> 15 Oct 2008 08:16:43,075 | LEVEL3 | sequoia debug: Executing task Autocommit StatementExecuteUpdateTask 385 (delete from ...)
> 15 Oct 2008 08:16:43,076 | LEVEL3 | sequoia debug: Removed delete from ... from total order queue
>
>
> Is that a known bug ? Should I add it to bug tracker ?
>
>
> Thanks in advance
>
>
> Pierre
>
> The information in this e-mail is confidential. The contents may not be disclosed or used by anyone other then the addressee. Access to this e-mail by anyone else is unauthorised.
> If you are not the intended recipient, please notify Airbus immediately and delete this e-mail.
> Airbus cannot accept any responsibility for the accuracy or completeness of this e-mail as it has been sent over public networks. If you have any concerns over the content of this message or its Accuracy or Integrity, please contact Airbus immediately.
> All outgoing e-mails from Airbus are checked using regularly updated virus scanning software but you should take whatever measures you deem to be appropriate to ensure that this message and any attachments are virus free.
>
> _______________________________________________
> Sequoia mailing list
> Se...@li...
> http://forge.continuent.org/mailman/listinfo/sequoia
>
>   


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