Emmanuel,
Many thanks, I'll give a RAIDb-1 config a try.
Config file attached.
Regards,
Peter
Emmanuel Cecchet wrote:
Hi Peter,
I get the following output for every update:-
Recovery log was unable to update request completion status:
UPDATE logtable SET
exec_status=S,update_count=0,exec_time=1733,completion_log_id=0 WHERE
log_id=0
This is probably a bug in SingleDB that we did not test for quite some
time.
Could you provide us with your config file ?
Meanwhile, moving to a RAIDb-1 config (even with a single backend)
should solve the problem.
Thanks for your feedback,
Emmanuel
--
------------------------------
Peter Courcoux
Telephone : +44 (0)1923 661488
Mobile : 07880 605626
email : [EMAIL PROTECTED]
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 3.0-beta//EN" "http://sequoia.continuent.org/dtds/sequoia-3.0-beta.dtd";>
<SEQUOIA>
<VirtualDatabase name="trident">
<Backup>
<Backuper backuperName="Octopus" className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"/>
</Backup>
<AuthenticationManager>
<AdminUser username="???" password="???">
<AccessControl defaultPolicy="denyAll">
<Accept address="127.0.0.1"/>
</AccessControl>
</AdminUser>
<VirtualUser vLogin="???" vPassword="???">
<AccessControl defaultPolicy="denyAll">
<Accept address="127.0.0.1"/>
</AccessControl>
</VirtualUser>
</AuthenticationManager>
<DatabaseBackend name="localhost" driver="org.postgresql.Driver" url="jdbc:postgresql://localhost/trident" connectionTestStatement="select now()">
<ConnectionManager vLogin="???" rLogin="???" rPassword="???">
<VariablePoolConnectionManager initPoolSize="40"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseSchema/>
<RequestManager>
<RequestScheduler>
<SingleDBScheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<ResultCache granularity="table"/>
</RequestCache>
<LoadBalancer>
<SingleDB/>
</LoadBalancer>
<!--
<RecoveryLog driver="org.postgresql.Driver" login="???" password="???" url="jdbc:postgresql://localhost/sequoia">
<RecoveryLogTable autoConnTranColumnType="CHAR(1) NOT NULL" createTable="CREATE TABLE" execTimeColumnType="BIGINT" extraStatementDefinition=",PRIMARY KEY (log_id)" logIdColumnType="BIGINT NOT NULL" requestIdColumnType="BIGINT" sqlColumnName="sql" sqlColumnType="VARCHAR NOT NULL" sqlParamColumnType="VARCHAR" tableName="logtable" transactionIdColumnType="BIGINT NOT NULL" updateCountColumnType="INT" vloginColumnType="VARCHAR NOT NULL"/>
<CheckpointTable checkpointNameColumnType="VARCHAR NOT NULL" createTable="CREATE TABLE" extraStatementDefinition=",PRIMARY KEY (name)" logIdColumnType="BIGINT" tableName="checkpointtable"/>
<BackendTable backendNameColumnType="VARCHAR NOT NULL" backendStateColumnType="INTEGER" checkpointNameColumnType="VARCHAR NOT NULL" createTable="CREATE TABLE" databaseNameColumnType="VARCHAR NOT NULL" extraStatementDefinition="" tableName="backendtable"/>
<DumpTable backendNameColumnType="VARCHAR NOT NULL" checkpointNameColumnType="VARCHAR NOT NULL" createTable="CREATE TABLE" dumpDateColumnType="TIMESTAMP" dumpFormatColumnType="VARCHAR NOT NULL" dumpNameColumnType="VARCHAR NOT NULL" dumpPathColumnType="VARCHAR NOT NULL" extraStatementDefinition="" tableName="dumptable" tablesColumnName="tables" tablesColumnType="VARCHAR NOT NULL"/>
</RecoveryLog>
-->
<RecoveryLog driver="org.postgresql.Driver" login="???" password="???" url="jdbc:postgresql://localhost/sequoia">
<RecoveryLogTable/>
<CheckpointTable/>
<BackendTable/>
<DumpTable/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
<!--
Commands to issue to the SEQUOIA console:
load .../c-jdbc/xml/examples/SingleDB.xml
admin clientDB
admin
c-jdbc
enableAll
quit
connect jdbc:cjdbc://localhost:/clientDB
user
c-jdbc
-->
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
