Skip to main content

no more buddy projections after backup/restore ?

  • October 29, 2014
  • 4 replies
  • 12 views
Luc_Lecocq
Forum|alt.badge.img+2
Hi,

I am running vertica 7.0.2.
I did a full backup of my 3 nodes cluster, reinstalled everything from scratch, including OS, vertica.
I then run the restore script vbr.py, which run smoothly, but when I start the restored database, I found out that all restored tables have no more buddy projections !

Is this normal behavior ?
What should I do to get back to the initial situation, prior to the backup, where my databbase was K-Sage ?

Thanks for helping.

    4 replies

    Raul_1
    Forum|alt.badge.img
    • Raul_1
    • Participating Frequently
    • October 30, 2014

    What is the output of the following, from your database -
    SELECT current_fault_tolerance FROM system;
    Luc_Lecocq
    Forum|alt.badge.img+2
    • Luc_Lecocq
    • Author
    • Participating Frequently
    • October 30, 2014
    It says current_fault_tolerance is 0

    Raul_1
    Forum|alt.badge.img
    • Raul_1
    • Participating Frequently
    • November 7, 2014
    If you still have the vertica.log from before you restored the DB can you check the following -
    grep K-safety= vertica.log
    Luc_Lecocq
    Forum|alt.badge.img+2
    • Luc_Lecocq
    • Author
    • Participating Frequently
    • November 7, 2014
    I created the db from scratch, and did the restore immediately after.
    The oldest log I could get shows the initial db startup right after restore, and report the db is 0-safe.
    It looks the problem was already present when doing the backup, but I do not remember having seen any warning at that time.
    To be more precise, the DB was initially running on Vertica 6.1.3.
    I updated successively to 7.0, then 7.1, and did the backup at that time.
    I also have an old backup from when the db was still running 6.1.3, but if I want to look at it, I have to reinstall vertica 6.1.3, which is not possible right now.
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement