Re: [Sequoiadb-discuss] [Sequoia] help --Cannot enable backend

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi,

I recommend that you read the documentation on how to initialize the 
cluster.
There are 2 possible causes for your problem:
1. You never initialized properly the cluster
2. You did not stop properly your cluster

You can download a copy of the documentation from 
https://sourceforge.net/project/showfiles.php?group_id=252061

Hope this helps,
Emmanuel

xzy12345 wrote:
> Hi,thank you for your last email.Now I encountered a new problem.And I 
> find several persons in the web have met the same problem,but no open 
> solution has been provided.
> the full message of start is:
> 16:52:49,765 INFO controller.core.Controller Sequoia controller (2.10.10)
> 16:52:49,828 INFO controller.core.Controller Loading configuration 
> file: ..\con
> fig\controller\controller-distributed-3.xml
> 16:52:49,890 INFO controller.core.Controller JMX is enabled
> 16:52:49,906 INFO controller.core.Controller Starting JMX server on 
> host: 127.0
> .0.1
> 16:52:49,906 WARN controller.core.Controller Could not parse RMI 
> Server Port 'n
> ull
> 16:52:50,203 INFO backup.backupers.OctopusBackuper OctopusBackuper 
> backup compr
> ession is set to true
> 16:52:50,203 INFO controller.backup.BackupManager Registering backuper 
> Octopus
> to handle format Octopus v3.4.1 database neutral dump compressed
> 16:52:50,218 INFO DatabaseBackend.myDB.localhost3 Adding connection 
> manager for
> virtual user "user"
> 16:52:50,234 INFO DatabaseBackend.myDB.localhost4 Adding connection 
> manager for
> virtual user "user"
> 16:52:50,531 INFO sequoia.controller.recoverylog Creating recovery log 
> table: l
> ogtable
> 16:52:50,609 INFO sequoia.controller.recoverylog Creating checkpoint 
> table: che
> ckpointtable
> 16:52:50,687 INFO sequoia.controller.recoverylog Creating backend 
> table: backen
> dtable
> 16:52:50,734 INFO sequoia.controller.recoverylog Creating dump table: 
> dumptable
> 16:52:50,875 INFO controller.RequestManager.myDB Request manager will 
> parse req
> uests with the following granularity: TABLE
> 16:52:50,890 INFO controller.virtualdatabase.myDB Recovery log size: 0
> 16:52:50,890 INFO controller.virtualdatabase.myDB Using Hedera 
> properties file:
> /hedera_jgroups.properties
> -------------------------------------------------------
> GMS: address is 192.168.1.10:2613
> -------------------------------------------------------
> 16:52:53,375 INFO controller.virtualdatabase.myDB Waiting 2000 ms for 
> group mem
> bership to be stable
> 16:52:55,375 INFO controller.virtualdatabase.myDB Group myDB connected 
> to Membe
> r(address=/192.168.1.10:2613, uid=myDB)
> 16:52:55,375 INFO controller.virtualdatabase.myDB First controller in 
> group myD
> B
> 16:52:55,453 INFO sequoia.controller.recoverylog Checking recovery log 
> consiste
> ncy
> 16:52:55,484 WARN controller.virtualdatabase.myDB Cannot enable 
> backend localho
> st3 from a known state. Resynchronize this backend by restoring a dump.
> 16:52:55,484 WARN controller.virtualdatabase.myDB Cannot enable 
> backend localho
> st4 from a known state. Resynchronize this backend by restoring a dump.
> 16:52:55,500 INFO controller.core.Controller Adding VirtualDatabase myDB
> 16:52:55,500 INFO controller.core.Controller Loading backend 
> interceptor classe
> s
> 16:52:55,500 INFO controller.core.Controller Loading frontend 
> interceptor class
> es
> 16:52:55,500 INFO controller.core.Controller Interceptors initialized
> 16:52:55,500 INFO controller.core.Controller Waiting for connections 
> on 127.0.0
> .1:25322
> 16:52:55,500 INFO controller.core.PingResponder Ping responder started
> 16:52:55,515 INFO controller.core.Controller Controller started on 
> 2009.04.27 1
> 8 at 04:52:55 ÏÂÎç CST
> 16:52:55,515 INFO controller.core.Controller Controller 
> 127.0.0.1:25322 ready,
> listening to requests ...
> my configuration is:
> <DatabaseBackend name="localhost3" driver="org.gjt.mm.mysql.Driver" 
> url="jdbc:mysql://192.168.1.10/coas" connectionTestStatement="call now()">
> <ConnectionManager vLogin="user" rLogin="root" rPassword="root">
> <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" 
> maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
> </ConnectionManager>
> </DatabaseBackend>
> <DatabaseBackend name="localhost4" driver="org.gjt.mm.mysql.Driver" 
> url="jdbc:mysql://192.168.1.25/coas" connectionTestStatement="call now()">
> <ConnectionManager vLogin="user" rLogin="root" rPassword="root">
> <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" 
> maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
> </ConnectionManager>
> </DatabaseBackend>
> when I use junit,the eclipse console prints:
> org.continuent.sequoia.common.exceptions.driver.DriverSQLException: 
> Message of cause: null....
> while the cmd append the message:
> 16:57:00,187 WARN sequoia.controller.cache Unable to remove pending 
> query user,
> select * from t_theme_sys
> 16:57:00,203 WARN controller.RequestManager.myDB An error occured 
> while executi
> ng remote select request 1
> org.continuent.sequoia.common.exceptions.NoMoreBackendException
> at org.continuent.sequoia.controller.requestmanager.distributed.RAIDb1Di
> stributedRequestManager.execRemoteStatementExecuteQuery(RAIDb1DistributedRequest
> Manager.java:170)
> at org.continuent.sequoia.controller.requestmanager.distributed.Distribu
> tedRequestManager.statementExecuteQuery(DistributedRequestManager.java:1371)
> at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.sta
> tementExecuteQuery(VirtualDatabase.java:592)
> at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWork
> erThread.statementExecuteQuery(VirtualDatabaseWorkerThread.java:2217)
> at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWork
> erThread.run(VirtualDatabaseWorkerThread.java:451)
> 16:57:00,203 INFO virtualdatabase.VirtualDatabaseWorkerThread.myDB 
> Error during
> command execution (null)
> Thank you for your help!
>
>
>
> ------------------------------------------------------------------------
> ÍøÒ×ÓÊÏä£¬ÖÐ¹úµÚÒ»´óµç×ÓÓÊ¼þ·þÎñÉÌ <http://email.163.com>
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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