Bug #76451 | Database downgraded to 5.5.27 during patching from 5.5.40 to 5.5.41 | ||
---|---|---|---|
Submitted: | 23 Mar 2015 10:44 | Modified: | 25 Mar 2015 12:42 |
Reporter: | Suman Das | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Installing | Severity: | S1 (Critical) |
Version: | 5.5.40 MySQL Community Server (GPL) | OS: | Linux (Red Hat Enterprise Linux Server release 5.6 (Tikanga)) |
Assigned to: | CPU Architecture: | Any | |
Tags: | Patching issue |
[23 Mar 2015 10:44]
Suman Das
[24 Mar 2015 8:49]
Suman Das
Can you give an update please?
[25 Mar 2015 11:58]
Chiranjeevi Battula
Hello Suman Das, Thank you for the bug report. I tried to reproduce the steps at my end, but couldn't trace out any issue with upgrading from 5.5.40 to 5.5.41. Could you please list out the steps you tried out at your end? Please provide repeatable steps for us to confirm this issue at our end. Thanks, Chiranjeevi.
[25 Mar 2015 11:59]
Chiranjeevi Battula
[chiran@chiran-linux ~]$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.5.40 MySQL Community Server (GPL) 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. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select version(); +-----------+ | version() | +-----------+ | 5.5.40 | +-----------+ 1 row in set (0.00 sec) mysql> exit Bye [chiran@chiran-linux ~]$ sudo rpm -Uvh /home/chiran/5.5.41/MySQL-server-5.5.41-1.rhel5.x86_64.rpm Preparing... ########################################### [100%] Giving mysqld 5 seconds to exit nicely 1:MySQL-server ########################################### [100%] Starting MySQL..[ OK ] Giving mysqld 5 seconds to start [chiran@chiran-linux ~]$ sudo service mysql start Starting MySQL [ OK ] [chiran@chiran-linux ~]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.41 MySQL Community Server (GPL) 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. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select version(); +-----------+ | version() | +-----------+ | 5.5.41 | +-----------+ 1 row in set (0.00 sec) mysql> exit Bye [chiran@chiran-linux ~]$ sudo rpm -Uvh /home/chiran/5.5.41/MySQL-client-5.5.41-1.rhel5.x86_64.rpm Preparing... ########################################### [100%] 1:MySQL-client ########################################### [100%] [chiran@chiran-linux ~]$ sudo service mysql start Starting MySQL [ OK ] [chiran@chiran-linux ~]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.5.41 MySQL Community Server (GPL) 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. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select version(); +-----------+ | version() | +-----------+ | 5.5.41 | +-----------+ 1 row in set (0.00 sec) mysql>
[25 Mar 2015 12:21]
Suman Das
Thanks Chiranjeevi for accepting and checking the bug. Do you think is there any issue from OS side? The server is showing those rpms are installed, but not reflecting in DB version. ----------------------------------------- mysql@qatintaliodb01:~$rpm -qa|grep MySQL MySQL-server-5.5.40-1.rhel5 MySQL-server-5.5.41-1.rhel5 MySQL-client-5.5.41-1.rhel5 ----------------------------------------- The DB was supposed to be upgraded from 5.5.40 to 5.5.41, but unfortunately showing downgraded. ----------------------------------------- mysql> select version(); +------------+ | version() | +------------+ | 5.5.27-log | +------------+ 1 row in set (0.00 sec) ----------------------------------------- Please let me know what more information you need to investigate with us? Also, let me know if we can arrange a call back or desktop sharing with you for same. Thanks !
[25 Mar 2015 12:42]
MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/ Chiran has confirmed that this issue is not repeatable at our end and this seems to be most likely caused due to failed installation/up-gradation earlier etc, please check rpm -qa|grep -i mysql to see if any left over from 5.5.27 which is causing this issue and address it before trying to upgrade 5.5.40 to 5.5.41. Thank you for your interest in MySQL.