Hi list, Recently i notice mysql stopping randomly approx. two times a week. I have to start the process manually after someone complains about it. The mysql error log show the following:
InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 070208 5:27:51 InnoDB: Unable to open the first data file InnoDB: Error in opening ./ibdata1 070208 5:27:51 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/mysql/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! 070208 5:27:52 [ERROR] Can't init databases 070208 5:27:52 [ERROR] Aborting 070208 5:27:56 [Note] /usr/sbin/mysqld: Shutdown complete 070208 05:27:56 mysqld ended 070208 9:11:02 [Note] /usr/sbin/mysqld: Normal shutdown 070208 9:11:04 InnoDB: Starting shutdown... 070208 09:11:09 mysqld started 070208 9:11:10 InnoDB: Started; log sequence number 0 403202 /usr/sbin/mysqld: ready for connections. Version: '4.1.22' socket: '/var/run/mysql/mysql.sock' port: 3306 Trustix MySQL RPM 070208 9:11:10 InnoDB: Shutdown completed; log sequence number 0 403202 070208 9:11:10 [Note] /usr/sbin/mysqld: Shutdown complete 070208 09:11:11 mysqld ended 070210 06:02:51 mysqld ended 070210 12:31:33 mysqld started 070210 12:31:33 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 070210 12:31:34 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 403212. InnoDB: Doing recovery: scanned up to log sequence number 0 403212 070210 12:31:35 InnoDB: Flushing modified pages from the buffer pool... 070210 12:31:35 InnoDB: Started; log sequence number 0 403212 /usr/sbin/mysqld: ready for connections. Version: '4.1.22' socket: '/var/run/mysql/mysql.sock' port: 3306 Trustix MySQL RPM Someone have hints about this? Thanks, Arien _______________________________________________ tsl-discuss mailing list [email protected] http://lists.trustix.org/mailman/listinfo/tsl-discuss
