>Description: MySQL Crashes with BDB Tables and replace into in some cases >How-To-Repeat: mysql> create table test (sessionid varchar(80) not null primary key, sessionval blob, lastopen timestamp not null) type=bdb; Query OK, 0 rows affected (0.88 sec) mysql> alter table test add index(lastopen); Query OK, 0 rows affected (1.50 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> replace into test values ("asdf","asdf",now()); Query OK, 1 row affected (0.06 sec) mysql> replace into test values ("asdf","asdf",now()); ERROR 2013: Lost connection to MySQL server during query Problem persists with MySQL 3.23.39. >Fix: When Using MyISAM instead there is no such problem >Submitter-Id: <submitter ID> >Originator: Thomas Stinner >Organization: billiton internet services GmbH > >MySQL support: none >Synopsis: MySQL CRASH with BDB - Tables and replace into >Severity: critical >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-3.23.36 (Source distribution) >Server: ./mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.36-log Protocol version 10 Connection roedgen2.stinnux.de via TCP/IP TCP port 3306 Uptime: 15 min 5 sec Threads: 1 Questions: 2 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.002 >Environment: System: Linux krusty 2.4.3 #3 SMP Sat May 12 21:28:15 CEST 2001 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/i486-suse-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rwxr-xr-x 1 root root 4070406 Jul 30 2000 /lib/libc.so.6 -rw-r--r-- 1 root root 19185232 Jul 30 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jul 30 2000 /usr/lib/libc.so -rw-r--r-- 1 root root 2032004 Jul 29 2000 /usr/lib/libc-client.a lrwxrwxrwx 1 root root 20 Feb 19 2000 /usr/lib/libc-client.so -> ./libc-client.so.4.7 -rwxr-xr-x 1 root root 668784 Jul 29 2000 /usr/lib/libc-client.so.4.7 Configure command: ./configure --prefix=/opt/mysql --without-bench --without-docs --with-extra-charsets=latin1,german1 --with-charset=german1 --with-berkeley-db --with-innobase --enable-assembler --with-mysqld-user=mysql --enable-thread-safe-client Perl: This is perl, version 5.005_03 built for i586-linux --------------------------------------------------------------------- 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