Hi Robert,
thanks a lot for you reply!
In both VDB.xml files the URLs has been the same.
Changing from localhost to the internal IP has done the trick.
Thanks a lot
Simon
Robert Hodges schrieb:
Hi Simon,
It appears you may have an overlap between VDB definition files on different
controllers. For example, you can't have two VDB.xml files for the same VDB
that use the same backend name "a", because then both controllers would own
the same backend. Also, we don't allow the backend URLs to be the same. I
notice you are using "localhost" for the backend URL. Try putting in the
host name and it should work better.
If you look in the log for the first controller you may find a description
of what Sequoia thinks is wrong. Sequoia sends the definition back to the
other controller for checking. Otherwise, you should compare the VDB files
very carefully to see what is inconsistent.
Thanks, Robert
On 1/28/08 3:07 AM, "Simon I. Landes" <[EMAIL PROTECTED]> wrote:
Hi Alex,
did you get your configuration work?
I am facing the same problem right know:
I have two Servers with one Controller on each and only one Backend per
Controller.
With the raidb-1 Configuration I'm getting following error when I start
the second Controller:
2008-01-28 01:41:27,976 ERROR controller.core.Controller Could not
load config file:
/usr/local/src/sequoia-2.10.9-bin/config/virtualdatabase/mysql-raid1.xml.
Error is: Failed to
send file to Sequoia controller:
org.continuent.sequoia.common.exceptions.ControllerException: Loading of
virtual databases configuration file failed (because of The
virtual data base test could not be added to the controller
(because of Error while joining group test
(org.continuent.sequoia.common.exceptions.ControllerException:
Virtual database configuration is not compatible with other
controller settings.)))..
The controllers start to communicate with each other. But s.th. ist
wrong and I can't figure it out what!
I would be very happy if you could send me your configuration file or
take a look at mine (attached).
Thanks a lot!
Simon
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-CONTROLLER
2.10.9//EN"
"http://sequoia.continuent.org/dtds/sequoia-controller-2.10.9.dtd";>
<SEQUOIA-CONTROLLER>
<Controller ipAddress="10.0.0.2" port="25322">
<JmxSettings>
<RmiJmxAdaptor port="1090"/>
</JmxSettings>
<VirtualDatabase configFile="mysql-raid1.xml" virtualDatabaseName="test"
autoEnableBackends="true"/>
</Controller>
</SEQUOIA-CONTROLLER>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.9//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.9.dtd";>
<SEQUOIA>
<VirtualDatabase name="test">
<Distribution>
<MessageTimeouts/>
</Distribution>
<Monitoring>
<SQLMonitoring defaultMonitoring="off">
<SQLMonitoringRule queryPattern="^select" caseSensitive="false"
applyToSkeleton ="false" monitoring="on"/>
</SQLMonitoring>
</Monitoring>
<Backup>
<Backuper backuperName="Octopus"
className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"
options="zip=true"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password=""/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword=""/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="a" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/test"
connectionTestStatement="SELECT 1">
<ConnectionManager vLogin="user" rLogin="test" rPassword="test">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="all"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/clusterlog" login="test"
password="test">
<RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT
NULL"
vloginColumnType="VARCHAR(255) NOT NULL" sqlColumnType="VARCHAR(255)
NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="CHECKPOINT"
checkpointNameColumnType="VARCHAR(255) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(255) NOT NULL"
backendNameColumnType="VARCHAR(255) NOT NULL"
checkpointNameColumnType="VARCHAR(255) NOT NULL"/>
<DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR(255) NOT NULL"
dumpDateColumnType="TIMESTAMP"
dumpPathColumnType="VARCHAR(255) NOT NULL"
dumpFormatColumnType="VARCHAR(255) NOT NULL"
checkpointNameColumnType="VARCHAR(255) NOT NULL"
backendNameColumnType="VARCHAR(255) NOT NULL"
tablesColumnType="VARCHAR(255) NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
