I just have a crash of my mysql 4.1.5 .(the machine where it was running just shutdown)
Tried to restart it, and problem with innodb:
050303 11:58:46 [WARNING] Asked for 196608 thread stack, but got 126976
InnoDB: Unable to lock ./ibdata1, error: 11InnoDB: Error in opening ./ibdata1
050303 11:58:46 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: See also section 13.2 at http://www.innodb.com/ibman.php
InnoDB: about operating system error numbers.
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!
050303 11:58:46 [ERROR] Can't init databases
050303 11:58:46 [ERROR] Aborting
050303 11:58:46 [NOTE] ./bin/mysqld: Shutdown complete
I'm sure I already saw that kind of problem, tried to go through the list but didn't find the thread again. In addition I'm not very familiar with that kind of thing.
I don't use innodb at all, only myisam, so I was able to restart with --skip-innodb.
About the error code "ressource unavailable" I tried later on no difference, the file ibdata1 is there with adequate permissions, I don't think that I have a my.cnf...
To sum up I have no idea what to do, and I'm not a system guru! My first ideas: - removing the ibdata1 file and recreating an empty one - I saw a force-recovery option but have no idea how it works
Hope somebody here can help me.... Thanks a lot
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
