[
https://forge.continuent.org/jira/browse/SEQUOIA-968?page=comments#action_14065
]
chidanand commented on SEQUOIA-968:
-----------------------------------
Hey,
Its this,even I had the same problem.You cannot share your backend
with two different controllers.Assign different backends for different
controllers.Hope this might solve your problem,
> 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
