[ https://forge.continuent.org/jira/browse/SEQUOIA-968?page=comments#action_14066 ]
Juan Olmedilla commented on SEQUOIA-968: ---------------------------------------- It's not that. Obviously, as I told you, I followed all the instructions in the manual, where it says specifically that the same backend cannot be assigned to two different controllers. I had two controllers and two backends and each one controlled a different backend. The problem was another and I have already solved it. I suggest adding a note in the manual so not to confuse people because the controller.xml examples included in the package are misleading. The thing was as follows: I had two controllers each in a different machine with different IP's and I started copying the example with two controllers (RAID 1b), in each controller.xml I left the IP address which was "127.0.0.1", however in the example one had port 25232 and the other 25323, since I was putting them in different machines unlike the example that placed them in the same, I changed the secon controller port to put it 25322 also. This made both controllers to conflict but the message was not sufficently explanatory (see above), and that's why you did not see it either. I changed both controllers and put the real IP in each one, and that solved the problem. However I was mislead by the example because it was working with both controllers in the same machines (different ports). Add a note in the manual or in the controller.xml itself to help others. Thanks, Juan Olmedilla > Virtual database configuration is not compatible with other controller > settings > ------------------------------------------------------------------------------- > > Key: SEQUOIA-968 > URL: https://forge.continuent.org/jira/browse/SEQUOIA-968 > Project: Sequoia > Type: Bug > Versions: Sequoia 2.10.9 > Environment: 2 SuSE Enterprise 10 Xeon Servers > 2 PostgreSQL 8.1.9 servers > Reporter: Juan Olmedilla > > > I have to controllers, each one in a different machine and there is a single > virtualdatabase with two backends. I have followed all installafion > instructions > and checked in the mailing lists and JIRA (there was a similar issue but it > resulted in a typo, I have doubled-checked my configuration files) > Both controllers see each other but when checking the virtualdatabase > configuration compatibility between them the second one throws an error: > "Virtual database configuration is not compatible with other controller > settings" > Here both virtualdatabase configurations: > First Server: > <?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="casinoDB"> > <Distribution groupName="casinoDB"> > <MessageTimeouts/> > </Distribution> > <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="srv1" driver="org.postgresql.Driver" > url="jdbc:postgresql://localhost/casino" connectionTestStatement="select > now()"> > <ConnectionManager vLogin="user" rLogin="almira" rPassword=""> > <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="first"/> > <RAIDb-1-LeastPendingRequestsFirst/> > </RAIDb-1> > </LoadBalancer> > <RecoveryLog driver="org.postgresql.Driver" > url="jdbc:postgresql://localhost/casinolog1" login="almira" > password=""> > <RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT > NULL" > vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR NOT NULL" > extraStatementDefinition=",PRIMARY KEY (log_id)"/> > <CheckpointTable tableName="CHECKPOINT" > checkpointNameColumnType="VARCHAR NOT NULL"/> > <BackendTable tableName="BACKEND" > databaseNameColumnType="VARCHAR NOT NULL" > backendNameColumnType="VARCHAR NOT NULL" > checkpointNameColumnType="VARCHAR NOT NULL"/> > <DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR NOT NULL" > dumpDateColumnType="TIMESTAMP" > dumpPathColumnType="VARCHAR NOT NULL" > dumpFormatColumnType="VARCHAR NOT NULL" > checkpointNameColumnType="VARCHAR NOT NULL" > backendNameColumnType="VARCHAR NOT NULL" > tablesColumnType="VARCHAR NOT NULL"/> > </RecoveryLog> > </RequestManager> > </VirtualDatabase> > </SEQUOIA> > -------------------------------------------------------------------------------------- > Second Server: > <?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="casinoDB"> > <Distribution groupName="casinoDB"> > <MessageTimeouts/> > </Distribution> > <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="srv2" driver="org.postgresql.Driver" > url="jdbc:postgresql://localhost:65432/casino" > connectionTestStatement="select now()"> > <ConnectionManager vLogin="user" rLogin="almira" rPassword=""> > <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="first"/> > <RAIDb-1-LeastPendingRequestsFirst/> > </RAIDb-1> > </LoadBalancer> > <RecoveryLog driver="org.postgresql.Driver" > url="jdbc:postgresql://localhost:65432/casinolog1" login="almira" > password=""> > <RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT > NULL" > vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR NOT NULL" > extraStatementDefinition=",PRIMARY KEY (log_id)"/> > <CheckpointTable tableName="CHECKPOINT" > checkpointNameColumnType="VARCHAR NOT NULL"/> > <BackendTable tableName="BACKEND" > databaseNameColumnType="VARCHAR NOT NULL" > backendNameColumnType="VARCHAR NOT NULL" > checkpointNameColumnType="VARCHAR NOT NULL"/> > <DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR NOT NULL" > dumpDateColumnType="TIMESTAMP" > dumpPathColumnType="VARCHAR NOT NULL" > dumpFormatColumnType="VARCHAR NOT NULL" > checkpointNameColumnType="VARCHAR NOT NULL" > backendNameColumnType="VARCHAR NOT NULL" > tablesColumnType="VARCHAR NOT NULL"/> > </RecoveryLog> > </RequestManager> > > </VirtualDatabase> > </SEQUOIA> -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://forge.continuent.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
