LP:611586 - mysql-test crashed on maria.maria-recover with icc compiled binary

./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data'

'--with-comment=(MariaDB - http://mariadb.com/)' '--with-system-type=Linux'

'--with-machine-type=x86_64' '--disable-shared' '--without-embedded-server'

'--without-bench' '--enable-assembler' '--enable-static'

'--with-client-ldflags=-static' '--with-mysqld-ldflags=-static'

'--enable-thread-safe-client' '--enable-local-infile' '--with-big-tables'

'--without-docs' '--with-extra-charsets=complex' '--with-ssl'

'--with-readline' '--with-libevent' '--with-zlib-dir=bundled'

'--with-partition' '--with-plugins=max-no-ndb' '--with-plugin-maria'

'--with-maria-tmp-tables' '--without-plugin-innodb'

'--without-plugin-example' '--without-plugin-ibmdb2i'

'--without-plugin-pbxt' 'CC=icc -static-intel -static-libgcc'

'CFLAGS=-O3 -unroll2 -ip -fp-model source -restrict'

'CXX=icpc -static-intel -static-libgcc' 'CXXFLAGS=-O3 -unroll2 -ip -fp-model source -restrict'

maria.maria-recover                      [ fail ]

        Test ended at 2010-07-30 15:28:04

CURRENT_TEST: maria.maria-recover

mysqltest: At line 63: query 'select * from t_corrupted2' failed: 2013: Lost connection to MySQL server during query

< snip >

OFF

set global maria_recover=normal;

select @@global.maria_recover;

@@global.maria_recover

NORMAL

drop database if exists mysqltest;

create database mysqltest;

use mysqltest;

create table t1 (a varchar(1000), index(a)) engine=maria;

insert into t1 values("

Server [mysqld.1 - pid: 16160, winpid: 16160, exit: 256] failed during test run

Server log from this test:

100730 15:28:04 [Note] Plugin 'InnoDB' is disabled.

100730 15:28:04 [Warning] /usr/local/src/mariadb-5.1.47/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300'

100730 15:28:04 [Note] Event Scheduler: Loaded 0 events

100730 15:28:04 [Note] /usr/local/src/mariadb-5.1.47/sql/mysqld: ready for connections.

Version: '5.1.47-MariaDB-log'  socket: '/usr/local/src/mariadb-5.1.47/mysql-test/var/tmp/mysqld.1.sock'  port: 13000  (MariaDB - http://mariadb.com/)

100730 15:28:04 [ERROR] mysqld: Table './mysqltest/t_corrupted2' is marked as crashed and should be repaired

 - saving '/usr/local/src/mariadb-5.1.47/mysql-test/var/log/maria.maria-recover/' to '/usr/local/src/mariadb-5.1.47/mysql-test/var/log/maria.maria-recover/'

 - found 'core.16164' (0/5)

Trying 'dbx' to get a backtrace

Trying 'gdb' to get a backtrace

Core generated by '/usr/local/src/mariadb-5.1.47/sql/mysqld'

Output from gdb follows. The first stack trace is from the failing thread.

The following stack traces are from all threads (so the failing one is

duplicated).

--------------------------

[New Thread 16167]

[New Thread 16166]

[New Thread 16164]

Core was generated by `/usr/local/src/mariadb-5.1.47/sql/mysqld --defaults-group-suffix=.1 --defaults-'.

Program terminated with signal 11, Segmentation fault.

#0  0x00000000008e0be3 in ha_maria::check_and_repair(THD*) ()

#0  0x00000000008e0be3 in ha_maria::check_and_repair(THD*) ()

#1  0x00000000007797e0 in handler::ha_check_and_repair(THD*) ()

#2  0x000000000068b19e in open_unireg_entry(THD*, st_table*, TABLE_LIST*, char const*, char*, unsigned int, st_mem_root*, unsigned int) ()

#3  0x000000000068a893 in open_table(THD*, TABLE_LIST*, st_mem_root*, bool*, unsigned int) ()

#4  0x000000000068cdb4 in open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int) ()

#5  0x000000000068bb15 in open_and_lock_tables_derived(THD*, TABLE_LIST*, bool) ()

#6  0x000000000064b0d8 in execute_sqlcom_select(THD*, TABLE_LIST*) ()

#7  0x00000000006451a5 in mysql_execute_command(THD*) ()

#8  0x000000000064b6eb in mysql_parse(THD*, char const*, unsigned int, char const**) ()

#9  0x000000000063fa83 in dispatch_command(enum_server_command, THD*, char*, unsigned int) ()

#10 0x000000000063e644 in do_command(THD*) ()

#11 0x00000000006390ba in handle_one_connection ()

#12 0x00002aaaaaee673d in start_thread () from /lib64/libpthread.so.0

#13 0x00002aaaabfadd1d in clone () from /lib64/libc.so.6

Thread 4 (Thread 16164):

#0  0x00002aaaabfa6fc2 in select () from /lib64/libc.so.6

#1  0x000000000062bde3 in main ()

Thread 3 (Thread 16166):

#0  0x00002aaaaaeeb150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0

#1  0x000000000094dd36 in ma_checkpoint_background ()

#2  0x00002aaaaaee673d in start_thread () from /lib64/libpthread.so.0

#3  0x00002aaaabfadd1d in clone () from /lib64/libc.so.6

Thread 2 (Thread 16167):

#0  0x00002aaaaaeee838 in do_sigwait () from /lib64/libpthread.so.0

#1  0x00002aaaaaeee8dd in sigwait () from /lib64/libpthread.so.0

#2  0x000000000062f220 in signal_hand ()

#3  0x00002aaaaaee673d in start_thread () from /lib64/libpthread.so.0

#4  0x00002aaaabfadd1d in clone () from /lib64/libc.so.6

Thread 1 (Thread 16180):

#0  0x00000000008e0be3 in ha_maria::check_and_repair(THD*) ()

#1  0x00000000007797e0 in handler::ha_check_and_repair(THD*) ()

#2  0x000000000068b19e in open_unireg_entry(THD*, st_table*, TABLE_LIST*, char const*, char*, unsigned int, st_mem_root*, unsigned int) ()

#3  0x000000000068a893 in open_table(THD*, TABLE_LIST*, st_mem_root*, bool*, unsigned int) ()

#4  0x000000000068cdb4 in open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int) ()

#5  0x000000000068bb15 in open_and_lock_tables_derived(THD*, TABLE_LIST*, bool) ()

#6  0x000000000064b0d8 in execute_sqlcom_select(THD*, TABLE_LIST*) ()

#7  0x00000000006451a5 in mysql_execute_command(THD*) ()

#8  0x000000000064b6eb in mysql_parse(THD*, char const*, unsigned int, char const**) ()

#9  0x000000000063fa83 in dispatch_command(enum_server_command, THD*, char*, unsigned int) ()

#10 0x000000000063e644 in do_command(THD*) ()

#11 0x00000000006390ba in handle_one_connection ()

#12 0x00002aaaaaee673d in start_thread () from /lib64/libpthread.so.0

#13 0x00002aaaabfadd1d in clone () from /lib64/libc.so.6