List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:April 1 2011 8:20am
Subject:Re: mysql-5.0.67-sol10-x86-local Bug
View as plain text  
Am 01.04.2011 04:28, schrieb Thomas Dineen:
> 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

in a backup since your machine crashed

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

in your datadir in the subfolder mysql

> 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

it is a totally clear path because it depends on your
configuration / distribution where your mysql-datadir
is and ./folder/ is always the database-name

Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
is full qualified database.table

> 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'
> 
> 

-- 

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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