Benches macOS

7

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.

  1. 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.

  2. 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

  3. 0

    pterobyte

    Imported from the Apple Support Forums via the Wayback Machine 🔗

  4. 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

  5. 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.

  6. 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 seconds

    Then, 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

  7. 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. 🙂