Hi All, In my master db, bin-log was not getting generated due to space issue, so i shut it down using 'mysqladmin shutdown". I cleared some old bin-logs and when i restart mysql using "mysqld_safe", i am getting below error. I checked for any other mysqld process, but did not find any. Please help
ps -ef | grep mysqld mysql 9125 9019 0 22:57 pts/0 00:00:00 grep mysqld InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /data/mysql/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /data/mysql/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 070620 21:51:09 InnoDB: Unable to open the first data file InnoDB: Error in opening /data/mysql/ibdata1 070620 21:51:09 InnoDB: Operating system error number 11 in a file operation. InnoDB: Error number 11 means 'Resource temporarily unavailable'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html InnoDB: Could not open or create data files. InnoDB: If you tried to add new data files, and it failed here, InnoDB: you should now edit innodb_data_file_path in my.cnf back InnoDB: to what it was, and remove the new ibdata files InnoDB created InnoDB: in this failed attempt. InnoDB only wrote those files full of InnoDB: zeros, but did not yet use them in any way. But be careful: do not InnoDB: remove old data files which contain your precious data! 070620 21:51:09 [ERROR] Default storage engine (InnoDB) is not available 070620 21:51:09 [ERROR] Aborting