Virtual database configuration is not compatible with other
controller settings.
----------------------------------------------------------------------
-----------
Key: SEQUOIA-971
URL: https://forge.continuent.org/jira/browse/SEQUOIA-971
Project: Sequoia
Type: Task
Components: JDBC Driver
Versions: Sequoia 2.10
Environment: linux(centOS)
Reporter: chidanand
Hellloooo,
I have 2 controllers with,two mysql backends configured at
different IPs.There is no error when i run one controller,but if i
run the second controller Iam getting error as shown below,
Iam not able to find out the reason for the error: " ERROR
controller.virtualdatabase.ems Virtual database configuration is
not compatible with other controller settings." and this needs to
be solved before i proceed further and finish task within
deadline.Iam greatfull if anybody could help.....
my virtual DB configurations are as follows,
for controller1:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA SYSTEM "file:///usr/local/sequoia/xml/sequoia.dtd">
<SEQUOIA>
<VirtualDatabase name="ems" >
<Distribution> <MessageTimeouts/> </Distribution>
<Monitoring>
<SQLMonitoring defaultMonitoring="off">
<SQLMonitoringRule queryPattern="^select"
caseSensitive="false" applyToSkeleton ="false" monitoring="on"/>
</SQLMonitoring>
</Monitoring>
<Backup>
<Backuper backuperName="MYSQL"
className="org.continuent.sequoia.controller.backup.backupers.MySQLBac
kuper"
options="zip=true"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="root" password="root"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="root" vPassword="root"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="bkend6"
driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://OSS640_SE2/ems"
connectionTestStatement="select 1">
<ConnectionManager vLogin="root" rLogin="root" rPassword="root">
<VariablePoolConnectionManager initPoolSize="40"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="bkend5"
driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://dbserver/ems_c1"
connectionTestStatement="select 1">
<ConnectionManager vLogin="root" rLogin="root" rPassword="root">
<VariablePoolConnectionManager initPoolSize="40"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<ResultCache granularity="table"/>
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<RAIDb-1-RoundRobin/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://localhost/recovery" login="root"
password="root">
<RecoveryLogTable
createTable="CREATE TABLE"
tableName="logtable"
logIdColumnType="INT"
vloginColumnType="VARCHAR(20)"
sqlColumnName="sql"
sqlColumnType="VARCHAR(20)"
sqlParamColumnType="VARCHAR(20)"
autoConnTranColumnType="CHAR(1)"
transactionIdColumnType="INT"
requestIdColumnType="INT"
execTimeColumnType="INT"
updateCountColumnType="INT"
/>
<CheckpointTable
checkpointNameColumnType="VARCHAR(50)"
logIdColumnType="INT"
/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(20)"
backendNameColumnType="VARCHAR(20)"
checkpointNameColumnType="VARCHAR(20)"/>
<DumpTable
createTable = "CREATE TABLE"
tableName = "dumptable"
dumpNameColumnType = "VARCHAR(20)"
dumpDateColumnType = "TIMESTAMP"
dumpPathColumnType = "VARCHAR(20)"
dumpFormatColumnType = "VARCHAR(20)"
checkpointNameColumnType = "VARCHAR(20)"
backendNameColumnType = "VARCHAR(20)"
tablesColumnName = "tab"
tablesColumnType = "VARCHAR(20)"
extraStatementDefinition = ""
/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
for controller2:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA SYSTEM "file:///usr/local/sequoia/xml/sequoia.dtd">
<SEQUOIA>
<VirtualDatabase name="ems" >
<Distribution> <MessageTimeouts/> </Distribution>
<Monitoring>
<SQLMonitoring defaultMonitoring="off">
<SQLMonitoringRule queryPattern="^select"
caseSensitive="false" applyToSkeleton ="false" monitoring="on"/>
</SQLMonitoring>
</Monitoring>
<Backup>
<Backuper backuperName="MYSQL"
className="org.continuent.sequoia.controller.backup.backupers.MySQLBac
kuper"
options="zip=true"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="root1" password="root1"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="root1" vPassword="root1"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="bkend6"
driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://OSS640_SE2/ems"
connectionTestStatement="select 1">
<ConnectionManager vLogin="root1" rLogin="root"
rPassword="root">
<VariablePoolConnectionManager initPoolSize="40"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="bkend5"
driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://dbserver/ems_c1"
connectionTestStatement="select 1">
<ConnectionManager vLogin="root1" rLogin="root"
rPassword="root">
<VariablePoolConnectionManager initPoolSize="40"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<ResultCache granularity="table"/>
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<RAIDb-1-RoundRobin/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://localhost/recovery2" login="root"
password="root">
<RecoveryLogTable
createTable="CREATE TABLE"
tableName="logtable"
logIdColumnType="INT"
vloginColumnType="VARCHAR(20)"
sqlColumnName="sql"
sqlColumnType="VARCHAR(20)"
sqlParamColumnType="VARCHAR(20)"
autoConnTranColumnType="CHAR(1)"
transactionIdColumnType="INT"
requestIdColumnType="INT"
execTimeColumnType="INT"
updateCountColumnType="INT"
/>
<CheckpointTable
checkpointNameColumnType="VARCHAR(50)"
logIdColumnType="INT"
/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(20)"
backendNameColumnType="VARCHAR(20)"
checkpointNameColumnType="VARCHAR(20)"/>
<DumpTable
createTable = "CREATE TABLE"
tableName = "dumptable"
dumpNameColumnType = "VARCHAR(20)"
dumpDateColumnType = "TIMESTAMP"
dumpPathColumnType = "VARCHAR(20)"
dumpFormatColumnType = "VARCHAR(20)"
checkpointNameColumnType = "VARCHAR(20)"
backendNameColumnType = "VARCHAR(20)"
tablesColumnName = "tab"
tablesColumnType = "VARCHAR(20)"
extraStatementDefinition = ""
/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
AND THE ERROR IAM GETTING IS;
16:36:36,613 INFO controller.core.Controller Sequoia controller
(2.10.6)
16:36:36,675 INFO controller.core.Controller Loading configuration
file: /usr/local/sequoia/config/controller/controller.xml
16:36:36,765 INFO controller.core.Controller JMX is enabled
16:36:36,791 INFO controller.core.Controller Starting JMX server
on host: 10.253.1.5
16:36:37,145 INFO controller.backup.BackupManager Registering
backuper MYSQL to handle format MySQL raw dump
16:36:37,173 INFO backend.DatabaseBackend.bkend6 Adding connection
manager for virtual user "root"
16:36:37,178 INFO backend.DatabaseBackend.bkend5 Adding connection
manager for virtual user "root"
16:36:37,493 INFO sequoia.controller.recoverylog Creating recovery
log table: logtable
16:36:37,497 INFO sequoia.controller.recoverylog Creating
checkpoint table: checkpointtable
16:36:37,513 INFO sequoia.controller.recoverylog Creating backend
table: BACKEND
16:36:37,515 INFO sequoia.controller.recoverylog Creating dump
table: dumptable
16:36:37,571 INFO controller.RequestManager.ems Request manager
will parse requests with the following granularity: TABLE
16:36:37,575 INFO controller.virtualdatabase.ems Using Hedera
properties file: /hedera_jgroups.properties
-------------------------------------------------------
GMS: address is 10.0.0.18:32772
-------------------------------------------------------
16:36:42,367 INFO controller.virtualdatabase.ems Group ems
connected to Member(address=/10.0.0.18:32772, uid=ems)
16:36:42,368 INFO controller.virtualdatabase.ems Group now
contains 2 controllers.
16:36:42,368 INFO controller.virtualdatabase.ems Checking virtual
database configuration with remote controllers.
16:36:42,533 ERROR controller.virtualdatabase.ems Virtual database
configuration is not compatible with other controller settings.
16:36:43,622 ERROR controller.jmx.MBeanServer Register mbean of
type
sequoia:VirtualDataBase=ems,type=VirtualDataBase.RequestManager.Parsin
gCache failed with error
sequoia:type=VirtualDataBase.RequestManager.ParsingCache,VirtualDataBa
se=ems ({2})
16:36:43,625 ERROR controller.xml.DatabasesParser The virtual
database ems could not be added to the controller (because of Error
while joining group ems
(org.continuent.sequoia.common.exceptions.ControllerException:
Virtual database configuration is not compatible with other
controller settings.))
java.lang.Exception: Error while joining group ems
(org.continuent.sequoia.common.exceptions.ControllerException:
Virtual database configuration is not compatible with other
controller settings.)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDa
tabase.joinGroup(DistributedVirtualDatabase.java:651)
at
org.continuent.sequoia.controller.xml.DatabasesParser.endElement
(DatabasesParser.java:685)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1528)
at org.apache.crimson.parser.Parser2.content(Parser2.java:
1779)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.parseInternal
(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at org.apache.crimson.parser.XMLReaderImpl.parse
(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML
(DatabasesParser.java:287)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML
(DatabasesParser.java:336)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(
Controller.java:222)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration
(Controller.java:552)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVi
rtualDatabase(ControllerConfiguration.java:446)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtua
lDatabase(ControllerParser.java:645)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement
(ControllerParser.java:325)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1488)
at org.apache.crimson.parser.Parser2.content(Parser2.java:
1779)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:
1779)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.parseInternal
(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at org.apache.crimson.parser.XMLReaderImpl.parse
(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML
(ControllerParser.java:127)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML
(ControllerParser.java:177)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML
(ControllerParser.java:206)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpBy
Xml(ControllerConfiguration.java:277)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup
(ControllerConfiguration.java:327)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getCont
roller(ControllerConfiguration.java:353)
at org.continuent.sequoia.controller.core.Controller.main
(Controller.java:742)
Caused by:
org.continuent.sequoia.common.exceptions.ControllerException:
Virtual database configuration is not compatible with other
controller settings.
at
org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackT
race(SequoiaException.java:103)
at java.lang.Throwable.<init>(Throwable.java:196)
at java.lang.Exception.<init>(Exception.java:41)
at
org.continuent.sequoia.common.exceptions.SequoiaException.<init>
(SequoiaException.java:57)
at
org.continuent.sequoia.common.exceptions.ControllerException.<init>
(ControllerException.java:51)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDa
tabase.joinGroup(DistributedVirtualDatabase.java:596)
... 29 more
16:36:43,628 WARN controller.core.Controller Loading of virtual
databases configuration file failed (because of The virtual
database ems could not be added to the controller (because of Error
while joining group ems
(org.continuent.sequoia.common.exceptions.ControllerException:
Virtual database configuration is not compatible with other
controller settings.))).
org.xml.sax.SAXException: The virtual database ems could not be
added to the controller (because of Error while joining group ems
(org.continuent.sequoia.common.exceptions.ControllerException:
Virtual database configuration is not compatible with other
controller settings.))
at
org.continuent.sequoia.controller.xml.DatabasesParser.endElement
(DatabasesParser.java:714)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1528)
at org.apache.crimson.parser.Parser2.content(Parser2.java:
1779)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.parseInternal
(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at org.apache.crimson.parser.XMLReaderImpl.parse
(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML
(DatabasesParser.java:287)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML
(DatabasesParser.java:336)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(
Controller.java:222)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration
(Controller.java:552)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVi
rtualDatabase(ControllerConfiguration.java:446)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtua
lDatabase(ControllerParser.java:645)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement
(ControllerParser.java:325)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1488)
at org.apache.crimson.parser.Parser2.content(Parser2.java:
1779)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:
1779)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.parseInternal
(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at org.apache.crimson.parser.XMLReaderImpl.parse
(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML
(ControllerParser.java:127)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML
(ControllerParser.java:177)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML
(ControllerParser.java:206)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpBy
Xml(ControllerConfiguration.java:277)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup
(ControllerConfiguration.java:327)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getCont
roller(ControllerConfiguration.java:353)
at org.continuent.sequoia.controller.core.Controller.main
(Controller.java:742)
16:36:43,630 ERROR controller.core.Controller Failed to send file
to Sequoia controller:
org.continuent.sequoia.common.exceptions.ControllerException:
Loading of virtual databases configuration file failed (because of
The virtual database ems could not be added to the controller
(because of Error while joining group ems
(org.continuent.sequoia.common.exceptions.ControllerException:
Virtual database configuration is not compatible with other
controller settings.))).
org.continuent.sequoia.common.exceptions.ControllerException:
Loading of virtual databases configuration file failed (because of
The virtual database ems could not be added to the controller
(because of Error while joining group ems
(org.continuent.sequoia.common.exceptions.ControllerException:
Virtual database configuration is not compatible with other
controller settings.))).
at
org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackT
race(SequoiaException.java:103)
at java.lang.Throwable.<init>(Throwable.java:196)
at java.lang.Exception.<init>(Exception.java:41)
at
org.continuent.sequoia.common.exceptions.SequoiaException.<init>
(SequoiaException.java:57)
at
org.continuent.sequoia.common.exceptions.ControllerException.<init>
(ControllerException.java:51)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(
Controller.java:229)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration
(Controller.java:552)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVi
rtualDatabase(ControllerConfiguration.java:446)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtua
lDatabase(ControllerParser.java:645)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement
(ControllerParser.java:325)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1488)
at org.apache.crimson.parser.Parser2.content(Parser2.java:
1779)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:
1779)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.parseInternal
(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at org.apache.crimson.parser.XMLReaderImpl.parse
(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML
(ControllerParser.java:127)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML
(ControllerParser.java:177)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML
(ControllerParser.java:206)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpBy
Xml(ControllerConfiguration.java:277)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup
(ControllerConfiguration.java:327)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getCont
roller(ControllerConfiguration.java:353)
at org.continuent.sequoia.controller.core.Controller.main
(Controller.java:742)
16:36:43,635 ERROR controller.core.Controller Could not load config
file: /usr/local/sequoia/config/virtualdatabase/ems.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 database ems could not be added to the controller
(because of Error while joining group ems
(org.continuent.sequoia.common.exceptions.ControllerException:
Virtual database configuration is not compatible with other
controller settings.)))..
org.continuent.sequoia.common.exceptions.ControllerException:
Failed to send file to Sequoia controller:
org.continuent.sequoia.common.exceptions.ControllerException:
Loading of virtual databases configuration file failed (because of
The virtual database ems could not be added to the controller
(because of Error while joining group ems
(org.continuent.sequoia.common.exceptions.ControllerException:
Virtual database configuration is not compatible with other
controller settings.))).
at
org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackT
race(SequoiaException.java:103)
at java.lang.Throwable.<init>(Throwable.java:196)
at java.lang.Exception.<init>(Exception.java:41)
at
org.continuent.sequoia.common.exceptions.SequoiaException.<init>
(SequoiaException.java:57)
at
org.continuent.sequoia.common.exceptions.ControllerException.<init>
(ControllerException.java:51)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration
(Controller.java:558)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVi
rtualDatabase(ControllerConfiguration.java:446)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtua
lDatabase(ControllerParser.java:645)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement
(ControllerParser.java:325)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1488)
at org.apache.crimson.parser.Parser2.content(Parser2.java:
1779)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:
1779)
at org.apache.crimson.parser.Parser2.maybeElement
(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.parseInternal
(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at org.apache.crimson.parser.XMLReaderImpl.parse
(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML
(ControllerParser.java:127)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML
(ControllerParser.java:177)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML
(ControllerParser.java:206)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpBy
Xml(ControllerConfiguration.java:277)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup
(ControllerConfiguration.java:327)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getCont
roller(ControllerConfiguration.java:353)
at org.continuent.sequoia.controller.core.Controller.main
(Controller.java:742)
16:36:43,641 INFO controller.core.Controller Waiting for
connections on 0.0.0.0:25322
16:36:43,642 INFO controller.core.Controller Controller started on
2007.08.31 35 at 04:36:43 PM IST
16:36:43,642 INFO controller.core.Controller Controller
10.253.1.5:25322 ready, listening to requests ...
--
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
