The consensus follower is not allowed to to do current operation

最新推荐文章于 2021-10-18 16:38:07 发布

原创

最新推荐文章于 2021-10-18 16:38:07 发布 · 2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#xdb

博客内容描述了一种数据库操作错误，由于使用了follower的地址导致操作失败。解决方案是通过kubectleditendpoints切换到主库地址。确认主库的方法是尝试执行操作，能成功执行的即为主库。

数据库操作报如下错误：

Caused by: java.sql.SQLException: The consensus follower is not allowed to to do current operation.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)
        at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
        at org.apache.ibatis.executor.statement.P