Database Starting up Error 'EncryptSpreadComm'

holakokhan

There is a single node database that I did apply mistake following command:

  ALTER DATABASE DEFAULT SET PARAMETER EncryptSpreadComm = 'vertica';
  
Then I restarted DB. Unfortunately it can't be up and following error is generated.

  {
"node" : "v_DB_node0001",
"stage" : "Database Halted",
"text" : "Initialization thread logged exception:Could not find spread security details in file",
"timestamp" : "2020-10-24 13:11:20.126"
}

The question that comes to mind is that how can I handle mentioned error and start-up vertica DB again?

All the best regards

Hibiki

Can you check the configuration in /spread.conf file? When enabling that parameter, Vertica adds the line starting with '# VSpreadKey'. Or, please try to restore spread.conf file from spread.backup.conf file, then, restart the database.