Details
Description
Test fail with signal 11, configure option is
./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'
change -O3 to -O still fails
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
The result from queries just before the failure was:
< 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
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: mysql-test crashed on maria.maria-recover with icc compiled binary
with icc optimize options sets to -O0 -fp-model source -restrict, test passed.
verified on icc 10.1.025 and 11.1.072