Prepared statements are written to general query log after being executed
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| | MySQL Server |
Unknown
|
Unknown
|
||
| | Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Unassigned | |
| | 5.1 |
Won't Fix
|
Medium
|
Sergei Glushchenko | |
| | 5.5 |
Fix Committed
|
Medium
|
Sergei Glushchenko | |
| | 5.6 |
Fix Released
|
Medium
|
Unassigned | |
Bug Description
Prepared statements logged to general query log and audit plugin notified after statement being executed unlike most other log events which are written before query being executed.
Related branches
- Alexey Kopytov (community): Needs Information on 2013-06-16
- Laurynas Biveinis (community): Needs Information on 2013-06-14
-
Diff: 53 lines (+18/-18)1 file modifiedPercona-Server/sql/sql_prepare.cc (+18/-18)
- Laurynas Biveinis (community): Needs Fixing on 2013-06-14
- Alexey Kopytov: Pending requested 2013-06-16
-
Diff: 105 lines (+55/-18)4 files modifiedPercona-Server/mysql-test/r/percona_bug1182949.result (+12/-0)
Percona-Server/mysql-test/t/percona_bug1182949-master.opt (+1/-0)
Percona-Server/mysql-test/t/percona_bug1182949.test (+24/-0)
Percona-Server/sql/sql_prepare.cc (+18/-18)
- Laurynas Biveinis (community): Needs Fixing on 2013-06-14
- Alexey Kopytov: Pending requested 2013-06-16
It seems that, for prepared statements, not only executing, but preparing is affected too.
| Alexey Kopytov (akopytov) wrote : | #3 |
Preparing a client-side prepared statement is currently ignored by the scalability metrics plugin anyway (its current implementation only tracks COM_QUERY and COM_STMT_EXECUTE).
Also, as there's no audit plugin interface in 5.1, do we really want to fix this in 5.1?
Preparing the statement can easily be tracked by scalability metrics plugin and I am going to implements this.
I agree that we can mark it as won't fix for 5.1. Does somebody has an objections?
Upstream is fixed in 5.7, do we want to port the fix into 5.1/5.5/5.6 ?
| Shahriyar Rzayev (rzayev-sehriyar) wrote : | #7 |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/
Sergei -
This is an upstream bug, isn't? Can you link one here?