List:General Discussion« Previous MessageNext Message »
From:Thomas Dineen Date:April 2 2011 12:18am
Subject:Mysql Bug 04/01/11
View as plain text  
Gentlemen:

- Keep in mind that I have approximately 50  hours into this Mysql 
server install and still no
results!

- Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz

- When installed and started with the following command:
/usr/local/mysql/bin/mysqld_safe --user=mysql &

The following error occurs:
110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find 
file: './mysql/host.frm' (errno: 13)

1) Please identify where the missing file can be found, keeping in mind 
that I just installed and
have no backup (of the current rev.).

2) If we are installing in /usr/local/mysql where exactly dose this file 
belong,
(exact path please).

3) What exactly do the file ownersiip and permissions have to be?

Keep in mind that I have tried several dozen experiments over many late 
hours with
a version host.frm from a older version of mysql with NO success! I have 
tried putting
it in every possible location. Using 777 file permissions.

A snapshot of my system:
root@Sun# pwd
/usr/local/mysql
root@Sun# ls
bin         info        man         mysql-test  var
host.frm    lib         my.cnf      share
include     libexec     mysql       sql-bench

root@Sun# ls -la host.frm
-rwxrwxrwx   1 root     root        9064 Apr  1 16:39 host.frm

root@Sun# ls -la mysql
total 22
drwxrwxrwx   2 root     root         512 Apr  1 16:34 .
drwxr-xr-x  13 bin      bin          512 Apr  1 16:39 ..
-rwxrwxrwx   1 root     root        9064 Apr  1 16:34 host.frm

- The entire transcript is shown below:

10401 16:39:27  mysqld started
110401 16:39:27 [Warning] option 'max_join_size': unsigned value 
18446744073709
551615 adjusted to 4294967295
110401 16:39:27 [Warning] option 'max_join_size': unsigned value 
18446744073709
551615 adjusted to 4294967295
110401 16:39:27 [Warning] option 'thread_stack': unsigned value 65536 
adjusted
to 131072
110401 16:39:27 [Warning] option 'thread_stack': unsigned value 65536 
adjusted
to 131072
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
110401 16:39:27  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
110401 16:39:27  InnoDB: Starting an apply batch of log records to the 
database
...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 
49 50 5
1 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 
75 76 77
  78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
110401 16:39:27  InnoDB: Started; log sequence number 0 43655
110401 16:39:27 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find 
file: './my
sql/host.frm' (errno: 13)
110401 16:39:27 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find 
file: './my
sql/host.frm' (errno: 13)
110401 16:39:27 [ERROR] Fatal error: Can't open and lock privilege 
tables: Can'
t find file: './mysql/host.frm' (errno: 13)
110401 16:39:27  mysqld ended

110401 16:42:30  mysqld started
110401 16:42:30 [Warning] option 'max_join_size': unsigned value 
18446744073709
551615 adjusted to 4294967295
110401 16:42:30 [Warning] option 'max_join_size': unsigned value 
18446744073709
551615 adjusted to 4294967295
110401 16:42:30 [Warning] option 'thread_stack': unsigned value 65536 
adjusted
to 131072
110401 16:42:30 [Warning] option 'thread_stack': unsigned value 65536 
adjusted
to 131072
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
110401 16:42:30  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
110401 16:42:30  InnoDB: Starting an apply batch of log records to the 
database
...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 
49 50 5
1 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 
75 76 77
  78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
110401 16:42:30  InnoDB: Started; log sequence number 0 43655
110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find 
file: './my
sql/host.frm' (errno: 13)
110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find 
file: './my
sql/host.frm' (errno: 13)
110401 16:42:30 [ERROR] Fatal error: Can't open and lock privilege 
tables: Can'
t find file: './mysql/host.frm' (errno: 13)
110401 16:42:30  mysqld ended

root@Sun#
Thread
Mysql Bug 04/01/11Thomas Dineen2 Apr
  • Re: Mysql Bug 04/01/11Jigal van Hemert2 Apr
  • Re: Mysql Bug 04/01/11Reindl Harald2 Apr
    • Re: Mysql Bug 04/01/11Claudio Nanni2 Apr
      • Re: Mysql Bug 04/01/11Reindl Harald2 Apr
  • Re: Mysql Bug 04/01/11: http://dev.mysql.com/doc/refman/5.0/en/starting-server.htmlReindl Harald2 Apr
Re: Mysql Bug 04/01/11Claudio Nanni2 Apr
  • Got It; Thank You; Re: Mysql Bug 04/01/11Thomas Dineen2 Apr