mysql-5.0.67-sol10-x86-local Bug

Re: mysql-5.0.67-sol10-x86-local Bug

--------------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@lists.mysql.com
> 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üß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/


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

iEYEARECAAYFAk2VisEACgkQhmBjz394AnlQkgCdG9ZWWRhZMUUOQ4uVNqNq SIdj
ZukAoIwBWzrp23JOcWVhpqDqD7UoOyr2
=pO9t
-----END PGP SIGNATURE-----

--------------enig9B46DDA2D7EFAB27A5E4B12E--