Test for update aborts #6
Description
Monday Sep 05, 2016 at 13:51 GMT
Originally opened as https://github.com/natsys/mariadb/issues/5
Present test for update aborts:
$ cd mysql-test
$ ./mysql-test-run.pl update
Logging: ./mysql-test-run.pl update
vardir: /home/faramir/Documents/obair/natsys/mariadb_10.2/mysql-test/var
...
worker[1] - 'localhost:16000' was not free
worker[1] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039
main.update 'innodb_plugin' [ fail ]
Test ended at 2016-09-05 15:43:05
CURRENT_TEST: main.update
mysqltest: At line 512: query 'CREATE TABLE t1 (a VARCHAR(50), b TEXT, c CHAR(50))
ENGINE=INNODB' failed: 2013: Lost connection to MySQL server during query
...
It seems that: CREATE TABLE t1 (a VARCHAR(50), b TEXT, c CHAR(50)) ENGINE=INNODB works in console client...
Full output of the test:
Logging: ./mysql-test-run.pl update
vardir: /home/faramir/Documents/obair/natsys/mariadb_10.2/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/faramir/Documents/obair/natsys/mariadb_10.2/mysql-test/var'...
Checking supported features...
MariaDB Version 10.2.1-MariaDB-debug
- SSL connections supported
- binaries are debug compiled
Collecting tests...
Installing system database...
==============================================================================
TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------
worker[1] - 'localhost:16000' was not free
worker[1] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039
main.update 'innodb_plugin' [ fail ]
Test ended at 2016-09-05 15:43:05
CURRENT_TEST: main.update
mysqltest: At line 512: query 'CREATE TABLE t1 (a VARCHAR(50), b TEXT, c CHAR(50)) ENGINE=INNODB' failed: 2013: Lost connection to MySQL server during query
The result from queries just before the failure was:
< snip >
SET SESSION sql_safe_updates = DEFAULT;
DROP TABLE t1;
DROP VIEW v1;
#
# Bug#54734 assert in Diagnostics_area::set_ok_status
#
DROP TABLE IF EXISTS t1, not_exists;
DROP FUNCTION IF EXISTS f1;
DROP VIEW IF EXISTS v1;
CREATE TABLE t1 (PRIMARY KEY(pk)) AS SELECT 1 AS pk;
CREATE FUNCTION f1() RETURNS INTEGER RETURN (SELECT 1 FROM not_exists);
CREATE VIEW v1 AS SELECT pk FROM t1 WHERE f1() = 13;
UPDATE v1 SET pk = 7 WHERE pk > 0;
ERROR HY000: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
DROP VIEW v1;
DROP FUNCTION f1;
DROP TABLE t1;
# Bug #21143080: UPDATE ON VARCHAR AND TEXT COLUMNS PRODUCE INCORRECT
# RESULTS
CREATE TABLE t1 (a VARCHAR(50), b TEXT, c CHAR(50)) ENGINE=INNODB;
More results from queries before failure can be found in /home/faramir/Documents/obair/natsys/mariadb_10.2/mysql-test/var/log/update.log
Server [mysqld.1 - pid: 13670, winpid: 13670, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
2016-09-05 15:43:03 139979670501312 [Note] /home/faramir/Documents/obair/natsys/mariadb_10.2/sql/mysqld (mysqld 10.2.1-MariaDB-debug) starting as process 13671 ...
2016-09-05 15:43:03 139979670501312 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4162)
2016-09-05 15:43:03 139979670501312 [Note] Plugin 'BLACKHOLE' is disabled.
2016-09-05 15:43:03 139979670501312 [Note] Plugin 'partition' is disabled.
2016-09-05 15:43:03 139979670501312 [Note] Plugin 'ARCHIVE' is disabled.
2016-09-05 15:43:03 139979670501312 [Note] Plugin 'SEQUENCE' is disabled.
2016-09-05 15:43:03 139979670501312 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-05 15:43:03 139979670501312 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2016-09-05 15:43:03 139979670501312 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
2016-09-05 15:43:03 139979670501312 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-05 15:43:03 139979670501312 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-09-05 15:43:03 139979670501312 [Note] InnoDB: Memory barrier is not used
2016-09-05 15:43:03 139979670501312 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-05 15:43:03 139979670501312 [Note] InnoDB: Using Linux native AIO
2016-09-05 15:43:03 139979670501312 [Note] InnoDB: Using SSE crc32 instructions
2016-09-05 15:43:03 139979670501312 [Note] InnoDB: Initializing buffer pool, size = 8.0M
2016-09-05 15:43:03 139979670501312 [Note] InnoDB: Completed initialization of buffer pool
2016-09-05 15:43:03 139979670501312 [Note] InnoDB: Highest supported file format is Barracuda.
2016-09-05 15:43:04 139979670501312 [Note] InnoDB: 128 rollback segment(s) are active.
2016-09-05 15:43:04 139979670501312 [Note] InnoDB: Waiting for purge to start
2016-09-05 15:43:04 139979670501312 [Note] InnoDB: 5.6.29 started; log sequence number 1629546
2016-09-05 15:43:05 139979359516416 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'FEDERATED' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_CMP' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'XTRADB_READ_VIEW' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'XTRADB_RSEG' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'CHANGED_PAGE_BITMAPS' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'XTRADB_INTERNAL_HASH_TABLES' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_MUTEXES' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
2016-09-05 15:43:05 139979670501312 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
2016-09-05 15:43:05 139979670501312 [Warning] /home/faramir/Documents/obair/natsys/mariadb_10.2/sql/mysqld: unknown option '--loose-skip-plugin-innodb-changed-pages'
2016-09-05 15:43:05 139979670501312 [Note] Server socket created on IP: '127.0.0.1'.
2016-09-05 15:43:05 139979670501312 [Note] /home/faramir/Documents/obair/natsys/mariadb_10.2/sql/mysqld: ready for connections.
Version: '10.2.1-MariaDB-debug' socket: '/home/faramir/Documents/obair/natsys/mariadb_10.2/mysql-test/var/tmp/mysqld.1.sock' port: 16020 MariaDB Server
2016-09-05 15:43:05 7f4f8e838f00 InnoDB: Assertion failure in thread 139979670130432 in file ha_innodb.cc line 6742
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.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
160905 15:43:05 [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.1-MariaDB-debug
key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=2
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 = 63026 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x0x7f4f76852070
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 = 0x7f4f8e8385c8 thread_stack 0x48800
/home/faramir/Documents/obair/natsys/mariadb_10.2/sql/mysqld(my_print_stacktrace+0x2b)[0x7f4f8e0a0372]
/home/faramir/Documents/obair/natsys/mariadb_10.2/sql/mysqld(handle_fatal_signal+0x301)[0x7f4f8dadc144]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x10330)[0x7f4f8c831330]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7f4f8be88c37]
mysys/stacktrace.c:246(my_print_stacktrace)[0x7f4f8be8c028]
/home/faramir/Documents/obair/natsys/mariadb_10.2/mysql-test/var/plugins/ha_innodb.so(+0x148dc4)[0x7f4f85382dc4]
/home/faramir/Documents/obair/natsys/mariadb_10.2/mysql-test/var/plugins/ha_innodb.so(+0x157204)[0x7f4f85391204]
sql/handler.cc:4315(handler::ha_create(char const*, TABLE*, HA_CREATE_INFO*))[0x7f4f8dae5354]
sql/handler.cc:4686(ha_create_table(THD*, char const*, char const*, char const*, HA_CREATE_INFO*, st_mysql_const_unsigned_lex_string*))[0x7f4f8dae5e2e]
sql/unireg.cc:474(rea_create_table(THD*, st_mysql_const_unsigned_lex_string*, char const*, char const*, char const*, HA_CREATE_INFO*, handler*, bool))[0x7f4f8d9e150d]
sql/sql_table.cc:4972(create_table_impl)[0x7f4f8d9ac65e]
sql/sql_table.cc:5089(mysql_create_table_no_lock(THD*, char const*, char const*, Table_specification_st*, Alter_info*, bool*, int))[0x7f4f8d9acc32]
sql/sql_table.cc:5153(mysql_create_table(THD*, TABLE_LIST*, Table_specification_st*, Alter_info*))[0x7f4f8d9ad029]
sql/sql_parse.cc:3850(mysql_execute_command(THD*))[0x7f4f8d913f85]
sql/sql_parse.cc:7789(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x7f4f8d91c506]
sql/sql_parse.cc:1790(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x7f4f8d91e73f]
sql/sql_parse.cc:1351(do_command(THD*))[0x7f4f8d921077]
sql/sql_connect.cc:1358(do_handle_one_connection(CONNECT*))[0x7f4f8da03213]
sql/sql_connect.cc:1266(handle_one_connection)[0x7f4f8da033fc]
/home/faramir/Documents/obair/natsys/mariadb_10.2/sql/mysqld(+0xb4bea6)[0x7f4f8dffeea6]
perfschema/pfs.cc:1865(pfs_spawn_thread)[0x7f4f8c829184]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f4f8bf4c37d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7f4f76923088): CREATE TABLE t1 (a VARCHAR(50), b TEXT, c CHAR(50)) ENGINE=INNODB
Connection ID (thread ID): 3
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
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/faramir/Documents/obair/natsys/mariadb_10.2/mysql-test/var/log/main.update-innodb_plugin/' to '/home/faramir/Documents/obair/natsys/mariadb_10.2/mysql-test/var/log/main.update-innodb_plugin/'
- found 'core' (0/5)
Trying 'dbx' to get a backtrace
Trying 'gdb' to get a backtrace
Core generated by '/home/faramir/Documents/obair/natsys/mariadb_10.2/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 13695]
[New LWP 13675]
[New LWP 13676]
[New LWP 13698]
[New LWP 13672]
[New LWP 13674]
[New LWP 13673]
[New LWP 13688]
[New LWP 13681]
[New LWP 13678]
[New LWP 13682]
[New LWP 13684]
[New LWP 13677]
[New LWP 13680]
[New LWP 13687]
[New LWP 13691]
[New LWP 13686]
[New LWP 13683]
[New LWP 13689]
[New LWP 13671]
[New LWP 13685]
[New LWP 13690]
[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/faramir/Documents/obair/natsys/mariadb_10.2/sql/mysqld --defaults-group-s'.
Program terminated with signal SIGABRT, Aborted.
#0 0x00007f4f8c82e611 in __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61 ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
#0 0x00007f4f8c82e611 in __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x00007f4f8e09ff73 in my_write_core (sig=6) at /home/faramir/Documents/epona/natsys/mariadb_10.2/mysys/stacktrace.c:456
#2 0x00007f4f8dadc3a3 in handle_fatal_signal (sig=6) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/signal_handler.cc:272
#3 <signal handler called>
#4 0x00007f4f8be88c37 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007f4f8be8c028 in __GI_abort () at abort.c:89
#6 0x00007f4f85382dc4 in get_innobase_type_from_mysql_type (unsigned_flag=unsigned_flag@entry=0x7f4f8e832dd8, f=f@entry=0x7f4f7682b720) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/handler/ha_innodb.cc:6742
#7 0x00007f4f85391204 in create_table_check_doc_id_col (doc_id_col=<synthetic pointer>, form=0x7f4f8e833770, trx=0x7f4f76872078) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/handler/ha_innodb.cc:10570
#8 create_table_def (key_id=1, mode=FIL_SPACE_ENCRYPTION_DEFAULT, flags2=80, flags=1, remote_path=0x7f4f8e833220 "", temp_path=0x7f4f8e833020 "", table_name=0x7f4f8e832e20 "test/t1", form=0x7f4f8e833770, trx=0x7f4f76872078) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/handler/ha_innodb.cc:10674
#9 ha_innodb::create (this=<optimized out>, name=<optimized out>, form=0x7f4f8e833770, create_info=0x7f4f8e836400) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/handler/ha_innodb.cc:11949
#10 0x00007f4f8dae5354 in handler::ha_create (this=0x7f4f76889888, name=0x7f4f8e835f70 "./test/t1", form=form@entry=0x7f4f8e833770, info_arg=info_arg@entry=0x7f4f8e836400) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/handler.cc:4315
#11 0x00007f4f8dae5e2e in ha_create_table (thd=thd@entry=0x7f4f76852070, path=path@entry=0x7f4f8e835f70 "./test/t1", db=db@entry=0x7f4f769237d0 "test", table_name=table_name@entry=0x7f4f76923180 "t1", create_info=create_info@entry=0x7f4f8e836400, frm=frm@entry=0x7f4f8e835f60) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/handler.cc:4686
#12 0x00007f4f8d9e150d in rea_create_table (thd=thd@entry=0x7f4f76852070, frm=frm@entry=0x7f4f8e835f60, path=path@entry=0x7f4f8e835f70 "./test/t1", db=db@entry=0x7f4f769237d0 "test", table_name=table_name@entry=0x7f4f76923180 "t1", create_info=create_info@entry=0x7f4f8e836400, file=file@entry=0x7f4f76923ee8, no_ha_create_table=no_ha_create_table@entry=false) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/unireg.cc:474
#13 0x00007f4f8d9ac65e in create_table_impl (thd=thd@entry=0x7f4f76852070, orig_db=orig_db@entry=0x7f4f769237d0 "test", orig_table_name=orig_table_name@entry=0x7f4f76923180 "t1", db=<optimized out>, db@entry=0x7f4f769237d0 "test", table_name=<optimized out>, table_name@entry=0x7f4f76923180 "t1", path=path@entry=0x7f4f8e835f70 "./test/t1", options=..., create_info=create_info@entry=0x7f4f8e836400, alter_info=alter_info@entry=0x7f4f8e836370, create_table_mode=create_table_mode@entry=0, is_trans=is_trans@entry=0x7f4f8e83621f, key_info=key_info@entry=0x7f4f8e835f58, key_count=key_count@entry=0x7f4f8e835f54, frm=frm@entry=0x7f4f8e835f60) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_table.cc:4973
#14 0x00007f4f8d9acc32 in mysql_create_table_no_lock (thd=thd@entry=0x7f4f76852070, db=db@entry=0x7f4f769237d0 "test", table_name=table_name@entry=0x7f4f76923180 "t1", create_info=create_info@entry=0x7f4f8e836400, alter_info=alter_info@entry=0x7f4f8e836370, is_trans=is_trans@entry=0x7f4f8e83621f, create_table_mode=create_table_mode@entry=0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_table.cc:5089
#15 0x00007f4f8d9ad029 in mysql_create_table (thd=thd@entry=0x7f4f76852070, create_table=create_table@entry=0x7f4f769231b8, create_info=create_info@entry=0x7f4f8e836400, alter_info=alter_info@entry=0x7f4f8e836370) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_table.cc:5154
#16 0x00007f4f8d913f85 in mysql_execute_command (thd=thd@entry=0x7f4f76852070) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_parse.cc:3850
#17 0x00007f4f8d91c506 in mysql_parse (thd=thd@entry=0x7f4f76852070, rawbuf=<optimized out>, length=65, parser_state=parser_state@entry=0x7f4f8e837940, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_parse.cc:7789
#18 0x00007f4f8d91e73f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f4f76852070, packet=packet@entry=0x7f4f76919071 "CREATE TABLE t1 (a VARCHAR(50), b TEXT, c CHAR(50)) ENGINE=INNODB", packet_length=packet_length@entry=65, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_parse.cc:1790
#19 0x00007f4f8d921077 in do_command (thd=0x7f4f76852070) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_parse.cc:1351
#20 0x00007f4f8da03213 in do_handle_one_connection (connect=connect@entry=0x7f4f8b472ef0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_connect.cc:1358
#21 0x00007f4f8da033fc in handle_one_connection (arg=arg@entry=0x7f4f8b472ef0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_connect.cc:1264
#22 0x00007f4f8dffeea6 in pfs_spawn_thread (arg=0x7f4f84755370) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/perfschema/pfs.cc:1862
#23 0x00007f4f8c829184 in start_thread (arg=0x7f4f8e838f00) at pthread_create.c:312
#24 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 22 (Thread 0x7f4f787ff700 (LWP 13690)):
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1 0x00007f4f8e0a55ae in safe_cond_timedwait (cond=cond@entry=0x7f4f8f2541a0 <COND_checkpoint>, mp=mp@entry=0x7f4f8f2541e0 <LOCK_checkpoint>, abstime=abstime@entry=0x7f4f787fed60, file=file@entry=0x7f4f8e161638 "/home/faramir/Documents/epona/natsys/mariadb_10.2/include/mysql/psi/mysql_thread.h", line=line@entry=1175) at /home/faramir/Documents/epona/natsys/mariadb_10.2/mysys/thr_mutex.c:545
#2 0x00007f4f8dca3bff in inline_mysql_cond_timedwait (src_line=119, src_file=0x7f4f8e275568 "/home/faramir/Documents/epona/natsys/mariadb_10.2/storage/maria/ma_servicethread.c", abstime=0x7f4f787fed60, mutex=0x7f4f8f2541e0 <LOCK_checkpoint>, that=0x7f4f8f2541a0 <COND_checkpoint>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/include/mysql/psi/mysql_thread.h:1175
#3 my_service_thread_sleep (control=control@entry=0x7f4f8e9ac2b0 <checkpoint_control>, sleep_time=sleep_time@entry=29000000000) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/maria/ma_servicethread.c:118
#4 0x00007f4f8dc9c060 in ma_checkpoint_background (arg=arg@entry=0x1e) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/maria/ma_checkpoint.c:711
#5 0x00007f4f8dffeea6 in pfs_spawn_thread (arg=0x7f4f84752df0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/perfschema/pfs.cc:1862
#6 0x00007f4f8c829184 in start_thread (arg=0x7f4f787ff700) at pthread_create.c:312
#7 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 21 (Thread 0x7f4f7d3ff700 (LWP 13685)):
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1 0x00007f4f85402cda in os_cond_wait_timed (abstime=0x7f4f7d3fed80, fast_mutex=0x7f4f86b82d00, cond=0x7f4f86b82d40) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:177
#2 os_event_wait_time_low (event=0x7f4f86b82d00, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=1) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:705
#3 0x00007f4f852c4f22 in page_cleaner_sleep_if_needed (next_loop_time=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/buf/buf0flu.cc:2274
#4 buf_flush_page_cleaner_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/buf/buf0flu.cc:2310
#5 0x00007f4f8c829184 in start_thread (arg=0x7f4f7d3ff700) at pthread_create.c:312
#6 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 20 (Thread 0x7f4f8e8937c0 (LWP 13671)):
#0 0x00007f4f8bf3efdd in poll () at ../sysdeps/unix/syscall-template.S:81
#1 0x00007f4f8d86d34b in poll (__timeout=-1, __nfds=2, __fds=0x7ffc8529fc50) at /usr/include/x86_64-linux-gnu/bits/poll2.h:41
#2 handle_connections_sockets () at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/mysqld.cc:6577
#3 0x00007f4f8d87683e in mysqld_main (argc=146, argv=0x7f4f8b45dac0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/mysqld.cc:6044
#4 0x00007f4f8d8670ae in main (argc=<optimized out>, argv=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/main.cc:25
Thread 19 (Thread 0x7f4f7a7fc700 (LWP 13689)):
#0 0x00007f4f8bf43c53 in select () at ../sysdeps/unix/syscall-template.S:81
#1 0x00007f4f854038d7 in os_thread_sleep (tm=tm@entry=1000000) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0thread.cc:261
#2 0x00007f4f852a3327 in btr_defragment_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/btr/btr0defragment.cc:758
#3 0x00007f4f8c829184 in start_thread (arg=0x7f4f7a7fc700) at pthread_create.c:312
#4 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 18 (Thread 0x7f4f7ebfd700 (LWP 13683)):
#0 0x00007f4f8bf43c53 in select () at ../sysdeps/unix/syscall-template.S:81
#1 0x00007f4f854038d7 in os_thread_sleep (tm=tm@entry=1000000) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0thread.cc:261
#2 0x00007f4f854d1684 in srv_master_sleep () at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/srv/srv0srv.cc:2514
#3 srv_master_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/srv/srv0srv.cc:2558
#4 0x00007f4f8c829184 in start_thread (arg=0x7f4f7ebfd700) at pthread_create.c:312
#5 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 17 (Thread 0x7f4f7bfff700 (LWP 13686)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
#1 0x00007f4f85402b2b in os_cond_wait (fast_mutex=0x7f4f87ffed80, cond=0x7f4f87ffedc0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:214
#2 os_event_wait_low (event=0x7f4f87ffed80, reset_sig_count=1, reset_sig_count@entry=0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:592
#3 0x00007f4f852bd847 in buf_dump_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/buf/buf0dump.cc:703
#4 0x00007f4f8c829184 in start_thread (arg=0x7f4f7bfff700) at pthread_create.c:312
#5 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 16 (Thread 0x7f4f8e882f00 (LWP 13691)):
#0 0x00007f4f8c8310c1 in do_sigwait (sig=0x7f4f8e882518, set=<optimized out>) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:60
#1 __sigwait (set=0x7f4f8e882590, sig=0x7f4f8e882518) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:97
#2 0x00007f4f8d86b16d in signal_hand (arg=arg@entry=0x0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/mysqld.cc:3557
#3 0x00007f4f8dffeea6 in pfs_spawn_thread (arg=0x7f4f847532f0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/perfschema/pfs.cc:1862
#4 0x00007f4f8c829184 in start_thread (arg=0x7f4f8e882f00) at pthread_create.c:312
#5 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 15 (Thread 0x7f4f7b7fe700 (LWP 13687)):
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1 0x00007f4f85402cda in os_cond_wait_timed (abstime=0x7f4f7b7fdd90, fast_mutex=0x7f4f86b83880, cond=0x7f4f86b838c0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:177
#2 os_event_wait_time_low (event=0x7f4f86b83880, time_in_usec=time_in_usec@entry=10000000, reset_sig_count=1, reset_sig_count@entry=0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:705
#3 0x00007f4f85317236 in dict_stats_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/dict/dict0stats_bg.cc:545
#4 0x00007f4f8c829184 in start_thread (arg=0x7f4f7b7fe700) at pthread_create.c:312
#5 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 14 (Thread 0x7f4f7fbff700 (LWP 13680)):
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1 0x00007f4f85402cda in os_cond_wait_timed (abstime=0x7f4f7fbfed90, fast_mutex=0x7f4f86b83180, cond=0x7f4f86b831c0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:177
#2 os_event_wait_time_low (event=event@entry=0x7f4f86b83180, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=1, reset_sig_count@entry=0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:705
#3 0x00007f4f853da598 in lock_wait_timeout_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/lock/lock0wait.cc:536
#4 0x00007f4f8c829184 in start_thread (arg=0x7f4f7fbff700) at pthread_create.c:312
#5 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 13 (Thread 0x7f4f823fb700 (LWP 13677)):
#0 0x00007f4f8ce7c58a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1 0x00007f4f85401061 in os_aio_linux_collect (seg_size=256, segment=0, array=0x7f4f873f4150) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0file.cc:5349
#2 os_aio_linux_handle (global_seg=global_seg@entry=4, message1=message1@entry=0x7f4f823fae48, message2=message2@entry=0x7f4f823fae50, type=type@entry=0x7f4f823fae58) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0file.cc:5501
#3 0x00007f4f85329c5c in fil_aio_wait (segment=segment@entry=4) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/fil/fil0fil.cc:5982
#4 0x00007f4f854d5f1a in io_handler_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/srv/srv0start.cc:515
#5 0x00007f4f8c829184 in start_thread (arg=0x7f4f823fb700) at pthread_create.c:312
#6 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 12 (Thread 0x7f4f7e3fc700 (LWP 13684)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
#1 0x00007f4f85402b2b in os_cond_wait (fast_mutex=0x7f4f87ffec00, cond=0x7f4f87ffec40) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:214
#2 os_event_wait_low (event=0x7f4f87ffec00, reset_sig_count=reset_sig_count@entry=1) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:592
#3 0x00007f4f854d2428 in srv_purge_coordinator_suspend (rseg_history_len=<optimized out>, slot=0x7f4f86fcfe80) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/srv/srv0srv.cc:2848
#4 srv_purge_coordinator_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/srv/srv0srv.cc:2967
#5 0x00007f4f8c829184 in start_thread (arg=0x7f4f7e3fc700) at pthread_create.c:312
#6 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 11 (Thread 0x7f4f7f3fe700 (LWP 13682)):
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1 0x00007f4f85402cda in os_cond_wait_timed (abstime=0x7f4f7f3fddd0, fast_mutex=0x7f4f87ffed00, cond=0x7f4f87ffed40) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:177
#2 os_event_wait_time_low (event=0x7f4f87ffed00, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=1) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:705
#3 0x00007f4f854d0406 in srv_monitor_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/srv/srv0srv.cc:1727
#4 0x00007f4f8c829184 in start_thread (arg=0x7f4f7f3fe700) at pthread_create.c:312
#5 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 10 (Thread 0x7f4f81bfa700 (LWP 13678)):
#0 0x00007f4f8ce7c58a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1 0x00007f4f85401061 in os_aio_linux_collect (seg_size=256, segment=1, array=0x7f4f873f4150) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0file.cc:5349
#2 os_aio_linux_handle (global_seg=global_seg@entry=5, message1=message1@entry=0x7f4f81bf9e48, message2=message2@entry=0x7f4f81bf9e50, type=type@entry=0x7f4f81bf9e58) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0file.cc:5501
#3 0x00007f4f85329c5c in fil_aio_wait (segment=segment@entry=5) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/fil/fil0fil.cc:5982
#4 0x00007f4f854d5f1a in io_handler_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/srv/srv0start.cc:515
#5 0x00007f4f8c829184 in start_thread (arg=0x7f4f81bfa700) at pthread_create.c:312
#6 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 9 (Thread 0x7f4f80bff700 (LWP 13681)):
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1 0x00007f4f85402cda in os_cond_wait_timed (abstime=0x7f4f80bfed70, fast_mutex=0x7f4f87ffec80, cond=0x7f4f87ffecc0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:177
#2 os_event_wait_time_low (event=0x7f4f87ffec80, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=1) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:705
#3 0x00007f4f854d0d15 in srv_error_monitor_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/srv/srv0srv.cc:1973
#4 0x00007f4f8c829184 in start_thread (arg=0x7f4f80bff700) at pthread_create.c:312
#5 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 8 (Thread 0x7f4f7affd700 (LWP 13688)):
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1 0x00007f4f85402cda in os_cond_wait_timed (abstime=0x7f4f7affcd40, fast_mutex=0x7f4f84761580, cond=0x7f4f847615c0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:177
#2 os_event_wait_time_low (event=0x7f4f84761580, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=reset_sig_count@entry=1) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0sync.cc:705
#3 0x00007f4f8551a478 in ib_wqueue_timedwait (wq=wq@entry=0x7f4f86f5fe78, wait_in_usecs=wait_in_usecs@entry=5000000) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/ut/ut0wqueue.cc:154
#4 0x00007f4f853670bc in fts_optimize_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/fts/fts0opt.cc:3001
#5 0x00007f4f8c829184 in start_thread (arg=0x7f4f7affd700) at pthread_create.c:312
#6 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 7 (Thread 0x7f4f843ff700 (LWP 13673)):
#0 0x00007f4f8ce7c58a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1 0x00007f4f85401061 in os_aio_linux_collect (seg_size=256, segment=0, array=0x7f4f873f4100) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0file.cc:5349
#2 os_aio_linux_handle (global_seg=global_seg@entry=0, message1=message1@entry=0x7f4f843fee48, message2=message2@entry=0x7f4f843fee50, type=type@entry=0x7f4f843fee58) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0file.cc:5501
#3 0x00007f4f85329c5c in fil_aio_wait (segment=segment@entry=0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/fil/fil0fil.cc:5982
#4 0x00007f4f854d5f1a in io_handler_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/srv/srv0start.cc:515
#5 0x00007f4f8c829184 in start_thread (arg=0x7f4f843ff700) at pthread_create.c:312
#6 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 6 (Thread 0x7f4f83bfe700 (LWP 13674)):
#0 0x00007f4f8ce7c58a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1 0x00007f4f85401061 in os_aio_linux_collect (seg_size=256, segment=0, array=0x7f4f873f40b0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0file.cc:5349
#2 os_aio_linux_handle (global_seg=global_seg@entry=1, message1=message1@entry=0x7f4f83bfde48, message2=message2@entry=0x7f4f83bfde50, type=type@entry=0x7f4f83bfde58) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0file.cc:5501
#3 0x00007f4f85329c5c in fil_aio_wait (segment=segment@entry=1) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/fil/fil0fil.cc:5982
#4 0x00007f4f854d5f1a in io_handler_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/srv/srv0start.cc:515
#5 0x00007f4f8c829184 in start_thread (arg=0x7f4f83bfe700) at pthread_create.c:312
#6 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 5 (Thread 0x7f4f867ff700 (LWP 13672)):
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1 0x00007f4f8e0a55ae in safe_cond_timedwait (cond=cond@entry=0x7f4f8f29bf20 <COND_timer>, mp=mp@entry=0x7f4f8f29bf60 <LOCK_timer>, abstime=abstime@entry=0x7f4f867fede0, file=file@entry=0x7f4f8e161638 "/home/faramir/Documents/epona/natsys/mariadb_10.2/include/mysql/psi/mysql_thread.h", line=line@entry=1175) at /home/faramir/Documents/epona/natsys/mariadb_10.2/mysys/thr_mutex.c:545
#2 0x00007f4f8e0a5c76 in inline_mysql_cond_timedwait (src_line=292, src_file=0x7f4f8e3145b0 "/home/faramir/Documents/epona/natsys/mariadb_10.2/mysys/thr_timer.c", abstime=0x7f4f867fede0, mutex=0x7f4f8f29bf60 <LOCK_timer>, that=0x7f4f8f29bf20 <COND_timer>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/include/mysql/psi/mysql_thread.h:1175
#3 timer_handler (arg=arg@entry=0x0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/mysys/thr_timer.c:292
#4 0x00007f4f8dffeea6 in pfs_spawn_thread (arg=0x7f4f8b4519f0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/perfschema/pfs.cc:1862
#5 0x00007f4f8c829184 in start_thread (arg=0x7f4f867ff700) at pthread_create.c:312
#6 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 4 (Thread 0x7f4f8e7eef00 (LWP 13698)):
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1 0x00007f4f8e0a55ae in safe_cond_timedwait (cond=0x7f4f8ea2b1a0 <COND_thread_cache>, mp=0x7f4f8ea28a20 <LOCK_thread_cache>, abstime=0x7f4f8e7ee4f0, file=0x7f4f8e161638 "/home/faramir/Documents/epona/natsys/mariadb_10.2/include/mysql/psi/mysql_thread.h", line=1175) at /home/faramir/Documents/epona/natsys/mariadb_10.2/mysys/thr_mutex.c:545
#2 0x00007f4f8d86c581 in inline_mysql_cond_timedwait (src_line=3020, src_file=0x7f4f8e161308 "/home/faramir/Documents/epona/natsys/mariadb_10.2/sql/mysqld.cc", abstime=0x7f4f8e7ee4f0, mutex=0x7f4f8ea28a20 <LOCK_thread_cache>, that=0x7f4f8ea2b1a0 <COND_thread_cache>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/include/mysql/psi/mysql_thread.h:1175
#3 cache_thread (thd=0x7f4f76c16070) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/mysqld.cc:3019
#4 one_thread_per_connection_end (thd=0x7f4f76c16070, put_in_cache=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/mysqld.cc:3108
#5 0x00007f4f8da0338e in do_handle_one_connection (connect=connect@entry=0x7f4f8b4730b0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_connect.cc:1377
#6 0x00007f4f8da033fc in handle_one_connection (arg=arg@entry=0x7f4f8b4730b0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_connect.cc:1264
#7 0x00007f4f8dffeea6 in pfs_spawn_thread (arg=0x7f4f84755af0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/perfschema/pfs.cc:1862
#8 0x00007f4f8c829184 in start_thread (arg=0x7f4f8e7eef00) at pthread_create.c:312
#9 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 3 (Thread 0x7f4f82bfc700 (LWP 13676)):
#0 0x00007f4f8ce7c58a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1 0x00007f4f85401061 in os_aio_linux_collect (seg_size=256, segment=1, array=0x7f4f873f4060) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0file.cc:5349
#2 os_aio_linux_handle (global_seg=global_seg@entry=3, message1=message1@entry=0x7f4f82bfbe48, message2=message2@entry=0x7f4f82bfbe50, type=type@entry=0x7f4f82bfbe58) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0file.cc:5501
#3 0x00007f4f85329c5c in fil_aio_wait (segment=segment@entry=3) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/fil/fil0fil.cc:5982
#4 0x00007f4f854d5f1a in io_handler_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/srv/srv0start.cc:515
#5 0x00007f4f8c829184 in start_thread (arg=0x7f4f82bfc700) at pthread_create.c:312
#6 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 2 (Thread 0x7f4f833fd700 (LWP 13675)):
#0 0x00007f4f8ce7c58a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1 0x00007f4f85401061 in os_aio_linux_collect (seg_size=256, segment=0, array=0x7f4f873f4060) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0file.cc:5349
#2 os_aio_linux_handle (global_seg=global_seg@entry=2, message1=message1@entry=0x7f4f833fce48, message2=message2@entry=0x7f4f833fce50, type=type@entry=0x7f4f833fce58) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/os/os0file.cc:5501
#3 0x00007f4f85329c5c in fil_aio_wait (segment=segment@entry=2) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/fil/fil0fil.cc:5982
#4 0x00007f4f854d5f1a in io_handler_thread (arg=<optimized out>) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/srv/srv0start.cc:515
#5 0x00007f4f8c829184 in start_thread (arg=0x7f4f833fd700) at pthread_create.c:312
#6 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Thread 1 (Thread 0x7f4f8e838f00 (LWP 13695)):
#0 0x00007f4f8c82e611 in __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x00007f4f8e09ff73 in my_write_core (sig=6) at /home/faramir/Documents/epona/natsys/mariadb_10.2/mysys/stacktrace.c:456
#2 0x00007f4f8dadc3a3 in handle_fatal_signal (sig=6) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/signal_handler.cc:272
#3 <signal handler called>
#4 0x00007f4f8be88c37 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007f4f8be8c028 in __GI_abort () at abort.c:89
#6 0x00007f4f85382dc4 in get_innobase_type_from_mysql_type (unsigned_flag=unsigned_flag@entry=0x7f4f8e832dd8, f=f@entry=0x7f4f7682b720) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/handler/ha_innodb.cc:6742
#7 0x00007f4f85391204 in create_table_check_doc_id_col (doc_id_col=<synthetic pointer>, form=0x7f4f8e833770, trx=0x7f4f76872078) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/handler/ha_innodb.cc:10570
#8 create_table_def (key_id=1, mode=FIL_SPACE_ENCRYPTION_DEFAULT, flags2=80, flags=1, remote_path=0x7f4f8e833220 "", temp_path=0x7f4f8e833020 "", table_name=0x7f4f8e832e20 "test/t1", form=0x7f4f8e833770, trx=0x7f4f76872078) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/handler/ha_innodb.cc:10674
#9 ha_innodb::create (this=<optimized out>, name=<optimized out>, form=0x7f4f8e833770, create_info=0x7f4f8e836400) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/innobase/handler/ha_innodb.cc:11949
#10 0x00007f4f8dae5354 in handler::ha_create (this=0x7f4f76889888, name=0x7f4f8e835f70 "./test/t1", form=form@entry=0x7f4f8e833770, info_arg=info_arg@entry=0x7f4f8e836400) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/handler.cc:4315
#11 0x00007f4f8dae5e2e in ha_create_table (thd=thd@entry=0x7f4f76852070, path=path@entry=0x7f4f8e835f70 "./test/t1", db=db@entry=0x7f4f769237d0 "test", table_name=table_name@entry=0x7f4f76923180 "t1", create_info=create_info@entry=0x7f4f8e836400, frm=frm@entry=0x7f4f8e835f60) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/handler.cc:4686
#12 0x00007f4f8d9e150d in rea_create_table (thd=thd@entry=0x7f4f76852070, frm=frm@entry=0x7f4f8e835f60, path=path@entry=0x7f4f8e835f70 "./test/t1", db=db@entry=0x7f4f769237d0 "test", table_name=table_name@entry=0x7f4f76923180 "t1", create_info=create_info@entry=0x7f4f8e836400, file=file@entry=0x7f4f76923ee8, no_ha_create_table=no_ha_create_table@entry=false) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/unireg.cc:474
#13 0x00007f4f8d9ac65e in create_table_impl (thd=thd@entry=0x7f4f76852070, orig_db=orig_db@entry=0x7f4f769237d0 "test", orig_table_name=orig_table_name@entry=0x7f4f76923180 "t1", db=<optimized out>, db@entry=0x7f4f769237d0 "test", table_name=<optimized out>, table_name@entry=0x7f4f76923180 "t1", path=path@entry=0x7f4f8e835f70 "./test/t1", options=..., create_info=create_info@entry=0x7f4f8e836400, alter_info=alter_info@entry=0x7f4f8e836370, create_table_mode=create_table_mode@entry=0, is_trans=is_trans@entry=0x7f4f8e83621f, key_info=key_info@entry=0x7f4f8e835f58, key_count=key_count@entry=0x7f4f8e835f54, frm=frm@entry=0x7f4f8e835f60) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_table.cc:4973
#14 0x00007f4f8d9acc32 in mysql_create_table_no_lock (thd=thd@entry=0x7f4f76852070, db=db@entry=0x7f4f769237d0 "test", table_name=table_name@entry=0x7f4f76923180 "t1", create_info=create_info@entry=0x7f4f8e836400, alter_info=alter_info@entry=0x7f4f8e836370, is_trans=is_trans@entry=0x7f4f8e83621f, create_table_mode=create_table_mode@entry=0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_table.cc:5089
#15 0x00007f4f8d9ad029 in mysql_create_table (thd=thd@entry=0x7f4f76852070, create_table=create_table@entry=0x7f4f769231b8, create_info=create_info@entry=0x7f4f8e836400, alter_info=alter_info@entry=0x7f4f8e836370) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_table.cc:5154
#16 0x00007f4f8d913f85 in mysql_execute_command (thd=thd@entry=0x7f4f76852070) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_parse.cc:3850
#17 0x00007f4f8d91c506 in mysql_parse (thd=thd@entry=0x7f4f76852070, rawbuf=<optimized out>, length=65, parser_state=parser_state@entry=0x7f4f8e837940, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_parse.cc:7789
#18 0x00007f4f8d91e73f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f4f76852070, packet=packet@entry=0x7f4f76919071 "CREATE TABLE t1 (a VARCHAR(50), b TEXT, c CHAR(50)) ENGINE=INNODB", packet_length=packet_length@entry=65, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_parse.cc:1790
#19 0x00007f4f8d921077 in do_command (thd=0x7f4f76852070) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_parse.cc:1351
#20 0x00007f4f8da03213 in do_handle_one_connection (connect=connect@entry=0x7f4f8b472ef0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_connect.cc:1358
#21 0x00007f4f8da033fc in handle_one_connection (arg=arg@entry=0x7f4f8b472ef0) at /home/faramir/Documents/epona/natsys/mariadb_10.2/sql/sql_connect.cc:1264
#22 0x00007f4f8dffeea6 in pfs_spawn_thread (arg=0x7f4f84755370) at /home/faramir/Documents/epona/natsys/mariadb_10.2/storage/perfschema/pfs.cc:1862
#23 0x00007f4f8c829184 in start_thread (arg=0x7f4f8e838f00) at pthread_create.c:312
#24 0x00007f4f8bf4c37d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Only 1 of 2 completed.
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 9 seconds executing testcases
Failure: Failed 1/1 tests, 0.00% were successful.
Failing test(s): main.update
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