Hi all
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)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 3.0-beta2//EN" "http://sequoia.continuent.org/dtds/sequoia-3.0-beta2.dtd";>
<SEQUOIA>
<VirtualDatabase name="myDB">
<Distribution>
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="mysql" className="org.continuent.sequoia.controller.backup.backupers.MySQLBackuper"/>
<Backuper backuperName="Octopus" className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper" options="zip=true"/>
</Backup>
<AuthenticationManager>
<AdminUser username="admin" password=""/>
<VirtualUser vLogin="user" vPassword=""/>
</AuthenticationManager>
<DatabaseBackend name="node1" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/txtbl_cluster" connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="root" rPassword="123456">
<VariablePoolConnectionManager initPoolSize="2" maxPoolSize="5"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseSchema/>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<ResultCache granularity="table" />
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/recoverlog" login="root" password="123456">
<RecoveryLogTable tableName="RECOVERY"
logIdColumnType="BIGINT NOT NULL"
vloginColumnType="VARCHAR(20) NOT NULL"
sqlColumnName="sqlsrc"
sqlColumnType="TEXT NOT NULL"
sqlParamColumnType="VARCHAR(20) NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="CHECK_POINT"
checkpointNameColumnType="VARCHAR(127) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(50) NOT NULL"
backendNameColumnType="VARCHAR(50) NOT NULL"
checkpointNameColumnType="VARCHAR(127) NOT NULL"/>
<DumpTable tableName="SEQUOIA_DUMP"
dumpNameColumnType="TEXT NOT NULL"
dumpDateColumnType="DATETIME"
dumpPathColumnType="TEXT NOT NULL"
dumpFormatColumnType="TEXT NOT NULL"
checkpointNameColumnType="TEXT NOT NULL"
backendNameColumnType="TEXT NOT NULL"
tablesColumnType="TEXT NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 3.0-beta2//EN" "http://sequoia.continuent.org/dtds/sequoia-3.0-beta2.dtd";>
<SEQUOIA>
<VirtualDatabase name="myDB">
<Distribution>
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="mysql" className="org.continuent.sequoia.controller.backup.backupers.MySQLBackuper"/>
<Backuper backuperName="Octopus" className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper" options="zip=true"/>
</Backup>
<AuthenticationManager>
<AdminUser username="admin" password=""/>
<VirtualUser vLogin="user" vPassword=""/>
</AuthenticationManager>
<DatabaseBackend name="node22" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/txtbl_cluster" connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="root" rPassword="123456">
<VariablePoolConnectionManager initPoolSize="2" maxPoolSize="5"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseSchema/>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<ResultCache granularity="table" />
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/recoverlog" login="root" password="123456">
<RecoveryLogTable tableName="RECOVERY"
logIdColumnType="BIGINT NOT NULL"
vloginColumnType="VARCHAR(20) NOT NULL"
sqlColumnName="sqlsrc"
sqlColumnType="TEXT NOT NULL"
sqlParamColumnType="VARCHAR(20) NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="CHECK_POINT"
checkpointNameColumnType="VARCHAR(127) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(50) NOT NULL"
backendNameColumnType="VARCHAR(50) NOT NULL"
checkpointNameColumnType="VARCHAR(127) NOT NULL"/>
<DumpTable tableName="SEQUOIA_DUMP"
dumpNameColumnType="TEXT NOT NULL"
dumpDateColumnType="DATETIME"
dumpPathColumnType="TEXT NOT NULL"
dumpFormatColumnType="TEXT NOT NULL"
checkpointNameColumnType="TEXT NOT NULL"
backendNameColumnType="TEXT NOT NULL"
tablesColumnType="TEXT NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
