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

[Julio L. <jc...@ho...>]

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: ma...@fr...
To: se...@li...
CC: seq...@li...
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
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