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.MySQLBackuper"
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.MySQLBackuper"
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.ParsingCache
failed with error
sequoia:type=VirtualDataBase.RequestManager.ParsingCache,VirtualDataBase=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.DistributedVirtualDatabase.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.setUpVirtualDatabase(ControllerConfiguration.java:446)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(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.setUpByXml(ControllerConfiguration.java:277)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:327)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(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.fillInStackTrace(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.DistributedVirtualDatabase.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.setUpVirtualDatabase(ControllerConfiguration.java:446)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(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.setUpByXml(ControllerConfiguration.java:277)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:327)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(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.fillInStackTrace(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.setUpVirtualDatabase(ControllerConfiguration.java:446)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(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.setUpByXml(ControllerConfiguration.java:277)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:327)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(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.fillInStackTrace(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.setUpVirtualDatabase(ControllerConfiguration.java:446)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(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.setUpByXml(ControllerConfiguration.java:277)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:327)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(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
