Add a new node to database failed.

Hello Jean,

I assume then that your database came to a stop? If you look back in vertica.log, you can see how it shut down. Did it shut down cleanly or come to an abrupt stop with an error?

The database has detected a missing data file. It doesn't seem that the error is related to attempting to add a new node. The database checks for data files at start-up, so this file could have gone missing at any time since the previous time your database started. For some users, that can be many days earlier.

Without this data file, the database cannot start with consistent state. It's not clear why the file might be missing... perhaps you can investigate potential problems with the disk on your system or determine if a privileged user erroneously deleted the data manually. Can you find 45035996281655281_0.fdb anywhere? Perhaps you can recover it from somewhere and the database will then start.

The recommended way forward is to restore from a backup or to let the node recover from its peers in the cluster. Because you had a 1-node database, you did not have fault tolerance / data redundancy, so recovery from peers is not an option. Do you have a backup?

The only other way "out" is to engage technical support (if you have a contract) and they can help determine which table or projection is associated with the missing data. They may be able to limit data loss to that projection alone, rather than the entire database.

Sorry to hear about your troubles. Backups are your friend! Especially for databases without data redundancy.

- Derrick