From: Reindl Harald Date: April 1 2011 8:20am Subject: Re: mysql-5.0.67-sol10-x86-local Bug List-Archive: http://lists.mysql.com/mysql/224744 Message-Id: <4D958AC1.40806@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig9B46DDA2D7EFAB27A5E4B12E" --------------enig9B46DDA2D7EFAB27A5E4B12E Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Am 01.04.2011 04:28, schrieb Thomas Dineen: > Gentle People: >=20 > 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 fil= e: './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' doe= sn't exist is full qualified database.table > Thomas Dineen >=20 >=20 > 110331 18:40:10 mysqld started > 110331 18:40:10 [Warning] option 'max_join_size': unsigned value 184467= 440737095 > 51615 adjusted to 4294967295 > 110331 18:40:10 [Warning] option 'max_join_size': unsigned value 184467= 440737095 > 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 7= 2 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 tabl= es: Table > 'mysql.host' doesn't exist > 110331 18:40:11 mysqld ended >=20 > 110331 18:49:41 mysqld started > 110331 18:49:41 [Warning] option 'max_join_size': unsigned value 184467= 440737095 > 51615 adjusted to 4294967295 > 110331 18:49:41 [Warning] option 'max_join_size': unsigned value 184467= 440737095 > 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 7= 2 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 fil= e: './mys > ql/host.frm' (errno: 13) > 110331 18:49:41 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find fil= e: './mys > ql/host.frm' (errno: 13) > 110331 18:49:41 [ERROR] Fatal error: Can't open and lock privilege tabl= es: Can't > find file: './mysql/host.frm' (errno: 13) > 110331 18:49:41 mysqld ended >=20 > 110331 19:06:48 mysqld started > 110331 19:06:48 [Warning] option 'max_join_size': unsigned value 184467= 440737095 > 51615 adjusted to 4294967295 > 110331 19:06:48 [Warning] option 'max_join_size': unsigned value 184467= 440737095 > 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 7= 2 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 fil= e: './mys > ql/host.frm' (errno: 13) > 110331 19:06:48 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find fil= e: './mys > ql/host.frm' (errno: 13) > 110331 19:06:48 [ERROR] Fatal error: Can't open and lock privilege tabl= es: Can't > find file: './mysql/host.frm' (errno: 13) > 110331 19:06:48 mysqld ended >=20 > 110331 19:19:10 mysqld started > 110331 19:19:10 [Warning] option 'max_join_size': unsigned value 184467= 440737095 > 51615 adjusted to 4294967295 > 110331 19:19:10 [Warning] option 'max_join_size': unsigned value 184467= 440737095 > 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 7= 2 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 fil= e: './mys > ql/host.frm' (errno: 13) > 110331 19:19:10 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find fil= e: './mys > ql/host.frm' (errno: 13) > 110331 19:19:10 [ERROR] Fatal error: Can't open and lock privilege tabl= es: Can't > find file: './mysql/host.frm' (errno: 13) > 110331 19:19:10 mysqld ended >=20 > root@Sun# >=20 >=20 >=20 >=20 >=20 >=20 > SEND-PR: -*- send-pr -*- > SEND-PR: Lines starting with `SEND-PR' will be removed automatically, a= s > 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)] >=20 >>Description: > >>How-To-Repeat: > >>Fix: > >=20 >>Submitter-Id: >>Originator: Owner >>Organization: > >>MySQL support: [none | licence | email support | extended email support= ] >>Synopsis: >>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) >=20 >>C compiler: gcc (GCC) 3.4.6 >>C++ compiler: g++ (GCC) 3.4.6 >>Environment: > > System: SunOS Sun5 5.10 Generic_137138-09 i86pc i386 i86pc > Architecture: i86pc >=20 > Some paths: /usr/bin/perl /usr/sfw/bin/gmake /export/home/tools/gcc/us= r/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=3D/usr/ccs/bin/as --with-ld=3D/= usr/ccs/bin/ld --enable-shared > --enable-languages=3Dc,c++,f77 > Thread model: posix > gcc version 3.4.6 > Compilation info (call): CC=3D'/usr/local/bin/gcc' CFLAGS=3D'' CXX=3D= 'g++' CXXFLAGS=3D'' LDFLAGS=3D'-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/Berke= leyDB.4.2/lib -L/usr/X11R6/lib > -R/usr/X11R6/lib' ASFLAGS=3D'' > Compilation info (used): CC=3D'/usr/local/bin/gcc' CFLAGS=3D'-O3 -DDBU= G_OFF -DHAVE_RWLOCK_T' CXX=3D'g++'=20 > CXXFLAGS=3D'-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -= fno-rtti -DHAVE_RWLOCK_T' LDFLAGS=3D'-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/Berke= leyDB.4.2/lib -L/usr/X11R6/lib > -R/usr/X11R6/lib ' ASFLAGS=3D'' > LIBC: > lrwxrwxrwx 1 root root 9 Jan 31 12:43 /lib/libc.so -> l= ibc.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=3D/usr/local/mysql' '--with-op= enssl' 'CC=3D/usr/local/bin/gcc' > 'CPPFLAGS=3D-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/l= ocal/pgsql/include' 'CXX=3Dg++' 'LDFLAGS=3D-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/Berke= leyDB.4.2/lib -L/usr/X11R6/lib > -R/usr/X11R6/lib' >=20 >=20 --=20 Mit besten Gr=FC=DFen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofm=FChlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ --------------enig9B46DDA2D7EFAB27A5E4B12E Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk2VisEACgkQhmBjz394AnlQkgCdG9ZWWRhZMUUOQ4uVNqNqSIdj ZukAoIwBWzrp23JOcWVhpqDqD7UoOyr2 =pO9t -----END PGP SIGNATURE----- --------------enig9B46DDA2D7EFAB27A5E4B12E--