Hi,
The issue is that you are using the same JDBC URL
(jdbc:mysql://localhost:3306/txtbl_cluster) for each backend and this is
not allowed by Sequoia that requires every backend to be different (to
avoid sharing).
If you want to stick with localhost, features like transferring backends
will not work, you should use the public IP of the machine instead. If
you still want to keep the loopback for communications, you can use
127.0.0.1 for the 1st backend and 127.0.0.2 for the 2nd backend.
That should solve your problem,
Emmanuel
I had installed and setted sequoia and appia on amazon as follow
start appia gossipserver at domU-12-31-39-00-D2-51:9900
appia.xml
1.(hostname:domU-12-31-39-00-D2-51)
<channel name="TCP SEQ Channel" template="tcp_sequencer"
initialized="yes">
<memorymanagement size="40000000" up_threshold="15000000"
down_threshold="7000000" />
<chsession name="hederalayer">
<parameter
name="gossip_address">domU-12-31-39-00-D2-51:9900</parameter>
</chsession>
</channel>
2.(hostname:domU-12-31-39-00-D2-41)
<channel name="TCP SEQ Channel" template="tcp_sequencer"
initialized="yes">
<memorymanagement size="40000000" up_threshold="15000000"
down_threshold="7000000" />
<chsession name="hederalayer">
<parameter
name="gossip_address">domU-12-31-39-00-D2-51:9900</parameter>
</chsession>
</channel>
when i start first sequois instance(any instance, only order), all
seems well,
when i start second, console shows:
19:24:20,893 ERROR controller.virtualdatabase.myDB Virtual database
configuration is not compatible with other controller settings.
19:24:21,901 ERROR controller.xml.DatabasesParser The virtual database
myDB could not be added to the controller (because of Error while
joining group myDB
(org.continuent.sequoia.common.exceptions.ControllerException: Virtual
database configuration is not compatible with other controller settings.))
java.lang.Exception: Error while joining group myDB
(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:629)
at
org.continuent.sequoia.controller.xml.DatabasesParser.endElement(DatabasesParser.java:646)
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:270)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:319)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:220)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:553)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:372)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:564)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement(ControllerParser.java:308)
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:121)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:171)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:200)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(ControllerConfiguration.java:232)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:288)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:314)
at
org.continuent.sequoia.controller.core.Controller.main(Controller.java:752)
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:574)
... 29 more
19:24:21,906 WARN controller.core.Controller Loading of virtual
databases configuration file failed (because of The virtual database
myDB could not be added to the controller (because of Error while
joining group myDB
(org.continuent.sequoia.common.exceptions.ControllerException: Virtual
database configuration is not compatible with other controller
settings.))).
org.xml.sax.SAXException: The virtual database myDB could not be added
to the controller (because of Error while joining group myDB
(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:227)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:553)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:372)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:564)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement(ControllerParser.java:308)
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:121)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:171)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:200)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(ControllerConfiguration.java:232)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:288)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:314)
at
org.continuent.sequoia.controller.core.Controller.main(Controller.java:752)
19:24:21,910 ERROR controller.core.Controller Could not load config
file: /mnt/sequoia/config/virtualdatabase/vdb-controller1.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 myDB could not be added to the controller (because of Error
while joining group myDB
(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 myDB could not be added to the controller (because of Error
while joining group myDB
(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:560)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:372)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:564)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement(ControllerParser.java:308)
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:121)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:171)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:200)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(ControllerConfiguration.java:232)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:288)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:314)
at
org.continuent.sequoia.controller.core.Controller.main(Controller.java:752)
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [EMAIL PROTECTED]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
