Different Server version value when installing from Source/Binary/RPM

Bug #1244178 reported by Muhammad Irfan
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Stewart Smith
5.1
Won't Fix
Undecided
Unassigned
5.5
Fix Released
Medium
Stewart Smith
5.6
Fix Released
Medium
Stewart Smith

Bug Description

I noticed difference in server version parameter value when installing via Source vs Binary/RPM. To me Binary/RPM looks more correct. I found this behavior during my test on CentOS 6.

Installation steps via source tarball fairly simple.

$ cmake . -DBUILD_CONFIG=mysql_release
$ make
$ make install

Installing Percona-Server-5.6.13-rel61.0.tar.gz via source.

mysql> status
--------------
mysql Ver 14.14 Distrib 5.6.13, for Linux (x86_64) using EditLine wrapper

Connection id: 7
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.6.13 MySQL Community Server (GPL)
Protocol version: 10

mysql> show global variables like '%version%';
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| innodb_version | 5.6.13-60.3 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.13 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+------------------------------+

While installing Percona-Server-5.6.13-rel61 from Binary/RPM.

mysql> status
--------------
bin/mysql Ver 14.14 Distrib 5.6.13, for Linux (x86_64) using EditLine wrapper

Connection id: 1
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: less
Using outfile: ''
Using delimiter: ;
Server version: 5.6.13-rel61.0 Percona Server with XtraDB (GPL), Release rel61.0, Revision 461
Protocol version: 10

mysql> show global variables like '%version%';
+-------------------------+-----------------------------------------------------+
| Variable_name | Value |
+-------------------------+-----------------------------------------------------+
| innodb_version | 5.6.13-rel61.0 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.13-56 |
| version_comment | Percona Server (GPL), Release rel61.0, Revision 461 |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+-----------------------------------------------------+

You can see there is different value against "version_comment, innodb_version" parameters.

Tags: pkg

Related branches

description: updated
Revision history for this message
Roel Van de Paar (roel11) wrote :

Issue may already be known/fixed. Notified AlexeyB

Revision history for this message
Muhammad Irfan (muhammad-irfan) wrote :

I tried it with Percona-Server-5.6.14-rel62.0.tar.gz by building it from source.

Installation steps via source tarball fairly simple.

$ cmake . -DBUILD_CONFIG=mysql_release
$ make
$ make install

mysql> status
--------------
bin/mysql Ver 14.14 Distrib 5.6.14, for Linux (x86_64) using EditLine wrapper

Connection id: 1
Current database: test
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.6.14 MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 1 min 4 sec

Threads: 1 Questions: 12 Slow queries: 0 Opens: 67 Flush tables: 1 Open tables: 60 Queries per second avg: 0.187
--------------

mysql> show global variables like '%version%';
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| innodb_version | 5.6.14-60.3 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.14 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+------------------------------+

So, it still appears as "MySQL Community Server (GPL) |" in 5.6.14 too.

tags: added: pkg
Revision history for this message
Stewart Smith (stewart) wrote :

I'm pretty sure this should be fixed in my pkg-5.5 and pkg-5.6 branches as they get the version number entirely from VERSION rather than having it specified in RPM, deb and binary packaging. Setting as Fix Released and we can re-open if there's something weird that I missed.

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-1444

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

Other bug subscribers

Remote bug watches

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