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 -- Robert Hodges, CTO, Continuent, Inc. Email: [EMAIL PROTECTED] Mobile: +1-510-501-3728 Skype: hodgesrm _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
