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
[email protected]
http://forge.continuent.org/mailman/listinfo/sequoia
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [email protected]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
http://forge.continuent.org/mailman/listinfo/sequoia
