tidb-server一直报Unknown Auth Plugin?

tidb v5.3.0版本

tidb-server一直报这个错误

[2022/01/15 20:37:08.782 +08:00] [WARN] [conn.go:573] ["parse attrs failed"] [conn=57554685] [error=EOF]
[2022/01/15 20:37:08.782 +08:00] [WARN] [conn.go:713] ["failed to check the user authplugin"] [conn=57554685] [error="Failed to get user record"]
[2022/01/15 20:37:08.782 +08:00] [WARN] [conn.go:728] ["Unknown Auth Plugin"] [conn=57554685] [plugin=]
[2022/01/15 20:37:08.782 +08:00] [ERROR] [terror.go:307] ["encountered error"] [error="Unknown auth plugin"] [stack="github.com/pingcap/tidb/parser/terror.Log\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/parser/terror/terror.go:307\
github.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:519"]
[2022/01/15 20:37:08.783 +08:00] [WARN] [conn.go:573] ["parse attrs failed"] [conn=57554689] [error=EOF]
[2022/01/15 20:37:08.783 +08:00] [WARN] [conn.go:713] ["failed to check the user authplugin"] [conn=57554689] [error="Failed to get user record"]
[2022/01/15 20:37:08.783 +08:00] [WARN] [conn.go:728] ["Unknown Auth Plugin"] [conn=57554689] [plugin=]
[2022/01/15 20:37:08.783 +08:00] [ERROR] [terror.go:307] ["encountered error"] [error="Unknown auth plugin"] [stack="github.com/pingcap/tidb/parser/terror.Log\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/parser/terror/terror.go:307\
github.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:519"]
[2022/01/15 20:37:08.783 +08:00] [WARN] [conn.go:573] ["parse attrs failed"] [conn=57554687] [error=EOF]
[2022/01/15 20:37:08.783 +08:00] [WARN] [conn.go:713] ["failed to check the user authplugin"] [conn=57554687] [error="Failed to get user record"]
[2022/01/15 20:37:08.783 +08:00] [WARN] [conn.go:728] ["Unknown Auth Plugin"] [conn=57554687] [plugin=]
[2022/01/15 20:37:08.783 +08:00] [ERROR] [terror.go:307] ["encountered error"] [error="Unknown auth plugin"] [stack="github.com/pingcap/tidb/parser/terror.Log\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/parser/terror/terror.go:307\
github.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:519"]
[2022/01/15 20:37:08.786 +08:00] [WARN] [conn.go:573] ["parse attrs failed"] [conn=57554691] [error=EOF]
[2022/01/15 20:37:08.786 +08:00] [WARN] [conn.go:713] ["failed to check the user authplugin"] [conn=57554691] [error="Failed to get user record"]
[2022/01/15 20:37:08.786 +08:00] [WARN] [conn.go:728] ["Unknown Auth Plugin"] [conn=57554691] [plugin=]
[2022/01/15 20:37:08.786 +08:00] [ERROR] [terror.go:307] ["encountered error"] [error="Unknown auth plugin"] [stack="github.com/pingcap/tidb/parser/terror.Log\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/parser/terror/terror.go:307\
github.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:519"]
^
1 个赞

换个 高版本的 mysql client 试试呢(以前有个类似的 bug)

1 个赞

报大量的错误,导致空间满了

但是应用程序访问tidb是正常

1 个赞

整个tidb qps只有3左右:

但是tidb-server 一直报大量的Unknown auth plugin错误,三个tidb-server节点都一直在打印错误日志:

[2022/01/16 17:47:12.216 +08:00] [WARN] [conn.go:728] ["Unknown Auth Plugin"] [conn=74445055] [plugin=]
[2022/01/16 17:47:12.216 +08:00] [ERROR] [terror.go:307] ["encountered error"] [error="Unknown auth plugin"] [stack="github.com/pingcap/tidb/parser/terror.Log\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/parser/terror/terror.go:307\
github.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:519"]
[2022/01/16 17:47:12.216 +08:00] [WARN] [conn.go:573] ["parse attrs failed"] [conn=74445057] [error=EOF]
[2022/01/16 17:47:12.217 +08:00] [WARN] [conn.go:713] ["failed to check the user authplugin"] [conn=74445057] [error="Failed to get user record"]
[2022/01/16 17:47:12.217 +08:00] [WARN] [conn.go:728] ["Unknown Auth Plugin"] [conn=74445057] [plugin=]
[2022/01/16 17:47:12.217 +08:00] [ERROR] [terror.go:307] ["encountered error"] [error="Unknown auth plugin"] [stack="github.com/pingcap/tidb/parser/terror.Log\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/parser/terror/terror.go:307\
github.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:519"]
[2022/01/16 17:47:12.219 +08:00] [WARN] [conn.go:573] ["parse attrs failed"] [conn=74445059] [error=EOF]
[2022/01/16 17:47:12.219 +08:00] [WARN] [conn.go:713] ["failed to check the user authplugin"] [conn=74445059] [error="Failed to get user record"]
[2022/01/16 17:47:12.219 +08:00] [WARN] [conn.go:728] ["Unknown Auth Plugin"] [conn=74445059] [plugin=]
[2022/01/16 17:47:12.219 +08:00] [ERROR] [terror.go:307] ["encountered error"] [error="Unknown auth plugin"] [stack="github.com/pingcap/tidb/parser/terror.Log\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/parser/terror/terror.go:307\
github.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:519"]
[2022/01/16 17:47:12.221 +08:00] [WARN] [conn.go:573] ["parse attrs failed"] [conn=74445061] [error=EOF]
[2022/01/16 17:47:12.221 +08:00] [WARN] [conn.go:713] ["failed to check the user authplugin"] [conn=74445061] [error="Failed to get user record"]
[2022/01/16 17:47:12.221 +08:00] [WARN] [conn.go:728] ["Unknown Auth Plugin"] [conn=74445061] [plugin=]
[2022/01/16 17:47:12.221 +08:00] [ERROR] [terror.go:307] ["encountered error"] [error="Unknown auth plugin"] [stack="github.com/pingcap/tidb/parser/terror.Log\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/parser/terror/terror.go:307\
github.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:519"]
[2022/01/16 17:47:12.224 +08:00] [WARN] [conn.go:573] ["parse attrs failed"] [conn=74445063] [error=EOF]
[2022/01/16 17:47:12.224 +08:00] [WARN] [conn.go:713] ["failed to check the user authplugin"] [conn=74445063] [error="Failed to get user record"]
[2022/01/16 17:47:12.224 +08:00] [WARN] [conn.go:728] ["Unknown Auth Plugin"] [conn=74445063] [plugin=]
[2022/01/16 17:47:12.225 +08:00] [ERROR] [terror.go:307] ["encountered error"] [error="Unknown auth plugin"] [stack="github.com/pingcap/tidb/parser/terror.Log\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/parser/terror/terror.go:307\
github.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:519"]
^C

1 个赞

是不是有老版本的 mysql client 连接 tidb
https://github.com/pingcap/tidb/issues/29725

好的,我们早上排查了下,确实是有旧的连接一直连tidb,谢谢回复

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。