tidb-server一直报Unknown Auth Plugin?

lindoubled · 2022 年1 月 15 日 12:39

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"]
^

spc_monkey · 2022 年1 月 16 日 07:00

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

lindoubled · 2022 年1 月 16 日 09:34

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

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

lindoubled · 2022 年1 月 16 日 09:47

整个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

qizheng · 2022 年1 月 17 日 03:24

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

lindoubled · 2022 年1 月 17 日 03:26

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

system · 2022 年10 月 31 日 19:09

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