mysql-bin.index not found
apple Verified ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hi,
I try to lauch MySQL service via Server Admin. It failed and I have this message in the log:
080215 15:50:29 mysqld started
080215 15:50:29 [Warning] Setting lower
case_tablenames=2 because file system for /var/mysql/ is case insensitive
/usr/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
080215 15:50:29 [ERROR] Aborting
080215 15:50:29 [Note] /usr/libexec/mysqld: Shutdown complete
080215 15:50:29 mysqld ended
Thank you for your help,
joe
7 replies
Sign in or join Beachball Help to reply.
- 0
pterobyte ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Does mysql-bin.index exist and does it have the right permissions?
If not you may need to flush the log files.
- 0
joe-farka ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hi pterobyte,
nice to see you.
-rw-rw---- 1 _mysql admin 427K Feb 22 10:17 /private/var/mysql/mysql-bin.index
Is that correct ?
I have this in /Library/Logs/MySQL.log:
2008-02-22 10:18:28 Europe/Paris
Starting MySQL Service
2008-02-22 10:18:28 Europe/Paris Starting MySQL daemon...
2008-02-22 10:18:28 Europe/Paris
MySQL startup options: socket=/var/mysql/mysql.sock; datadir=/var/mysql; pid-file=/var/mysql/ns.epigenomique.genopole.fr.pid; network=NO
2008-02-22 10:19:01 Europe/Paris [E] MySQL daemon startup timed-out.
Thanks,
joe - 0
pterobyte ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hi Joe,
Yes, that should work. You may want to flush/reset your log files.
See:
http://mysql2.mirrors-r-us.net/doc/refman/5.0/en/reset-master.html
http://mysql2.mirrors-r-us.net/doc/refman/5.0/en/flush.html - 0
joe-farka ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Ok, but the daemon does not start. I cannot do these actions.
joe
- 0
pterobyte ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Check that the enclosing directory has the right permissions as well.
Try and move the index file to a different place and see if mysql will create it properly. - 0
joe-farka ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Ok,
mysqld well re-created it. But the daemon still not starts.
When I do a tail -f /var/log/system | grep -i sql, it tells me:Feb 22 12:04:04 ns org.mysql.mysqld[87098]: 080222 12:04:04 [Warning] Setting lower
case_tablenames=2 because file system for /var/mysql/ is case insensitive
Feb 22 12:04:04 ns org.mysql.mysqld[87098]: 080222 12:04:04 [Warning] Setting lower
case_tablenames=2 because file system for /var/mysql/ is case insensitive
Feb 22 12:04:04 ns org.mysql.mysqld[87098]: 080222 12:04:04 InnoDB: Database was not shut down normally!
Feb 22 12:04:04 ns org.mysql.mysqld[87098]: 080222 12:04:04 InnoDB: Database was not shut down normally!
Feb 22 12:04:04 ns org.mysql.mysqld[87098]: InnoDB: Starting crash recovery.
Feb 22 12:04:04 ns org.mysql.mysqld[87098]: InnoDB: Starting crash recovery.
Feb 22 12:04:04 ns org.mysql.mysqld[87098]: InnoDB: Reading tablespace information from the .ibd files...
Feb 22 12:04:04 ns org.mysql.mysqld[87098]: InnoDB: Reading tablespace information from the .ibd files...
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: InnoDB: Restoring possible half-written data pages from the doublewrite
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: InnoDB: Restoring possible half-written data pages from the doublewrite
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: InnoDB: buffer...
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: InnoDB: buffer...
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 InnoDB: Starting log scan based on checkpoint at
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 InnoDB: Starting log scan based on checkpoint at
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: InnoDB: log sequence number 0 43655.
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: InnoDB: log sequence number 0 43655.
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: InnoDB: Doing recovery: scanned up to log sequence number 0 43655
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: InnoDB: Doing recovery: scanned up to log sequence number 0 43655
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 InnoDB: Started; log sequence number 0 43655
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 InnoDB: Started; log sequence number 0 43655
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 [Note] Recovering after a crash using mysql-bin
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 [Note] Recovering after a crash using mysql-bin
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 [Note] Starting crash recovery...
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 [Note] Starting crash recovery...
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 [Note] Crash recovery finished.
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 [Note] Crash recovery finished.
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
Feb 22 12:04:05 ns org.mysql.mysqld[87098]: 080222 12:04:05 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
Feb 22 12:04:05 ns com.apple.launchd[1] (org.mysql.mysqld[87098]): Exited with exit code: 1
Feb 22 12:04:05 ns com.apple.launchd[1] (org.mysql.mysqld[87098]): Exited with exit code: 1
Feb 22 12:04:05 ns com.apple.launchd[1] (org.mysql.mysqld): Throttling respawn: Will start in 10 seconds
Feb 22 12:04:05 ns com.apple.launchd[1] (org.mysql.mysqld): Throttling respawn: Will start in 10 secondsThen, I chowned _mysql:wheel /var/private/mysql/mysql, and the daemon starts fine !
It is a little bit strange that by default, the first start of MySQL does not work.
Sometimes, I have the impression that I admin a Linux server...thanks a lot,
joe - 0
pterobyte ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Yep, that's why I suggested to fix permissions on the enclosing directory.
Glad you got it sorted. 🙂