hi everyone,
we are trying to use sequoia v2.10.9.
with the configuration i've reproduced below (replaced actual ip address
with a.b.c.d) it takes around 3 minutes to start the controller (see log
snippet below). if i remove the <JmxSettings /> element from the
controller configuration the controller starts up real quick.
further it seems that the console cannot connect to the started
controller. the startup is again really slow. after the console is up it
reports that it couldn't connect to the controller (see [4]). this is
odd as i
can see that the port is bound (see [5]).
any help appreciated.
thanks in advance,
alphonse bendt
[1] controller-1.xml:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD
SEQUOIA-CONTROLLER 2.10.9//EN"
"http://sequoia.continuent.org/dtds/sequoia-controller-2.10.9.dtd";>
<SEQUOIA-CONTROLLER>
<Controller port="25322" ipAddress="a.b.c.d" >
<Report hideSensitiveData="true" generateOnShutdown="true"
generateOnFatal="true" enableFileLogging="true" />
<JmxSettings>
<RmiJmxAdaptor/>
</JmxSettings>
<VirtualDatabase configFile="mps-postgres-1.xml"
virtualDatabaseName="mpsPostgres"
autoEnableBackends="true" />
</Controller>
</SEQUOIA-CONTROLLER>
[2] mps-postgres-1.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.9//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.9.dtd";>
<SEQUOIA>
<VirtualDatabase name="mpsPostgres">
<Distribution groupName="mpsGroup" >
<MessageTimeouts/>
</Distribution>
<Monitoring>
<SQLMonitoring defaultMonitoring="off">
<SQLMonitoringRule queryPattern="^select"
caseSensitive="false" applyToSkeleton ="false" monitoring="on"/>
</SQLMonitoring>
</Monitoring>
<Backup>
<Backuper backuperName="Octopus"
className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"
options="zip=true"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password="admin_pass"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword="user_pass"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="node1" driver="org.postgresql.Driver"
url="jdbc:postgresql://a.b.c.d:5432/mps"
connectionTestStatement="select now()">
<DatabaseSchema dynamicPrecision="table" />
<ConnectionManager vLogin="user" >
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<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="org.postgresql.Driver"
url="jdbc:postgresql://a.b.c.d:5432/cluster"
login="cluster"
password="password">
<RecoveryLogTable tableName="recovery" logIdColumnType="BIGINT
NOT NULL"
vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR
NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="checkpoint"
checkpointNameColumnType="VARCHAR NOT NULL"/>
<BackendTable tableName="backend"
databaseNameColumnType="VARCHAR NOT NULL"
backendNameColumnType="VARCHAR NOT NULL"
checkpointNameColumnType="VARCHAR NOT NULL"/>
<DumpTable tableName="dump" dumpNameColumnType="VARCHAR NOT NULL"
dumpDateColumnType="TIMESTAMP"
dumpPathColumnType="VARCHAR NOT NULL"
dumpFormatColumnType="VARCHAR NOT NULL"
checkpointNameColumnType="VARCHAR NOT NULL"
backendNameColumnType="VARCHAR NOT NULL"
tablesColumnType="VARCHAR NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
[3] controller startup log:
09:32:24,523 INFO controller.core.Controller Sequoia controller (2.10.9)
09:32:24,571 INFO controller.core.Controller Loading configuration
file: sequoia-2.10.9-bin/config/controller/controller-1.xml
09:32:24,647 INFO controller.core.Controller JMX is enabled
09:32:24,671 INFO controller.core.Controller Starting JMX server on
host: a.b.c.d
09:32:24,675 INFO sequoia.controller.jmx Create and start naming service
09:32:24,695 INFO sequoia.controller.jmx Create JRMP adaptor
09:35:34,022 INFO backup.backupers.OctopusBackuper OctopusBackuper
backup compression is set to true
[4] console startup log:
Launching the Sequoia controller console
Cannot connect to the administration port of the controller. Is a
controller running at localhost:1090 ?
Initializing Controller module...
Initializing VirtualDatabase Administration module...
Initializing SQL Console module...
Sequoia driver (Sequoia core v2.10.9) successfully loaded.
not connected >
[5]
$ netstat -l
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address
State
tcp 0 0 *:1090 *:* LISTEN
$ fuser -n tcp 1090
1090/tcp: 14129
$ ps 14129
PID TTY STAT TIME COMMAND
14129 pts/0 S+ 0:05 /home/jboss/clusternode/jdk1.5.0_15/bin/java
-classpath
:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/octopus/Octopus.jar:/home/jbos
s/clusternode/sequoia-2.10.9-bin/lib/octopus/OctopusGenerator.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/octopus/csvjdbc.jar:/home/jboss/clusternode/sequ
oia-2.10.9-bin/lib/sequoia-controller.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/sequoia-backend.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/sequo
ia-backupers.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/sequoia-cache.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/sequoia-commons.jar:/home/jboss/
clusternode/sequoia-2.10.9-bin/lib/sequoia-jmx.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/sequoia-sql.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/
octopus:/home/jboss/clusternode/sequoia-2.10.9-bin/drivers:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/hedera-commons.jar:/home/jboss/clusternode/sequoia-2.10
.9-bin/lib/hedera-jgroups.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/hedera-appia.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/appia.jar:/home/jbos
s/clusternode/sequoia-2.10.9-bin/lib/jgroups-core.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/concurrent.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/li
b/commons-logging.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/dom4j-1.6.1.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/jaxen-1.1-beta-8.jar:/home/jb
oss/clusternode/sequoia-2.10.9-bin/lib/log4j.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/activation.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/mai
l.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/commons-cli.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/jmx/mx4j.jar:/home/jboss/clusternode/sequoia-
2.10.9-bin/lib/jmx/mx4j-remote.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/jmx/mx4j-tools.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/xml:/home/jboss/c
lusternode/sequoia-2.10.9-bin/lib/crimson.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/lib/xml-apis.jar:/home/jboss/clusternode/sequoia-2.10.9-bin/config/contr
oller:/home/jboss/clusternode/sequoia-2.10.9-bin/config/virtualdatabase:/home/jboss/clusternode/sequoia-2.10.9-bin/config/::/home/jboss/clusternode/sequoia-2.10.
9-bin/drivers/postgresql-8.2-jdbc3.jar
-Dsequoia.home=/home/jboss/clusternode/sequoia-2.10.9-bin
-Dsequoia.log=/home/jboss/clusternode/sequoia-2.10.9-bin/log -Dj
ava.security.policy=/home/jboss/clusternode/sequoia-2.10.9-bin/config/java.policy
-Djava.net.preferIPv4Stack=true
org.continuent.sequoia.controller.core.Controll
er -f sequoia-2.10.9-bin/config/controller/controller-1.xml
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
