# Audit log filter not working after upgrade from Percona 8.0.41 to 8.4.4

**URL:** <https://forums.percona.com/t/audit-log-filter-not-working-after-upgrade-from-percona-8-0-41-to-8-4-4/37992>\
**Category:** Uncategorized\
**Created:** [May 17, 2025, 6:16pm UTC](https://forums.percona.com/t/audit-log-filter-not-working-after-upgrade-from-percona-8-0-41-to-8-4-4/37992 "2025-05-17T18:16:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![redssr](https://avatars.discourse-cdn.com/v4/letter/r/a9a28c/32.png) [@redssr](https://forums.percona.com/u/redssr)\
**Post date:** [May 17, 2025, 6:16pm UTC](https://forums.percona.com/t/audit-log-filter-not-working-after-upgrade-from-percona-8-0-41-to-8-4-4/37992/1 "2025-05-17T18:16:38Z")

</div>

Dear friends,  
Thanks again for solving my previous issue on [How to skip select or all read operation in audit\_log\_filter in percona 8.4 - #5 by redssr](https://forums.percona.com/t/how-to-skip-select-or-all-read-operation-in-audit-log-filter-in-percona-8-4/37956/5) thread

Now i am in different issue, While upgrading from Percona 8.0.41 with legacy audit\_log feature to Percona 8.4.4 with audit\_log\_filter component, i am not able to enable audit log, getting below error

mysql\> SELECT audit\_log\_filter\_set\_filter(‘log\_all’, ‘{ “filter”: { “log”: true } }’);  
±------------------------------------------------------------------------+  
| audit\_log\_filter\_set\_filter(‘log\_all’, ‘{ “filter”: { “log”: true } }’) |  
±------------------------------------------------------------------------+  
| ERROR: Failed to check filtering rule name existence |  
±------------------------------------------------------------------------+  
1 row in set (0.01 sec)

In mysql error log i am gerting this  
2025-05-17T23:22:40.157914+05:30 12 [ERROR] [MY-011071] [Server] Component audit\_log\_filter reported: ‘Failed to start table access transaction’  
2025-05-17T23:22:40.157966+05:30 11 [ERROR] [MY-011071] [Server] Component audit\_log\_filter reported: ‘Failed to load filtering rules’  
2025-05-17T23:25:04.479412+05:30 13 [ERROR] [MY-011071] [Server] Component audit\_log\_filter reported: ‘Failed to start table access transaction’  
2025-05-17T23:25:04.479493+05:30 11 [ERROR] [MY-048112] [Server] Component audit\_log\_filter reported: ‘Failed to check filtering rule name existence’  
2025-05-17T23:25:09.077175+05:30 14 [ERROR] [MY-011071] [Server] Component audit\_log\_filter reported: ‘Failed to start table access transaction’  
2025-05-17T23:25:09.077245+05:30 11 [ERROR] [MY-048059] [Server] Component audit\_log\_filter reported: ‘Failed to check filtering rule name existence’  
2025-05-17T23:35:41.002075+05:30 15 [ERROR] [MY-011071] [Server] Component audit\_log\_filter reported: ‘Failed to start table access transaction’  
2025-05-17T23:35:41.002133+05:30 11 [ERROR] [MY-011071] [Server] Component audit\_log\_filter reported: ‘Failed to load filtering rules’  
2025-05-17T23:36:25.266203+05:30 16 [ERROR] [MY-011071] [Server] Component audit\_log\_filter reported: ‘Failed to start table access transaction’  
2025-05-17T23:36:25.266276+05:30 11 [ERROR] [MY-048059] [Server] Component audit\_log\_filter reported: ‘Failed to check filtering rule name existence’

Along with these errors i am also getting below error in log  
2025-05-17T23:38:39.387011+05:30 0 [ERROR] [MY-010901] [Server] Can’t open shared library ‘/db/mysql/lib/plugin/audit\_log\_filter.so’ (errno: 0 /db/mysql/lib/plugin/audit\_log\_filter.so: undefined symbol: my\_thread\_init).

but i had already remove audit\_log\_plugin before upgrading from 8.0.41 to 8.4.4

I already tried uninstalling and installing of component as well in 8.4.4

But when i insert same filter on fresh 8.4.4 instance it works without any error

Is something am i missing here

---

<div class="post-metadata">

**Author:** ![Yunus](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yunus/32/6430_2.png) [@Yunus](https://forums.percona.com/u/Yunus)\
**Post date:** [May 22, 2025, 4:38pm UTC](https://forums.percona.com/t/audit-log-filter-not-working-after-upgrade-from-percona-8-0-41-to-8-4-4/37992/2 "2025-05-22T16:38:46Z")

</div>

> [@redssr](#):
>
> ERROR: Failed to check filtering rule name existence

The audit log filter component looks for `audit_log_filter` and `audit_log_user` tables in the database specified in the `audit_log_filter.database` variable (by default is the `mysql` database).

> **[Audit log filter functions, options, and variables - Percona Server for MySQL](https://docs.percona.com/percona-server/8.4/audit-log-filter-variables.html#audit_log_filterdatabase)**
>
> The following sections describe the functions, options, and variables available in the audit log filter component.

Check it with

```auto
show variables like '%audit_log_filter.database%';

```

Make sure that those tables are present.  
Follow this and it should work

> **[Install the Audit Log Filter - Percona Server for MySQL](https://docs.percona.com/percona-server/8.0/install-audit-log-filter.html)**
>
> The plugin\_dir system variable defines the plugin library location. If needed, at server startup, set the plugin\_dir variable.
