[ https://forge.continuent.org/jira/browse/SEQUOIA-968?page=comments#action_14031 ]
S. Schnabl commented on SEQUOIA-968: ------------------------------------ Have you tested to replace the "localhost" in your driver url with real ip-addresses ? See: <DatabaseBackend name="srv1" driver="org.postgresql.Driver" url="jdbc:postgresql://localhost:65432/casino" connectionTestStatement="select now()"> > 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
