>Description:
Rollback still does not work with MySQL 3.23.32 and BDB 3.2.3h.
This same problem has been encountered with earlier versions of
MySQL as well. However, all hosts on which this has been noticed
have been running Red Hat Linux 7.0, which could be the culprit.
Several different libc versions have been tested with RH7.
>How-To-Repeat:
The short way: (%=regular user, $=root)
1. Build BDB 3.2.3h
% tar xvfz db-3.2.3h.tar.gz
% cd db-3.2.3h/build_unix
% ../dist/configure --enable-cxx --enable-dynamic --enable-shared
% make
$ make install
2. Build MySQL
% cd ../..
% tar xvfz mysql-3.23.32.tar.gz
% cd mysql-3.23.32
% ./configure --enable-assembler --with-mysqld-user=mysql \
--with-unix-socket-path=/var/lib/mysql/mysql.sock \
--with-extra-charsets=complex --prefix=/ --exec-prefix=/usr \
--libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share \
--localstatedir=/var/lib/mysql --infodir=/usr/info \
--includedir=/usr/include --mandir=/usr/man \
--with-berkeley-db=/usr/local/BerkeleyDB.3.2 \
'--with-comment=Tarball Source Build'
% make
3. Run the test cases
% make test
The BDB test will fail in line 122, which tries to insert an integer
(4) into table t1. This value has earlier been inserted into the same
table, but this insert was rolled back so the record should not be
there.
>Fix:
Not known.
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
Tomi Junnila <[EMAIL PROTECTED]>
http://www.badzilla.net/~topeju/
Electronics and Information Technology,
University of Turku, Finland
>
>MySQL support: none
>Synopsis: BDB rollback still not working in 3.23.32
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.32 (Tarball Source Build)
>Environment:
For documentation on how BDB was installed, see above.
System: Linux isis.yok.utu.fi 2.2.16-22isis1 #2 Sat Nov 4 20:36:36 EET 2000 i586
unknown
Architecture: i586
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.0)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 11 Nov 23 22:36 /lib/libc.so.6 -> libc-2.2.so
-rwxr-xr-x 1 root root 5072386 Jan 11 01:37 /lib/libc-2.2.so
-rw-r--r-- 1 root root 24498288 Jan 11 01:35 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 11 01:35 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Nov 1 19:52 /usr/lib/libc-client.a ->
c-client.a
Configure command: ./configure --enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-extra-charsets=complex
--prefix=/ --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc
--datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info
--includedir=/usr/include --mandir=/usr/man
--with-berkeley-db=/usr/local/BerkeleyDB.3.2 '--with-comment=Tarball Source Build'
---------------------------------------------------------------------
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
