List:General Discussion« Previous MessageNext Message »
From:Eric Z. Ayers Date:September 1 1999 8:20pm
Subject:Mysql 3-22.25-1 crashes on restart
View as plain text  
>Description:
  This is a Red Hat 5.2 installation.  It has glibc 2.0.7-29 on it.

  The daemon comes up after we first install it, but then, after running for a 
  while and trying to restart the server, it crashes.  here is a stack trace:


  (gdb) run --user=mysql --pid-file=/tmp/baloney.pid --datadir=/var/lib/mysql --one-thread
                        
  Starting program: /usr/sbin/mysqld --user=mysql --pid-file=/tmp/baloney.pid
--datadir=/var/lib/mysql --one-thread
  [New Thread 29495]
  [New Thread 29494]
  [New Thread 29496]

  Program received signal SIGSEGV, Segmentation fault.
  0x811f9ef in calc_hashnr (key=0xa5a5a5a5 <Address 0xa5a5a5a5 out of bounds>, 
    length=2779096484) at hash.c:116
  116         nr^= (((nr & 63)+nr2)*((uint) (uchar) *key++))+ (nr << 8);
  (gdb) print key
  $1 = 0xa5a5a5a5 <Address 0xa5a5a5a5 out of bounds>
  (gdb) where
  #0  0x811f9ef in calc_hashnr (key=0xa5a5a5a5 <Address 0xa5a5a5a5 out of bounds>, 
    length=2779096484) at hash.c:116
  #1  0x811fa99 in rec_hashnr (hash=0x8199860, record=0x81a2080
"¥¥¥¥à \032\bè \032\b")
    at hash.c:140
  #2  0x812000a in hash_insert (info=0x8199860, record=0x81a2080
"¥¥¥¥à \032\bè \032\b")
    at hash.c:334
  #3  0x80e3943 in grant_init () at sql_acl.cc:1829
  #4  0x80a7866 in main (argc=5, argv=0x819aadc) at mysqld.cc:1176
  (gdb) 
  #0  0x811f9ef in calc_hashnr (key=0xa5a5a5a5 <Address 0xa5a5a5a5 out of bounds>, 
    length=2779096484) at hash.c:116
  #1  0x811fa99 in rec_hashnr (hash=0x8199860, record=0x81a2080
"¥¥¥¥à \032\bè \032\b")
    at hash.c:140
  #2  0x812000a in hash_insert (info=0x8199860, record=0x81a2080
"¥¥¥¥à \032\bè \032\b")
    at hash.c:334
  #3  0x80e3943 in grant_init () at sql_acl.cc:1829
  #4  0x80a7866 in main (argc=5, argv=0x819aadc) at mysqld.cc:1176

  I have a /tmp/mysqld.trace file, but it doesn't look very useful
  to me.  If you want it, email me eric@stripped
  
  Note, that if we use the --skip-grant-tables command, we seem to get past this 
problem.

  (gdb) run --user=mysql --pid-file=/tmp/baloney.pid --datadir=/var/lib/mysql --one-thread
  --skip-grant-tables
  The program being debugged has been started already.
  Start it from the beginning? (y or n) y
  Starting program: /usr/sbin/mysqld --user=mysql --pid-file=/tmp/baloney.pid
--datadir=/var/lib/mysql --one-thread   --skip-grant-tables
  [New Thread 29503]
  [New Thread 29502]
  [New Thread 29504]
  /usr/sbin/mysqld: ready for connections
	
>How-To-Repeat:
	install mysql 3.22.25, create some dbs, then restart the server
>Fix:
	a workaround is to use the --skip-grant-table option

>Submitter-Id:	eric.ayers@stripped
>Originator:	
>Organization:
 <organization of PR author (multiple lines)>
>MySQL support: none 
>Synopsis:	
>Severity:	serious
>Priority:	high
>Category:	mysql
>Class:		sw-bug
>Release:	mysql-3.22.25 (Source distribution)
>Server: /usr/bin/mysqladmin  Ver 7.11 Distrib 3.22.25, for pc-linux-gnu on i586
TCX Datakonsult AB, by Monty

Server version		3.22.25-debug
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/var/lib/mysql/mysql.sock
Uptime:			2 min 16 sec

Threads: 2  Questions: 17  Slow queries: 0  Opens: 6  Flush tables: 1  Open tables: 6 
Memory in use: 8308K  Max memory used: 8324K
>Environment:
	<machine, os, target, libraries (multiple lines)>
System: Linux tuna.compgen.com 2.0.36 #1 Tue Oct 13 22:17:11 EDT 1998 i586 unknown
Architecture: i586

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.7.2.3/specs
gcc version 2.7.2.3
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
Configure command: ./configure  --enable-shared --enable-assembler --with-debug
--with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include
--mandir=/usr/man
Perl: This is perl, version 5.004_05 built for i386-linux
Thread
Mysql 3-22.25-1 crashes on restartEric Z. Ayers2 Sep
  • Mysql 3-22.25-1 crashes on restartJani Tolonen2 Sep
  • Re: Mysql 3-22.25-1 crashes on restartsinisa2 Sep
  • Re: [BUG] CONCAT_WS + GROUP BY display problemMichael Widenius17 May
Re: Mysql 3-22.25-1 crashes on restartEric Z. Ayers3 Sep
  • Re: Mysql 3-22.25-1 crashes on restartMichael Widenius7 Sep