mysqld got signal 11 while running openssl_1 test

main.openssl_1                           [ fail ]

        Test ended at 2014-07-30 14:55:19

CURRENT_TEST: main.openssl_1

mysqltest: In included file "/var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mysql/mysql-test/include/wait_condition.inc":

included from /var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mysql/mysql-test/t/openssl_1.test at line 165:

At line 53: query 'let $success= `$wait_condition`' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:

< snip >

SHOW STATUS LIKE 'Ssl_cipher';

Variable_name   Value

Ssl_cipher      DHE-RSA-AES256-SHA

Variable_name   Value

Ssl_cipher      DHE-RSA-AES256-SHA

End of 5.0 tests

DROP TABLE IF EXISTS thread_status;

DROP EVENT IF EXISTS event_status;

SET GLOBAL event_scheduler=1;

CREATE EVENT event_status

ON SCHEDULE AT NOW()

ON COMPLETION NOT PRESERVE

DO

BEGIN

CREATE TABLE thread_status

SELECT variable_name, variable_value

FROM information_schema.session_status

WHERE variable_name LIKE 'SSL_ACCEPTS' OR

variable_name LIKE 'SSL_CALLBACK_CACHE_HITS';

END$$

More results from queries before failure can be found in /var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mysql/mysql-test/var-tests/log/openssl_1.log

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

Server log from this test:

----------SERVER LOG START-----------

140730 14:55:18 [Note] [Debug] WSREP: dummy_stats_get

140730 14:55:18 [Note] [Debug] WSREP: dummy_stats_free

140730 14:55:18 [Note] [Debug] WSREP: dummy_stats_get

140730 14:55:18 [Note] [Debug] WSREP: dummy_stats_free

140730 14:55:18 [Note] X509 subject mismatch: should be 'xxx' but is '/C=SE/ST=Uppsala/O=MySQL AB'

140730 14:55:18 [Note] [Debug] WSREP: dummy_stats_get

140730 14:55:18 [Note] [Debug] WSREP: dummy_stats_free

140730 14:55:18 [Note] [Debug] WSREP: dummy_stats_get

140730 14:55:18 [Note] [Debug] WSREP: dummy_stats_free

140730 14:55:18 [Note] [Debug] WSREP: dummy_stats_get

140730 14:55:18 [Note] [Debug] WSREP: dummy_stats_free

140730 14:55:18 [Note] [Debug] WSREP: dummy_stats_get

140730 14:55:18 [Note] [Debug] WSREP: dummy_stats_free

140730 14:55:19 [Note] [Debug] WSREP: dummy_stats_get

140730 14:55:19 [Note] [Debug] WSREP: dummy_stats_free

140730 14:55:19 [Note] [Debug] WSREP: dummy_stats_get

140730 14:55:19 [Note] [Debug] WSREP: dummy_stats_free

140730 14:55:19 [Note] Event Scheduler: scheduler thread started with id 1767

140730 14:55:19 [Note] Event Scheduler: Last execution of test.event_status. Dropping.

140730 14:55:19 [Note] [Debug] WSREP: dummy_stats_get

140730 14:55:19 [Note] Event Scheduler: Dropping test.event_status

140730 14:55:19 [Note] [Debug] WSREP: dummy_stats_free

140730 14:55:19 [ERROR] mysqld got signal 11 ;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against is corrupt, improperly built,

or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see http://kb.askmonty.org/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help

diagnose the problem, but since we have already crashed,

something is definitely wrong and this may fail.

Server version: 5.5.38-MariaDB-wsrep-log

key_buffer_size=1048576

read_buffer_size=131072

max_used_connections=6

max_threads=153

thread_count=2

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62554 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0x7fcc980c9f40

Attempting backtrace. You can use the following information to find out

where mysqld died. If you see no messages after this, something went

terribly wrong...

stack_bottom = 0x7fcca88c4ddf thread_stack 0x48000

/var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mariadb-galera-5.5.38_build/sql/mysqld(my_print_stacktrace+0x29)[0xa2d929]

/var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mariadb-galera-5.5.38_build/sql/mysqld(handle_fatal_signal+0x390)[0x6c3bb0]

/lib64/libpthread.so.0(+0x107b0)[0x7fccacaf27b0]

/var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mariadb-galera-5.5.38_build/sql/mysqld(_Z21plugin_thdvar_cleanupP3THD+0xc4)[0x5a4e64]

/var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mariadb-galera-5.5.38_build/sql/mysqld(_ZN3THDD2Ev+0x20c)[0x56f4cc]

/var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mariadb-galera-5.5.38_build/sql/mysqld(_ZN3THDD0Ev+0x9)[0x56f889]

/var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mariadb-galera-5.5.38_build/sql/mysqld(_Z19deinit_event_threadP3THD+0xab)[0x7e798b]

/var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mariadb-galera-5.5.38_build/sql/mysqld(_ZN19Event_worker_thread3runEP3THDP28Event_queue_element_for_exec+0x55)[0x7e7c35]

/var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mariadb-galera-5.5.38_build/sql/mysqld(event_worker_thread+0x50)[0x7e7d30]

:0(pfs_spawn_thread)[0x9fd688]

/lib64/libpthread.so.0(+0x8333)[0x7fccacaea333]

/lib64/libc.so.6(clone+0x6d)[0x7fccabbd32cd]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0x0):

Connection ID (thread ID): 1768

Status: KILL_CONNECTION

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

information that should help you find out what is causing the crash.

Writing a core file

----------SERVER LOG END-------------

 - saving '/var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mysql/mysql-test/var-tests/log/main.openssl_1/' to '/var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mysql/mysql-test/var-tests/log/main.openssl_1/'

 - found 'core' (0/5)

Trying 'dbx' to get a backtrace

Trying 'gdb' to get a backtrace

Guessing that core was generated by '/var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mariadb-galera-5.5.38_build/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 LWP 17190]

[New LWP 12698]

[New LWP 12699]

[New LWP 17189]

[New LWP 17146]

[New LWP 12696]

warning: Could not load shared library symbols for linux-vdso.so.1.

Do you need "set solib-search-path" or "set sysroot"?

[Thread debugging using libthread_db enabled]

Using host libthread_db library "/lib64/libthread_db.so.1".

Core was generated by `/var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mariadb-galera-5.5.38_build/'.

Program terminated with signal SIGSEGV, Segmentation fault.

#0  0x00007fccacaefa91 in pthread_kill () from /lib64/libpthread.so.0

#0  0x00007fccacaefa91 in pthread_kill () from /lib64/libpthread.so.0

#1  0x00000000006c3bda in handle_fatal_signal ()

#2  <signal handler called>

#3  0x00000000005a4e64 in plugin_thdvar_cleanup(THD*) ()

#4  0x000000000056f4cc in THD::~THD() ()

#5  0x000000000056f889 in THD::~THD() ()

#6  0x00000000007e798b in deinit_event_thread(THD*) ()

#7  0x00000000007e7c35 in Event_worker_thread::run(THD*, Event_queue_element_for_exec*) ()

#8  0x00000000007e7d30 in event_worker_thread ()

#9  0x00000000009fd688 in pfs_spawn_thread ()

#10 0x00007fccacaea333 in start_thread () from /lib64/libpthread.so.0

#11 0x00007fccabbd32cd in clone () from /lib64/libc.so.6

Thread 6 (Thread 0x7fccad73a740 (LWP 12696)):

#0  0x00007fccabbc973d in poll () from /lib64/libc.so.6

#1  0x000000000051d28e in handle_connections_sockets() ()

#2  0x0000000000523045 in mysqld_main(int, char**) ()

#3  0x00007fccabb09a75 in __libc_start_main () from /lib64/libc.so.6

#4  0x0000000000517615 in _start ()

Thread 5 (Thread 0x7fcca887c700 (LWP 17146)):

#0  0x00007fccacaf187d in read () from /lib64/libpthread.so.0

#1  0x0000000000a59aed in vio_read ()

#2  0x000000000052471a in my_real_read(st_net*, unsigned long*) ()

#3  0x0000000000525302 in my_net_read ()

#4  0x000000000059f299 in do_command(THD*) ()

#5  0x0000000000640cd4 in do_handle_one_connection(THD*) ()

#6  0x0000000000640e62 in handle_one_connection ()

#7  0x00000000009fd688 in pfs_spawn_thread ()

#8  0x00007fccacaea333 in start_thread () from /lib64/libpthread.so.0

#9  0x00007fccabbd32cd in clone () from /lib64/libc.so.6

Thread 4 (Thread 0x7fcca8833700 (LWP 17189)):

#0  0x00007fccacaee7bc in pthread_cond_wait () from /lib64/libpthread.so.0

#1  0x00000000007ea1e4 in Event_queue::cond_wait(THD*, timespec*, char const*, char const*, unsigned int) ()

#2  0x00000000007ea367 in Event_queue::get_top_for_execution_if_time(THD*, Event_queue_element_for_exec**) ()

#3  0x00000000007e837f in Event_scheduler::run(THD*) ()

#4  0x00000000007e859d in event_scheduler_thread ()

#5  0x00000000009fd688 in pfs_spawn_thread ()

#6  0x00007fccacaea333 in start_thread () from /lib64/libpthread.so.0

#7  0x00007fccabbd32cd in clone () from /lib64/libc.so.6

Thread 3 (Thread 0x7fcca8a32700 (LWP 12699)):

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

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

#2  0x0000000000518ecf in signal_hand ()

#3  0x00000000009fd688 in pfs_spawn_thread ()

#4  0x00007fccacaea333 in start_thread () from /lib64/libpthread.so.0

#5  0x00007fccabbd32cd in clone () from /lib64/libc.so.6

Thread 2 (Thread 0x7fccab8d0700 (LWP 12698)):

#0  0x00007fccacaeeb8e in pthread_cond_timedwait () from /lib64/libpthread.so.0

#1  0x0000000000965a7e in my_service_thread_sleep ()

#2  0x000000000095ed60 in ma_checkpoint_background ()

#3  0x00000000009fd688 in pfs_spawn_thread ()

#4  0x00007fccacaea333 in start_thread () from /lib64/libpthread.so.0

#5  0x00007fccabbd32cd in clone () from /lib64/libc.so.6

Thread 1 (Thread 0x7fcca88c5700 (LWP 17190)):

#0  0x00007fccacaefa91 in pthread_kill () from /lib64/libpthread.so.0

#1  0x00000000006c3bda in handle_fatal_signal ()

#2  <signal handler called>

#3  0x00000000005a4e64 in plugin_thdvar_cleanup(THD*) ()

#4  0x000000000056f4cc in THD::~THD() ()

#5  0x000000000056f889 in THD::~THD() ()

#6  0x00000000007e798b in deinit_event_thread(THD*) ()

#7  0x00000000007e7c35 in Event_worker_thread::run(THD*, Event_queue_element_for_exec*) ()

#8  0x00000000007e7d30 in event_worker_thread ()

#9  0x00000000009fd688 in pfs_spawn_thread ()

#10 0x00007fccacaea333 in start_thread () from /lib64/libpthread.so.0

#11 0x00007fccabbd32cd in clone () from /lib64/libc.so.6

Compressed file /var/tmp/portage/dev-db/mariadb-galera-5.5.38/work/mysql/mysql-test/var-tests/log/main.openssl_1/mysqld.1/data/core

***Warnings generated in error logs during shutdown after running tests: main.lock_multi_bug38691 main.key_primary main.mix2_myisam_ucs2 main.not_embedded_server main.locale main.mysqltest_cont_on_error main.mysql-bug41486 main.mysqladmin main.help main.mysql_locale_posix main.mrr_icp_extra main.last_value main.implicit_char_to_num_conversion main.index_merge_myisam main.grant_cache_no_prot main.grant_lowercase_fs main.limit main.myisam_icp_notembedded main.join_nested main.metadata main.lock_multi_bug38499 main.mysql_upgrade_ssl main.myisam_mrr main.insert_select main.null_key main.mysqld--defaults-file main.information_schema_routines main.myisam_icp main.mysqltest_ps main.information_schema_db main.mysqltest_256 main.loadxml main.olap main.having main.handler_read_last main.information_schema_chmod main.group_by_null main.mysql_tzinfo_to_sql_symlink main.lock_multi main.grant_4332 main.null main.insert_notembedded main.information_schema2 main.mdev375 main.greedy_optimizer main.mysql_cp932 main.odbc main.mysql_upgrade main.not_partition main.in_datetime_241 main.merge main.non_blocking_api main.no_binlog main.insert main.kill main.mysql main.myisam-system main.log_tables_upgrade main.mysqlshow main.mix2_myisam main.mysqlhotcopy_myisam main.key main.join main.openssl_1 main.group_by main.mysql_protocols main.mdev316 main.group_min_max main.mysql_not_windows main.join_nested_jcl6 main.lowercase_fs_off main.log_slow main.join_crash main.negation_elimination main.key_diff main.grant_cache_ps_prot main.keywords main.myisampack main.myisam_optimize main.mysqld_option_err main.mysqlslap main.mysql-bug45236 main.join_optimizer main.insert_update main.limit_rows_examined main.handlersocket main.index_intersect main.mysql_comments main.loaddata main.join_cache main.information_schema_parameters

140730 14:55:19 [ERROR] mysqld got signal 11 ;

Attempting backtrace. You can use the following information to find out