>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
