Title: ALTRAN OUEST
Hello,

What exactly is the right procedure to initialize a cluster.
With the following configuration: RAID-b1 with 2 controllers, each having 1 virtualdatabase, each holding 1 backend.
I've done the following, as described in the Installation guide:
initialize backend on the first controller
backup backend on the first controller
transfer dump to the second controller
enable backend on the first controller

restore backend on the second controller
eanble backend on the second controller

And that's OK

But now, when I shutdown the whole with the commands:

shutdown virtualdatabase on first controller
then shutdown first controller
shutdown virtualdatabase on second controller
the shutdown second controller

All seems OK.

The surprise is at restarting the whole.
First controller starts normally
But seconds disable backend as shown in the following logs:

18:02:55,617 INFO  backend.DatabaseBackend.fr-bea Detected backend as: MySQL
18:02:55,686 INFO  controller.RequestManager.MATISSEDB Setting new virtual database schema.
18:02:55,738 ERROR controller.recoverylog.RecoverThread Unable to get checkpoint from recovery log.
java.sql.SQLException: Unable to get checkpoint disable all backends-192.168.4.201:25322-20070130180224872+0100 from the recovery log (Checkpoint disable all backends-192.168.4.201:25322-20070130180224872+0100 does not exist in recovery log)
        at org.continuent.sequoia.controller.recoverylog.events.GetCheckpointLogIdEvent.execute(GetCheckpointLogIdEvent.java:96)
        at org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:732)
18:02:55,753 INFO  sequoia.controller.connection 10 connections freed on "jdbc:mysql://fr-bea.ago.fr/MATISSE"
18:02:55,829 WARN  controller.virtualdatabase.MATISSEDB Virtual database MATISSEDB failed to enable database backend fr-bea from checkpoint (because of : java.sql.SQLException: Unable to get checkpoint from recovery log.)
java.sql.SQLException: Unable to get checkpoint from recovery log.
        at org.continuent.sequoia.controller.recoverylog.RecoverThread.run(RecoverThread.java:168)
18:02:55,829 WARN  controller.core.Controller Failed to automatically enable backends, manual resynchronization is probably needed
18:02:55,829 INFO  controller.core.Controller Adding VirtualDatabase MATISSEDB


So what's wrong in my procedure ?
Is my shutdown procedure wrong ?

Gérard
--

Gérard BUNEL
Chef de Projet
____________________________________________________________________


Technopôle Brest Iroise
Site du Vernis – CS 23866
29238 Brest Cedex 3
Tél : + 33 2 98 05 43 21
Fax : + 33 2 98 05 20 34
www.altran.com

_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Reply via email to