mysql error log contains errors relating to audit_log_filter plugin upon successful startup

[shayancanonical]

Steps to reproduce

1. juju deploy -n 1 mysql-k8s --channel 8.0/edge

Expected behavior

No errors in the mysql error log, despite mysqld starting up successfully

Actual behavior

Error logs present

Versions

Operating system: Ubuntu 22.04.4 LTS

Juju CLI: 3.5.3-genericlinux-amd64

Juju agent: 3.5.3

Charm revision: 201

microk8s: MicroK8s v1.31.0 revision 7175

Log output

mysql error log:

2024-09-25T19:26:50.643101Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2024-09-25T19:26:50.643140Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.37-0ubuntu0.22.04.3) starting as process 512
2024-09-25T19:26:50.648666Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-09-25T19:26:52.531762Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-09-25T19:26:52.816443Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-09-25T19:26:52.816493Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-09-25T19:26:52.817152Z 0 [Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_admin. See below for the description of exact issue.
2024-09-25T19:26:52.817182Z 0 [Warning] [MY-010069] [Server] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2024-09-25T19:26:52.817197Z 0 [System] [MY-013603] [Server] No TLS configuration was given for channel mysql_admin; re-using TLS configuration of channel mysql_main.
2024-09-25T19:26:52.824947Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/lib/mysql' in the path is accessible to all OS users. Consider choosing a different direc
tory.                                              
2024-09-25T19:26:52.848514Z 7 [ERROR] [MY-011071] [Server] Plugin audit_log_filter reported: 'Failed to get an opened audit_log_filter table'
2024-09-25T19:26:52.848586Z 6 [ERROR] [MY-011071] [Server] Plugin audit_log_filter reported: 'Failed to load filtering rules'
2024-09-25T19:26:52.848612Z 6 [Warning] [MY-013360] [Server] '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
2024-09-25T19:26:52.852724Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '0.0.0.0' port: 33060, socket: /var/run/mysqld/mysqlx.sock

Additional context

[syncronize-issues-to-jira]

Thank you for reporting us your feedback!

The internal ticket has been created: https://warthogs.atlassian.net/browse/DPE-5557.

This message was autogenerated