Hi, Does it replay the inserts/updates okay?, but not the alter table statement / create table, is it possible this is not getting written to the recovery log. You can take a look through the recovery log for this on the actual database that you are using for the recovery log.
Regards, On Tue, 30 Oct 2007 22:11:47 -0400 (EDT) "Dominic Vieira (JIRA)" <[EMAIL PROTECTED]> wrote: > [ > https://forge.continuent.org/jira/browse/SEQUOIA-996?page=comments#action_14113 > ] > > Dominic Vieira commented on SEQUOIA-996: > ---------------------------------------- > > Yes, the recovery logs resides on a database server that is also used > as one of the backends. There doesn't seem to be any errors reported > in the logs. I have attached my VDB definition files. > > > Recovery log is not applied when backend is enabled > > --------------------------------------------------- > > > > Key: SEQUOIA-996 > > URL: https://forge.continuent.org/jira/browse/SEQUOIA-996 > > Project: Sequoia > > Type: Bug > > > Components: Backup System > > Versions: Sequoia 2.9 > > Environment: Linux Redhat with postgres 8.2.5 > > Reporter: Dominic Vieira > > > > > > > I have setup sequoia with two postgres backends. I activate the > > cluster accordling to the user guide documentation. 1. Initialize > > BE1 2. Enable BE1 > > 3.Create a backup of BE1 > > 4.Restore to BE2 > > 5. Enable BE2 > > 6. Insert 2 rows, they appear in both > > 7. I disable BE2 > > 8. Insert row 3, appears only in BE1 (good) > > 9.Enable BE2 **I expected to see the row replicated over to BE2, > > but it doesn't and the backends are out of sync with both backends > > showing enabled*** The checkpoints appear correct in the recovery > > logs and also in "show backend *" Is there something wrong here? > -- Stuart James Senior Systems Administrator PayPoint Internet Payment Services 203 High Street, Tonbridge TN9 1BW, UK Direct: +44 (0)1732 300205 Mobile: +44 (0)7809 504773 SECPay Ltd registered offices. 1 The Boulevard, Shire Park, Welwyn Garden City, Hertfordshire, AL7 1EL This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. SECPay Ltd does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by SECPay Ltd in this regard and the recipient should carry out such virus and other checks as it considers appropriate. _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
