Bug in the installation of MySQL 4.1.4
am 02.09.2004 10:57:26 von Bertrand Lanneau------=_NextPart_000_0159_01C490DB.A1F78F90
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_015A_01C490DB.A1F78F90"
------=_NextPart_001_015A_01C490DB.A1F78F90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Just to mention a bug. I have a workaround and it is thus not a problem=20
for me, but i hope it can help.
I've a crash when i tried to install MySQL 4.1.4 from the rpm on Linux =
(RedHat 8).
Before the install, i only wrote my config file (my.cnf in attachment), =
and the
command rpm -i MySQL-server-4.1.4-0.i386.rpm crashed with the error =
messages
that are following.
Everything works fine if i remove my config file, install, stop the =
server, put my
config file again and restart.
I tracked a little more and find that the problem was caused by the line =
default-table-type=3Dinnodb
in my config file. If i comment just this line, everything works fine.
Bertrand Lanneau.
warning: MySQL-server-4.1.4-0.i386.rpm: V3 DSA signature: NOKEY, key ID =
5072e1f5
040902 10:26:45 [ERROR] Warning: Asked for 196608 thread stack, but got =
126976
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this =
binary
or one of the libraries it was linked against is corrupt, improperly =
built,
or misconfigured. This error can also be caused by malfunctioning =
hardware.
We will try our best to scrape up some info that will hopefully help =
diagnose
the problem, but since we have already crashed, something is definitely =
wrong
and this may fail.
key_buffer_size=3D8388600
read_buffer_size=3D131072
max_used_connections=3D0
max_connections=3D100
threads_connected=3D1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
=3D 225791 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=3D0x85a3288
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=3D0xbff5e118, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x808c817
0x82de458
0x82dc66c
0x81dd7aa
0x80fdbba
0x810176a
0x80f8783
0x80eba72
0x8107661
0x809cc13
0x80a05f9
0x809a060
0x82dbc0c
0x830519a
New value of fp=3D(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/en/Using_stack_trace.html and =
follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x85b3250 =3D CREATE TABLE host ( Host char(60) binary =
DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, =
Select_priv enum('N','Y') DEFAULT 'N' NOT NULL, Insert_priv =
enum('N','Y') DEFAULT 'N' NOT NULL, Update_priv enum('N','Y') DEFAULT =
'N' NOT NULL, Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL, =
Create_priv enum('N','Y') DEFAULT 'N' NOT NULL, Drop_priv enum('N','Y') =
DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL, =
References_priv enum('N','Y') DEFAULT 'N' NOT NULL, Index_priv =
enum('N','Y') DEFAULT 'N' NOT NULL, Alter_priv enum('N','Y') DEFAULT =
'N' NOT NULL, Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL, =
Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL, PRIMARY KEY Host =
(Host,Db) ) comment=3D'Host privileges; Merged with database =
privileges'
thd->thread_id=3D1
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
Installation of system tables failed!
------=_NextPart_001_015A_01C490DB.A1F78F90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
charset=3Diso-8859-1">
workaround and=20
it is thus not a problem
help.
MySQL 4.1.4=20
from the rpm on Linux (RedHat 8).
config file=20
(my.cnf in attachment), and the
MySQL-server-4.1.4-0.i386.rpm =20
crashed with the error messages
config file,=20
install, stop the server, put my
restart.
the problem=20
was caused by the line
in my =
config file. If=20
i comment just this line, everything works fine.
V3 DSA=20
signature: NOKEY, key ID 5072e1f5
040902 10:26:45 [ERROR] =
Warning:=20
Asked for 196608 thread stack, but got 126976
mysqld got signal =
11;
This=20
could be because you hit a bug. It is also possible that this =
binary
or one=20
of the libraries it was linked against is corrupt, improperly =
built,
or=20
misconfigured. This error can also be caused by malfunctioning =
hardware.
We=20
will try our best to scrape up some info that will hopefully help=20
diagnose
the problem, but since we have already crashed, something is =
definitely wrong
and this may fail.
read_buffer_size=3D131072
max_us=
ed_connections=3D0
max_connections=3D100
threads_connected=3D1
I=
t=20
is possible that mysqld could use up to
key_buffer_size + =
(read_buffer_size +=20
sort_buffer_size)*max_connections =3D 225791 K
bytes of =
memory
Hope that's=20
ok; if not, decrease some variables in the equation.
Attempting =
backtrace. You can use=20
the following information to find out
where mysqld died. If you see =
no=20
messages after this, something went
terribly wrong...
Cannot =
determine=20
thread, fp=3D0xbff5e118, backtrace may not be correct.
Stack range =
sanity check=20
OK, backtrace=20
follows:
0x808c817
0x82de458
0x82dc66c
0x81dd7aa
0x80fdbba=
0x810176a
0x80f8783
0x80eba72
0x8107661
0x809cc13
0x80=
a05f9
0x809a060
0x82dbc0c
0x830519a
New=20
value of fp=3D(nil) failed sanity check, terminating stack =
trace!
Please read=20
sql.com/doc/en/Using_stack_trace.html=20
and follow instructions on how to resolve the stack trace. =
Resolved
stack=20
trace is much more helpful in diagnosing the problem, so please =
do
resolve=20
it
Trying to get some variables.
Some pointers may be invalid and =
cause=20
the dump to abort...
thd->query at 0x85b3250 =3D CREATE =
TABLE host=20
( Host char(60) binary DEFAULT '' NOT NULL, Db char(64) =
binary=20
DEFAULT '' NOT NULL, Select_priv enum('N','Y') DEFAULT 'N' NOT =
NULL, =20
Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL, Update_priv =
enum('N','Y')=20
DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y') DEFAULT 'N' NOT=20
NULL, Create_priv enum('N','Y') DEFAULT 'N' NOT NULL, =
Drop_priv=20
enum('N','Y') DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y') =
DEFAULT 'N'=20
NOT NULL, References_priv enum('N','Y') DEFAULT 'N' NOT =
NULL, =20
Index_priv enum('N','Y') DEFAULT 'N' NOT NULL, Alter_priv =
enum('N','Y')=20
DEFAULT 'N' NOT NULL, Create_tmp_table_priv enum('N','Y') DEFAULT =
'N' NOT=20
NULL, Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL, =
PRIMARY=20
KEY Host (Host,Db) ) comment=3D'Host privileges; Merged with =
database=20
privileges'
thd->thread_id=3D1
The manual page at
oc/en/Crashing.html=20
contains
information that should help you find out what is causing =
the=20
crash.
Installation of system tables failed!
------=_NextPart_001_015A_01C490DB.A1F78F90--
------=_NextPart_000_0159_01C490DB.A1F78F90
Content-Type: text/plain; charset=us-ascii
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
------=_NextPart_000_0159_01C490DB.A1F78F90--