Bug #73835 service start failing with sles11 5.7.5-community repo packages
Submitted: 8 Sep 2014 11:58 Modified: 15 Jul 2015 22:21
Reporter: Ramana Yeruva Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Package Repos Severity:S3 (Non-critical)
Version:5.7.5 OS:Any
Assigned to: CPU Architecture:Any

[8 Sep 2014 11:58] Ramana Yeruva
Description:
install sles11 repo file on  the clean environment
install mysql-community packages from repository
start service and observe that it is failing with below error
vitro16:~/ramana # service mysql start
mysql_install_db: [ERROR] unknown option '--rpm'
2014-09-08 13:48:39 [ERROR]   Unrecognized options
MySQL Database could not initialize data directory:                                                                                                             unused

How to repeat:
vitro16:~/ramana # zypper clean --all
All repositories have been cleaned up.
vitro16:~/ramana # ls
list1.txt  mysql-community-release-sles11-11.noarch.rpm  repository_code  rpms  zypper_packages_list.out
vitro16:~/ramana # zypper update
Retrieving repository 'SUSE-Linux-Enterprise-Server-11-SP3 11.3.3-1.138' metadata [done]
Building repository 'SUSE-Linux-Enterprise-Server-11-SP3 11.3.3-1.138' cache [done]
Retrieving repository 'SDK' metadata [done]
Building repository 'SDK' cache [done]
Loading repository data...
Reading installed packages...

Nothing to do.
vitro16:~/ramana # zypper install mysql-community-release-sles11-11.noarch.rpm 
Loading repository data...
Reading installed packages...
Resolving package dependencies...

The following NEW package is going to be installed:
  mysql-community-release 

The following package is not supported by its vendor:
  mysql-community-release 

1 new package to install.
Overall download size: 6.0 KiB. After the operation, additional 3.0 KiB will be used.
Continue? [y/n/?] (y): y
Retrieving package mysql-community-release-sles11-11.noarch (1/1), 6.0 KiB (3.0 KiB unpacked)
Retrieving package mysql-community-release-sles11-11.noarch (1/1), 6.0 KiB (3.0 KiB unpacked)
Installing: mysql-community-release-sles11-11 [done]
vitro16:~/ramana # zypper clean --all
All repositories have been cleaned up.
vitro16:~/ramana # zypper update
Retrieving repository 'SUSE-Linux-Enterprise-Server-11-SP3 11.3.3-1.138' metadata [done]
Building repository 'SUSE-Linux-Enterprise-Server-11-SP3 11.3.3-1.138' cache [done]
Retrieving repository 'SDK' metadata [done]
Building repository 'SDK' cache [done]
Building repository 'mysql-community-x86_64' cache [done]
Loading repository data...
Reading installed packages...

Nothing to do.
vitro16:~/ramana # zypper search 'mysql-community*'
Loading repository data...
Reading installed packages...

S | Name                           | Summary                                                                       | Type   
--+--------------------------------+-------------------------------------------------------------------------------+--------
  | mysql-community-bench          | MySQL benchmark suite                                                         | package
  | mysql-community-client         | MySQL database client applications and tools                                  | package
  | mysql-community-common         | MySQL database common files for server and client libs                        | package
  | mysql-community-devel          | Development header files and libraries for MySQL database client applications | package
  | mysql-community-embedded       | MySQL embedded library                                                        | package
  | mysql-community-embedded-devel | Development header files and libraries for MySQL as an embeddable library     | package
  | mysql-community-libs           | Shared libraries for MySQL database client applications                       | package
i | mysql-community-release        | MySQL repository configuration for zypper                                     | package
  | mysql-community-server         | A very fast and reliable SQL database server                                  | package
  | mysql-community-test           | Test suite for the MySQL database server                                      | package
vitro16:~/ramana # zypper install mysql-community-bench mysql-community-client mysql-community-common mysql-community-devel mysql-community-embedded mysql-community-embedded-devel mysql-community-libs mysql-community-server mysql-community-test
Loading repository data...
Reading installed packages...
Resolving package dependencies...

The following NEW packages are going to be installed:
  mysql-community-bench mysql-community-client mysql-community-common mysql-community-devel mysql-community-embedded mysql-community-embedded-devel mysql-community-libs 
  mysql-community-server mysql-community-test 

The following packages are not supported by their vendor:
  mysql-community-bench mysql-community-client mysql-community-common mysql-community-devel mysql-community-embedded mysql-community-embedded-devel mysql-community-libs 
  mysql-community-server mysql-community-test 

9 new packages to install.
Overall download size: 335.6 MiB. After the operation, additional 1.7 GiB will be used.
Continue? [y/n/?] (y): y
Retrieving package mysql-community-common-5.7.5-0.2.m15.sles11.x86_64 (1/9), 258.0 KiB (2.2 MiB unpacked)
Retrieving: mysql-community-common-5.7.5-0.2.m15.sles11.x86_64.rpm [done]
Retrieving package mysql-community-embedded-5.7.5-0.2.m15.sles11.x86_64 (2/9), 33.5 MiB (135.0 MiB unpacked)
Retrieving: mysql-community-embedded-5.7.5-0.2.m15.sles11.x86_64.rpm [done]
Retrieving package mysql-community-libs-5.7.5-0.2.m15.sles11.x86_64 (3/9), 2.3 MiB (10.0 MiB unpacked)
Retrieving: mysql-community-libs-5.7.5-0.2.m15.sles11.x86_64.rpm [done]
Retrieving package mysql-community-client-5.7.5-0.2.m15.sles11.x86_64 (4/9), 21.5 MiB (91.7 MiB unpacked)
Retrieving: mysql-community-client-5.7.5-0.2.m15.sles11.x86_64.rpm [done]
Retrieving package mysql-community-devel-5.7.5-0.2.m15.sles11.x86_64 (5/9), 3.7 MiB (22.7 MiB unpacked)
Retrieving: mysql-community-devel-5.7.5-0.2.m15.sles11.x86_64.rpm [done]
Retrieving package mysql-community-server-5.7.5-0.2.m15.sles11.x86_64 (6/9), 92.2 MiB (394.6 MiB unpacked)
Retrieving: mysql-community-server-5.7.5-0.2.m15.sles11.x86_64.rpm [done]
Retrieving package mysql-community-embedded-devel-5.7.5-0.2.m15.sles11.x86_64 (7/9), 98.9 MiB (613.4 MiB unpacked)
Retrieving: mysql-community-embedded-devel-5.7.5-0.2.m15.sles11.x86_64.rpm [done (47.0 MiB/s)]
Retrieving package mysql-community-test-5.7.5-0.2.m15.sles11.x86_64 (8/9), 82.9 MiB (474.5 MiB unpacked)
Retrieving: mysql-community-test-5.7.5-0.2.m15.sles11.x86_64.rpm [done]
Retrieving package mysql-community-bench-5.7.5-0.2.m15.sles11.x86_64 (9/9), 386.0 KiB (2.6 MiB unpacked)
Retrieving: mysql-community-bench-5.7.5-0.2.m15.sles11.x86_64.rpm [done]
Installing: mysql-community-common-5.7.5-0.2.m15.sles11 [done]
Installing: mysql-community-embedded-5.7.5-0.2.m15.sles11 [done]
Installing: mysql-community-libs-5.7.5-0.2.m15.sles11 [done]
Installing: mysql-community-client-5.7.5-0.2.m15.sles11 [done]
Installing: mysql-community-devel-5.7.5-0.2.m15.sles11 [done]
Installing: mysql-community-server-5.7.5-0.2.m15.sles11 [done]
Additional rpm output:
insserv: warning: script 'S01bigbrother' missing LSB tags
insserv: warning: script 'bigbrother' missing LSB tags
Installing: mysql-community-embedded-devel-5.7.5-0.2.m15.sles11 [done]
Installing: mysql-community-test-5.7.5-0.2.m15.sles11 [done]
Installing: mysql-community-bench-5.7.5-0.2.m15.sles11 [done]
vitro16:~/ramana # ls /var/lib/mysql/
vitro16:~/ramana # service mysql start
mysql_install_db: [ERROR] unknown option '--rpm'
2014-09-08 13:48:39 [ERROR]   Unrecognized options
MySQL Database could not initialize data directory:                                                                                                             unused

Suggested fix:
service start should be successful and database should be created as part of service startup

This issue could be because of wl7688 merge and sles repo scripts should reflect wl7688 changes accordingly as like other platform repos(EL5,EL6,EL7,FC19,FC20)