View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 1 post ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sat Nov 07, 2009 1:23 pm 
Offline
Joined: Sat Jan 06, 2007 7:08 pm
Posts: 125
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

_________________
DH87MC i7-4770 16GB ram Xonar Essence ST geforce 710 LinHes 8.6


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 14 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu