audit log plugin truncates sqlquery to 512 bytes

Bug #1557293 reported by Jeremy Tinley
26
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Invalid
Undecided
Unassigned
5.5
Won't Fix
Medium
Unassigned
5.6
Fix Released
Medium
Sergei Glushchenko
5.7
Fix Released
Medium
Sergei Glushchenko

Bug Description

https://github.com/percona/percona-server/blob/5.5/plugin/audit_log/audit_log.c#L367

512 feels arbitrary and counterintuitive to the point of logging queries. A reasonably long INSERT / ON DUPLICATE KEY UPDATE can easily pass 512 bytes and it leaves users in the dark about what's wrong. The plugin is supposed to be used to help fulfill requirements around HIPAA and SOX and truncated data doesn't fit that goal.

Suggestion:
Increase to a larger length or make it a configuration variable.

Tags: audit
Revision history for this message
Sergei Glushchenko (sergei.glushchenko) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1703

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.