mysql ACL 不生效

EMQX版本 5.0.4
操作系统:linux
mysql版本 8.0

按照文档配置mysql授权,数据库如下:

查询sql
SELECT ACTION, permission, topic FROM mqtt_acl WHERE username = ${username} ORDER BY ID DESC

客户端连接后,订阅主题’a/b/c‘,emqx日志如下:
2022-12-13T07:41:32.430030+00:00 [warning] authorize_type: mysql, clientid: 20221212184627030238, exception: error, line: 413, mfa: emqx_authz:do_authorize/4, msg: unexpected_error_in_authorize, peername: 192.168.1.245:50449, reason: badarith, stacktrace: [{lists,nth,2,[{file,“lists.erl”},{line,172}]},{emqx_authz_mysql,format_result,2,[{file,“emqx_authz_mysql.erl”},{line,118}]},{emqx_authz_mysql,do_authorize,5,[{file,“emqx_authz_mysql.erl”},{line,109}]},{emqx_authz,do_authorize,4,[{file,“emqx_authz.erl”},{line,398}]},{emqx_authz,authorize_non_superuser,5,[{file,“emqx_authz.erl”},{line,337}]},{emqx_hooks,safe_execute,2,[{file,“emqx_hooks.erl”},{line,200}]},{emqx_hooks,do_run_fold,3,[{file,“emqx_hooks.erl”},{line,180}]},{emqx_access_control,do_authorize,3,[{file,“emqx_access_control.erl”},{line,81}]},{emqx_access_control,authorize,3,[{file,“emqx_access_control.erl”},{line,51}]},{emqx_channel,check_sub_authzs,3,[{file,“emqx_channel.erl”},{line,1856}]},{emqx_channel,handle_in,2,[{file,“emqx_channel.erl”},{line,504}]},{emqx_connection,with_channel,3,[{file,“emqx_connection.erl”},{line,801}]},{emqx_connection,process_msg,2,[{file,“emqx_connection.erl”},{line,466}]},{emqx_connection,process_msg,2,[{file,“emqx_connection.erl”},{line,472}]},{emqx_connection,handle_recv,3,[{file,“emqx_connection.erl”},{line,428}]},{proc_lib,wake_up,3,[{file,“proc_lib.erl”},{line,236}]}]

EMQX后台设置如下,显示已连接数据库

请问这是什么问题?如果设置No Match为deny,客户端订阅失败。

已解决