526互联

[INFLUXDB] 查询数据时，INFLUXDB报“InfluxDBException: user is locked”

发布时间 2023-12-13 18:44:28作者: 千千寰宇

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