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.


SUSE Linux Enterprise Server 11 SP3
Subscription Management Tool 11 SP3


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
Log files inconsistency, please merge following files manually:
Running protected MySQL... 
error: /var/tmp/mysql-protected.gDATed/mysql.sock file didn't appeared... 
       Try checking "/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
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


Edit /etc/my.cnf and change the entry
After the change, please run
rcmysql restart


Option skip-locking is deprecated in MySQL 5.5.x.


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

< Back to Support Search

For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback[at]suse.com

SUSE Support Forums

Get your questions answered by experienced Sys Ops or interact with other SUSE community experts.

Join Our Community

Support Resources

Learn how to get the most from the technical support you receive with your SUSE Subscription, Premium Support, Academic Program, or Partner Program.

SUSE Customer Support Quick Reference Guide SUSE Technical Support Handbook Update Advisories
Support FAQ

Open an Incident

Open an incident with SUSE Technical Support, manage your subscriptions, download patches, or manage user access.

Go to Customer Center