LinHES Forums http://forums.linhes.org/ |
|
yet another database crash question http://forums.linhes.org/viewtopic.php?f=25&t=20490 |
Page 1 of 1 |
Author: | welner [ Sat Nov 07, 2009 1:23 pm ] |
Post subject: | yet another database crash question |
i am having trouble getting mysql started up. this problem started when i noticed high disk i//o activity this morning. i run the standard backup script each midnight. after hitting my myth box via a web browser, i saw that mysql was not running. after ssh'ing in, i also saw that the database backup file was only 36 bytes, so it appears that something happened during the backup process as the database was being stopped. the only change i made just before this problem surfaced was to update hulu desktop via cecils installation script. after checking filesystem space and verifying that there were no full partitions, i rebooted the box. upon reboot, mysql did not start. /data/srv/mysql/mythtv.err shows: Code: 091107 13:17:44 mysqld started 091107 13:17:44 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 091107 13:17:44 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 /usr/sbin/mysqld: Can't create/write to file '/tmp/ibMPzWN5' (Errcode: 13) 091107 13:17:44 InnoDB: Error: unable to create temporary file; errno: 13 091107 13:17:45 [ERROR] Can't start server : Bind on unix socket: Permission denied 091107 13:17:45 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 091107 13:17:45 [ERROR] Aborting 091107 13:17:45 [Note] /usr/sbin/mysqld: Shutdown complete 091107 13:17:45 mysqld ended i have attempted to check and repair the database even though myisamchk shows no errors. i have a good backup and am prepared to use the mythrestore script to restore things, but it seems as though mysql needs to be running to perform the restore. since i cant get mysql started, i am kind of stuck regarding the error message: Code: /usr/sbin/mysqld: Can't create/write to file '/tmp/ibMPzWN5' (Errcode: 13) the /tmp file system has plenty of space and i am able to touch a file in /tmp all of the google searches concerning this error give the usual motherhood suggestions such as checking permissions and disk space. i have not found anything beyond those suggestions. the first two warning messages are interesting: Code: 091107 13:17:44 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 091107 13:17:44 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 however, the mythtv.err log shows the creation of the database and starts out with those warning messages, so i dont think they are related to the issue Code: Do you already have another mysqld server running on socket: /tmp/mysql.sock
there is no mysql.sock in /tmp, and netstat shows that port 3306 is not in use so, at this point, without knowing how to get mysql restarted to recreate/restore the mythconvrg database, i think i am looking at doing a full auto-upgrade. any suggestions on how to get mysql running without having to reinstall are greatly appreciated |
Page 1 of 1 | All times are UTC - 6 hours |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |