Merge lp:~hrvojem/percona-server/rn-5.5.39-36.0-5.5 into lp:percona-server/5.5

Proposed by Hrvoje Matijakovic on 2014-08-28
Status: Merged
Approved by: Laurynas Biveinis on 2014-08-28
Approved revision: 692
Merged at revision: 695
Proposed branch: lp:~hrvojem/percona-server/rn-5.5.39-36.0-5.5
Merge into: lp:percona-server/5.5
Diff against target: 367 lines (+150/-24)
4 files modified
doc/source/management/audit_log_plugin.rst (+79/-7)
doc/source/release-notes/Percona-Server-5.5.39-36.0.rst (+35/-0)
doc/source/release-notes/release-notes_index.rst (+1/-0)
doc/source/upstream-bug-fixes.rst (+35/-17)
To merge this branch: bzr merge lp:~hrvojem/percona-server/rn-5.5.39-36.0-5.5
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) 2014-08-28 Approve on 2014-08-28
Review via email: mp+232521@code.launchpad.net
To post a comment you must log in.
review: Needs Fixing
review: Needs Fixing
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'doc/source/management/audit_log_plugin.rst'
2--- doc/source/management/audit_log_plugin.rst 2014-04-30 09:32:01 +0000
3+++ doc/source/management/audit_log_plugin.rst 2014-08-28 13:26:38 +0000
4@@ -87,7 +87,7 @@
5 Log Format
6 ==========
7
8-Audit log plugin supports two formats. In one format (``OLD``) log record properties are saved as XML attributes and in the other (``NEW``) log recored properties are saved as XML tags. Audit log format can be set up with the :variable:`audit_log_format` variable.
9+The audit log plugin supports four log formats: ``OLD``, ``NEW``, ``JSON``, and ``CSV``. ``OLD`` and ``NEW`` formats are based on XML, where the former outputs log record properties as XML attributes and the latter as XML tags. Information logged is the same in all four formats. The log format choice is controlled by :variable:`audit_log_format` variable.
10
11 Example of the ``OLD`` format: ::
12
13@@ -122,6 +122,25 @@
14 <DB></DB>
15 </AUDIT_RECORD>
16
17+Example of the ``JSON`` format: ::
18+
19+ {"audit_record":{"name":"Query","record":"4707_2014-08-27T10:43:52","timestamp":"2014-08-27T10:44:19 UTC","command_class":"show_databases","connection_id":"37","status":0,"sqltext":"show databases","user":"root[root] @ localhost []","host":"localhost","os_user":"","ip":""}}
20+
21+Example of the ``CSV`` format: ::
22+
23+ "Query","49284_2014-08-27T10:47:11","2014-08-27T10:47:23 UTC","show_databases","37",0,"show databases","root[root] @ localhost []","localhost","",""
24+
25+.. _streaming_to_syslog:
26+
27+Streaming the audit log to syslog
28+=================================
29+
30+Ability to stream the audit log to `syslog <http://www.syslog.org/>`_ was implemented in |Percona Server| :rn:`5.5.39-36.0`. To stream the audit log to syslog you'll need to set :variable:`audit_log_handler` variable to ``SYSLOG``. To control the syslog file handler, the following variables can be used: :variable:`audit_log_syslog_ident`, :variable:`audit_log_syslog_facility`, and :variable:`audit_log_syslog_priority` These variables have the same meaning as appropriate parameters described in the `syslog(3) manual <http://linux.die.net/man/3/syslog>`_.
31+
32+.. note::
33+
34+ Variables: :variable:`audit_log_strategy`, :variable:`audit_log_buffer_size`, :variable:`audit_log_rotate_on_size`, :variable:`audit_log_rotations` have effect only with ``FILE`` handler.
35+
36 System Variables
37 ================
38
39@@ -142,6 +161,8 @@
40 * ``SEMISYNCHRONOUS`` - log directly to file, do not flush and sync every event
41 * ``SYNCHRONOUS`` - log directly to file, flush and sync every event
42
43+This variable has effect only when :variable:`audit_log_handler` is set to ``FILE``.
44+
45 .. variable:: audit_log_file
46
47 :version 5.5.37-35.0: Implemented
48@@ -173,19 +194,20 @@
49 :vartype: Numeric
50 :default: 4096
51
52-This variable can be used to specify the size of memory buffer used for logging, used when :variable:`audit_log_strategy` variable is set to ``ASYNCHRONOUS`` or ``PERFORMANCE`` values.
53+This variable can be used to specify the size of memory buffer used for logging, used when :variable:`audit_log_strategy` variable is set to ``ASYNCHRONOUS`` or ``PERFORMANCE`` values. This variable has effect only when :variable:`audit_log_handler` is set to ``FILE``.
54
55 .. variable:: audit_log_format
56
57- :version 5.5.37-35.0: Implemented
58+ :version 5.5.37-35.0: Original implementation
59+ :version 5.5.39-36.0: Implemented support for ``CSV`` and ``JSON`` log formats
60 :cli: Yes
61 :scope: Global
62 :dyn: No
63 :vartype: String
64 :default: OLD
65- :allowed values: ``OLD``, ``NEW``
66+ :allowed values: ``OLD``, ``NEW``, ``CSV``, ``JSON``
67
68-This variable is used to specify the audit log format. When this variable is set to ``OLD`` information will be logged as XML attributes, and when is set to ``NEW`` it will be logged as XML tags.
69+This variable is used to specify the audit log format. The audit log plugin supports four log formats: ``OLD``, ``NEW``, ``JSON``, and ``CSV``. ``OLD`` and ``NEW`` formats are based on XML, where the former outputs log record properties as XML attributes and the latter as XML tags. Information logged is the same in all four formats.
70
71 .. variable:: audit_log_policy
72
73@@ -213,7 +235,7 @@
74 :vartype: Numeric
75 :default: 0 (don't rotate the log file)
76
77-This variable is used to specify the size of the audit log file. When this size is reached log will get rotated. Old log can be found in the same directory, audit log sequential number will be appended to the name specified in the :variable:`audit_log_file` variable.
78+This variable is used to specify the maximum audit log file size. Upon reaching this size the log will be rotated. The rotated log files will be present in the same same directory as the current log file. A sequence number will be appended to the log file name upon rotation. This variable has effect only when :variable:`audit_log_handler` is set to ``FILE``.
79
80 .. variable:: audit_log_rotations
81
82@@ -224,11 +246,61 @@
83 :vartype: Numeric
84 :default: 0
85
86-This variable is used to specify how many log files should be kept when :variable:`audit_log_rotate_on_size` variable is set to non-zero value.
87+This variable is used to specify how many log files should be kept when :variable:`audit_log_rotate_on_size` variable is set to non-zero value. This variable has effect only when :variable:`audit_log_handler` is set to ``FILE``.
88+
89+.. variable:: audit_log_handler
90+
91+ :version 5.5.39-36.0: Implemented
92+ :cli: Yes
93+ :scope: Global
94+ :dyn: No
95+ :vartype: String
96+ :default: FILE
97+ :allowed values: ``FILE``, ``SYSLOG``
98+
99+This variable is used to configure where the audit log will be written. If it is set to ``FILE``, the log will be written into a file specified by :variable:`audit_log_file` variable. If it is set to ``SYSLOG``, the audit log will be written to syslog.
100+
101+.. variable:: audit_log_syslog_ident
102+
103+ :version 5.5.39-36.0: Implemented
104+ :cli: Yes
105+ :scope: Global
106+ :dyn: No
107+ :vartype: String
108+ :default: percona-audit
109+
110+This variable is used to specify the ``ident`` value for syslog. This variable has the same meaning as the appropriate parameter described in the `syslog(3) manual <http://linux.die.net/man/3/syslog>`_.
111+
112+.. variable:: audit_log_syslog_facility
113+
114+ :version 5.5.39-36.0: Implemented
115+ :cli: Yes
116+ :scope: Global
117+ :dyn: No
118+ :vartype: String
119+ :default: LOG_USER
120+
121+This variable is used to specify the ``facility`` value for syslog. This variable has the same meaning as the appropriate parameter described in the `syslog(3) manual <http://linux.die.net/man/3/syslog>`_.
122+
123+.. variable:: audit_log_syslog_priority
124+
125+ :version 5.5.39-36.0: Implemented
126+ :cli: Yes
127+ :scope: Global
128+ :dyn: No
129+ :vartype: String
130+ :default: LOG_INFO
131+
132+This variable is used to specify the ``priority`` value for syslog. This variable has the same meaning as the appropriate parameter described in the `syslog(3) manual <http://linux.die.net/man/3/syslog>`_.
133
134 Version Specific Information
135 ============================
136
137 * :rn:`5.5.37-35.0`
138 Audit Log plugin has been implemented in |Percona Server|.
139+ * :rn:`5.5.39-36.0`
140+ |Percona Server| :ref:`audit_log_plugin` now supports ``JSON`` and ``CSV`` log formats.
141+ * :rn:`5.5.39-36.0`
142+ |Percona Server| :ref:`audit_log_plugin` now supports :ref:`streaming the audit log to syslog <streaming_to_syslog>`.
143
144+
145
146=== added file 'doc/source/release-notes/Percona-Server-5.5.39-36.0.rst'
147--- doc/source/release-notes/Percona-Server-5.5.39-36.0.rst 1970-01-01 00:00:00 +0000
148+++ doc/source/release-notes/Percona-Server-5.5.39-36.0.rst 2014-08-28 13:26:38 +0000
149@@ -0,0 +1,35 @@
150+.. rn:: 5.5.39-36.0
151+
152+==============================
153+ |Percona Server| 5.5.39-36.0
154+==============================
155+
156+Percona is glad to announce the release of |Percona Server| 5.5.39-36.0 on August 29th, 2014. Downloads are available `here <http://www.percona.com/downloads/Percona-Server-5.5/Percona-Server-5.5.39-36.0/>`_ and from the :doc:`Percona Software Repositories </installation>`.
157+
158+Based on `MySQL 5.5.39 <http://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-39.html>`_, including all the bug fixes in it, |Percona Server| 5.5.39-36.0 is now the current stable release in the 5.5 series. All of |Percona|'s software is open-source and free, all the details of the release can be found in the `5.5.39-36.0 milestone at Launchpad <https://launchpad.net/percona-server/+milestone/5.5.39-36.0>`_.
159+
160+New Features
161+============
162+
163+ |Percona Server| :ref:`audit_log_plugin` now supports ``JSON`` and ``CSV`` formats. The format choice is controlled by :variable:`audit_log_format` variable.
164+
165+ |Percona Server| :ref:`audit_log_plugin` now supports :ref:`streaming the audit log to syslog <streaming_to_syslog>`.
166+
167+Bugs Fixed
168+==========
169+
170+ Querying :table:`INNODB_CHANGED_PAGES` with a range condition ``START_LSN > x AND END_LSN < y`` would lead to a server crash if the range was empty with x greater than y. Bug fixed :bug:`1202252` (*Jan Lindström* and *Sergei Petrunia*).
171+
172+ With :ref:`changed_page_tracking` feature enabled, queries from the :table:`INNODB_CHANGED_PAGES` could read the bitmap data whose write was in still progress. This would cause the query to fail with an ``ER_CANT_FIND_SYSTEM_REC`` and a warning printed to the server error log. The workaround is to add an appropriate ``END_LSN``-limiting condition to the query. Bug fixed :bug:`1346122`.
173+
174+ ``mysqld-debug`` was missing from *Debian* packages. This regression was introduced in |Percona Server| :rn:`5.5.36-34.0`. Bug fixed :bug:`1290087`.
175+
176+ Fixed a memory leak in :ref:`slowlog_rotation`. Bug fixed :bug:`1314138`.
177+
178+ The audit log plugin would write log with XML syntax errors when ``OLD`` and ``NEW`` formats were used. Bug fixed :bug:`1320879`.
179+
180+ A server built with system OpenSSL support, such as the distributed Percona Server binaries, had SSL-related memory leaks. Bug fixed :bug:`1334743` (upstream :mysqlbug:`73126`).
181+
182+ If the bitmap directory has a bitmap file sequence with a start LSN of one file less than a start LSN of the previous file, a debug build would assert when queries were run on :table:`INNODB_CHANGED_PAGES` table. Bug fixed :bug:`1342494`.
183+
184+Other bugs fixed: :bug:`1337324`, :bug:`1151723`, :bug:`1182050`, :bug:`1182072`, :bug:`1280875`, :bug:`1182046`, :bug:`1328482` (upstream :mysqlbug:`73418`), and :bug:`1334317` (upstream :mysqlbug:`73111`).
185
186=== modified file 'doc/source/release-notes/release-notes_index.rst'
187--- doc/source/release-notes/release-notes_index.rst 2014-07-30 10:29:34 +0000
188+++ doc/source/release-notes/release-notes_index.rst 2014-08-28 13:26:38 +0000
189@@ -6,6 +6,7 @@
190 :maxdepth: 1
191 :glob:
192
193+ Percona-Server-5.5.39-36.0
194 Percona-Server-5.5.38-35.2
195 Percona-Server-5.5.37-35.1
196 Percona-Server-5.5.37-35.0
197
198=== modified file 'doc/source/upstream-bug-fixes.rst'
199--- doc/source/upstream-bug-fixes.rst 2014-07-30 10:29:34 +0000
200+++ doc/source/upstream-bug-fixes.rst 2014-08-28 13:26:38 +0000
201@@ -5,9 +5,27 @@
202 =============================================================
203
204 +-------------------------------------------------------------------------------------------------------------+
205+|:Upstream bug: :mysqlbug:`73126` - Numerous Valgrind errors in OpenSSL |
206+|:Launchpad bug: :bug:`1334743` |
207+|:Upstream state: Verified (checked on 2014-08-28) |
208+|:Fix Released: :rn:`5.5.39-36.0` |
209+|:Upstream fix: N/A |
210++-------------------------------------------------------------------------------------------------------------+
211+|:Upstream bug: :mysqlbug:`73111` - Suppression typo causing spurious MTR Valgrind failures |
212+|:Launchpad bug: :bug:`1334317` |
213+|:Upstream state: Open (checked on 2014-08-28) |
214+|:Fix Released: :rn:`5.5.39-36.0` |
215+|:Upstream fix: N/A |
216++-------------------------------------------------------------------------------------------------------------+
217+|:Upstream bug: :mysqlbug:`73418` - Add --manual-lldb option to mysql-test-run.pl |
218+|:Launchpad bug: :bug:`1328482` |
219+|:Upstream state: Verified (checked on 2014-08-28) |
220+|:Fix Released: :rn:`5.5.39-36.0` |
221+|:Upstream fix: N/A |
222++-------------------------------------------------------------------------------------------------------------+
223 |:Upstream bug: :mysqlbug:`60782` - Audit plugin API: no MYSQL_AUDIT_GENERAL_LOG notifications with general...|
224 |:Launchpad bug: :bug:`1182535` |
225-|:Upstream state: Verified (checked on 2014-07-01) |
226+|:Upstream state: Closed |
227 |:Fix Released: :rn:`5.5.37-35.0` |
228 |:Upstream fix: N/A |
229 +-------------------------------------------------------------------------------------------------------------+
230@@ -25,13 +43,13 @@
231 +-------------------------------------------------------------------------------------------------------------+
232 |:Upstream bug: :mysqlbug:`71375` - Slave IO thread won't attempt auto reconnect to the master/error-code 1593|
233 |:Launchpad bug: :bug:`1268735` |
234-|:Upstream state: Verified (checked on 2014-07-01) |
235+|:Upstream state: Verified (checked on 2014-08-28) |
236 |:Fix Released: :rn:`5.5.36-34.1` |
237 |:Upstream fix: N/A |
238 +-------------------------------------------------------------------------------------------------------------+
239 |:Upstream bug: :mysqlbug:`71374` - Slave IO thread won't attempt auto reconnect to the master/error-code 1159|
240 |:Launchpad bug: :bug:`1268729` |
241-|:Upstream state: Verified (checked on 2014-07-01) |
242+|:Upstream state: Verified (checked on 2014-08-28) |
243 |:Fix Released: :rn:`5.5.36-34.1` |
244 |:Upstream fix: N/A |
245 +-------------------------------------------------------------------------------------------------------------+
246@@ -61,7 +79,7 @@
247 +-------------------------------------------------------------------------------------------------------------+
248 |:Upstream bug: :mysqlbug:`69639` - mysql failed to build with dtrace Sun D 1.11 |
249 |:Launchpad bug: :bug:`1196460` |
250-|:Upstream state: Open (checked on 2014-07-01) |
251+|:Upstream state: Open (checked on 2014-08-28) |
252 |:Fix Released: :rn:`5.5.33-31.1` |
253 |:Upstream fix: N/A |
254 +-------------------------------------------------------------------------------------------------------------+
255@@ -73,7 +91,7 @@
256 +-------------------------------------------------------------------------------------------------------------+
257 |:Upstream bug: :mysqlbug:`42415` - UPDATE/DELETE with LIMIT clause unsafe for SBL even with ORDER BY PK ... |
258 |:Launchpad bug: :bug:`1132194` |
259-|:Upstream state: Verified (checked on 2014-07-01) |
260+|:Upstream state: Verified (checked on 2014-08-28) |
261 |:Fix Released: :rn:`5.5.32-31.0` |
262 |:Upstream fix: N/A |
263 +-------------------------------------------------------------------------------------------------------------+
264@@ -85,7 +103,7 @@
265 +-------------------------------------------------------------------------------------------------------------+
266 |:Upstream bug: :mysqlbug:`68970` - fsp_reserve_free_extents switches from small to big tblspace handling ... |
267 |:Launchpad bug: :bug:`1169494` |
268-|:Upstream state: Verified (checked on 2014-07-01) |
269+|:Upstream state: Verified (checked on 2014-08-28) |
270 |:Fix Released: :rn:`5.5.32-31.0` |
271 |:Upstream fix: N/A |
272 +-------------------------------------------------------------------------------------------------------------+
273@@ -97,7 +115,7 @@
274 +-------------------------------------------------------------------------------------------------------------+
275 |:Upstream bug: :mysqlbug:`68999` - SSL_OP_NO_COMPRESSION not defined |
276 |:Launchpad bug: :bug:`1183610` |
277-|:Upstream state: No Feedback (checked on 2014-07-01) |
278+|:Upstream state: No Feedback (checked on 2014-08-28) |
279 |:Fix Released: :rn:`5.5.31-30.3` |
280 |:Upstream fix: N/A |
281 +-------------------------------------------------------------------------------------------------------------+
282@@ -109,7 +127,7 @@
283 +-------------------------------------------------------------------------------------------------------------+
284 |:Upstream bug: :mysqlbug:`68845` - Unnecessary log_sys->mutex reacquisition in mtr_log_reserve_and_write() |
285 |:Launchpad bug: :bug:`1163439` |
286-|:Upstream state: Verified (checked on 2014-07-01) |
287+|:Upstream state: Verified (checked on 2014-08-28) |
288 |:Fix Released: :rn:`5.5.30-30.2` |
289 |:Upstream fix: N/A |
290 +-------------------------------------------------------------------------------------------------------------+
291@@ -139,13 +157,13 @@
292 +-------------------------------------------------------------------------------------------------------------+
293 |:Upstream bug: :mysqlbug:`68476` - Suboptimal code in my_strnxfrm_simple() |
294 |:Launchpad bug: :bug:`1132350` |
295-|:Upstream state: Verified (checked on 2014-07-01) |
296+|:Upstream state: Verified (checked on 2014-08-28) |
297 |:Fix Released: :rn:`5.5.30-30.1` |
298 |:Upstream fix: N/A |
299 +-------------------------------------------------------------------------------------------------------------+
300 |:Upstream bug: :mysqlbug:`68116` - InnoDB monitor may hit an assertion error in buf_page_get_gen in debug ...|
301 |:Launchpad bug: :bug:`1100178` |
302-|:Upstream state: Verified (checked on 2014-07-01) |
303+|:Upstream state: Verified (checked on 2014-08-28) |
304 |:Fix Released: :rn:`5.5.29-30.0` |
305 |:Upstream fix: N/A |
306 +-------------------------------------------------------------------------------------------------------------+
307@@ -247,7 +265,7 @@
308 +-------------------------------------------------------------------------------------------------------------+
309 |:Upstream bug: :mysqlbug:`61178` - Incorrect implementation of intersect(ulonglong) in non-optimized Bitmap..|
310 |:Launchpad bug: :bug:`1042517` |
311-|:Upstream state: Verified (checked on 2014-07-01) |
312+|:Upstream state: Verified (checked on 2014-08-28) |
313 |:Fix Released: :rn:`5.5.27-29.0` |
314 |:Upstream fix: N/A |
315 +-------------------------------------------------------------------------------------------------------------+
316@@ -259,7 +277,7 @@
317 +-------------------------------------------------------------------------------------------------------------+
318 |:Upstream bug: :mysqlbug:`64800` - mysqldump with --include-master-host-port putting quotes around port no. |
319 |:Launchpad bug: :bug:`1013432` |
320-|:Upstream state: Verified (checked on 2014-07-01) |
321+|:Upstream state: Verified (checked on 2014-08-28) |
322 |:Fix Released: :rn:`5.5.27-28.0` |
323 |:Upstream fix: N/A |
324 +-------------------------------------------------------------------------------------------------------------+
325@@ -307,7 +325,7 @@
326 +-------------------------------------------------------------------------------------------------------------+
327 |:Upstream bug: :mysqlbug:`71183` - os_file_fsync() should handle fsync() returning EINTR |
328 |:Launchpad bug: :bug:`1262651` |
329-|:Upstream state: Verified (checked on 2014-07-01) |
330+|:Upstream state: Verified (checked on 2014-08-28) |
331 |:Fix Released: :rn:`5.5.20-24.1` |
332 |:Upstream fix: N/A |
333 +-------------------------------------------------------------------------------------------------------------+
334@@ -331,13 +349,13 @@
335 +-------------------------------------------------------------------------------------------------------------+
336 |:Upstream bug: :mysqlbug:`62516` - Fast index creation does not update index statistics |
337 |:Launchpad bug: :bug:`857590` |
338-|:Upstream state: Verified (checked on 2014-07-01) |
339+|:Upstream state: Verified (checked on 2014-08-28) |
340 |:Fix Released: :rn:`5.5.16-22.0` |
341 |:Upstream fix: N/A |
342 +-------------------------------------------------------------------------------------------------------------+
343 |:Upstream bug: :mysqlbug:`25007` - memory tables with dynamic rows format |
344 |:Launchpad bug: N/A |
345-|:Upstream state: Verified (checked on 2014-07-01) |
346+|:Upstream state: Verified (checked on 2014-08-28) |
347 |:Fix Released: :rn:`5.5.15-21.0` |
348 |:Upstream fix: N/A |
349 +-------------------------------------------------------------------------------------------------------------+
350@@ -355,7 +373,7 @@
351 +-------------------------------------------------------------------------------------------------------------+
352 |:Upstream bug: :mysqlbug:`61595` - mysql-test/include/wait_for_slave_param.inc timeout logic is incorrect |
353 |:Launchpad bug: :bug:`800035` |
354-|:Upstream state: Verified (checked on 2014-07-01) |
355+|:Upstream state: Verified (checked on 2014-08-28) |
356 |:Fix Released: :rn:`5.5.13-20.4` |
357 |:Upstream fix: N/A |
358 +-------------------------------------------------------------------------------------------------------------+
359@@ -385,7 +403,7 @@
360 +-------------------------------------------------------------------------------------------------------------+
361 |:Upstream bug: :mysqlbug:`69146` - Optimization in buf_pool_get_oldest_modification if srv_buf_pool_instances|
362 |:Launchpad bug: :bug:`1176496` |
363-|:Upstream state: Verified (checked on 2014-07-01) |
364+|:Upstream state: Verified (checked on 2014-08-28) |
365 |:Fix Released: :rn:`5.5.8-20.0` |
366 |:Upstream fix: N/A |
367 +-------------------------------------------------------------------------------------------------------------+

Subscribers

People subscribed via source and target branches