Stefan Lischke wrote:
Hi alex,
Can you reproduce the behavior? If so you can eliminate other errors.
Yup, it's perfectly reproducable....
Here's what I do:
I delete all tables from the recovery database.
I start my controller.
I run the console.
I run the following console commands (based on the demo script called
init_controller1.script):
load virtualdatabase configuration
/opt/sequoia/config/virtualdatabase/myDB.xml init
admin myDB
[admin login]
[admin password]
expert on
initialize backend1
backup backend1 init_dump MySQLBackuper /tmp/backup
[backup login]
[backup pwd]
enable backend1
One the final command, the console just hangs on "Enabling backend
backend1 from its last known checkpoint", and the last thing on the
controller log is: "11:01:57,376 INFO
controller.recoverylog.RecoverThread Starting recovery".
I've attached my VDB and controller XML files in case it's any help.
(Note that the controller config doesn't autoload the VDB - it's
commented out - I do it on the console command line.)
I'm trying to work out what to try next...
This didn't used to happen - I could enable the backend ok, it came back
almost instantly - so I have no idea what has changed!
thanks,
Alex
Stefan
Alex wrote:
Alex wrote:
Hi again
Earlier I had backends being enabled without any problem - and the
command returns almost instantly - but now the console hangs if I try
to enable a backend.
[snip]
Hi all
Anyone got any idea on this one?
I'm running out of time for my evaluation of Sequoia - I think it
looks very handy - but if I can't get it running in the time left we
may lapse back to older technology - booo! :[
Alex
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
------------------------------------------------------------------------
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
<?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="myDB">
<!--
<Monitoring>
<SQLMonitoring defaultMonitoring="off">
<SQLMonitoringRule queryPattern="^select" caseSensitive="false" applyToSkeleton ="false" monitoring="on"/>
</SQLMonitoring>
</Monitoring>
-->
<Distribution>
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="MySQLBackuper"
className="org.continuent.sequoia.controller.backup.backupers.MySQLBackuper"
options="zip=true"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password=""/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword=""/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="backend1"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://127.0.0.1:3306/testdb2"
connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="root" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
<!--<SingleDBScheduler level="passThrough" />-->
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<!-- <ResultCache granularity="table"/> -->
</RequestCache>
<LoadBalancer>
<!--<SingleDB/>--> <!-- no children allowed! -->
<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/testdb2recov"
login="root" password="">
<RecoveryLogTable tableName="RECOVERY"
logIdColumnType="BIGINT NOT NULL"
sqlColumnName="sqlcmd"
sqlColumnType="MEDIUMTEXT NOT NULL"
sqlParamColumnType="MEDIUMTEXT"
vloginColumnType="MEDIUMTEXT NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)" />
<CheckpointTable tableName="CHECKPOINT"
checkpointNameColumnType="VARCHAR(256) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="MEDIUMTEXT NOT NULL"
backendNameColumnType="MEDIUMTEXT NOT NULL"
checkpointNameColumnType="MEDIUMTEXT NOT NULL"/>
<DumpTable tableName="DUMP"
dumpNameColumnType="MEDIUMTEXT NOT NULL"
dumpDateColumnType="TIMESTAMP"
dumpPathColumnType="MEDIUMTEXT NOT NULL"
dumpFormatColumnType="MEDIUMTEXT NOT NULL"
checkpointNameColumnType="MEDIUMTEXT NOT NULL"
backendNameColumnType="MEDIUMTEXT NOT NULL"
tablesColumnType="MEDIUMTEXT NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
<?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="192.168.0.128" >
<Report hideSensitiveData="true" generateOnShutdown="true" generateOnFatal="true" enableFileLogging="true" />
<JmxSettings>
<RmiJmxAdaptor/>
</JmxSettings>
<!--
<VirtualDatabase configFile="/opt/sequoia/config/virtualdatabase/myDB.xml" virtualDatabaseName="myDB" autoEnableBackends="false" />
-->
</Controller>
</SEQUOIA-CONTROLLER>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
