Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.