Hello,
I'm testing sequoia with a 3 nodes configuration. Each node is a linux
virtual machine. On each I have a controller with a backend. The backend
backend target postgresql server hosted on the node.
I have the following VDB for each node :
<SEQUOIA>
<VirtualDatabase name="xxx">
<Distribution groupName="xxx"
hederaPropertiesFile="/hedera_appia.properties">
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="postgres"
className="...OctopusBackuper"
options="dumpServer=IP1"/>
<Backuper backuperName="postgres2"
className="...PostgreSQLBinaryBackuper"
options="dumpServer=IP1"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password="admin"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="xxx" vPassword="xxx"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="db1"
driverPath=".../sequoia-2.10.10/drivers/postgresql-8.2-508.jdbc2.jar"
driver="org.postgresql.Driver" url="jdbc:postgresql://IP1/db1"
connectionTestStatement="select now()">
<DatabaseSchema dynamicPrecision="table"/>
<ConnectionManager vLogin="xxx" rLogin="xxx" rPassword="xxx">
<VariablePoolConnectionManager initPoolSize="20" minPoolSize="5"
maxPoolSize="80" idleTimeout="30" waitTimeout="10"/>
</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="org.postgresql.Driver"
url="jdbc:postgresql://IP1/recoverylogs" login="xxx"
password="xxx" >
<RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT
NOT NULL"
vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR NOT
NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
...
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
Normal usage of the cluster is good. My databasses are consistent.
My test scenario : I shutdown my db #3. Controller #3 notice it.
System is still running. I restart my database. I try to re enable my
backend (after a dump restore) ... no success. then I must restore logs
from another node. Then it's the end. The node suspend my vdb activity
... no more after 20 mins.
very embarrassing...
Thanks for your help.
Arnaud GIULIANI.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
