[EMAIL PROTECTED] writes:
> Hi folks, I'm having a hard time using bdb tables. Here are the
> details...
>
> I've create a few BDB tables, which are causing me great amounts
> of grief. The tables worked fine for a while, then suddenly
> started crashing mysqld. I decided to drop the offending
> database, and re-create it. No problem so far. Right after
> I run the offending queries (see below), mysqld dies. Any subsequent
> connection attempt to mysqld hangs, and the server is basically
> dead (requiring a killall -9 mysqld). There is a file called
> log.0000000001 that appeared, as well as an error message (see below).
>
> I can replicate this error quite easily, as it happens each time the
> query
> is run.
>
>
> CREATE TABLE tblCharge (
> ChargeID int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
> ServiceID int(10) unsigned DEFAULT '0' NOT NULL,
> ChargeDate date DEFAULT '0000-00-00' NOT NULL,
> ChargeAmount decimal(20,2) DEFAULT '0.00' NOT NULL,
> FedTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
> ProvTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
> ChargeStatus enum('New','Auth','Unauth','Sale','Denied','Refund')
> DEFAULT 'New' NOT NULL,
> ChargeAuthorizationMessage text,
> ChargeComment text,
> ChargeTimeStamp varchar(20),
> PRIMARY KEY (ChargeID),
> KEY ServiceID (ServiceID),
> KEY ChargeDate (ChargeDate)
> ) type=BDB;
>
>
>
> Query #1:
> BEGIN;
> INSERT INTO tblCharge
> VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
> COMMIT;
>
> Query #2
> BEGIN;
> UPDATE tblCharge SET ChargeAuthorizationMessage = 'blablabla' WHERE
> ChargeID = 1;
> COMMIT;
>
> Query #3
> BEGIN;
> INSERT INTO tblCharge
> VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
>
> <CRASH HERE>
>
> ERROR 2013: Lost connection to MySQL server during query
> mysql> COMMIT;
> Number of processes running now: 0
> 010228 13:59:40 mysqld restarted
>
> ERROR 2006: MySQL server has gone away
> No connection. Trying to reconnect...
> Connection id: 4
> Current database: Funio
>
> ./mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var \
> --user=root --pid-file=/usr/local/mysql/var/suave.pid --skip-locking
> ./mysqld: ready for connections
> mysqld got signal 11;
> The manual section 'Debugging a MySQL server' tells you how to use a
> stack trace and/or the core file to produce a readable backtrace that
> may
> help in finding out why mysqld died
> Attemping backtrace. You can use the following information to find out
> where mysqld died. If you see no messages after this, something went
> terribly wrong
>
>
> I've replicated this problem on 3 different machines, and on 3.23.33 and
> 3.23.32.
> I had been using BDB tables for a couple weeks now in testing, without a
> hitch
> until the above query starting being used. I also tried to recompile
> mysql
> statically, with the same results.
>
> I really hope there is an easy patch/fix to this problem, as my
> development
> team has just finished writing 15000 lines of code and use DBD tables
> extensively throughout the application. My company has purchased a
> basic license for mysql, and quite frankly this error really concerns
> me.
>
> If it was this easy to crash BDB tables and there is no quick fix, I
> will
> have to stop using mysql altogether throughout my company. We rely
> heavily
> on mysql right now, and this kind of error makes me wonder if this is
> not a
> mistake. Until a solution can be found, I will instruct my team to
> start porting the application to postgres, I simply can't take the
> chance of using these versions of mysql in production.
>
>
>
>
> Description:
> BDB tables crash very easily
> How-To-Repeat:
> See above
> Fix:
> no idea
>
> Originator: Mark Steele
> Organization:
> Mark Steele
> Vice president research and development
> Inet Technologies Inc.
> [EMAIL PROTECTED]
>
> MySQL support: [email support]
> Synopsis: BDB tables crash
> Severity: <critical>
> Priority: <high>
> Category: mysql
> Class: <sw-bug>
> Release: mysql-3.23.32 (Source distribution)
> Server: /usr/local/mysql/bin/mysqladmin Ver 8.14 Distrib 3.23.32, 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.32
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /tmp/mysql.sock
> Uptime: 1 min 12 sec
>
> Threads: 1 Questions: 61 Slow queries: 0 Opens: 48 Flush tables: 1
> Open tables: 42 Queries per second avg: 0.847
> Environment:
> System: Linux suave 2.4.1 #11 Sat Feb 17 00:30:04 EST 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/i386-slackware-linux/2.95.2/specs
> gcc version 2.95.2 19991024 (release)
> Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS=''
> LDFLAGS=''
> LIBC:
> lrwxrwxrwx 1 root root 13 Feb 16 20:43 /lib/libc.so.6 ->
> libc-2.2.1.so
> -rwxr-xr-x 1 root root 1008844 Sep 9 1999
> /lib/libc-2.1.2.so
> -rwxr-xr-x 1 root root 4135126 May 29 2000
> /lib/libc-2.1.3.so
> -rwxr-xr-x 1 root root 1128904 Jan 14 10:29
> /lib/libc-2.2.1.so
> -rwxr-xr-x 1 root root 4808643 Nov 20 17:11 /lib/libc-2.2.so
> -rw-r--r-- 1 root root 24076056 Nov 20 17:07 /usr/lib/libc.a
> -rw-r--r-- 1 root root 178 Nov 20 17:07 /usr/lib/libc.so
> Configure command: ./configure
> --prefix=/usr/local/mysql
>
>
> Regards,
>
> --
> Mark Steele
> Vice president research and development
> Inet Technologies Inc.
> [EMAIL PROTECTED]
>
>
>010110010110111101110101001000000110000101110010011001010010000001100100011101010110110101100010
>
Hi!
I will test this , although on 2.2 kernel.
And please when you write to the support list, provide your
registration number and expiration date.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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