Hello All
I am in the process of testing the sequoia system for deployment. My
current configuration consists of one controller and two MySQL nodes. I
had this configuration working fine with 2.10.9. I recently updated to
2.10.10 as we needed support for prepared statements, which did not seem
to be supported in 2.10.9. However on updating to the new system I have
run into an error that I cannot seem to work out.
Basically I am getting the following error.
11:54:19,496 INFO controller.backup.BackupManager Registering backuper
MySQLBackuper to handle format MySQL raw dump
11:54:19,497 INFO DatabaseBackend.allocation.node1 Adding connection
manager for virtual user "user"
11:54:19,498 INFO DatabaseBackend.allocation.node1 Adding connection
manager for virtual user "trans"
11:54:19,498 INFO DatabaseBackend.allocation.node1 Adding connection
manager for virtual user "tomcat"
11:54:19,501 INFO DatabaseBackend.allocation.node2 Adding connection
manager for virtual user "user"
11:54:19,502 INFO DatabaseBackend.allocation.node2 Adding connection
manager for virtual user "trans"
11:54:19,502 INFO DatabaseBackend.allocation.node2 Adding connection
manager for virtual user "tomcat"
11:54:19,529 INFO controller.RequestManager.allocation Request manager
will parse requests with the following granularity: TABLE
11:54:19,536 INFO controller.virtualdatabase.allocation Recovery log
size: 0
11:54:19,537 INFO controller.virtualdatabase.allocation Using Hedera
properties file: /hedera_jgroups.properties
11:54:19,558 ERROR controller.jmx.MBeanServer Register mbean of type
sequoia:VirtualDataBase=allocation,type=VirtualDataBase.RequestManager.ParsingCache
failed with error
sequoia:type=VirtualDataBase.RequestManager.ParsingCache,VirtualDataBase=allocation
({2})
11:54:19,559 ERROR controller.xml.DatabasesParser The virtual database
allocation could not be added to the controller (because of Error while
joining group allocation
(org.continuent.hedera.channel.ChannelException:
org.jgroups.ChannelException: failed to start protocol stack))
However my virtual database does not have any cache definition in the
xml file. This XML file works in the old version just not in 2.10.10.
I also tried to run the demo in 2.10.10 thinking I might be able to find
some new config options in the new XML files. The demo's also died with
the same issue though.
So I am thinking I have missed some new configuration or setting I need
for 2.10.10 but I have no idea what it might be. Any ideas would be
much appreciated. Thank you in advance for your help.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.10//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.10.dtd";>
<SEQUOIA>
<VirtualDatabase name="allocation">
<Distribution>
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="MySQLBackuper"
className="org.continuent.sequoia.controller.backup.backupers.MySQLBackuper"
options=""/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password=""/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword=""/>
<VirtualLogin vLogin="trans" vPassword=""/>
<VirtualLogin vLogin="tomcat" vPassword=""/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="node1" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://127.0.0.1:3306/allocation"
connectionTestStatement="SELECT 1">
<ConnectionManager vLogin="user" rLogin="sequoia" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
<ConnectionManager vLogin="trans" rLogin="sequoia" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
<ConnectionManager vLogin="tomcat" rLogin="sequoia" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="node2" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://192.168.0.92:3306/allocation"
connectionTestStatement="SELECT 1">
<ConnectionManager vLogin="user" rLogin="sequoia" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
<ConnectionManager vLogin="trans" rLogin="sequoia" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
<ConnectionManager vLogin="tomcat" rLogin="sequoia" 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="com.mysql.jdbc.Driver"
url="jdbc:mysql://127.0.0.1:3306/recovery" login="sequoia" password="">
<RecoveryLogTable tableName="ALLOCATION_RECOVERY"
logIdColumnType="BIGINT NOT NULL"
vloginColumnType="VARCHAR(255) NOT NULL"
sqlColumnName="sqlStmt"
sqlColumnType="TEXT NOT NULL"
sqlParamColumnType="TEXT"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="ALLOCATION_CHECKPOINT"
checkpointNameColumnType="VARCHAR(255) NOT NULL"/>
<BackendTable tableName="ALLOCATION_BACKEND"
databaseNameColumnType="VARCHAR(255) NOT NULL"
backendNameColumnType="VARCHAR(255) NOT NULL"
checkpointNameColumnType="VARCHAR(255) NOT NULL"/>
<DumpTable tableName="ALLOCATION_DUMP"
dumpNameColumnType="VARCHAR(255) NOT NULL"
dumpDateColumnType="TIMESTAMP"
dumpPathColumnType="VARCHAR(255) NOT NULL"
dumpFormatColumnType ="VARCHAR(255) NOT NULL"
checkpointNameColumnType="VARCHAR(255) NOT NULL"
backendNameColumnType="VARCHAR(255) NOT NULL"
tablesColumnType="VARCHAR(255) NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
