CDH 5.14.2 server启动报错 Can't DROP FOREIGN KEY `FK_SERVICE_CONFIG_REVISION`; check that it exists

现象：启动cloudera-scm-server报错

查看cloudera-scm-server.log
发现如下报错

2019-11-26 16:32:46,303 FATAL main:org.hsqldb.cmdline.SqlFile: SQL Error at 'UTF-8' line 2:
"alter table SERVICES
    drop foreign key FK_SERVICE_CONFIG_REVISION"
Can't DROP FOREIGN KEY `FK_SERVICE_CONFIG_REVISION`; check that it exists

查看该版本的官方文档
https://docs.cloudera.com/documentation/enterprise/release-notes/topics/rn_consolidated_pcm.html#cdh_cm_supported_db
发现是mariadb的版本过高所致


更换mysql5.6之后问题解决