原文链接:https://www.longkui.site/error/nacosencrypted_data_key/4858/
部分报错信息:
java.sql.SQLSyntaxErrorException: Unknown column ‘encrypted_data_key’ in ‘field list’
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT id,data_id,group_id,tenant_id,app_name,content,md5,gmt_modified,type,encrypted_data_key FROM config_info WHERE id > ? ORDER BY id ASC LIMIT ?,?]; nested exception is java.sql.SQLSyntaxErrorException: Unknown column ‘encrypted_data_key’ in ‘field list’
nacos启动的时候报错了,原因是一些数据库表缺少字段
ALTER TABLE `nacos`.`config_info`
ADD COLUMN encrypted_data_key
text NOT NULL COMMENT ‘秘钥’ AFTER c_schema
;
执行上面的代码后,就可以正常启动了。