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