1 问题描述
- 通过Query API查询INFLUXDB数据库数据时，查询失败，日志中报INFLUXDB数据库错误：
...
org.influxdb.InfluxDBException: user is locked
at org.influxdb.InfluxDBException.buildExceptionFromErrorMessage(InfluxDBException.java:161) ~[influxdb-java-2.22.jar!/:?]
at org.influxdb.InfluxDBException.buildExceptionForErrorState(InfluxDBException.java:173) ~[influxdb-java-2.22.jar!/:?]
at org.influxdb.impl.InfluxDBImpl.execute(InfluxDBImpl.java:846) ~[influxdb-java-2.22.jar!/:?]
at org.influxdb.impl.InfluxDBImpl.executeQuery(InfluxDBImpl.java:833) ~[influxdb-java-2.22.jar!/:?]
at org.influxdb.impl.InfluxDBImpl.query$original$NqPAZts7(InfluxDBImpl.java:559) ~[influxdb-java-2.22.jar!/:?]
at org.influxdb.impl.InfluxDBImpl.query$original$NqPAZts7$accessor$6GQc4J6p(InfluxDBImpl.java) ~[influxdb-java-2.22.jar!/:?]
at org.influxdb.impl.InfluxDBImpl$auxiliary$JDCxBf2K.call(Unknown Source) ~[influxdb-java-2.22.jar!/:?]
at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86) ~[skywalking-agent.jar:8.9.0]
at org.influxdb.impl.InfluxDBImpl.query(InfluxDBImpl.java) ~[influxdb-java-2.22.jar!/:?]
...
2 问题分析
- 根本原因：下午升级时，负责写入数据的Flink作业依赖的NACOS配置文件中密码配置错误，且用该错误密码高频请求导致了数据库用户被锁。
3 解决方法
- Step1 停止运行INFLUXDB的数据写入程序
停止之后，数据库30s默认自动解锁（否则，即使是尝试重置密码，也可能一直无法重置密码成功）
X 参考文献
- Influxdb
标签：java,InfluxDBException,jar,InfluxDBImpl,influxdb,INFLUXDB,org,2.22,locked From： https://www.cnblogs.com/johnnyzen/p/17899707.html