Andrii Nikitin (Inactive) added a comment - 2017-05-05 16:14 Full report from test run: ./mysql-test-run.pl innodb1 --mysqld=--innodb_thread_concurrency=8 Logging: /home/a/test1/mariadb-environs/_depot/m-branch/10.2/mysql-test/mysql-test-run.pl innodb1 --mysqld=--innodb_thread_concurrency=8 vardir: /home/a/test1/mariadb-environs/m9-10.2/build/mysql-test/var Removing old var directory... Creating var directory '/home/a/test1/mariadb-environs/m9-10.2/build/mysql-test/var'... Checking supported features... MariaDB Version 10.2.6-MariaDB - SSL connections supported Collecting tests... Installing system database...   ==============================================================================   TEST RESULT TIME (ms) or COMMENT --------------------------------------------------------------------------   worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 innodb.innodb1 'innodb' [ fail ] Test ended at 2017-05-05 18:12:35   CURRENT_TEST: innodb.innodb1 ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query mysqltest: At line 6: exec of '/home/a/test1/mariadb-environs/m9-10.2/build/client/mysql --defaults-file=/home/a/test1/mariadb-environs/m9-10.2/build/mysql-test/var/my.cnf -Ns -e "CREATE TABLE tmp1 ENGINE=InnoDB SELECT * FROM payment" test' failed, error: 256, status: 1, errno: 11 Output from before failure:     Server [mysqld.1 - pid: 30154, winpid: 30154, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2017-05-05 18:12:31 140413173444672 [Note] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld (mysqld 10.2.6-MariaDB-log) starting as process 30155 ... 2017-05-05 18:12:31 140413173444672 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4162) 2017-05-05 18:12:31 140413173444672 [Note] Plugin 'SEQUENCE' is disabled. 2017-05-05 18:12:31 140413173444672 [Note] Plugin 'partition' is disabled. 2017-05-05 18:12:31 140413173444672 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-05 18:12:31 140413173444672 [Note] InnoDB: Uses event mutexes 2017-05-05 18:12:31 140413173444672 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-05-05 18:12:31 140413173444672 [Note] InnoDB: Using Linux native AIO 2017-05-05 18:12:31 140413173444672 [Note] InnoDB: Number of pools: 1 2017-05-05 18:12:31 140413173444672 [Note] InnoDB: Using SSE2 crc32 instructions 2017-05-05 18:12:31 140413173444672 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M 2017-05-05 18:12:31 140413173444672 [Note] InnoDB: Completed initialization of buffer pool 2017-05-05 18:12:31 140412933101312 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-05-05 18:12:31 140413173444672 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-05 18:12:31 140413173444672 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-05-05 18:12:31 140413173444672 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-05-05 18:12:32 140413173444672 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-05-05 18:12:32 140413173444672 [Note] InnoDB: 128 out of 128 rollback segments are active. 2017-05-05 18:12:32 140413173444672 [Note] InnoDB: Waiting for purge to start 2017-05-05 18:12:32 140413173444672 [Note] InnoDB: 5.7.14 started; log sequence number 1634127 2017-05-05 18:12:32 140412782098176 [Note] InnoDB: Loading buffer pool(s) from /home/a/test1/mariadb-environs/m9-10.2/build/mysql-test/var/mysqld.1/data/ib_buffer_pool 2017-05-05 18:12:32 140412782098176 [Note] InnoDB: Buffer pool(s) load completed at 170505 18:12:32 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_CMP' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'FEEDBACK' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'user_variables' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2017-05-05 18:12:32 140413173444672 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled. 2017-05-05 18:12:32 140413173444672 [Warning] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld: unknown variable 'loose-feedback-debug-startup-interval=20' 2017-05-05 18:12:32 140413173444672 [Warning] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld: unknown variable 'loose-feedback-debug-first-interval=60' 2017-05-05 18:12:32 140413173444672 [Warning] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld: unknown variable 'loose-feedback-debug-interval=60' 2017-05-05 18:12:32 140413173444672 [Warning] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld: unknown option '--loose-pam-debug' 2017-05-05 18:12:32 140413173444672 [Warning] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300' 2017-05-05 18:12:32 140413173444672 [Note] Server socket created on IP: '127.0.0.1'. 2017-05-05 18:12:32 140413173444672 [Note] Reading of all Master_info entries succeded 2017-05-05 18:12:32 140413173444672 [Note] Added new Master_info '' to hash table 2017-05-05 18:12:32 140413173444672 [Note] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld: ready for connections. Version: '10.2.6-MariaDB-log' socket: '/home/a/test1/mariadb-environs/m9-10.2/build/mysql-test/var/tmp/mysqld.1.sock' port: 16000 MariaDB Server 2017-05-05 18:12:34 0x7fb476486700 InnoDB: Assertion failure in file /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0conc.cc line 126 InnoDB: Failing assertion: !trx->declared_to_be_inside_innodb InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 170505 18:12:34 [ERROR] mysqld got signal 6 ; 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 https://mariadb.com/kb/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: 10.2.6-MariaDB-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=2 max_threads=153 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62977 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.   Thread pointer: 0x7fb4200009a8 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 = 0x7fb476485e48 thread_stack 0x49000 /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld(my_print_stacktrace+0x2e)[0x55d3ebbb613e] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld(handle_fatal_signal+0x3cd)[0x55d3eb62211d] /lib/x86_64-linux-gnu/libpthread.so.0(+0x11630)[0x7fb47caea630] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x9f)[0x7fb47c0b67ef] /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7fb47c0b83ea] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld(+0x40da05)[0x55d3eb3dea05] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld(+0x8f32f4)[0x55d3eb8c42f4] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld(+0x7e2f53)[0x55d3eb7b3f53] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld(_ZN7handler11ha_rnd_nextEPh+0x71)[0x55d3eb626621] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld(_Z13rr_sequentialP11READ_RECORD+0x37)[0x55d3eb72f6d7] mysys/stacktrace.c:268(my_print_stacktrace)[0x55d3eb4c35b6] include/my_atomic.h:274(my_atomic_add64)[0x55d3eb4e1d70] handler/ha_innodb.cc:10368(ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int))[0x55d3eb4e1f13] sql/handler.cc:2584(handler::ha_rnd_next(unsigned char*))[0x55d3eb4e205b] /home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x135)[0x55d3eb4e2985] sql/sql_select.cc:18486(sub_select(JOIN*, st_join_table*, bool))[0x55d3eb493bb6] sql/sql_parse.cc:3917(mysql_execute_command(THD*))[0x55d3eb4946ca] sql/sql_parse.cc:1812(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55d3eb497604] sql/sql_parse.cc:1364(do_command(THD*))[0x55d3eb497ea7] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x55d3eb55c46a] sql/sql_connect.cc:1262(handle_one_connection)[0x55d3eb55c5dd] perfschema/pfs.cc:1865(pfs_spawn_thread)[0x55d3ebb6a731] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ca)[0x7fb47cae06ca] /lib/x86_64-linux-gnu/libc.so.6(clone+0x5f)[0x7fb47c1890af]   Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fb42000eed0): CREATE TABLE tmp1 ENGINE=InnoDB SELECT * FROM payment Connection ID (thread ID): 11 Status: NOT_KILLED   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=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on   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 '/home/a/test1/mariadb-environs/m9-10.2/build/mysql-test/var/log/innodb.innodb1-innodb/' to '/home/a/test1/mariadb-environs/m9-10.2/build/mysql-test/var/log/innodb.innodb1-innodb/' - found 'core' (0/5)   Trying 'dbx' to get a backtrace   Trying 'gdb' to get a backtrace from coredump /home/a/test1/mariadb-environs/m9-10.2/build/mysql-test/var/log/innodb.innodb1-innodb/mysqld.1/data/core Core generated by '/home/a/test1/mariadb-environs/m9-10.2/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 30189] [New LWP 30159] [New LWP 30166] [New LWP 30161] [New LWP 30163] [New LWP 30156] [New LWP 30167] [New LWP 30158] [New LWP 30160] [New LWP 30157] [New LWP 30173] [New LWP 30165] [New LWP 30172] [New LWP 30177] [New LWP 30175] [New LWP 30155] [New LWP 30170] [New LWP 30169] [New LWP 30174] [New LWP 30171] [New LWP 30178] [New LWP 30181] [New LWP 30180] [New LWP 30179] [New LWP 30176] [New LWP 30162] [New LWP 30168] [New LWP 30184] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". Core was generated by `/home/a/test1/mariadb-environs/m9-10.2/build/sql/mysqld --defaults-group-suffix'. Program terminated with signal SIGABRT, Aborted. #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 62 ../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory. [Current thread is 1 (Thread 0x7fb476486700 (LWP 30189))] #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 #1 0x000055d3ebbb5d07 in my_write_core (sig=sig@entry=6) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/mysys/stacktrace.c:477 #2 0x000055d3eb6220b7 in handle_fatal_signal (sig=6) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/signal_handler.cc:299 #3 <signal handler called> #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:58 #5 0x00007fb47c0b83ea in __GI_abort () at abort.c:89 #6 0x000055d3eb3dea05 in ut_dbg_assertion_failed (expr=expr@entry=0x55d3ebd356e8 "!trx->declared_to_be_inside_innodb", file=file@entry=0x55d3ebd35690 "/home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0conc.cc", line=line@entry=126) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/ut/ut0dbg.cc:60 #7 0x000055d3eb8c42f4 in srv_conc_enter_innodb_with_atomics (trx=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0conc.cc:126 #8 0x000055d3eb7b3f53 in ha_innobase::general_fetch (this=0x7fb42001a380, buf=0x7fb420017e40 "\375\203\006<", direction=1, match_mode=0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/handler/ha_innodb.cc:10365 #9 0x000055d3eb626621 in handler::ha_rnd_next (this=0x7fb42001a380, buf=0x7fb420017e40 "\375\203\006<") at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/handler.cc:2584 #10 0x000055d3eb72f6d7 in rr_sequential (info=0x7fb4200133d0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/records.cc:484 #11 0x000055d3eb4c35b6 in sub_select (join=0x7fb420010048, join_tab=0x7fb420013308, end_of_records=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_select.cc:18484 #12 0x000055d3eb4e1d70 in do_select (procedure=<optimized out>, join=0x7fb420010048) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_select.cc:18009 #13 JOIN::exec_inner (this=this@entry=0x7fb420010048) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_select.cc:3469 #14 0x000055d3eb4e1f13 in JOIN::exec (this=this@entry=0x7fb420010048) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_select.cc:3271 #15 0x000055d3eb4e205b in mysql_select (thd=thd@entry=0x7fb4200009a8, tables=0x7fb42000f748, wild_num=1, fields=..., conds=<optimized out>, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7fb42000ff50, unit=0x7fb420004348, select_lex=0x7fb420004a80) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_select.cc:3664 #16 0x000055d3eb4e2985 in handle_select (thd=thd@entry=0x7fb4200009a8, lex=lex@entry=0x7fb420004280, result=result@entry=0x7fb42000ff50, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_select.cc:361 #17 0x000055d3eb493bb6 in mysql_execute_command (thd=thd@entry=0x7fb4200009a8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_parse.cc:3917 #18 0x000055d3eb4946ca in mysql_parse (thd=thd@entry=0x7fb4200009a8, rawbuf=<optimized out>, length=53, parser_state=parser_state@entry=0x7fb476485210, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_parse.cc:7874 #19 0x000055d3eb497604 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fb4200009a8, packet=packet@entry=0x7fb42001de39 "CREATE TABLE tmp1 ENGINE=InnoDB SELECT * FROM payment", packet_length=packet_length@entry=53, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_parse.cc:1812 #20 0x000055d3eb497ea7 in do_command (thd=0x7fb4200009a8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_parse.cc:1361 #21 0x000055d3eb55c46a in do_handle_one_connection (connect=connect@entry=0x55d3ee2fe9e8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_connect.cc:1354 #22 0x000055d3eb55c5dd in handle_one_connection (arg=arg@entry=0x55d3ee2fe9e8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_connect.cc:1260 #23 0x000055d3ebb6a731 in pfs_spawn_thread (arg=0x55d3ee2b9218) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/perfschema/pfs.cc:1862 #24 0x00007fb47cae06ca in start_thread (arg=0x7fb476486700) at pthread_create.c:333 #25 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 28 (Thread 0x7fb4764d0700 (LWP 30184)): #0 0x00007fb47c17d0bd in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x000055d3ebc58501 in poll (__timeout=28800000, __nfds=1, __fds=0x7fb4764cf770) at /usr/include/x86_64-linux-gnu/bits/poll2.h:46 #2 vio_io_wait (vio=vio@entry=0x55d3ee2b8ce8, event=event@entry=VIO_IO_EVENT_READ, timeout=28800000) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/vio/viosocket.c:945 #3 0x000055d3ebc58588 in vio_socket_io_wait (vio=vio@entry=0x55d3ee2b8ce8, event=event@entry=VIO_IO_EVENT_READ) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/vio/viosocket.c:108 #4 0x000055d3ebc58692 in vio_read (vio=0x55d3ee2b8ce8, buf=0x7fb42c006be8 "\001", size=4) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/vio/viosocket.c:184 #5 0x000055d3eb403c7a in my_real_read (net=0x7fb42c000be8, complen=complen@entry=0x7fb4764cf978, header=header@entry=1 '\001') at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/net_serv.cc:888 #6 0x000055d3eb404d38 in my_net_read_packet_reallen (net=net@entry=0x7fb42c000be8, read_from_server=read_from_server@entry=1 '\001', reallen=reallen@entry=0x7fb4764cf9c8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/net_serv.cc:1158 #7 0x000055d3eb404e9d in my_net_read_packet (net=net@entry=0x7fb42c000be8, read_from_server=read_from_server@entry=1 '\001') at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/net_serv.cc:1142 #8 0x000055d3eb497dda in do_command (thd=0x7fb42c0009a8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_parse.cc:1244 #9 0x000055d3eb55c46a in do_handle_one_connection (connect=connect@entry=0x55d3ee2fe9e8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_connect.cc:1354 #10 0x000055d3eb55c5dd in handle_one_connection (arg=arg@entry=0x55d3ee2fe9e8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_connect.cc:1260 #11 0x000055d3ebb6a731 in pfs_spawn_thread (arg=0x55d3ee2b8ee8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/perfschema/pfs.cc:1862 #12 0x00007fb47cae06ca in start_thread (arg=0x7fb4764d0700) at pthread_create.c:333 #13 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 27 (Thread 0x7fb46cff9700 (LWP 30168)): #0 0x00007fb47cae9ced in nanosleep () at ../sysdeps/unix/syscall-template.S:84 #1 0x000055d3eb82a2b0 in os_thread_sleep (tm=tm@entry=1000000) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0thread.cc:245 #2 0x000055d3eb8cc2cb in srv_master_sleep () at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0srv.cc:2521 #3 srv_master_thread (arg=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0srv.cc:2568 #4 0x00007fb47cae06ca in start_thread (arg=0x7fb46cff9700) at pthread_create.c:333 #5 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 26 (Thread 0x7fb46f7fe700 (LWP 30162)): #0 0x00007fb47d13364a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d3eb81ded1 in LinuxAIOHandler::collect (this=this@entry=0x7fb46f7fdc70) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:1886 #2 0x000055d3eb8234e2 in LinuxAIOHandler::poll (this=this@entry=0x7fb46f7fdc70, m1=m1@entry=0x7fb46f7fdd10, m2=m2@entry=0x7fb46f7fdd18, request=request@entry=0x7fb46f7fdd20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:2031 #3 0x000055d3eb8253e4 in os_aio_linux_handler (request=0x7fb46f7fdd20, m2=0x7fb46f7fdd18, m1=0x7fb46f7fdd10, global_segment=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:2085 #4 os_aio_handler (segment=segment@entry=5, m1=m1@entry=0x7fb46f7fdd10, m2=m2@entry=0x7fb46f7fdd18, request=request@entry=0x7fb46f7fdd20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:5683 #5 0x000055d3eb9de98a in fil_aio_wait (segment=segment@entry=5) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/fil/fil0fil.cc:5476 #6 0x000055d3eb8d0328 in io_handler_thread (arg=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0start.cc:327 #7 0x00007fb47cae06ca in start_thread (arg=0x7fb46f7fe700) at pthread_create.c:333 #8 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 25 (Thread 0x7fb447fff700 (LWP 30176)): #0 0x00007fb47cae9ced in nanosleep () at ../sysdeps/unix/syscall-template.S:84 #1 0x000055d3eb82a2b0 in os_thread_sleep (tm=tm@entry=1000000) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0thread.cc:245 #2 0x000055d3eb95d64a in btr_defragment_thread (arg=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/btr/btr0defragment.cc:771 #3 0x00007fb47cae06ca in start_thread (arg=0x7fb447fff700) at pthread_create.c:333 #4 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 24 (Thread 0x7fb4467fc700 (LWP 30179)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d3eba9814e in inline_mysql_cond_timedwait (src_file=0x55d3ebd5bac8 "/home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/maria/ma_servicethread.c", src_line=116, abstime=0x7fb4467fbdd0, mutex=0x55d3ecd449c0 <LOCK_checkpoint>, that=0x55d3ecd44980 <COND_checkpoint>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/include/mysql/psi/mysql_thread.h:1175 #2 my_service_thread_sleep (control=control@entry=0x55d3ec453360 <checkpoint_control>, sleep_time=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/maria/ma_servicethread.c:115 #3 0x000055d3eba8fc58 in ma_checkpoint_background (arg=arg@entry=0x1e) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/maria/ma_checkpoint.c:708 #4 0x000055d3ebb6a731 in pfs_spawn_thread (arg=0x55d3edfb1598) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/perfschema/pfs.cc:1862 #5 0x00007fb47cae06ca in start_thread (arg=0x7fb4467fc700) at pthread_create.c:333 #6 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 23 (Thread 0x7fb476564700 (LWP 30180)): #0 do_sigwait (sig=0x7fb476563db8, set=<optimized out>) at ../sysdeps/unix/sysv/linux/sigwait.c:64 #1 __sigwait (set=set@entry=0x7fb476563e10, sig=sig@entry=0x7fb476563db8) at ../sysdeps/unix/sysv/linux/sigwait.c:96 #2 0x000055d3eb3f89cb in signal_hand (arg=arg@entry=0x0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/mysqld.cc:3487 #3 0x000055d3ebb6a731 in pfs_spawn_thread (arg=0x55d3edde64f8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/perfschema/pfs.cc:1862 #4 0x00007fb47cae06ca in start_thread (arg=0x7fb476564700) at pthread_create.c:333 #5 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 22 (Thread 0x7fb47651a700 (LWP 30181)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d3eb416036 in inline_mysql_cond_wait (that=<optimized out>, mutex=<optimized out>, src_file=0x55d3ebc8c3b8 "/home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/slave.cc", src_line=334) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/include/mysql/psi/mysql_thread.h:1138 #2 handle_slave_background (arg=arg@entry=0x0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/slave.cc:334 #3 0x000055d3ebb6a731 in pfs_spawn_thread (arg=0x55d3ee2fc2f8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/perfschema/pfs.cc:1862 #4 0x00007fb47cae06ca in start_thread (arg=0x7fb47651a700) at pthread_create.c:333 #5 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 21 (Thread 0x7fb446ffd700 (LWP 30178)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d3eb79decd in inline_mysql_cond_wait (src_file=0x55d3ebd18e58 "/home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/handler/ha_innodb.cc", src_line=338, mutex=0x7fb446ffce40, that=0x7fb446ffce70) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/include/mysql/psi/mysql_thread.h:1149 #2 thd_destructor_proxy () at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/handler/ha_innodb.cc:338 #3 0x000055d3ebb6a731 in pfs_spawn_thread (arg=0x55d3edfab138) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/perfschema/pfs.cc:1862 #4 0x00007fb47cae06ca in start_thread (arg=0x7fb446ffd700) at pthread_create.c:333 #5 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 20 (Thread 0x7fb466ffd700 (LWP 30171)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d3eb829f66 in os_event::wait (this=0x55d3ede3a000) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=1, this=0x55d3ede3a000) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x55d3ede3a000, reset_sig_count=reset_sig_count@entry=0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055d3eb8cd0f6 in srv_resume_thread (sig_count=0, timeout_usec=0, wait=true, slot=0x55d3ede39c20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0srv.cc:954 #5 srv_worker_thread (arg=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0srv.cc:2710 #6 0x00007fb47cae06ca in start_thread (arg=0x7fb466ffd700) at pthread_create.c:333 #7 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 19 (Thread 0x7fb4657fa700 (LWP 30174)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d3eb829942 in os_event::timed_wait (this=this@entry=0x55d3edf6a570, abstime=abstime@entry=0x7fb4657f9d90) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:286 #2 0x000055d3eb829ba1 in os_event::wait_time_low (this=0x55d3edf6a570, time_in_usec=time_in_usec@entry=10000000, reset_sig_count=1, reset_sig_count@entry=0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:413 #3 0x000055d3eb829f1a in os_event_wait_time_low (event=<optimized out>, time_in_usec=time_in_usec@entry=10000000, reset_sig_count=reset_sig_count@entry=0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:518 #4 0x000055d3eb9d1fd0 in dict_stats_thread () at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/dict/dict0stats_bg.cc:420 #5 0x00007fb47cae06ca in start_thread (arg=0x7fb4657fa700) at pthread_create.c:333 #6 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 18 (Thread 0x7fb467fff700 (LWP 30169)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d3eb829f66 in os_event::wait (this=0x55d3ede39f00) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=1, this=0x55d3ede39f00) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x55d3ede39f00, reset_sig_count=reset_sig_count@entry=1) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055d3eb8ce179 in srv_resume_thread (timeout_usec=0, wait=true, sig_count=1, slot=0x55d3ede39bb0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0srv.cc:954 #5 srv_purge_coordinator_suspend (rseg_history_len=<optimized out>, slot=<optimized out>, thd=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0srv.cc:2867 #6 srv_purge_coordinator_thread (arg=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0srv.cc:2954 #7 0x00007fb47cae06ca in start_thread (arg=0x7fb467fff700) at pthread_create.c:333 #8 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 17 (Thread 0x7fb4677fe700 (LWP 30170)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d3eb829f66 in os_event::wait (this=0x55d3ede39f80) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=1, this=0x55d3ede39f80) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x55d3ede39f80, reset_sig_count=reset_sig_count@entry=0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055d3eb8cd0f6 in srv_resume_thread (sig_count=0, timeout_usec=0, wait=true, slot=0x55d3ede39be8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0srv.cc:954 #5 srv_worker_thread (arg=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0srv.cc:2710 #6 0x00007fb47cae06ca in start_thread (arg=0x7fb4677fe700) at pthread_create.c:333 #7 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 16 (Thread 0x7fb47d533040 (LWP 30155)): #0 0x00007fb47c17d0bd in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x00007fb47c19b22e in __poll_chk (fds=<optimized out>, nfds=<optimized out>, timeout=<optimized out>, fdslen=<optimized out>) at poll_chk.c:27 #2 0x000055d3eb3fa93f in poll (__timeout=-1, __nfds=2, __fds=0x7ffeb55f5db0) at /usr/include/x86_64-linux-gnu/bits/poll2.h:41 #3 handle_connections_sockets () at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/mysqld.cc:6556 #4 0x000055d3eb402fe6 in mysqld_main (argc=<optimized out>, argv=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/mysqld.cc:6022 #5 0x00007fb47c0a13f1 in __libc_start_main (main=0x55d3eb3e2040 <main(int, char**)>, argc=23, argv=0x7ffeb55f66a8, init=<optimized out>, fini=<optimized out>, rtld_fini=<optimized out>, stack_end=0x7ffeb55f6698) at ../csu/libc-start.c:291 #6 0x000055d3eb3f66aa in _start ()   Thread 15 (Thread 0x7fb464ff9700 (LWP 30175)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d3eb829942 in os_event::timed_wait (this=this@entry=0x55d3edfaaa80, abstime=abstime@entry=0x7fb464ff8c20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:286 #2 0x000055d3eb829ba1 in os_event::wait_time_low (this=0x55d3edfaaa80, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=reset_sig_count@entry=1) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:413 #3 0x000055d3eb829f1a in os_event_wait_time_low (event=<optimized out>, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=reset_sig_count@entry=1) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:518 #4 0x000055d3eb929682 in ib_wqueue_timedwait (wq=wq@entry=0x55d3edf970c0, wait_in_usecs=wait_in_usecs@entry=5000000) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/ut/ut0wqueue.cc:163 #5 0x000055d3eba27256 in fts_optimize_thread (arg=0x55d3edf970c0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/fts/fts0opt.cc:3041 #6 0x00007fb47cae06ca in start_thread (arg=0x7fb464ff9700) at pthread_create.c:333 #7 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 14 (Thread 0x7fb4477fe700 (LWP 30177)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d3eb829f66 in os_event::wait (this=0x55d3ede3a300) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=1, this=0x55d3ede3a300) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x55d3ede3a300, reset_sig_count=reset_sig_count@entry=0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055d3eb96c52c in buf_resize_thread () at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/buf/buf0buf.cc:3065 #5 0x00007fb47cae06ca in start_thread (arg=0x7fb4477fe700) at pthread_create.c:333 #6 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 13 (Thread 0x7fb4667fc700 (LWP 30172)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d3eb829f66 in os_event::wait (this=0x55d3ede3a080) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=1, this=0x55d3ede3a080) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x55d3ede3a080, reset_sig_count=reset_sig_count@entry=0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055d3eb8cd0f6 in srv_resume_thread (sig_count=0, timeout_usec=0, wait=true, slot=0x55d3ede39c58) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0srv.cc:954 #5 srv_worker_thread (arg=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0srv.cc:2710 #6 0x00007fb47cae06ca in start_thread (arg=0x7fb4667fc700) at pthread_create.c:333 #7 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 12 (Thread 0x7fb46e7fc700 (LWP 30165)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d3eb829942 in os_event::timed_wait (this=this@entry=0x55d3edf573f0, abstime=abstime@entry=0x7fb46e7fbd80) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:286 #2 0x000055d3eb829ba1 in os_event::wait_time_low (this=this@entry=0x55d3edf573f0, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=1) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:413 #3 0x000055d3eb829f1a in os_event_wait_time_low (event=event@entry=0x55d3edf573f0, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:518 #4 0x000055d3eb7f4ad0 in lock_wait_timeout_thread () at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/lock/lock0wait.cc:529 #5 0x00007fb47cae06ca in start_thread (arg=0x7fb46e7fc700) at pthread_create.c:333 #6 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 11 (Thread 0x7fb465ffb700 (LWP 30173)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d3eb829f66 in os_event::wait (this=0x55d3ede3a200) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=1, this=0x55d3ede3a200) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x55d3ede3a200, reset_sig_count=reset_sig_count@entry=0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055d3eb976847 in buf_dump_thread () at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/buf/buf0dump.cc:815 #5 0x00007fb47cae06ca in start_thread (arg=0x7fb465ffb700) at pthread_create.c:333 #6 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 10 (Thread 0x7fb476341700 (LWP 30157)): #0 0x00007fb47d13364a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d3eb81ded1 in LinuxAIOHandler::collect (this=this@entry=0x7fb476340c70) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:1886 #2 0x000055d3eb8234e2 in LinuxAIOHandler::poll (this=this@entry=0x7fb476340c70, m1=m1@entry=0x7fb476340d10, m2=m2@entry=0x7fb476340d18, request=request@entry=0x7fb476340d20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:2031 #3 0x000055d3eb8253e4 in os_aio_linux_handler (request=0x7fb476340d20, m2=0x7fb476340d18, m1=0x7fb476340d10, global_segment=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:2085 #4 os_aio_handler (segment=segment@entry=0, m1=m1@entry=0x7fb476340d10, m2=m2@entry=0x7fb476340d18, request=request@entry=0x7fb476340d20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:5683 #5 0x000055d3eb9de98a in fil_aio_wait (segment=segment@entry=0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/fil/fil0fil.cc:5476 #6 0x000055d3eb8d0328 in io_handler_thread (arg=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0start.cc:327 #7 0x00007fb47cae06ca in start_thread (arg=0x7fb476341700) at pthread_create.c:333 #8 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 9 (Thread 0x7fb474b3e700 (LWP 30160)): #0 0x00007fb47d13364a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d3eb81ded1 in LinuxAIOHandler::collect (this=this@entry=0x7fb474b3dc70) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:1886 #2 0x000055d3eb8234e2 in LinuxAIOHandler::poll (this=this@entry=0x7fb474b3dc70, m1=m1@entry=0x7fb474b3dd10, m2=m2@entry=0x7fb474b3dd18, request=request@entry=0x7fb474b3dd20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:2031 #3 0x000055d3eb8253e4 in os_aio_linux_handler (request=0x7fb474b3dd20, m2=0x7fb474b3dd18, m1=0x7fb474b3dd10, global_segment=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:2085 #4 os_aio_handler (segment=segment@entry=3, m1=m1@entry=0x7fb474b3dd10, m2=m2@entry=0x7fb474b3dd18, request=request@entry=0x7fb474b3dd20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:5683 #5 0x000055d3eb9de98a in fil_aio_wait (segment=segment@entry=3) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/fil/fil0fil.cc:5476 #6 0x000055d3eb8d0328 in io_handler_thread (arg=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0start.cc:327 #7 0x00007fb47cae06ca in start_thread (arg=0x7fb474b3e700) at pthread_create.c:333 #8 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 8 (Thread 0x7fb475b40700 (LWP 30158)): #0 0x00007fb47d13364a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d3eb81ded1 in LinuxAIOHandler::collect (this=this@entry=0x7fb475b3fc70) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:1886 #2 0x000055d3eb8234e2 in LinuxAIOHandler::poll (this=this@entry=0x7fb475b3fc70, m1=m1@entry=0x7fb475b3fd10, m2=m2@entry=0x7fb475b3fd18, request=request@entry=0x7fb475b3fd20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:2031 #3 0x000055d3eb8253e4 in os_aio_linux_handler (request=0x7fb475b3fd20, m2=0x7fb475b3fd18, m1=0x7fb475b3fd10, global_segment=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:2085 #4 os_aio_handler (segment=segment@entry=1, m1=m1@entry=0x7fb475b3fd10, m2=m2@entry=0x7fb475b3fd18, request=request@entry=0x7fb475b3fd20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:5683 #5 0x000055d3eb9de98a in fil_aio_wait (segment=segment@entry=1) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/fil/fil0fil.cc:5476 #6 0x000055d3eb8d0328 in io_handler_thread (arg=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0start.cc:327 #7 0x00007fb47cae06ca in start_thread (arg=0x7fb475b40700) at pthread_create.c:333 #8 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 7 (Thread 0x7fb46d7fa700 (LWP 30167)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d3eb829942 in os_event::timed_wait (this=this@entry=0x55d3ede3a180, abstime=abstime@entry=0x7fb46d7f9e90) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:286 #2 0x000055d3eb829ba1 in os_event::wait_time_low (this=0x55d3ede3a180, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=1) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:413 #3 0x000055d3eb829f1a in os_event_wait_time_low (event=<optimized out>, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:518 #4 0x000055d3eb8cb964 in srv_monitor_thread () at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0srv.cc:1775 #5 0x00007fb47cae06ca in start_thread (arg=0x7fb46d7fa700) at pthread_create.c:333 #6 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 6 (Thread 0x7fb477d86700 (LWP 30156)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d3ebbba7a1 in inline_mysql_cond_timedwait (that=0x55d3ecd54420 <COND_timer>, mutex=0x55d3ecd54460 <LOCK_timer>, src_file=0x55d3ebd704e8 "/home/a/test1/mariadb-environs/_depot/m-branch/10.2/mysys/thr_timer.c", src_line=292, abstime=0x7fb477d85e60) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/include/mysql/psi/mysql_thread.h:1175 #2 timer_handler (arg=arg@entry=0x0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/mysys/thr_timer.c:292 #3 0x000055d3ebb6a731 in pfs_spawn_thread (arg=0x55d3edde0368) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/perfschema/pfs.cc:1862 #4 0x00007fb47cae06ca in start_thread (arg=0x7fb477d86700) at pthread_create.c:333 #5 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 5 (Thread 0x7fb46effd700 (LWP 30163)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d3eb829942 in os_event::timed_wait (this=this@entry=0x55d3ede3a280, abstime=abstime@entry=0x7fb46effcb30) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:286 #2 0x000055d3eb829ba1 in os_event::wait_time_low (this=0x55d3ede3a280, time_in_usec=<optimized out>, reset_sig_count=reset_sig_count@entry=2) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:413 #3 0x000055d3eb829f1a in os_event_wait_time_low (event=<optimized out>, time_in_usec=<optimized out>, reset_sig_count=reset_sig_count@entry=2) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:518 #4 0x000055d3eb981de2 in pc_sleep_if_needed (sig_count=2, next_loop_time=1494000754785) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/buf/buf0flu.cc:2711 #5 buf_flush_page_cleaner_coordinator (arg=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/buf/buf0flu.cc:3213 #6 0x00007fb47cae06ca in start_thread (arg=0x7fb46effd700) at pthread_create.c:333 #7 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 4 (Thread 0x7fb46ffff700 (LWP 30161)): #0 0x00007fb47d13364a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d3eb81ded1 in LinuxAIOHandler::collect (this=this@entry=0x7fb46fffec70) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:1886 #2 0x000055d3eb8234e2 in LinuxAIOHandler::poll (this=this@entry=0x7fb46fffec70, m1=m1@entry=0x7fb46fffed10, m2=m2@entry=0x7fb46fffed18, request=request@entry=0x7fb46fffed20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:2031 #3 0x000055d3eb8253e4 in os_aio_linux_handler (request=0x7fb46fffed20, m2=0x7fb46fffed18, m1=0x7fb46fffed10, global_segment=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:2085 #4 os_aio_handler (segment=segment@entry=4, m1=m1@entry=0x7fb46fffed10, m2=m2@entry=0x7fb46fffed18, request=request@entry=0x7fb46fffed20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:5683 #5 0x000055d3eb9de98a in fil_aio_wait (segment=segment@entry=4) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/fil/fil0fil.cc:5476 #6 0x000055d3eb8d0328 in io_handler_thread (arg=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0start.cc:327 #7 0x00007fb47cae06ca in start_thread (arg=0x7fb46ffff700) at pthread_create.c:333 #8 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 3 (Thread 0x7fb46dffb700 (LWP 30166)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d3eb829942 in os_event::timed_wait (this=this@entry=0x55d3ede3a100, abstime=abstime@entry=0x7fb46dffac60) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:286 #2 0x000055d3eb829ba1 in os_event::wait_time_low (this=0x55d3ede3a100, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=1) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:413 #3 0x000055d3eb829f1a in os_event_wait_time_low (event=<optimized out>, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0event.cc:518 #4 0x000055d3eb8caba4 in srv_error_monitor_thread () at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0srv.cc:2000 #5 0x00007fb47cae06ca in start_thread (arg=0x7fb46dffb700) at pthread_create.c:333 #6 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 2 (Thread 0x7fb47533f700 (LWP 30159)): #0 0x00007fb47d13364a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d3eb81ded1 in LinuxAIOHandler::collect (this=this@entry=0x7fb47533ec70) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:1886 #2 0x000055d3eb8234e2 in LinuxAIOHandler::poll (this=this@entry=0x7fb47533ec70, m1=m1@entry=0x7fb47533ed10, m2=m2@entry=0x7fb47533ed18, request=request@entry=0x7fb47533ed20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:2031 #3 0x000055d3eb8253e4 in os_aio_linux_handler (request=0x7fb47533ed20, m2=0x7fb47533ed18, m1=0x7fb47533ed10, global_segment=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:2085 #4 os_aio_handler (segment=segment@entry=2, m1=m1@entry=0x7fb47533ed10, m2=m2@entry=0x7fb47533ed18, request=request@entry=0x7fb47533ed20) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/os/os0file.cc:5683 #5 0x000055d3eb9de98a in fil_aio_wait (segment=segment@entry=2) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/fil/fil0fil.cc:5476 #6 0x000055d3eb8d0328 in io_handler_thread (arg=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0start.cc:327 #7 0x00007fb47cae06ca in start_thread (arg=0x7fb47533f700) at pthread_create.c:333 #8 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   Thread 1 (Thread 0x7fb476486700 (LWP 30189)): #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 #1 0x000055d3ebbb5d07 in my_write_core (sig=sig@entry=6) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/mysys/stacktrace.c:477 #2 0x000055d3eb6220b7 in handle_fatal_signal (sig=6) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/signal_handler.cc:299 #3 <signal handler called> #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:58 #5 0x00007fb47c0b83ea in __GI_abort () at abort.c:89 #6 0x000055d3eb3dea05 in ut_dbg_assertion_failed (expr=expr@entry=0x55d3ebd356e8 "!trx->declared_to_be_inside_innodb", file=file@entry=0x55d3ebd35690 "/home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0conc.cc", line=line@entry=126) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/ut/ut0dbg.cc:60 #7 0x000055d3eb8c42f4 in srv_conc_enter_innodb_with_atomics (trx=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/srv/srv0conc.cc:126 #8 0x000055d3eb7b3f53 in ha_innobase::general_fetch (this=0x7fb42001a380, buf=0x7fb420017e40 "\375\203\006<", direction=1, match_mode=0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/innobase/handler/ha_innodb.cc:10365 #9 0x000055d3eb626621 in handler::ha_rnd_next (this=0x7fb42001a380, buf=0x7fb420017e40 "\375\203\006<") at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/handler.cc:2584 #10 0x000055d3eb72f6d7 in rr_sequential (info=0x7fb4200133d0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/records.cc:484 #11 0x000055d3eb4c35b6 in sub_select (join=0x7fb420010048, join_tab=0x7fb420013308, end_of_records=<optimized out>) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_select.cc:18484 #12 0x000055d3eb4e1d70 in do_select (procedure=<optimized out>, join=0x7fb420010048) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_select.cc:18009 #13 JOIN::exec_inner (this=this@entry=0x7fb420010048) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_select.cc:3469 #14 0x000055d3eb4e1f13 in JOIN::exec (this=this@entry=0x7fb420010048) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_select.cc:3271 #15 0x000055d3eb4e205b in mysql_select (thd=thd@entry=0x7fb4200009a8, tables=0x7fb42000f748, wild_num=1, fields=..., conds=<optimized out>, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7fb42000ff50, unit=0x7fb420004348, select_lex=0x7fb420004a80) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_select.cc:3664 #16 0x000055d3eb4e2985 in handle_select (thd=thd@entry=0x7fb4200009a8, lex=lex@entry=0x7fb420004280, result=result@entry=0x7fb42000ff50, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_select.cc:361 #17 0x000055d3eb493bb6 in mysql_execute_command (thd=thd@entry=0x7fb4200009a8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_parse.cc:3917 #18 0x000055d3eb4946ca in mysql_parse (thd=thd@entry=0x7fb4200009a8, rawbuf=<optimized out>, length=53, parser_state=parser_state@entry=0x7fb476485210, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_parse.cc:7874 #19 0x000055d3eb497604 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fb4200009a8, packet=packet@entry=0x7fb42001de39 "CREATE TABLE tmp1 ENGINE=InnoDB SELECT * FROM payment", packet_length=packet_length@entry=53, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_parse.cc:1812 #20 0x000055d3eb497ea7 in do_command (thd=0x7fb4200009a8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_parse.cc:1361 #21 0x000055d3eb55c46a in do_handle_one_connection (connect=connect@entry=0x55d3ee2fe9e8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_connect.cc:1354 #22 0x000055d3eb55c5dd in handle_one_connection (arg=arg@entry=0x55d3ee2fe9e8) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/sql/sql_connect.cc:1260 #23 0x000055d3ebb6a731 in pfs_spawn_thread (arg=0x55d3ee2b9218) at /home/a/test1/mariadb-environs/_depot/m-branch/10.2/storage/perfschema/pfs.cc:1862 #24 0x00007fb47cae06ca in start_thread (arg=0x7fb476486700) at pthread_create.c:333 #25 0x00007fb47c1890af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105   -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 13 seconds executing testcases   Failure: Failed 1/1 tests, 0.00% were successful.   Failing test(s): innodb.innodb1   The log files in var/log may give you some hint of what went wrong.   If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html   mysql-test-run: *** ERROR: there were failing test cases

Andrii Nikitin (Inactive) added a comment - 2017-05-05 16:18 - edited The crash doesn't happen when I try to reduce amount of data in payment.sql or when use innodb_thread_concurrency=0

Jan Lindström (Inactive) added a comment - 2017-05-09 05:26 commit b246993cfc52e88a492e6284f347f93f144573fd Author: Jan Lindström <jan.lindstrom@mariadb.com> Date: Tue May 9 08:23:24 2017 +0300 MDEV-12706 : !trx->declared_to_be_inside_innodb with innodb_thread_concurrency during CREATE .. SELECT There were two calls to innobase_srv_conc_enter_innodb on ::general_fetch() due to incorrect merge of 5.7.14.