Hello All,
I'm new to the list so please bare with me if this is something I should
have found elsewhere before posting.
I am testing sequoia in a raidb-1 configuration with mysql. We have a
couple of databases and in which I have had to set in /etc/my.cnf a
variable in which I think is causing the following error. Right now I
have only one controller, but I plan on having 2 controllers and two
databases
max_allowed_packet=32M is set in our my.cnf.
now when implementing sequoia
SQA_VIASDSYDB(root) > restore backend DB1 initial_dump
Backend login for restore process > root
Backend password for restore process >
Restoring backend DB1 with dump initial_dump
This seems to be fine, however when I enable the backend I get this
error:
SQA_VIASDSYDB(root) > enable DB1
Enabling backend DB1 from its last known checkpoint
Virtual database SQA_VIASDSYDB failed to enable database backend DB1
from checkpoint (because of : java.sql.SQLException: Unable to get
checkpoint from recovery log.)
Did I miss something? If there is any where to get an ideal
configuration for jboss servers connecting to a raidb-1 mysql controller
that would be even better. I'm worried that this import is failing due
to some blobs of data that require this max_allowed_packet
Any help would be great.
16:49:26,158 INFO backup.backupers.NativeCommandExec Command "mysql -h
192.168.61.14 --port=3306 -uroot --password= DB1
16:49:26,166 ERROR controller.backend.BackendStateListener Could not
store information for backend: DB1
java.sql.SQLException: Unable to get checkpoint disable
DB1-192.168.61.14:25322-20080226023634223-0500 from the recoveryn
recovery log)
at
org.continuent.sequoia.controller.recoverylog.events.GetCheckpointLogIdE
vent.execute(GetCheckpointLogIdEvent.
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThr
ead.java:732)
16:49:26,168 INFO controller.RequestManager.SQA_VIASDSYDB Recovery of
backend DB1 done.
16:49:45,090 INFO DatabaseBackend.SQA_VIASDSYDB.DB1 Detected backend
as: MySQL
16:49:47,106 INFO controller.RequestManager.SQA_VIASDSYDB Setting new
virtual database schema.
16:49:47,113 ERROR controller.recoverylog.RecoverThread Unable to get
checkpoint from recovery log.
java.sql.SQLException: Unable to get checkpoint disable
DB1-192.168.61.14:25322-20080226023634223-0500 from the recoveryn
recovery log)
at
org.continuent.sequoia.controller.recoverylog.events.GetCheckpointLogIdE
vent.execute(GetCheckpointLogIdEvent.
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThr
ead.java:732)
16:49:47,120 INFO sequoia.controller.connection 10 connections freed on
"jdbc:mysql://192.168.61.14:3306/DB1_iasdsydb"
16:49:47,199 WARN controller.virtualdatabase.SQA_VIASDSYDB Virtual
database SQA_VIASDSYDB failed to enable database bacrom recovery log.)
java.sql.SQLException: Unable to get checkpoint from recovery log.
at
org.continuent.sequoia.controller.recoverylog.RecoverThread.run(RecoverT
hread.java:168)
Regards,
Jonathan D. Poole
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
