Subject: Re: mysqld got signal 11 ?
To: =?Windows-1252?Q?Jonas_Lind=E9n?= <jonas.linden.7469@student.uu.se>
From: Douwe Kiela <virtus@wanadoo.nl>
List: netbsd-users
Date: 05/08/2003 22:25:36
This is a multi-part message in MIME format.

------=_NextPart_000_00BD_01C315B0.BF7BE0E0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

MeddelandeIn the configuration file, make MySQL log error messages to =
/var/log/mysql-errors or something and check if it says anything. It =
could be missing InnoDB stuff.
In the case of a hardware problem, you have more than 225791 K of =
memory?

Regards,
Douwe
  ----- Original Message -----=20
  From: Jonas Lind=E9n=20
  To: netbsd-users@netbsd.org=20
  Sent: Wednesday, May 07, 2003 7:01 PM
  Subject: mysqld got signal 11 ?


  Hello, has someone on the list had any problems installing =
mysql-server from pkgsrc?  I have been working on this for three weeks =
now I cant figure out what I am doing wrong (or if the pkg is broken?). =
To me it seems like the grant tables isnt installed properly. Does =
someone know if one could install the grant tables by hand afterwards? I =
have tried starting the server without grant tables (--skip-grant) but I =
still get "mysqld got signal 11" error and the server refuses to start. =
Anyone encounterd a similar problem? and solved it;). I include the =
error msg from the pkgsrc installation.=20
  =20
  /Jonas=20
  =20
  Initializing MySQL databases...
  -------------------------------
  Preparing db table
  Preparing host table
  Preparing user table
  Preparing func table
  Preparing tables_priv table
  Preparing columns_priv table
  Installing all prepared tables
  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 agaist 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
  record_buffer=3D131072
  sort_buffer=3D2097144
  max_used_connections=3D0
  max_connections=3D100
  threads_connected=3D0
  It is possible that mysqld could use up to=20
  key_buffer_size + (record_buffer + sort_buffer)*max_connections =3D =
225791 K
  bytes of memory
  Hope that's ok, if not, decrease some variables in the equation

  Installation of grant tables failed!

  =20

------=_NextPart_000_00BD_01C315B0.BF7BE0E0
Content-Type: text/html;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Meddelande</TITLE>
<META content=3D"text/html; charset=3DWindows-1252" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>In the configuration file, make MySQL =
log error=20
messages to /var/log/mysql-errors or something and check if it says =
anything. It=20
could be missing InnoDB stuff.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>In the case of a hardware problem, you =
have more=20
than 225791 K of memory?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Douwe</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
  <A href=3D"mailto:jonas.linden.7469@student.uu.se"=20
  title=3Djonas.linden.7469@student.uu.se>Jonas Lind=E9n</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
  href=3D"mailto:netbsd-users@netbsd.org"=20
  title=3Dnetbsd-users@netbsd.org>netbsd-users@netbsd.org</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Wednesday, May 07, 2003 =
7:01=20
  PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> mysqld got signal 11 =
?</DIV>
  <DIV><BR></DIV>
  <DIV><FONT face=3DArial size=3D2><SPAN =
class=3D765465116-07052003>Hello, has someone=20
  on the list had any problems installing mysql-server from =
pkgsrc?&nbsp; I have=20
  been working on this for three weeks now I cant figure out what I am =
doing=20
  wrong (or if the pkg is broken?). To me it seems like the grant tables =

  isnt&nbsp;installed properly. Does someone know if one could install =
the grant=20
  tables by hand afterwards? I have tried starting the server without =
grant=20
  tables (--skip-grant) but I still get "mysqld got signal 11" error and =
the=20
  server refuses to start. Anyone encounterd&nbsp;a similar problem? and =
solved=20
  it;). I include the error msg from the pkgsrc=20
  installation.&nbsp;</SPAN></FONT></DIV>
  <DIV><FONT face=3DArial size=3D2><SPAN=20
  class=3D765465116-07052003></SPAN></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2><SPAN=20
  class=3D765465116-07052003>/Jonas&nbsp;</SPAN></FONT></DIV>
  <DIV><FONT face=3DArial size=3D2><SPAN=20
  class=3D765465116-07052003></SPAN></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2><SPAN =
class=3D765465116-07052003>Initializing MySQL=20
  databases...<BR>-------------------------------<BR>Preparing db=20
  table<BR>Preparing host table<BR>Preparing user table<BR>Preparing =
func=20
  table<BR>Preparing tables_priv table<BR>Preparing columns_priv=20
  table<BR>Installing all prepared tables<BR>mysqld got signal =
11;<BR>This could=20
  be because you hit a bug. It is also possible that this binary<BR>or =
one of=20
  the libraries it was linked agaist is corrupt, improperly built,<BR>or =

  misconfigured. This error can also be caused by malfunctioning =
hardware.<BR>We=20
  will try our best to scrape up some info that will hopefully help=20
  diagnose<BR>the problem, but since we have already crashed, something =
is=20
  definitely wrong<BR>and this may fail</SPAN></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2><SPAN=20
  =
class=3D765465116-07052003>key_buffer_size=3D8388600<BR>record_buffer=3D1=
31072<BR>sort_buffer=3D2097144<BR>max_used_connections=3D0<BR>max_connect=
ions=3D100<BR>threads_connected=3D0<BR>It=20
  is possible that mysqld could use up to <BR>key_buffer_size + =
(record_buffer +=20
  sort_buffer)*max_connections =3D 225791 K<BR>bytes of memory<BR>Hope =
that's ok,=20
  if not, decrease some variables in the equation</SPAN></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2><SPAN =
class=3D765465116-07052003>Installation of=20
  grant tables failed!</SPAN></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2><SPAN=20
  =
class=3D765465116-07052003></SPAN></FONT>&nbsp;</DIV></BLOCKQUOTE></BODY>=
</HTML>

------=_NextPart_000_00BD_01C315B0.BF7BE0E0--