Percona audit log filter audit_log_read() showing "null" always instead of the bookmarked and current information
General
Escalation
General
Escalation
Description
When we try to read the JSON logs using audit log filers audit_log_read(audit_log_read_bookmark()) & SELECT audit_log_read('{"timestamp": "2025-04-17 08:03:00", "id": 752}') instead of returning the valid data it shows “null“ always.
Scenario:
So here we are having the current/bookmark positions.
Now if we try to read from the current position it shows “null“
If I explicitly provide the arguments still it not consider those and returns “null“
Medium
When we try to read the JSON logs using audit log filers audit_log_read(audit_log_read_bookmark()) & SELECT audit_log_read('{"timestamp": "2025-04-17 08:03:00", "id": 752}') instead of returning the valid data it shows “null“ always.
Scenario:
So here we are having the current/bookmark positions.
Now if we try to read from the current position it shows “null“
If I explicitly provide the arguments still it not consider those and returns “null“
This is experienced on both 8.0.40 and 8.4.4