Hello List,
Been a while since I last posted. I've been tackling sequoia once again, and I'm thinking this is a mis configuration somewhere. We've rebuilt our code to be JDBC compliant however when we start up jboss I see the following in the sequoia log file: 2008-04-25 14:18:07,605 ERROR sequoia.controller.recoverylog Recovery log was unable to update request completion status: [EMAIL PROTECTED]: UPDATE logtable SET exec_status='F',update_count=0,exec_time=0 WHERE log_id=-1 How do I resolve this recovery log issue? My configuration is as follows: <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-CONTROLLER 2.10.9//EN" "http://sequoia.continuent.org/dtds/sequoia-controller-2.10.9.dtd";> <SEQUOIA-CONTROLLER> <Controller ipAddress="192.168.61.14" port="25322"> <Report hideSensitiveData="true" generateOnShutdown="true" generateOnFatal="true" enableFileLogging="true" /> <JmxSettings> <RmiJmxAdaptor port="1090" /> </JmxSettings> <VirtualDatabase configFile="vdb.xml" virtualDatabaseName="vdb" autoEnableBackends="false" checkpointName="Initial_empty_recovery_log"/> </Controller> </SEQUOIA-CONTROLLER> And I load two virtualdatabases: <?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="iasipaiddb"> <Monitoring> <SQLMonitoring defaultMonitoring="off"> <SQLMonitoringRule queryPattern="^select" caseSensitive="false" applyToSkeleton ="false" monitoring="on"/> </SQLMonitoring> </Monitoring> <Backup> <Backuper backuperName="BKUP_SQA_IASIPAIDDB" className="org.continuent.sequoia.controller.backup.backupers.MySQLBacku per"/> </Backup> <AuthenticationManager> <Admin> <User username="root" password="password"/> </Admin> <VirtualUsers> <VirtualLogin vLogin="user" vPassword=""/> </VirtualUsers> </AuthenticationManager> <DatabaseBackend name="DB1" driver="com.mysql.jdbc.Driver" driverPath="/usr/local/sequoia/sequoia/drivers/mysql-connector-java-5.0. 8-bin.jar" url="jdbc:mysql://192.168.61.14:3306/iasipaiddb" connectionTestStatement="select 1"> <ConnectionManager vLogin="user" rLogin="root" rPassword=""> <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> </ConnectionManager> </DatabaseBackend> <RequestManager> <RequestScheduler> <RAIDb-1Scheduler level="passThrough"/> </RequestScheduler> <RequestCache> <MetadataCache/> <ParsingCache/> </RequestCache> <LoadBalancer> <RAIDb-1> <WaitForCompletion policy="first"/> <RAIDb-1-LeastPendingRequestsFirst/> </RAIDb-1> </LoadBalancer> <RecoveryLog driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/iasipaiddb_recovery" login="root" password=""> <RecoveryLogTable tableName="logtable" vloginColumnType="TEXT NOT NULL" sqlColumnName="sqlcol" sqlColumnType="TEXT NOT NULL" sqlParamColumnType="TEXT"/> <CheckpointTable tableName="checkpointtable" checkpointNameColumnType="TEXT NOT NULL" extraStatementDefinition=",PRIMARY KEY (name(767))"/> <BackendTable tableName="backendtable" databaseNameColumnType="TEXT NOT NULL" backendNameColumnType="TEXT NOT NULL" checkpointNameColumnType="TEXT NOT NULL"/> <DumpTable tableName="dumptable" dumpNameColumnType="TEXT NOT NULL" dumpPathColumnType="TEXT NOT NULL" dumpFormatColumnType="TEXT NOT NULL" checkpointNameColumnType="TEXT NOT NULL" backendNameColumnType="TEXT NOT NULL" tablesColumnType="TEXT NOT NULL"/> </RecoveryLog> </RequestManager> </VirtualDatabase> </SEQUOIA> AND <?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="iasdsydb"> <Monitoring> <SQLMonitoring defaultMonitoring="off"> <SQLMonitoringRule queryPattern="^select" caseSensitive="false" applyToSkeleton ="false" monitoring="on"/> </SQLMonitoring> </Monitoring> <Backup> <Backuper backuperName="BKUP_SQA_IASDSYDB" className="org.continuent.sequoia.controller.backup.backupers.MySQLBacku per"/> </Backup> <AuthenticationManager> <Admin> <User username="root" password="r0th"/> </Admin> <VirtualUsers> <VirtualLogin vLogin="user" vPassword=""/> </VirtualUsers> </AuthenticationManager> <DatabaseBackend name="DB1" driver="com.mysql.jdbc.Driver" driverPath="/usr/local/sequoia/sequoia/drivers/mysql-connector-java-5.0. 8-bin.jar" url="jdbc:mysql://192.168.61.14:3306/iasdsydb" connectionTestStatement="select 1"> <ConnectionManager vLogin="user" rLogin="root" rPassword=""> <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> </ConnectionManager> </DatabaseBackend> <RequestManager> <RequestScheduler> <RAIDb-1Scheduler level="passThrough"/> </RequestScheduler> <RequestCache> <MetadataCache/> <ParsingCache/> </RequestCache> <LoadBalancer> <RAIDb-1> <WaitForCompletion policy="first"/> <RAIDb-1-LeastPendingRequestsFirst/> </RAIDb-1> </LoadBalancer> <RecoveryLog driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/iasdsydb_recovery" login="root" password=""> <RecoveryLogTable tableName="logtable" vloginColumnType="TEXT NOT NULL" sqlColumnName="sqlcol" sqlColumnType="TEXT NOT NULL" sqlParamColumnType="TEXT"/> <CheckpointTable tableName="checkpointtable" checkpointNameColumnType="TEXT NOT NULL" extraStatementDefinition=",PRIMARY KEY (name(767))"/> <BackendTable tableName="backendtable" databaseNameColumnType="TEXT NOT NULL" backendNameColumnType="TEXT NOT NULL" checkpointNameColumnType="TEXT NOT NULL"/> <DumpTable tableName="dumptable" dumpNameColumnType="TEXT NOT NULL" dumpPathColumnType="TEXT NOT NULL" dumpFormatColumnType="TEXT NOT NULL" checkpointNameColumnType="TEXT NOT NULL" backendNameColumnType="TEXT NOT NULL" tablesColumnType="TEXT NOT NULL"/> </RecoveryLog> </RequestManager> </VirtualDatabase> </SEQUOIA> This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform us immediately and delete this e-mail message and destroy all copies. Thank you.
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
