|
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"> <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="" 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="" 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="" 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
