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@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' > > -- 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/
signature.asc
Description: OpenPGP digital signature
