elasticsearch的.security-7索引崩溃恢复笔记

装了es 三方插件 重启后出现以下问题

failed to authenticate user [elastic]
failed to retrieve password hash for reserved user [elastic] org.elasticsearch.action.UnavailableShardsException: at least one primary shard for the index [.security-7] is unavailable

网友的解决办法
https://blog.csdn.net/lhjllff12345/article/details/126148875

另外
org.elasticsearch.bootstrap.StartupException: java.lang.IllegalArgumentException: Cannot replace existing handler for [/_sql] for method: POST

原因：elasticsearch-sql与自带的x-pack-sql模块冲突，vi /opt/elasticsearch/config/elasticsearch.yml 修改

xpack.sql.enabled: false重启ES，参考链接