Merge lp:~hrvojem/percona-xtradb-cluster/rn-5.5.34-25.9 into lp:percona-xtradb-cluster/percona-xtradb-cluster-5.5

[Hrvoje Matijakovic]

[Raghavendra D Prabhu (raghavendra-prabhu)]

Approved after discussion.

review: Approve

[Raghavendra D Prabhu (raghavendra-prabhu)]

Following need to be removed from errata:
=======================================================

wsrep_causal_reads being ON can introduce temporary stalls due to MDL lock conflicts.

bug #1226185: percona-xtrabackup-20 may get installed as a dependency instead of latest percona-xtrabackup during a fresh install due to certain yum issues. Workaround is documented here - https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1226185/comments/2.

bug #1217426: When empty test directory is present on donor, it is not created on joiner, so when tables are created after SST on donor, the joiner later on will fail with inconsistency. Workaround is to either drop the test database or populate it with a table before SST. This is currently a limitation of Xtrabackup itself, hence, needs to be fixed there.

bug #1098566: innodb_data_home_dir is not supported. Depends on bug #1164945 for the fix.

=== modified file 'doc-pxc/source/conf.py'
--- doc-pxc/source/conf.py	2013-09-16 10:28:41 +0000
+++ doc-pxc/source/conf.py	2013-12-03 12:55:58 +0000
@@ -53,9 +53,9 @@
 # built documents.
 #
 # The short X.Y version.
-version = '5.5.33'
+version = '5.5.34'
 # The full version, including alpha/beta/rc tags.
-release = '5.5.33-23.7.6'
+release = '5.5.34-25.9'
 
 # The language for content autogenerated by Sphinx. Refer to documentation
 # for a list of supported languages.
@@ -168,10 +168,10 @@
 
 # The name for this set of Sphinx documents.  If None, it defaults to
 # "<project> v<release> documentation".
-html_title = 'Percona XtraDB Cluster Documentation'
+html_title = 'Percona XtraDB Cluster 5.5 Documentation'
 
 # A shorter title for the navigation bar.  Default is the same as html_title.
-html_short_title = 'XtraDB Cluster Docs'
+html_short_title = 'Percona XtraDB Cluster 5.5 Documentation'
 
 # The name of an image file (relative to this directory) to place at the top
 # of the sidebar.
@@ -244,7 +244,7 @@
 # Grouping the document tree into LaTeX files. List of tuples
 # (source start file, target name, title, author, documentclass [howto/manual]).
 latex_documents = [
-  ('index', 'PerconaXtraDBCluster.tex', u'Percona XtraDB Cluster Documentation',
+  ('index', 'PerconaXtraDBCluster-5.5.tex', u'Percona XtraDB Cluster 5.5 Documentation', 
    u'2012-2013, Percona LLC and/or its affiliates', 'manual'),
 ]
 
 
=== modified file 'doc-pxc/source/errata.rst'
--- doc-pxc/source/errata.rst	2013-11-25 14:54:46 +0000
+++ doc-pxc/source/errata.rst	2013-12-03 12:55:58 +0000
@@ -8,12 +8,8 @@
 -------------
 
 Following are issues which may impact you while running PXC:
- - wsrep_causal_reads being ON can introduce temporary stalls due to MDL lock conflicts.
  - Create Table As Select (CTAS) can cause deadlocks and server hang when used with explicit TEMPORARY tables.
- - bug :bug:`1226185`: percona-xtrabackup-20 may get installed as a dependency instead of latest percona-xtrabackup during a fresh install due to certain yum issues. Workaround is documented here - https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1226185/comments/2.
  - bug :bug:`1192834`: Joiner may crash after SST from donor with compaction enabled. Workaround is to disable the index compaction (compact under [xtrabackup]), if enabled. This crash requires specific configuration, hence you may not be affected. Also, this doesn't require any fix from PXC, but Xtrabackup with the fix included should do.
- - bug :bug:`1217426`: When empty test directory is present on donor, it is not created on joiner, so when tables are created after SST on donor, the joiner later on will fail with inconsistency. Workaround is to either drop the test database or populate it with a table before SST. This is currently a limitation of Xtrabackup itself, hence, needs to be fixed there.
- - bug :bug:`1098566`: :variable:`innodb_data_home_dir` is not supported. Depends on bug :bug:`1164945` for the fix.
  - For Debian/Ubuntu users: |Percona XtraDB Cluster| :rn:`5.5.33-23.7.6` onwards has a new dependency, the ``socat`` package. If the ``socat`` is not previously installed, ``percona-xtradb-cluster-server-5.5`` may be held back. In order to upgrade, you need to either install ``socat`` before running the ``apt-get upgrade`` or with the following command: ``apt-get install percona-xtradb-cluster-server-5.5``. For *Ubuntu* users the ``socat`` package is in the universe repository, so the repository will have to be enabled in order to install the package.
 
 
 
=== removed file 'doc-pxc/source/howtos/kewpietests.rst'
--- doc-pxc/source/howtos/kewpietests.rst	2012-06-27 10:05:05 +0000
+++ doc-pxc/source/howtos/kewpietests.rst	1970-01-01 00:00:00 +0000
@@ -1,35 +0,0 @@
-===========================
-How to Execute Kewpie Tests
-===========================
-
-To use kewpie for testing it's recommended to use `this MP <https://code.launchpad.net/~patrick-crews/percona-xtradb-cluster/qp-integrate/+merge/93648>`_. As it removes dbqp and integrates kewpie (and cuts size down to 25MB from 400+).
-To execute tests: 
-
-.. code-block:: bash
-
-   cd kewpie ; ./kewpie.py [--force ] [--libeatmydata] [--wsrep-provider-path=...]
-                  
-The defaults are to run the cluster_basic and cluster_randgen suites against a 3 node cluster. Cluster_basic is used for small atomic tests like ADD/DROP single/multiple columns on a table and ensuring the change is replicated. cluster_randgen is used for high stress transactional loads.  There are single and multi-threaded variants.  The load is a mix of INSERT/UPDATE/DELETE/SELECT statements.  This includes both regular transactions, single queries, ROLLBACK's and SAVEPOINTs, and a mix of good and bad SQL statements.
-               
-To view all options, one may look at "./kewpie.py --help".  Basic documentation is also available as sphinx docs in kewpie/docs folder. Here are the some of the most used options:
-
-.. option:: --force 
-
-   Run all tests despite failures (default is to stop test execution on first failure)
-
-.. option:: --libeatmydata 
-
-   Use libeatmydata if installed. This can greatly speed up testing in many cases.  Can be used in conjunction with:
-
-.. option:: --libeatmydata-path to specify where the library is located.
-
-.. option:: --wsrep-provider-path  
-   
-   By default, we expect / look for it in /usr/lib/galera/libgalera_smm.so (where it ends up via 'make install'...at least on Ubuntu).  If one has an alternate library/location, specify it with this option.
-
-Any additional suites may be run this way: 
-
-.. code-block:: bash
-
-   ./kewpie.py [options] --suite=any/suitedir/from/kewpie/percona_tests
-   ./kewpie.py --suite=crashme
 
=== modified file 'doc-pxc/source/index.rst'
--- doc-pxc/source/index.rst	2013-09-17 12:05:56 +0000
+++ doc-pxc/source/index.rst	2013-12-03 12:55:58 +0000
@@ -86,7 +86,6 @@
    howtos/3nodesec2
    howtos/haproxy
    howtos/virt_sandbox
-   howtos/kewpietests
    howtos/bugreport
 
 Reference
 
=== modified file 'doc-pxc/source/installation.rst'
--- doc-pxc/source/installation.rst	2013-11-22 03:47:13 +0000
+++ doc-pxc/source/installation.rst	2013-12-03 12:55:58 +0000
@@ -33,7 +33,7 @@
 
 Once the repository is set up, use the following commands: ::
 
-  $ yum install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client
+  $ yum install Percona-XtraDB-Cluster-server-55 Percona-XtraDB-Cluster-client-55 Percona-XtraDB-Cluster-galera-2
 
 More detailed example of the |Percona XtraDB Cluster| installation and configuration can be seen in :ref:`centos_howto` tutorial.
 
 
=== modified file 'doc-pxc/source/installation/apt_repo.rst'
--- doc-pxc/source/installation/apt_repo.rst	2013-11-22 03:47:13 +0000
+++ doc-pxc/source/installation/apt_repo.rst	2013-12-03 12:55:58 +0000
@@ -48,7 +48,13 @@
 Following command will install Cluster packages: :: 
 
   $ sudo apt-get install percona-xtradb-cluster-client-5.5 \
-  percona-xtradb-cluster-server-5.5 percona-xtrabackup percona-xtradb-cluster-galera-2.x
+  percona-xtradb-cluster-server-5.5 percona-xtradb-cluster-galera-2.x
+
+.. note:: 
+
+   When doing the package upgrade on debian, you need to specify the all the packages or do the ``dist-upgrade``, otherwise some packages will be held back during the upgrade: ::
+ 
+   $ apt-get install percona-xtradb-cluster-galera-2.x percona-xtradb-cluster-server-5.5 percona-xtradb-cluster-client-5.5  
 
 Percona `apt` Experimental repository
 =====================================
 
=== modified file 'doc-pxc/source/installation/yum_repo.rst'
--- doc-pxc/source/installation/yum_repo.rst	2013-03-12 09:32:01 +0000
+++ doc-pxc/source/installation/yum_repo.rst	2013-12-03 12:55:58 +0000
@@ -30,7 +30,7 @@
 
 Following command will install Cluster packages: ::
 
-  $ yum install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client xtrabackup
+  $ yum install Percona-XtraDB-Cluster-server-55 Percona-XtraDB-Cluster-client-55 Percona-XtraDB-Cluster-galera-2
 
 Percona `yum` Experimental repository
 =====================================
 
=== modified file 'doc-pxc/source/manual/xtrabackup_sst.rst'
--- doc-pxc/source/manual/xtrabackup_sst.rst	2013-11-04 12:43:19 +0000
+++ doc-pxc/source/manual/xtrabackup_sst.rst	2013-12-03 12:55:58 +0000
@@ -151,6 +151,13 @@
 
 **NOTE:** This option can only be used when :variable:`wsrep_sst_method` is set to xtrabackup-v2.
 
+.. option:: sst_special_dirs
+   
+     :Values: 0,1
+     :Default: 0
+
+In order for XtraBackup SST to support :variable:`innodb_data_home_dir` and :variable:`innodb_log_home_dir` variables in the configuration file this option was introduced in |Percona XtraDB Cluster| :rn:`5.5.34-25.9`. This requires sst-special-dirs to be set under [sst] in the configuration file to either 0 or 1. Also, :variable:`innodb-data-home-dir` and/or :variable:`innodb-log-group-home-dir` need to be defined in :file:`my.cnf` under [mysqld]. |Percona Xtrabackup| 2.1.6 or higher is required in order for this to work.
+
 .. _tar_ag_xbstream:
 
 Tar against xbstream
 
=== added file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.34-25.9.rst'
--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.34-25.9.rst	1970-01-01 00:00:00 +0000
+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.34-25.9.rst	2013-12-03 12:55:58 +0000
@@ -0,0 +1,68 @@
+.. rn:: 5.5.34-25.9
+
+======================================
+ |Percona XtraDB Cluster| 5.5.34-25.9
+======================================
+
+Percona is glad to announce the release of |Percona XtraDB Cluster| on December 3rd, 2013. Binaries are available from `downloads area <http://www.percona.com/downloads/Percona-XtraDB-Cluster/5.5.34-25.9/>`_ or from our :doc:`software repositories </installation>`.
+
+This is an General Availability release. We did our best to eliminate bugs and problems during the testing release, but this is a software, so bugs are expected. If you encounter them, please report them to our `bug tracking system <https://bugs.launchpad.net/percona-xtradb-cluster/+filebug>`_.
+
+
+New Features
+============
+
+ |Percona XtraDB Cluster| is now based on wsrep API 25 and Galera 25.2.x.
+
+ Limited support for Query Cache has been implemented. Query cache cannot still be fully enabled during the startup. To enable query cache, ``mysqld`` should be started with ``query_cache_type=1`` and ``query_cache_size=0`` and then query_cache_size should be changed to desired value during runtime.
+
+ ``RPM`` packages are now made `relocatable <http://rpm5.org/docs/api/relocatable.html>`_ which means they now support installation to custom prefixes.
+
+ XtraBackup SST now supports :variable:`innodb_data_home_dir` and :variable:`innodb_log_home_dir` in the configuration file.
+
+ The binaries are now statically linked with regard to ``Galera`` library which depended on ``OpenSSL`` library. 
+
+Bugs fixed 
+==========
+ 
+ Product suffix has been added to the |Percona XtraDB Cluster| ``rpm`` packages, which means that packages have been renamed from ``Percona-XtraDB-Cluster-server`` to ``Percona-XtraDB-Cluster-server-55``. Bug fixed :bug:`1255616`.
+
+ Fixed the dependency issue which caused Percona XtraDB Cluster 5.5 installation to fail on *Ubuntu* 12.04. Bug fixed :bug:`1247861`.
+ 
+ When installing first ``Percona-XtraDB-Cluster-client`` and then ``Percona-XtraDB-Cluster-server`` on two single statements or a single statement with both packages , yum would install ``percona-xtrabackup-20`` instead ``percona-xtrabackup`` package as dependency of ``Percona-XtraDB-Cluster-server``. Bug fixed :bug:`1226185`.
+
+ If ``SELECT FOR UPDATE...`` query was aborted due to multi-master conflict, the client wouldn't get back the deadlock error. From client perspective the transaction would be successful. Bug fixed :bug:`1187739`.
+
+ Temporary tables are not replicated, but any DDL on those tables were (in this case it was ``TRUNCATE``), which would generates error messages on other nodes. Bug fixed :bug:`1194156`.
+
+ When setting the :variable:`gcache.size` to a larger value than the default 128M, the mysql service command did not allow enough time for the file to be preallocated. Bug fixed :bug:`1207500`.
+
+ ``CREATE TABLE AS SELECT`` would fail with explicit temporary tables, when binlogging was enabled and :variable:`autocommit` was set to ``0``. Bug fixed :bug:`1240098`. 
+
+ Write set flags defined in wsrep API are now exposed to application side appliers too. Bug fixed :bug:`1247402`.
+
+ Local brute force aborts are counted accurately. Bug fixed :bug:`1247971`.
+ 
+ Certain combinations of transaction rollbacks could leave stale transactional ``MDL`` locks and cause deadlocks. Bug fixed :bug:`1247978`.
+
+ After turning ``UNIV_SYNC_DEBUG`` on, node that was started from clean state would crash immediately at startup. Bug fixed :bug:`1248908`.
+
+ Server built with ``UNIV_SYNC_DEBUG`` would assert if SQL load has ``DELETE`` statements on tables with foreign key constraints with ``ON DELETE CASCADE`` option. Bug fixed :bug:`1248921`.
+
+ Xtrabackup SST dependencies have been added as ``Suggested`` dependencies for *DEB* packages. Bug fixed :bug:`1250326`.
+
+ ``init stop`` script on *CentOS* didn't wait for the server to be fully stopped. This would cause unsuccessful server restart because the ``start`` action would fail because the daemon would still be running. Bug fixed :bug:`1254153`.
+
+ Memory leak in ``mem_root`` has been fixed. Bug fixed :bug:`1249753`.
+
+ Galera is now packaged with garbd init script. Bug fixed :bug:`1256769`.
+
+Other bugs fixed: bug fixed :bug:`1247980`, bug fixed :bug:`891476`, bugs fixed :bug:`1250805`, bug fixed :bug:`1253923`.
+ 
+.. note:: 
+
+ Because some package names have been changed with the product suffix and and additional dependencies being added please check the :ref:`manual <installation>` before starting new installations. *Debian* users are requested to use ``apt-get dist-upgrade`` or ``apt-get install`` for upgrade, for more refer to installation :ref:`guide <apt-repo>`. 
+
+Based on `Percona Server 5.5.34-32.0 <http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.34-32.0.html>`_ including all the bug fixes in it, `Galera Replicator <https://launchpad.net/galera/+milestone/25.2.8>`_ and on `Codership wsrep API 5.5.34-25.9 <https://launchpad.net/codership-mysql/+milestone/5.5.34-25.9>`_, |Percona XtraDB Cluster| `5.5.34-25.9 <https://launchpad.net/percona-xtradb-cluster/+milestone/5.5.34-25.9>`_ is now the current stable release. All of |Percona|'s software is open-source and free. 
+
+|Percona XtraDB Cluster| `Errata <http://www.percona.com/doc/percona-xtradb-cluster/errata.html>`_ can be found in our documentation.
 
=== modified file 'doc-pxc/source/release-notes/release-notes_index.rst'
--- doc-pxc/source/release-notes/release-notes_index.rst	2013-11-04 10:19:08 +0000
+++ doc-pxc/source/release-notes/release-notes_index.rst	2013-12-03 12:55:58 +0000
@@ -5,7 +5,8 @@
 .. toctree::
    :maxdepth: 1
    :glob:
-
+   
+   Percona-XtraDB-Cluster-5.5.34-25.9
    Percona-XtraDB-Cluster-5.5.34-23.7.6
    Percona-XtraDB-Cluster-5.5.33-23.7.6
    Percona-XtraDB-Cluster-5.5.31-23.7.5