Geoff Montee (Inactive) added a comment - 2017-07-05 22:28 With a MariaDB 10.1.11 debug build, the user saw the following assertion failure: 2017-07-05 14:34:53 7f85a4ad5b00 InnoDB: Assertion failure in thread 140211970202368 in file rem0rec.cc line 1285 InnoDB: Failing assertion: len < 16384 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. 170705 14:34:53 [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 http://kb.askmonty.org/en/reporting-bugs   We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail.   Server version: 10.1.11-MariaDB-debug-log key_buffer_size=268435456 read_buffer_size=1048576 max_used_connections=29 max_threads=153 thread_count=24 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 578683 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.   Thread pointer: 0x0x7f85689d9070 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 = 0x7f85a4ad5180 thread_stack 0x48400 /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(my_print_stacktrace+0x38)[0x7f85ab824482] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(handle_fatal_signal+0x3a2)[0x7f85ab1ca39e] /lib64/libpthread.so.0(+0xf370)[0x7f85aa669370] /lib64/libc.so.6(gsignal+0x37)[0x7f85a85c11d7] /lib64/libc.so.6(abort+0x148)[0x7f85a85c28c8] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(+0x9cd2d7)[0x7f85ab4662d7] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(+0x9cd3d6)[0x7f85ab4663d6] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(+0x9cd506)[0x7f85ab466506] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(+0xac0539)[0x7f85ab559539] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(+0xac3fff)[0x7f85ab55cfff] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(+0xac6a74)[0x7f85ab55fa74] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(+0xa45949)[0x7f85ab4de949] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(+0xa465fc)[0x7f85ab4df5fc] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(+0xa4686d)[0x7f85ab4df86d] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(+0xa46cdd)[0x7f85ab4dfcdd] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(+0xa08583)[0x7f85ab4a1583] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(+0x8fba86)[0x7f85ab394a86] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(_ZN7handler13ha_update_rowEPKhPh+0x1d5)[0x7f85ab1d8b97] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(_Z12mysql_updateP3THDP10TABLE_LISTR4ListI4ItemES6_PS4_jP8st_ordery15enum_duplicatesbPySB_+0x1d51)[0x7f85ab0678f6] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(_Z21mysql_execute_commandP3THD+0x3b56)[0x7f85aaf8f338] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x257)[0x7f85aaf9a79b] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xd73)[0x7f85aaf891fb] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(_Z10do_commandP3THD+0x7c0)[0x7f85aaf87f22] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x1f9)[0x7f85ab0be788] /tmp/mariadb-10.1.11-linux-x86_64/bin/mysqld(handle_one_connection+0x33)[0x7f85ab0be4d9] /lib64/libpthread.so.0(+0x7dc5)[0x7f85aa661dc5] /lib64/libc.so.6(clone+0x6d)[0x7f85a868376d]

Jan Lindström (Inactive) added a comment - 2017-07-20 05:04 Using MariaDB-10.1.26-debug same assertion: Version: '10.1.26-MariaDB-debug' socket: '/home/jan/mysql/10.1-tmp/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution 2017-07-20 08:02:50 7f2523828b00 InnoDB: Assertion failure in thread 139797486275328 in file rem0rec.cc line 1285 InnoDB: Failing assertion: len < 16384 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. 170720 8:02:50 [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.1.26-MariaDB-debug key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=1 max_threads=153 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62987 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.   Thread pointer: 0x7f25151cb070 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 = 0x7f25238280b0 thread_stack 0x48400 /home/jan/mysql/10.1-tmp/sql/mysqld(my_print_stacktrace+0x38)[0x55569028340a] /home/jan/mysql/10.1-tmp/sql/mysqld(handle_fatal_signal+0x394)[0x55568fc20835] /lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f25235520c0] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcf)[0x7f2520aedfcf] /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f2520aef3fa] /home/jan/mysql/10.1-tmp/mysql-test/var/plugins/ha_innodb.so(+0x25d683)[0x7f25197c5683] /home/jan/mysql/10.1-tmp/mysql-test/var/plugins/ha_innodb.so(+0x25d77b)[0x7f25197c577b] /home/jan/mysql/10.1-tmp/mysql-test/var/plugins/ha_innodb.so(+0x25d8e5)[0x7f25197c58e5] /home/jan/mysql/10.1-tmp/mysql-test/var/plugins/ha_innodb.so(+0x86bfe)[0x7f25195eebfe] mysys/stacktrace.c:267(my_print_stacktrace)[0x7f25195f2314] /home/jan/mysql/10.1-tmp/mysql-test/var/plugins/ha_innodb.so(+0x8cc43)[0x7f25195f4c43] /home/jan/mysql/10.1-tmp/mysql-test/var/plugins/ha_innodb.so(+0x2db1e4)[0x7f25198431e4] /home/jan/mysql/10.1-tmp/mysql-test/var/plugins/ha_innodb.so(+0x2dbe17)[0x7f2519843e17] /home/jan/mysql/10.1-tmp/mysql-test/var/plugins/ha_innodb.so(+0x2dc061)[0x7f2519844061] /home/jan/mysql/10.1-tmp/mysql-test/var/plugins/ha_innodb.so(+0x2dc4d9)[0x7f25198444d9] /home/jan/mysql/10.1-tmp/mysql-test/var/plugins/ha_innodb.so(+0x296a31)[0x7f25197fea31] /home/jan/mysql/10.1-tmp/mysql-test/var/plugins/ha_innodb.so(+0x18c486)[0x7f25196f4486] sql/handler.cc:5978(handler::ha_update_row(unsigned char const*, unsigned char*))[0x55568fc2f29a] sql/sql_update.cc:830(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool, unsigned long long*, unsigned long long*))[0x55568fac3dca] sql/sql_parse.cc:3775(mysql_execute_command(THD*))[0x55568f9ea20b] sql/sql_parse.cc:7339(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55568f9f54e7] sql/sql_parse.cc:1492(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x55568f9e4213] sql/sql_parse.cc:1109(do_command(THD*))[0x55568f9e2fa7] sql/sql_connect.cc:1349(do_handle_one_connection(THD*))[0x55568fb1a4f5] sql/sql_connect.cc:1262(handle_one_connection)[0x55568fb1a23b] perfschema/pfs.cc:1862(pfs_spawn_thread)[0x55568ff456a1] /lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7f2523548494] /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f2520ba3aff]   Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f25078fa088): UPDATE t1 SET a=CONCAT(a, RAND(), a) 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,orderby_uses_equalities=off   The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file ----------SERVER LOG END-------------     - saving '/home/jan/mysql/10.1-tmp/mysql-test/var/log/innodb.innodb-big-innodb_plugin/' to '/home/jan/mysql/10.1-tmp/mysql-test/var/log/innodb.innodb-big-innodb_plugin/' - found 'core' (0/5)   Trying 'dbx' to get a backtrace   Trying 'gdb' to get a backtrace from coredump /home/jan/mysql/10.1-tmp/mysql-test/var/log/innodb.innodb-big-innodb_plugin/mysqld.1/data/core Core generated by '/home/jan/mysql/10.1-tmp/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 12477] [New LWP 12442] [New LWP 12446] [New LWP 12443] [New LWP 12447] [New LWP 12441] [New LWP 12470] [New LWP 12462] [New LWP 12464] [New LWP 12444] [New LWP 12466] [New LWP 12445] [New LWP 12473] [New LWP 12448] [New LWP 12463] [New LWP 12449] [New LWP 12465] [New LWP 12467] [New LWP 12468] [New LWP 12469] [New LWP 12461] [New LWP 12460] [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/jan/mysql/10.1-tmp/sql/mysqld --defaults-group-suffix=.1 --defaults-file='. Program terminated with signal SIGABRT, Aborted. #0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 57 ../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory. [Current thread is 1 (Thread 0x7f2523828b00 (LWP 12477))] #0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 #1 0x00005556902834fc in my_write_core (sig=6) at /home/jan/mysql/10.1-tmp/mysys/stacktrace.c:477 #2 0x000055568fc20bc7 in handle_fatal_signal (sig=6) at /home/jan/mysql/10.1-tmp/sql/signal_handler.cc:296 #3 <signal handler called> #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51 #5 0x00007f2520aef3fa in __GI_abort () at abort.c:89 #6 0x00007f25197c5683 in rec_convert_dtuple_to_rec_comp (rec=0x7f25079cf080 "", index=0x7f2507a80278, fields=0x7f25078450d0, n_fields=4, status=0, temp=false) at /home/jan/mysql/10.1-tmp/storage/innobase/rem/rem0rec.cc:1285 #7 0x00007f25197c577b in rec_convert_dtuple_to_rec_new (buf=0x7f25079cf078 "A ", index=0x7f2507a80278, dtuple=0x7f2507845098) at /home/jan/mysql/10.1-tmp/storage/innobase/rem/rem0rec.cc:1321 #8 0x00007f25197c58e5 in rec_convert_dtuple_to_rec (buf=0x7f25079cf078 "A ", index=0x7f2507a80278, dtuple=0x7f2507845098, n_ext=0) at /home/jan/mysql/10.1-tmp/storage/innobase/rem/rem0rec.cc:1353 #9 0x00007f25195eebfe in page_cur_tuple_insert (cursor=0x7f2507813600, tuple=0x7f2507845098, index=0x7f2507a80278, offsets=0x7f25238254f8, heap=0x7f2523825588, n_ext=0, mtr=0x7f25238258f0) at /home/jan/mysql/10.1-tmp/storage/innobase/include/page0cur.ic:281 #10 0x00007f25195f2314 in btr_cur_insert_if_possible (cursor=0x7f25078135f8, tuple=0x7f2507845098, offsets=0x7f25238254f8, heap=0x7f2523825588, n_ext=0, mtr=0x7f25238258f0) at /home/jan/mysql/10.1-tmp/storage/innobase/btr/btr0cur.cc:1175 #11 0x00007f25195f4c43 in btr_cur_optimistic_update (flags=2, cursor=0x7f25078135f8, offsets=0x7f25238254f8, heap=0x7f2523825588, update=0x7f2507883588, cmpl_info=1, thr=0x7f2507883708, trx_id=1296, mtr=0x7f25238258f0) at /home/jan/mysql/10.1-tmp/storage/innobase/btr/btr0cur.cc:2408 #12 0x00007f25198431e4 in row_upd_clust_rec (node=0x7f2507883480, index=0x7f2507a80278, offsets=0x7f25238255d0, offsets_heap=0x7f2523825588, thr=0x7f2507883708, mtr=0x7f25238258f0) at /home/jan/mysql/10.1-tmp/storage/innobase/row/row0upd.cc:2364 #13 0x00007f2519843e17 in row_upd_clust_step (node=0x7f2507883480, thr=0x7f2507883708) at /home/jan/mysql/10.1-tmp/storage/innobase/row/row0upd.cc:2718 #14 0x00007f2519844061 in row_upd (node=0x7f2507883480, thr=0x7f2507883708) at /home/jan/mysql/10.1-tmp/storage/innobase/row/row0upd.cc:2807 #15 0x00007f25198444d9 in row_upd_step (thr=0x7f2507883708) at /home/jan/mysql/10.1-tmp/storage/innobase/row/row0upd.cc:2959 #16 0x00007f25197fea31 in row_update_for_mysql (mysql_rec=0x7f251512fe98 "\376\004 ", prebuilt=0x7f2507882a78) at /home/jan/mysql/10.1-tmp/storage/innobase/row/row0mysql.cc:1842 #17 0x00007f25196f4486 in ha_innodb::update_row (this=0x7f25078b0888, old_row=0x7f251512fe98 "\376\004 ", new_row=0x7f251512fe88 "\376\032@") at /home/jan/mysql/10.1-tmp/storage/innobase/handler/ha_innodb.cc:8854 #18 0x000055568fc2f29a in handler::ha_update_row (this=0x7f25078b0888, old_data=0x7f251512fe98 "\376\004 ", new_data=0x7f251512fe88 "\376\032@") at /home/jan/mysql/10.1-tmp/sql/handler.cc:5978 #19 0x000055568fac3dca in mysql_update (thd=0x7f25151cb070, table_list=0x7f25078fa180, fields=..., values=..., conds=0x0, order_num=0, order=0x0, limit=18446744073709551614, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f2523826b50, updated_return=0x7f2523826be0) at /home/jan/mysql/10.1-tmp/sql/sql_update.cc:830 #20 0x000055568f9ea20b in mysql_execute_command (thd=0x7f25151cb070) at /home/jan/mysql/10.1-tmp/sql/sql_parse.cc:3775 #21 0x000055568f9f54e7 in mysql_parse (thd=0x7f25151cb070, rawbuf=0x7f25078fa088 "UPDATE t1 SET a=CONCAT(a, RAND(), a)", length=36, parser_state=0x7f2523827460) at /home/jan/mysql/10.1-tmp/sql/sql_parse.cc:7339 #22 0x000055568f9e4213 in dispatch_command (command=COM_QUERY, thd=0x7f25151cb070, packet=0x7f2518bab071 "UPDATE t1 SET a=CONCAT(a, RAND(), a)", packet_length=36) at /home/jan/mysql/10.1-tmp/sql/sql_parse.cc:1490 #23 0x000055568f9e2fa7 in do_command (thd=0x7f25151cb070) at /home/jan/mysql/10.1-tmp/sql/sql_parse.cc:1109 #24 0x000055568fb1a4f5 in do_handle_one_connection (thd_arg=0x7f25151cb070) at /home/jan/mysql/10.1-tmp/sql/sql_connect.cc:1349 #25 0x000055568fb1a23b in handle_one_connection (arg=0x7f25151cb070) at /home/jan/mysql/10.1-tmp/sql/sql_connect.cc:1261 #26 0x000055568ff456a1 in pfs_spawn_thread (arg=0x7f2518b23970) at /home/jan/mysql/10.1-tmp/storage/perfschema/pfs.cc:1860 #27 0x00007f2523548494 in start_thread (arg=0x7f2523828b00) at pthread_create.c:333 #28 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 22 (Thread 0x7f2510fff700 (LWP 12460)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00007f2519784931 in os_cond_wait_timed (cond=0x7f2518a330c0, fast_mutex=0x7f2518a33080, abstime=0x7f2510ffecf0) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:177 #2 0x00007f2519785151 in os_event_wait_time_low (event=0x7f2518a33080, time_in_usec=1000000, reset_sig_count=1) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:705 #3 0x00007f251975e87d in lock_wait_timeout_thread () at /home/jan/mysql/10.1-tmp/storage/innobase/lock/lock0wait.cc:536 #4 0x00007f2523548494 in start_thread (arg=0x7f2510fff700) at pthread_create.c:333 #5 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 21 (Thread 0x7f250ffff700 (LWP 12461)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00007f2519784931 in os_cond_wait_timed (cond=0x7f251f817c40, fast_mutex=0x7f251f817c00, abstime=0x7f250fffecb0) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:177 #2 0x00007f2519785151 in os_event_wait_time_low (event=0x7f251f817c00, time_in_usec=1000000, reset_sig_count=1) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:705 #3 0x00007f2519852253 in srv_error_monitor_thread () at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0srv.cc:1978 #4 0x00007f2523548494 in start_thread (arg=0x7f250ffff700) at pthread_create.c:333 #5 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 20 (Thread 0x7f25093fe700 (LWP 12469)): #0 0x00007f2520b9c3f3 in select () at ../sysdeps/unix/syscall-template.S:84 #1 0x00007f2519785d25 in os_thread_sleep (tm=1000000) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0thread.cc:283 #2 0x00007f2519611a2a in btr_defragment_thread () at /home/jan/mysql/10.1-tmp/storage/innobase/btr/btr0defragment.cc:758 #3 0x00007f2523548494 in start_thread (arg=0x7f25093fe700) at pthread_create.c:333 #4 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 19 (Thread 0x7f2509bff700 (LWP 12468)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00007f2519784a1d in os_cond_wait (cond=0x7f251f817d40, fast_mutex=0x7f251f817d00) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:214 #2 0x00007f2519784faa in os_event_wait_low (event=0x7f251f817d00, reset_sig_count=1) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:592 #3 0x00007f251962ea45 in buf_dump_thread () at /home/jan/mysql/10.1-tmp/storage/innobase/buf/buf0dump.cc:700 #4 0x00007f2523548494 in start_thread (arg=0x7f2509bff700) at pthread_create.c:333 #5 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 18 (Thread 0x7f250b3ff700 (LWP 12467)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00007f2519784931 in os_cond_wait_timed (cond=0x7f2518a32c40, fast_mutex=0x7f2518a32c00, abstime=0x7f250b3fec90) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:177 #2 0x00007f2519785151 in os_event_wait_time_low (event=0x7f2518a32c00, time_in_usec=1000000, reset_sig_count=1) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:705 #3 0x00007f2519635fc0 in page_cleaner_sleep_if_needed (next_loop_time=1500526970577) at /home/jan/mysql/10.1-tmp/storage/innobase/buf/buf0flu.cc:2296 #4 0x00007f2519636081 in buf_flush_page_cleaner_thread (arg=0x0) at /home/jan/mysql/10.1-tmp/storage/innobase/buf/buf0flu.cc:2332 #5 0x00007f2523548494 in start_thread (arg=0x7f250b3ff700) at pthread_create.c:333 #6 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 17 (Thread 0x7f250d7ff700 (LWP 12465)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00007f2519784931 in os_cond_wait_timed (cond=0x7f25153cd540, fast_mutex=0x7f25153cd500, abstime=0x7f250d7fec60) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:177 #2 0x00007f2519785151 in os_event_wait_time_low (event=0x7f25153cd500, time_in_usec=5000000, reset_sig_count=1) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:705 #3 0x00007f25198962e9 in ib_wqueue_timedwait (wq=0x7f251b7fba78, wait_in_usecs=5000000) at /home/jan/mysql/10.1-tmp/storage/innobase/ut/ut0wqueue.cc:154 #4 0x00007f25196d56d2 in fts_optimize_thread (arg=0x7f251b7fba78) at /home/jan/mysql/10.1-tmp/storage/innobase/fts/fts0opt.cc:3060 #5 0x00007f2523548494 in start_thread (arg=0x7f250d7ff700) at pthread_create.c:333 #6 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 16 (Thread 0x7f25127fa700 (LWP 12449)): #0 0x00007f25228c46ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f2519781f78 in os_aio_linux_collect (array=0x7f2518bca150, segment=1, seg_size=256) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0file.cc:5213 #2 0x00007f2519782326 in os_aio_linux_handle (global_seg=5, message1=0x7f25127f9cf0, message2=0x7f25127f9cf8, type=0x7f25127f9d00) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0file.cc:5365 #3 0x00007f2519699d10 in fil_aio_wait (segment=5) at /home/jan/mysql/10.1-tmp/storage/innobase/fil/fil0fil.cc:6165 #4 0x00007f2519855d9f in io_handler_thread (arg=0x7f2519bf0248 <n+40>) at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0start.cc:556 #5 0x00007f2523548494 in start_thread (arg=0x7f25127fa700) at pthread_create.c:333 #6 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 15 (Thread 0x7f250effd700 (LWP 12463)): #0 0x00007f251975ecbf in mach_write_to_4 (b=0x7f251500d1fc "\177\376\214Z", n=2147388183) at /home/jan/mysql/10.1-tmp/storage/innobase/include/mach0data.ic:169 #1 0x00007f2519760400 in log_block_set_checksum (log_block=0x7f251500d000 "", checksum=2147388183) at /home/jan/mysql/10.1-tmp/storage/innobase/include/log0log.ic:255 #2 0x00007f2519762585 in log_block_store_checksum (block=0x7f251500d000 "") at /home/jan/mysql/10.1-tmp/storage/innobase/log/log0log.cc:1273 #3 0x00007f2519762912 in log_group_write_buf (group=0x7f251f84e978, buf=0x7f2515006200 "\200", len=35328, start_lsn=25844736, new_data_offset=349) at /home/jan/mysql/10.1-tmp/storage/innobase/log/log0log.cc:1370 #4 0x00007f251976303e in log_write_up_to (lsn=25879916, wait=91, flush_to_disk=1) at /home/jan/mysql/10.1-tmp/storage/innobase/log/log0log.cc:1568 #5 0x00007f2519763414 in log_buffer_sync_in_background (flush=1) at /home/jan/mysql/10.1-tmp/storage/innobase/log/log0log.cc:1673 #6 0x00007f25198525ff in srv_sync_log_buffer_in_background () at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0srv.cc:2154 #7 0x00007f251985294d in srv_master_do_active_tasks () at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0srv.cc:2277 #8 0x00007f251985323c in srv_master_thread (arg=0x0) at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0srv.cc:2491 #9 0x00007f2523548494 in start_thread (arg=0x7f250effd700) at pthread_create.c:333 #10 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 14 (Thread 0x7f2512ffb700 (LWP 12448)): #0 0x00007f25228c46ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f2519781f78 in os_aio_linux_collect (array=0x7f2518bca150, segment=0, seg_size=256) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0file.cc:5213 #2 0x00007f2519782326 in os_aio_linux_handle (global_seg=4, message1=0x7f2512ffacf0, message2=0x7f2512ffacf8, type=0x7f2512ffad00) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0file.cc:5365 #3 0x00007f2519699d10 in fil_aio_wait (segment=4) at /home/jan/mysql/10.1-tmp/storage/innobase/fil/fil0fil.cc:6165 #4 0x00007f2519855d9f in io_handler_thread (arg=0x7f2519bf0240 <n+32>) at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0start.cc:556 #5 0x00007f2523548494 in start_thread (arg=0x7f2512ffb700) at pthread_create.c:333 #6 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 13 (Thread 0x7f2523872b00 (LWP 12473)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x0000555690288a29 in safe_cond_wait (cond=0x555690c6d800 <COND_slave_background>, mp=0x555690c70880 <LOCK_slave_background>, file=0x5556902eeaa0 "/home/jan/mysql/10.1-tmp/include/mysql/psi/mysql_thread.h", line=1154) at /home/jan/mysql/10.1-tmp/mysys/thr_mutex.c:493 #2 0x000055568f93d7f0 in inline_mysql_cond_wait (that=0x555690c6d800 <COND_slave_background>, mutex=0x555690c70880 <LOCK_slave_background>, src_file=0x5556902ef340 "/home/jan/mysql/10.1-tmp/sql/slave.cc", src_line=336) at /home/jan/mysql/10.1-tmp/include/mysql/psi/mysql_thread.h:1154 #3 0x000055568f93e52d in handle_slave_background (arg=0x0) at /home/jan/mysql/10.1-tmp/sql/slave.cc:336 #4 0x000055568ff456a1 in pfs_spawn_thread (arg=0x7f2518b22070) at /home/jan/mysql/10.1-tmp/storage/perfschema/pfs.cc:1860 #5 0x00007f2523548494 in start_thread (arg=0x7f2523872b00) at pthread_create.c:333 #6 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 12 (Thread 0x7f25147fe700 (LWP 12445)): #0 0x00007f25228c46ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f2519781f78 in os_aio_linux_collect (array=0x7f2518bca0b0, segment=0, seg_size=256) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0file.cc:5213 #2 0x00007f2519782326 in os_aio_linux_handle (global_seg=1, message1=0x7f25147fdcf0, message2=0x7f25147fdcf8, type=0x7f25147fdd00) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0file.cc:5365 #3 0x00007f2519699d10 in fil_aio_wait (segment=1) at /home/jan/mysql/10.1-tmp/storage/innobase/fil/fil0fil.cc:6165 #4 0x00007f2519855d9f in io_handler_thread (arg=0x7f2519bf0228 <n+8>) at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0start.cc:556 #5 0x00007f2523548494 in start_thread (arg=0x7f25147fe700) at pthread_create.c:333 #6 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 11 (Thread 0x7f250c3ff700 (LWP 12466)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00007f2519784a1d in os_cond_wait (cond=0x7f251f817bc0, fast_mutex=0x7f251f817b80) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:214 #2 0x00007f2519784faa in os_event_wait_low (event=0x7f251f817b80, reset_sig_count=2) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:592 #3 0x00007f251984ffde in srv_resume_thread (slot=0x7f2519bebb98 <srv_sys+344>, sig_count=2, wait=true, timeout_usec=0) at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0srv.cc:926 #4 0x00007f2519853a93 in srv_purge_coordinator_suspend (slot=0x7f2519bebb98 <srv_sys+344>, rseg_history_len=7) at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0srv.cc:2781 #5 0x00007f2519853e22 in srv_purge_coordinator_thread (arg=0x0) at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0srv.cc:2869 #6 0x00007f2523548494 in start_thread (arg=0x7f250c3ff700) at pthread_create.c:333 #7 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 10 (Thread 0x7f2514fff700 (LWP 12444)): #0 0x00007f25228c46ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f2519781f78 in os_aio_linux_collect (array=0x7f2518bca100, segment=0, seg_size=256) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0file.cc:5213 #2 0x00007f2519782326 in os_aio_linux_handle (global_seg=0, message1=0x7f2514ffecf0, message2=0x7f2514ffecf8, type=0x7f2514ffed00) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0file.cc:5365 #3 0x00007f2519699d10 in fil_aio_wait (segment=0) at /home/jan/mysql/10.1-tmp/storage/innobase/fil/fil0fil.cc:6165 #4 0x00007f2519855d9f in io_handler_thread (arg=0x7f2519bf0220 <n>) at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0start.cc:556 #5 0x00007f2523548494 in start_thread (arg=0x7f2514fff700) at pthread_create.c:333 #6 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 9 (Thread 0x7f250e7fc700 (LWP 12464)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00007f2519784931 in os_cond_wait_timed (cond=0x7f2518a337c0, fast_mutex=0x7f2518a33780, abstime=0x7f250e7fbd10) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:177 #2 0x00007f2519785151 in os_event_wait_time_low (event=0x7f2518a33780, time_in_usec=10000000, reset_sig_count=1) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:705 #3 0x00007f251968566f in dict_stats_thread () at /home/jan/mysql/10.1-tmp/storage/innobase/dict/dict0stats_bg.cc:552 #4 0x00007f2523548494 in start_thread (arg=0x7f250e7fc700) at pthread_create.c:333 #5 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 8 (Thread 0x7f250f7fe700 (LWP 12462)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00007f2519784931 in os_cond_wait_timed (cond=0x7f251f817cc0, fast_mutex=0x7f251f817c80, abstime=0x7f250f7fdcc0) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:177 #2 0x00007f2519785151 in os_event_wait_time_low (event=0x7f251f817c80, time_in_usec=5000000, reset_sig_count=1) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0sync.cc:705 #3 0x00007f2519851c10 in srv_monitor_thread () at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0srv.cc:1737 #4 0x00007f2523548494 in start_thread (arg=0x7f250f7fe700) at pthread_create.c:333 #5 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 7 (Thread 0x7f25238bcb00 (LWP 12470)): #0 do_sigwait (set=<optimized out>, set@entry=0x7f25238bc080, sig=sig@entry=0x7f25238bc050) at ../sysdeps/unix/sysv/linux/sigwait.c:64 #1 0x00007f2523551ced in __sigwait (set=0x7f25238bc080, sig=0x7f25238bc050) at ../sysdeps/unix/sysv/linux/sigwait.c:96 #2 0x000055568f91b3b5 in signal_hand (arg=0x0) at /home/jan/mysql/10.1-tmp/sql/mysqld.cc:3400 #3 0x000055568ff456a1 in pfs_spawn_thread (arg=0x7f2518b21170) at /home/jan/mysql/10.1-tmp/storage/perfschema/pfs.cc:1860 #4 0x00007f2523548494 in start_thread (arg=0x7f25238bcb00) at pthread_create.c:333 #5 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 6 (Thread 0x7f25238c1600 (LWP 12441)): #0 0x00007f2520b9a6ad in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x000055568f921018 in handle_connections_sockets () at /home/jan/mysql/10.1-tmp/sql/mysqld.cc:6489 #2 0x000055568f91ffab in mysqld_main (argc=150, argv=0x7f251f8940c0) at /home/jan/mysql/10.1-tmp/sql/mysqld.cc:5914 #3 0x000055568f915160 in main (argc=26, argv=0x7ffed8d35338) at /home/jan/mysql/10.1-tmp/sql/main.cc:25   Thread 5 (Thread 0x7f25137fc700 (LWP 12447)): #0 0x00007f25228c46ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f2519781f78 in os_aio_linux_collect (array=0x7f2518bca060, segment=1, seg_size=256) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0file.cc:5213 #2 0x00007f2519782326 in os_aio_linux_handle (global_seg=3, message1=0x7f25137fbcf0, message2=0x7f25137fbcf8, type=0x7f25137fbd00) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0file.cc:5365 #3 0x00007f2519699d10 in fil_aio_wait (segment=3) at /home/jan/mysql/10.1-tmp/storage/innobase/fil/fil0fil.cc:6165 #4 0x00007f2519855d9f in io_handler_thread (arg=0x7f2519bf0238 <n+24>) at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0start.cc:556 #5 0x00007f2523548494 in start_thread (arg=0x7f25137fc700) at pthread_create.c:333 #6 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 4 (Thread 0x7f25187ff700 (LWP 12443)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000555690288d33 in safe_cond_timedwait (cond=0x55569149c280 <COND_checkpoint>, mp=0x55569149c1c0 <LOCK_checkpoint>, abstime=0x7f25187fec40, file=0x55569040de90 "/home/jan/mysql/10.1-tmp/include/mysql/psi/mysql_thread.h", line=1191) at /home/jan/mysql/10.1-tmp/mysys/thr_mutex.c:547 #2 0x000055568fe259f3 in inline_mysql_cond_timedwait (that=0x55569149c280 <COND_checkpoint>, mutex=0x55569149c1c0 <LOCK_checkpoint>, abstime=0x7f25187fec40, src_file=0x55569040ded0 "/home/jan/mysql/10.1-tmp/storage/maria/ma_servicethread.c", src_line=116) at /home/jan/mysql/10.1-tmp/include/mysql/psi/mysql_thread.h:1191 #3 0x000055568fe25ed9 in my_service_thread_sleep (control=0x555690aa5d40 <checkpoint_control>, sleep_time=29000000000) at /home/jan/mysql/10.1-tmp/storage/maria/ma_servicethread.c:115 #4 0x000055568fe1a99d in ma_checkpoint_background (arg=0x1e) at /home/jan/mysql/10.1-tmp/storage/maria/ma_checkpoint.c:708 #5 0x000055568ff456a1 in pfs_spawn_thread (arg=0x7f251f8131f0) at /home/jan/mysql/10.1-tmp/storage/perfschema/pfs.cc:1860 #6 0x00007f2523548494 in start_thread (arg=0x7f25187ff700) at pthread_create.c:333 #7 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 3 (Thread 0x7f2513ffd700 (LWP 12446)): #0 0x00007f25228c46ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f2519781f78 in os_aio_linux_collect (array=0x7f2518bca060, segment=0, seg_size=256) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0file.cc:5213 #2 0x00007f2519782326 in os_aio_linux_handle (global_seg=2, message1=0x7f2513ffccf0, message2=0x7f2513ffccf8, type=0x7f2513ffcd00) at /home/jan/mysql/10.1-tmp/storage/innobase/os/os0file.cc:5365 #3 0x00007f2519699d10 in fil_aio_wait (segment=2) at /home/jan/mysql/10.1-tmp/storage/innobase/fil/fil0fil.cc:6165 #4 0x00007f2519855d9f in io_handler_thread (arg=0x7f2519bf0230 <n+16>) at /home/jan/mysql/10.1-tmp/storage/innobase/srv/srv0start.cc:556 #5 0x00007f2523548494 in start_thread (arg=0x7f2513ffd700) at pthread_create.c:333 #6 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 2 (Thread 0x7f251abff700 (LWP 12442)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000555690288d33 in safe_cond_timedwait (cond=0x5556914eb5e0 <COND_timer>, mp=0x5556914eb520 <LOCK_timer>, abstime=0x7f251abfecf0, file=0x5556904efde0 "/home/jan/mysql/10.1-tmp/include/mysql/psi/mysql_thread.h", line=1191) at /home/jan/mysql/10.1-tmp/mysys/thr_mutex.c:547 #2 0x0000555690289c84 in inline_mysql_cond_timedwait (that=0x5556914eb5e0 <COND_timer>, mutex=0x5556914eb520 <LOCK_timer>, abstime=0x7f251abfecf0, src_file=0x5556904efe20 "/home/jan/mysql/10.1-tmp/mysys/thr_timer.c", src_line=292) at /home/jan/mysql/10.1-tmp/include/mysql/psi/mysql_thread.h:1191 #3 0x000055569028a781 in timer_handler (arg=0x0) at /home/jan/mysql/10.1-tmp/mysys/thr_timer.c:292 #4 0x000055568ff456a1 in pfs_spawn_thread (arg=0x7f251f810c70) at /home/jan/mysql/10.1-tmp/storage/perfschema/pfs.cc:1860 #5 0x00007f2523548494 in start_thread (arg=0x7f251abff700) at pthread_create.c:333 #6 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97   Thread 1 (Thread 0x7f2523828b00 (LWP 12477)): #0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 #1 0x00005556902834fc in my_write_core (sig=6) at /home/jan/mysql/10.1-tmp/mysys/stacktrace.c:477 #2 0x000055568fc20bc7 in handle_fatal_signal (sig=6) at /home/jan/mysql/10.1-tmp/sql/signal_handler.cc:296 #3 <signal handler called> #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51 #5 0x00007f2520aef3fa in __GI_abort () at abort.c:89 #6 0x00007f25197c5683 in rec_convert_dtuple_to_rec_comp (rec=0x7f25079cf080 "", index=0x7f2507a80278, fields=0x7f25078450d0, n_fields=4, status=0, temp=false) at /home/jan/mysql/10.1-tmp/storage/innobase/rem/rem0rec.cc:1285 #7 0x00007f25197c577b in rec_convert_dtuple_to_rec_new (buf=0x7f25079cf078 "A ", index=0x7f2507a80278, dtuple=0x7f2507845098) at /home/jan/mysql/10.1-tmp/storage/innobase/rem/rem0rec.cc:1321 #8 0x00007f25197c58e5 in rec_convert_dtuple_to_rec (buf=0x7f25079cf078 "A ", index=0x7f2507a80278, dtuple=0x7f2507845098, n_ext=0) at /home/jan/mysql/10.1-tmp/storage/innobase/rem/rem0rec.cc:1353 #9 0x00007f25195eebfe in page_cur_tuple_insert (cursor=0x7f2507813600, tuple=0x7f2507845098, index=0x7f2507a80278, offsets=0x7f25238254f8, heap=0x7f2523825588, n_ext=0, mtr=0x7f25238258f0) at /home/jan/mysql/10.1-tmp/storage/innobase/include/page0cur.ic:281 #10 0x00007f25195f2314 in btr_cur_insert_if_possible (cursor=0x7f25078135f8, tuple=0x7f2507845098, offsets=0x7f25238254f8, heap=0x7f2523825588, n_ext=0, mtr=0x7f25238258f0) at /home/jan/mysql/10.1-tmp/storage/innobase/btr/btr0cur.cc:1175 #11 0x00007f25195f4c43 in btr_cur_optimistic_update (flags=2, cursor=0x7f25078135f8, offsets=0x7f25238254f8, heap=0x7f2523825588, update=0x7f2507883588, cmpl_info=1, thr=0x7f2507883708, trx_id=1296, mtr=0x7f25238258f0) at /home/jan/mysql/10.1-tmp/storage/innobase/btr/btr0cur.cc:2408 #12 0x00007f25198431e4 in row_upd_clust_rec (node=0x7f2507883480, index=0x7f2507a80278, offsets=0x7f25238255d0, offsets_heap=0x7f2523825588, thr=0x7f2507883708, mtr=0x7f25238258f0) at /home/jan/mysql/10.1-tmp/storage/innobase/row/row0upd.cc:2364 #13 0x00007f2519843e17 in row_upd_clust_step (node=0x7f2507883480, thr=0x7f2507883708) at /home/jan/mysql/10.1-tmp/storage/innobase/row/row0upd.cc:2718 #14 0x00007f2519844061 in row_upd (node=0x7f2507883480, thr=0x7f2507883708) at /home/jan/mysql/10.1-tmp/storage/innobase/row/row0upd.cc:2807 #15 0x00007f25198444d9 in row_upd_step (thr=0x7f2507883708) at /home/jan/mysql/10.1-tmp/storage/innobase/row/row0upd.cc:2959 #16 0x00007f25197fea31 in row_update_for_mysql (mysql_rec=0x7f251512fe98 "\376\004 ", prebuilt=0x7f2507882a78) at /home/jan/mysql/10.1-tmp/storage/innobase/row/row0mysql.cc:1842 #17 0x00007f25196f4486 in ha_innodb::update_row (this=0x7f25078b0888, old_row=0x7f251512fe98 "\376\004 ", new_row=0x7f251512fe88 "\376\032@") at /home/jan/mysql/10.1-tmp/storage/innobase/handler/ha_innodb.cc:8854 #18 0x000055568fc2f29a in handler::ha_update_row (this=0x7f25078b0888, old_data=0x7f251512fe98 "\376\004 ", new_data=0x7f251512fe88 "\376\032@") at /home/jan/mysql/10.1-tmp/sql/handler.cc:5978 #19 0x000055568fac3dca in mysql_update (thd=0x7f25151cb070, table_list=0x7f25078fa180, fields=..., values=..., conds=0x0, order_num=0, order=0x0, limit=18446744073709551614, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f2523826b50, updated_return=0x7f2523826be0) at /home/jan/mysql/10.1-tmp/sql/sql_update.cc:830 #20 0x000055568f9ea20b in mysql_execute_command (thd=0x7f25151cb070) at /home/jan/mysql/10.1-tmp/sql/sql_parse.cc:3775 #21 0x000055568f9f54e7 in mysql_parse (thd=0x7f25151cb070, rawbuf=0x7f25078fa088 "UPDATE t1 SET a=CONCAT(a, RAND(), a)", length=36, parser_state=0x7f2523827460) at /home/jan/mysql/10.1-tmp/sql/sql_parse.cc:7339 #22 0x000055568f9e4213 in dispatch_command (command=COM_QUERY, thd=0x7f25151cb070, packet=0x7f2518bab071 "UPDATE t1 SET a=CONCAT(a, RAND(), a)", packet_length=36) at /home/jan/mysql/10.1-tmp/sql/sql_parse.cc:1490 #23 0x000055568f9e2fa7 in do_command (thd=0x7f25151cb070) at /home/jan/mysql/10.1-tmp/sql/sql_parse.cc:1109 #24 0x000055568fb1a4f5 in do_handle_one_connection (thd_arg=0x7f25151cb070) at /home/jan/mysql/10.1-tmp/sql/sql_connect.cc:1349 #25 0x000055568fb1a23b in handle_one_connection (arg=0x7f25151cb070) at /home/jan/mysql/10.1-tmp/sql/sql_connect.cc:1261 #26 0x000055568ff456a1 in pfs_spawn_thread (arg=0x7f2518b23970) at /home/jan/mysql/10.1-tmp/storage/perfschema/pfs.cc:1860 #27 0x00007f2523548494 in start_thread (arg=0x7f2523828b00) at pthread_create.c:333 #28 0x00007f2520ba3aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97     Only 1 of 2 completed. -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 19 seconds executing testcases   Failure: Failed 1/1 tests, 0.00% were successful.   Failing test(s): innodb.innodb-big   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 jan@jan-laptop-asus:~/mysql/10.1-tmp/mysql-test$

Jan Lindström (Inactive) added a comment - 2017-07-20 07:06 When length of blob field is increased to be > 16K it should be stored externally, however when innodb-page-size=64K row size 16K+1 < 64K/2 i.e. half of the btree leaf page size and blob is not stored externally.

Jan Lindström (Inactive) added a comment - 2017-07-20 10:19 commit d1b3e428d4843b83ef2ea7443ba61a9b7f6bf999 Author: Jan Lindström <jan.lindstrom@mariadb.com> Date: Thu Jul 20 11:24:01 2017 +0300 MDEV-13227 : Assertion failure len < 16384 in file rem0rec.cc line 1285 Crashes with innodb_page_size=64K. Does not crash at <= 32K. Problem was that when blob record that was earlier < 16k is enlarged at update wo that length > 16K it should be stored externally. However, that was not enforced when page-size = 64K (note that 16K+1 < 64K/2 i.e. half of the btree leaf page). btr_cur_optimistic_update: limit max record size to 16K or in REDUNDANT row format to 16K-1.