Emanuel,
I was looking directly at the database to extract the recovery log info.
the controller config is:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE SEQUOIA-CONTROLLER SYSTEM "file:///sequoia-controller.dtd">
<SEQUOIA-CONTROLLER>
<Controller ipAddress="192.168.0.109" port="6954">
<JmxSettings>
<RmiJmxAdaptor port="6956"/>
</JmxSettings>
<VirtualDatabase configFile="myapp.xml"
virtualDatabaseName="AndyCluster" autoEnableBackends="false"/>
</Controller>
</SEQUOIA-CONTROLLER>
And the virtualdatabase is:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA SYSTEM "file:///sequoia.dtd">
<SEQUOIA>
<VirtualDatabase name="AndyCluster">
<!--Distribution hederaPropertiesFile="/hedera_appia.properties">
<MessageTimeouts/>
</Distribution-->
<Backup>
<Backuper backuperName="MyAppDerby"
className="com.coppereye.myapp.ha.DerbyEmbeddedBackuper"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password=""/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="myusername" vPassword="password"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="MYAPP" driver="org.apache.derby.jdbc.EmbeddedDriver"
url="jdbc:derby:MYAPP;retrieveMessagesFromServerOnGetMessage=true;"
connectionTestStatement="values 1">
<ConnectionManager vLogin="myusername" >
<VariablePoolConnectionManager initPoolSize="0" minPoolSize="0"
maxPoolSize="0" idleTimeout="30" waitTimeout="30"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="MYAPP-BACKUP"
driver="org.apache.derby.jdbc.EmbeddedDriver"
url="jdbc:derby:MYAPP-BACKUP;retrieveMessagesFromServerOnGetMessage=true;"
connectionTestStatement="values 1">
<ConnectionManager vLogin="myusername" >
<VariablePoolConnectionManager initPoolSize="0" minPoolSize="0"
maxPoolSize="0" idleTimeout="30" waitTimeout="30"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<!--ResultCache granularity="table" /-->
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="all"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.apache.derby.jdbc.EmbeddedDriver"
url="jdbc:derby:HA;create=true" login="username" password="password">
<RecoveryLogTable tableName="RECOVERY"
logIdColumnType="BIGINT NOT NULL"
vloginColumnType="VARCHAR(64) NOT NULL"
sqlColumnName="sqlStmt"
sqlColumnType="VARCHAR(8192) NOT NULL"
sqlParamColumnType="CLOB "
extraStatementDefinition=", PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="CHECKPOINT"
checkpointNameColumnType="VARCHAR(1024) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(1024) NOT NULL"
backendNameColumnType="VARCHAR(1024) NOT NULL"
checkpointNameColumnType="VARCHAR(1024) NOT NULL"/>
<DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR(1024) NOT
NULL" dumpDateColumnType="TIMESTAMP NOT NULL" dumpPathColumnType="VARCHAR(1024)
NOT NULL" dumpFormatColumnType ="VARCHAR(1024) NOT NULL"
checkpointNameColumnType="VARCHAR(1024) NOT NULL"
backendNameColumnType="VARCHAR(1024) NOT NULL" tablesColumnType="VARCHAR(1024)
NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
Many thanks again,
Andy
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel Cecchet
Sent: 27 June 2008 18:52
To: Sequoia general mailing list
Subject: Re: [Sequoia] Deadlock when replaying recovery log
Andrew,
Could you send me your configuration files?
Do you get the recovery log entries by using the console 'dump recoverylog'
command or directly by looking at the database content?
Thanks for your help,
Emmanuel
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [EMAIL PROTECTED]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
