Hi
I'm running two database nodes (PostgreSQL) running on two separate
physical servers. Each server also has an instance of Sequoia (2.10.6)
installed so the set up looks like this:
controller1 controller2
+-------------------------+ +-------------------------+
| | | |
| +-------------------+ | | +-------------------+ |
| | PostgreSQL 1 | | | | PostgreSQL 2 | |
| +-------------------+ | | +-------------------+ |
| | | |
| +-------------------+ | | +-------------------+ |
| | Sequoia |--------------| Sequoia | |
| +-------------------+ | | +-------------------+ |
| | | |
+-------------------------+ +-------------------------+
I've got what I think is a good controller and virtual database
configuration, which are the same on both servers, and when I start up
the first Sequoia instance everything is fine, but when the next Sequoia
instance is started, I get the following errors:
2007-05-30 14:42:55,401 ERROR controller.virtualdatabase.ssnen Virtual
database configuration is not compatible with other controller settings.
2007-05-30 14:42:56,542 ERROR controller.xml.DatabasesParser The virtual
database ssnen could not be added to the controller (because of Error
while joining group ssnen
(org.continuent.sequoia.common.exceptions.ControllerException: Virtual
database configuration is not compatible with other controller settings.))
I have already found another entry in the mailing list from January this
year http://permalink.gmane.org/gmane.comp.db.sequoia.general/4602 which
has the same error message, but the solution isn't the same as mine.
I wonder if someone could help? I include my config files below (I have
left out the DTD declarations):
SERVER 1 (controller1)
======================
<SEQUOIA-CONTROLLER>
<Controller port="25322">
<JmxSettings>
<RmiJmxAdaptor port="1090"/>
</JmxSettings>
<VirtualDatabase configFile="postgres-raidb1-distribution-1.xml"
virtualDatabaseName="ssnen" autoEnableBackends="true"/>
</Controller>
</SEQUOIA-CONTROLLER>
SERVER 1 (virtualdatabase)
==========================
<SEQUOIA>
<VirtualDatabase name="ssnen" maxNbOfConnections="200">
<Distribution>
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="pgdump"
className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLBinaryBackuper"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password="mmam3hol"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword=""/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="controller1" driver="org.postgresql.Driver"
url="jdbc:postgresql://controller1/ns" connectionTestStatement="select
now()">
<DatabaseSchema dynamicPrecision="table"/>
<ConnectionManager vLogin="user" rLogin="jdbc"
rPassword="number123">
<VariablePoolConnectionManager initPoolSize="10"
minPoolSize="5"
maxPoolSize="100" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="controller2" driver="org.postgresql.Driver"
url="jdbc:postgresql://controller2/ns" connectionTestStatement="select
now()">
<DatabaseSchema dynamicPrecision="table"/>
<ConnectionManager vLogin="user" rLogin="jdbc"
rPassword="number123">
<VariablePoolConnectionManager initPoolSize="10"
minPoolSize="5"
maxPoolSize="100" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<ResultCache granularity="database" />
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first" />
<RAIDb-1-LeastPendingRequestsFirst />
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.postgresql.Driver"
url="jdbc:postgresql://controller1/ssnen_log" login="postgres"
password="mmam3hol">
<RecoveryLogTable/>
<CheckpointTable/>
<BackendTable/>
<DumpTable/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
SERVER 2 (controller1)
======================
<SEQUOIA-CONTROLLER>
<Controller port="25322">
<JmxSettings>
<RmiJmxAdaptor port="1090"/>
</JmxSettings>
<VirtualDatabase configFile="postgres-raidb1-distribution-1.xml"
virtualDatabaseName="ssnen" autoEnableBackends="true"/>
</Controller>
</SEQUOIA-CONTROLLER>
SERVER 2 (virtualdatabase)
==========================
<SEQUOIA>
<VirtualDatabase name="ssnen" maxNbOfConnections="200">
<Distribution>
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="pgdump"
className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLBinaryBackuper"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password="mmam3hol"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword=""/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="controller1" driver="org.postgresql.Driver"
url="jdbc:postgresql://controller1/ns" connectionTestStatement="select
now()">
<DatabaseSchema dynamicPrecision="table"/>
<ConnectionManager vLogin="user" rLogin="jdbc"
rPassword="number123">
<VariablePoolConnectionManager initPoolSize="10"
minPoolSize="5"
maxPoolSize="100" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="controller2" driver="org.postgresql.Driver"
url="jdbc:postgresql://controller2/ns" connectionTestStatement="select
now()">
<DatabaseSchema dynamicPrecision="table"/>
<ConnectionManager vLogin="user" rLogin="jdbc"
rPassword="number123">
<VariablePoolConnectionManager initPoolSize="10"
minPoolSize="5"
maxPoolSize="100" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<ResultCache granularity="database" />
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first" />
<RAIDb-1-LeastPendingRequestsFirst />
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.postgresql.Driver"
url="jdbc:postgresql://controller1/ssnen_log" login="postgres"
password="mmam3hol">
<RecoveryLogTable/>
<CheckpointTable/>
<BackendTable/>
<DumpTable/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
If anyone can see anything wrong with the configuration files, or
perhaps point me in the corrcet direction, I would greatly appreciate it.
Regards
John
--
John Gardner - Tagish Ltd.
Infrastructure Manager
T: 01665 833 322
F: 01665 830 695
D: 01665 833 310
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
