The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Database Starting up Error 'EncryptSpreadComm'

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

Comments

  • HibikiHibiki Vertica Employee Employee

    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.

Leave a Comment

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