Hi Eivar, Did you follow the procedure to initialize one of your backends and then transfer its state to the other backend? The messages in your log indicate this has not been done. Check the manuals for more information.
Thanks, Robert On 1/28/08 3:24 AM, "Eivar Armero Luna" <[EMAIL PROTECTED]> wrote: > Hello, > I'm Eivar armero, I'm running sequoia 2.10.9 as part of my degree project, > with a sigle controller and two Mysql backends, but when I start the > controller the following Warnings appear and the when i try to do a simple > INSERT operation in the databases other warning is throw, and the INSERT does > not commit, > > Please can somebody help me??? > > I'm very grateful by any help. Tks. > > this is the log of the sequoia. full_cluster.log > > 2008-01-27 18:48:33,109 INFO controller.core.Controller Sequoia controller > (2.10.9) > 2008-01-27 18:48:33,187 INFO controller.core.Controller Loading configuration > file: /C:/sequoia2/config/controller/controller.xml > 2008-01-27 18:48:33,296 INFO controller.core.Controller JMX is enabled > 2008-01-27 18:48:33,328 INFO controller.core.Controller Starting JMX server > on host: 127.0.0.1 > 2008-01-27 18:48:34,187 INFO controller.backup.BackupManager Registering > backuper mysql to handle format MySQL raw dump > 2008-01-27 18:48:34,234 INFO DatabaseBackend.myDB.localhost1 Adding > connection manager for virtual user "user" > 2008-01-27 18:48:34,250 INFO DatabaseBackend.myDB.remote1 Adding connection > manager for virtual user "user" > 2008-01-27 18:48:34,687 INFO sequoia.controller.recoverylog Creating recovery > log table: RECOVERY > 2008-01-27 18:48:34,734 INFO sequoia.controller.recoverylog Creating > checkpoint table: CHECKPOINT > 2008-01-27 18:48:34,781 INFO sequoia.controller.recoverylog Creating backend > table: BACKEND > 2008-01-27 18:48:34,796 INFO sequoia.controller.recoverylog Creating dump > table: DUMP > 2008-01-27 18:48:34,906 INFO controller.RequestManager.myDB Request manager > will parse requests with the following granularity: TABLE > 2008-01-27 18:48:34,906 INFO controller.virtualdatabase.myDB Recovery log > size: 0 > 2008-01-27 18:48:34,921 INFO controller.virtualdatabase.myDB Using Hedera > properties file: /hedera_jgroups.properties > 2008-01-27 18:48:40,000 INFO controller.virtualdatabase.myDB Group myDB > connected to Member(address=/192.168.79.1:1137, uid=myDB) > 2008-01-27 18:48:40,000 INFO controller.virtualdatabase.myDB First controller > in group myDB > 2008-01-27 18:48:40,015 INFO sequoia.controller.recoverylog Checking recovery > log consistency > 2008-01-27 18:48:40,031 WARN controller.virtualdatabase.myDB Cannot enable > backend localhost1 from a known state. Resynchronize this backend by restoring > a dump. > 2008-01-27 18:48:40,031 WARN controller.virtualdatabase.myDB Cannot enable > backend remote1 from a known state. Resynchronize this backend by restoring a > dump. > 2008-01-27 18:48:40,031 INFO controller.core.Controller Adding > VirtualDatabase myDB > 2008-01-27 18:48:40,093 INFO controller.core.Controller Waiting for > connections on 127.0.0.1:25322 > 2008-01-27 18:48:40,125 INFO controller.core.Controller Controller started on > 2008.01.27 04 at 06:48:40 PM COT > 2008-01-27 18:48:40,125 INFO controller.core.Controller Controller > 127.0.0.1:25322 ready, listening to requests ... > 2008-01-27 18:49:11,921 WARN controller.RequestManager.myDB Request 'INSERT > INTO datos ( id, nombre) VALUES (?, ?)/<!%I|0|!%><!%S|eivar|!%>' failed on all > controllers > 2008-01-27 18:49:11,921 WARN controller.RequestManager.myDB Request INSERT > INTO datos ( id, nombre) VALUES (... failed (Request 'INSERT INTO datos ( id, > nombre) VALUES (?, ?)/<!%I|0|!%><!%S|eivar|!%>' failed on all controllers) > 2008-01-27 18:49:11,921 WARN controller.virtualdatabase.myDB Request '1' > failed (Request 'INSERT INTO datos ( id, nombre) VALUES (?, > ?)/<!%I|0|!%><!%S|eivar|!%>' failed on all controllers) > 2008-01-27 18:49:11,921 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB > Error during command execution (Request 'INSERT INTO datos ( id, nombre) > VALUES (?, ?)/<!%I|0|!%><!%S|eivar|!%>' failed on all controllers) > > > > > and this is my VDB config file. > > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.9//EN" > "http://sequoia.continuent.org/dtds/sequoia-2.10.9.dtd"; > <http://sequoia.continuent.org/dtds/sequoia-2.10.9.dtd> > > > <SEQUOIA> > > <VirtualDatabase name="myDB"> > > <Distribution> > <MessageTimeouts/> > </Distribution> > > <Backup> > <Backuper backuperName="mysql" > className="org.continuent.sequoia.controller.backup.backupers.MySQLBackuper"/> > </Backup> > > <AuthenticationManager> > <Admin> > <User username="admin" password=""/> > </Admin> > <VirtualUsers> > <VirtualLogin vLogin="user" vPassword="tesis"/> > </VirtualUsers> > </AuthenticationManager> > > > <DatabaseBackend name="localhost1" driver="com.mysql.jdbc.Driver" > url="jdbc:mysql://localhost:3306/tesis" > driverPath="C:\sequoia2\drivers\mysql-connector-java-3.0.15-ga-bin.jar" > connectionTestStatement="select 1"> > <ConnectionManager vLogin="user" rLogin="user" rPassword="tesis"> > <VariablePoolConnectionManager initPoolSize="40"/> > </ConnectionManager> > </DatabaseBackend> > > > > <DatabaseBackend name="remote1" driver="com.mysql.jdbc.Driver" > url="jdbc:mysql://localhost:3306/tesis2" > driverPath="C:\sequoia2\drivers\mysql-connector-java-3.0.15-ga-bin.jar" > connectionTestStatement="select 1"> > <ConnectionManager vLogin="user" rLogin="user2" rPassword="tesis2"> > <VariablePoolConnectionManager initPoolSize="40"/> > </ConnectionManager> > </DatabaseBackend> > > <RequestManager> > <RequestScheduler> > <RAIDb-1Scheduler level="passThrough"/> > </RequestScheduler> > > <RequestCache> > <MetadataCache/> > <ParsingCache/> > <!-- <ResultCache granularity="table"/> --> > </RequestCache> > > <LoadBalancer> > <RAIDb-1> > <WaitForCompletion policy="first"/> > <RAIDb-1-LeastPendingRequestsFirst/> > </RAIDb-1> > </LoadBalancer> > > <RecoveryLog driver="com.mysql.jdbc.Driver" > url="jdbc:mysql://localhost:3306/log" login="log" password="loger"> > <RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT > NULL" > vloginColumnType="TEXT NOT NULL" > sqlColumnName="sql2" > sqlColumnType="TEXT NOT NULL" > sqlParamColumnType="TEXT NOT NULL" > transactionIdColumnType="BIGINT NOT NULL" > extraStatementDefinition=",PRIMARY KEY (log_id)"/> > <CheckpointTable tableName="CHECKPOINT" > checkpointNameColumnType="VARCHAR(32) NOT NULL"/> > <BackendTable tableName="BACKEND" > databaseNameColumnType="TEXT NOT NULL" > backendNameColumnType="TEXT NOT NULL" > checkpointNameColumnType="TEXT NOT NULL"/> > <DumpTable tableName="DUMP" dumpNameColumnType="TEXT NOT NULL" > dumpDateColumnType="TIMESTAMP" > dumpPathColumnType="TEXT NOT NULL" > dumpFormatColumnType="TEXT NOT NULL" > checkpointNameColumnType="TEXT NOT NULL" > backendNameColumnType="TEXT NOT NULL" > tablesColumnType="TEXT NOT NULL"/> > > </RecoveryLog> > </RequestManager> > > </VirtualDatabase> > > </SEQUOIA> > > > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia -- Robert Hodges, CTO, Continuent, Inc. Email: [EMAIL PROTECTED] Mobile: +1-510-501-3728 Skype: hodgesrm
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
