Can't complete 'make test' and test table crash

[Takeshi]

Hi, this is Takeshi Ohishi from DeNA (but it's just try for private
purpose :-P)

I tried to install q4m into mysql, and it looked to be done, but can't
complete make test.
It crashed as below.

----------------------------------------------------------------------------------------------------------
# DBI_PASSWORD='password' ./run_test.pl
t/01-base-rnd_pos.t ....................... ok
t/01-base.t ............................... ok
t/02-queue-cond.t ......................... ok
t/02-queue-owned-delete.t ................. ok
t/02-queue.t .............................. ok
t/03-queue-error-wait.t ................... ok
t/03-queue-error.t ........................ ok
t/04-blob-cond.t .......................... 1/22011 *** glibc detected
*** /usr/sbin/mysqld: malloc(): memory corruption: 0x00007fc8860ae980
***
======= Backtrace: =========
/lib/libc.so.6[0x7fc882a9cdd6]
/lib/libc.so.6[0x7fc882a9fc0e]
/lib/libc.so.6(__libc_malloc+0x6e)[0x7fc882aa17ee]
/usr/lib/libstdc++.so.6(_Znwm+0x1d)[0x7fc8832f864d]
/usr/lib/mysql/plugin/
libqueue_engine.so(_ZNSt6vectorIPN13queue_share_t8append_tESaIS2_EE13_M_insert_auxEN9__gnu_cxx17__normal_iteratorIPS2_S4_EERKS2_
+0xd1)[0x7fc87f9e7ca1]
/usr/lib/mysql/plugin/
libqueue_engine.so(_ZN13queue_share_t10write_rowsEPKvmm+0x42c)
[0x7fc87f9dd23c]
/usr/lib/mysql/plugin/
libqueue_engine.so(_ZN8ha_queue15end_bulk_insertEv+0x6a)
[0x7fc87f9dde0a]
/usr/sbin/
mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb
+0xcf3)[0x7fc8847dbcc3]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0xbc1)[0x7fc884765561]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x35a)[0x7fc88476a38a]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj
+0xdea)[0x7fc88476b17a]
/usr/sbin/mysqld(_Z10do_commandP3THD+0xea)[0x7fc88476ba6a]
/usr/sbin/mysqld(handle_one_connection+0x23d)[0x7fc88475dced]
/lib/libpthread.so.0[0x7fc883fc0a04]
/lib/libc.so.6(clone+0x6d)[0x7fc882b067bd]
======= Memory map: ========
7fc874000000-7fc874021000 rw-p 00000000 00:00 0
7fc874021000-7fc878000000 ---p 00000000 00:00 0
7fc87a5db000-7fc87a5dc000 ---p 00000000 00:00 0
7fc87a5dc000-7fc87addc000 rw-p 00000000 00:00 0
7fc87addc000-7fc87b1dc000 r--s 00000000 ca:00
76859 /var/lib/mysql/test/q4m_t.Q4M
7fc87b1dc000-7fc87b1dd000 ---p 00000000 00:00 0
7fc87b1dd000-7fc87b9dd000 rw-p 00000000 00:00 0
7fc87b9dd000-7fc87b9de000 ---p 00000000 00:00 0
7fc87b9de000-7fc87c1de000 rw-p 00000000 00:00 0
7fc87c1de000-7fc87c1df000 ---p 00000000 00:00 0
7fc87c1df000-7fc87c9df000 rw-p 00000000 00:00 0
7fc87c9df000-7fc87c9e0000 ---p 00000000 00:00 0
7fc87c9e0000-7fc87d3e6000 rw-p 00000000 00:00 0
7fc87d663000-7fc87d664000 ---p 00000000 00:00 0
7fc87d664000-7fc87d694000 rw-p 00000000 00:00 0
7fc87d694000-7fc87d695000 ---p 00000000 00:00 0
7fc87d695000-7fc87d6c5000 rw-p 00000000 00:00 0
7fc87d6c5000-7fc87d6c6000 ---p 00000000 00:00 0
7fc87d6c6000-7fc87d6f6000 rw-p 00000000 00:00 0
7fc87d6f6000-7fc87d6f7000 ---p 00000000 00:00 0
7fc87d6f7000-7fc87def7000 rw-p 00000000 00:00 0
7fc87def7000-7fc87def8000 ---p 00000000 00:00 0
7fc87def8000-7fc87e6f8000 rw-p 00000000 00:00 0
7fc87e6f8000-7fc87e6f9000 ---p 00000000 00:00 0
7fc87e6f9000-7fc87f9b3000 rw-p 00000000 00:00 0
7fc87f9b3000-7fc87fa00000 r-xp 00000000 ca:00
60374 /usr/lib/mysql/plugin/libqueue_engine.so.
0.0.0
7fc87fa00000-7fc87fc00000 ---p 0004d000 ca:00
60374 /usr/lib/mysql/plugin/libqueue_engine.so.
0.0.0
7fc87fc00000-7fc87fc03000 r--p 0004d000 ca:00
60374 /usr/lib/mysql/plugin/libqueue_engine.so.
0.0.0
7fc87fc03000-7fc87fc04000 rw-p 00050000 ca:00
60374 /usr/lib/mysql/plugin/libqueue_engine.so.
0.0.0
7fc87fc04000-7fc881c01000 rw-p 00000000 00:00 0
7fc881c01000-7fc881c0d000 r-xp 00000000 ca:00
42 /lib/libnss_files-2.10.1.so
7fc881c0d000-7fc881e0c000 ---p 0000c000 ca:00
42 /lib/libnss_files-2.10.1.so
7fc881e0c000-7fc881e0d000 r--p 0000b000 ca:00
42 /lib/libnss_files-2.10.1.so
7fc881e0d000-7fc881e0e000 rw-p 0000c000 ca:00
42 /lib/libnss_files-2.10.1.so
7fc881e0e000-7fc881e18000 r-xp 00000000 ca:00
44 /lib/libnss_nis-2.10.1.so
7fc881e18000-7fc882017000 ---p 0000a000 ca:00
44 /lib/libnss_nis-2.10.1.so
7fc882017000-7fc882018000 r--p 00009000 ca:00
44 /lib/libnss_nis-2.10.1.so
7fc882018000-7fc882019000 rw-p 0000a000 ca:00
44 /lib/libnss_nis-2.10.1.so
7fc882019000-7fc882020000 r-xp 00000000 ca:00
40 /lib/libnss_compat-2.10.1.so
7fc882020000-7fc882220000 ---p 00007000 ca:00
40 /lib/libnss_compat-2.10.1.so
7fc882220000-7fc882221000 r--p 00007000 ca:00
40 /lib/libnss_compat-2.10.1.so
7fc882221000-7fc882222000 rw-p 00008000 ca:00
40 /lib/libnss_compat-2.10.1.so
7fc882226000-7fc882227000 ---p 00000000 00:00 0
7fc882227000-7fc882a27000 rw-p 00000000 00:00 0
7fc882a27000-7fc882b8d000 r-xp 00000000 ca:00
29 /lib/libc-2.10.1.so
7fc882b8d000-7fc882d8c000 ---p 00166000 ca:00
29 /lib/libc-2.10.1.so
7fc882d8c000-7fc882d90000 r--p 00165000 ca:00
29 /lib/libc-2.10.1.so
7fc882d90000-7fc882d91000 rw-p 00169000 ca:00
29 /lib/libc-2.10.1.so
7fc882d91000-7fc882d96000 rw-p 00000000 00:00 0
7fc882d96000-7fc882dac000 r-xp 00000000 ca:00
75 /lib/libgcc_s.so.1
7fc882dac000-7fc882fab000 ---p 00016000 ca:00
75 /lib/libgcc_s.so.1
7fc882fab000-7fc882fac000 r--p 00015000 ca:00
75 /lib/libgcc_s.so.1
7fc882fac000-7fc882fad000 rw-p 00016000 ca:00
75 /lib/libgcc_s.so.1
7fc882fad000-7fc88302f000 r-xp 00000000 ca:00
37 /lib/libm-2.10.1.so
7fc88302f000-7fc88322f000 ---p 00082000 ca:00
37 /lib/libm-2.10.1.so
7fc88322f000-7fc883230000 r--p 00082000 ca:00
37 /lib/libm-2.10.1.so
7fc883230000-7fc883231000 rw-p 00083000 ca:00
37 /lib/libm-2.10.1.so
7fc883231000-7fc883323000 r-xp 00000000 ca:00
4354 /usr/lib/libstdc++.so.6.0.13
7fc883323000-7fc883523000 ---p 000f2000 ca:00
4354 /usr/lib/libstdc++.so.6.0.13
7fc883523000-7fc88352a000 r--p 000f2000 ca:00
4354 /usr/lib/libstdc++.so.6.0.13
7fc88352a000-7fc88352c000 rw-p 000f9000 ca:00
4354 /usr/lib/libstdc++.so.6.0.13
7fc88352c000-7fc883541000 rw-p 00000000 00:00 0
7fc883541000-7fc883557000 r-xp 00000000 ca:00
39 /lib/libnsl-2.10.1.so
7fc883557000-7fc883757000 ---p 00016000 ca:00
39 /lib/libnsl-2.10.1.so
7fc883757000-7fc883758000 r--p 00016000 ca:00
39 /lib/libnsl-2.10.1.so
7fc883758000-7fc883759000 rw-p 00017000 ca:00
39 /lib/libnsl-2.10.1.so
7fc883759000-7fc88375b000 rw-p 00000000 00:00 0
7fc88375b000-7fc883764000 r-xp 00000000 ca:00
35 /lib/libcrypt-2.10.1.so
7fc883764000-7fc883964000 ---p 00009000 ca:00
35 /lib/libcrypt-2.10.1.so
7fc883964000-7fc883965000 r--p 00009000 ca:00
35 /lib/libcrypt-2.10.1.so
7fc883965000-7fc883966000 rw-p 0000a000 ca:00
35 /lib/libcrypt-2.10.1.so
7fc883966000-7fc883994000 rw-p 00000000 00:00 0
7fc883994000-7fc883996000 r-xp 00000000 ca:00
36 /lib/libdl-2.10.1.so
7fc883996000-7fc883b96000 ---p 00002000 ca:00
36 /lib/libdl-2.10.1.so
7fc883b96000-7fc883b97000 r--p 00002000 ca:00
36 /lib/libdl-2.10.1.so
7fc883b97000-7fc883b98000 rw-p 00003000 ca:00
36 /lib/libdl-2.10.1.so
7fc883b98000-7fc883ba1000 r-xp 00000000 ca:00
338 /lib/libwrap.so.0.7.6
7fc883ba1000-7fc883da0000 ---p 00009000 ca:00
338 /lib/libwrap.so.0.7.6
7fc883da0000-7fc883da1000 r--p 00008000 ca:00
338 /lib/libwrap.so.0.7.6
7fc883da1000-7fc883da2000 rw-p 00009000 ca:00
338 /lib/libwrap.so.0.7.6
7fc883da2000-7fc883da3000 rw-p 00000000 00:00 0
7fc883da3000-7fc883db9000 r-xp 00000000 ca:00
146 /lib/libz.so.1.2.3.3
7fc883db9000-7fc883fb8000 ---p 00016000 ca:00
146 /lib/libz.so.1.2.3.3
7fc883fb8000-7fc883fb9000 r--p 00015000 ca:00
146 /lib/libz.so.1.2.3.3
7fc883fb9000-7fc883fba000 rw-p 00016000 ca:00
146 /lib/libz.so.1.2.3.3
7fc883fba000-7fc883fd1000 r-xp 00000000 ca:00
47 /lib/libpthread-2.10.1.so
7fc883fd1000-7fc8841d0000 ---p 00017000 ca:00
47 /lib/libpthread-2.10.1.so
7fc8841d0000-7fc8841d1000 r--p 00016000 ca:00
47 /lib/libpthread-2.10.1.so
7fc8841d1000-7fc8841d2000 rw-p 00017000 ca:00
47 /lib/libpthread-2.10.1.so
7fc8841d2000-7fc8841d6000 rw-p 00000000 00:00 0
7fc8841d6000-7fc8841f5000 r-xp 00000000 ca:00
26 /lib/ld-2.10.1.so
7fc884223000-7fc8843ed000 rw-p 00000000 00:00 0
7fc8843ee000-7fc8843f4000 rw-p 00000000 00:00 0
7fc8843f4000-7fc8843f5000 r--p 0001e000 ca:00
26 /lib/ld-2.10.1.so
7fc8843f5000-7fc8843f6000 rw-p 0001f000 ca:00
26 /lib/ld-2.10.1.so
7fc8843f6000-7fc884c99000 r-xp 00000000 ca:00
204807 /usr/sbin/mysqld
7fc884e99000-7fc884f00000 r--p 008a3000 ca:00
204807 /usr/sbin/mysqld
7fc884f00000-7fc884f72000 rw-p 0090a000 ca:00
204807 /usr/sbin/mysqld
7fc884f72000-7fc884f89000 rw-p 00000000 00:00 0
7fc885a5c000-7fc88615d000 rw-p 00000000 00:00
0 [heap]
7fff497c2000-7fff497d7000 rw-p 00000000 00:00
0 [stack]
7fff497ff000-7fff49800000 r-xp 00000000 00:00
0 [vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00
0 [vsyscall]
----------------------------------------------------------------------------------------------------------

More information as below.
----------------------------------------------------------------------------------------------------------
OS: Ubuntu 9.10 64bit
MySQL: 5.1.37
% dpkg -l | grep mysql
ii libdbd-mysql-perl 4.011-1ubuntu1 A
Perl5 database interface to the MySQL data
ii libmysqlclient-dev 5.1.37-1ubuntu5.1
MySQL database development files
ii libmysqlclient16 5.1.37-1ubuntu5.1
MySQL database client library
ii libmysqlclient16-dev 5.1.37-1ubuntu5.1
MySQL database development files - empty tra
ii mysql-client-5.1 5.1.37-1ubuntu5.1
MySQL database client binaries
ii mysql-common 5.1.37-1ubuntu5.1
MySQL database common files (e.g. /etc/mysql
ii mysql-server 5.1.37-1ubuntu5.1
MySQL database server (metapackage depending
ii mysql-server-5.1 5.1.37-1ubuntu5.1
MySQL database server binaries
ii mysql-server-core-5.1 5.1.37-1ubuntu5.1
MySQL database core server files
Q4M: 0.9.4
perl: 5.12.1
----------------------------------------------------------------------------------------------------------

If required, I'll definitely give more information about my
environment.
Thanks.

--Takeshi

[Kazuho Oku]

Hi,

Would you please let me know the following?

1) version of MySQL and the configuration options (can be found in
bin/mysqlbug script)

2a) (if you installed Q4M from source) version of Q4M and the
configuration options (can be found in config.log)
2b) (or if you downloaded Q4M binary and installed it) the URL of the Q4M binary

3) OS (or distribution) you are using (as well as the architecture,
like i386 or x86_64)

2010/9/18 Takeshi <tks.o...@gmail.com>:

> --
> You received this message because you are subscribed to the Google Groups "Q4M - a Message Queue for MySQL" group.
> To post to this group, send email to q4m-g...@googlegroups.com.
> To unsubscribe from this group, send email to q4m-general...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/q4m-general?hl=en.
>
>

--
Kazuho Oku

[Takeshi Ohishi]

It would be good if the information below is helpful for you.

1)
MySQL version: 5.1.37
Configure command: ../configure  '--build=x86_64-linux-gnu' '--host=x86_64-linux-gnu' '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--d    atadir=/usr/share' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--with-server-suf    fix=-1ubuntu5.4' '--with-comment=(Ubuntu)' '--with-system-type=debian-linux-gnu' '--enable-shared' '--enable-static' '--enable-thread-safe-client' '--en    able-assembler' '--enable-local-infile' '--with-pstack' '--with-fast-mutexes' '--with-big-tables' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock'     '--with-mysqld-user=mysql' '--with-libwrap' '--with-ssl' '--without-docs' '--with-extra-charsets=all' '--with-plugins=max' '--without-ndbcluster' '--wit    h-embedded-server' '--with-embedded-privilege-control' 'build_alias=x86_64-linux-gnu' 'host_alias=x86_64-linux-gnu' 'CC=gcc' 'CFLAGS=-O3 -DBIG_JOINS=1      -fno-strict-aliasing' 'LDFLAGS=-Wl,-Bsymbolic-functions' 'CPPFLAGS=' 'CXX=g++' 'CXXFLAGS=-O3 -DBIG_JOINS=1 -felide-constructors -fno-exceptions -fno-rtt    i  -fno-strict-aliasing'

2)
Q4M version: 0.9.4
./configure CPPFLAG=-I/usr/include/mysql --with-mysql=/home/takeshi/local/src/mysql-5.1.37

3)
Ubuntu 9.10 x86_64

Thanks!

Takeshi Ohishi
Software Engineer
tks.o...@gmail.com
"""

[Kazuho Oku]

Thank you for the information.

Question: is the mysql source you are referring in the Q4M
configuration (the one in /home/takeshi/local/src/mysql-5.1.37)
configured with the identical options with 1?

2010/9/23 Takeshi Ohishi <tks.o...@gmail.com>:

[Takeshi Ohishi]

Ah, I see... I have to follow mysqlbug's configure command exactly. I'll try again.
Now in my env, wrong QUEUE engine was already installed, so how should I uninstall this engine?