Merge lp:~tplavcic/percona-server/bld-242-5.6 into lp:percona-server/5.6
Status: | Merged |
---|---|
Approved by: | Laurynas Biveinis |
Approved revision: | no longer in the source branch. |
Merged at revision: | 731 |
Proposed branch: | lp:~tplavcic/percona-server/bld-242-5.6 |
Merge into: | lp:percona-server/5.6 |
Diff against target: |
64 lines (+39/-2) 1 file modified
build-ps/percona-server.spec (+39/-2) |
To merge this branch: | bzr merge lp:~tplavcic/percona-server/bld-242-5.6 |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Laurynas Biveinis (community) | Approve | ||
Review via email: mp+246905@code.launchpad.net |
Description of the change
After fixing the bug on server upgrade on centos 5/6 where it wasn't started if it was running before upgrade (at least the case where pid was located in datadir) it was noticed that if tokudb was installed the server (new upgraded version) got started with the old version of tokudb which then failed to init (BLD-242).
The problem is in the sequence of starting/stopping the server when upgrading so the correct thing is to stop the server, upgrade it and if TokuDB is installed don't start the server until new TokuDB version is unpacked - so that means if it was running before that TokuDB package needs to start it on upgrade.
This affects centos 5/6.
Test packages:
http://
http://
Some testing - centos 6 mostly, but tried centos5, centos7 and ubuntu14 also - all pass:
test1: with running service before upgrade and installed tokudb
test2: without running service before upgrade and installed tokudb
test3: with running service before upgrade and no installed tokudb
test4: install tokudb package on running server
test5: without running service before upgrade and no installed tokudb
test6: centos7 - running service with tokudb and upgrade
test7: centos5 - running service with tokudb and upgrade
test8: ubuntu 14.04 - running service with tokudb and upgrade
Test data:
### TEST1: WITH RUNNING SERVICE BEFORE UPGRADE AND INSTALLED TOKUDB:
mysql> show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.21-70.1 |
| protocol_version | 10 |
| slave_type_
| tokudb_version | tokudb-7.5.2 |
| version | 5.6.21-70.1 |
| version_comment | Percona Server (GPL), Release 70.1, Revision 698 |
| version_
| version_compile_os | Linux |
+------
mysql> show table status like 'City';
+------
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+------
| City | TokuDB | 10 | tokudb_zlib | 4079 | 67 | 273293 | 9223372036854775807 | 36711 | 0 | 4080 | 2015-01-19 02:29:04 | 2015-01-19 02:29:04 | NULL | latin1_swedish_ci | NULL | | |
+------
1 row in set (0,00 sec)
[vagrant@
SUCCESS! MySQL (Percona Server) running (1364)
UPGRADE:
[vagrant@
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: mirror.met.hu
* extras: mirror.met.hu
* updates: mirror.met.hu
Setting up Install Process
Examining Percona-
Marking Percona-
Examining Percona-
Marking Percona-
Examining Percona-
Marking Percona-
Examining Percona-
Marking Percona-
Resolving Dependencies
--> Running transaction check
---> Package Percona-
---> Package Percona-
---> Package Percona-
---> Package Percona-
---> Package Percona-
---> Package Percona-
---> Package Percona-
---> Package Percona-
--> Finished Dependency Resolution
Dependencies Resolved
=======
Package Arch Version Repository Size
=======
Updating:
Percona-
Percona-
Percona-
Percona-
Transaction Summary
=======
Upgrade 4 Package(s)
Running Transaction
Updating : Percona-
Updating : Percona-
Updating : Percona-
ls: cannot access /var/lib/
ls: cannot access /var/lib/
Giving mysqld 5 seconds to exit nicely
Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://
Updating : Percona-
Starting MySQL (Percona Server).. SUCCESS!
Giving mysqld 5 seconds to start
Cleanup : Percona-
Cleanup : Percona-
Cleanup : Percona-
Cleanup : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Updated:
Percona-
Complete!
CHECK AFTER UPGRADE:
[vagrant@
SUCCESS! MySQL (Percona Server) running (2517)
mysql> show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.22-71.0 |
| protocol_version | 10 |
| slave_type_
| tokudb_version | tokudb-7.5.4 |
| version | 5.6.22-71.0 |
| version_comment | Percona Server (GPL), Release 71.0, Revision 730 |
| version_
| version_compile_os | Linux |
+------
8 rows in set (0,01 sec)
mysql> select * from City limit 10;
+----+-
| ID | Name | CountryCode | District | Population |
+----+-
| 1 | Kabul | AFG | Kabol | 1780000 |
| 2 | Qandahar | AFG | Qandahar | 237500 |
| 3 | Herat | AFG | Herat | 186800 |
| 4 | Mazar-e-Sharif | AFG | Balkh | 127800 |
| 5 | Amsterdam | NLD | Noord-Holland | 731200 |
| 6 | Rotterdam | NLD | Zuid-Holland | 593321 |
| 7 | Haag | NLD | Zuid-Holland | 440900 |
| 8 | Utrecht | NLD | Utrecht | 234323 |
| 9 | Eindhoven | NLD | Noord-Brabant | 201843 |
| 10 | Tilburg | NLD | Noord-Brabant | 193238 |
+----+-
10 rows in set (0,01 sec)
mysql> show table status like 'City';
+------
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+------
| City | TokuDB | 10 | tokudb_zlib | 4079 | 67 | 273293 | 9223372036854775807 | 36711 | 0 | 4080 | 2015-01-19 02:29:04 | 2015-01-19 02:29:04 | NULL | latin1_swedish_ci | NULL | | |
+------
1 row in set (0,00 sec)
LOG:
150119 02:48:47 mysqld_safe mysqld from pid file /var/lib/
150119 02:48:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-01-19 02:48:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
2015-01-19 02:48:56 2517 [Note] Plugin 'FEDERATED' is disabled.
2015-01-19 02:48:56 2517 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-19 02:48:56 2517 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-19 02:48:56 2517 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-19 02:48:56 2517 [Note] InnoDB: Memory barrier is not used
2015-01-19 02:48:56 2517 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-19 02:48:56 2517 [Note] InnoDB: Using Linux native AIO
2015-01-19 02:48:56 2517 [Note] InnoDB: Not using CPU crc32 instructions
2015-01-19 02:48:56 2517 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-19 02:48:56 2517 [Note] InnoDB: Completed initialization of buffer pool
2015-01-19 02:48:56 2517 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-19 02:48:56 2517 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-19 02:48:56 2517 [Note] InnoDB: Waiting for purge to start
2015-01-19 02:48:56 2517 [Note] InnoDB: Percona XtraDB (http://
2015-01-19 02:48:57 2517 [Note] RSA private key file not found: /var/lib/
2015-01-19 02:48:57 2517 [Note] RSA public key file not found: /var/lib/
2015-01-19 02:48:57 2517 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-19 02:48:57 2517 [Note] IPv6 is available.
2015-01-19 02:48:57 2517 [Note] - '::' resolves to '::';
2015-01-19 02:48:57 2517 [Note] Server socket created on IP: '::'.
2015-01-19 02:48:57 2517 [Note] Event Scheduler: Loaded 0 events
2015-01-19 02:48:57 2517 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.22-71.0' socket: '/var/lib/
### TEST2: WITHOUT RUNNING SERVICE BEFORE UPGRADE AND INSTALLED TOKUDB:
mysql> show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.21-70.1 |
| protocol_version | 10 |
| slave_type_
| tokudb_version | tokudb-7.5.2 |
| version | 5.6.21-70.1 |
| version_comment | Percona Server (GPL), Release 70.1, Revision 698 |
| version_
| version_compile_os | Linux |
+------
[vagrant@
ERROR! MySQL (Percona Server) is not running
UPGRADE:
=======
Package Arch Version Repository Size
=======
Updating:
Percona-
Percona-
Percona-
Percona-
Transaction Summary
=======
Upgrade 4 Package(s)
Total size: 127 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Updating : Percona-
Updating : Percona-
Updating : Percona-
ls: cannot access /var/lib/
ls: cannot access /var/lib/
Giving mysqld 5 seconds to exit nicely
Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://
Updating : Percona-
Cleanup : Percona-
Cleanup : Percona-
Cleanup : Percona-
Cleanup : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
[vagrant@
ERROR! MySQL (Percona Server) is not running
[vagrant@
Starting MySQL (Percona Server). SUCCESS!
mysql> show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.22-71.0 |
| protocol_version | 10 |
| slave_type_
| tokudb_version | tokudb-7.5.4 |
| version | 5.6.22-71.0 |
| version_comment | Percona Server (GPL), Release 71.0, Revision 730 |
| version_
| version_compile_os | Linux |
+------
8 rows in set (0,02 sec)
mysql> select * from City limit 10;
+----+-
| ID | Name | CountryCode | District | Population |
+----+-
| 1 | Kabul | AFG | Kabol | 1780000 |
| 2 | Qandahar | AFG | Qandahar | 237500 |
| 3 | Herat | AFG | Herat | 186800 |
| 4 | Mazar-e-Sharif | AFG | Balkh | 127800 |
| 5 | Amsterdam | NLD | Noord-Holland | 731200 |
| 6 | Rotterdam | NLD | Zuid-Holland | 593321 |
| 7 | Haag | NLD | Zuid-Holland | 440900 |
| 8 | Utrecht | NLD | Utrecht | 234323 |
| 9 | Eindhoven | NLD | Noord-Brabant | 201843 |
| 10 | Tilburg | NLD | Noord-Brabant | 193238 |
+----+-
10 rows in set (0,01 sec)
### TEST3: WITH RUNNING SERVICE BEFORE UPGRADE AND NO INSTALLED TOKUDB
[vagrant@
Percona-
Percona-
Percona-
jemalloc.x86_64 3.3.1-1.el6 @percona-
mysql> show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.21-70.1 |
| protocol_version | 10 |
| slave_type_
| version | 5.6.21-70.1 |
| version_comment | Percona Server (GPL), Release 70.1, Revision 698 |
| version_
| version_compile_os | Linux |
+------
7 rows in set (0,02 sec)
[vagrant@
SUCCESS! MySQL (Percona Server) running (2678)
UPGRADE:
[vagrant@
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: mirror.met.hu
* extras: mirror.met.hu
* updates: mirror.met.hu
Setting up Install Process
Examining Percona-
Marking Percona-
Examining Percona-
Marking Percona-
Examining Percona-
Marking Percona-
Resolving Dependencies
--> Running transaction check
---> Package Percona-
---> Package Percona-
---> Package Percona-
---> Package Percona-
---> Package Percona-
---> Package Percona-
--> Finished Dependency Resolution
Dependencies Resolved
=======
Package Arch Version Repository Size
=======
Updating:
Percona-
Percona-
Percona-
Transaction Summary
=======
Upgrade 3 Package(s)
Running Transaction
Updating : Percona-
Updating : Percona-
Updating : Percona-
ls: cannot access /var/lib/
ls: cannot access /var/lib/
Giving mysqld 5 seconds to exit nicely
Starting MySQL (Percona Server). SUCCESS!
Giving mysqld 5 seconds to start
Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://
Cleanup : Percona-
Cleanup : Percona-
Cleanup : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Updated:
Percona-
Complete!
[vagrant@
SUCCESS! MySQL (Percona Server) running (2982)
mysql> show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.22-71.0 |
| protocol_version | 10 |
| slave_type_
| version | 5.6.22-71.0 |
| version_comment | Percona Server (GPL), Release 71.0, Revision 730 |
| version_
| version_compile_os | Linux |
+------
7 rows in set (0,01 sec)
### TEST4: INSTALL TOKUDB PACKAGE ON RUNNING SERVER
[vagrant@
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: mirror.met.hu
* extras: mirror.met.hu
* updates: mirror.met.hu
Setting up Install Process
Examining Percona-
Marking Percona-
Resolving Dependencies
--> Running transaction check
---> Package Percona-
--> Finished Dependency Resolution
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : Percona-
* This release of Percona Server is distributed with TokuDB storage engine.
* Run the following commands to enable the TokuDB storage engine in Percona Server:
mysql -e "INSTALL PLUGIN tokudb SONAME 'ha_tokudb.so';"
mysql -e "INSTALL PLUGIN tokudb_file_map SONAME 'ha_tokudb.so';"
mysql -e "INSTALL PLUGIN tokudb_
mysql -e "INSTALL PLUGIN tokudb_
mysql -e "INSTALL PLUGIN tokudb_trx SONAME 'ha_tokudb.so';"
mysql -e "INSTALL PLUGIN tokudb_locks SONAME 'ha_tokudb.so';"
mysql -e "INSTALL PLUGIN tokudb_lock_waits SONAME 'ha_tokudb.so';"
* See http://
Verifying : Percona-
Installed:
Percona-
Complete!
[vagrant@
SUCCESS! MySQL (Percona Server) running (2982)
mysql> show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.22-71.0 |
| protocol_version | 10 |
| slave_type_
| tokudb_version | tokudb-7.5.4 |
| version | 5.6.22-71.0 |
| version_comment | Percona Server (GPL), Release 71.0, Revision 730 |
| version_
| version_compile_os | Linux |
+------
8 rows in set (0,01 sec)
[vagrant@
Shutting down MySQL (Percona Server).. SUCCESS!
[vagrant@
Starting MySQL (Percona Server). SUCCESS!
### TEST5: WITHOUT RUNNING SERVICE BEFORE UPGRADE AND NO INSTALLED TOKUDB
[vagrant@
ERROR! MySQL (Percona Server) is not running
[vagrant@
Percona-
Percona-
Percona-
UPGRADE:
Resolving Dependencies
--> Running transaction check
---> Package Percona-
---> Package Percona-
---> Package Percona-
---> Package Percona-
---> Package Percona-
---> Package Percona-
--> Finished Dependency Resolution
Dependencies Resolved
Running Transaction
Updating : Percona-
Updating : Percona-
Updating : Percona-
ls: cannot access /var/lib/
ls: cannot access /var/lib/
Giving mysqld 5 seconds to exit nicely
Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://
Cleanup : Percona-
Cleanup : Percona-
Cleanup : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Updated:
Percona-
Complete!
[vagrant@
ERROR! MySQL (Percona Server) is not running
[vagrant@
Starting MySQL (Percona Server). SUCCESS!
### TEST6: CENTOS7 - RUNNING SERVICE WITH TOKUDB AND UPGRADE
[vagrant@
mysqld.service - MySQL Percona Server
Loaded: loaded (/usr/lib/
Active: active (running) since Pon 2015-01-19 13:59:47 CET; 4min 27s ago
Process: 3641 ExecStartPost=
Process: 3610 ExecStartPre=
Main PID: 3640 (mysqld_safe)
CGroup: /system.
├─3640 /bin/sh /usr/bin/
└─3786 /usr/sbin/mysqld --basedir=/usr --datadir=
mysql> show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.21-70.1 |
| protocol_version | 10 |
| slave_type_
| tokudb_version | tokudb-7.5.2 |
| version | 5.6.21-70.1 |
| version_comment | Percona Server (GPL), Release 70.1, Revision 698 |
| version_
| version_compile_os | Linux |
+------
8 rows in set (0,02 sec)
UPGRADE:
=======
Package Arch Version Repository Size
=======
Updating:
Percona-
Percona-
Percona-
Percona-
Transaction Summary
=======
Upgrade 4 Packages
Total size: 128 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Updating : Percona-
Updating : Percona-
ls: cannot access /var/lib/
ls: cannot access /var/lib/
Updating : Percona-
Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://
Updating : Percona-
Cleanup : Percona-
Cleanup : Percona-
Cleanup : Percona-
Cleanup : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Updated:
Percona-
Complete!
[vagrant@
mysqld.service - MySQL Percona Server
Loaded: loaded (/usr/lib/
Active: active (running) since Pon 2015-01-19 14:06:23 CET; 26s ago
Process: 4019 ExecStartPost=
Process: 3988 ExecStartPre=
Main PID: 4018 (mysqld_safe)
CGroup: /system.
├─4018 /bin/sh /usr/bin/
└─4164 /usr/sbin/mysqld --basedir=/usr --datadir=
Sij 19 14:06:02 t-centos7-64 systemd[1]: Starting MySQL Percona Server...
Sij 19 14:06:02 t-centos7-64 mysqld_safe[4018]: 150119 14:06:02 mysqld_safe Adding '/usr/lib64/
Sij 19 14:06:02 t-centos7-64 mysqld_safe[4018]: 150119 14:06:02 mysqld_safe Logging to '/var/log/
Sij 19 14:06:02 t-centos7-64 mysqld_safe[4018]: 150119 14:06:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Sij 19 14:06:23 t-centos7-64 systemd[1]: Started MySQL Percona Server.
mysql> show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.22-71.0 |
| protocol_version | 10 |
| slave_type_
| tokudb_version | tokudb-7.5.4 |
| version | 5.6.22-71.0 |
| version_comment | Percona Server (GPL), Release 71.0, Revision 730 |
| version_
| version_compile_os | Linux |
+------
8 rows in set (0,02 sec)
mysql> select * from City limit 10;
+----+-
| ID | Name | CountryCode | District | Population |
+----+-
| 1 | Kabul | AFG | Kabol | 1780000 |
| 2 | Qandahar | AFG | Qandahar | 237500 |
| 3 | Herat | AFG | Herat | 186800 |
| 4 | Mazar-e-Sharif | AFG | Balkh | 127800 |
| 5 | Amsterdam | NLD | Noord-Holland | 731200 |
| 6 | Rotterdam | NLD | Zuid-Holland | 593321 |
| 7 | Haag | NLD | Zuid-Holland | 440900 |
| 8 | Utrecht | NLD | Utrecht | 234323 |
| 9 | Eindhoven | NLD | Noord-Brabant | 201843 |
| 10 | Tilburg | NLD | Noord-Brabant | 193238 |
+----+-
10 rows in set (0,01 sec)
### TEST7: CENTOS5 - RUNNING SERVICE WITH TOKUDB AND UPGRADE
mysql> show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.21-70.1 |
| protocol_version | 10 |
| slave_type_
| tokudb_version | tokudb-7.5.2 |
| version | 5.6.21-70.1 |
| version_comment | Percona Server (GPL), Release 70.1, Revision 698 |
| version_
| version_compile_os | Linux |
+------
8 rows in set (0,00 sec)
[vagrant@
MySQL (Percona Server) running (4382) [ OK ]
UPGRADE:
=======
Package Arch Version Repository Size
=======
Updating:
Percona-
Percona-
Percona-
Percona-
Transaction Summary
=======
Install 0 Package(s)
Upgrade 4 Package(s)
Total size: 127 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Updating : Percona-
Updating : Percona-
Giving mysqld 5 seconds to exit nicely
Updating : Percona-
Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://
Updating : Percona-
Starting MySQL (Percona Server)..[ OK ]
Giving mysqld 5 seconds to start
Cleanup : Percona-
Cleanup : Percona-
Cleanup : Percona-
Cleanup : Percona-
Updated:
Percona-
Complete!
[vagrant@
MySQL (Percona Server) running (4634) [ OK ]
mysql> show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.22-71.0 |
| protocol_version | 10 |
| slave_type_
| tokudb_version | tokudb-7.5.4 |
| version | 5.6.22-71.0 |
| version_comment | Percona Server (GPL), Release 71.0, Revision 730 |
| version_
| version_compile_os | Linux |
+------
8 rows in set (0,01 sec)
mysql> select * from City limit 10;
+----+-
| ID | Name | CountryCode | District | Population |
+----+-
| 1 | Kabul | AFG | Kabol | 1780000 |
| 2 | Qandahar | AFG | Qandahar | 237500 |
| 3 | Herat | AFG | Herat | 186800 |
| 4 | Mazar-e-Sharif | AFG | Balkh | 127800 |
| 5 | Amsterdam | NLD | Noord-Holland | 731200 |
| 6 | Rotterdam | NLD | Zuid-Holland | 593321 |
| 7 | Haag | NLD | Zuid-Holland | 440900 |
| 8 | Utrecht | NLD | Utrecht | 234323 |
| 9 | Eindhoven | NLD | Noord-Brabant | 201843 |
| 10 | Tilburg | NLD | Noord-Brabant | 193238 |
+----+-
10 rows in set (0,00 sec)
### TEST8: UBUNTU 14.04 - RUNNING SERVICE WITH TOKUDB AND UPGRADE
vagrant@
* /usr/bin/mysqladmin Ver 8.42 Distrib 5.6.21-70.1, for debian-linux-gnu on x86_64
Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Server version 5.6.21-70.1
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/
Uptime: 8 min 26 sec
Threads: 1 Questions: 6284 Slow queries: 0 Opens: 768 Flush tables: 1 Open tables: 82 Queries per second avg: 12.418
mysql> show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.21-70.1 |
| protocol_version | 10 |
| slave_type_
| tokudb_version | tokudb-7.5.2 |
| version | 5.6.21-70.1 |
| version_comment | Percona Server (GPL), Release 70.1, Revision 698 |
| version_
| version_compile_os | debian-linux-gnu |
+------
8 rows in set (0.02 sec)
UPGRADE:
vagrant@
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libperconaser
percona-
Suggested packages:
tinyca
The following packages will be upgraded:
libperconaser
percona-
percona-
5 upgraded, 0 newly installed, 0 to remove and 46 not upgraded.
Need to get 16.8 MB of archives.
After this operation, 67.6 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://
Get:2 http://
Get:3 http://
Get:4 http://
Get:5 http://
Fetched 16.8 MB in 40s (414 kB/s)
Preconfiguring packages ...
(Reading database ... 104045 files and directories currently installed.)
Preparing to unpack .../percona-
Unpacking percona-
Preparing to unpack .../percona-
Unpacking percona-
Preparing to unpack .../libperconas
Unpacking libperconaserve
Preparing to unpack .../percona-
Unpacking percona-
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Setting up percona-
(Reading database ... 104045 files and directories currently installed.)
Preparing to unpack .../percona-
* Stopping MySQL (Percona Server) mysqld
...done.
* Stopping MySQL (Percona Server) mysqld
...done.
Unpacking percona-
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Setting up libperconaserve
Setting up percona-
Setting up percona-
Installing new version of config file /etc/init.d/mysql ...
* Stopping MySQL (Percona Server) mysqld
...done.
* Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
* Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
* See http://
* Starting MySQL (Percona Server) database server mysqld
...done.
* Checking for corrupt, not cleanly closed and upgrade needing tables.
Processing triggers for ureadahead (0.100.0-16) ...
Setting up percona-
Processing triggers for libc-bin (2.19-0ubuntu6.4) ...
vagrant@
* /usr/bin/mysqladmin Ver 8.42 Distrib 5.6.22-71.0, for debian-linux-gnu on x86_64
Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Server version 5.6.22-71.0
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/
Uptime: 1 min 5 sec
Threads: 1 Questions: 914 Slow queries: 0 Opens: 796 Flush tables: 2 Open tables: 83 Queries per second avg: 14.061
mysql> show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.22-71.0 |
| protocol_version | 10 |
| slave_type_
| tokudb_version | tokudb-7.5.4 |
| version | 5.6.22-71.0 |
| version_comment | Percona Server (GPL), Release 71.0, Revision 726 |
| version_
| version_compile_os | debian-linux-gnu |
+------
8 rows in set (0.00 sec)
mysql> select * from City limit 10;
+----+-
| ID | Name | CountryCode | District | Population |
+----+-
| 1 | Kabul | AFG | Kabol | 1780000 |
| 2 | Qandahar | AFG | Qandahar | 237500 |
| 3 | Herat | AFG | Herat | 186800 |
| 4 | Mazar-e-Sharif | AFG | Balkh | 127800 |
| 5 | Amsterdam | NLD | Noord-Holland | 731200 |
| 6 | Rotterdam | NLD | Zuid-Holland | 593321 |
| 7 | Haag | NLD | Zuid-Holland | 440900 |
| 8 | Utrecht | NLD | Utrecht | 234323 |
| 9 | Eindhoven | NLD | Noord-Brabant | 201843 |
| 10 | Tilburg | NLD | Noord-Brabant | 193238 |
+----+-
10 rows in set (0.01 sec)
It needs a Launchpad bug