Jonathan,
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.
If the queries were originally executed with that value, there should
not be any issue to replay with that value.
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
Which backuper are you using?
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?
There is probably a problem with the way you generated the dump. When
you did the backup operation, it was associated to a checkpoint
corresponding to the backend state at that time. It looks like this
checkpoint does not exist anymore in your recovery log for some reason
(initialize command, recovery log resynchronization, purge log...).
You should recreate a valid dump with a proper checkpoint. There are
various command to list dumps and checkpoints in the recovery log if you
want to check manually.
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
If max_allowed_packet was an issue, I guess the problem would also
happen at backup time, not only restore.
Keep us posted with your progress,
Emmanuel
--
Emmanuel Cecchet - Research scientist
EPFL - LABOS/DSLAB - IN.N 317
Phone: +41-21-693-7558
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
