It's always a laugh or three when talking to Jeff and since this was a critical server (high traffic) I thought first to call him to see if he has hit this yet...and in fact he had, however it would be nice to understand the exact details here and how we can prevent this for the common user in the future.thank you these command # killall -KILL mysqld # service mysqld start helped me to solve this issue [[email protected] ~]# service mysqld restart ERROR!
busybox gconv-modules libuclibc ncursesw libgd Some of these may have been requirements for squeezeboxserver, and not My SQL. Unfortunately after installing all the above My SQL5 still won't start. Configuring mysql5 /opt/etc/init.d/S70mysqld: line 276: /bin/hostname: not found /opt/etc/init.d/S70mysqld: line 285: /bin/hostname: not found Starting My SQL… I'm a newbie when it comes to this, I don't appear to have either /bin/hostname or /opt/bin/hostname to change to. In summary: Install ipkg packages ncursesw and libuclibc . Edit (“/opt/etc/my.cnf”) and add the following two lines user = root data dir = /opt/var/lib/ Edit S70mysqld (“/opt/etc/init.d/S70mysqld” ) and add "/opt" to the path prior to "/bin/hostname`.pid" on lines 270 and 279. Well after mysql was updated it failed to start throwing the following error.I'm not sure why this line above didn't cause any issues with 5.1.55 and threw 5.1.56 into a frizzy...141106 Inno DB: Retrying to lock the first data file Inno DB: Unable to lock ./ibdata1, error: 11 Inno DB: Check that you do not already have another mysqld process Inno DB: using the same Inno DB data or log files.Inno DB: Unable to lock ./ibdata1, error: 11 Inno DB: Check that you do not already have another mysqld process Inno DB: using the same Inno DB data or log files.Then, you need to verify if all the permissions are intact or not.Next helpline could be your error log and when you read the error log, you get following details- Inno DB: Unable to lock ./ibdata1, error: 11 Inno DB: Check that you do not already have another mysqld process Inno DB: using the same Inno DB data or log files.141106 Inno DB: Shutdown completed; log sequence number 882 2873506614 141106 [Note] /usr/sbin/mysqld: Shutdown complete 141106 mysqld_safe mysqld from pid file /var/lib/mysql/*******ended 141106 Inno DB: Started; log sequence number 882 2873506614 /usr/sbin/mysqld: File ” not found (Errcode: 2) 141106 [ERROR] Failed to open log (file ”, errno 2) 141106 [ERROR] Could not open log file 141106 [ERROR] Can’t init tc log 141106 [ERROR] Aborting Referring to these logs, it looked to be an issue with the log or data files.I decided to delete the ib_logfile0 and ib_logfile1 files, and tried restarting My SQL Service once again but it was still throwing the same error.Make sure to brew info mysql if you missed it after mysql installs.It contains the instruction you probably missed to mysql_install_db Getting the database set up properly resolved the error for me.