Re: Crash on replace

[Miguel Angel Solórzano]

At 17:50 02/08/2001 +0200, monika@stripped wrote:
Hi,

I was be able to repeat your bug report. Thanks and it
will be fixed.

Regards,
Miguel

> >Description:
>
> >How-To-Repeat:
>I try the following:
>
>         mysql> create table foo (primary key (aaa), unique(bbb), aaa 
> varchar(20) not null, bbb varchar(20)) type=bdb;
>         Query OK, 0 rows affected (0.76 sec)
>
>         mysql> replace into foo set aaa="alfa", bbb="beta";
>         Query OK, 1 row affected (0.02 sec)
>
>         mysql> replace into foo set aaa="alfa", bbb="beta";
>         ERROR 2013: Lost connection to MySQL server during query
>
>and also the message
>
>         010802 16:27:09  mysqld restarted
>
>
>
>I might have done anything wrong (I'm no mySQL expert) - so if there
>is something I've missed, I hope to pe pointed in the right
>direction.
>
>The last entry in the error log is
>
>         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=8388600
>         record_buffer=131072
>         sort_buffer=2097144
>         max_used_connections=0
>         max_connections=100
>         threads_connected=1
>         It is possible that mysqld could use up to
>         key_buffer_size + (record_buffer + sort_buffer)*max_connections = 
> 225791 K
>         bytes of memory
>         Hope that's ok, if not, decrease some variables in the equation
>
>         010802 17:38:00  mysqld restarted
>         Can't initialize InnoDB as 'innodb_data_file_path' is not set
>         /isk/mysql-max-3.23.39-sun-solaris2.7-sparc/bin/mysqld: ready for 
> connections
>
> >Fix:
>
>
> >Submitter-Id:  Monika Danielsson (monika@stripped)
> >Originator:    System Operator
> >Organization:
>
> >MySQL support: [none  ]
> >Synopsis:      replace query (replacing already inserted row) gives crash
> >Severity:
> >Priority:
> >Category:      mysql
> >Class:
> >Release:       mysql-3.23.39-max (Official MySQL-max binary)
>
> >Environment:
>
>System: SunOS orion 5.8 Generic_108528-08 sun4u sparc SUNW,Ultra-5_10
>Architecture: sun4
>
>Some paths:  /usr/local/bin/perl /opt/local/gnu/bin/gmake /opt/SUNWspro/bin/cc
>
>Compilation info: CC='gcc'  CFLAGS='-O3 
>-fno-omit-frame-pointer'  CXX='gcc'  CXXFLAGS='-O3 -fno-omit-frame-pointer 
>-felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
>LIBC:
>-rw-r--r--   1 root     bin      1759264 Jul 11 05:02 /lib/libc.a
>lrwxrwxrwx   1 root     root          11 Jul 12 11:46 /lib/libc.so -> 
>./libc.so.1
>-rwxr-xr-x   1 root     bin      1136692 Jul 11 05:02 /lib/libc.so.1
>-rw-r--r--   1 root     bin      1759264 Jul 11 05:02 /usr/lib/libc.a
>lrwxrwxrwx   1 root     root          11 Jul 12 11:46 /usr/lib/libc.so -> 
>./libc.so.1
>-rwxr-xr-x   1 root     bin      1136692 Jul 11 05:02 /usr/lib/libc.so.1
>Configure command: ./configure  --prefix=/usr/local/mysql 
>'--with-comment=Official MySQL-max binary' --with-extra-charsets=complex 
>--with-server-suffix=-max --enable-assembler --disable-shared 
>--with-berkeley-db --with-innodb
>
>
>---------------------------------------------------------------------
>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 <mysql-thread81422@stripped>
>To unsubscribe, e-mail 
><mysql-unsubscribe-solorzano=intermol.com.br@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
For technical support contracts, goto https://order.mysql.com/
    __  ___     ___ ____  __
   /  |/  /_ __/ __/ __ \/ /    Miguel A. Solórzano <miguel@stripped>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
        <___/   www.mysql.com