Migration of MySQL 5.0.x to 5.5.32-0.9.1 fails with unknown option --skip-locking
This document (7013208) is provided subject to the disclaimer at the end of this document.
Environment
SUSE Linux Enterprise Server 11 SP3
Subscription Management Tool 11 SP3
Subscription Management Tool 11 SP3
Situation
When upgrading from SLE11SP2 to SP3 on a system running SMT11, the following error may get encountered when migrating the MySQL database from version 5.0.x to 5.5.32-0.9.1:
testsmt:~ # rcmysql restart
Restarting service MySQL
Shutting down service MySQL done
Will update MySQL now, if you encounter any problems, please read following
file:
/usr/share/doc/packages/mysql/README.SuSE
Log files inconsistency, please merge following files manually:
/var/lib/mysql/mysqld.log
/var/log/mysqld.log
Running protected MySQL...
error: /var/tmp/mysql-protected.gDATed/mysql.sock file didn't appeared...
Try checking "/var/log/mysql/mysqld-upgrade-run.log"...
/var/log/mysql/mysqld-upgrade-run.log:
130904 12:27:47 mysqld_safe mysqld from pid file
/var/tmp/mysql-protected.ZYrZ6l/mysqld.pid ended
130904 12:28:42 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
130904 12:28:42 InnoDB: The InnoDB memory heap is disabled
130904 12:28:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130904 12:28:42 InnoDB: Compressed tables use zlib 1.2.7
130904 12:28:42 InnoDB: Using Linux native AIO
130904 12:28:42 InnoDB: Initializing buffer pool, size = 128.0M
130904 12:28:42 InnoDB: Completed initialization of buffer pool
130904 12:28:42 InnoDB: highest supported file format is Barracuda.
130904 12:28:42 InnoDB: Waiting for the background threads to start
130904 12:28:43 InnoDB: 5.5.32 started; log sequence number 1606200
130904 12:28:43 [ERROR] /usr/sbin/mysqld: unknown option '--skip-locking'
130904 12:28:43 [ERROR] Aborting
Resolution
Edit /etc/my.cnf and change the entry
skip-lockingto
skip-external-lockingAfter the change, please run
rcmysql restart
Cause
Option skip-locking is deprecated in MySQL 5.5.x.
Disclaimer
This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.
- Document ID:7013208
- Creation Date: 05-Sep-2013
- Modified Date:28-Sep-2022
-
- SUSE Linux Enterprise Server
For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback[at]suse.com
