I'm not shure, but i think that at least your read_buffer_size and sort_buffer_size values are too high!
> key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 3415663 K > bytes of memory How much memory does that machine have ? You can modify those values in your mysql configuration file (my.cnf). On Thu, 2003-01-09 at 05:42, [EMAIL PROTECTED] wrote: > >Description: > I installed mysql 4.0.8 from RPMs on a machine running RedHat 7.3 > (fresh install. I did not install the mysql rpms that come with RH 7.3) > mysql ran for a while (few hours) and then started to crash in very fast > cycles (about 1/sec) > This mysql instance is a slave for a 3.23.53a-Max server. Has at > this point almost no other queries but data transfer to setup the slave > (e.g. load table from master...) > >How-To-Repeat: > whenever I start mysql using 'service mysql start', it will crash > immidiatly. > > error log: > > 030109 00:18:31 mysqld restarted > 030109 0:18:31 InnoDB: Started > /usr/sbin/mysqld: ready for connections > 030109 0:18:31 Slave I/O thread: connected to master 'repl@host:3306', >replication started in log 'host-bin.003' at position 84914753 > 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=209715200 > read_buffer_size=209711104 > sort_buffer_size=209715192 > max_used_connections=0 > max_connections=100 > threads_connected=0 > It is possible that mysqld could use up to > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 3415663 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > thd=0x873a3a8 > 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=0xbfe5f2b8, backtrace may not be correct. > Stack range sanity check OK, backtrace follows: > 0x807328a > 0x82834b8 > 0x80b36ce > 0x80b408e > 0x80ecaa1 > 0x80edb61 > 0x8280c6c > 0x82b620a > New value of fp=(nil) failed sanity check, terminating stack trace! > Please read http://www.mysql.com/doc/U/s/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 (nil) is invalid pointer > thd->thread_id=2 > > Successfully dumped variables, if you ran with --log, take a look at the > details of what thread 2 did to cause the crash. In some cases of really > bad corruption, the values shown above may be invalid. > > The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains > information that should help you find out what is causing the crash. > > Number of processes running now: 0 > 030109 00:18:33 mysqld restarted > > > > > >Fix: > sorry. no fix at this point. > > >Submitter-Id: <submitter ID> > >Originator: root > >Organization: > SANS Inst. > >MySQL support: [none | licence | email support | extended email support ] > >Synopsis: mysql 4.0.8 crashes > >Severity: critical > >Priority: high > >Category: mysql > >Class: sw-bug > >Release: mysql-4.0.8-gamma (Official MySQL RPM) > > >C compiler: 2.95.3 > >C++ compiler: 2.95.3 > >Environment: > RedHat 7.3 , dual 1 GHz P-III, 4 GByte RAM > System: Linux hostname 2.4.18-3smp #1 SMP Thu Apr 18 07:27:31 EDT 2002 i686 unknown > Architecture: i686 > > 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.96/specs > gcc version 2.96 20000731 (Red Hat Linux 7.3 2.96-110) > Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' >CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors >-fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' > LIBC: > lrwxrwxrwx 1 root root 13 Jan 7 10:56 /lib/libc.so.6 -> >libc-2.2.5.so > -rwxr-xr-x 1 root root 1260480 Apr 15 2002 /lib/libc-2.2.5.so > -rw-r--r-- 1 root root 2310808 Apr 15 2002 /usr/lib/libc.a > -rw-r--r-- 1 root root 178 Apr 15 2002 /usr/lib/libc.so > Configure command: ./configure '--disable-shared' >'--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' >'--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' >'--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' >'--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' >'--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' >'--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' >'--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' >'--with-embedded-server' '--enable-thread-safe-client' '--with-comment=Official MySQL >RPM' 'CC=gcc' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 >-fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti >-mpentium' 'CXX=gcc' > -- Diana Soares --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
