Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.2.38
-
None
-
Ubuntu 16.04 LTS / x86-64
Description
On a production database, single VM (Ubuntu 16.04), no replication, we got about a crash once a day - we installed debug symbols and got a backtrace :
*** Error in `/usr/sbin/mysqld': double free or corruption (out): 0x00007f8e0800c080 ***
|
======= Backtrace: =========
|
/lib/x86_64-linux-gnu/libc.so.6(+0x777f5)[0x7f93f67ed7f5]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x8038a)[0x7f93f67f638a]
|
/lib/x86_64-linux-gnu/libc.so.6(cfree+0x4c)[0x7f93f67fa58c]
|
/usr/sbin/mysqld(+0x86bc2e)[0x558f647fcc2e]
|
/usr/sbin/mysqld(+0x83be8d)[0x558f647cce8d]
|
/usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcij+0x33)[0x558f64621793]
|
/usr/sbin/mysqld(_Z14open_tmp_tableP5TABLE+0x2b)[0x558f644b7bab]
|
/usr/sbin/mysqld(_ZN7AGGR_OP17prepare_tmp_tableEv+0x101)[0x558f644cc8a1]
|
/usr/sbin/mysqld(_ZN7AGGR_OP10put_recordEb+0x26)[0x558f644cc9a6]
|
/usr/sbin/mysqld(+0x517bfe)[0x558f644a8bfe]
|
/usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x179)[0x558f644b1d99]
|
/usr/sbin/mysqld(+0x517bfe)[0x558f644a8bfe]
|
/usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x179)[0x558f644b1d99]
|
/usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xb8b)[0x558f644d1ebb]
|
/usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x558f644d20c3]
|
/usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xeb)[0x558f644d220b]
|
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x12f)[0x558f644d2b2f]
|
/usr/sbin/mysqld(+0x41c289)[0x558f643ad289]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x5c2a)[0x558f6447f42a]
|
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x26e)[0x558f644816ee]
|
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xba6)[0x558f64482fc6]
|
/usr/sbin/mysqld(_Z10do_commandP3THD+0x10c)[0x558f64484d2c]
|
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x272)[0x558f64553dd2]
|
/usr/sbin/mysqld(handle_one_connection+0x3d)[0x558f64553f2d]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f93f71d26ba]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f93f687d51d]
|
======= Memory map: ========
|
[...]
|
220516 18:00:41 [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.38-MariaDB-10.2.38+maria~xenial-log
|
key_buffer_size=67108864
|
read_buffer_size=1048576
|
max_used_connections=66
|
max_threads=102
|
thread_count=57
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 276586 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x7f8e3c0008c8
|
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 = 0x7f93f007fcf8 thread_stack 0x30000
|
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x558f64b6c24e]
|
/usr/sbin/mysqld(handle_fatal_signal+0x305)[0x558f6461d1d5]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f93f71dc390]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38)[0x7f93f67ab438]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f93f67ad03a]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x777fa)[0x7f93f67ed7fa]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x8038a)[0x7f93f67f638a]
|
/lib/x86_64-linux-gnu/libc.so.6(cfree+0x4c)[0x7f93f67fa58c]
|
/usr/sbin/mysqld(+0x86bc2e)[0x558f647fcc2e]
|
/usr/sbin/mysqld(+0x83be8d)[0x558f647cce8d]
|
/usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcij+0x33)[0x558f64621793]
|
/usr/sbin/mysqld(_Z14open_tmp_tableP5TABLE+0x2b)[0x558f644b7bab]
|
/usr/sbin/mysqld(_ZN7AGGR_OP17prepare_tmp_tableEv+0x101)[0x558f644cc8a1]
|
/usr/sbin/mysqld(_ZN7AGGR_OP10put_recordEb+0x26)[0x558f644cc9a6]
|
/usr/sbin/mysqld(+0x517bfe)[0x558f644a8bfe]
|
/usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x179)[0x558f644b1d99]
|
/usr/sbin/mysqld(+0x517bfe)[0x558f644a8bfe]
|
/usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x179)[0x558f644b1d99]
|
/usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xb8b)[0x558f644d1ebb]
|
/usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x558f644d20c3]
|
/usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xeb)[0x558f644d220b]
|
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x12f)[0x558f644d2b2f]
|
/usr/sbin/mysqld(+0x41c289)[0x558f643ad289]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x5c2a)[0x558f6447f42a]
|
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x26e)[0x558f644816ee]
|
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xba6)[0x558f64482fc6]
|
/usr/sbin/mysqld(_Z10do_commandP3THD+0x10c)[0x558f64484d2c]
|
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x272)[0x558f64553dd2]
|
/usr/sbin/mysqld(handle_one_connection+0x3d)[0x558f64553f2d]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f93f71d26ba]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f93f687d51d]
|
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f8e08000050): SELECT DISTINCT `roles`.* FROM `roles` INNER JOIN `member_roles` ON `roles`.`id` = `member_roles`.`role_id` WHERE `member_roles`.`member_id` = 575728
|
|
|
Connection ID (thread ID): 128171
|
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 https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
|
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /var/lib/mysql
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 8388608 unlimited bytes
|
Max core file size unlimited unlimited bytes
|
Max resident set unlimited unlimited bytes
|
Max processes 96251 96251 processes
|
Max open files 32768 32768 files
|
Max locked memory 65536 65536 bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 96251 96251 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Max realtime timeout unlimited unlimited us
|
Core pattern: core
|
And the backtrace :
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
|
#1 0x0000558f64b6c047 in my_write_core (sig=sig@entry=6) at /home/buildbot/buildbot/build/mariadb-10.2.38/mysys/stacktrace.c:382
|
#2 0x0000558f6461d256 in handle_fatal_signal (sig=6) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/signal_handler.cc:355
|
#3 <signal handler called>
|
#4 0x00007f93f67ab438 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
|
#5 0x00007f93f67ad03a in __GI_abort () at abort.c:89
|
#6 0x00007f93f67ed7fa in __libc_message (do_abort=do_abort@entry=2, fmt=fmt@entry=0x7f93f6906fd8 "*** Error in `%s': %s: 0x%s ***\n") at ../sysdeps/posix/libc_fatal.c:175
|
#7 0x00007f93f67f638a in malloc_printerr (ar_ptr=<optimized out>, ptr=<optimized out>, str=0x7f93f69070e8 "double free or corruption (out)", action=3) at malloc.c:5020
|
#8 _int_free (av=<optimized out>, p=<optimized out>, have_lock=0) at malloc.c:3874
|
#9 0x00007f93f67fa58c in __GI___libc_free (mem=<optimized out>) at malloc.c:2975
|
#10 0x0000558f64b6801d in my_free (ptr=<optimized out>) at /home/buildbot/buildbot/build/mariadb-10.2.38/mysys/my_malloc.c:218
|
#11 0x0000558f647fcc2e in maria_open (name=<optimized out>, mode=<optimized out>, open_flags=open_flags@entry=596) at /home/buildbot/buildbot/build/mariadb-10.2.38/storage/maria/ma_open.c:1083
|
#12 0x0000558f647cce8d in ha_maria::open (this=0x7f8e3c01bf80, name=<optimized out>, mode=<optimized out>, test_if_locked=532) at /home/buildbot/buildbot/build/mariadb-10.2.38/storage/maria/ha_maria.cc:1203
|
#13 0x0000558f64621793 in handler::ha_open (this=0x7f8e3c01bf80, table_arg=table_arg@entry=0x7f8e0815ece0, name=0x7f8e08160418 "/tmp/#sql_5294_2", mode=mode@entry=2, test_if_locked=test_if_locked@entry=516)
|
at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/handler.cc:2592
|
#14 0x0000558f644b7bab in open_tmp_table (table=0x7f8e0815ece0) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_select.cc:17657
|
#15 0x0000558f644cc8a1 in AGGR_OP::prepare_tmp_table (this=this@entry=0x7f8e08005fd8) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_select.cc:26778
|
#16 0x0000558f644cc9a6 in AGGR_OP::put_record (this=0x7f8e08005fd8, end_of_records=<optimized out>) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_select.cc:26817
|
#17 0x0000558f644a8bfe in evaluate_join_record (join=join@entry=0x7f8e08001e90, join_tab=join_tab@entry=0x7f8e3c00f2a0, error=<optimized out>) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_select.cc:19094
|
#18 0x0000558f644b1d99 in sub_select (join=0x7f8e08001e90, join_tab=0x7f8e3c00f2a0, end_of_records=<optimized out>) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_select.cc:18874
|
#19 0x0000558f644a8bfe in evaluate_join_record (join=join@entry=0x7f8e08001e90, join_tab=join_tab@entry=0x7f8e3c00eef0, error=<optimized out>) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_select.cc:19094
|
#20 0x0000558f644b1d99 in sub_select (join=0x7f8e08001e90, join_tab=0x7f8e3c00eef0, end_of_records=<optimized out>) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_select.cc:18874
|
#21 0x0000558f644d1ebb in do_select (procedure=<optimized out>, join=0x7f8e08001e90) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_select.cc:18418
|
#22 JOIN::exec_inner (this=this@entry=0x7f8e08001e90) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_select.cc:3651
|
#23 0x0000558f644d20c3 in JOIN::exec (this=this@entry=0x7f8e08001e90) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_select.cc:3446
|
#24 0x0000558f644d220b in mysql_select (thd=thd@entry=0x7f8e3c0008c8, tables=0x7f8e08000338, wild_num=1, fields=..., conds=<optimized out>, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748609,
|
result=0x7f8e08001e70, unit=0x7f8e3c004300, select_lex=0x7f8e3c004a40) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_select.cc:3849
|
#25 0x0000558f644d2b2f in handle_select (thd=thd@entry=0x7f8e3c0008c8, lex=lex@entry=0x7f8e3c004240, result=result@entry=0x7f8e08001e70, setup_tables_done_option=setup_tables_done_option@entry=0)
|
at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_select.cc:373
|
#26 0x0000558f643ad289 in execute_sqlcom_select (thd=thd@entry=0x7f8e3c0008c8, all_tables=0x7f8e08000338) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_parse.cc:6274
|
#27 0x0000558f6447f42a in mysql_execute_command (thd=thd@entry=0x7f8e3c0008c8) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_parse.cc:3585
|
#28 0x0000558f644816ee in mysql_parse (thd=thd@entry=0x7f8e3c0008c8, rawbuf=<optimized out>, length=149, parser_state=parser_state@entry=0x7f93f007f4d0, is_com_multi=is_com_multi@entry=false,
|
is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_parse.cc:7796
|
#29 0x0000558f64482fc6 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f8e3c0008c8, packet=packet@entry=0x7f8e08006069 "", packet_length=packet_length@entry=149, is_com_multi=is_com_multi@entry=false,
|
is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_parse.cc:1828
|
#30 0x0000558f64484d2c in do_command (thd=0x7f8e3c0008c8) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_parse.cc:1382
|
#31 0x0000558f64553dd2 in do_handle_one_connection (connect=connect@entry=0x558f7d7bf938) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_connect.cc:1336
|
#32 0x0000558f64553f2d in handle_one_connection (arg=0x558f7d7bf938) at /home/buildbot/buildbot/build/mariadb-10.2.38/sql/sql_connect.cc:1241
|
#33 0x00007f93f71d26ba in start_thread (arg=0x7f93f0080700) at pthread_create.c:333
|
#34 0x00007f93f687d51d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
|
(gdb) f 11
|
(gdb) info f
|
Stack frame at 0x7f93f007d6a0:
|
rip = 0x558f647fcc2e in maria_open (/home/buildbot/buildbot/build/mariadb-10.2.38/storage/maria/ma_open.c:1083); saved rip = 0x558f647cce8d
|
called by frame at 0x7f93f007d6c0, caller of frame at 0x7f93f007ad00
|
source language c.
|
Arglist at 0x7f93f007ad00, args: name=<optimized out>, mode=<optimized out>, open_flags=open_flags@entry=596
|
Locals at 0x7f93f007ad00, Previous frame's sp is 0x7f93f007d6a0
|
Saved registers:
|
rbx at 0x7f93f007d668, rbp at 0x7f93f007d690, r12 at 0x7f93f007d670, r13 at 0x7f93f007d678, r14 at 0x7f93f007d680, r15 at 0x7f93f007d688, rip at 0x7f93f007d698
|
|
|
(gdb) info locals
|
kfile = 300
|
open_mode = <optimized out>
|
save_errno = <optimized out>
|
i = <optimized out>
|
j = <optimized out>
|
len = <optimized out>
|
errpos = <optimized out>
|
base_pos = <optimized out>
|
keys = <optimized out>
|
realpath_err = <optimized out>
|
key_parts = <optimized out>
|
unique_key_parts = <optimized out>
|
fulltext_keys = <optimized out>
|
uniques = <optimized out>
|
internal_table = 1
|
file_version = <optimized out>
|
info_length = <optimized out>
|
name_buff = "/tmp/#sql_5294_2.MAI", '\000' <repeats 20 times>, "\204s=d\217U", '\000' <repeats 26 times>, ",\001\000\000\000\000\000\000\000 \000\000\000\000\000\000\000x=e\217U\000\000\327\004", '\000' <repeats 14 times>, "\060\267\a\360\223\177\000\000Y\205|d\217U\000\000 \325\a\360\223\177\000\000\000 \000\000\000\000\000\000,\001", '\000' <repeats 22 times>, "\214\245\177\366\223\177\000\000\000 \000\000\000\000\000\000,\001", '\000' <repeats 23 times>...
|
org_name = "/tmp/#sql_5294_2\000MAI\000\177\000\000\000\000\000\000\217U\000\000\240\064\062f\217U\000\000\b\220\001<\216\177\000\000\200\270\a\360\223\177\000\000\214>d\\\000\000\000\000\002\000\000\000\000\000\000\000\004\000\000\000\000\000\000\000 H\001\064\216\177\000\000\300\027T\245\222\177\000\000\000\000\000\000\000\000\000\000\330\027T\245\222\177\000\000P\030T\245\222\177\000\000\001\000\000\000\000\000\000\000 \271\a\360\223\177\000\000\374T\237d\217U\000\000\060\275\a\360\223\177\000\000\320\316\a\360\223\177\000\000,\001\257\\\331\000\000\000\360V\316d\217U\000\000\070\021\aЎ\177\000\000\300\027T\245\222\177\000\000\b\022\a,\217\177\000\000\001"...
|
index_name = "/tmp/#sql_5294_2.MAI\000\177\000\000\360G{j\217U\000\000\340\274\a\360\223\177", '\000' <repeats 18 times>, "\002\000\000\000\000\000\000\000ބc\000\204p\000\000\000\000\000\000\001\000\000\000\270\272\a\360\004\000\000\000`\300\001<\216\177\000\000`\300\001<\216\177\000\000\000\000\000\000\000\000\000\000\360\377\377\377\004", '\000' <repeats 11 times>, "P\000\000\000\000\000\000\000,\275\a\360\223\177\000\000\000\273\a\360\223\177\000\000xW\000\b\216\177\000\000\n", '\000' <repeats 11 times>, "\001\177\000\000\070\005\247\214\222\177\000\000 \005\247\214\222\177\000\000\070\005\247\214\222\177\000\000\070"...
|
data_name = "/tmp/#sql_5294_2.MAD\000\177\000\000\370\060\002\004\221\177\000\000p1\002\004\221\177\000\000\001\000\000\000\000\000\000\000м\a\360\223\177\000\000\374T\237d\217U\000\000\340\274\a\360\223\177\000\000\200\322\a\360\223\177\000\000\256O\307Z\331\000\000\000\360V\316d\217U\000\000\070\312\001\344\216\177\000\000\340\060\002\004\221\177\000\000hP\n\034\217\177\000\000\001\000\000\000\000\000\000\000\360V\316d\217U\000\000[\016\000\000\000\000\000\000P\275\a\360\223\177\000\000\025!\235d\217U\000\000\320^2f\217U\000\000\210\305\001\344\216\177\000\000\000\275\a\360\223\177\000\000\027\063\244W\000\000\000\000\020\275\a\360\223\177\000\000L"...
|
disk_cache = 0x7f8e0800c088 "\320C\026\b\216\177"
|
disk_pos = <optimized out>
|
end_pos = <optimized out>
|
info = {s = 0x0, trn = 0x0, trn_next = 0x0, state = 0x0, state_save = {records = 0, del = 0, empty = 0, key_empty = 0, key_file_length = 0, data_file_length = 0, checksum = 0, changed = 0, no_transid = 0}, state_start = 0x0, used_tables = 0x0, cur_row = {insert_blocks = {block = 0x0, count = 0, tail_page_skipped = 0 '\000', page_skipped = 0 '\000'}, extents = 0x0, lastpos = 0, nextpos = 0, tail_positions = 0x0, checksum = 0, orig_undo_lsn = 0, trid = 0, empty_bits = 0x0, field_lengths = 0x0, null_field_lengths = 0x0, blob_lengths = 0x0, min_length = 0, normal_length = 0, char_length = 0, varchar_length = 0, blob_length = 0, total_length = 0, extents_buffer_length = 0, head_length = 0, header_length = 0, field_lengths_length = 0, extents_count = 0, full_page_count = 0, tail_count = 0, space_on_head_page = 0}, new_row = {insert_blocks = {block = 0x0, count = 0, tail_page_skipped = 0 '\000', page_skipped = 0 '\000'}, extents = 0x0, lastpos = 0, nextpos = 0, tail_positions = 0x0, checksum = 0, orig_undo_lsn = 0, trid = 0, empty_bits = 0x0, field_lengths = 0x0, null_field_lengths = 0x0, blob_lengths = 0x0, min_length = 0, normal_length = 0, char_length = 0, varchar_length = 0, blob_length = 0, total_length = 0, extents_buffer_length = 0, head_length = 0, header_length = 0, field_lengths_length = 0, extents_count = 0, full_page_count = 0, tail_count = 0, space_on_head_page = 0}, last_key = {data = 0x0, keyinfo = 0x0, data_length = 0, ref_length = 0, flag = 0}, scan = {bitmap_buff = 0x0, bitmap_pos = 0x0, bitmap_end = 0x0, page_buff = 0x0, dir = 0x0, dir_end = 0x0, bitmap_page = 0, max_page = 0, bits = 0, number_of_rows = 0, bit_pos = 0, row_base_page = 0, row_changes = 0}, scan_save = 0x0, blobs = 0x0, bit_buff = {current_byte = 0, bits = 0, pos = 0x0, end = 0x0, blob_pos = 0x0, blob_end = 0x0, error = 0}, bitmap_blocks = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0, malloc_flags = 0}, pinned_pages = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0, malloc_flags = 0}, bulk_insert = 0x0, log_row_parts = 0x0, ft1_to_ft2 = 0x0, ft_memroot = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 0, block_size = 0, block_num = 0, first_block_usage = 0, error_handler = 0x0}, ftparser_param = 0x0, external_ref = 0x0, buff = 0x0, keyread_buff = 0x0, lastkey_buff = 0x0, lastkey_buff2 = 0x0, first_mbr_key = 0x0, rec_buff = 0x0, blob_buff = 0x0, int_keypos = 0x0, int_maxpos = 0x0, keypos_offset = 0, maxpos_offset = 0, update_field_data = 0x0, int_nod_flag = 0, int_keytree_version = 0, read_record = 0x0, invalidator = 0x0, last_auto_increment = 0, row_changes = 0, start_row_changes = 0, this_unique = 0, last_unique = 0, this_loop = 0, last_loop = 0, save_lastpos = 0, dup_key_pos = 0, dup_key_trid = 0, pos = 0, last_keypage = 0, last_search_keypage = 0, packed_length = 0, blob_length = 0, rec_buff_size = 0, blob_buff_size = 0, dfile = {file = 0, pre_read_hook = 0x0, post_read_hook = 0x0, pre_write_hook = 0x0, post_write_hook = 0x0, flush_log_callback = 0x0, callback_data = 0x0}, rec_cache = {pos_in_file = 0, end_of_file = 0, read_pos = 0x0, read_end = 0x0, buffer = 0x0, request_pos = 0x0, write_buffer = 0x0, append_read_pos = 0x0
|
, write_pos = 0x0, write_end = 0x0, append_buffer_lock = {m_mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, m_psi = 0x0}, share = 0x0, read_function = 0x0, write_function = 0x0, type = TYPE_NOT_SET, disk_writes = 0, file_name = 0x0, dir = 0x0, prefix = "\000\000", file = 0, next_file_user = 0x0, seek_not_done = 0, error = 0, buffer_length = 0, read_length = 0, myflags = 0, alloced_buffer = 0}, open_list = {prev = 0x0, next = 0x0, data = 0x0}, share_list = {prev = 0x0, next = 0x0, data = 0x0}, changed_fields = {bitmap = 0x0, last_word_ptr = 0x0, mutex = 0x0, last_word_mask = 0, n_bits = 0}, row_base_length = 0, row_flag = 0, opt_flag = 0, open_flags = 0, update = 0, lastinx = 0, last_rkey_length = 0, last_rtree_keypos = 0x0, bulk_insert_ref_length = 0, non_flushable_state = 0, last_key_func = HA_READ_KEY_EXACT, save_lastkey_data_length = 0, save_lastkey_ref_length = 0, pack_key_length = 0, lock_wait = 0, errkey = 0, lock_type = 0, tmp_lock_type = 0, data_changed = 0, save_update = 0, save_lastinx = 0, preload_buff_size = 0, last_used_keyseg = 0, key_del_used = 0 '\000', was_locked = 0 '\000', append_insert_at_end = 0 '\000', quick_mode = 0 '\000', in_check_table = 0 '\000', page_changed = 0 '\000', keyread_buff_used = 0 '\000', once_flags = 0 '\000', switched_transactional = 0 '\000', lock = {owner = 0x0, next = 0x0, prev = 0x0, lock = 0x0, cond = 0x0, status_param = 0x0, debug_print_param = 0x0, m_psi = 0x0, type = TL_UNLOCK, org_type = TL_UNLOCK, priority = 0}, maria_rtree_recursion_state = 0x0, length_buff = "\000\000\000\000", maria_rtree_recursion_depth = 0, create_unique_index_by_sort = 0 '\000', index_cond_func = 0x0, index_cond_func_arg = 0x0}
|
old_info = <optimized out>
|
share_buff = {state = {header = {file_version = "\376\376\t\003", options = "\004\021", header_length = "\003\216", state_info_length = <incomplete sequence \327>, base_info_length = "\000\207", base_pos = <incomplete sequence \357>, key_parts = "\000\001", unique_key_parts = "\000\f", keys = 1 '\001', uniques = 1 '\001', not_used = 0 '\000', fulltext_keys = 0 '\000', data_file_type = 1 '\001', org_data_file_type = 1 '\001'}, state = {records = 0, del = 0, empty = 0, key_empty = 0, key_file_length = 8192, data_file_length = 0, checksum = 0, changed = 0, no_transid = 0}, common = {records = 0, del = 0, empty = 0, key_empty = 0, key_file_length = 0, data_file_length = 0, checksum = 0, changed = 0, no_transid = 0}, no_logging = {records = 0, del = 0, empty = 0, key_empty = 0, key_file_length = 0, data_file_length = 0, checksum = 0, changed = 0, no_transid = 0}, split = 0, dellink = 18446744073709551615, first_bitmap_with_space = 0, auto_increment = 0, create_trid = 0, last_change_trn = 0, update_count = 0, status = 0, rec_per_key_part = 0x7f8e081616f0, nulls_per_key_part = 0x7f8e081616f8, checksum = 0, key_root = 0x7f8e08161d78, key_del = 18446744073709551615, records_at_analyze = 0, sec_index_changed = 0, sec_index_used = 0, key_map = 1, version = 1652716841, create_time = 1652716841, recover_time = 0, check_time = 0, sortkey = 255, open_count = 0, changed = 0, create_rename_lsn = 0, is_of_horizon = 0, skip_redo_lsn = 0, logrec_file_id = 0, dupp_key = 0 '\000', state_diff_length = 0, state_length = 239, key_info = 0x0}, checkpoint_state = {header = {file_version = "\000\000\000", options = "\000", header_length = "\000", state_info_length = "\000", base_info_length = "\000", base_pos = "\000", key_parts = "\000", unique_key_parts = "\000", keys = 0 '\000', uniques = 0 '\000', not_used = 0 '\000', fulltext_keys = 0 '\000', data_file_type = 0 '\000', org_data_file_type = 0 '\000'}, state = {records = 0, del = 0, empty = 0, key_empty = 0, key_file_length = 0, data_file_length = 0, checksum = 0, changed = 0, no_transid = 0}, common = {records = 0, del = 0, empty = 0, key_empty = 0, key_file_length = 0, data_file_length = 0, checksum = 0, changed = 0, no_transid = 0}, no_logging = {records = 0, del = 0, empty = 0, key_empty = 0, key_file_length = 0, data_file_length = 0, checksum = 0, changed = 0, no_transid = 0}, split = 0, dellink = 0, first_bitmap_with_space = 0, auto_increment = 0, create_trid = 0, last_change_trn = 0, update_count = 0, status = 0, rec_per_key_part = 0x0, nulls_per_key_part = 0x0, checksum = 0, key_root = 0x0, key_del = 0, records_at_analyze = 0, sec_index_changed = 0, sec_index_used = 0, key_map = 0, version = 0, create_time = 0, recover_time = 0, check_time = 0, sortkey = 0, open_count = 0, changed = 0, create_rename_lsn = 0, is_of_horizon = 0, skip_redo_lsn = 0, logrec_file_id = 0, dupp_key = 0 '\000', state_diff_length = 0, state_length = 0, key_info = 0x0}, base = {keystart = 8192, max_data_file_length = 18446744073709551615, max_key_file_length = 18446744073709551615, margin_key_file_length = 0, records = 683212743470724133, reloc = 0, mean_row_length = 0, reclength = 403, pack_reclength = 403, min_pack_length = 24, max_pack_length = 131488, min_block_length = 20, fields = 13, fixed_not_null_fields = 5, fixed_not_null_fields_length = 14, max_field_lengths = 8, pack_fields = 2, varlength_fields = 0, rec_reflength = 7, key_reflength = 7, keys = 1, auto_key = 0, blobs = 2, pack_bytes = 1, original_null_bytes = 0, null_bytes = 0, field_offsets = 0, max_key_block_length = 8192, max_key_length = 23, extra_alloc_bytes = 0, extra_alloc_procent = 0, is_nulls_extended = 0, default_row_flag = 0, block_size = 8192, default_rec_buff_size = 0, extra_rec_buff_size = 0, extra_options = 0, language = 45, key_parts = 0, all_key_parts = 0, uuid = "\377\246\217\223\276^\021\347\241\025\000PV\221\364]", born_transactional = 0 '\000'}, state_history = 0x0, ft2_keyinfo = {share = 0x0, root_lock = {m_rwlock = {__data = {__lock = 0, __nr_readers = 0, __readers_wakeup = 0, __writer_wakeup = 0, __nr_readers_queued = 0, __nr_writers_queued = 0, __writer = 0, __shared = 0, __rwelision = 0 '\000', __pad1 = "\000\000\000\000\000\000", __pad2 = 0, __flags = 0}, __size = '\000' <repeats 55 times>, __align = 0}, m_psi = 0x0}, keysegs = 0, flag = 0, key_alg = 0 '\000', key_nr = 0 '\000', block_length = 0, underflow_block_length = 0, keylength = 0, minlength = 0, maxlength = 0, write_comp_flag = 0, version = 0, ftkey_nr = 0, seg = 0x0, end = 0x0, parser = 0x0, bin_search = 0x0, get_key = 0x0, skip_key = 0x0, pack_key = 0x0, store_key = 0x0, ck_insert = 0x0, ck_delete = 0x0, make_key = 0x0}, keyinfo = 0x7f8e08161700, uniqueinfo = 0x7f8e081617c0, keyparts = 0x7f8e081617d8, columndef = 0x7f8e081619b8, pack = {header_length = 0, ref_length = 0, version = 0 '\000'}, blobs = 0x7f8e08161ce8, column_nr = 0x7f8e08161cc8, unique_file_name = {str = 0x7f8e08161d18 "/tmp/#sql_5294_2.MAI", length = 20}, data_file_name = {str = 0x7f8e08161d48 "/tmp/#sql_5294_2.MAD", length = 20}, index_file_name = {str = 0x7f8e08161d30 "/tmp/#sql_5294_2.MAI", length = 20}, open_file_name = {str = 0x7f8e08161d60 "/tmp/#sql_5294_2", length = 16}, file_map = 0x0, open_list = 0x0, pagecache = 0x558f65cdfe20 <maria_pagecache_var>, decode_trees = 0x0, last_auto_increment = 0, decode_tables = 0x0, id = 0, once_init = 0x0, once_end = 0x0, init = 0x0, end = 0x0, read_record = 0x0, scan_init = 0x0, scan = 0x0, scan_end = 0x0, scan_remember_pos = 0x0, scan_restore_pos = 0x0, write_record_init = 0x0, write_record = 0x0, write_record_abort = 0x0, update_record = 0x0, delete_record = 0x0, compare_record = 0x0, calc_checksum = 0x0, calc_write_checksum = 0x0, calc_check_checksum = 0x0, compare_unique = 0x0, keypos_to_recpos = 0x0, recpos_to_keypos = 0x0, row_is_visible = 0x0, file_read = 0x0, file_write = 0x0, invalidator = 0x0, chst_invalidator = 0x0, key_del_current = 0, this_process = 0, last_process = 0, last_version = 0, options = 1041, min_pack_length = 0, max_pack_length = 0, state_diff_length = 0, rec_reflength = 0, keypage_header = 0, ftkeys = 0, kfile = {file = 0, pre_read_hook = 0x0, post_read_hook = 0x0, pre_write_hook = 0x0, post_write_hook = 0x0, flush_log_callback = 0x0, callback_data = 0x0}, data_file = 0, mode = 2, reopen = 0, in_trans = 0, w_locks = 0, r_locks = 0, tot_locks = 0, block_size = 0, max_index_block_size = 0, base_length = 0, write_flag = 0, data_file_type = STATIC_RECORD, page_type = PAGECACHE_EMPTY_PAGE, in_checkpoint = 0 '\000', temporary = 0 '\000', is_log_table = 0 '\000', has_null_fields = 0 '\000', has_varchar_fields = 0 '\000', open_count_not_zero_on_open = 0 '\000', changed = 0 '\000', global_changed = 0 '\000', not_flushed = 0 '\000', internal_table = 0 '\000', lock_key_trees = 0 '\000', non_transactional_concurrent_insert = 0 '\000', delay_key_write = 0 '\000', have_rtree = 0 '\000', now_transactional = 0 '\000', have_versioning = 0 '\000', key_del_used = 0 '\000', deleting = 0 '\000', lock = {list = {prev = 0x0, next = 0x0, data = 0x0}, mutex = {m_mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, m_psi = 0x0}, read_wait = {data = 0x0, last = 0x0}, read = {data = 0x0, last = 0x0}, write_wait = {data = 0x0, last = 0x0}, write = {data = 0x0, last = 0x0}, write_lock_count = 0, read_no_write_count = 0, get_status = 0x0, copy_status = 0x0, update_status = 0x0, restore_status = 0x0, start_trans = 0x0, check_status = 0x0, fix_status = 0x0, name = 0x0, allow_multiple_concurrent_insert = 0 '\000'}, lock_restore_status = 0x0, intern_lock = {m_mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, m_psi = 0x0}, key_del_lock = {m_mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, m_psi = 0x0}, key_del_cond = {m_cond = {__data = {__lock = 0, __futex = 0, __total_seq = 0, __wakeup_seq = 0, __woken_seq = 0, __mutex = 0x0, __nwaiters = 0, __broadcast_seq = 0}, __size = '\000' <repeats 47 times>, __align = 0}, m_psi = 0x0}, close_lock = {m_mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, m_psi = 0x0}, mmaped_length = 0, nonmmaped_inserts = 0, bitmap = {share = 0x0, map = 0x0, page = 0, last_bitmap_page = 0, changed = 0 '\000', changed_not_flushed = 0 '\000', return_first_match = 0 '\000', used_size = 0, full_head_size = 0, full_tail_size = 0, flush_all_requested = 0, waiting_for_flush_all_requested = 0, non_flushable = 0, waiting_for_non_flushable = 0, file = {file = 0, pre_read_hook = 0x0, post_read_hook = 0x0, pre_write_hook = 0x0, post_write_hook = 0x0, flush_log_callback = 0x0, callback_data = 0x0}, bitmap_lock = {m_mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, m_psi = 0x0}, bitmap_cond = {m_cond = {__data = {__lock = 0, __futex = 0, __total_seq = 0, __wakeup_seq = 0, __woken_seq = 0, __mutex = 0x0, __nwaiters = 0, __broadcast_seq = 0}, __size = '\000' <repeats 47 times>, __align = 0}, m_psi = 0x0}, sizes = {0, 0, 0, 0, 0, 0, 0, 0}, total_size = 0, max_total_size = 0, last_total_size = 0, block_size = 0, pages_covered = 0, pinned_pages = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0, malloc_flags = 0}}, mmap_lock = {m_rwlock = {__data = {__lock = 135667072, __nr_readers = 32654, __readers_wakeup = 0, __writer_wakeup = 0, __nr_readers_queued = 0, __nr_writers_queued = 0, __writer = 0, __shared = 0, __rwelision = 0 '\000', __pad1 = "\000\000\000\000\000\000", __pad2 = 0, __flags = 0}, __size = "\200\035\026\b\216\177", '\000' <repeats 49 times>, __align = 140247997750656}, m_psi = 0x0}, lsn_of_file_id = 0, crypt_page_header_space = 0, crypt_data = 0x0, last_insert_page = 0, last_insert_bitmap = 0}
|
share = 0x7f8e08160c18
|
rec_per_key_part = 0x7f8e0800c498
|
nulls_per_key_part = 0x7f8e0801c398
|
key_root = {18446744073709551615, 0 <repeats 230 times>, 94074350433156, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 140273363957424, 94074367210896, 4800, 94074376690400, 0, 140273472480652, 94074367210896, 4800, 94074376690400, 0, 140273363957312, 0, 140273363957424}
|
max_data_file_length = <optimized out>
|
versioning = <optimized out>
|
data_file = <optimized out>
|