Error starting database with no good epoch (epoch 0)

Error starting database after unexpected restart. No good epoch. No backup.

How we can resolve this?

Vertica.log:
2015-02-22 10:57:44.140 Main:0x745e930 [Init] <INFO> Startup [Check Storage] Removing unnecessary storage files2015-02-22 10:57:44.153 Main:0x745e930 [Init] <INFO> Startup [Check Storage] Confirming storage matches catalog (files) - 0 / 216
2015-02-22 10:57:44.153 Main:0x745e930 [Catalog] <INFO> Checking 216 files in 2 threads
2015-02-22 10:57:44.154 nameless:0x78b72b0 [Catalog] <WARNING> Error getting size of file [/media/twingo/49d27a86-4ffd-4837-8319-2da68cc1bfea/vertica_data/811/45035996273930811/45035996273930811_0.fdb]: No such file or directory
2015-02-22 10:57:44.154 nameless:0x79505c0 [Catalog] <WARNING> Error getting size of file [/media/twingo/49d27a86-4ffd-4837-8319-2da68cc1bfea/vertica_data/493/45035996273931493/45035996273931493_0.fdb]: No such file or directory
2015-02-22 10:57:44.154 nameless:0x78b72b0 <WARNING> @v_meta_networks_node0001: 01000/3938: MiniRos 45035996273930811 does not have proper SAL files
2015-02-22 10:57:44.154 nameless:0x79505c0 <WARNING> @v_meta_networks_node0001: 01000/3938: MiniRos 45035996273931493 does not have proper SAL files

Comments

  • Hi!

    Nno worries, you have CSV files as backup in - /archive dir. Database isn't so big, to reload data will take about 2 hours ;)

    Cheers :)
  • Hi Daniel! I'am not worry, it's only developer database with 0.5 TB of data. I take it as a case study and want to learn how we can to reanimate the server. Any ideas?
  • In this case you have no choice, only a backup or may be only with fsck.
    The problem here is -
    /media/twingo/...
    or its a bad system configuration or its a bad hardware planing.
    man hier
    ...
    /media This directory contains mount points for removable media such as CD and DVD disks or USB sticks.
    ...
    I bet on a second. 
    Only an advise - if you will continue to use in mountable USB disk as a storage you will need to advance an epoch more frequently. You can do it manually or you can reconfigure Vertica to do it more frequently.

    Remember - Vertica is a disk based database ;)

    cheers
  • Thanks you very much for your participation! I'll try to repair fs by fsck. I think you're right - a problem in system configuration, but /media/twingo/... it's a internal HDD...

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file