Gentle People:

Using the following startup command: /etc/init.d/mysql.server start
I get the following error:
110331 18:49:41 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find
file: './mysql/host.frm' (errno: 13)


1) Where do I find or how do I create the file host.frm

2) What is the proper location (Full path please) for host.frm

3) It would be easier to debug this if your error messages included the
full path!
not something like ./ which provides no help in identifing where a file
is required.


Thomas Dineen


110331 18:40:10 mysqld started
110331 18:40:10 [Warning] option 'max_join_size': unsigned value
184467440737095
51615 adjusted to 4294967295
110331 18:40:10 [Warning] option 'max_join_size': unsigned value
184467440737095
51615 adjusted to 4294967295
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
110331 18:40:10 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
110331 18:40:10 InnoDB: Starting an apply batch of log records to the
database.
...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
19 20 21
22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
46 47 48
49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
72 73 74 7
5 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
110331 18:40:11 InnoDB: Started; log sequence number 0 43655
110331 18:40:11 [ERROR] Fatal error: Can't open and lock privilege
tables: Table
'mysql.host' doesn't exist
110331 18:40:11 mysqld ended

110331 18:49:41 mysqld started
110331 18:49:41 [Warning] option 'max_join_size': unsigned value
184467440737095
51615 adjusted to 4294967295
110331 18:49:41 [Warning] option 'max_join_size': unsigned value
184467440737095
51615 adjusted to 4294967295
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
110331 18:49:41 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
110331 18:49:41 InnoDB: Starting an apply batch of log records to the
database.
...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
19 20 21
22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
46 47 48
49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
72 73 74 7
5 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
110331 18:49:41 InnoDB: Started; log sequence number 0 43655
110331 18:49:41 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find
file: './mys
ql/host.frm' (errno: 13)
110331 18:49:41 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find
file: './mys
ql/host.frm' (errno: 13)
110331 18:49:41 [ERROR] Fatal error: Can't open and lock privilege
tables: Can't
find file: './mysql/host.frm' (errno: 13)
110331 18:49:41 mysqld ended

110331 19:06:48 mysqld started
110331 19:06:48 [Warning] option 'max_join_size': unsigned value
184467440737095
51615 adjusted to 4294967295
110331 19:06:48 [Warning] option 'max_join_size': unsigned value
184467440737095
51615 adjusted to 4294967295
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
110331 19:06:48 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
110331 19:06:48 InnoDB: Starting an apply batch of log records to the
database.
...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
19 20 21
22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
46 47 48
49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
72 73 74 7
5 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
110331 19:06:48 InnoDB: Started; log sequence number 0 43655
110331 19:06:48 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find
file: './mys
ql/host.frm' (errno: 13)
110331 19:06:48 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find
file: './mys
ql/host.frm' (errno: 13)
110331 19:06:48 [ERROR] Fatal error: Can't open and lock privilege
tables: Can't
find file: './mysql/host.frm' (errno: 13)
110331 19:06:48 mysqld ended

110331 19:19:10 mysqld started
110331 19:19:10 [Warning] option 'max_join_size': unsigned value
184467440737095
51615 adjusted to 4294967295
110331 19:19:10 [Warning] option 'max_join_size': unsigned value
184467440737095
51615 adjusted to 4294967295
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
110331 19:19:10 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
110331 19:19:10 InnoDB: Starting an apply batch of log records to the
database.
...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
19 20 21
22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
46 47 48
49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
72 73 74 7
5 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
110331 19:19:10 InnoDB: Started; log sequence number 0 43655
110331 19:19:10 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find
file: './mys
ql/host.frm' (errno: 13)
110331 19:19:10 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find
file: './mys
ql/host.frm' (errno: 13)
110331 19:19:10 [ERROR] Fatal error: Can't open and lock privilege
tables: Can't
find file: './mysql/host.frm' (errno: 13)
110331 19:19:10 mysqld ended

root@Sun#






SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: tdineen
To: mysql@lists.mysql.com
Subject: [50 character or so descriptive subject here (for reference)]

>Description:
<precise description of the problem (multiple lines)>
>How-To-Repeat:
<code/input/activities to reproduce the problem (multiple lines)>
>Fix:
<how to correct or work around the problem, if known (multiple lines)>

>Submitter-Id: <submitter ID>
>Originator: Owner
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: <synopsis of the problem (one line)>
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release: mysql-5.0.67 (Source distribution)

>C compiler: gcc (GCC) 3.4.6
>C++ compiler: g++ (GCC) 3.4.6
>Environment:
<machine, os, target, libraries (multiple lines)>
System: SunOS Sun5 5.10 Generic_137138-09 i86pc i386 i86pc
Architecture: i86pc

Some paths: /usr/bin/perl /usr/sfw/bin/gmake
/export/home/tools/gcc/usr/local/bin/gcc
/export/home/tools/SolarisStudio12/solstudio12.2/bin/cc
GCC: Reading specs from
/export/home/tools/gcc/usr/local/bin/../lib/gcc/i386-pc-solaris2.10/3.4.6/specs
Configured with: ../configure --with-as=/usr/ccs/bin/as
--with-ld=/usr/ccs/bin/ld --enable-shared --enable-languages=c,c++,f77
Thread model: posix
gcc version 3.4.6
Compilation info (call): CC='/usr/local/bin/gcc' CFLAGS='' CXX='g++'
CXXFLAGS='' LDFLAGS='-fPIC -L/usr/local/lib -R/usr/local/lib -R/usr/lib
-L/usr/lib -R/usr/openwin/lib -L/usr/openwin/lib -L/usr/local/ssl/lib
-R/usr/local/ssl/lib -L/usr/local/BerkeleyDB.4.2/lib
-R/usr/local/BerkeleyDB.4.2/lib -L/usr/X11R6/lib -R/usr/X11R6/lib'
ASFLAGS=''
Compilation info (used): CC='/usr/local/bin/gcc' CFLAGS='-O3
-DDBUG_OFF -DHAVE_RWLOCK_T' CXX='g++' CXXFLAGS='-O3 -DDBUG_OFF
-fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T'
LDFLAGS='-fPIC -L/usr/local/lib -R/usr/local/lib -R/usr/lib -L/usr/lib
-R/usr/openwin/lib -L/usr/openwin/lib -L/usr/local/ssl/lib
-R/usr/local/ssl/lib -L/usr/local/BerkeleyDB.4.2/lib
-R/usr/local/BerkeleyDB.4.2/lib -L/usr/X11R6/lib -R/usr/X11R6/lib '
ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 9 Jan 31 12:43 /lib/libc.so ->
libc.so.1
-rwxr-xr-x 1 root bin 1401932 Oct 3 2008 /lib/libc.so.1
lrwxrwxrwx 1 root root 19 Jan 31 12:39 /usr/lib/libc.so
-> ../../lib/libc.so.1
lrwxrwxrwx 1 root root 19 Jan 31 12:39 /usr/lib/libc.so.1
-> ../../lib/libc.so.1
Configure command: ./configure '--prefix=/usr/local/mysql'
'--with-openssl' 'CC=/usr/local/bin/gcc' 'CPPFLAGS=-I/usr/local/include
-I/usr/X11R6/include -I/usr/local/ssl/include
-I/usr/local/include/ncurses -I/usr/local/BerkeleyDB.4.2/include
-I/usr/openwin/include -I/usr/local/cups/include
-I/usr/local/rrdtool-1.2.19/include -I/usr/local/mysql/include
-I/usr/local/pgsql/include' 'CXX=g++' 'LDFLAGS=-fPIC -L/usr/local/lib
-R/usr/local/lib -R/usr/lib -L/usr/lib -R/usr/openwin/lib
-L/usr/openwin/lib -L/usr/local/ssl/lib -R/usr/local/ssl/lib
-L/usr/local/BerkeleyDB.4.2/lib -R/usr/local/BerkeleyDB.4.2/lib
-L/usr/X11R6/lib -R/usr/X11R6/lib'


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com