List:General Discussion« Previous MessageNext Message »
From:Thomas Dineen Date:April 1 2011 2:28am
Subject:mysql-5.0.67-sol10-x86-local Bug
View as plain text  
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@stripped
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'

Thread
mysql-5.0.67-sol10-x86-local BugThomas Dineen1 Apr
  • Re: mysql-5.0.67-sol10-x86-local BugReindl Harald1 Apr
    • Re: mysql-5.0.67-sol10-x86-local BugJoerg Bruehe1 Apr