On 23-mrt-2007, at 12:08, Emmanuel Cecchet wrote:
Leander,
Anyway, I checked it again just now and I really don't get any
output using the following log4j config:
db01:/usr/local/sequoia/config# grep DEBUG log4j.properties
log4j.logger.org.continuent.sequoia.controller.monitoring=DEBUG,
Console,Filetrace
log4j.logger.org.continuent.sequoia.controller.cache=DEBUG,
Console,Filetrace
Could you post your virtual database config file to check if the
caching is properly defined?
Voila!
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 3.0-beta2//EN" "http://sequoia.continuent.org/dtds/sequoia-3.0-beta2.dtd";>
<SEQUOIA>
<VirtualDatabase name="unicorn">
<Distribution>
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="postgres"
className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLBinaryBackuper"
options="encoding=UTF8,useAuthentication=true"/>
</Backup>
<AuthenticationManager transparentLogin="on">
<AdminUser username="XXXXX" password="XXXXXX"/>
<VirtualUser vLogin="XXXXXXX" vPassword="XXXXXX"/>
</AuthenticationManager>
<DatabaseBackend name="db01" driver="org.postgresql.Driver" url="jdbc:postgresql://10.0.30.40/unicorn" connectionTestStatement="select now()">
<ConnectionManager vLogin="XXXXXXX">
<VariablePoolConnectionManager initPoolSize="20" minPoolSize="5" maxPoolSize="200" idleTimeout="180" waitTimeout="60"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseSchema/>
<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>
<EmbeddedRecoveryLog />
<!-- <RecoveryLog driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:hsql://localhost:9001" login="TEST" password="">
<RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT NULL" vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR NOT NULL" extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="CHECKPOINT" checkpointNameColumnType="VARCHAR NOT NULL"/>
<BackendTable tableName="BACKEND" databaseNameColumnType="VARCHAR NOT NULL" backendNameColumnType="VARCHAR NOT NULL" checkpointNameColumnType="VARCHAR NOT NULL"/>
<DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR NOT NULL" dumpDateColumnType="VARCHAR NOT NULL" dumpPathColumnType="VARCHAR NOT NULL" dumpFormatColumnType ="VARCHAR NOT NULL" checkpointNameColumnType="VARCHAR NOT NULL" backendNameColumnType="VARCHAR NOT NULL" tablesColumnType="VARCHAR NOT NULL"/>
</RecoveryLog>-->
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
Leander
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
