audit_log_rotate() query execution time increasing per execution
General
Escalation
General
Escalation
Description
Environment
None
Activity
Show:

mohit.joshi May 1, 2023 at 9:57 AM
Re-tested with the fix. Works fine now.
Done
Details
Details
Assignee
Unassigned
UnassignedReporter

Labels
Needs QA
Yes
Sprint
None
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created April 27, 2023 at 10:17 AM
Updated April 2, 2024 at 11:40 AM
Resolved May 1, 2023 at 9:58 AM
When tried to rotate the audit logs repeatedly, it is noticed that the query execution time increases every time the logs are rotated. This maybe due to the reason that the audit plugin rechecks already existing logs to make sure newly generated name doesn't conflict.
The audit log was rotated a few times and the execution time quickly grew 3 times from initially 6s to 18s.