Re: [Sequoiadb-discuss] [Sequoia] sequoia 2.10.10.

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

Hi Julio,

This looks like a bug. What is your connection manager configuration on 
your db1 backend?
If the problem persists I suggest that you file a new bug in JIRA.

Thanks for your feedback
Emmanuel

>  Hi all
> I know the list has been moved, but I haven't get any reply back from 
> this in that list.(sorry Emmanuel to bother you with this)
>
> I just update sequoia from 2.10.0 to 2.10.10
>
> We are running a volume test with 1000 clients sending insert 
> transactions to the DB
> We have 2 postgresql backends(8.3.5) <javascript:;>
>
> After three hours we got these error messages and one backend was disabled
>
> This did not happen with the previous version of sequoia
>
> Any Ideas?
>
> Thanks in advance
>
>
> 2009-10-29 12:38:20,881 INFO  controller.core.PingResponder Ping 
> responder started
> 2009-10-29 15:52:29,090 FATAL backend.DatabaseBackend.db1 Unexpected 
> error while executing task: StatementExecuteUpdateTask from 
> transaction 1160899 (INSERT INTO table1 (f1, f2, f3, f4, f5, f6, f7, 
> f8, f9,f10, f11, f12, f13, f14, f15, f16, f17, f18, f19, f20, f21, 
> f22, f23, f24, f25,f26) VALUES(?,?,?,?,?, ?,?,?,?,?, ?,?,?,?,?, ?,?,?,?,?,
> ?,?,?,?,?, ?)/*RQT*//<!%L|5364374|!%><!%I|2554|!%><!%T|2009-10-29 
> 15:52:29.048|!%><!%S||!%><!%I|2600|!%><!%I|1|!%><!%N|4|!%><!%D|4.0|!%><!%1|0
> .0|!%><!%I|0|!%><!%I|0|!%><!%I|2600|!%><!%S|awg|!%><!%S|perf__150028|!%><!%D|0.0|!%><!%I|1000|!%><!%N|-5|!%><!%I|1|!%><!%D|1.0|!%><!%I|1|!%><!
> %S||!%><!%I|1000|!%><!%L|5364374|!%><!%D|0.0|!%><!%N|4|!%><!%L|5364374|!%>) 
> (0)
> java.lang.NullPointerException
>         at java.util.LinkedList.remove(LinkedList.java:647)
>         at java.util.LinkedList.removeLast(LinkedList.java:144)
>         at 
> org.continuent.sequoia.controller.connection.VariablePoolConnectionManager.getConnection(VariablePoolConnectionManager.java:468)
>         at 
> org.continuent.sequoia.controller.connection.AbstractConnectionManager.getRenewedConnectionInAutoCommit(AbstractConnectionManager.j
> ava:427)
>         at 
> org.continuent.sequoia.controller.connection.AbstractConnectionManager.getConnectionForTransaction(AbstractConnectionManager.java:4
> 59)
>         at 
> org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.getConnectionAndBeginTransaction(AbstractLoadBalancer.java:1793
> )
>         at 
> org.continuent.sequoia.controller.backend.DatabaseBackend.getConnectionForTransactionAndLazyBeginIfNeeded(DatabaseBackend.java:849)
>         at 
> org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateTask.executeInTransaction(StatementExecuteUpdateTask.jav
> a:280)
>         at 
> org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateTask.executeTask(StatementExecuteUpdateTask.java:118)
>         at 
> org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.execute(AbstractTask.java:141)
>         at 
> org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:197)
> 2009-10-29 15:52:29,105 ERROR controller.loadbalancer.RAIDb1 Request  
> SELECT nextval('table1_id_seq')/... failed on backend db1 (null)
>
>
>
> Thanks
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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