Hi Emmanuel
This is my current connection Manager configuration, it seems to be working now.
In the previous version of sequoia I had minPoolSize=20
Thanks
<ConnectionManager vLogin="postgres" rLogin="postgres" rPassword="">
<VariablePoolConnectionManager initPoolSize="100" minPoolSize="0"
maxPoolSize="0" idleTimeout="180" waitTimeout="0"/>
</ConnectionManager>
Date: Tue, 3 Nov 2009 17:00:43 -0500
From: m...@frogthinker.org
To: sequoia@lists.forge.continuent.org
CC: sequoiadb-disc...@lists.sourceforge.net
Subject: Re: [Sequoia] sequoia 2.10.10.
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)
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
Sequoia@lists.forge.continuent.org
http://forge.continuent.org/mailman/listinfo/sequoia
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: m...@frogthinker.org
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
Sequoia@lists.forge.continuent.org
http://forge.continuent.org/mailman/listinfo/sequoia
