Closed riern closed 9 years ago
glicht
commented
9 years ago Hi,
Thanks for reporting this. I am not seeing this reproduce on our local testing systems.
What kind of load to you have on the database? Does this reproduce for you without load.
Would you be able to reproduce this while GDB is connected and then supply the stack trace? Or another options is to create a core dump?
dthorell
commented
9 years ago Hi, We can only repoduce when the database is under some load. We run about 600 - 650 qps when we can make it crash, does not happen every time we issue the "use database" command. But if you do it enough time it will crash
Starting program: /usr/local/mysql/bin/mysqld --defaults-file=/db/mysql_main_fi_s_b/mysql_main_fi_s_b.cnf --user=mysql
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
2015-07-24 12:41:37 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[New Thread 0x7fffc4bfd700 (LWP 29822)]
2015-07-24 12:41:37 29650 [Warning] option 'audit-json-file-bufsize': signed value 0 adjusted to 1
2015-07-24 12:41:37 29650 [Warning] option 'plugin-audit-json-file-bufsize': signed value 0 adjusted to 1
2015-07-24 12:41:37 29650 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-07-24 12:41:37 29650 [Note] InnoDB: The InnoDB memory heap is disabled
2015-07-24 12:41:37 29650 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-07-24 12:41:37 29650 [Note] InnoDB: Memory barrier is not used
2015-07-24 12:41:37 29650 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-07-24 12:41:37 29650 [Note] InnoDB: Using Linux native AIO
2015-07-24 12:41:37 29650 [Note] InnoDB: Using CPU crc32 instructions
2015-07-24 12:41:37 29650 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2015-07-24 12:41:37 29650 [Note] InnoDB: Completed initialization of buffer pool
[New Thread 0x7fff15ff0700 (LWP 29823)]
[New Thread 0x7fff157ef700 (LWP 29824)]
[New Thread 0x7fff14fee700 (LWP 29825)]
[New Thread 0x7fff147ed700 (LWP 29826)]
[New Thread 0x7fff13fec700 (LWP 29827)]
[New Thread 0x7fff137eb700 (LWP 29828)]
[New Thread 0x7fff12fea700 (LWP 29829)]
[New Thread 0x7fff127e9700 (LWP 29830)]
[New Thread 0x7fff11fe8700 (LWP 29831)]
[New Thread 0x7fff117e7700 (LWP 29832)]
[New Thread 0x7fff10fe6700 (LWP 29833)]
[New Thread 0x7fff107e5700 (LWP 29834)]
[New Thread 0x7fff0ffe4700 (LWP 29835)]
[New Thread 0x7fff0f7e3700 (LWP 29836)]
[New Thread 0x7fff0efe2700 (LWP 29837)]
[New Thread 0x7fff0e7e1700 (LWP 29838)]
[New Thread 0x7fff0dfe0700 (LWP 29839)]
[New Thread 0x7fff0d7df700 (LWP 29840)]
[New Thread 0x7fff0cfde700 (LWP 29841)]
[New Thread 0x7fff0c7dd700 (LWP 29842)]
[New Thread 0x7fff0bfdc700 (LWP 29843)]
[New Thread 0x7fff0b7db700 (LWP 29844)]
2015-07-24 12:41:37 29650 [Note] InnoDB: Highest supported file format is Barracuda.
2015-07-24 12:41:37 29650 [Note] InnoDB: The log sequence numbers 780300068770 and 780300068770 in ibdata files do not match the log sequence number 780301171894 in the ib_logfiles!
2015-07-24 12:41:37 29650 [Note] InnoDB: Database was not shutdown normally!
2015-07-24 12:41:37 29650 [Note] InnoDB: Starting crash recovery.
2015-07-24 12:41:37 29650 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-07-24 12:41:37 29650 [Note] InnoDB: Restoring possible half-written data pages
2015-07-24 12:41:37 29650 [Note] InnoDB: from the doublewrite buffer...
[New Thread 0x7fff087bc700 (LWP 29845)]
InnoDB: Last MySQL binlog file position 0 367868047, file name mysql-bin.000012
[Thread 0x7fff087bc700 (LWP 29845) exited]
[New Thread 0x7fff087bc700 (LWP 29973)]
2015-07-24 12:41:37 29650 [Note] InnoDB: 128 rollback segment(s) are active.
[New Thread 0x7fff0afda700 (LWP 29976)]
[Thread 0x7fff087bc700 (LWP 29973) exited]
[New Thread 0x7fff0a7d9700 (LWP 29977)]
[New Thread 0x7fff087bc700 (LWP 29987)]
[New Thread 0x7fff09fd8700 (LWP 29988)]
[New Thread 0x7fff097d7700 (LWP 29990)]
2015-07-24 12:41:37 29650 [Note] InnoDB: Waiting for purge to start
[New Thread 0x7fff07749700 (LWP 29998)]
[New Thread 0x7fff06f48700 (LWP 29999)]
2015-07-24 12:41:37 29650 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.20-rel68.0 started; log sequence number 780301171894
[New Thread 0x7fff06747700 (LWP 30000)]
[New Thread 0x7fff05f46700 (LWP 30001)]
[New Thread 0x7fff05745700 (LWP 30002)]
2015-07-24 12:41:37 29650 [Note] Audit Plugin: starting up. Version: 1.0.8 , Revision: 527 (64bit). AUDIT plugin interface version: 769 (0x301). MySQL Server version: 5.6.20-68.0-log.
2015-07-24 12:41:37 29650 [Note] Audit Plugin: setup_offsets audit_offsets: 8624, 8672, 4376, 5016, 88, 2720, 96, 0, 32, 104 validate_checksum: 1 offsets_by_version: 1
2015-07-24 12:41:38 29650 [Note] Audit Plugin: mysqld: /usr/local/mysql/bin/mysqld (86559c027aa9a33b7d3694cef7c6f4be)
2015-07-24 12:41:38 29650 [Note] Audit Plugin: setup_offsets Audit_formatter::thd_offsets values: 8624 8672 4376 5016 88 2720 96 0 32 104
2015-07-24 12:41:38 29650 [Note] Audit Plugin: extended offsets validate res: MySQL thread id 123456, OS thread handle 0x0, query id 789 aud_tusr
2015-07-24 12:41:38 29650 [Note] Audit Plugin: Validation passed. Using offsets from audit_offsets: 8624, 8672, 4376, 5016, 88, 2720, 96, 0, 32, 104
2015-07-24 12:41:38 29650 [Note] Audit Plugin: Set password_masking_cmds num: 7, value: CREATE_USER,GRANT,SET_OPTION,SLAVE_START,CREATE_SERVER,ALTER_SERVER,CHANGE_MASTER
2015-07-24 12:41:38 29650 [Note] Audit Plugin: Compile password_masking_regex res: [0]
2015-07-24 12:41:38 29650 [Note] Audit Plugin: Set password_masking_regex value: [identified(?:/\*.*?\*/|\s)*?by(?:/\*.*?\*/|\s)*?(?:password)?(?:/\*.*?\*/|\s)*?['|"](?<psw>.*?)(?<!\\)['|"]|password(?:/\*.*?\*/|\s)*?\((?:/\*.*?\*/|\s)*?['|"](?<psw>.*?)(?<!\\)['|"](?:/\*.*?\*/|\s)*?\)|password(?:/\*.*?\*/|\s)*?(?:for(?:/\*.*?\*/|\s)*?\S+?)?(?:/\*.*?\*/|\s)*?=(?:/\*.*?\*/|\s)*?['|"](?<psw>.*?)(?<!\\)['|"]|password(?:/\*.*?\*/|\s)*?['|"](?<psw>.*?)(?<!\\)['|"]]
2015-07-24 12:41:38 29650 [Note] Audit Plugin: Set json_socket_name str: [] value: [/tmp/mysql.audit__db_mysql_main_fi_s_b_13208]
2015-07-24 12:41:38 29650 [Note] Audit Plugin: bufsize for file [/db-log/mysql_main_fi_s_b/auditlog/audit.log]: 4096. Value of json_file_bufsize: 262144.
2015-07-24 12:41:38 29650 [Note] Audit Plugin: success opening file: /db-log/mysql_main_fi_s_b/auditlog/audit.log.
2015-07-24 12:41:38 29650 [Note] Audit Plugin: mem func addr: 0x7fffc427e6b0 mem start addr: 0x7fffc427f000 page size: 4096
2015-07-24 12:41:38 29650 [Note] Audit Plugin: hot patching function: 0x6f84c0, trampolineFunction: 0x7fffc427f000 trampolinePage: 0x7fffc427f000
2015-07-24 12:41:38 29650 [Note] Audit Plugin: hot patch for: mysql_execute_command (0x6f84c0) complete. Audit func: 0x7fffc427e040, Trampoline address: 0x7fffc427f000 size: 16.
2015-07-24 12:41:38 29650 [Note] Audit Plugin: hot patching function: 0x6bc880, trampolineFunction: 0x7fffc427f020 trampolinePage: 0x7fffc427f000
2015-07-24 12:41:38 29650 [Note] Audit Plugin: hot patch for: send_result_to_client (0x6bc880) complete. Audit func: 0x7fffc427dcc0, Trampoline address: 0x7fffc427f020 size: 15.
2015-07-24 12:41:38 29650 [Note] Audit Plugin: hot patching function: 0x6f4820, trampolineFunction: 0x7fffc427f040 trampolinePage: 0x7fffc427f000
2015-07-24 12:41:38 29650 [Note] Audit Plugin: hot patch for: check_table_access (0x6f4820) complete. Audit func: 0x7fffc427db70, Trampoline address: 0x7fffc427f040 size: 15.
2015-07-24 12:41:38 29650 [Note] Audit Plugin: hot patching function: 0x6b5580, trampolineFunction: 0x7fffc427f060 trampolinePage: 0x7fffc427f000
2015-07-24 12:41:38 29650 [Note] Audit Plugin: hot patch for: open_tables (0x6b5580) complete. Audit func: 0x7fffc427dd90, Trampoline address: 0x7fffc427f060 size: 18.
2015-07-24 12:41:38 29650 [Note] Audit Plugin: Done initializing sql command names. status_vars_index: [152], com_status_vars: [0x1215060].
2015-07-24 12:41:38 29650 [Note] Audit Plugin: Init completed successfully.
2015-07-24 12:41:38 29650 [Note] RSA private key file not found: /db/mysql_main_fi_s_b//private_key.pem. Some authentication plugins will not work.
2015-07-24 12:41:38 29650 [Note] RSA public key file not found: /db/mysql_main_fi_s_b//public_key.pem. Some authentication plugins will not work.
2015-07-24 12:41:38 29650 [Note] Server hostname (bind-address): '*'; port: 13208
2015-07-24 12:41:38 29650 [Note] IPv6 is available.
2015-07-24 12:41:38 29650 [Note] - '::' resolves to '::';
2015-07-24 12:41:38 29650 [Note] Server socket created on IP: '::'.
[New Thread 0x7fff08fd6700 (LWP 30003)]
2015-07-24 12:41:38 29650 [Note] Event Scheduler: Loaded 0 events
2015-07-24 12:41:38 29650 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.20-68.0-log' socket: '/tmp/mysql_main_fi_s_b.sock' port: 13208 Percona Server (GPL), Release 68.0, Revision 656
[New Thread 0x7fff08f95700 (LWP 30004)]
2015-07-24 12:41:52 29650 [Warning] IP address '172.17.2.57' could not be resolved: Name or service not known
[New Thread 0x7fff08b44700 (LWP 32212)]
[New Thread 0x7fff08b03700 (LWP 32213)]
[New Thread 0x7fff08ac2700 (LWP 32214)]
[New Thread 0x7fff08a81700 (LWP 32215)]
[New Thread 0x7fff08a40700 (LWP 32216)]
[New Thread 0x7fff04f44700 (LWP 32217)]
[New Thread 0x7fff04f03700 (LWP 32218)]
[New Thread 0x7fff04ec2700 (LWP 32219)]
[New Thread 0x7fff04e81700 (LWP 32220)]
[New Thread 0x7fff04e40700 (LWP 32221)]
[New Thread 0x7fff04dff700 (LWP 32222)]
[New Thread 0x7fff04dbe700 (LWP 32223)]
[New Thread 0x7fff04d7d700 (LWP 32224)]
[New Thread 0x7fff04d3c700 (LWP 32225)]
[New Thread 0x7fff04cfb700 (LWP 32226)]
[New Thread 0x7fff04cba700 (LWP 32227)]
[New Thread 0x7fff04c79700 (LWP 32228)]
[New Thread 0x7fff04c38700 (LWP 32229)]
[New Thread 0x7fff04bf7700 (LWP 32230)]
[New Thread 0x7fff04bb6700 (LWP 32231)]
[New Thread 0x7fff04b75700 (LWP 32232)]
2015-07-24 12:42:04 7fff05745700 InnoDB: FTS Optimize Removing table prisjakt_temporary/structure_55aecb6c36067
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fff04d7d700 (LWP 32224)]
0x00007ffff634e7d1 in __strlen_sse2_pminub () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install glibc-2.17-55.el7_0.5.x86_64 keyutils-libs-1.5.8-3.el7.x86_64 krb5-libs-1.11.3-49.el7.x86_64 libaio-0.3.109-12.el7.x86_64 libcom_err-1.42.9-4.el7.x86_64 libgcc-4.8.2-16.2.el7_0.x86_64 libselinux-2.2.2-6.el7.x86_64 libstdc++-4.8.2-16.2.el7_0.x86_64 nss-softokn-freebl-3.16.2.3-1.el7_0.x86_64 openssl098e-0.9.8e-29.el7.centos.2.x86_64 pcre-8.32-12.el7.x86_64 systemd-libs-208-11.el7_0.6.x86_64 xz-libs-5.1.2-8alpha.el7.x86_64 zlib-1.2.7-13.el7.x86_64
(gdb) backtrace full
#0 0x00007ffff634e7d1 in __strlen_sse2_pminub () from /lib64/libc.so.6
No symbol table info available.
#1 0x00007fffc42838b0 in Audit_json_formatter::event_format (this=0x7fffc43e2960 <json_formatter>, pThdData=0x7fff04d7be60, writer=0x7fffc43e2910 <json_file_handler+144>) at audit_handler.cc:409
gen = 0x7ffeb806a8f0
cmd = 0xbc1a85 "Init DB"
res = <optimized out>
qid = <optimized out>
stat = <optimized out>
thd = <optimized out>
thdid = <optimized out>
#2 0x00007fffc4282a75 in Audit_file_handler::handler_log_audit (this=0x7fffc43e2880 <json_file_handler>, pThdData=0x7fffc42bce18) at audit_handler.cc:317
res = <optimized out>
#3 0x00007fffc42825f7 in Audit_handler::log_audit (this=0x7fffc43e2880 <json_file_handler>, pThdData=0x7fff04d7be60) at audit_handler.cc:167
inst_thread_id = <optimized out>
plug_thread_id = <optimized out>
#4 0x00007fffc428266e in Audit_handler::log_audit_all (pThdData=0x7fff04d7be60) at audit_handler.cc:81
i = 1
#5 0x00007fffc427d89a in audit (pThdData=0x7fff04d7be60) at audit_plugin.cc:287
pThdPrintedList = 0x0
do_objs_cmds_check = true
#6 0x00007fffc427de38 in audit_notify (thd=<optimized out>, event_class=<optimized out>, event=<optimized out>) at audit_plugin.cc:460
ThdData = {m_pThd = 0x5122800, m_CmdName = 0xbc1a85 "Init DB", m_UserName = 0x7ffeb8029c70 "root", m_isSqlCmd = true, m_objIterType = ThdSesData::OBJ_DB, m_tables = 0x0, m_firstTable = false, m_tableInf = 0x0, m_index = 0}
#7 0x00000000006a8935 in plugins_dispatch (arg=0x7fff04d7beb0, plugin=<optimized out>, thd=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.cc:433
event_generic = 0x7fff04d7beb0
data = <optimized out>
#8 event_class_dispatch (event=0x7fff04d7bec0, event_class=0, thd=0x5122800) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.cc:469
plugins = 0x7ffeb803b6c0
plugins_last = 0x7ffeb803b6c8
event_generic = {event_class = 0, event = 0x7fff04d7bec0}
#9 general_class_handler(THD *, uint, typedef __va_list_tag __va_list_tag *) (thd=0x5122800, event_subtype=<optimized out>, ap=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.cc:69
event = {event_subclass = 3, general_error_code = 0, general_thread_id = 1630, general_user = 0x7fff04d7c7d0 "root[root] @ localhost []", general_user_length = 25, general_command = 0xbc1a85 "Init DB", general_command_length = 7, general_query = 0x0, general_query_length = 0,
general_charset = 0x124bb20 <my_charset_bin>, general_time = 1437734538, general_rows = 1, general_host = {str = 0xba6ffb "localhost", length = 9}, general_sql_command = {str = 0xbd3143 "error", length = 0}, general_external_user = {str = 0xc2f293 "", length = 0}, general_ip = {str = 0xc2f293 "",
length = 0}}
#10 0x00000000006a8b08 in mysql_audit_notify (thd=thd@entry=0x5122800, event_class=event_class@entry=0, event_subtype=event_subtype@entry=3) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.cc:194
ap = {{gp_offset = 48, fp_offset = 48, overflow_arg_area = 0x7fff04d7c108, reg_save_area = 0x7fff04d7bfb0}}
handlers = 0x1218cd0 <audit_handlers>
#11 0x0000000000700558 in mysql_audit_general (msg=0xbc1a85 "Init DB", error_code=0, event_subtype=3, thd=0x5122800) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.h:224
time = 1437734538
msglen = 7
user_buff = "root[root] @ localhost []\000(\304\377\177\000\000\000\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000 \313?\304\377\177\000\000\200\312\327\004\377\177\000\000\001\000\000\000\000\000\000\000n&(\304\377\177\000\000\200\312\327\004\377\177\000\000\200\312\327\004\377\177\000\000\001\000\000\000\000\000\000\000\232\330'\304\377\177\000\000\201\067(\373\000\200\377\377\214\000\000\000\000\000\000\000\000\311\327\004\377\177\000\000\022\300\271", '\000' <repeats 13 times>, "\200\310\327\004\377\177\000\000\200\000\000\000\000\000\000\000\021\067(\373@\000\000\000\t\000\000\000\377\177\000\000\002\000\000\000\000\000\000\000\062", '\000' <repeats 11 times>...
user = 0x7fff04d7c7d0 "root[root] @ localhost []"
query = {string = {str = 0x0, length = 0}, cs = 0x124bb20 <my_charset_bin>}
rows = 1
userlen = 25
msg = 0xbc1a85 "Init DB"
error_code = 0
event_subtype = 3
thd = 0x5122800
#12 dispatch_command (command=<optimized out>, thd=0x5122800, packet=<optimized out>, packet_length=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:1868
net = 0x5122a70
error = false
__FUNCTION__ = "dispatch_command"
#13 0x00000000007028e9 in do_command (thd=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:1049
return_value = <optimized out>
packet = <optimized out>
packet_length = <optimized out>
net = <optimized out>
command = <optimized out>
#14 0x00000000006ce8e2 in do_handle_one_connection (thd_arg=thd_arg@entry=0x5122800) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_connect.cc:1532
rc = <optimized out>
create_user = true
net = <optimized out>
thd = 0x5122800
#15 0x00000000006ce9d0 in handle_one_connection (arg=arg@entry=0x5122800) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_connect.cc:1443
thd = 0x5122800
#16 0x00000000009224a3 in pfs_spawn_thread (arg=0x50ebbb0) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/storage/perfschema/pfs.cc:1860
typed_arg = 0x50ebbb0
user_arg = 0x5122800
pfs = <optimized out>
user_start_routine = 0x6ce990 <handle_one_connection(void*)>
klass = <optimized out>
#17 0x00007ffff7bc7df3 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#18 0x00007ffff62e21ad in clone () from /lib64/libc.so.6
No symbol table info available.Thanks for the gdb stack trace. It is crashing on one of the strings we try to write to the audit log. I think it is related to the writing out of the DB name but I am not fully sure.
Can you provide the following:
In gdb after hitting the segmentation fault please print out:
p $_siginfo
Then choose frame 1 and print out the THD struct by doing the following:
frame 1
p *pThdData->m_pThdThe printout of p *pThdData->m_pThd is big. Make sure to print the whole struct. Best option is to enable gdb logging via: set logging on. Then output is copied to gdb.txt file in current dir.
dthorell
commented
9 years ago Here should be the info requested:
$1 = {si_signo = 11, si_errno = 0, si_code = 128, _sifields = {_pad = {0, 0, 63, 0, 111, 0, 7, 0, -2135723616, 32767, 0, 0, 98, 110, 0, 0, 0, 0, 119, 124, -2135723617, 32767, 0, 0, 0, 0, 0, 0}, _kill = {
si_pid = 0, si_uid = 0}, _timer = {si_tid = 0, si_overrun = 0, si_sigval = {sival_int = 63, sival_ptr = 0x3f}}, _rt = {si_pid = 0, si_uid = 0, si_sigval = {sival_int = 63, sival_ptr = 0x3f}},
_sigchld = {si_pid = 0, si_uid = 0, si_status = 63, si_utime = 476741369856, si_stime = 30064771072}, _sigfault = {si_addr = 0x0}, _sigpoll = {si_band = 0, si_fd = 63}}}
#1 0x00007fffc42838b0 in Audit_json_formatter::event_format (this=0x7fffc43e2960 <json_formatter>, pThdData=0x7fff04f01e60, writer=0x7fffc43e2910 <json_file_handler+144>) at audit_handler.cc:409
409 audit_handler.cc: No such file or directory.
$2 = {<MDL_context_owner> = {_vptr.MDL_context_owner = 0x11edd90 <vtable for THD+16>}, <Statement> = {<Query_arena> = {_vptr.Query_arena = 0x11eddf0 <vtable for THD+112>, free_list = 0x0,
mem_root = 0x5144160, state = Query_arena::STMT_CONVENTIONAL_EXECUTION}, id = 0, query_strip_comments = {buffer = 0x0, length = 0, buffer_length = 0}, mark_used_columns = MARK_COLUMNS_READ, name = {
str = 0x0, length = 1297036694400623619}, lex = 0x5142ed0, query_string = {string = {str = 0x0, length = 0}, cs = 0x124bb20 <my_charset_bin>}, rewritten_query = {Ptr = 0x0, str_length = 0,
Alloced_length = 0, alloced = false, str_charset = 0x124bb20 <my_charset_bin>}, db = 0x7ffed0038d60 "test", db_length = 4}, <Open_tables_state> = {m_reprepare_observers = {array = {
buffer = 0x4b7c450 "HhZ\366\377\177", elements = 0, max_element = 16, alloc_increment = 16, size_of_element = 8}}, open_tables = 0x0, temporary_tables = 0x0, LOCK_temporary_tables = {m_mutex = {
mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 3, __spins = 0, __list = {__prev = 0x0, __next = 0x0}},
__size = '\000' <repeats 16 times>, "\003", '\000' <repeats 22 times>, __align = 0}, spins = 8, rng_state = 1}, m_psi = 0x0}, derived_tables = 0x0, lock = 0x0, extra_lock = 0x0,
locked_tables_mode = LTM_NONE, current_tablenr = 0, state_flags = 0}, mdl_context = {m_wait = {m_LOCK_wait_status = {m_mutex = {mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0,
__kind = 0, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, spins = 0, rng_state = 1}, m_psi = 0x0}, m_COND_wait_status = {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}, m_wait_status = MDL_wait::EMPTY}, m_tickets = {{<I_P_List_null_counter> = {<No data fields>}, <I_P_List_no_push_back<MDL_ticket>> = {<No data fields>}, m_first = 0x0},
{<I_P_List_null_counter> = {<No data fields>}, <I_P_List_no_push_back<MDL_ticket>> = {<No data fields>}, m_first = 0x0},
{<I_P_List_null_counter> = {<No data fields>}, <I_P_List_no_push_back<MDL_ticket>> = {<No data fields>}, m_first = 0x0}}, m_owner = 0x51409c0, m_needs_thr_lock_abort = false, m_LOCK_waiting_for = {
m_prlock = {lock = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0},
no_active_readers = {__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}, active_readers = 0, writers_waiting_readers = 0, active_writer = 0 '\000'}, m_psi = 0x0}, m_waiting_for = 0x0}, rli_fake = 0x0, rli_slave = 0x0,
static DEFAULT_WHERE = 0xbbba0b "field list", query_cache_tls = {first_query_block = 0x0}, net = {vio = 0x50ed1a0, buff = 0x51444c0 "\a", buff_end = 0x51484c0 "ner Bro", <incomplete sequence \361>,
write_pos = 0x51444c0 "\a", read_pos = 0x51444c0 "\a", fd = 151, remain_in_buf = 0, length = 0, buf_length = 0, where_b = 0, max_packet = 16384, max_packet_size = 16777216, pkt_nr = 2,
compress_pkt_nr = 1, write_timeout = 60, read_timeout = 30, retry_count = 10, fcntl = 0, return_status = 0x5142bac, reading_or_writing = 0 '\000', save_char = 0 '\000', unused1 = 0 '\000',
unused2 = 0 '\000', compress = 0 '\000', unused3 = 0 '\000', unused = 0x0, last_errno = 0, error = 0 '\000', unused4 = -1 '\377', unused5 = -1 '\377',
last_error = '\000' <repeats 42 times>, "ve_SQL_", '\000' <repeats 56 times>, "\260\205\024\005\000\000\000\000\260E\024\005\000\000\000\000\260E\024\005\000\000\000\000\227\000\000\000aste\000\000\000\000\000\000\000\000\350\000\364\000\000\000\375\001\000\037\000\000-\000\000\061\000\000\000\000\000\000\000\000\000@\000\000\000\000\000\000\000\000\000\001\000\000\000\000\001\000\000\000\001\000\000\000<\000\000\000\036\000\000\000"..., sqlstate = "\000\000\000\000\000", extension = 0x5140ed8}, m_net_server_extension = {m_before_header = 0x5a98a0 <net_before_header_psi(st_net*, void*, unsigned long)>,
m_after_header = 0x5a9e90 <net_after_header_psi(st_net*, void*, unsigned long, char)>, m_user_data = 0x51409c0}, scheduler = 0x131b540 <thread_scheduler_struct>, protocol = 0x5140f00,
protocol_text = {<Protocol> = {_vptr.Protocol = 0x11ebb30 <vtable for Protocol_text+16>, thd = 0x51409c0, packet = 0x5140fc8, convert = 0x5140fe8, field_pos = 0, field_count = 1}, <No data fields>},
protocol_binary = {<Protocol> = {_vptr.Protocol = 0x11ebc30 <vtable for Protocol_binary+16>, thd = 0x51409c0, packet = 0x5140fc8, convert = 0x5140fe8, field_pos = 0, field_count = 4294967295},
bit_fields = 0}, user_vars = {key_offset = 0, key_length = 0, blength = 1, records = 0, flags = 0, array = {buffer = 0x50f5b10 "\270hZ\366\377\177", elements = 0, max_element = 16, alloc_increment = 32,
size_of_element = 16}, get_key = 0x6bf3c0 <get_var_key(user_var_entry*, size_t*, my_bool)>, free = 0x6bf760 <free_user_var(user_var_entry*)>, charset = 0x1305d60 <my_charset_utf8_general_ci>,
hash_function = 0x8cdea0 <cset_hash_sort_adapter>}, packet = {Ptr = 0x7ffed00009c0 "\373def", str_length = 1, Alloced_length = 16384, alloced = true, str_charset = 0x124bb20 <my_charset_bin>},
convert_buffer = {Ptr = 0x7ffed0007d90 "SELECT DATABASE()comment limit 1", str_length = 17, Alloced_length = 104, alloced = true, str_charset = 0x1305d60 <my_charset_utf8_general_ci>}, rand = {
seed1 = 846207249, seed2 = 967538772, max_value = 1073741823, max_value_dbl = 1073741823}, slog_rand = {seed1 = 260553784, seed2 = 175357986, max_value = 1073741823, max_value_dbl = 1073741823},
variables = {dynamic_variables_version = 13, dynamic_variables_ptr = 0x7ffed0032090 "\001", dynamic_variables_head = 72, dynamic_variables_size = 80, dynamic_variables_allocs = 0x0,
max_heap_table_size = 4294967296, tmp_table_size = 4294967296, long_query_time = 1000000, end_markers_in_json = 0 '\000', optimizer_switch = 65023, optimizer_trace = 0, optimizer_trace_features = 15,
optimizer_trace_offset = -1, optimizer_trace_limit = 1, optimizer_trace_max_mem_size = 16384, sql_mode = 64, option_bits = 2147748608, select_limit = 18446744073709551615,
max_join_size = 18446744073709551615, auto_increment_increment = 1, auto_increment_offset = 1, bulk_insert_buff_size = 536870912, eq_range_index_dive_limit = 10, join_buff_size = 4194304,
lock_wait_timeout = 31536000, max_allowed_packet = 16777216, max_error_count = 64, max_length_for_sort_data = 1024, max_sort_length = 1024, max_tmp_tables = 32, max_insert_delayed_threads = 20,
min_examined_row_limit = 0, multi_range_count = 256, myisam_repair_threads = 0, myisam_sort_buff_size = 0, myisam_stats_method = 0, net_buffer_length = 16384, net_interactive_timeout = 28800,
net_read_timeout = 30, net_retry_count = 10, net_wait_timeout = 28800, net_write_timeout = 60, optimizer_prune_level = 1, optimizer_search_depth = 62, preload_buff_size = 32768,
profiling_history_size = 15, read_buff_size = 131072, read_rnd_buff_size = 262144, div_precincrement = 4, sortbuff_size = 262144, max_sp_recursion_depth = 0, default_week_format = 3,
max_seeks_for_key = 18446744073709551615, range_alloc_block_size = 4096, query_alloc_block_size = 8192, query_prealloc_size = 8192, trans_alloc_block_size = 8192, trans_prealloc_size = 4096,
group_concat_max_len = 8192, binlog_format = 1, binlog_direct_non_trans_update = 0 '\000', binlog_row_image = 2, sql_log_bin = 1 '\001', completion_type = 0, query_cache_type = 0, tx_isolation = 1,
updatable_views_with_limit = 1, max_user_connections = 1000, my_aes_mode = 0, pseudo_thread_id = 2547, tx_read_only = 0 '\000', low_priority_updates = 0 '\000', new_mode = 0 '\000',
query_cache_wlock_invalidate = 0 '\000', engine_condition_pushdown = 1 '\001', keep_files_on_create = 0 '\000', online_alter_index = 0 '\000', old_alter_table = 0 '\000', old_passwords = 0,
big_tables = 0 '\000', table_plugin = 0x1455860, temp_table_plugin = 0x14403f0, character_set_filesystem = 0x124bb20 <my_charset_bin>, character_set_client = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>,
character_set_results = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, collation_server = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, collation_database = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>,
collation_connection = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, lc_messages = 0x131f140 <my_locale_en_US>, lc_time_names = 0x131f140 <my_locale_en_US>, time_zone = 0x133c508 <tz_SYSTEM>,
explicit_defaults_for_timestamp = 0 '\000', sysdate_is_now = 0 '\000', binlog_rows_query_log_events = 0 '\000', log_slow_rate_limit = 1, log_slow_filter = 0, log_slow_verbosity = 0, innodb_io_reads = 0,
innodb_io_read = 0, innodb_io_reads_wait_timer = 0, innodb_lock_que_wait_timer = 0, innodb_innodb_que_wait_timer = 0, innodb_page_access = 0, long_query_time_double = 1, pseudo_slave_mode = 0 '\000',
max_statement_time = 0, gtid_next = {type = AUTOMATIC_GROUP, gtid = {sidno = 0, gno = 0, static MAX_TEXT_LENGTH = 56}, static MAX_TEXT_LENGTH = 56}, gtid_next_list = {gtid_set = 0x0, is_non_null = false},
expand_fast_index_creation = 0 '\000', threadpool_high_prio_tickets = 4294967295, threadpool_high_prio_mode = 0}, status_var = {created_tmp_disk_tables = 0, created_tmp_tables = 0, ha_commit_count = 0,
ha_delete_count = 0, ha_read_first_count = 0, ha_read_last_count = 0, ha_read_key_count = 0, ha_read_next_count = 0, ha_read_prev_count = 0, ha_read_rnd_count = 0, ha_read_rnd_next_count = 0,
ha_multi_range_read_init_count = 0, ha_rollback_count = 0, ha_update_count = 0, ha_write_count = 0, ha_prepare_count = 0, ha_discover_count = 0, ha_savepoint_count = 0, ha_savepoint_rollback_count = 0,
ha_external_lock_count = 0, opened_tables = 0, opened_shares = 0, table_open_cache_hits = 0, table_open_cache_misses = 0, table_open_cache_overflows = 0, select_full_join_count = 0,
select_full_range_join_count = 0, select_range_count = 0, select_range_check_count = 0, select_scan_count = 0, long_query_count = 0, filesort_merge_passes = 0, filesort_range_count = 0, filesort_rows = 0,
filesort_scan_count = 0, com_stmt_prepare = 0, com_stmt_reprepare = 0, com_stmt_execute = 0, com_stmt_send_long_data = 0, com_stmt_fetch = 0, com_stmt_reset = 0, com_stmt_close = 0, bytes_received = 259,
bytes_sent = 292, questions = 3, com_other = 0, com_stat = {2, 0 <repeats 37 times>, 1, 0 <repeats 105 times>}, last_query_cost = 0, last_query_partial_plans = 0, max_statement_time_exceeded = 0,
max_statement_time_set = 0, max_statement_time_set_failed = 0}, initial_status_var = 0x0, lock_info = {thread = 140733276239616, thread_id = 2547}, LOCK_thd_data = {m_mutex = {mutex = {__data = {
__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 3, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 16 times>, "\003", '\000' <repeats 22 times>,
__align = 0}, spins = 8, rng_state = 1}, m_psi = 0x0}, stmt_map = {st_hash = {key_offset = 0, key_length = 0, blength = 1, records = 0, flags = 0, array = {buffer = 0x50f58f0 "\330jZ\366\377\177",
elements = 0, max_element = 16, alloc_increment = 32, size_of_element = 16}, get_key = 0x6bf680 <get_statement_id_as_hash_key(uchar const*, size_t*, my_bool)>,
free = 0x6bf6a0 <delete_statement_as_hash_key(void*)>, charset = 0x124bb20 <my_charset_bin>, hash_function = 0x8cdea0 <cset_hash_sort_adapter>}, names_hash = {key_offset = 0, key_length = 0,
blength = 1, records = 0, flags = 0, array = {buffer = 0x50f5a00 "\270gZ\366\377\177", elements = 0, max_element = 16, alloc_increment = 32, size_of_element = 16},
get_key = 0x6bf6c0 <get_stmt_name_hash_key(Statement*, size_t*, my_bool)>, free = 0x0, charset = 0x1305d60 <my_charset_utf8_general_ci>, hash_function = 0x8cdea0 <cset_hash_sort_adapter>},
last_found_statement = 0x0}, thread_stack = 0x7fff04f02d80 "\300\t\024\005", catalog = 0xbbba45 "std", main_security_ctx = {host = {Ptr = 0xba6ffb "localhost", str_length = 9, Alloced_length = 0,
alloced = false, str_charset = 0x1305d60 <my_charset_utf8_general_ci>}, ip = {Ptr = 0xc2f293 "", str_length = 0, Alloced_length = 0, alloced = false,
str_charset = 0x1305d60 <my_charset_utf8_general_ci>}, external_user = {Ptr = 0xc2f293 "", str_length = 0, Alloced_length = 0, alloced = false, str_charset = 0x1305d60 <my_charset_utf8_general_ci>},
user = 0x7ffed0019810 "root", priv_user = "root", '\000' <repeats 43 times>,
proxy_user = '\000' <repeats 16 times>, " \000\000\000\000\000\000\000\020\000\000\000\000\000\000\000\300\366k", '\000' <repeats 13 times>, "`]0\001\000\000\000\000\240ތ", '\000' <repeats 13 times>, "\200\315\327\004\377\177\000\000E\272\273", '\000' <repeats 29 times>, "`]", priv_host = "localhost", '\000' <repeats 21 times>, "`]0\001\000\000\000\000\223\362\302", '\000' <repeats 19 times>,
host_or_ip = 0xba6ffb "localhost", master_access = 536870911, db_access = 233258047, password_expired = false}, security_ctx = 0x5141ad8, proc_info = 0xba8219 "init", m_current_stage_key = 36,
where = 0xbbba0b "field list", client_capabilities = 4170373, max_client_packet_length = 16777216, handler_tables_hash = {key_offset = 0, key_length = 0, blength = 0, records = 0, flags = 0, array = {
buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0}, get_key = 0x0, free = 0x0, charset = 0x0, hash_function = 0x0}, ull_hash = {key_offset = 0, key_length = 0,
blength = 0, records = 0, flags = 0, array = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0}, get_key = 0x0, free = 0x0, charset = 0x0, hash_function = 0x0},
mysys_var = 0x7ffed00008c0, m_command = COM_INIT_DB, unmasked_server_id = 8, server_id = 8, file_id = 0, peer_port = 0, start_time = {tv_sec = 1437981811, tv_usec = 249048}, user_time = {tv_sec = 0,
tv_usec = 0}, prior_thr_create_utime = 0, thr_create_utime = 1437981811248822, start_utime = 1437981811249048, utime_after_lock = 1437981811249048, update_lock_default = TL_WRITE, di = 0x0,
bytes_sent_old = 281, tmp_tables_used = 0, tmp_tables_disk_used = 0, tmp_tables_size = 0, innodb_was_used = false, innodb_trx_id = 0, innodb_io_reads = 0, innodb_io_read = 0, innodb_io_reads_wait_timer = 0,
innodb_lock_que_wait_timer = 0, innodb_innodb_que_wait_timer = 0, innodb_page_access = 0, query_plan_flags = 0, query_plan_fsort_passes = 0, last_errno = 0, in_sub_stmt = 0, skip_wait_timeout = false,
fill_status_recursion_level = 0, ha_data = {{ha_ptr = 0x0, ha_info = {{m_next = 0x0, m_ht = 0x0, m_flags = 0 '\000'}, {m_next = 0x0, m_ht = 0x0, m_flags = 0 '\000'}}, lock = 0x0} <repeats 15 times>},
order_deterministic = false, binlog_next_event_pos = {file_name = 0x0, pos = 0}, binlog_row_event_extra_data = 0x0, timer = 0x0, timer_cache = 0x0, m_binlog_filter_state = THD::BINLOG_FILTER_UNKNOWN,
current_stmt_binlog_format = BINLOG_FORMAT_STMT, binlog_unsafe_warning_flags = 0, binlog_table_maps = 0, binlog_accessed_db_names = 0x0, m_trans_log_file = 0x0, m_trans_fixed_log_file = 0x0,
m_trans_end_pos = 0, transaction = {savepoints = 0x0, all = {no_2pc = false, rw_ha_count = 0, ha_list = 0x0, m_unsafe_rollback_flags = 0, static MODIFIED_NON_TRANS_TABLE = 1, static CREATED_TEMP_TABLE = 2,
static DROPPED_TEMP_TABLE = 4}, stmt = {no_2pc = false, rw_ha_count = 0, ha_list = 0x0, m_unsafe_rollback_flags = 0, static MODIFIED_NON_TRANS_TABLE = 1, static CREATED_TEMP_TABLE = 2,
static DROPPED_TEMP_TABLE = 4}, xid_state = {xid = {formatID = -1, gtrid_length = 0, bqual_length = 0, data = '\000' <repeats 127 times>}, xa_state = XA_NOTR, in_thd = true, rm_error = 0},
m_pending_rows_event = 0x0, changed_tables = 0x0, mem_root = {free = 0x7ffed0006d70, used = 0x0, pre_alloc = 0x7ffed0006d70, min_malloc = 32, block_size = 8160, block_num = 4, first_block_usage = 0,
error_handler = 0x6a8330 <sql_alloc_error_handler()>}, flags = {enabled = true, pending = false, xid_written = false, real_commit = false, commit_low = false, run_hooks = false}}, global_read_lock = {
m_state = Global_read_lock::GRL_NONE, m_mdl_global_shared_lock = 0x0, m_mdl_blocks_commits_lock = 0x0}, backup_tables_lock = {m_namespace = MDL_key::BACKUP, m_lock = 0x0, m_prot_lock = 0x0},
backup_binlog_lock = {m_namespace = MDL_key::BINLOG, m_lock = 0x0, m_prot_lock = 0x0}, dup_field = 0x0, signals = {__val = {0, 0, 0, 0, 0, 0, 0, 0, 4294967296, 0, 0, 0, 0, 0, 0, 32}},
active_vio = 0x50ed1a0, change_list = {<base_ilist<Item_change_record>> = {first = 0x5142470, sentinel = {_vptr.ilink = 0x11ec390 <vtable for ilink<Item_change_record>+16>, prev = 0x5142468,
next = 0x0}}, <No data fields>}, stmt_arena = 0x51409c8, table_map_for_update = 0, arg_of_last_insert_id_function = false, first_successful_insert_id_in_prev_stmt = 0,
first_successful_insert_id_in_prev_stmt_for_binlog = 0, first_successful_insert_id_in_cur_stmt = 0, stmt_depends_on_first_successful_insert_id_in_prev_stmt = false,
auto_inc_intervals_in_cur_stmt_for_binlog = {first_interval = {interval_min = 0, interval_values = 0, interval_max = 0, next = 0x0}, head = 0x0, tail = 0x0, current = 0x0, elements = 0},
auto_inc_intervals_forced = {first_interval = {interval_min = 0, interval_values = 0, interval_max = 0, next = 0x0}, head = 0x0, tail = 0x0, current = 0x0, elements = 0}, limit_found_rows = 1,
m_row_count_func = 0, cuted_fields = 0, m_sent_row_count = 0, m_examined_row_count = 0, m_user_connect = 0x7ffed0008910, db_charset = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, profiling = {
profile_id_counter = 1, thd = 0x51409c0, keeping = false, enabled = false, current = 0x0, last = 0x0, history = {first = 0x0, last = 0x0, elements = 0}}, m_statement_psi = 0x51425c0, m_statement_state = {
m_discarded = 0 '\000', m_no_index_used = 0 '\000', m_no_good_index_used = 0 '\000', m_flags = 15, m_class = 0x13ad440, m_thread = 0x7fffd907b140, m_timer_start = 1437981811249046356,
m_timer = 0xb683f0 <my_timer_nanoseconds>, m_statement = 0x7fffcf42d0b0, m_lock_time = 0, m_rows_sent = 0, m_rows_examined = 0, m_created_tmp_disk_tables = 0, m_created_tmp_tables = 0,
m_select_full_join = 0, m_select_full_range_join = 0, m_select_range = 0, m_select_range_check = 0, m_select_scan = 0, m_sort_merge_passes = 0, m_sort_range = 0, m_sort_rows = 0, m_sort_scan = 0,
m_digest_state = {m_last_id_index = 0, m_digest_storage = {m_full = 0 '\000', m_byte_count = 0, m_charset_number = 232,
m_token_array = "\330\002j\001(\000)\000\017\000version_comment\v\002}\003", '\000' <repeats 39 times>, "\017\000\000\000\200\323:\001\000\000\000\000@\200\005\331\377\177\000\000\210\060C\253ּ\364\023\360\203\266\000\000\000\000\000@v@\317\377\177", '\000' <repeats 126 times>...}},
m_schema_name = "arent)\000n\003\336\001\001\000k.\000\336\001\v\000kategori_id\236\001}\003is.\000\336\001\b\000junk_typ,\000\336\001\001\000f.\000\336\001\017\000visa_kreditinfo,\000\336\001\001\000f.\000\336\001\005\000orgnr,\000\336\001\001\000f.\000\336\001\017\000antal_billigast,\000\336\001\003\000fkm.\000\336\001\022\000konsument_mervarde\300\001\336\001\024\000prisjakt_nyaprisjakt.\000\336\001\004\000pr", m_schema_name_length = 0}, m_idle_psi = 0x5142b40, m_idle_state = {m_flags = 3, m_thread = 0x7fffd907b140, m_timer_start = 1437981811249044, m_timer = 0xb68420 <my_timer_microseconds>,
m_wait = 0x746b616a73697270}, m_server_idle = false, query_id = 5142, col_access = 0, statement_id_counter = 0, rand_saved_seed1 = 0, rand_saved_seed2 = 0, real_id = 140733276239616, thread_id = 2547,
tmp_table = 0, server_status = 2, open_options = 0, system_thread = NON_SYSTEM_THREAD, select_number = 1, tx_isolation = ISO_READ_COMMITTED, tx_read_only = false, count_cuted_fields = CHECK_FIELD_IGNORE,
updated_row_count = 0, sent_row_count_2 = 2, user_var_events = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0}, user_var_events_alloc = 0x0, next_to_commit = 0x0,
commit_error = THD::CE_NONE, durability_property = HA_REGULAR_DURABILITY, killed = THD::NOT_KILLED, scramble = "te|^DxRnR1<zsT(iX_Uk", slave_thread = false, one_shot_set = false, extra_port = false,
no_errors = false, password = 1 '\001', is_fatal_error = false, transaction_rollback_request = false, is_fatal_sub_stmt_error = false, query_start_used = false, query_start_usec_used = false,
rand_used = false, time_zone_used = false, substitute_null_with_insert_id = false, in_lock_tables = false, is_slave_error = false, bootstrap = false, thread_specific_used = false,
charset_is_system_charset = false, charset_is_collation_connection = true, charset_is_character_set_filesystem = true, enable_slow_log = true, abort_on_warning = false, got_warning = false,
derived_tables_processing = false, tablespace_op = 0 '\000', sp_runtime_ctx = 0x0, sp_proc_cache = 0x0, sp_func_cache = 0x0, query_name_consts = 0, current_linfo = 0x0, slave_net = 0x0,
current_connect_time = 1437981811, last_global_update_time = 1437981811, busy_time = 0, diff_total_busy_time = 0, cpu_time = 0, diff_total_cpu_time = 0, bytes_received = 9, diff_total_bytes_received = 0,
bytes_sent = 11, diff_total_bytes_sent = 0, binlog_bytes_written = 0, diff_total_binlog_bytes_written = 0, diff_total_sent_rows = 0, diff_total_updated_rows = 0, diff_total_read_rows = 0,
diff_select_commands = 0, diff_update_commands = 0, diff_other_commands = 0, diff_commit_trans = 0, diff_rollback_trans = 0, diff_denied_connections = 0, diff_lost_connections = 0,
diff_access_denied_errors = 0, diff_empty_queries = 0, query_delay_millis = 0, sys_var_tmp = {my_bool_value = 0 '\000', long_value = 0, ulong_value = 0, ulonglong_value = 0, double_value = 0},
binlog_evt_union = {do_union = false, unioned_events = false, unioned_events_trans = false, first_query_id = 0}, m_parser_state = 0x0, locked_tables_list = {m_locked_tables_root = {free = 0x0, used = 0x0,
pre_alloc = 0x0, min_malloc = 32, block_size = 8160, block_num = 4, first_block_usage = 0, error_handler = 0x6a8330 <sql_alloc_error_handler()>}, m_locked_tables = 0x0, m_locked_tables_last = 0x5142da0,
m_reopen_array = 0x0, m_locked_tables_count = 0}, work_part_info = 0x0, audit_class_plugins = {buffer = 0x7ffed0004c90 "8\257E\001", elements = 1, max_element = 16, alloc_increment = 16,
size_of_element = 8}, audit_class_mask = {1}, m_enable_plugins = true, m_release_resources_done = false, cleanup_done = false, owned_gtid = {sidno = 0, gno = 0, static MAX_TEXT_LENGTH = 56},
owned_gtid_set = {static default_string_format = {begin = 0xc2f293 "", end = 0xc2f293 "", sid_gno_separator = 0xba6f63 ":", gno_start_end_separator = 0xbbba09 "-", gno_gno_separator = 0xba6f63 ":",
gno_sid_separator = 0xbc3b09 ",\n", empty_set_string = 0xc2f293 "", begin_length = 0, end_length = 0, sid_gno_separator_length = 1, gno_start_end_separator_length = 1, gno_gno_separator_length = 1,
gno_sid_separator_length = 2, empty_set_string_length = 0}, static sql_string_format = {begin = 0xc20990 "'", end = 0xc20990 "'", sid_gno_separator = 0xba6f63 ":",
gno_start_end_separator = 0xbbba09 "-", gno_gno_separator = 0xba6f63 ":", gno_sid_separator = 0xc2098d "',\n'", empty_set_string = 0xbc3a56 "''", begin_length = 1, end_length = 1,
sid_gno_separator_length = 1, gno_start_end_separator_length = 1, gno_gno_separator_length = 1, gno_sid_separator_length = 4, empty_set_string_length = 2}, static commented_string_format = {
begin = 0xc20980 "# ", end = 0xc2f293 "", sid_gno_separator = 0xba6f63 ":", gno_start_end_separator = 0xbbba09 "-", gno_gno_separator = 0xba6f63 ":", gno_sid_separator = 0xc2097e ",\n# ",
empty_set_string = 0xc20983 "# [empty]", begin_length = 2, end_length = 0, sid_gno_separator_length = 1, gno_start_end_separator_length = 1, gno_gno_separator_length = 1, gno_sid_separator_length = 4,
empty_set_string_length = 9}, static CHUNK_GROW_SIZE = 8, sid_lock = 0x0, free_intervals_mutex = {m_mutex = {mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0,
__spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, spins = 0, rng_state = 0}, m_psi = 0x0}, sid_map = 0x143f170, intervals = {
buffer = 0x509e310 "\370gZ\366\377\177", elements = 0, max_element = 8, alloc_increment = 8, size_of_element = 8}, free_intervals = 0x0, chunks = 0x0, cached_string_length = -1,
cached_string_format = 0x0}, skip_gtid_rollback = false, event_scheduler = {m_psi = 0x0, data = 0x0}, opt_trace = {static flag_names = 0x1233b40 <Opt_trace_context::flag_names>,
static feature_names = <same as static member of an already seen type>,
static default_features = (Opt_trace_context::GREEDY_SEARCH | Opt_trace_context::RANGE_OPTIMIZER | Opt_trace_context::DYNAMIC_RANGE | Opt_trace_context::REPEATED_SUBSELECT), pimpl = 0x0,
I_S_disabled = 0}, m_internal_handler = 0x0, main_lex = {<Query_tables_list> = {sql_command = SQLCOM_END, query_tables = 0x0, query_tables_last = 0x5142ee0, query_tables_own_last = 0x0, sroutines = {
key_offset = 0, key_length = 0, blength = 0, records = 0, flags = 0, array = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0}, get_key = 0x0, free = 0x0,
charset = 0x0, hash_function = 0x0}, sroutines_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x5142f70}, sroutines_list_own_last = 0x5142f70,
sroutines_list_own_elements = 0, lock_tables_state = Query_tables_list::LTS_NOT_LOCKED, table_count = 0, static BINLOG_STMT_UNSAFE_ALL_FLAGS = 1048575, static binlog_stmt_unsafe_errcode = {1668, 1669,
1670, 1671, 1672, 1673, 1674, 1675, 1692, 1693, 1714, 1715, 1722, 1716, 1717, 1718, 1723, 1719, 1724, 1727}, binlog_stmt_flags = 0, stmt_accessed_table_flag = 0},
_vptr.LEX = 0x119a630 <vtable for LEX+16>, unit = {<st_select_lex_node> = {_vptr.st_select_lex_node = 0x11eec30 <vtable for st_select_lex_unit+16>, next = 0x0, prev = 0x0, master = 0x0, slave = 0x51435e8,
link_next = 0x0, link_prev = 0x0, options = 0, sql_cache = st_select_lex_node::SQL_CACHE_UNSPECIFIED, uncacheable = 0 '\000', linkage = GLOBAL_OPTIONS_TYPE, no_table_names_allowed = false,
no_error = false}, result_table_list = {next_local = 0x0, next_global = 0x0, prev_global = 0x0, db = 0x0, alias = 0x0, table_name = 0x0, schema_table_name = 0x0, option = 0x0,
context_of_embedding = 0x0, m_join_cond = 0x0, prep_join_cond = 0x0, sj_on_expr = 0x0, sj_inner_tables = 0, cond_equal = 0x0, natural_join = 0x0, is_natural_join = 96, join_using_fields = 0x5143060,
join_columns = 0x0, is_join_columns_complete = true, next_name_resolution_table = 0x0, index_hints = 0x11eebb0 <vtable for st_select_lex_node+16>, table = 0x0, table_id = {
static TABLE_ID_MAX = 281474976710655, m_id = 0}, derived_result = 0x0, correspondent_table = 0x51436d8, derived = 0x0, derived_keys_ready = false, schema_table = 0x0, schema_select_lex = 0x0,
schema_table_reformed = 4, schema_table_param = 0x0, select_lex = 0x0, view = 0x0, field_translation = 0x0, field_translation_end = 0x0, merge_underlying_list = 0x0, view_tables = 0x0,
belong_to_view = 0x0, referencing_view = 0x0, parent_l = 0x0, security_ctx = 0x0, view_sctx = 0x0, allowed_show = false, next_leaf = 0x0, where = 0x100000000, check_option = 0x131cc00 <end_of_list>,
select_stmt = {str = 0x5143158 "", length = 0}, md5 = {str = 0x131cc00 <end_of_list> "", length = 85209456}, source = {str = 0x0, length = 85209544}, view_db = {str = 0x0, length = 0}, view_name = {
str = 0x0, length = 85198240}, timestamp = {str = 0x0, length = 0}, definer = {user = {str = 0x0, length = 18803632}, host = {str = 0x0, length = 85207968}, password = {str = 0x5142b80 "",
length = 0}, plugin = {str = 0x0, length = 85210320}, auth = {str = 0x0, length = 0}, uses_identified_by_clause = false, uses_identified_with_clause = false,
uses_authentication_string_clause = false, uses_identified_by_password_clause = false}, file_version = 0, updatable_view = 140731649907352, algorithm = 140731649907352, view_suid = 0,
with_check = 85209544, effective_with_check = 160 '\240', effective_algorithm = VIEW_ALGORITHM_UNDEFINED, grant = {grant_table = 0x0, version = 0, privilege = 0, want_privilege = 0,
orig_want_privilege = 0, m_internal = {m_schema_lookup_done = false, m_schema_access = 0x0, m_table_lookup_done = false, m_table_access = 0x0}}, engine_data = 0, callback_func = 0x0,
lock_type = 85207728, outer_join = 0, shared = 0, db_length = 1, table_name_length = 140731649907352, updatable = 152, straight = 90, updating = false, force_index = 164, ignore_leaves = 254,
dep_tables = 0, on_expr_dep_tables = 0, nested_join = 0x51432d0, embedding = 0x0, join_list = 0x131cc00 <end_of_list>, cacheable_table = 232, table_in_first_from_clause = 50,
open_type = OT_TEMPORARY_OR_BASE, contain_auto_increment = false, multitable_view = false, compact_view_format = false, where_processed = false, check_option_processed = false,
required_type = (unknown: 20040704), timestamp_buffer = "\000\000\000\000\000\063\024\005", '\000' <repeats 11 times>, prelocking_placeholder = false, open_strategy = TABLE_LIST::OPEN_NORMAL,
internal_tmp_table = 40, is_alias = 51, is_fqtn = 20, view_creation_ctx = 0x131cc00 <end_of_list>, view_client_cs_name = {str = 0x5143328 "", length = 0}, view_connection_cl_name = {str = 0x0,
length = 20040704}, view_body_utf8 = {str = 0x5143348 "", length = 0}, derived_key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143360,
elements = 0}, <No data fields>}, trg_event_map = 112 'p', optimized_away = 51, i_s_requested_object = 0, has_db_lookup_value = false, has_table_lookup_value = false, table_open_method = 0,
schema_table_state = (unknown: 2751486616), mdl_request = {type = MDL_INTENTION_EXCLUSIVE, duration = MDL_STATEMENT, next_in_list = 0x0, prev_in_list = 0x5143398, ticket = 0x0, key = {m_length = 0,
m_db_name_length = 0,
m_ptr = '\000' <repeats 12 times>, "\270\063\024\005", '\000' <repeats 64 times>, "\b", '\000' <repeats 23 times>, "\001", '\000' <repeats 28 times>, "\314\061\001\000\000\000\000\070\064\024\005", '\000' <repeats 13 times>, "\314\061\001\000\000\000\000P4\024\005", '\000' <repeats 12 times>, "`4\024\005", '\000' <repeats 15 times>, "\200"..., static m_namespace_to_wait_state_name = {{m_key = 102,
m_name = 0xbb7aab "Waiting for global read lock", m_flags = 0}, {m_key = 103, m_name = 0xbb7ac8 "Waiting for backup lock", m_flags = 0}, {m_key = 104,
m_name = 0xbb7c68 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 105, m_name = 0xbb7c90 "Waiting for table metadata lock", m_flags = 0}, {m_key = 106,
m_name = 0xbb7cb0 "Waiting for stored function metadata lock", m_flags = 0}, {m_key = 107, m_name = 0xbb7ce0 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 108,
m_name = 0xbb7d10 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 109, m_name = 0xbb7d38 "Waiting for event metadata lock", m_flags = 0}, {m_key = 110,
m_name = 0xbb7ae0 "Waiting for commit lock", m_flags = 0}, {m_key = 79, m_name = 0xba72d8 "User lock", m_flags = 0}, {m_key = 111, m_name = 0xbb7af8 "Waiting for binlog lock", m_flags = 0}}}},
partition_names = 0x0, m_table_ref_type = TABLE_REF_NULL, m_table_ref_version = 0}, union_result = 0x0, table = 0x0, result = 0x0, found_rows_for_union = 0, saved_error = false, prepared = false,
optimized = false, executed = false, cleaned = true, item_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143578, elements = 0}, <No data fields>},
types = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143590, elements = 0}, <No data fields>}, global_parameters = 0x51435e8,
select_limit_cnt = 18446744073709551615, offset_limit_cnt = 0, item = 0x0, thd = 0x51409c0, fake_select_lex = 0x0, union_distinct = 0x0, describe = false, explain_marker = 0},
select_lex = {<st_select_lex_node> = {_vptr.st_select_lex_node = 0x11eecb0 <vtable for st_select_lex+16>, next = 0x0, prev = 0x5142fc0, master = 0x5142fa0, slave = 0x0, link_next = 0x0,
link_prev = 0x51438f0, options = 0, sql_cache = st_select_lex_node::SQL_CACHE_UNSPECIFIED, uncacheable = 0 '\000', linkage = UNSPECIFIED_TYPE, no_table_names_allowed = false, no_error = false},
context = {<Sql_alloc> = {<No data fields>}, outer_context = 0x0, table_list = 0x0, first_name_resolution_table = 0x0, last_name_resolution_table = 0x0, select_lex = 0x51435e8,
error_processor = 0x5dd5a0 <dummy_error_processor(THD*, void*)>, error_processor_data = 0x0, resolve_in_select_list = true, security_ctx = 0x0}, resolve_place = st_select_lex::RESOLVE_NONE,
resolve_nest = 0x0, db = 0x0, where = 0x0, having = 0x0, prep_where = 0x0, prep_having = 0x0, cond_value = Item::COND_UNDEF, having_value = Item::COND_UNDEF, parent_lex = 0x5142ed0,
olap = UNSPECIFIED_OLAP_TYPE, table_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x51436d8}, group_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0,
next = 0x51436f0}, group_list_ptrs = 0x0, item_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7ffed0005838, last = 0x7ffed0005838, elements = 1}, <No data fields>},
interval_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143720, elements = 0}, <No data fields>}, is_item_list_lookup = true,
ftfunc_list = 0x5143748, ftfunc_list_alloc = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143748, elements = 0}, <No data fields>}, join = 0x0,
top_join_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143768, elements = 0}, <No data fields>}, join_list = 0x5143768, embedding = 0x0,
sj_nests = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143790, elements = 0}, <No data fields>}, leaf_tables = 0x0,
order_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x51437b8}, order_list_ptrs = 0x0, gorder_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0,
next = 0x51437d8}, select_limit = 0x7ffed0005c70, offset_limit = 0x0, ref_pointer_array = {m_array = 0x7ffed0006178, m_size = 10}, derived_table_count = 0, materialized_table_count = 0,
partitioned_table_count = 0, select_n_having_items = 1, cond_count = 0, between_count = 0, max_equal_elems = 0, select_n_where_fields = 0, parsing_place = NO_MATTER, with_sum_func = false,
table_join_options = 0, in_sum_expr = 0, select_number = 1, nest_level = 0, inner_sum_func_list = 0x0, with_wild = 0, braces = false, having_fix_field = false, group_fix_field = false,
inner_refs_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143858, elements = 0}, <No data fields>}, n_sum_items = 0, n_child_sum_items = 0,
explicit_limit = false, subquery_in_having = false, first_execution = true, first_natural_join_processing = true, first_cond_optimization = false, no_wrap_view_item = false,
exclude_from_table_unique_test = false, non_agg_fields = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143880, elements = 0}, <No data fields>},
static ALL_FIELDS_UNDEF_POS = -2147483648, cur_pos_in_all_fields = -2147483648, udf_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x51438a0,
elements = 0}, <No data fields>}, prev_join_using = 0x0, select_list_tables = 0, removed_select = 0x0, m_non_agg_field_used = false, m_agg_func_used = false,
current_index_hint_type = INDEX_HINT_IGNORE, current_index_hint_clause = 0 '\000', index_hints = 0x0, static type_str = {0xbc3358 "NONE", 0xbbd0d8 "PRIMARY", 0xbb15f9 "SIMPLE", 0xbbd61d "DERIVED",
0xbbd625 "SUBQUERY", 0xbc316a "UNION", 0xbbd62e "UNION RESULT", 0xbbd63b "MATERIALIZED"}}, current_select = 0x0, all_selects_list = 0x51435e8, length = 0x0, dec = 0x0, change = 0x0, name = {str = 0x0,
length = 0}, help_arg = 0x0, to_log = 0x100000000 <Address 0x100000000 out of bounds>, x509_subject = 0x0, x509_issuer = 0x0, ssl_cipher = 0x0, wild = 0x0, exchange = 0x0, result = 0x0,
default_value = 0x0, on_update_value = 0x101000000, comment = {str = 0x131cc00 <end_of_list> "", length = 85211504}, ident = {str = 0x0, length = 2147483648}, grant_user = 0x131cc00 <end_of_list>,
xid = 0x5143990, thd = 0x51409c0, plugins = {buffer = 0x51439d0 "", elements = 0, max_element = 16, alloc_increment = 16, size_of_element = 8}, plugins_static_buffer = {0x0, 0x0, 0x51436d8,
0x0 <repeats 13 times>}, charset = 0x0, text_string_is_7bit = false, leaf_tables_insert = 0x0, create_view_select = {str = 0x0, length = 0}, raw_trg_on_table_name_begin = 0x0,
raw_trg_on_table_name_end = 0x0, part_info = 0x0, definer = 0x5140ab0, col_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143a98,
elements = 0}, <No data fields>}, ref_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143ab0, elements = 0}, <No data fields>},
load_set_str_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143ac8, elements = 0}, <No data fields>},
interval_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143ae0, elements = 0}, <No data fields>},
users_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143af8, elements = 0}, <No data fields>},
columns = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143b10, elements = 0}, <No data fields>}, insert_list = 0x0,
field_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143b30, elements = 0}, <No data fields>},
value_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143b48, elements = 0}, <No data fields>},
update_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143b60, elements = 0}, <No data fields>},
many_values = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143b78, elements = 0}, <No data fields>},
var_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143b90, elements = 0}, <No data fields>},
set_var_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143ba8, elements = 0}, <No data fields>},
param_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143bc0, elements = 0}, <No data fields>},
view_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143bd8, elements = 0}, <No data fields>},
context_stack = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7ffed0004df0, last = 0x7ffed0004df0, elements = 1}, <No data fields>}, set_statement = false, proc_analyse = 0x0,
auxiliary_table_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x5143c20}, save_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x5143c38},
last_field = 0x0, in_sum_func = 0x0, udf = {name = {str = 0x5143c50 "", length = 0}, returns = 3087089544, type = (UDFTYPE_AGGREGATE | unknown: 32764), dl = 0x7ffeb8013f88 "", dlhandle = 0x1,
func = 0x7ffeb80056f0, func_init = 0x7ffeb80056f0, func_deinit = 0x1, func_clear = 0x131cc00 <end_of_list>, func_add = 0x5143c98, usage_count = 0}, check_opt = {flags = 20040704, sql_flags = 0,
key_cache = 0x5143cb0}, create_info = {table_charset = 0x0, default_table_charset = 0x131cc00 <end_of_list>, connect_string = {str = 0x5143cc8 "", length = 0}, password = 0x7ffeb8004ee8 "",
tablespace = 0x7ffeb8004ee8 "", comment = {str = 0x1 <Address 0x1 out of bounds>, length = 0}, data_file_name = 0x0, index_file_name = 0x0, alias = 0x0, max_rows = 85212432, min_rows = 0,
auto_increment_value = 0, table_options = 85212456, avg_row_length = 0, used_fields = 0, key_block_size = 0, stats_sample_pages = 0, stats_auto_recalc = HA_STATS_AUTO_RECALC_DEFAULT,
merge_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x5143d60}, db_type = 0x6a8330 <sql_alloc_error_handler()>, row_type = ROW_TYPE_FIXED, null_bits = 0, options = 0,
merge_insert_method = 0, extra_size = 0, varchar = false, storage_media = HA_SM_DEFAULT}, key_create_info = {algorithm = HA_KEY_ALG_UNDEF, block_size = 0, parser_name = {str = 0x0, length = 0},
comment = {str = 0x0, length = 0}, check_for_duplicate_indexes = false}, mi = {host = 0x0, user = 0x0, password = 0x0, log_file_name = 0x0, bind_addr = 0x0, port = 0, connect_retry = 0,
heartbeat_period = 0, sql_delay = 0, pos = 0, server_id = 0, retry_count = 0, gtid = 0x0, gtid_until_condition = st_lex_master_info::UNTIL_SQL_BEFORE_GTIDS, until_after_gaps = false,
ssl = st_lex_master_info::LEX_MI_UNCHANGED, ssl_verify_server_cert = st_lex_master_info::LEX_MI_UNCHANGED, heartbeat_opt = st_lex_master_info::LEX_MI_UNCHANGED,
repl_ignore_server_ids_opt = st_lex_master_info::LEX_MI_UNCHANGED, retry_count_opt = st_lex_master_info::LEX_MI_UNCHANGED, auto_position = st_lex_master_info::LEX_MI_UNCHANGED, ssl_key = 0x0,
ssl_cert = 0x0, ssl_ca = 0x0, ssl_capath = 0x0, ssl_cipher = 0x0, ssl_crl = 0x0, ssl_crlpath = 0x0, relay_log_name = 0x0, relay_log_pos = 0, repl_ignore_server_ids = {buffer = 0x0, elements = 0,
max_element = 0, alloc_increment = 0, size_of_element = 0}, server_ids_buffer = {0, 0}}, slave_connection = {user = 0x0, password = 0x0, plugin_auth = 0x0, plugin_dir = 0x0}, server_options = {
port = -1, server_name_length = 0, server_name = 0x0, host = 0x0, db = 0x0, username = 0x0, password = 0x0, scheme = 0x0, socket = 0x0, owner = 0x0}, mqh = {questions = 0, updates = 0,
conn_per_hour = 0, user_conn = 0, specified_limits = 0}, reset_slave_info = {all = false}, type = 0, allow_sum_func = 0, m_sql_cmd = 0x0, expr_allows_subselect = true, ssl_type = SSL_TYPE_NONE,
duplicates = DUP_ERROR, tx_isolation = ISO_READ_UNCOMMITTED, xa_opt = XA_NONE, option_type = OPT_DEFAULT, create_view_mode = VIEW_CREATE_NEW, drop_mode = DROP_DEFAULT, profile_query_id = 0,
profile_options = 0, uint_geom_type = 0, grant = 0, grant_tot_col = 0, which_columns = 0, fk_match_option = Foreign_key::FK_MATCH_UNDEF, fk_update_opt = Foreign_key::FK_OPTION_UNDEF,
fk_delete_opt = Foreign_key::FK_OPTION_UNDEF, slave_thd_opt = 0, start_transaction_opt = 0, nest_level = 0, describe = 0 '\000', derived_tables = 0 '\000', create_view_algorithm = 0 '\000',
create_view_check = 0 '\000', context_analysis_only = 0 '\000', drop_if_exists = false, drop_temporary = false, local_file = false, one_shot_set = 224, autocommit = 7, verbose = false,
no_write_to_binlog = false, tx_chain = TVL_YES, tx_release = (unknown: 4), safe_to_cache_query = false, subqueries = false, ignore = false, parsing_options = {allows_variable = true,
allows_select_into = true, allows_select_procedure = true, allows_derived = true}, alter_info = {static ALTER_ADD_COLUMN = 1, static ALTER_DROP_COLUMN = 2, static ALTER_CHANGE_COLUMN = 4,
static ALTER_ADD_INDEX = 8, static ALTER_DROP_INDEX = 16, static ALTER_RENAME = 32, static ALTER_ORDER = 64, static ALTER_OPTIONS = 128, static ALTER_CHANGE_COLUMN_DEFAULT = 256,
static ALTER_KEYS_ONOFF = 512, static ALTER_CONVERT = 1024, static ALTER_RECREATE = 2048, static ALTER_ADD_PARTITION = 4096, static ALTER_DROP_PARTITION = 8192, static ALTER_COALESCE_PARTITION = 16384,
static ALTER_REORGANIZE_PARTITION = 32768, static ALTER_PARTITION = 65536, static ALTER_ADMIN_PARTITION = 131072, static ALTER_TABLE_REORG = 262144, static ALTER_REBUILD_PARTITION = 524288,
static ALTER_ALL_PARTITION = 1048576, static ALTER_REMOVE_PARTITIONING = 2097152, static ADD_FOREIGN_KEY = 4194304, static DROP_FOREIGN_KEY = 8388608, static ALTER_EXCHANGE_PARTITION = 16777216,
static ALTER_TRUNCATE_PARTITION = 33554432, static ALTER_COLUMN_ORDER = 67108864, drop_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143fd8,
elements = 0}, <No data fields>}, alter_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5143ff0, elements = 0}, <No data fields>},
key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5144008, elements = 0}, <No data fields>},
create_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5144020, elements = 0}, <No data fields>},
delayed_key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5144038, elements = 0}, <No data fields>}, delayed_key_info = 0x0,
delayed_key_count = 85212929, flags = 0, keys_onoff = Alter_info::LEAVE_AS_IS, partition_names = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5144068,
elements = 0}, <No data fields>}, num_parts = 0, requested_algorithm = Alter_info::ALTER_TABLE_ALGORITHM_DEFAULT, requested_lock = Alter_info::ALTER_TABLE_LOCK_DEFAULT},
create_last_non_select_table = 0x0, prepared_stmt_name = {str = 0x4011 <Address 0x4011 out of bounds>, length = 0}, prepared_stmt_code = {str = 0x4e40000 "p\a\344\004", length = 0},
prepared_stmt_code_is_varref = false, prepared_stmt_params = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x51440c0, elements = 0}, <No data fields>}, sphead =
0x0, spname = 0x0, sp_lex_in_use = 224, all_privileges = 64, proxy_priv = 20, is_change_password = false, is_set_password_sql = false, contains_plaintext_password = false, m_broken = false,
sp_current_parsing_ctx = 0x0, sp_chistics = {comment = {str = 0x131cc00 <end_of_list> "", length = 85213432}, suid = SP_IS_DEFAULT_SUID, detistic = 101, daccess = 20040704}, event_parse_data = 0x0,
only_view = false, empty_field_list_on_rset = false, create_view_suid = 0 '\000', {stmt_definition_begin = 0x131cc00 <end_of_list> "", keyword_delayed_begin_offset = 20040704}, {
stmt_definition_end = 0x5144128 "", keyword_delayed_end_offset = 85213480}, use_only_table_context = false, alter_tablespace_info = 0x4156202964657461, escape_used = false, is_lex_started = true,
used_tables = 0, explain_format = 0x0}, main_mem_root = {free = 0x7ffed0004d50, used = 0x0, pre_alloc = 0x7ffed0004d50, min_malloc = 32, block_size = 8160, block_num = 4, first_block_usage = 0,
error_handler = 0x6a8330 <sql_alloc_error_handler()>}, main_da = {m_is_sent = true, m_can_overwrite_status = false,
m_message = "\000\002!\020\000\000\000H\000\000\005\003def\024prisja\000\314\061\001\000\000\000\000\260A\024\005\000\000\000\000\000\000\000\000lver", '\000' <repeats 16 times>, "ill\000\000\000\000l", '\000' <repeats 13 times>, "Z\000\000\006\003def\024prisjakt_nyaprisja\000\000\000\000\000\000\000\000l\000erkare\022tillv_url_redir\000ct\022tillv_url_re\000\001rect\f-\001", '\000' <repeats 39 times>...,
m_sql_errno = 0, m_sqlstate = "\001\000\002\000\000R", m_affected_rows = 0, m_last_insert_id = 0, m_statement_warn_count = 0, m_status = Diagnostics_area::DA_OK, m_main_wi = {m_warn_root = {
free = 0x50d8370, used = 0x0, pre_alloc = 0x50d8370, min_malloc = 32, block_size = 2016, block_num = 4, first_block_usage = 0, error_handler = 0x6a8330 <sql_alloc_error_handler()>},
m_warn_list = {<I_P_List_counter> = {m_counter = 0}, <I_P_List_fast_push_back<Sql_condition>> = {m_last = 0x5144408}, m_first = 0x0}, m_warn_count = {0, 0, 0}, m_current_statement_warn_count = 0,
m_current_row_for_warning = 1, m_warn_id = 0, m_error_condition = 0x0, m_allow_unlimited_warnings = false, m_read_only = false, m_next_in_da = 0x0, m_prev_in_da = 0x5144478,
m_marked_sql_conditions = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x5144450, elements = 0}, <No data fields>}}, m_wi_stack = {<I_P_List_counter> = {
m_counter = 1}, <I_P_List_fast_push_back<Warning_info>> = {m_last = 0x5144440}, m_first = 0x51443c0}}, m_stmt_da = 0x5144198, m_binlog_invoker = false, invoker_user = {str = 0x0, length = 0},
invoker_host = {str = 0x0, length = 0}}Thanks for the info. I am still checking this out. Can you try setting
audit_whitelist_cmds=Init DB
This will cause the plugin to skip the Init DB command. After setting this please try running your tests again and see if a crash happens. If it doesn't happen we can be sure that this is really related only to the "use
dthorell
commented
9 years ago With that setting we have not managed to trigger a crash.
glicht
commented
9 years ago Thanks for the update. This at least confirms that the issue is specific to
"use
Still analyzing the previous info to try and understand why the crash happens. Will keep you updated. On Jul 28, 2015 10:18 AM, "dthorell" notifications@github.com wrote:
With that setting we have not managed to trigger a crash.
— Reply to this email directly or view it on GitHub https://github.com/mcafee/mysql-audit/issues/118#issuecomment-125480018.
glicht
commented
9 years ago I just committed a possible fix. Can you try out with the latest build from here (make sure to remove the audit_whitelist_cmds setting) :
If it still crashes please include: mysql error log, full stack trace and the info requested at previous comment: https://github.com/mcafee/mysql-audit/issues/118#issuecomment-124966179
dthorell
commented
9 years ago Unfortunately we still manage to crash it, we tried with Oracle GA build without any issues. Seems to be more stable with one thread running.
Stacktrace:
#0 0x00007ffff634e7d1 in __strlen_sse2_pminub () from /lib64/libc.so.6
No symbol table info available.
#1 0x00007fffc4283981 in Audit_json_formatter::event_format (this=0x7fffc43e2b20 <json_formatter>, pThdData=0x7fff08a7fe60, writer=0x7fffc43e2ad0 <json_file_handler+144>) at audit_handler.cc:409
gen = 0x7ffe94004c90
cmd = 0xbc1a85 "Init DB"
res = <optimized out>
qid = <optimized out>
stat = <optimized out>
thd = 0x50c9f30
thdid = <optimized out>
#2 0x00007fffc4282b35 in Audit_file_handler::handler_log_audit (this=0x7fffc43e2a40 <json_file_handler>, pThdData=0x7fffc42bd048) at audit_handler.cc:317
res = <optimized out>
#3 0x00007fffc42826b7 in Audit_handler::log_audit (this=0x7fffc43e2a40 <json_file_handler>, pThdData=0x7fff08a7fe60) at audit_handler.cc:167
inst_thread_id = <optimized out>
plug_thread_id = <optimized out>
#4 0x00007fffc428272e in Audit_handler::log_audit_all (pThdData=0x7fff08a7fe60) at audit_handler.cc:81
i = 1
#5 0x00007fffc427d95a in audit (pThdData=0x7fff08a7fe60) at audit_plugin.cc:287
pThdPrintedList = 0x0
do_objs_cmds_check = true
#6 0x00007fffc427def8 in audit_notify (thd=<optimized out>, event_class=<optimized out>, event=<optimized out>) at audit_plugin.cc:460
ThdData = {m_pThd = 0x50c9f30, m_CmdName = 0xbc1a85 "Init DB", m_UserName = 0x7ffe94011b30 "root", m_isSqlCmd = true, m_objIterType = ThdSesData::OBJ_DB, m_tables = 0x0, m_firstTable = false,
m_tableInf = 0x0, m_index = 0}
#7 0x00000000006a8935 in plugins_dispatch (arg=0x7fff08a7feb0, plugin=<optimized out>, thd=<optimized out>)
at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.cc:433
event_generic = 0x7fff08a7feb0
data = <optimized out>
#8 event_class_dispatch (event=0x7fff08a7fec0, event_class=0, thd=0x50c9f30) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.cc:469
plugins = 0x7ffe94006aa0
plugins_last = 0x7ffe94006aa8
event_generic = {event_class = 0, event = 0x7fff08a7fec0}
#9 general_class_handler(THD *, uint, typedef __va_list_tag __va_list_tag *) (thd=0x50c9f30, event_subtype=<optimized out>, ap=<optimized out>)
at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.cc:69
event = {event_subclass = 3, general_error_code = 0, general_thread_id = 23931, general_user = 0x7fff08a807d0 "root[root] @ localhost []", general_user_length = 25, general_command = 0xbc1a85 "Init DB",
general_command_length = 7, general_query = 0x0, general_query_length = 0, general_charset = 0x124bb20 <my_charset_bin>, general_time = 1438178321, general_rows = 1, general_host = {
str = 0xba6ffb "localhost", length = 9}, general_sql_command = {str = 0xbd3143 "error", length = 0}, general_external_user = {str = 0xc2f293 "", length = 0}, general_ip = {str = 0xc2f293 "", length = 0}}
#10 0x00000000006a8b08 in mysql_audit_notify (thd=thd@entry=0x50c9f30, event_class=event_class@entry=0, event_subtype=event_subtype@entry=3)
at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.cc:194
ap = {{gp_offset = 48, fp_offset = 48, overflow_arg_area = 0x7fff08a80108, reg_save_area = 0x7fff08a7ffb0}}
handlers = 0x1218cd0 <audit_handlers>
#11 0x0000000000700558 in mysql_audit_general (msg=0xbc1a85 "Init DB", error_code=0, event_subtype=3, thd=0x50c9f30)
at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.h:224
time = 1438178321
msglen = 7
user_buff = "root[root] @ localhost []\000(\304\377\177\000\000\000\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\340\314?\304\377\177\000\000\200\n\250\b\377\177\000\000\001\000\000\000\000\000\000\000.'(\304\377\177\000\000\200\n\250\b\377\177\000\000\200\n\250\b\377\177\000\000\001\000\000\000\000\000\000\000Z\331'\304\377\177\000\000\000\000\000\000\000\000\000\000\203\000\000\000\000\000\000\000\000\t\250\b\377\177\000\000\022\300\271", '\000' <repeats 13 times>, "\200\b\250\b\377\177\000\000\200\000\000\000\000\000\000\000\260\b\250\b@\000\000\000\257\b\250\b\377\177\000\000\002\000\000\000\000\000\000\000\062", '\000' <repeats 11 times>...
user = 0x7fff08a807d0 "root[root] @ localhost []"
query = {string = {str = 0x0, length = 0}, cs = 0x124bb20 <my_charset_bin>}
rows = 1
userlen = 25
msg = 0xbc1a85 "Init DB"
error_code = 0
event_subtype = 3
thd = 0x50c9f30
#12 dispatch_command (command=<optimized out>, thd=0x50c9f30, packet=<optimized out>, packet_length=<optimized out>)
at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:1868
net = 0x50ca1a0
error = false
__FUNCTION__ = "dispatch_command"
#13 0x00000000007028e9 in do_command (thd=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:1049
return_value = <optimized out>
packet = <optimized out>
packet_length = <optimized out>
net = <optimized out>
command = <optimized out>
#14 0x00000000006ce8e2 in do_handle_one_connection (thd_arg=thd_arg@entry=0x50d6c80) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_connect.cc:1532
rc = <optimized out>
create_user = true
net = <optimized out>
thd = 0x50c9f30
#15 0x00000000006ce9d0 in handle_one_connection (arg=arg@entry=0x50d6c80) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_connect.cc:1443
thd = 0x50d6c80
#16 0x00000000009224a3 in pfs_spawn_thread (arg=0x4e47cf0) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/storage/perfschema/pfs.cc:1860
typed_arg = 0x4e47cf0
user_arg = 0x50d6c80
pfs = <optimized out>
user_start_routine = 0x6ce990 <handle_one_connection(void*)>
klass = <optimized out>
#17 0x00007ffff7bc7df3 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#18 0x00007ffff62e21ad in clone () from /lib64/libc.so.6
No symbol table info available.
$1 = {si_signo = 11, si_errno = 0, si_code = 128, _sifields = {_pad = {0, 0, 0, 0, 48, 1, 0, 0, -1125042272, 32767, 0, 0, 91, 110, 0, 0, 0, 0, 119, 124, -1125042273, 32767, -440387584, 1593146086, 38843360, 0, 0, 0},
_kill = {si_pid = 0, si_uid = 0}, _timer = {si_tid = 0, si_overrun = 0, si_sigval = {sival_int = 0, sival_ptr = 0x0}}, _rt = {si_pid = 0, si_uid = 0, si_sigval = {sival_int = 0, sival_ptr = 0x0}}, _sigchld = {
si_pid = 0, si_uid = 0, si_status = 0, si_utime = 206158430208, si_stime = 1}, _sigfault = {si_addr = 0x0}, _sigpoll = {si_band = 0, si_fd = 0}}}
#1 0x00007fffc4283981 in Audit_json_formatter::event_format (this=0x7fffc43e2b20 <json_formatter>, pThdData=0x7fff08a7fe60, writer=0x7fffc43e2ad0 <json_file_handler+144>) at audit_handler.cc:409
409 audit_handler.cc: No such file or directory.
$2 = {<MDL_context_owner> = {_vptr.MDL_context_owner = 0x11edd90 <vtable for THD+16>}, <Statement> = {<Query_arena> = {_vptr.Query_arena = 0x11eddf0 <vtable for THD+112>, free_list = 0x0, mem_root = 0x50cd6d0,
state = Query_arena::STMT_CONVENTIONAL_EXECUTION}, id = 0, query_strip_comments = {buffer = 0x0, length = 0, buffer_length = 0}, mark_used_columns = MARK_COLUMNS_READ, name = {str = 0x0,
length = 8030604369041128041}, lex = 0x50cc440, query_string = {string = {str = 0x0, length = 0}, cs = 0x124bb20 <my_charset_bin>}, rewritten_query = {Ptr = 0x0, str_length = 0, Alloced_length = 0,
alloced = false, str_charset = 0x124bb20 <my_charset_bin>}, db = 0x7ffe9400e770 "test", db_length = 4}, <Open_tables_state> = {m_reprepare_observers = {array = {buffer = 0x4e2cac0 "HhZ\366\377\177",
elements = 0, max_element = 16, alloc_increment = 16, size_of_element = 8}}, open_tables = 0x0, temporary_tables = 0x0, LOCK_temporary_tables = {m_mutex = {mutex = {__data = {__lock = 0, __count = 0,
__owner = 0, __nusers = 0, __kind = 3, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 16 times>, "\003", '\000' <repeats 22 times>, __align = 0}, spins = 8, rng_state = 1},
m_psi = 0x0}, derived_tables = 0x0, lock = 0x0, extra_lock = 0x0, locked_tables_mode = LTM_NONE, current_tablenr = 0, state_flags = 0}, mdl_context = {m_wait = {m_LOCK_wait_status = {m_mutex = {mutex = {
__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, spins = 0, rng_state = 1},
m_psi = 0x0}, m_COND_wait_status = {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}, m_wait_status = MDL_wait::EMPTY}, m_tickets = {
{<I_P_List_null_counter> = {<No data fields>}, <I_P_List_no_push_back<MDL_ticket>> = {<No data fields>}, m_first = 0x0},
{<I_P_List_null_counter> = {<No data fields>}, <I_P_List_no_push_back<MDL_ticket>> = {<No data fields>}, m_first = 0x0},
{<I_P_List_null_counter> = {<No data fields>}, <I_P_List_no_push_back<MDL_ticket>> = {<No data fields>}, m_first = 0x0}}, m_owner = 0x50c9f30, m_needs_thr_lock_abort = false, m_LOCK_waiting_for = {m_prlock = {
lock = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, no_active_readers = {
__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},
active_readers = 0, writers_waiting_readers = 0, active_writer = 0 '\000'}, m_psi = 0x0}, m_waiting_for = 0x0}, rli_fake = 0x0, rli_slave = 0x0, static DEFAULT_WHERE = 0xbbba0b "field list",
query_cache_tls = {first_query_block = 0x0}, net = {vio = 0x50bdb10, buff = 0x50d6c80 "\a", buff_end = 0x50dac80 ";}s:15:\"\201\303\001", write_pos = 0x50d6c80 "\a", read_pos = 0x50d6c80 "\a", fd = 131,
remain_in_buf = 0, length = 8529659782979874405, buf_length = 8389759014281704033, where_b = 0, max_packet = 16384, max_packet_size = 16777216, pkt_nr = 2, compress_pkt_nr = 1, write_timeout = 60,
read_timeout = 30, retry_count = 10, fcntl = 1701274912, return_status = 0x50cc11c, reading_or_writing = 0 '\000', save_char = 100 'd', unused1 = 101 'e', unused2 = 44 ',', compress = 0 '\000', unused3 = 48 '0',
unused = 0x0, last_errno = 0, error = 0 '\000', unused4 = 100 'd', unused5 = 101 'e',
last_error = "\000, pdn.user_adder_id, mh.name AS add_user, mh.mgroup AS add_user_group, pdn.add_date\nFROM product_detail_numeric pdn\nLEFT JOIN prisjakt_forums.ibfmembers_heap mh ON (mh.id=pdn.user_adder_id)\nWHERE pdn"..., sqlstate = "skap_o", extension = 0x50ca448}, m_net_server_extension = {m_before_header = 0x5a98a0 <net_before_header_psi(st_net*, void*, unsigned long)>,
m_after_header = 0x5a9e90 <net_after_header_psi(st_net*, void*, unsigned long, char)>, m_user_data = 0x50c9f30}, scheduler = 0x131b540 <thread_scheduler_struct>, protocol = 0x50ca470,
protocol_text = {<Protocol> = {_vptr.Protocol = 0x11ebb30 <vtable for Protocol_text+16>, thd = 0x50c9f30, packet = 0x50ca538, convert = 0x50ca558, field_pos = 1969516402, field_count = 1}, <No data fields>},
protocol_binary = {<Protocol> = {_vptr.Protocol = 0x11ebc30 <vtable for Protocol_binary+16>, thd = 0x50c9f30, packet = 0x50ca538, convert = 0x50ca558, field_pos = 1601465205, field_count = 1226859625},
bit_fields = 824713294}, user_vars = {key_offset = 0, key_length = 0, blength = 1, records = 0, flags = 0, array = {buffer = 0x4e33970 "XiZ\366\377\177", elements = 0, max_element = 16, alloc_increment = 32,
size_of_element = 16}, get_key = 0x6bf3c0 <get_var_key(user_var_entry*, size_t*, my_bool)>, free = 0x6bf760 <free_user_var(user_var_entry*)>, charset = 0x1305d60 <my_charset_utf8_general_ci>,
hash_function = 0x8cdea0 <cset_hash_sort_adapter>}, packet = {Ptr = 0x7ffe94000990 "\373def", str_length = 1, Alloced_length = 16384, alloced = true, str_charset = 0x124bb20 <my_charset_bin>}, convert_buffer = {
Ptr = 0x7ffe9400e310 "SELECT DATABASE()comment limit 1\005", str_length = 17, Alloced_length = 104, alloced = true, str_charset = 0x1305d60 <my_charset_utf8_general_ci>}, rand = {seed1 = 16472122,
seed2 = 414805127, max_value = 1073741823, max_value_dbl = 1073741823}, slog_rand = {seed1 = 381493164, seed2 = 296994146, max_value = 1073741823, max_value_dbl = 1073741823}, variables = {
dynamic_variables_version = 13, dynamic_variables_ptr = 0x7ffe9400d220 "\001", dynamic_variables_head = 72, dynamic_variables_size = 80, dynamic_variables_allocs = 0x0, max_heap_table_size = 4294967296,
tmp_table_size = 4294967296, long_query_time = 1000000, end_markers_in_json = 0 '\000', optimizer_switch = 65023, optimizer_trace = 0, optimizer_trace_features = 15, optimizer_trace_offset = -1,
optimizer_trace_limit = 1, optimizer_trace_max_mem_size = 16384, sql_mode = 64, option_bits = 2147748608, select_limit = 18446744073709551615, max_join_size = 18446744073709551615, auto_increment_increment = 1,
auto_increment_offset = 1, bulk_insert_buff_size = 536870912, eq_range_index_dive_limit = 10, join_buff_size = 4194304, lock_wait_timeout = 31536000, max_allowed_packet = 16777216, max_error_count = 64,
max_length_for_sort_data = 1024, max_sort_length = 1024, max_tmp_tables = 32, max_insert_delayed_threads = 20, min_examined_row_limit = 0, multi_range_count = 256, myisam_repair_threads = 0,
myisam_sort_buff_size = 0, myisam_stats_method = 0, net_buffer_length = 16384, net_interactive_timeout = 28800, net_read_timeout = 30, net_retry_count = 10, net_wait_timeout = 28800, net_write_timeout = 60,
optimizer_prune_level = 1, optimizer_search_depth = 62, preload_buff_size = 32768, profiling_history_size = 15, read_buff_size = 131072, read_rnd_buff_size = 262144, div_precincrement = 4, sortbuff_size = 262144,
max_sp_recursion_depth = 0, default_week_format = 3, max_seeks_for_key = 18446744073709551615, range_alloc_block_size = 4096, query_alloc_block_size = 8192, query_prealloc_size = 8192,
trans_alloc_block_size = 8192, trans_prealloc_size = 4096, group_concat_max_len = 8192, binlog_format = 1, binlog_direct_non_trans_update = 0 '\000', binlog_row_image = 2, sql_log_bin = 1 '\001',
completion_type = 0, query_cache_type = 0, tx_isolation = 1, updatable_views_with_limit = 1, max_user_connections = 1000, my_aes_mode = 0, pseudo_thread_id = 23931, tx_read_only = 0 '\000',
low_priority_updates = 0 '\000', new_mode = 0 '\000', query_cache_wlock_invalidate = 0 '\000', engine_condition_pushdown = 1 '\001', keep_files_on_create = 0 '\000', online_alter_index = 0 '\000',
old_alter_table = 0 '\000', old_passwords = 0, big_tables = 0 '\000', table_plugin = 0x1455860, temp_table_plugin = 0x14403f0, character_set_filesystem = 0x124bb20 <my_charset_bin>,
character_set_client = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, character_set_results = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, collation_server = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>,
collation_database = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, collation_connection = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, lc_messages = 0x131f140 <my_locale_en_US>,
lc_time_names = 0x131f140 <my_locale_en_US>, time_zone = 0x133c508 <tz_SYSTEM>, explicit_defaults_for_timestamp = 0 '\000', sysdate_is_now = 0 '\000', binlog_rows_query_log_events = 0 '\000',
log_slow_rate_limit = 1, log_slow_filter = 0, log_slow_verbosity = 0, innodb_io_reads = 0, innodb_io_read = 0, innodb_io_reads_wait_timer = 0, innodb_lock_que_wait_timer = 0, innodb_innodb_que_wait_timer = 0,
innodb_page_access = 0, long_query_time_double = 1, pseudo_slave_mode = 0 '\000', max_statement_time = 0, gtid_next = {type = AUTOMATIC_GROUP, gtid = {sidno = 0, gno = 0, static MAX_TEXT_LENGTH = 56},
static MAX_TEXT_LENGTH = 56}, gtid_next_list = {gtid_set = 0x0, is_non_null = false}, expand_fast_index_creation = 0 '\000', threadpool_high_prio_tickets = 4294967295, threadpool_high_prio_mode = 0},
status_var = {created_tmp_disk_tables = 0, created_tmp_tables = 0, ha_commit_count = 0, ha_delete_count = 0, ha_read_first_count = 0, ha_read_last_count = 0, ha_read_key_count = 0, ha_read_next_count = 0,
ha_read_prev_count = 0, ha_read_rnd_count = 0, ha_read_rnd_next_count = 0, ha_multi_range_read_init_count = 0, ha_rollback_count = 0, ha_update_count = 0, ha_write_count = 0, ha_prepare_count = 0,
ha_discover_count = 0, ha_savepoint_count = 0, ha_savepoint_rollback_count = 0, ha_external_lock_count = 0, opened_tables = 0, opened_shares = 0, table_open_cache_hits = 0, table_open_cache_misses = 0,
table_open_cache_overflows = 0, select_full_join_count = 0, select_full_range_join_count = 0, select_range_count = 0, select_range_check_count = 0, select_scan_count = 0, long_query_count = 0,
filesort_merge_passes = 0, filesort_range_count = 0, filesort_rows = 0, filesort_scan_count = 0, com_stmt_prepare = 0, com_stmt_reprepare = 0, com_stmt_execute = 0, com_stmt_send_long_data = 0,
com_stmt_fetch = 0, com_stmt_reset = 0, com_stmt_close = 0, bytes_received = 259, bytes_sent = 292, questions = 3, com_other = 0, com_stat = {2, 0 <repeats 37 times>, 1, 0 <repeats 105 times>},
last_query_cost = 0, last_query_partial_plans = 0, max_statement_time_exceeded = 0, max_statement_time_set = 0, max_statement_time_set_failed = 0}, initial_status_var = 0x2d373030320a3036, lock_info = {
thread = 140733338621696, thread_id = 23931}, LOCK_thd_data = {m_mutex = {mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 3, __spins = 0, __list = {__prev = 0x0, __next = 0x0}},
__size = '\000' <repeats 16 times>, "\003", '\000' <repeats 22 times>, __align = 0}, spins = 8, rng_state = 1}, m_psi = 0x0}, stmt_map = {st_hash = {key_offset = 0, key_length = 0, blength = 1, records = 0,
flags = 0, array = {buffer = 0x4e2a130 "\270hZ\366\377\177", elements = 0, max_element = 16, alloc_increment = 32, size_of_element = 16},
get_key = 0x6bf680 <get_statement_id_as_hash_key(uchar const*, size_t*, my_bool)>, free = 0x6bf6a0 <delete_statement_as_hash_key(void*)>, charset = 0x124bb20 <my_charset_bin>,
hash_function = 0x8cdea0 <cset_hash_sort_adapter>}, names_hash = {key_offset = 0, key_length = 0, blength = 1, records = 0, flags = 0, array = {buffer = 0x4e312e0 "XiZ\366\377\177", elements = 0,
max_element = 16, alloc_increment = 32, size_of_element = 16}, get_key = 0x6bf6c0 <get_stmt_name_hash_key(Statement*, size_t*, my_bool)>, free = 0x0, charset = 0x1305d60 <my_charset_utf8_general_ci>,
hash_function = 0x8cdea0 <cset_hash_sort_adapter>}, last_found_statement = 0x0}, thread_stack = 0x7fff08a80d80 "0\237\f\005", catalog = 0xbbba45 "std", main_security_ctx = {host = {Ptr = 0xba6ffb "localhost",
str_length = 9, Alloced_length = 0, alloced = false, str_charset = 0x1305d60 <my_charset_utf8_general_ci>}, ip = {Ptr = 0xc2f293 "", str_length = 0, Alloced_length = 0, alloced = false,
str_charset = 0x1305d60 <my_charset_utf8_general_ci>}, external_user = {Ptr = 0xc2f293 "", str_length = 0, Alloced_length = 0, alloced = false, str_charset = 0x1305d60 <my_charset_utf8_general_ci>},
user = 0x7ffe94011b30 "root", priv_user = "root\000\061\066\rDrawmer DS404\n2007-11-06\006\064\067\064\062\065\060\006\071\062\065.00\004\060",
proxy_user = "\000\060\060\001\061\001\060\004-100\004\060.00\004\060.00\004\060.00\003\062\066\065\001\060\001\060\001\060\001\060\001\060\004\060.00\001\060\001\060\004\062\070\062\062\004\060.00\001\060\004\066\061\065\063\aDrawmer\003\066\070\071\vRäkkilaite\001\061\000\001\060\001\060\373\000\001\060\225\000\000\062\006\062\064\067\062\061\067\r",
priv_host = "localhost\000\065\060\061\n2007-11-06\006\064\067\064\062\064\071\006\067\063\065.00\004\060.00\001\061\001\060\004-100\004\060.00\004\060.0", host_or_ip = 0xba6ffb "localhost",
master_access = 536870911, db_access = 233258047, password_expired = false}, security_ctx = 0x50cb048, proc_info = 0xba8219 "init", m_current_stage_key = 36, where = 0xbbba0b "field list",
client_capabilities = 4170373, max_client_packet_length = 16777216, handler_tables_hash = {key_offset = 0, key_length = 0, blength = 0, records = 0, flags = 0, array = {buffer = 0x0, elements = 0, max_element = 0,
alloc_increment = 0, size_of_element = 0}, get_key = 0x0, free = 0x0, charset = 0x0, hash_function = 0x0}, ull_hash = {key_offset = 0, key_length = 0, blength = 0, records = 0, flags = 0, array = {buffer = 0x0,
elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0}, get_key = 0x0, free = 0x0, charset = 0x0, hash_function = 0x0}, mysys_var = 0x7ffe940008c0, m_command = COM_INIT_DB,
unmasked_server_id = 8, server_id = 8, file_id = 0, peer_port = 0, start_time = {tv_sec = 1438178321, tv_usec = 902781}, user_time = {tv_sec = 0, tv_usec = 0}, prior_thr_create_utime = 0,
thr_create_utime = 1438178321902624, start_utime = 1438178321902781, utime_after_lock = 1438178321902781, update_lock_default = TL_WRITE, di = 0xd39383230303606, bytes_sent_old = 281, tmp_tables_used = 0,
tmp_tables_disk_used = 0, tmp_tables_size = 0, innodb_was_used = false, innodb_trx_id = 0, innodb_io_reads = 0, innodb_io_read = 0, innodb_io_reads_wait_timer = 0, innodb_lock_que_wait_timer = 0,
innodb_innodb_que_wait_timer = 0, innodb_page_access = 0, query_plan_flags = 0, query_plan_fsort_passes = 0, last_errno = 0, in_sub_stmt = 0, skip_wait_timeout = false, fill_status_recursion_level = 0, ha_data = {{
ha_ptr = 0x0, ha_info = {{m_next = 0x0, m_ht = 0x0, m_flags = 0 '\000'}, {m_next = 0x0, m_ht = 0x0, m_flags = 0 '\000'}}, lock = 0x0} <repeats 15 times>}, order_deterministic = false, binlog_next_event_pos = {
file_name = 0x0, pos = 0}, binlog_row_event_extra_data = 0x0, timer = 0x0, timer_cache = 0x0, m_binlog_filter_state = THD::BINLOG_FILTER_UNKNOWN, current_stmt_binlog_format = BINLOG_FORMAT_STMT,
binlog_unsafe_warning_flags = 0, binlog_table_maps = 0, binlog_accessed_db_names = 0x0, m_trans_log_file = 0x0, m_trans_fixed_log_file = 0x0, m_trans_end_pos = 0, transaction = {savepoints = 0x0, all = {
no_2pc = false, rw_ha_count = 0, ha_list = 0x0, m_unsafe_rollback_flags = 0, static MODIFIED_NON_TRANS_TABLE = 1, static CREATED_TEMP_TABLE = 2, static DROPPED_TEMP_TABLE = 4}, stmt = {no_2pc = false,
rw_ha_count = 0, ha_list = 0x0, m_unsafe_rollback_flags = 0, static MODIFIED_NON_TRANS_TABLE = 1, static CREATED_TEMP_TABLE = 2, static DROPPED_TEMP_TABLE = 4}, xid_state = {xid = {formatID = -1,
gtrid_length = 0, bqual_length = 0, data = '\000' <repeats 127 times>}, xa_state = XA_NOTR, in_thd = true, rm_error = 0}, m_pending_rows_event = 0x0, changed_tables = 0x0, mem_root = {free = 0x7ffe9400d2f0,
used = 0x0, pre_alloc = 0x7ffe9400d2f0, min_malloc = 32, block_size = 8160, block_num = 4, first_block_usage = 0, error_handler = 0x6a8330 <sql_alloc_error_handler()>}, flags = {enabled = true, pending = false,
xid_written = false, real_commit = false, commit_low = false, run_hooks = false}}, global_read_lock = {m_state = Global_read_lock::GRL_NONE, m_mdl_global_shared_lock = 0x0, m_mdl_blocks_commits_lock = 0x0},
backup_tables_lock = {m_namespace = MDL_key::BACKUP, m_lock = 0x0, m_prot_lock = 0x0}, backup_binlog_lock = {m_namespace = MDL_key::BINLOG, m_lock = 0x0, m_prot_lock = 0x0}, dup_field = 0x3934373632077e00,
signals = {__val = {3459106686164480560, 3676397654309483269, 5984774835995160114, 5197275369155425893, 65095433531476, 3906649695752095615, 445857678228783929, 3820794317362510133, 3543491987312097593,
7598247080507939376, 3474306356889722990, 7597409209630992416, 9223372226528437614, 230864693583099910, 3833694886535640885, 3471770860290846766}}, active_vio = 0x50bdb10,
change_list = {<base_ilist<Item_change_record>> = {first = 0x50cb9e0, sentinel = {_vptr.ilink = 0x11ec390 <vtable for ilink<Item_change_record>+16>, prev = 0x50cb9d8, next = 0x0}}, <No data fields>},
stmt_arena = 0x50c9f38, table_map_for_update = 0, arg_of_last_insert_id_function = false, first_successful_insert_id_in_prev_stmt = 0, first_successful_insert_id_in_prev_stmt_for_binlog = 0,
first_successful_insert_id_in_cur_stmt = 0, stmt_depends_on_first_successful_insert_id_in_prev_stmt = false, auto_inc_intervals_in_cur_stmt_for_binlog = {first_interval = {interval_min = 0, interval_values = 0,
interval_max = 0, next = 0x0}, head = 0x0, tail = 0x0, current = 0x0, elements = 0}, auto_inc_intervals_forced = {first_interval = {interval_min = 0, interval_values = 0, interval_max = 0, next = 0x0},
head = 0x0, tail = 0x0, current = 0x0, elements = 0}, limit_found_rows = 1, m_row_count_func = 0, cuted_fields = 0, m_sent_row_count = 0, m_examined_row_count = 0, m_user_connect = 0x7ffe9400e590,
db_charset = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, profiling = {profile_id_counter = 1, thd = 0x50c9f30, keeping = 57, enabled = false, current = 0x0, last = 0x0, history = {first = 0x0, last = 0x0,
elements = 0}}, m_statement_psi = 0x50cbb30, m_statement_state = {m_discarded = 0 '\000', m_no_index_used = 0 '\000', m_no_good_index_used = 0 '\000', m_flags = 15, m_class = 0x13ad440,
m_thread = 0x7fffd9041540, m_timer_start = 1438178321902779615, m_timer = 0xb683f0 <my_timer_nanoseconds>, m_statement = 0x7fffcf3ef070, m_lock_time = 0, m_rows_sent = 0, m_rows_examined = 0,
m_created_tmp_disk_tables = 0, m_created_tmp_tables = 0, m_select_full_join = 0, m_select_full_range_join = 0, m_select_range = 0, m_select_range_check = 0, m_select_scan = 0, m_sort_merge_passes = 0,
m_sort_range = 0, m_sort_rows = 0, m_sort_scan = 0, m_digest_state = {m_last_id_index = 0, m_digest_storage = {m_full = 0 '\000', m_byte_count = 0, m_charset_number = 232,
m_token_array = "\330\002j\001(\000)\000\017\000version_comment\v\002}\003\060\060\005\062\071.00\003-10\016Severin WA2103,\000\000\214\006\065\062\065\064\062\066\003\065\061\066\001\060\005\063\067.00\005\063\067.00\003-10\016Severin BA3241,\000\000\215\a2988932\003\065\065\065\001\060\005\070\065.00\005\070\065.00\001\061\017Severin KA 4460-\000\000\216\a1511852\003\065\065\071\001\060\005\066\071.00\005\066\071.00\003-10\016Severin HM381"...}},
m_schema_name = "ect AT2292+\000\000\240\a2601355\003\065\067\060\001\060\005\062\071.90\005\063\065.00\001\061\016Severin WK3333-\000\000\241\a2670172\003\065\065\061\001\060\005\062\071.90\004\060.00\004-100\016Severin AT2281,\000\000\242\a2858851\003\065\067\060\001\060\005\063\064.90\005\063\065.00\001\061\017Severin WK 33891\000\000\243\a2866607\003\065\067\060\001\060\005\061\071.90\004\060.00\004-100\022Sev",
m_schema_name_length = 0}, m_idle_psi = 0x50cc0b0, m_idle_state = {m_flags = 3, m_thread = 0x7fffd9041540, m_timer_start = 1438178321902773, m_timer = 0xb68420 <my_timer_microseconds>,
m_wait = 0x6972657665530f30}, m_server_idle = false, query_id = 215889, col_access = 0, statement_id_counter = 0, rand_saved_seed1 = 229736556031771952, rand_saved_seed2 = 7311142452477309229,
real_id = 140733338621696, thread_id = 23931, tmp_table = 0, server_status = 2, open_options = 0, system_thread = NON_SYSTEM_THREAD, select_number = 1, tx_isolation = ISO_READ_COMMITTED, tx_read_only = false,
count_cuted_fields = CHECK_FIELD_IGNORE, updated_row_count = 0, sent_row_count_2 = 2, user_var_events = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0},
user_var_events_alloc = 0x42313932322054, next_to_commit = 0x0, commit_error = THD::CE_NONE, durability_property = HA_REGULAR_DURABILITY, killed = THD::NOT_KILLED, scramble = "A]4)mm\\c[#822D@PU7T\"",
slave_thread = false, one_shot_set = false, extra_port = false, no_errors = false, password = 1 '\001', is_fatal_error = false, transaction_rollback_request = false, is_fatal_sub_stmt_error = false,
query_start_used = false, query_start_usec_used = false, rand_used = false, time_zone_used = false, substitute_null_with_insert_id = false, in_lock_tables = false, is_slave_error = false, bootstrap = false,
thread_specific_used = false, charset_is_system_charset = false, charset_is_collation_connection = true, charset_is_character_set_filesystem = true, enable_slow_log = true, abort_on_warning = false,
got_warning = 114, derived_tables_processing = false, tablespace_op = 0 '\000', sp_runtime_ctx = 0x0, sp_proc_cache = 0x0, sp_func_cache = 0x0, query_name_consts = 0, current_linfo = 0x0, slave_net = 0x0,
current_connect_time = 1438178321, last_global_update_time = 1438178321, busy_time = 0, diff_total_busy_time = 0, cpu_time = 0, diff_total_cpu_time = 0, bytes_received = 9, diff_total_bytes_received = 0,
bytes_sent = 11, diff_total_bytes_sent = 0, binlog_bytes_written = 0, diff_total_binlog_bytes_written = 0, diff_total_sent_rows = 0, diff_total_updated_rows = 0, diff_total_read_rows = 0, diff_select_commands = 0,
diff_update_commands = 0, diff_other_commands = 0, diff_commit_trans = 0, diff_rollback_trans = 0, diff_denied_connections = 0, diff_lost_connections = 0, diff_access_denied_errors = 0, diff_empty_queries = 0,
query_delay_millis = 3617588191607810418, sys_var_tmp = {my_bool_value = 49 '1', long_value = 3677098935797494577, ulong_value = 3677098935797494577, ulonglong_value = 3677098935797494577,
double_value = 7.1952664625472718e-63}, binlog_evt_union = {do_union = false, unioned_events = 54, unioned_events_trans = 55, first_query_id = 4122817886525928757}, m_parser_state = 0x0, locked_tables_list = {
m_locked_tables_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 8160, block_num = 4, first_block_usage = 0, error_handler = 0x6a8330 <sql_alloc_error_handler()>},
m_locked_tables = 0x0, m_locked_tables_last = 0x50cc310, m_reopen_array = 0x0, m_locked_tables_count = 0}, work_part_info = 0x0, audit_class_plugins = {buffer = 0x7ffe94006aa0 "8\257E\001", elements = 1,
max_element = 16, alloc_increment = 16, size_of_element = 8}, audit_class_mask = {1}, m_enable_plugins = true, m_release_resources_done = false, cleanup_done = false, owned_gtid = {sidno = 0, gno = 0,
static MAX_TEXT_LENGTH = 56}, owned_gtid_set = {static default_string_format = {begin = 0xc2f293 "", end = 0xc2f293 "", sid_gno_separator = 0xba6f63 ":", gno_start_end_separator = 0xbbba09 "-",
gno_gno_separator = 0xba6f63 ":", gno_sid_separator = 0xbc3b09 ",\n", empty_set_string = 0xc2f293 "", begin_length = 0, end_length = 0, sid_gno_separator_length = 1, gno_start_end_separator_length = 1,
gno_gno_separator_length = 1, gno_sid_separator_length = 2, empty_set_string_length = 0}, static sql_string_format = {begin = 0xc20990 "'", end = 0xc20990 "'", sid_gno_separator = 0xba6f63 ":",
gno_start_end_separator = 0xbbba09 "-", gno_gno_separator = 0xba6f63 ":", gno_sid_separator = 0xc2098d "',\n'", empty_set_string = 0xbc3a56 "''", begin_length = 1, end_length = 1, sid_gno_separator_length = 1,
gno_start_end_separator_length = 1, gno_gno_separator_length = 1, gno_sid_separator_length = 4, empty_set_string_length = 2}, static commented_string_format = {begin = 0xc20980 "# ", end = 0xc2f293 "",
sid_gno_separator = 0xba6f63 ":", gno_start_end_separator = 0xbbba09 "-", gno_gno_separator = 0xba6f63 ":", gno_sid_separator = 0xc2097e ",\n# ", empty_set_string = 0xc20983 "# [empty]", begin_length = 2,
end_length = 0, sid_gno_separator_length = 1, gno_start_end_separator_length = 1, gno_gno_separator_length = 1, gno_sid_separator_length = 4, empty_set_string_length = 9}, static CHUNK_GROW_SIZE = 8,
sid_lock = 0x0, free_intervals_mutex = {m_mutex = {mutex = {__data = {__lock = 889403447, __count = 805385525, __owner = 775434501, __nusers = 855978041, __kind = 808463925, __spins = 1393438977, __list = {
__prev = 0x4b206e6972657665, __next = 0x2d3231323441}}, __size = "78\003\065\065\065\001\060\005\061\070.90\005\063\065.00\001\061\016Severin KA4212-\000", __align = 3459104491436193847},
spins = 909248435, rng_state = 942747958}, m_psi = 0x530013734350335}, sid_map = 0x143f170, intervals = {buffer = 0x50a8e70 "\370gZ\366\377\177", elements = 0, max_element = 8, alloc_increment = 8,
size_of_element = 8}, free_intervals = 0x0, chunks = 0x0, cached_string_length = -1, cached_string_format = 0x0}, skip_gtid_rollback = false, event_scheduler = {m_psi = 0x0, data = 0x0}, opt_trace = {
static flag_names = 0x1233b40 <Opt_trace_context::flag_names>, static feature_names = <same as static member of an already seen type>,
static default_features = (Opt_trace_context::GREEDY_SEARCH | Opt_trace_context::RANGE_OPTIMIZER | Opt_trace_context::DYNAMIC_RANGE | Opt_trace_context::REPEATED_SUBSELECT), pimpl = 0x0, I_S_disabled = 0},
m_internal_handler = 0x0, main_lex = {<Query_tables_list> = {sql_command = SQLCOM_END, query_tables = 0x0, query_tables_last = 0x50cc450, query_tables_own_last = 0x0, sroutines = {key_offset = 0, key_length = 0,
blength = 0, records = 0, flags = 0, array = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0}, get_key = 0x0, free = 0x0, charset = 0x0, hash_function = 0x0},
sroutines_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x50cc4e0}, sroutines_list_own_last = 0x50cc4e0, sroutines_list_own_elements = 0,
lock_tables_state = Query_tables_list::LTS_NOT_LOCKED, table_count = 0, static BINLOG_STMT_UNSAFE_ALL_FLAGS = 1048575, static binlog_stmt_unsafe_errcode = {1668, 1669, 1670, 1671, 1672, 1673, 1674, 1675, 1692,
1693, 1714, 1715, 1722, 1716, 1717, 1718, 1723, 1719, 1724, 1727}, binlog_stmt_flags = 0, stmt_accessed_table_flag = 0}, _vptr.LEX = 0x119a630 <vtable for LEX+16>, unit = {<st_select_lex_node> = {
_vptr.st_select_lex_node = 0x11eec30 <vtable for st_select_lex_unit+16>, next = 0x0, prev = 0x0, master = 0x0, slave = 0x50ccb58, link_next = 0x0, link_prev = 0x0, options = 0,
sql_cache = st_select_lex_node::SQL_CACHE_UNSPECIFIED, uncacheable = 0 '\000', linkage = GLOBAL_OPTIONS_TYPE, no_table_names_allowed = false, no_error = false}, result_table_list = {
next_local = 0x392e353505300139, next_global = 0x2d0430302e300430, prev_global = 0x657665530e303031, db = 0x30314b44206e6972 <Address 0x30314b44206e6972 out of bounds>,
alias = 0x3307bc00002e3131 <Address 0x3307bc00002e3131 out of bounds>, table_name = 0x3503333234303731 <Address 0x3503333234303731 out of bounds>,
schema_table_name = 0x2e39330530013037 <Address 0x2e39330530013037 out of bounds>, option = 0x430302e30043039 <Address 0x430302e30043039 out of bounds>, context_of_embedding = 0x7665530f3030312d,
m_join_cond = 0x204b57206e697265, prep_join_cond = 0xbd00002c33333739, sj_on_expr = 0x3230323434323307, sj_inner_tables = 3820512640572404995, cond_equal = 0x2e30350530302e30,
natural_join = 0x7665530f31013030, is_natural_join = 101, join_using_fields = 0xbe00002e39323739, join_columns = 0x3330323434323307, is_join_columns_complete = 3,
next_name_resolution_table = 0x302e300430352e39, index_hints = 0x530f3030312d0430, table = 0x41206e6972657665, table_id = {static TABLE_ID_MAX = 281474976710655, m_id = 0}, derived_result =
0x393034323307bf00, correspondent_table = 0x3001313535033237, derived = 0x300430392e393105, derived_keys_ready = 46, schema_table = 0x6e6972657665530f, schema_select_lex = 0x3632373920544120,
schema_table_reformed = 46, schema_table_param = 0x3135350333373930, select_lex = 0x30392e3933053001, view = 0x312d0430302e3004, field_translation = 0x72657665530f3030,
field_translation_end = 0x3739205441206e69, merge_underlying_list = 0xfec10000053233, view_tables = 0x2073656761000200, belong_to_view = 0x3334312064616572, referencing_view = 0x7461657263202c38,
parent_l = 0x77202c3232206465, security_ctx = 0x37206e6574746972, view_sctx = 0x2035382e330a3738, allowed_show = 114, next_leaf = 0x72632030302e3020, where = 0x2c732f7365746165,
check_option = 0x72772030302e3020, select_stmt = {str = 0x420a732f73657469 <Address 0x420a732f73657469 out of bounds>, length = 8029953811301164661}, md5 = {
str = 0x7220746968206c6f <Address 0x7220746968206c6f out of bounds>, length = 2319416725615244385}, source = {str = 0x202c30303031202f <Address 0x202c30303031202f out of bounds>,
length = 7020317316398542713}, view_db = {str = 0x74617220676e696b <Address 0x74617220676e696b out of bounds>, length = 3472592174454939749}, view_name = {
str = 0x3020746f6e203030 <Address 0x3020746f6e203030 out of bounds>, length = 734139722802147104}, timestamp = {str = 0x6572207365676150 <Address 0x6572207365676150 out of bounds>,
length = 7233173975514244193}, definer = {user = {str = 0x2c732f30302e3020 <Address 0x2c732f30302e3020 out of bounds>, length = 7234316346760520992}, host = {
str = 0x74756f6874697720 <Address 0x74756f6874697720 out of bounds>, length = 2338339510831767840}, password = {str = 0x202c732f30302e30 <Address 0x202c732f30302e30 out of bounds>,
length = 8223693244772278610}, plugin = {str = 0x6165686120646165 <Address 0x6165686120646165 out of bounds>, length = 8299905621758582884}, auth = {
str = 0x6e656c2055524c0a <Address 0x6e656c2055524c0a out of bounds>, length = 2318280917550964794}, uses_identified_by_clause = 117, uses_identified_with_clause = 110,
uses_authentication_string_clause = 122, uses_identified_by_password_clause = 105}, file_version = 3467835958897680469, updatable_view = 7887336905013938442, algorithm = 6589458273837854811,
view_suid = 7600508770471140656, with_check = 6714967570089451632, effective_with_check = 58 ':', effective_algorithm = 173879387, grant = {grant_table = 0x2d2d2d2d2d2d2d2d, version = 757935405,
privilege = 4706900771782809423, want_privilege = 3255269458571118932, orig_want_privilege = 3255307777713450285, m_internal = {m_schema_lookup_done = 45, m_schema_access = 0x6920736569726575,
m_table_lookup_done = 110, m_table_access = 0x2030202c42446f6e}}, engine_data = 2338324135100642673, callback_func = 0x6575657571206e69, lock_type = 1914712074, outer_join = 543449445,
shared = 2003134838, db_length = 7235441194394742373, table_name_length = 4775064025006940261, updatable = 10, straight = 48, updating = 32, force_index = 82, ignore_leaves = 87,
dep_tables = 8028075780950158945, on_expr_dep_tables = 8532478939210216302, nested_join = 0x656469736e692065, embedding = 0xa42446f6e6e4920, join_list = 0x617274204f522030, cacheable_table = 110,
table_in_first_from_clause = 115, open_type = (unknown: 1852795252), contain_auto_increment = 115, multitable_view = 32, compact_view_format = 97, where_processed = 99, check_option_processed = 116,
required_type = (unknown: 1936615712), timestamp_buffer = "ide InnoDB\n0 out of ", prelocking_placeholder = 49, open_strategy = 1936024608, internal_tmp_table = 99, is_alias = 114, is_fqtn = 105,
view_creation_ctx = 0x614d0a6465737520, view_client_cs_name = {str = 0x6165726874206e69 <Address 0x6165726874206e69 out of bounds>, length = 8315161617321959524}, view_connection_cl_name = {
str = 0x3231202e6f6e2073 <Address 0x3231202e6f6e2073 out of bounds>, length = 3539939709787321140}, view_body_utf8 = {str = 0x3036333333373034 <Address 0x3036333333373034 out of bounds>,
length = 2318285306957674809}, derived_key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cc8d0, elements = 0}, <No data fields>},
trg_event_map = 102 'f', optimized_away = 32, i_s_requested_object = 1763734391, has_db_lookup_value = 110, has_table_lookup_value = 115, table_open_method = 543450484,
schema_table_state = (PROCESSED_BY_CREATE_SORT_INDEX | unknown: 741357624), mdl_request = {type = 1684370529, duration = 942747936, next_in_list = 0x656c6564202c3334, prev_in_list = 0x72202c3020646574,
ticket = 0x3834333120646165, key = {m_length = 12341, m_db_name_length = 2610,
m_ptr = "10.69 inserts/s, 16.23 updates/s, 0.00 deletes/s, 4101.99 reads/s\n", '-' <repeats 12 times>, "\nTRANSACTIONS\n", '-' <repeats 12 times>, "\nTrx id counter 103236602\nPurge done for trx's n:o < 103236601 undo n:o < 0 state: running but i"..., static m_namespace_to_wait_state_name = {{m_key = 102, m_name = 0xbb7aab "Waiting for global read lock", m_flags = 0}, {m_key = 103,
m_name = 0xbb7ac8 "Waiting for backup lock", m_flags = 0}, {m_key = 104, m_name = 0xbb7c68 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 105,
m_name = 0xbb7c90 "Waiting for table metadata lock", m_flags = 0}, {m_key = 106, m_name = 0xbb7cb0 "Waiting for stored function metadata lock", m_flags = 0}, {m_key = 107,
m_name = 0xbb7ce0 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 108, m_name = 0xbb7d10 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 109,
m_name = 0xbb7d38 "Waiting for event metadata lock", m_flags = 0}, {m_key = 110, m_name = 0xbb7ae0 "Waiting for commit lock", m_flags = 0}, {m_key = 79, m_name = 0xba72d8 "User lock", m_flags = 0}, {
m_key = 111, m_name = 0xbb7af8 "Waiting for binlog lock", m_flags = 0}}}}, partition_names = 0x574f48530a74696e, m_table_ref_type = 556412704, m_table_ref_version = 4994009607405117488},
union_result = 0x0, table = 0x0, result = 0x0, found_rows_for_union = 0, saved_error = 49, prepared = false, optimized = false, executed = false, cleaned = true,
item_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ccae8, elements = 0}, <No data fields>}, types = {<base_list> = {<Sql_alloc> = {<No data fields>},
first = 0x131cc00 <end_of_list>, last = 0x50ccb00, elements = 0}, <No data fields>}, global_parameters = 0x50ccb58, select_limit_cnt = 18446744073709551615, offset_limit_cnt = 0, item = 0x0,
thd = 0x50c9f30, fake_select_lex = 0x0, union_distinct = 0x0, describe = false, explain_marker = 0}, select_lex = {<st_select_lex_node> = {_vptr.st_select_lex_node = 0x11eecb0 <vtable for st_select_lex+16>,
next = 0x0, prev = 0x50cc530, master = 0x50cc510, slave = 0x0, link_next = 0x0, link_prev = 0x50cce60, options = 0, sql_cache = st_select_lex_node::SQL_CACHE_UNSPECIFIED, uncacheable = 0 '\000',
linkage = UNSPECIFIED_TYPE, no_table_names_allowed = false, no_error = false}, context = {<Sql_alloc> = {<No data fields>}, outer_context = 0x0, table_list = 0x0, first_name_resolution_table = 0x0,
last_name_resolution_table = 0x0, select_lex = 0x50ccb58, error_processor = 0x5dd5a0 <dummy_error_processor(THD*, void*)>, error_processor_data = 0x0, resolve_in_select_list = true, security_ctx = 0x0},
resolve_place = st_select_lex::RESOLVE_NONE, resolve_nest = 0x0, db = 0x0, where = 0x0, having = 0x0, prep_where = 0x0, prep_having = 0x0, cond_value = Item::COND_UNDEF, having_value = Item::COND_UNDEF,
parent_lex = 0x50cc440, olap = UNSPECIFIED_OLAP_TYPE, table_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x50ccc48}, group_list = {<Sql_alloc> = {<No data fields>}, elements = 0,
first = 0x0, next = 0x50ccc60}, group_list_ptrs = 0x0, item_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7ffe9400f308, last = 0x7ffe9400f308, elements = 1}, <No data fields>},
interval_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ccc90, elements = 0}, <No data fields>}, is_item_list_lookup = true, ftfunc_list = 0x50cccb8,
ftfunc_list_alloc = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cccb8, elements = 0}, <No data fields>}, join = 0x0,
top_join_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cccd8, elements = 0}, <No data fields>}, join_list = 0x50cccd8, embedding = 0x0,
sj_nests = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ccd00, elements = 0}, <No data fields>}, leaf_tables = 0x0,
order_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x50ccd28}, order_list_ptrs = 0x0, gorder_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0,
next = 0x50ccd48}, select_limit = 0x7ffe9400f740, offset_limit = 0x0, ref_pointer_array = {m_array = 0x7ffe9400fc48, m_size = 10}, derived_table_count = 0, materialized_table_count = 0,
partitioned_table_count = 0, select_n_having_items = 1, cond_count = 0, between_count = 0, max_equal_elems = 0, select_n_where_fields = 0, parsing_place = NO_MATTER, with_sum_func = false,
table_join_options = 0, in_sum_expr = 0, select_number = 1, nest_level = 0, inner_sum_func_list = 0x0, with_wild = 0, braces = false, having_fix_field = false, group_fix_field = false,
inner_refs_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ccdc8, elements = 0}, <No data fields>}, n_sum_items = 0, n_child_sum_items = 0,
explicit_limit = false, subquery_in_having = false, first_execution = true, first_natural_join_processing = true, first_cond_optimization = false, no_wrap_view_item = false,
exclude_from_table_unique_test = false, non_agg_fields = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ccdf0, elements = 0}, <No data fields>},
static ALL_FIELDS_UNDEF_POS = -2147483648, cur_pos_in_all_fields = -2147483648, udf_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cce10,
elements = 0}, <No data fields>}, prev_join_using = 0x5f72657a696d6974, select_list_tables = 0, removed_select = 0x0, m_non_agg_field_used = false, m_agg_func_used = false,
current_index_hint_type = (INDEX_HINT_USE | unknown: 1768709988), current_index_hint_clause = 110 'n', index_hints = 0x6d6974706f186800, static type_str = {0xbc3358 "NONE", 0xbbd0d8 "PRIMARY",
0xbb15f9 "SIMPLE", 0xbbd61d "DERIVED", 0xbbd625 "SUBQUERY", 0xbc316a "UNION", 0xbbd62e "UNION RESULT", 0xbbd63b "MATERIALIZED"}}, current_select = 0x0, all_selects_list = 0x50ccb58, length = 0x0,
dec = 0x63726165735f7964 <Address 0x63726165735f7964 out of bounds>, change = 0x6e61722c6e6f3d68 <Address 0x6e61722c6e6f3d68 out of bounds>, name = {str = 0x0, length = 0},
help_arg = 0x5f63696d616e7964 <Address 0x5f63696d616e7964 out of bounds>, to_log = 0x6e6f3d65676e6172 <Address 0x6e6f3d65676e6172 out of bounds>,
x509_subject = 0x657461657065722c <Address 0x657461657065722c out of bounds>, x509_issuer = 0x6c65736275735f64 <Address 0x6c65736275735f64 out of bounds>,
ssl_cipher = 0x186e6f3d746365 <Address 0x186e6f3d746365 out of bounds>, wild = 0x0, exchange = 0x0, result = 0x0, default_value = 0x6f1c6a0000233101, on_update_value = 0x72657a696d697470, comment = {
str = 0x6d5f65636172745f <Address 0x6d5f65636172745f out of bounds>, length = 8313483719543322721}, ident = {str = 0x3833363105657a69 <Address 0x3833363105657a69 out of bounds>, length = 8101718903480130100},
grant_user = 0x5f72657a696d6974, xid = 0x666f5f6563617274, thd = 0x50c9f30, plugins = {buffer = 0x50ccf40 "e_schema_accounts_size\003\061\060\060&", elements = 0, max_element = 16, alloc_increment = 16,
size_of_element = 8}, plugins_static_buffer = {0x616d656863735f65, 0x746e756f6363615f, 0x3103657a69735f73, 0x701f6e0000263030, 0x6e616d726f667265, 0x6d656863735f6563, 0x7473656769645f61, 0x3105657a69735f73,
0x6f00003930303030, 0x6d726f6672657032, 0x6863735f65636e61, 0x6e6576655f616d65, 0x65676174735f7374, 0x726f747369685f73, 0x735f676e6f6c5f79, 0x3030303105657a69}, charset = 0x65702d7000003130,
text_string_is_7bit = 114, leaf_tables_insert = 0x0, create_view_select = {str = 0x5f73746e6576655f <Address 0x5f73746e6576655f out of bounds>, length = 7520856782095348851},
raw_trg_on_table_name_begin = 0x735f79726f747369 <Address 0x735f79726f747369 out of bounds>, raw_trg_on_table_name_end = 0x3d303102657a69 <Address 0x3d303102657a69 out of bounds>, part_info = 0x0,
definer = 0x735f65636e616d72, col_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd008, elements = 0}, <No data fields>},
ref_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd020, elements = 0}, <No data fields>},
load_set_str_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd038, elements = 0}, <No data fields>},
interval_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd050, elements = 0}, <No data fields>},
users_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd068, elements = 0}, <No data fields>}, columns = {<base_list> = {<Sql_alloc> = {<No data fields>},
first = 0x131cc00 <end_of_list>, last = 0x50cd080, elements = 0}, <No data fields>}, insert_list = 0x6e6f6c5f79726f74, field_list = {<base_list> = {<Sql_alloc> = {<No data fields>},
first = 0x131cc00 <end_of_list>, last = 0x50cd0a0, elements = 0}, <No data fields>}, value_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd0b8,
elements = 0}, <No data fields>}, update_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd0d0, elements = 0}, <No data fields>},
many_values = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd0e8, elements = 0}, <No data fields>}, var_list = {<base_list> = {<Sql_alloc> = {<No data fields>},
first = 0x131cc00 <end_of_list>, last = 0x50cd100, elements = 0}, <No data fields>}, set_var_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd118,
elements = 0}, <No data fields>}, param_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd130, elements = 0}, <No data fields>},
view_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd148, elements = 0}, <No data fields>}, context_stack = {<base_list> = {<Sql_alloc> = {<No data fields>},
first = 0x7ffe9400e8c0, last = 0x7ffe9400e8c0, elements = 1}, <No data fields>}, set_statement = false, proc_analyse = 0x0, auxiliary_table_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0,
next = 0x50cd190}, save_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x50cd1a8}, last_field = 0x70257a00002c3836, in_sum_func = 0x0, udf = {name = {
str = 0x6d656863735f6563 <Address 0x6d656863735f6563 out of bounds>, length = 7594862792242192225}, returns = 1767859564, type = (UDFTYPE_AGGREGATE | unknown: 1635021676),
dl = 0x353732057365636e <Address 0x353732057365636e out of bounds>, dlhandle = 0x70247b0000293133, func = 0x6e616d726f667265, func_init = 0x6d656863735f6563, func_deinit = 0x756d5f78616d5f61,
func_clear = 0x73616c635f786574, func_add = 0x2d30303203736573, usage_count = 7382074271570067456}, check_opt = {flags = 1634562671, sql_flags = 1600480110, key_cache = 0x6d5f616d65686373}, create_info = {
table_charset = 0x786574756d5f7861, default_table_charset = 0x636e6174736e695f, connect_string = {str = 0x3030303333057365 <Address 0x3030303333057365 out of bounds>, length = 8243117999284813865},
password = 0x65636e616d726f66 <Address 0x65636e616d726f66 out of bounds>, tablespace = 0x5f616d656863735f <Address 0x5f616d656863735f out of bounds>, comment = {
str = 0x6f6c77725f78616d <Address 0x6f6c77725f78616d out of bounds>, length = 8319100054834998115}, data_file_name = 0x2e3034027365 <Address 0x2e3034027365 out of bounds>,
index_file_name = 0x726f66726570277e <Address 0x726f66726570277e out of bounds>, alias = 0x63735f65636e616d <Address 0x63735f65636e616d out of bounds>, max_rows = 8674334613716165992,
min_rows = 6875698586323481183, auto_increment_value = 7305804385369681513, table_options = 2967925155225994611, avg_row_length = 7382074271553486848, used_fields = 6874009731983045231,
key_block_size = 7881124995402326899, stats_sample_pages = 1935636577, stats_auto_recalc = (HA_STATS_AUTO_RECALC_ON | HA_STATS_AUTO_RECALC_OFF | unknown: 1701536620),
merge_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x50cd2d0}, db_type = 0x6863735f65636e61, row_type = 1600220517, null_bits = 1601724781, options = 1801678707,
merge_insert_method = 1767863397, extra_size = 1635021678, varchar = 110, storage_media = (unknown: 842019588)}, key_create_info = {algorithm = 1701848193, block_size = 7166176321141105005, parser_name = {
str = 0x78616d5f616d6568 <Address 0x78616d5f616d6568 out of bounds>, length = 7160553427233436511}, comment = {str = 0x310373657373616c <Address 0x310373657373616c out of bounds>,
length = 8081852467830927413}, check_for_duplicate_indexes = 101}, mi = {host = 0x0, user = 0x0, password = 0x0, log_file_name = 0x0, bind_addr = 0x0, port = 0, connect_retry = 0, heartbeat_period = 0,
sql_delay = 0, pos = 0, server_id = 0, retry_count = 0, gtid = 0x0, gtid_until_condition = st_lex_master_info::UNTIL_SQL_BEFORE_GTIDS, until_after_gaps = false, ssl = st_lex_master_info::LEX_MI_UNCHANGED,
ssl_verify_server_cert = st_lex_master_info::LEX_MI_UNCHANGED, heartbeat_opt = st_lex_master_info::LEX_MI_UNCHANGED, repl_ignore_server_ids_opt = st_lex_master_info::LEX_MI_UNCHANGED,
retry_count_opt = st_lex_master_info::LEX_MI_UNCHANGED, auto_position = st_lex_master_info::LEX_MI_UNCHANGED, ssl_key = 0x0, ssl_cert = 0x0, ssl_ca = 0x0, ssl_capath = 0x0, ssl_cipher = 0x0, ssl_crl = 0x0,
ssl_crlpath = 0x0, relay_log_name = 0x0, relay_log_pos = 0, repl_ignore_server_ids = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0}, server_ids_buffer = {0, 0}},
slave_connection = {user = 0x6e6f69737365735f <Address 0x6e6f69737365735f out of bounds>, password = 0x7463656e6e6f635f <Address 0x7463656e6e6f635f out of bounds>,
plugin_auth = 0x735f73727474615f <Address 0x735f73727474615f out of bounds>, plugin_dir = 0x2932313503657a69 <Address 0x2932313503657a69 out of bounds>}, server_options = {port = -1, server_name_length = 0,
server_name = 0x0, host = 0x0, db = 0x0, username = 0x0, password = 0x0, scheme = 0x0, socket = 0x0, owner = 0x0}, mqh = {questions = 1769168755, updates = 822306170, conn_per_hour = 2240560,
user_conn = 1880984064, specified_limits = 1868984933}, reset_slave_info = {all = false}, type = 7882821499128604003, allow_sum_func = 0, m_sql_cmd = 0x0, expr_allows_subselect = true, ssl_type = 1684631560,
duplicates = DUP_ERROR, tx_isolation = 1680809317, xa_opt = 2037198690, option_type = OPT_DEFAULT, create_view_mode = (VIEW_ALTER | unknown: 1852399980),
drop_mode = (DROP_CASCADE | DROP_RESTRICT | unknown: 1600743004), profile_query_id = 794976115, profile_options = 0, uint_geom_type = 1466198384, grant = 176947200, grant_tot_col = 1735748720,
which_columns = 1683975785, fk_match_option = 793473641, fk_update_opt = 796029813, fk_delete_opt = 1633906540, slave_thd_opt = 1699753836, start_transaction_opt = 1852793714, nest_level = 0, describe = 0 '\000',
derived_tables = 0 '\000', create_view_algorithm = 101 'e', create_view_check = 114 'r', context_analysis_only = 0 '\000', drop_if_exists = 53, drop_temporary = 46, local_file = 54, one_shot_set = 46,
autocommit = 50, verbose = 48, no_write_to_binlog = 45, tx_chain = (TVL_UNKNOWN | unknown: 913073520), tx_release = (unknown: 758132280), safe_to_cache_query = false, subqueries = false, ignore = false,
parsing_options = {allows_variable = true, allows_select_into = true, allows_select_procedure = true, allows_derived = true}, alter_info = {static ALTER_ADD_COLUMN = 1, static ALTER_DROP_COLUMN = 2,
static ALTER_CHANGE_COLUMN = 4, static ALTER_ADD_INDEX = 8, static ALTER_DROP_INDEX = 16, static ALTER_RENAME = 32, static ALTER_ORDER = 64, static ALTER_OPTIONS = 128, static ALTER_CHANGE_COLUMN_DEFAULT = 256,
static ALTER_KEYS_ONOFF = 512, static ALTER_CONVERT = 1024, static ALTER_RECREATE = 2048, static ALTER_ADD_PARTITION = 4096, static ALTER_DROP_PARTITION = 8192, static ALTER_COALESCE_PARTITION = 16384,
static ALTER_REORGANIZE_PARTITION = 32768, static ALTER_PARTITION = 65536, static ALTER_ADMIN_PARTITION = 131072, static ALTER_TABLE_REORG = 262144, static ALTER_REBUILD_PARTITION = 524288,
static ALTER_ALL_PARTITION = 1048576, static ALTER_REMOVE_PARTITIONING = 2097152, static ADD_FOREIGN_KEY = 4194304, static DROP_FOREIGN_KEY = 8388608, static ALTER_EXCHANGE_PARTITION = 16777216,
static ALTER_TRUNCATE_PARTITION = 33554432, static ALTER_COLUMN_ORDER = 67108864, drop_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd548,
elements = 0}, <No data fields>}, alter_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd560, elements = 0}, <No data fields>},
key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd578, elements = 0}, <No data fields>}, create_list = {<base_list> = {<Sql_alloc> = {<No data fields>},
first = 0x131cc00 <end_of_list>, last = 0x50cd590, elements = 0}, <No data fields>}, delayed_key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd5a8,
elements = 0}, <No data fields>}, delayed_key_info = 0x6c6f636f746f7270, delayed_key_count = 1919252063, flags = 0, keys_onoff = Alter_info::LEAVE_AS_IS,
partition_names = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd5d8, elements = 0}, <No data fields>}, num_parts = 0,
requested_algorithm = Alter_info::ALTER_TABLE_ALGORITHM_DEFAULT, requested_lock = Alter_info::ALTER_TABLE_LOCK_DEFAULT}, create_last_non_select_table = 0x6f64756573701094, prepared_stmt_name = {
str = 0x5f6461657268745f <Address 0x5f6461657268745f out of bounds>, length = 3690476913652229225}, prepared_stmt_code = {str = 0x657571169500001c <Address 0x657571169500001c out of bounds>,
length = 7165064744915663218}, prepared_stmt_code_is_varref = 95, prepared_stmt_params = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50cd630,
elements = 0}, <No data fields>}, sphead = 0x0, spname = 0x0, sp_lex_in_use = false, all_privileges = 151, proxy_priv = 24, is_change_password = false, is_set_password_sql = false,
contains_plaintext_password = false, m_broken = false, sp_current_parsing_ctx = 0x0, sp_chistics = {comment = {str = 0x755f7365725f6e69 <Address 0x755f7365725f6e69 out of bounds>, length = 3907207151691786606},
suid = (SP_IS_NOT_SUID | SP_IS_SUID | unknown: 2550136848), detistic = 16, daccess = 1667201394}, event_parse_data = 0x0, only_view = false, empty_field_list_on_rset = false, create_view_suid = 153 '\231', {
stmt_definition_begin = 0x5f65686361635f79 <Address 0x5f65686361635f79 out of bounds>, keyword_delayed_begin_offset = 1633902457}, {
stmt_definition_end = 0x6f635f7069727473 <Address 0x6f635f7069727473 out of bounds>, keyword_delayed_end_offset = 1769108595}, use_only_table_context = false, alter_tablespace_info = 0x71109a0000154646,
escape_used = false, is_lex_started = true, used_tables = 0, explain_format = 0x0}, main_mem_root = {free = 0x7ffe9400e820, used = 0x0, pre_alloc = 0x7ffe9400e820, min_malloc = 32, block_size = 8160,
block_num = 4, first_block_usage = 0, error_handler = 0x6a8330 <sql_alloc_error_handler()>}, main_da = {m_is_sent = true, m_can_overwrite_status = false,
m_message = "\000\071\062\r\000\000\235\nrand_seed1\001\060\r\000\000\236\nrand_seed2\001\060\034\000\000\237\026range_alloc_block_size\004\064\060\071\066\030\000\000\240\020read_buffer_size\006\061\063\061\060\067\062\016\000\000\241\tread_only\003OFF\034\000\000\242\024read_rnd_buffer_size\006\062\066\062\061\064\064=\000\000\243\trelay_log2/db-log/mysql_main_fi_s_b/relaylog/mys"..., m_sql_errno = 0,
m_sqlstate = "\000\252\025rel", m_affected_rows = 0, m_last_insert_id = 0, m_statement_warn_count = 0, m_status = Diagnostics_area::DA_OK, m_main_wi = {m_warn_root = {free = 0x50929f0, used = 0x0,
pre_alloc = 0x50929f0, min_malloc = 32, block_size = 2016, block_num = 4, first_block_usage = 0, error_handler = 0x6a8330 <sql_alloc_error_handler()>}, m_warn_list = {<I_P_List_counter> = {
m_counter = 0}, <I_P_List_fast_push_back<Sql_condition>> = {m_last = 0x50cd978}, m_first = 0x0}, m_warn_count = {0, 0, 0}, m_current_statement_warn_count = 0, m_current_row_for_warning = 1, m_warn_id = 0,
m_error_condition = 0x0, m_allow_unlimited_warnings = false, m_read_only = false, m_next_in_da = 0x0, m_prev_in_da = 0x50cd9e8, m_marked_sql_conditions = {<base_list> = {<Sql_alloc> = {<No data fields>},
first = 0x131cc00 <end_of_list>, last = 0x50cd9c0, elements = 0}, <No data fields>}}, m_wi_stack = {<I_P_List_counter> = {m_counter = 1}, <I_P_List_fast_push_back<Warning_info>> = {m_last = 0x50cd9b0},
m_first = 0x50cd930}}, m_stmt_da = 0x50cd708, m_binlog_invoker = false, invoker_user = {str = 0x0, length = 0}, invoker_host = {str = 0x0, length = 0}}Error log:
150729 15:12:56 mysqld_safe Starting mysqld daemon with databases from /db/mysql_main_fi_s_b/
2015-07-29 15:12:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-07-29 15:12:56 7152 [Warning] option 'audit-json-file-bufsize': signed value 0 adjusted to 1
2015-07-29 15:12:56 7152 [Warning] option 'plugin-audit-json-file-bufsize': signed value 0 adjusted to 1
2015-07-29 15:12:56 7152 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-07-29 15:12:56 7152 [Note] InnoDB: The InnoDB memory heap is disabled
2015-07-29 15:12:56 7152 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-07-29 15:12:56 7152 [Note] InnoDB: Memory barrier is not used
2015-07-29 15:12:56 7152 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-07-29 15:12:56 7152 [Note] InnoDB: Using Linux native AIO
2015-07-29 15:12:56 7152 [Note] InnoDB: Using CPU crc32 instructions
2015-07-29 15:12:56 7152 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2015-07-29 15:12:56 7152 [Note] InnoDB: Completed initialization of buffer pool
2015-07-29 15:12:56 7152 [Note] InnoDB: Highest supported file format is Barracuda.
2015-07-29 15:12:57 7152 [Note] InnoDB: 128 rollback segment(s) are active.
2015-07-29 15:12:57 7152 [Note] InnoDB: Waiting for purge to start
2015-07-29 15:12:57 7152 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.20-rel68.0 started; log sequence number 781304288197
2015-07-29 15:12:57 7152 [Note] Audit Plugin: starting up. Version: 1.0.9 , Revision: 536 (64bit). AUDIT plugin interface version: 769 (0x301). MySQL Server version: 5.6.20-68.0-log.
2015-07-29 15:12:57 7152 [Note] Audit Plugin: setup_offsets audit_offsets: 8624, 8672, 4376, 5016, 88, 2720, 96, 0, 32, 104 validate_checksum: 1 offsets_by_version: 1
2015-07-29 15:12:57 7152 [Note] Audit Plugin: mysqld: /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld (86559c027aa9a33b7d3694cef7c6f4be)
2015-07-29 15:12:57 7152 [Note] Audit Plugin: setup_offsets Audit_formatter::thd_offsets values: 8624 8672 4376 5016 88 2720 96 0 32 104
2015-07-29 15:12:57 7152 [Note] Audit Plugin: extended offsets validate res: MySQL thread id 123456, OS thread handle 0x0, query id 789 aud_tusr
2015-07-29 15:12:57 7152 [Note] Audit Plugin: Validation passed. Using offsets from audit_offsets: 8624, 8672, 4376, 5016, 88, 2720, 96, 0, 32, 104
2015-07-29 15:12:57 7152 [Note] Audit Plugin: Set password_masking_cmds num: 7, value: CREATE_USER,GRANT,SET_OPTION,SLAVE_START,CREATE_SERVER,ALTER_SERVER,CHANGE_MASTER
2015-07-29 15:12:57 7152 [Note] Audit Plugin: Compile password_masking_regex res: [0]
2015-07-29 15:12:57 7152 [Note] Audit Plugin: Set password_masking_regex value: [identified(?:/\*.*?\*/|\s)*?by(?:/\*.*?\*/|\s)*?(?:password)?(?:/\*.*?\*/|\s)*?['|"](?<psw>.*?)(?<!\\)['|"]|password(?:/\*.*?\*/|\s)*?\((?:/\*.*?\*/|\s)*?['|"](?<psw>.*?)(?<!\\)['|"](?:/\*.*?\*/|\s)*?\)|password(?:/\*.*?\*/|\s)*?(?:for(?:/\*.*?\*/|\s)*?\S+?)?(?:/\*.*?\*/|\s)*?=(?:/\*.*?\*/|\s)*?['|"](?<psw>.*?)(?<!\\)['|"]|password(?:/\*.*?\*/|\s)*?['|"](?<psw>.*?)(?<!\\)['|"]]
2015-07-29 15:12:57 7152 [Note] Audit Plugin: Set json_socket_name str: [] value: [/tmp/mysql.audit__db_mysql_main_fi_s_b_13208]
2015-07-29 15:12:57 7152 [Note] Audit Plugin: bufsize for file [/db-log/mysql_main_fi_s_b/auditlog/audit.log]: 4096. Value of json_file_bufsize: 262144.
2015-07-29 15:12:57 7152 [Note] Audit Plugin: success opening file: /db-log/mysql_main_fi_s_b/auditlog/audit.log.
2015-07-29 15:12:57 7152 [Note] Audit Plugin: mem func addr: 0x7fe468024770 mem start addr: 0x7fe468025000 page size: 4096
2015-07-29 15:12:57 7152 [Note] Audit Plugin: hot patching function: 0x6f84c0, trampolineFunction: 0x7fe468025000 trampolinePage: 0x7fe468025000
2015-07-29 15:12:57 7152 [Note] Audit Plugin: hot patch for: mysql_execute_command (0x6f84c0) complete. Audit func: 0x7fe468024100, Trampoline address: 0x7fe468025000 size: 16.
2015-07-29 15:12:57 7152 [Note] Audit Plugin: hot patching function: 0x6bc880, trampolineFunction: 0x7fe468025020 trampolinePage: 0x7fe468025000
2015-07-29 15:12:57 7152 [Note] Audit Plugin: hot patch for: send_result_to_client (0x6bc880) complete. Audit func: 0x7fe468023d80, Trampoline address: 0x7fe468025020 size: 15.
2015-07-29 15:12:57 7152 [Note] Audit Plugin: hot patching function: 0x6f4820, trampolineFunction: 0x7fe468025040 trampolinePage: 0x7fe468025000
2015-07-29 15:12:57 7152 [Note] Audit Plugin: hot patch for: check_table_access (0x6f4820) complete. Audit func: 0x7fe468023c30, Trampoline address: 0x7fe468025040 size: 15.
2015-07-29 15:12:57 7152 [Note] Audit Plugin: hot patching function: 0x6b5580, trampolineFunction: 0x7fe468025060 trampolinePage: 0x7fe468025000
2015-07-29 15:12:57 7152 [Note] Audit Plugin: hot patch for: open_tables (0x6b5580) complete. Audit func: 0x7fe468023e50, Trampoline address: 0x7fe468025060 size: 18.
2015-07-29 15:12:57 7152 [Note] Audit Plugin: Done initializing sql command names. status_vars_index: [152], com_status_vars: [0x1215060].
2015-07-29 15:12:57 7152 [Note] Audit Plugin: Init completed successfully.
2015-07-29 15:12:57 7152 [Note] RSA private key file not found: /db/mysql_main_fi_s_b//private_key.pem. Some authentication plugins will not work.
2015-07-29 15:12:57 7152 [Note] RSA public key file not found: /db/mysql_main_fi_s_b//public_key.pem. Some authentication plugins will not work.
2015-07-29 15:12:57 7152 [Note] Server hostname (bind-address): '*'; port: 13208
2015-07-29 15:12:57 7152 [Note] IPv6 is available.
2015-07-29 15:12:57 7152 [Note] - '::' resolves to '::';
2015-07-29 15:12:57 7152 [Note] Server socket created on IP: '::'.
2015-07-29 15:12:57 7152 [Note] Event Scheduler: Loaded 0 events
2015-07-29 15:12:57 7152 [Note] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld: ready for connections.
Version: '5.6.20-68.0-log' socket: '/tmp/mysql_main_fi_s_b.sock' port: 13208 Percona Server (GPL), Release 68.0, Revision 656
2015-07-29 15:22:05 7152 [Warning] IP address '172.17.2.61' could not be resolved: Name or service not known
2015-07-29 15:30:58 7152 [Note] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld: Normal shutdown
2015-07-29 15:30:58 7152 [Note] Giving 0 client threads a chance to die gracefully
2015-07-29 15:30:58 7152 [Note] Event Scheduler: Purging the queue. 0 events
2015-07-29 15:30:58 7152 [Note] Shutting down slave threads
2015-07-29 15:30:58 7152 [Note] Forcefully disconnecting 0 remaining clients
2015-07-29 15:30:58 7152 [Note] Binlog end
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'AUDIT'
2015-07-29 15:30:58 7152 [Note] Audit Plugin: deinit
2015-07-29 15:30:58 7152 [Note] Audit Plugin: removing hot patching function: 0x6b5580 targetPage: 0x6b5000 trampolineFunction: 0x7fe468025060
2015-07-29 15:30:58 7152 [Note] Audit Plugin: removing hot patching function: 0x6bc880 targetPage: 0x6bc000 trampolineFunction: 0x7fe468025020
2015-07-29 15:30:58 7152 [Note] Audit Plugin: removing hot patching function: 0x6f4820 targetPage: 0x6f4000 trampolineFunction: 0x7fe468025040
2015-07-29 15:30:58 7152 [Note] Audit Plugin: removing hot patching function: 0x6f84c0 targetPage: 0x6f8000 trampolineFunction: 0x7fe468025000
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'partition'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'ARCHIVE'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'FEDERATED'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'BLACKHOLE'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_METRICS'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_CMP'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'INNODB_TRX'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'XTRADB_RSEG'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
2015-07-29 15:30:58 7152 [Note] Shutting down plugin 'InnoDB'
2015-07-29 15:30:58 7152 [Note] InnoDB: FTS optimize thread exiting.
2015-07-29 15:30:58 7152 [Note] InnoDB: Starting shutdown...
2015-07-29 15:31:00 7152 [Note] InnoDB: Shutdown completed; log sequence number 781304293029
2015-07-29 15:31:00 7152 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-07-29 15:31:00 7152 [Note] Shutting down plugin 'CSV'
2015-07-29 15:31:00 7152 [Note] Shutting down plugin 'MRG_MYISAM'
2015-07-29 15:31:00 7152 [Note] Shutting down plugin 'MyISAM'
2015-07-29 15:31:00 7152 [Note] Shutting down plugin 'MEMORY'
2015-07-29 15:31:00 7152 [Note] Shutting down plugin 'sha256_password'
2015-07-29 15:31:00 7152 [Note] Shutting down plugin 'mysql_old_password'
2015-07-29 15:31:00 7152 [Note] Shutting down plugin 'mysql_native_password'
2015-07-29 15:31:00 7152 [Note] Shutting down plugin 'binlog'
2015-07-29 15:31:00 7152 [Note] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld: Shutdown complete
150729 15:31:00 mysqld_safe mysqld from pid file /db/mysql_main_fi_s_b//db2.pid endedCan you send me the part from the error log where it prints out the backtrace. I want to check the addresses which are printed out there.
glicht
commented
9 years ago One more request. Can you print out the following when you hit the crash in gdb:
frame 1
p *(yajl_buf)gen->ctxHopefully everything should be included here:
Starting program: /usr/local/mysql/bin/mysqld --defaults-file=/db/mysql_main_fi_s_b/mysql_main_fi_s_b.cnf --user=mysql
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
2015-07-29 17:33:07 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[New Thread 0x7fffc4bfd700 (LWP 7744)]
2015-07-29 17:33:07 7571 [Warning] option 'audit-json-file-bufsize': signed value 0 adjusted to 1
2015-07-29 17:33:07 7571 [Warning] option 'plugin-audit-json-file-bufsize': signed value 0 adjusted to 1
2015-07-29 17:33:07 7571 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-07-29 17:33:07 7571 [Note] InnoDB: The InnoDB memory heap is disabled
2015-07-29 17:33:07 7571 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-07-29 17:33:07 7571 [Note] InnoDB: Memory barrier is not used
2015-07-29 17:33:07 7571 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-07-29 17:33:07 7571 [Note] InnoDB: Using Linux native AIO
2015-07-29 17:33:07 7571 [Note] InnoDB: Using CPU crc32 instructions
2015-07-29 17:33:07 7571 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2015-07-29 17:33:07 7571 [Note] InnoDB: Completed initialization of buffer pool
[New Thread 0x7fff15ff0700 (LWP 7745)]
[New Thread 0x7fff157ef700 (LWP 7746)]
[New Thread 0x7fff14fee700 (LWP 7747)]
[New Thread 0x7fff147ed700 (LWP 7748)]
[New Thread 0x7fff13fec700 (LWP 7749)]
[New Thread 0x7fff137eb700 (LWP 7750)]
[New Thread 0x7fff12fea700 (LWP 7751)]
[New Thread 0x7fff127e9700 (LWP 7752)]
[New Thread 0x7fff11fe8700 (LWP 7753)]
[New Thread 0x7fff117e7700 (LWP 7754)]
[New Thread 0x7fff10fe6700 (LWP 7755)]
[New Thread 0x7fff107e5700 (LWP 7756)]
[New Thread 0x7fff0ffe4700 (LWP 7757)]
[New Thread 0x7fff0f7e3700 (LWP 7758)]
[New Thread 0x7fff0efe2700 (LWP 7759)]
[New Thread 0x7fff0e7e1700 (LWP 7760)]
[New Thread 0x7fff0dfe0700 (LWP 7761)]
[New Thread 0x7fff0d7df700 (LWP 7763)]
[New Thread 0x7fff0cfde700 (LWP 7764)]
[New Thread 0x7fff0c7dd700 (LWP 7765)]
[New Thread 0x7fff0bfdc700 (LWP 7766)]
[New Thread 0x7fff0b7db700 (LWP 7767)]
2015-07-29 17:33:08 7571 [Note] InnoDB: Highest supported file format is Barracuda.
2015-07-29 17:33:08 7571 [Note] InnoDB: The log sequence numbers 781399879828 and 781399879828 in ibdata files do not match the log sequence number 781399884749 in the ib_logfiles!
2015-07-29 17:33:08 7571 [Note] InnoDB: Database was not shutdown normally!
2015-07-29 17:33:08 7571 [Note] InnoDB: Starting crash recovery.
2015-07-29 17:33:08 7571 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-07-29 17:33:08 7571 [Note] InnoDB: Restoring possible half-written data pages
2015-07-29 17:33:08 7571 [Note] InnoDB: from the doublewrite buffer...
[New Thread 0x7fff087bc700 (LWP 7768)]
InnoDB: Last MySQL binlog file position 0 367868047, file name mysql-bin.000012
[Thread 0x7fff087bc700 (LWP 7768) exited]
[New Thread 0x7fff087bc700 (LWP 7927)]
2015-07-29 17:33:08 7571 [Note] InnoDB: 128 rollback segment(s) are active.
[Thread 0x7fff087bc700 (LWP 7927) exited]
[New Thread 0x7fff0afda700 (LWP 7928)]
[New Thread 0x7fff087bc700 (LWP 7929)]
[New Thread 0x7fff0a7d9700 (LWP 7930)]
[New Thread 0x7fff09fd8700 (LWP 7931)]
[New Thread 0x7fff097d7700 (LWP 7932)]
2015-07-29 17:33:08 7571 [Note] InnoDB: Waiting for purge to start
[New Thread 0x7fff07749700 (LWP 7933)]
[New Thread 0x7fff06f48700 (LWP 7934)]
2015-07-29 17:33:08 7571 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.20-rel68.0 started; log sequence number 781399884749
[New Thread 0x7fff06747700 (LWP 7935)]
[New Thread 0x7fff05f46700 (LWP 7936)]
[New Thread 0x7fff05745700 (LWP 7937)]
2015-07-29 17:33:08 7571 [Note] Audit Plugin: starting up. Version: 1.0.9 , Revision: 536 (64bit). AUDIT plugin interface version: 769 (0x301). MySQL Server version: 5.6.20-68.0-log.
2015-07-29 17:33:08 7571 [Note] Audit Plugin: setup_offsets audit_offsets: 8624, 8672, 4376, 5016, 88, 2720, 96, 0, 32, 104 validate_checksum: 1 offsets_by_version: 1
2015-07-29 17:33:08 7571 [Note] Audit Plugin: mysqld: /usr/local/mysql/bin/mysqld (86559c027aa9a33b7d3694cef7c6f4be)
2015-07-29 17:33:08 7571 [Note] Audit Plugin: setup_offsets Audit_formatter::thd_offsets values: 8624 8672 4376 5016 88 2720 96 0 32 104
2015-07-29 17:33:08 7571 [Note] Audit Plugin: extended offsets validate res: MySQL thread id 123456, OS thread handle 0x0, query id 789 aud_tusr
2015-07-29 17:33:08 7571 [Note] Audit Plugin: Validation passed. Using offsets from audit_offsets: 8624, 8672, 4376, 5016, 88, 2720, 96, 0, 32, 104
2015-07-29 17:33:08 7571 [Note] Audit Plugin: Set password_masking_cmds num: 7, value: CREATE_USER,GRANT,SET_OPTION,SLAVE_START,CREATE_SERVER,ALTER_SERVER,CHANGE_MASTER
2015-07-29 17:33:08 7571 [Note] Audit Plugin: Compile password_masking_regex res: [0]
2015-07-29 17:33:08 7571 [Note] Audit Plugin: Set password_masking_regex value: [identified(?:/\*.*?\*/|\s)*?by(?:/\*.*?\*/|\s)*?(?:password)?(?:/\*.*?\*/|\s)*?['|"](?<psw>.*?)(?<!\\)['|"]|password(?:/\*.*?\*/|\s)*?\((?:/\*.*?\*/|\s)*?['|"](?<psw>.*?)(?<!\\)['|"](?:/\*.*?\*/|\s)*?\)|password(?:/\*.*?\*/|\s)*?(?:for(?:/\*.*?\*/|\s)*?\S+?)?(?:/\*.*?\*/|\s)*?=(?:/\*.*?\*/|\s)*?['|"](?<psw>.*?)(?<!\\)['|"]|password(?:/\*.*?\*/|\s)*?['|"](?<psw>.*?)(?<!\\)['|"]]
2015-07-29 17:33:08 7571 [Note] Audit Plugin: Set json_socket_name str: [] value: [/tmp/mysql.audit__db_mysql_main_fi_s_b_13208]
2015-07-29 17:33:08 7571 [Note] Audit Plugin: bufsize for file [/db-log/mysql_main_fi_s_b/auditlog/audit.log]: 4096. Value of json_file_bufsize: 262144.
2015-07-29 17:33:08 7571 [Note] Audit Plugin: success opening file: /db-log/mysql_main_fi_s_b/auditlog/audit.log.
2015-07-29 17:33:08 7571 [Note] Audit Plugin: mem func addr: 0x7fffc427e770 mem start addr: 0x7fffc427f000 page size: 4096
2015-07-29 17:33:08 7571 [Note] Audit Plugin: hot patching function: 0x6f84c0, trampolineFunction: 0x7fffc427f000 trampolinePage: 0x7fffc427f000
2015-07-29 17:33:08 7571 [Note] Audit Plugin: hot patch for: mysql_execute_command (0x6f84c0) complete. Audit func: 0x7fffc427e100, Trampoline address: 0x7fffc427f000 size: 16.
2015-07-29 17:33:08 7571 [Note] Audit Plugin: hot patching function: 0x6bc880, trampolineFunction: 0x7fffc427f020 trampolinePage: 0x7fffc427f000
2015-07-29 17:33:08 7571 [Note] Audit Plugin: hot patch for: send_result_to_client (0x6bc880) complete. Audit func: 0x7fffc427dd80, Trampoline address: 0x7fffc427f020 size: 15.
2015-07-29 17:33:08 7571 [Note] Audit Plugin: hot patching function: 0x6f4820, trampolineFunction: 0x7fffc427f040 trampolinePage: 0x7fffc427f000
2015-07-29 17:33:08 7571 [Note] Audit Plugin: hot patch for: check_table_access (0x6f4820) complete. Audit func: 0x7fffc427dc30, Trampoline address: 0x7fffc427f040 size: 15.
2015-07-29 17:33:08 7571 [Note] Audit Plugin: hot patching function: 0x6b5580, trampolineFunction: 0x7fffc427f060 trampolinePage: 0x7fffc427f000
2015-07-29 17:33:08 7571 [Note] Audit Plugin: hot patch for: open_tables (0x6b5580) complete. Audit func: 0x7fffc427de50, Trampoline address: 0x7fffc427f060 size: 18.
2015-07-29 17:33:08 7571 [Note] Audit Plugin: Done initializing sql command names. status_vars_index: [152], com_status_vars: [0x1215060].
2015-07-29 17:33:08 7571 [Note] Audit Plugin: Init completed successfully.
2015-07-29 17:33:08 7571 [Note] RSA private key file not found: /db/mysql_main_fi_s_b//private_key.pem. Some authentication plugins will not work.
2015-07-29 17:33:08 7571 [Note] RSA public key file not found: /db/mysql_main_fi_s_b//public_key.pem. Some authentication plugins will not work.
2015-07-29 17:33:08 7571 [Note] Server hostname (bind-address): '*'; port: 13208
2015-07-29 17:33:08 7571 [Note] IPv6 is available.
2015-07-29 17:33:08 7571 [Note] - '::' resolves to '::';
2015-07-29 17:33:08 7571 [Note] Server socket created on IP: '::'.
[New Thread 0x7fff08fd6700 (LWP 7938)]
2015-07-29 17:33:08 7571 [Note] Event Scheduler: Loaded 0 events
2015-07-29 17:33:08 7571 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.20-68.0-log' socket: '/tmp/mysql_main_fi_s_b.sock' port: 13208 Percona Server (GPL), Release 68.0, Revision 656[New Thread 0x7fff08f95700 (LWP 12912)]
2015-07-29 17:33:40 7571 [Warning] IP address '172.17.2.61' could not be resolved: Name or service not known
[New Thread 0x7fff08b44700 (LWP 13184)]
[New Thread 0x7fff08b03700 (LWP 13241)]
[New Thread 0x7fff08ac2700 (LWP 13242)]
[New Thread 0x7fff08a81700 (LWP 13245)]
[New Thread 0x7fff08a40700 (LWP 13246)]
[New Thread 0x7fff04f44700 (LWP 13248)]
[New Thread 0x7fff04f03700 (LWP 13250)]
[New Thread 0x7fff04ec2700 (LWP 13251)]
[New Thread 0x7fff04e81700 (LWP 13253)]
[New Thread 0x7fff04e40700 (LWP 13255)]
[New Thread 0x7fff04dff700 (LWP 13257)]
[New Thread 0x7fff04dbe700 (LWP 13259)]
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fff08a81700 (LWP 13245)]
0x00007ffff634e7d1 in __strlen_sse2_pminub () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install glibc-2.17-55.el7_0.5.x86_64 keyutils-libs-1.5.8-3.el7.x86_64 krb5-libs-1.11.3-49.el7.x86_64 libaio-0.3.109-12.el7.x86_64 libcom_err-1.42.9-4.el7.x86_64 libgcc-4.8.2-16.2.el7_0.x86_64 libselinux-2.2.2-6.el7.x86_64 libstdc++-4.8.2-16.2.el7_0.x86_64 nss-softokn-freebl-3.16.2.3-1.el7_0.x86_64 openssl098e-0.9.8e-29.el7.centos.2.x86_64 pcre-8.32-12.el7.x86_64 systemd-libs-208-11.el7_0.6.x86_64 xz-libs-5.1.2-8alpha.el7.x86_64 zlib-1.2.7-13.el7.x86_64
(gdb) backtrace full
#0 0x00007ffff634e7d1 in __strlen_sse2_pminub () from /lib64/libc.so.6
No symbol table info available.
#1 0x00007fffc4283981 in Audit_json_formatter::event_format (this=0x7fffc43e2b20 <json_formatter>, pThdData=0x7fff08a7fe60, writer=0x7fffc43e2ad0 <json_file_handler+144>) at audit_handler.cc:409
gen = 0x7ffee4007370
cmd = 0xbc1a85 "Init DB"
res = <optimized out>
qid = <optimized out>
stat = <optimized out>
thd = 0x50daba0
thdid = <optimized out>
#2 0x00007fffc4282b35 in Audit_file_handler::handler_log_audit (this=0x7fffc43e2a40 <json_file_handler>, pThdData=0x7fffc42bd048) at audit_handler.cc:317
res = <optimized out>
#3 0x00007fffc42826b7 in Audit_handler::log_audit (this=0x7fffc43e2a40 <json_file_handler>, pThdData=0x7fff08a7fe60) at audit_handler.cc:167
inst_thread_id = <optimized out>
plug_thread_id = <optimized out>
#4 0x00007fffc428272e in Audit_handler::log_audit_all (pThdData=0x7fff08a7fe60) at audit_handler.cc:81
i = 1
#5 0x00007fffc427d95a in audit (pThdData=0x7fff08a7fe60) at audit_plugin.cc:287
pThdPrintedList = 0x0
do_objs_cmds_check = true
#6 0x00007fffc427def8 in audit_notify (thd=<optimized out>, event_class=<optimized out>, event=<optimized out>) at audit_plugin.cc:460
ThdData = {m_pThd = 0x50daba0, m_CmdName = 0xbc1a85 "Init DB", m_UserName = 0x7ffee4004a40 "root", m_isSqlCmd = true, m_objIterType = ThdSesData::OBJ_DB, m_tables = 0x0, m_firstTable = false, m_tableInf = 0x0, m_index = 0}
#7 0x00000000006a8935 in plugins_dispatch (arg=0x7fff08a7feb0, plugin=<optimized out>, thd=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.cc:433
event_generic = 0x7fff08a7feb0
data = <optimized out>
#8 event_class_dispatch (event=0x7fff08a7fec0, event_class=0, thd=0x50daba0) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.cc:469
plugins = 0x7ffee40076d0
plugins_last = 0x7ffee40076d8
event_generic = {event_class = 0, event = 0x7fff08a7fec0}
#9 general_class_handler(THD *, uint, typedef __va_list_tag __va_list_tag *) (thd=0x50daba0, event_subtype=<optimized out>, ap=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.cc:69
event = {event_subclass = 3, general_error_code = 0, general_thread_id = 182, general_user = 0x7fff08a807d0 "root[root] @ localhost []", general_user_length = 25, general_command = 0xbc1a85 "Init DB", general_command_length = 7, general_query = 0x0,
general_query_length = 0, general_charset = 0x124bb20 <my_charset_bin>, general_time = 1438184021, general_rows = 1, general_host = {str = 0xba6ffb "localhost", length = 9}, general_sql_command = {str = 0xbd3143 "error", length = 0}, general_external_user = {
str = 0xc2f293 "", length = 0}, general_ip = {str = 0xc2f293 "", length = 0}}
#10 0x00000000006a8b08 in mysql_audit_notify (thd=thd@entry=0x50daba0, event_class=event_class@entry=0, event_subtype=event_subtype@entry=3) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.cc:194
ap = {{gp_offset = 48, fp_offset = 48, overflow_arg_area = 0x7fff08a80108, reg_save_area = 0x7fff08a7ffb0}}
handlers = 0x1218cd0 <audit_handlers>
#11 0x0000000000700558 in mysql_audit_general (msg=0xbc1a85 "Init DB", error_code=0, event_subtype=3, thd=0x50daba0) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_audit.h:224
time = 1438184021
msglen = 7
user_buff = "root[root] @ localhost []\000(\304\377\177\000\000\000\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\340\314?\304\377\177\000\000\200\n\250\b\377\177\000\000\001\000\000\000\000\000\000\000.'(\304\377\177\000\000\200\n\250\b\377\177\000\000\200\n\250\b\377\177\000\000\001\000\000\000\000\000\000\000Z\331'\304\377\177\000\000\000\000\000\000\000\000\000\000\060\000\000\000\000\000\000\000\000\t\250\b\377\177\000\000\022\300\271", '\000' <repeats 13 times>, "\200\b\250\b\377\177\000\000\200\000\000\000\000\000\000\000\021\367W\367\000\200\377\377\t\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\062", '\000' <repeats 15 times>...
user = 0x7fff08a807d0 "root[root] @ localhost []"
query = {string = {str = 0x0, length = 0}, cs = 0x124bb20 <my_charset_bin>}
rows = 1
userlen = 25
msg = 0xbc1a85 "Init DB"
error_code = 0
event_subtype = 3
thd = 0x50daba0
#12 dispatch_command (command=<optimized out>, thd=0x50daba0, packet=<optimized out>, packet_length=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:1868
net = 0x50dae10
error = false
__FUNCTION__ = "dispatch_command"
#13 0x00000000007028e9 in do_command (thd=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:1049
return_value = <optimized out>
packet = <optimized out>
packet_length = <optimized out>
net = <optimized out>
command = <optimized out>
---Type <return> to continue, or q <return> to quit---
#14 0x00000000006ce8e2 in do_handle_one_connection (thd_arg=thd_arg@entry=0x50d6d90) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_connect.cc:1532
rc = <optimized out>
create_user = true
net = <optimized out>
thd = 0x50daba0
#15 0x00000000006ce9d0 in handle_one_connection (arg=arg@entry=0x50d6d90) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/sql/sql_connect.cc:1443
thd = 0x50d6d90
#16 0x00000000009224a3 in pfs_spawn_thread (arg=0x4fcb600) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.20-68.0/storage/perfschema/pfs.cc:1860
typed_arg = 0x4fcb600
user_arg = 0x50d6d90
pfs = <optimized out>
user_start_routine = 0x6ce990 <handle_one_connection(void*)>
klass = <optimized out>
#17 0x00007ffff7bc7df3 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#18 0x00007ffff62e21ad in clone () from /lib64/libc.so.6
No symbol table info available.$1 = {si_signo = 11, si_errno = 0, si_code = 128, _sifields = {_pad = {0, 0, 0, 0, 48, 0, 0, 0, -1264027456, 32767, 0, 0, 91, 110, 0, 0, 0, 0, 119, 124, -1264027457, 32767, 1507928576, -1084489386, 29111312, 0, 0, 0}, _kill = {si_pid = 0, si_uid = 0}, _timer = {
si_tid = 0, si_overrun = 0, si_sigval = {sival_int = 0, sival_ptr = 0x0}}, _rt = {si_pid = 0, si_uid = 0, si_sigval = {sival_int = 0, sival_ptr = 0x0}}, _sigchld = {si_pid = 0, si_uid = 0, si_status = 0, si_utime = 206158430208, si_stime = 0}, _sigfault = {
si_addr = 0x0}, _sigpoll = {si_band = 0, si_fd = 0}}}
#1 0x00007fffc4283981 in Audit_json_formatter::event_format (this=0x7fffc43e2b20 <json_formatter>, pThdData=0x7fff08a7fe60, writer=0x7fffc43e2ad0 <json_file_handler+144>) at audit_handler.cc:409
409 audit_handler.cc: No such file or directory.
$2 = {<MDL_context_owner> = {_vptr.MDL_context_owner = 0x11edd90 <vtable for THD+16>}, <Statement> = {<Query_arena> = {_vptr.Query_arena = 0x11eddf0 <vtable for THD+112>, free_list = 0x0, mem_root = 0x50de340, state = Query_arena::STMT_CONVENTIONAL_EXECUTION}, id = 0,
query_strip_comments = {buffer = 0x0, length = 0, buffer_length = 0}, mark_used_columns = MARK_COLUMNS_READ, name = {str = 0x0, length = 8030604369041128041}, lex = 0x50dd0b0, query_string = {string = {str = 0x0, length = 0}, cs = 0x124bb20 <my_charset_bin>},
rewritten_query = {Ptr = 0x0, str_length = 0, Alloced_length = 0, alloced = false, str_charset = 0x124bb20 <my_charset_bin>}, db = 0x7ffee4007d90 "test", db_length = 4}, <Open_tables_state> = {m_reprepare_observers = {array = {buffer = 0x50efe10 "HhZ\366\377\177",
elements = 0, max_element = 16, alloc_increment = 16, size_of_element = 8}}, open_tables = 0x0, temporary_tables = 0x0, LOCK_temporary_tables = {m_mutex = {mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 3, __spins = 0,
__list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 16 times>, "\003", '\000' <repeats 22 times>, __align = 0}, spins = 8, rng_state = 1}, m_psi = 0x0}, derived_tables = 0x0, lock = 0x0, extra_lock = 0x0, locked_tables_mode = LTM_NONE,
current_tablenr = 0, state_flags = 0}, mdl_context = {m_wait = {m_LOCK_wait_status = {m_mutex = {mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __list = {__prev = 0x0, __next = 0x0}},
__size = '\000' <repeats 39 times>, __align = 0}, spins = 0, rng_state = 1}, m_psi = 0x0}, m_COND_wait_status = {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}, m_wait_status = MDL_wait::EMPTY}, m_tickets = {{<I_P_List_null_counter> = {<No data fields>}, <I_P_List_no_push_back<MDL_ticket>> = {<No data fields>}, m_first = 0x0},
{<I_P_List_null_counter> = {<No data fields>}, <I_P_List_no_push_back<MDL_ticket>> = {<No data fields>}, m_first = 0x0}, {<I_P_List_null_counter> = {<No data fields>}, <I_P_List_no_push_back<MDL_ticket>> = {<No data fields>}, m_first = 0x0}},
m_owner = 0x50daba0, m_needs_thr_lock_abort = false, m_LOCK_waiting_for = {m_prlock = {lock = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>,
__align = 0}, no_active_readers = {__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}, active_readers = 0,
writers_waiting_readers = 0, active_writer = 0 '\000'}, m_psi = 0x0}, m_waiting_for = 0x0}, rli_fake = 0x0, rli_slave = 0x0, static DEFAULT_WHERE = 0xbbba0b "field list", query_cache_tls = {first_query_block = 0x0}, net = {vio = 0x5091dd0,
buff = 0x50f3d10 "\a", buff_end = 0x50f7d10 "", write_pos = 0x50f3d10 "\a", read_pos = 0x50f3d10 "\a", fd = 48, remain_in_buf = 0, length = 8533314594134910322, buf_length = 7016440515808027231, where_b = 0, max_packet = 16384, max_packet_size = 16777216,
pkt_nr = 2, compress_pkt_nr = 1, write_timeout = 60, read_timeout = 30, retry_count = 10, fcntl = 1936290416, return_status = 0x50dcd8c, reading_or_writing = 0 '\000', save_char = 114 'r', unused1 = 105 'i', unused2 = 115 's', compress = 0 '\000',
unused3 = 97 'a', unused = 0x0, last_errno = 0, error = 0 '\000', unused4 = 101 'e', unused5 = 8 '\b',
last_error = "\000illv_cv\btillv_cv\f?\000\a\000\000\000\366\001\000\002\000\000R\000\000\v\003def\024prisjakt_nyaprisjakt\001t\vtillverkare\016sponsor_banner\016sponsor_banner\f-\000\240\000\000\000\375\001\020\000\000\000\035\000\000\f\003def\000\000\000\asponsor\000\f?\000\001\000\000\000\b\201\000\000\000\000\005\000\000\r\376\000\000\"\000\005\000\000\016\376\000\000\"\000illv_betyg_antal\f?\000\v\000\000\000\003\001\020\000\000\000F\000\000\n"..., sqlstate = "\000\000\000\000\000", extension = 0x50db0b8},
m_net_server_extension = {m_before_header = 0x5a98a0 <net_before_header_psi(st_net*, void*, unsigned long)>, m_after_header = 0x5a9e90 <net_after_header_psi(st_net*, void*, unsigned long, char)>, m_user_data = 0x50daba0},
scheduler = 0x131b540 <thread_scheduler_struct>, protocol = 0x50db0e0, protocol_text = {<Protocol> = {_vptr.Protocol = 0x11ebb30 <vtable for Protocol_text+16>, thd = 0x50daba0, packet = 0x50db1a8, convert = 0x50db1c8, field_pos = 1,
field_count = 1}, <No data fields>}, protocol_binary = {<Protocol> = {_vptr.Protocol = 0x11ebc30 <vtable for Protocol_binary+16>, thd = 0x50daba0, packet = 0x50db1a8, convert = 0x50db1c8, field_pos = 0, field_count = 0}, bit_fields = 0}, user_vars = {
key_offset = 0, key_length = 0, blength = 1, records = 0, flags = 0, array = {buffer = 0x50e7170 "\350iZ\366\377\177", elements = 0, max_element = 16, alloc_increment = 32, size_of_element = 16}, get_key = 0x6bf3c0 <get_var_key(user_var_entry*, size_t*, my_bool)>,
free = 0x6bf760 <free_user_var(user_var_entry*)>, charset = 0x1305d60 <my_charset_utf8_general_ci>, hash_function = 0x8cdea0 <cset_hash_sort_adapter>}, packet = {Ptr = 0x7ffee40009c0 "\373def", str_length = 1, Alloced_length = 16384, alloced = true,
str_charset = 0x124bb20 <my_charset_bin>}, convert_buffer = {Ptr = 0x7ffee4007c00 "SELECT DATABASE()comment limit 1\003", str_length = 17, Alloced_length = 104, alloced = true, str_charset = 0x1305d60 <my_charset_utf8_general_ci>}, rand = {seed1 = 991077320,
seed2 = 1030955596, max_value = 1073741823, max_value_dbl = 1073741823}, slog_rand = {seed1 = 999055618, seed2 = 914273152, max_value = 1073741823, max_value_dbl = 1073741823}, variables = {dynamic_variables_version = 13,
dynamic_variables_ptr = 0x7ffee40077c0 "\001", dynamic_variables_head = 72, dynamic_variables_size = 80, dynamic_variables_allocs = 0x0, max_heap_table_size = 4294967296, tmp_table_size = 4294967296, long_query_time = 1000000, end_markers_in_json = 0 '\000',
optimizer_switch = 65023, optimizer_trace = 0, optimizer_trace_features = 15, optimizer_trace_offset = -1, optimizer_trace_limit = 1, optimizer_trace_max_mem_size = 16384, sql_mode = 64, option_bits = 2147748608, select_limit = 18446744073709551615,
max_join_size = 18446744073709551615, auto_increment_increment = 1, auto_increment_offset = 1, bulk_insert_buff_size = 536870912, eq_range_index_dive_limit = 10, join_buff_size = 4194304, lock_wait_timeout = 31536000, max_allowed_packet = 16777216,
max_error_count = 64, max_length_for_sort_data = 1024, max_sort_length = 1024, max_tmp_tables = 32, max_insert_delayed_threads = 20, min_examined_row_limit = 0, multi_range_count = 256, myisam_repair_threads = 0, myisam_sort_buff_size = 0, myisam_stats_method = 0,
net_buffer_length = 16384, net_interactive_timeout = 28800, net_read_timeout = 30, net_retry_count = 10, net_wait_timeout = 28800, net_write_timeout = 60, optimizer_prune_level = 1, optimizer_search_depth = 62, preload_buff_size = 32768,
profiling_history_size = 15, read_buff_size = 131072, read_rnd_buff_size = 262144, div_precincrement = 4, sortbuff_size = 262144, max_sp_recursion_depth = 0, default_week_format = 3, max_seeks_for_key = 18446744073709551615, range_alloc_block_size = 4096,
query_alloc_block_size = 8192, query_prealloc_size = 8192, trans_alloc_block_size = 8192, trans_prealloc_size = 4096, group_concat_max_len = 8192, binlog_format = 1, binlog_direct_non_trans_update = 0 '\000', binlog_row_image = 2, sql_log_bin = 1 '\001',
completion_type = 0, query_cache_type = 0, tx_isolation = 1, updatable_views_with_limit = 1, max_user_connections = 1000, my_aes_mode = 0, pseudo_thread_id = 182, tx_read_only = 0 '\000', low_priority_updates = 0 '\000', new_mode = 0 '\000',
query_cache_wlock_invalidate = 0 '\000', engine_condition_pushdown = 1 '\001', keep_files_on_create = 0 '\000', online_alter_index = 0 '\000', old_alter_table = 0 '\000', old_passwords = 0, big_tables = 0 '\000', table_plugin = 0x1455860,
temp_table_plugin = 0x14403f0, character_set_filesystem = 0x124bb20 <my_charset_bin>, character_set_client = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, character_set_results = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>,
collation_server = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, collation_database = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, collation_connection = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, lc_messages = 0x131f140 <my_locale_en_US>,
lc_time_names = 0x131f140 <my_locale_en_US>, time_zone = 0x133c508 <tz_SYSTEM>, explicit_defaults_for_timestamp = 0 '\000', sysdate_is_now = 0 '\000', binlog_rows_query_log_events = 0 '\000', log_slow_rate_limit = 1, log_slow_filter = 0, log_slow_verbosity = 0,
innodb_io_reads = 0, innodb_io_read = 0, innodb_io_reads_wait_timer = 0, innodb_lock_que_wait_timer = 0, innodb_innodb_que_wait_timer = 0, innodb_page_access = 0, long_query_time_double = 1, pseudo_slave_mode = 0 '\000', max_statement_time = 0, gtid_next = {
type = AUTOMATIC_GROUP, gtid = {sidno = 0, gno = 0, static MAX_TEXT_LENGTH = 56}, static MAX_TEXT_LENGTH = 56}, gtid_next_list = {gtid_set = 0x0, is_non_null = false}, expand_fast_index_creation = 0 '\000', threadpool_high_prio_tickets = 4294967295,
threadpool_high_prio_mode = 0}, status_var = {created_tmp_disk_tables = 0, created_tmp_tables = 0, ha_commit_count = 0, ha_delete_count = 0, ha_read_first_count = 0, ha_read_last_count = 0, ha_read_key_count = 0, ha_read_next_count = 0, ha_read_prev_count = 0,
ha_read_rnd_count = 0, ha_read_rnd_next_count = 0, ha_multi_range_read_init_count = 0, ha_rollback_count = 0, ha_update_count = 0, ha_write_count = 0, ha_prepare_count = 0, ha_discover_count = 0, ha_savepoint_count = 0, ha_savepoint_rollback_count = 0,
ha_external_lock_count = 0, opened_tables = 0, opened_shares = 0, table_open_cache_hits = 0, table_open_cache_misses = 0, table_open_cache_overflows = 0, select_full_join_count = 0, select_full_range_join_count = 0, select_range_count = 0,
select_range_check_count = 0, select_scan_count = 0, long_query_count = 0, filesort_merge_passes = 0, filesort_range_count = 0, filesort_rows = 0, filesort_scan_count = 0, com_stmt_prepare = 0, com_stmt_reprepare = 0, com_stmt_execute = 0,
com_stmt_send_long_data = 0, com_stmt_fetch = 0, com_stmt_reset = 0, com_stmt_close = 0, bytes_received = 260, bytes_sent = 292, questions = 3, com_other = 0, com_stat = {2, 0 <repeats 37 times>, 1, 0 <repeats 105 times>}, last_query_cost = 0,
last_query_partial_plans = 0, max_statement_time_exceeded = 0, max_statement_time_set = 0, max_statement_time_set_failed = 0}, initial_status_var = 0x0, lock_info = {thread = 140733338621696, thread_id = 182}, LOCK_thd_data = {m_mutex = {mutex = {__data = {
__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 3, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 16 times>, "\003", '\000' <repeats 22 times>, __align = 0}, spins = 8, rng_state = 1}, m_psi = 0x0}, stmt_map = {
st_hash = {key_offset = 0, key_length = 0, blength = 1, records = 0, flags = 0, array = {buffer = 0x50e75b0 "\250iZ\366\377\177", elements = 0, max_element = 16, alloc_increment = 32, size_of_element = 16},
get_key = 0x6bf680 <get_statement_id_as_hash_key(uchar const*, size_t*, my_bool)>, free = 0x6bf6a0 <delete_statement_as_hash_key(void*)>, charset = 0x124bb20 <my_charset_bin>, hash_function = 0x8cdea0 <cset_hash_sort_adapter>}, names_hash = {key_offset = 0,
key_length = 0, blength = 1, records = 0, flags = 0, array = {buffer = 0x50921f0 "\250iZ\366\377\177", elements = 0, max_element = 16, alloc_increment = 32, size_of_element = 16}, get_key = 0x6bf6c0 <get_stmt_name_hash_key(Statement*, size_t*, my_bool)>,
free = 0x0, charset = 0x1305d60 <my_charset_utf8_general_ci>, hash_function = 0x8cdea0 <cset_hash_sort_adapter>}, last_found_statement = 0x0}, thread_stack = 0x7fff08a80d80 "\240\253\r\005", catalog = 0xbbba45 "std", main_security_ctx = {host = {
Ptr = 0xba6ffb "localhost", str_length = 9, Alloced_length = 0, alloced = false, str_charset = 0x1305d60 <my_charset_utf8_general_ci>}, ip = {Ptr = 0xc2f293 "", str_length = 0, Alloced_length = 0, alloced = false,
str_charset = 0x1305d60 <my_charset_utf8_general_ci>}, external_user = {Ptr = 0xc2f293 "", str_length = 0, Alloced_length = 0, alloced = false, str_charset = 0x1305d60 <my_charset_utf8_general_ci>}, user = 0x7ffee4004a40 "root",
priv_user = "root", '\000' <repeats 43 times>, proxy_user = '\000' <repeats 113 times>, priv_host = "localhost", '\000' <repeats 51 times>, host_or_ip = 0xba6ffb "localhost", master_access = 536870911, db_access = 233258047, password_expired = false},
security_ctx = 0x50dbcb8, proc_info = 0xba8219 "init", m_current_stage_key = 36, where = 0xbbba0b "field list", client_capabilities = 4170373, max_client_packet_length = 16777216, handler_tables_hash = {key_offset = 0, key_length = 0, blength = 0, records = 0,
flags = 0, array = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0}, get_key = 0x0, free = 0x0, charset = 0x0, hash_function = 0x0}, ull_hash = {key_offset = 0, key_length = 0, blength = 0, records = 0, flags = 0, array = {
buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0}, get_key = 0x0, free = 0x0, charset = 0x0, hash_function = 0x0}, mysys_var = 0x7ffee40008c0, m_command = COM_INIT_DB, unmasked_server_id = 8, server_id = 8, file_id = 0,
peer_port = 0, start_time = {tv_sec = 1438184021, tv_usec = 217070}, user_time = {tv_sec = 0, tv_usec = 0}, prior_thr_create_utime = 0, thr_create_utime = 1438184021216901, start_utime = 1438184021217070, utime_after_lock = 1438184021217070,
update_lock_default = TL_WRITE, di = 0x0, bytes_sent_old = 281, tmp_tables_used = 0, tmp_tables_disk_used = 0, tmp_tables_size = 0, innodb_was_used = false, innodb_trx_id = 0, innodb_io_reads = 0, innodb_io_read = 0, innodb_io_reads_wait_timer = 0,
innodb_lock_que_wait_timer = 0, innodb_innodb_que_wait_timer = 0, innodb_page_access = 0, query_plan_flags = 0, query_plan_fsort_passes = 0, last_errno = 0, in_sub_stmt = 0, skip_wait_timeout = false, fill_status_recursion_level = 0, ha_data = {{ha_ptr = 0x0,
ha_info = {{m_next = 0x0, m_ht = 0x0, m_flags = 0 '\000'}, {m_next = 0x0, m_ht = 0x0, m_flags = 0 '\000'}}, lock = 0x0} <repeats 15 times>}, order_deterministic = false, binlog_next_event_pos = {file_name = 0x0, pos = 0}, binlog_row_event_extra_data = 0x0,
timer = 0x0, timer_cache = 0x0, m_binlog_filter_state = THD::BINLOG_FILTER_UNKNOWN, current_stmt_binlog_format = BINLOG_FORMAT_STMT, binlog_unsafe_warning_flags = 0, binlog_table_maps = 0, binlog_accessed_db_names = 0x0, m_trans_log_file = 0x0,
m_trans_fixed_log_file = 0x0, m_trans_end_pos = 0, transaction = {savepoints = 0x0, all = {no_2pc = false, rw_ha_count = 0, ha_list = 0x0, m_unsafe_rollback_flags = 0, static MODIFIED_NON_TRANS_TABLE = 1, static CREATED_TEMP_TABLE = 2,
static DROPPED_TEMP_TABLE = 4}, stmt = {no_2pc = false, rw_ha_count = 0, ha_list = 0x0, m_unsafe_rollback_flags = 0, static MODIFIED_NON_TRANS_TABLE = 1, static CREATED_TEMP_TABLE = 2, static DROPPED_TEMP_TABLE = 4}, xid_state = {xid = {formatID = -1,
gtrid_length = 0, bqual_length = 0, data = '\000' <repeats 127 times>}, xa_state = XA_NOTR, in_thd = true, rm_error = 0}, m_pending_rows_event = 0x0, changed_tables = 0x0, mem_root = {free = 0x7ffee4008620, used = 0x0, pre_alloc = 0x7ffee4008620,
min_malloc = 32, block_size = 8160, block_num = 4, first_block_usage = 0, error_handler = 0x6a8330 <sql_alloc_error_handler()>}, flags = {enabled = true, pending = false, xid_written = false, real_commit = false, commit_low = false, run_hooks = false}},
global_read_lock = {m_state = Global_read_lock::GRL_NONE, m_mdl_global_shared_lock = 0x0, m_mdl_blocks_commits_lock = 0x0}, backup_tables_lock = {m_namespace = MDL_key::BACKUP, m_lock = 0x0, m_prot_lock = 0x0}, backup_binlog_lock = {m_namespace = MDL_key::BINLOG,
m_lock = 0x0, m_prot_lock = 0x0}, dup_field = 0x0, signals = {__val = {0 <repeats 16 times>}}, active_vio = 0x5091dd0, change_list = {<base_ilist<Item_change_record>> = {first = 0x50dc650, sentinel = {
_vptr.ilink = 0x11ec390 <vtable for ilink<Item_change_record>+16>, prev = 0x50dc648, next = 0x0}}, <No data fields>}, stmt_arena = 0x50daba8, table_map_for_update = 0, arg_of_last_insert_id_function = false, first_successful_insert_id_in_prev_stmt = 0,
first_successful_insert_id_in_prev_stmt_for_binlog = 0, first_successful_insert_id_in_cur_stmt = 0, stmt_depends_on_first_successful_insert_id_in_prev_stmt = false, auto_inc_intervals_in_cur_stmt_for_binlog = {first_interval = {interval_min = 0, interval_values = 0,
interval_max = 0, next = 0x0}, head = 0x0, tail = 0x0, current = 0x0, elements = 0}, auto_inc_intervals_forced = {first_interval = {interval_min = 0, interval_values = 0, interval_max = 0, next = 0x0}, head = 0x0, tail = 0x0, current = 0x0, elements = 0},
limit_found_rows = 1, m_row_count_func = 0, cuted_fields = 0, m_sent_row_count = 0, m_examined_row_count = 0, m_user_connect = 0x7ffee4007760, db_charset = 0x12d5040 <my_charset_utf8mb4_swedish_uca_ci>, profiling = {profile_id_counter = 1, thd = 0x50daba0,
keeping = false, enabled = false, current = 0x0, last = 0x0, history = {first = 0x0, last = 0x0, elements = 0}}, m_statement_psi = 0x50dc7a0, m_statement_state = {m_discarded = 0 '\000', m_no_index_used = 0 '\000', m_no_good_index_used = 0 '\000', m_flags = 15,
m_class = 0x13ad440, m_thread = 0x7fffd8a21d40, m_timer_start = 1438184021217068641, m_timer = 0xb683f0 <my_timer_nanoseconds>, m_statement = 0x7fffced5bbf0, m_lock_time = 0, m_rows_sent = 0, m_rows_examined = 0, m_created_tmp_disk_tables = 0,
m_created_tmp_tables = 0, m_select_full_join = 0, m_select_full_range_join = 0, m_select_range = 0, m_select_range_check = 0, m_select_scan = 0, m_sort_merge_passes = 0, m_sort_range = 0, m_sort_rows = 0, m_sort_scan = 0, m_digest_state = {m_last_id_index = 0,
m_digest_storage = {m_full = 0 '\000', m_byte_count = 0, m_charset_number = 232, m_token_array = "\330\002j\001(\000)\000\017\000version_comment\v\002}\003", '\000' <repeats 994 times>}}, m_schema_name = '\000' <repeats 191 times>, m_schema_name_length = 0},
m_idle_psi = 0x50dcd20, m_idle_state = {m_flags = 3, m_thread = 0x7fffd8a21d40, m_timer_start = 1438184021217062, m_timer = 0xb68420 <my_timer_microseconds>, m_wait = 0x0}, m_server_idle = false, query_id = 1161, col_access = 0, statement_id_counter = 0,
rand_saved_seed1 = 0, rand_saved_seed2 = 0, real_id = 140733338621696, thread_id = 182, tmp_table = 0, server_status = 2, open_options = 0, system_thread = NON_SYSTEM_THREAD, select_number = 1, tx_isolation = ISO_READ_COMMITTED, tx_read_only = false,
count_cuted_fields = CHECK_FIELD_IGNORE, updated_row_count = 0, sent_row_count_2 = 2, user_var_events = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0}, user_var_events_alloc = 0x0, next_to_commit = 0x0,
commit_error = THD::CE_NONE, durability_property = HA_REGULAR_DURABILITY, killed = THD::NOT_KILLED, scramble = "]H2^eb;=aPNv)d@PS2<w", slave_thread = false, one_shot_set = false, extra_port = false, no_errors = false, password = 1 '\001', is_fatal_error = false,
transaction_rollback_request = false, is_fatal_sub_stmt_error = false, query_start_used = false, query_start_usec_used = false, rand_used = false, time_zone_used = false, substitute_null_with_insert_id = false, in_lock_tables = false, is_slave_error = false,
bootstrap = false, thread_specific_used = false, charset_is_system_charset = false, charset_is_collation_connection = true, charset_is_character_set_filesystem = true, enable_slow_log = true, abort_on_warning = false, got_warning = false,
derived_tables_processing = false, tablespace_op = 0 '\000', sp_runtime_ctx = 0x0, sp_proc_cache = 0x0, sp_func_cache = 0x0, query_name_consts = 0, current_linfo = 0x0, slave_net = 0x0, current_connect_time = 1438184021, last_global_update_time = 1438184021,
busy_time = 0, diff_total_busy_time = 0, cpu_time = 0, diff_total_cpu_time = 0, bytes_received = 9, diff_total_bytes_received = 0, bytes_sent = 11, diff_total_bytes_sent = 0, binlog_bytes_written = 0, diff_total_binlog_bytes_written = 0, diff_total_sent_rows = 0,
diff_total_updated_rows = 0, diff_total_read_rows = 0, diff_select_commands = 0, diff_update_commands = 0, diff_other_commands = 0, diff_commit_trans = 0, diff_rollback_trans = 0, diff_denied_connections = 0, diff_lost_connections = 0, diff_access_denied_errors = 0,
diff_empty_queries = 0, query_delay_millis = 0, sys_var_tmp = {my_bool_value = 0 '\000', long_value = 0, ulong_value = 0, ulonglong_value = 0, double_value = 0}, binlog_evt_union = {do_union = false, unioned_events = false, unioned_events_trans = false,
first_query_id = 0}, m_parser_state = 0x0, locked_tables_list = {m_locked_tables_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 8160, block_num = 4, first_block_usage = 0, error_handler = 0x6a8330 <sql_alloc_error_handler()>},
m_locked_tables = 0x0, m_locked_tables_last = 0x50dcf80, m_reopen_array = 0x0, m_locked_tables_count = 0}, work_part_info = 0x0, audit_class_plugins = {buffer = 0x7ffee40076d0 "8\257E\001", elements = 1, max_element = 16, alloc_increment = 16,
size_of_element = 8}, audit_class_mask = {1}, m_enable_plugins = true, m_release_resources_done = false, cleanup_done = false, owned_gtid = {sidno = 0, gno = 0, static MAX_TEXT_LENGTH = 56}, owned_gtid_set = {static default_string_format = {begin = 0xc2f293 "",
end = 0xc2f293 "", sid_gno_separator = 0xba6f63 ":", gno_start_end_separator = 0xbbba09 "-", gno_gno_separator = 0xba6f63 ":", gno_sid_separator = 0xbc3b09 ",\n", empty_set_string = 0xc2f293 "", begin_length = 0, end_length = 0, sid_gno_separator_length = 1,
gno_start_end_separator_length = 1, gno_gno_separator_length = 1, gno_sid_separator_length = 2, empty_set_string_length = 0}, static sql_string_format = {begin = 0xc20990 "'", end = 0xc20990 "'", sid_gno_separator = 0xba6f63 ":",
gno_start_end_separator = 0xbbba09 "-", gno_gno_separator = 0xba6f63 ":", gno_sid_separator = 0xc2098d "',\n'", empty_set_string = 0xbc3a56 "''", begin_length = 1, end_length = 1, sid_gno_separator_length = 1, gno_start_end_separator_length = 1,
gno_gno_separator_length = 1, gno_sid_separator_length = 4, empty_set_string_length = 2}, static commented_string_format = {begin = 0xc20980 "# ", end = 0xc2f293 "", sid_gno_separator = 0xba6f63 ":", gno_start_end_separator = 0xbbba09 "-",
gno_gno_separator = 0xba6f63 ":", gno_sid_separator = 0xc2097e ",\n# ", empty_set_string = 0xc20983 "# [empty]", begin_length = 2, end_length = 0, sid_gno_separator_length = 1, gno_start_end_separator_length = 1, gno_gno_separator_length = 1,
gno_sid_separator_length = 4, empty_set_string_length = 9}, static CHUNK_GROW_SIZE = 8, sid_lock = 0x0, free_intervals_mutex = {m_mutex = {mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __list = {__prev = 0x0,
__next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, spins = 0, rng_state = 0}, m_psi = 0x0}, sid_map = 0x143f170, intervals = {buffer = 0x50a4950 "\370gZ\366\377\177", elements = 0, max_element = 8, alloc_increment = 8,
size_of_element = 8}, free_intervals = 0x0, chunks = 0x0, cached_string_length = -1, cached_string_format = 0x0}, skip_gtid_rollback = false, event_scheduler = {m_psi = 0x0, data = 0x0}, opt_trace = {static flag_names = 0x1233b40 <Opt_trace_context::flag_names>,
static feature_names = <same as static member of an already seen type>, static default_features = (Opt_trace_context::GREEDY_SEARCH | Opt_trace_context::RANGE_OPTIMIZER | Opt_trace_context::DYNAMIC_RANGE | Opt_trace_context::REPEATED_SUBSELECT), pimpl = 0x0,
I_S_disabled = 0}, m_internal_handler = 0x0, main_lex = {<Query_tables_list> = {sql_command = SQLCOM_END, query_tables = 0x0, query_tables_last = 0x50dd0c0, query_tables_own_last = 0x0, sroutines = {key_offset = 0, key_length = 0, blength = 0, records = 0,
flags = 0, array = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0}, get_key = 0x0, free = 0x0, charset = 0x0, hash_function = 0x0}, sroutines_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0,
next = 0x50dd150}, sroutines_list_own_last = 0x50dd150, sroutines_list_own_elements = 0, lock_tables_state = Query_tables_list::LTS_NOT_LOCKED, table_count = 0, static BINLOG_STMT_UNSAFE_ALL_FLAGS = 1048575, static binlog_stmt_unsafe_errcode = {1668, 1669,
1670, 1671, 1672, 1673, 1674, 1675, 1692, 1693, 1714, 1715, 1722, 1716, 1717, 1718, 1723, 1719, 1724, 1727}, binlog_stmt_flags = 0, stmt_accessed_table_flag = 0}, _vptr.LEX = 0x119a630 <vtable for LEX+16>, unit = {<st_select_lex_node> = {
_vptr.st_select_lex_node = 0x11eec30 <vtable for st_select_lex_unit+16>, next = 0x0, prev = 0x0, master = 0x0, slave = 0x50dd7c8, link_next = 0x0, link_prev = 0x0, options = 0, sql_cache = st_select_lex_node::SQL_CACHE_UNSPECIFIED, uncacheable = 0 '\000',
linkage = GLOBAL_OPTIONS_TYPE, no_table_names_allowed = false, no_error = false}, result_table_list = {next_local = 0x0, next_global = 0x0, prev_global = 0x0, db = 0x0, alias = 0x0, table_name = 0x0, schema_table_name = 0x0, option = 0x0,
context_of_embedding = 0x0, m_join_cond = 0x0, prep_join_cond = 0x0, sj_on_expr = 0x0, sj_inner_tables = 0, cond_equal = 0x0, natural_join = 0x0, is_natural_join = false, join_using_fields = 0x0, join_columns = 0x0, is_join_columns_complete = false,
next_name_resolution_table = 0x0, index_hints = 0x0, table = 0x0, table_id = {static TABLE_ID_MAX = 281474976710655, m_id = 0}, derived_result = 0x0, correspondent_table = 0x0, derived = 0x0, derived_keys_ready = false, schema_table = 0x0,
schema_select_lex = 0x0, schema_table_reformed = false, schema_table_param = 0x0, select_lex = 0x0, view = 0x0, field_translation = 0x0, field_translation_end = 0x0, merge_underlying_list = 0x0, view_tables = 0x0, belong_to_view = 0x0, referencing_view = 0x0,
parent_l = 0x0, security_ctx = 0x0, view_sctx = 0x0, allowed_show = false, next_leaf = 0x0, where = 0x0, check_option = 0x0, select_stmt = {str = 0x0, length = 0}, md5 = {str = 0x0, length = 0}, source = {str = 0x0, length = 0}, view_db = {str = 0x0,
length = 0}, view_name = {str = 0x0, length = 0}, timestamp = {str = 0x0, length = 0}, definer = {user = {str = 0x0, length = 0}, host = {str = 0x0, length = 0}, password = {str = 0x0, length = 0}, plugin = {str = 0x0, length = 0}, auth = {str = 0x0,
length = 0}, uses_identified_by_clause = false, uses_identified_with_clause = false, uses_authentication_string_clause = false, uses_identified_by_password_clause = false}, file_version = 0, updatable_view = 0, algorithm = 0, view_suid = 0, with_check = 0,
effective_with_check = 0 '\000', effective_algorithm = VIEW_ALGORITHM_UNDEFINED, grant = {grant_table = 0x0, version = 0, privilege = 0, want_privilege = 0, orig_want_privilege = 0, m_internal = {m_schema_lookup_done = false, m_schema_access = 0x0,
m_table_lookup_done = false, m_table_access = 0x0}}, engine_data = 0, callback_func = 0x0, lock_type = TL_UNLOCK, outer_join = 0, shared = 0, db_length = 0, table_name_length = 0, updatable = false, straight = false, updating = false, force_index = false,
ignore_leaves = false, dep_tables = 0, on_expr_dep_tables = 0, nested_join = 0x0, embedding = 0x0, join_list = 0x0, cacheable_table = false, table_in_first_from_clause = false, open_type = OT_TEMPORARY_OR_BASE, contain_auto_increment = false,
multitable_view = false, compact_view_format = false, where_processed = false, check_option_processed = false, required_type = FRMTYPE_ERROR, timestamp_buffer = '\000' <repeats 19 times>, prelocking_placeholder = false, open_strategy = TABLE_LIST::OPEN_NORMAL,
internal_tmp_table = false, is_alias = false, is_fqtn = false, view_creation_ctx = 0x0, view_client_cs_name = {str = 0x0, length = 0}, view_connection_cl_name = {str = 0x0, length = 0}, view_body_utf8 = {str = 0x0, length = 0},
derived_key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50dd540, elements = 0}, <No data fields>}, trg_event_map = 0 '\000', optimized_away = false, i_s_requested_object = 0, has_db_lookup_value = false,
has_table_lookup_value = false, table_open_method = 0, schema_table_state = NOT_PROCESSED, mdl_request = {type = MDL_INTENTION_EXCLUSIVE, duration = MDL_STATEMENT, next_in_list = 0x0, prev_in_list = 0x0, ticket = 0x0, key = {m_length = 0, m_db_name_length = 0,
m_ptr = '\000' <repeats 386 times>, static m_namespace_to_wait_state_name = {{m_key = 102, m_name = 0xbb7aab "Waiting for global read lock", m_flags = 0}, {m_key = 103, m_name = 0xbb7ac8 "Waiting for backup lock", m_flags = 0}, {m_key = 104,
m_name = 0xbb7c68 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 105, m_name = 0xbb7c90 "Waiting for table metadata lock", m_flags = 0}, {m_key = 106, m_name = 0xbb7cb0 "Waiting for stored function metadata lock", m_flags = 0}, {
m_key = 107, m_name = 0xbb7ce0 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 108, m_name = 0xbb7d10 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 109, m_name = 0xbb7d38 "Waiting for event metadata lock",
m_flags = 0}, {m_key = 110, m_name = 0xbb7ae0 "Waiting for commit lock", m_flags = 0}, {m_key = 79, m_name = 0xba72d8 "User lock", m_flags = 0}, {m_key = 111, m_name = 0xbb7af8 "Waiting for binlog lock", m_flags = 0}}}}, partition_names = 0x0,
m_table_ref_type = TABLE_REF_NULL, m_table_ref_version = 0}, union_result = 0x0, table = 0x0, result = 0x0, found_rows_for_union = 0, saved_error = false, prepared = false, optimized = false, executed = false, cleaned = true,
item_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50dd758, elements = 0}, <No data fields>}, types = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50dd770,
elements = 0}, <No data fields>}, global_parameters = 0x50dd7c8, select_limit_cnt = 18446744073709551615, offset_limit_cnt = 0, item = 0x0, thd = 0x50daba0, fake_select_lex = 0x0, union_distinct = 0x0, describe = false, explain_marker = 0},
select_lex = {<st_select_lex_node> = {_vptr.st_select_lex_node = 0x11eecb0 <vtable for st_select_lex+16>, next = 0x0, prev = 0x50dd1a0, master = 0x50dd180, slave = 0x0, link_next = 0x0, link_prev = 0x50ddad0, options = 0,
sql_cache = st_select_lex_node::SQL_CACHE_UNSPECIFIED, uncacheable = 0 '\000', linkage = UNSPECIFIED_TYPE, no_table_names_allowed = false, no_error = false}, context = {<Sql_alloc> = {<No data fields>}, outer_context = 0x0, table_list = 0x0,
first_name_resolution_table = 0x0, last_name_resolution_table = 0x0, select_lex = 0x50dd7c8, error_processor = 0x5dd5a0 <dummy_error_processor(THD*, void*)>, error_processor_data = 0x0, resolve_in_select_list = true, security_ctx = 0x0},
resolve_place = st_select_lex::RESOLVE_NONE, resolve_nest = 0x0, db = 0x0, where = 0x0, having = 0x0, prep_where = 0x0, prep_having = 0x0, cond_value = Item::COND_UNDEF, having_value = Item::COND_UNDEF, parent_lex = 0x50dd0b0, olap = UNSPECIFIED_OLAP_TYPE,
table_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x50dd8b8}, group_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x50dd8d0}, group_list_ptrs = 0x0,
item_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7ffee40055c8, last = 0x7ffee40055c8, elements = 1}, <No data fields>}, interval_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50dd900,
elements = 0}, <No data fields>}, is_item_list_lookup = true, ftfunc_list = 0x50dd928, ftfunc_list_alloc = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50dd928, elements = 0}, <No data fields>}, join = 0x0,
top_join_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50dd948, elements = 0}, <No data fields>}, join_list = 0x50dd948, embedding = 0x0, sj_nests = {<base_list> = {<Sql_alloc> = {<No data fields>},
first = 0x131cc00 <end_of_list>, last = 0x50dd970, elements = 0}, <No data fields>}, leaf_tables = 0x0, order_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x50dd998}, order_list_ptrs = 0x0,
gorder_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x50dd9b8}, select_limit = 0x7ffee4005a00, offset_limit = 0x0, ref_pointer_array = {m_array = 0x7ffee4005f08, m_size = 10}, derived_table_count = 0, materialized_table_count = 0,
partitioned_table_count = 0, select_n_having_items = 1, cond_count = 0, between_count = 0, max_equal_elems = 0, select_n_where_fields = 0, parsing_place = NO_MATTER, with_sum_func = false, table_join_options = 0, in_sum_expr = 0, select_number = 1,
nest_level = 0, inner_sum_func_list = 0x0, with_wild = 0, braces = false, having_fix_field = false, group_fix_field = false, inner_refs_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50dda38,
elements = 0}, <No data fields>}, n_sum_items = 0, n_child_sum_items = 0, explicit_limit = false, subquery_in_having = false, first_execution = true, first_natural_join_processing = true, first_cond_optimization = false, no_wrap_view_item = false,
exclude_from_table_unique_test = false, non_agg_fields = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50dda60, elements = 0}, <No data fields>}, static ALL_FIELDS_UNDEF_POS = -2147483648,
cur_pos_in_all_fields = -2147483648, udf_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50dda80, elements = 0}, <No data fields>}, prev_join_using = 0x0, select_list_tables = 0, removed_select = 0x0,
m_non_agg_field_used = false, m_agg_func_used = false, current_index_hint_type = INDEX_HINT_IGNORE, current_index_hint_clause = 0 '\000', index_hints = 0x0, static type_str = {0xbc3358 "NONE", 0xbbd0d8 "PRIMARY", 0xbb15f9 "SIMPLE", 0xbbd61d "DERIVED",
0xbbd625 "SUBQUERY", 0xbc316a "UNION", 0xbbd62e "UNION RESULT", 0xbbd63b "MATERIALIZED"}}, current_select = 0x0, all_selects_list = 0x50dd7c8, length = 0x0, dec = 0x0, change = 0x0, name = {str = 0x0, length = 0}, help_arg = 0x0, to_log = 0x0,
x509_subject = 0x0, x509_issuer = 0x0, ssl_cipher = 0x0, wild = 0x0, exchange = 0x0, result = 0x0, default_value = 0x0, on_update_value = 0x0, comment = {str = 0x0, length = 0}, ident = {str = 0x0, length = 0}, grant_user = 0x0, xid = 0x0, thd = 0x50daba0,
plugins = {buffer = 0x50ddbb0 "", elements = 0, max_element = 16, alloc_increment = 16, size_of_element = 8}, plugins_static_buffer = {0x0 <repeats 16 times>}, charset = 0x0, text_string_is_7bit = false, leaf_tables_insert = 0x0, create_view_select = {str = 0x0,
length = 0}, raw_trg_on_table_name_begin = 0x0, raw_trg_on_table_name_end = 0x0, part_info = 0x0, definer = 0x0, col_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ddc78, elements = 0}, <No data fields>},
ref_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ddc90, elements = 0}, <No data fields>}, load_set_str_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>,
last = 0x50ddca8, elements = 0}, <No data fields>}, interval_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ddcc0, elements = 0}, <No data fields>},
users_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ddcd8, elements = 0}, <No data fields>}, columns = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ddcf0,
elements = 0}, <No data fields>}, insert_list = 0x0, field_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ddd10, elements = 0}, <No data fields>},
value_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ddd28, elements = 0}, <No data fields>}, update_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ddd40,
elements = 0}, <No data fields>}, many_values = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ddd58, elements = 0}, <No data fields>}, var_list = {<base_list> = {<Sql_alloc> = {<No data fields>},
first = 0x131cc00 <end_of_list>, last = 0x50ddd70, elements = 0}, <No data fields>}, set_var_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ddd88, elements = 0}, <No data fields>},
param_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50ddda0, elements = 0}, <No data fields>}, view_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50dddb8,
elements = 0}, <No data fields>}, context_stack = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7ffee4004b80, last = 0x7ffee4004b80, elements = 1}, <No data fields>}, set_statement = false, proc_analyse = 0x0,
auxiliary_table_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x50dde00}, save_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x50dde18}, last_field = 0x0, in_sum_func = 0x0, udf = {name = {str = 0x0,
length = 0}, returns = STRING_RESULT, type = (unknown: 0), dl = 0x0, dlhandle = 0x0, func = 0x0, func_init = 0x0, func_deinit = 0x0, func_clear = 0x0, func_add = 0x0, usage_count = 0}, check_opt = {flags = 0, sql_flags = 0, key_cache = 0x0}, create_info = {
table_charset = 0x0, default_table_charset = 0x0, connect_string = {str = 0x0, length = 0}, password = 0x0, tablespace = 0x0, comment = {str = 0x0, length = 0}, data_file_name = 0x0, index_file_name = 0x0, alias = 0x0, max_rows = 0, min_rows = 0,
auto_increment_value = 0, table_options = 0, avg_row_length = 0, used_fields = 0, key_block_size = 0, stats_sample_pages = 0, stats_auto_recalc = HA_STATS_AUTO_RECALC_DEFAULT, merge_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0,
next = 0x50ddf40}, db_type = 0x0, row_type = ROW_TYPE_DEFAULT, null_bits = 0, options = 0, merge_insert_method = 0, extra_size = 0, varchar = false, storage_media = HA_SM_DEFAULT}, key_create_info = {algorithm = HA_KEY_ALG_UNDEF, block_size = 0, parser_name = {
str = 0x0, length = 0}, comment = {str = 0x0, length = 0}, check_for_duplicate_indexes = false}, mi = {host = 0x0, user = 0x0, password = 0x0, log_file_name = 0x0, bind_addr = 0x0, port = 0, connect_retry = 0, heartbeat_period = 0, sql_delay = 0, pos = 0,
server_id = 0, retry_count = 0, gtid = 0x0, gtid_until_condition = st_lex_master_info::UNTIL_SQL_BEFORE_GTIDS, until_after_gaps = false, ssl = st_lex_master_info::LEX_MI_UNCHANGED, ssl_verify_server_cert = st_lex_master_info::LEX_MI_UNCHANGED,
heartbeat_opt = st_lex_master_info::LEX_MI_UNCHANGED, repl_ignore_server_ids_opt = st_lex_master_info::LEX_MI_UNCHANGED, retry_count_opt = st_lex_master_info::LEX_MI_UNCHANGED, auto_position = st_lex_master_info::LEX_MI_UNCHANGED, ssl_key = 0x0, ssl_cert = 0x0,
ssl_ca = 0x0, ssl_capath = 0x0, ssl_cipher = 0x0, ssl_crl = 0x0, ssl_crlpath = 0x0, relay_log_name = 0x0, relay_log_pos = 0, repl_ignore_server_ids = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0}, server_ids_buffer = {0,
0}}, slave_connection = {user = 0x0, password = 0x0, plugin_auth = 0x0, plugin_dir = 0x0}, server_options = {port = -1, server_name_length = 0, server_name = 0x0, host = 0x0, db = 0x0, username = 0x0, password = 0x0, scheme = 0x0, socket = 0x0, owner = 0x0},
mqh = {questions = 0, updates = 0, conn_per_hour = 0, user_conn = 0, specified_limits = 0}, reset_slave_info = {all = false}, type = 0, allow_sum_func = 0, m_sql_cmd = 0x0, expr_allows_subselect = true, ssl_type = SSL_TYPE_NONE, duplicates = DUP_ERROR,
tx_isolation = ISO_READ_UNCOMMITTED, xa_opt = XA_NONE, option_type = OPT_DEFAULT, create_view_mode = VIEW_CREATE_NEW, drop_mode = DROP_DEFAULT, profile_query_id = 0, profile_options = 0, uint_geom_type = 0, grant = 0, grant_tot_col = 0, which_columns = 0,
fk_match_option = Foreign_key::FK_MATCH_UNDEF, fk_update_opt = Foreign_key::FK_OPTION_UNDEF, fk_delete_opt = Foreign_key::FK_OPTION_UNDEF, slave_thd_opt = 0, start_transaction_opt = 0, nest_level = 0, describe = 0 '\000', derived_tables = 0 '\000',
create_view_algorithm = 0 '\000', create_view_check = 0 '\000', context_analysis_only = 0 '\000', drop_if_exists = false, drop_temporary = false, local_file = false, one_shot_set = false, autocommit = false, verbose = false, no_write_to_binlog = false,
tx_chain = TVL_YES, tx_release = TVL_YES, safe_to_cache_query = false, subqueries = false, ignore = false, parsing_options = {allows_variable = true, allows_select_into = true, allows_select_procedure = true, allows_derived = true}, alter_info = {
static ALTER_ADD_COLUMN = 1, static ALTER_DROP_COLUMN = 2, static ALTER_CHANGE_COLUMN = 4, static ALTER_ADD_INDEX = 8, static ALTER_DROP_INDEX = 16, static ALTER_RENAME = 32, static ALTER_ORDER = 64, static ALTER_OPTIONS = 128,
static ALTER_CHANGE_COLUMN_DEFAULT = 256, static ALTER_KEYS_ONOFF = 512, static ALTER_CONVERT = 1024, static ALTER_RECREATE = 2048, static ALTER_ADD_PARTITION = 4096, static ALTER_DROP_PARTITION = 8192, static ALTER_COALESCE_PARTITION = 16384,
static ALTER_REORGANIZE_PARTITION = 32768, static ALTER_PARTITION = 65536, static ALTER_ADMIN_PARTITION = 131072, static ALTER_TABLE_REORG = 262144, static ALTER_REBUILD_PARTITION = 524288, static ALTER_ALL_PARTITION = 1048576,
static ALTER_REMOVE_PARTITIONING = 2097152, static ADD_FOREIGN_KEY = 4194304, static DROP_FOREIGN_KEY = 8388608, static ALTER_EXCHANGE_PARTITION = 16777216, static ALTER_TRUNCATE_PARTITION = 33554432, static ALTER_COLUMN_ORDER = 67108864,
drop_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50de1b8, elements = 0}, <No data fields>}, alter_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50de1d0,
elements = 0}, <No data fields>}, key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50de1e8, elements = 0}, <No data fields>}, create_list = {<base_list> = {<Sql_alloc> = {<No data fields>},
first = 0x131cc00 <end_of_list>, last = 0x50de200, elements = 0}, <No data fields>}, delayed_key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50de218, elements = 0}, <No data fields>},
delayed_key_info = 0x0, delayed_key_count = 0, flags = 0, keys_onoff = Alter_info::LEAVE_AS_IS, partition_names = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50de248, elements = 0}, <No data fields>},
num_parts = 0, requested_algorithm = Alter_info::ALTER_TABLE_ALGORITHM_DEFAULT, requested_lock = Alter_info::ALTER_TABLE_LOCK_DEFAULT}, create_last_non_select_table = 0x0, prepared_stmt_name = {str = 0x0, length = 0}, prepared_stmt_code = {str = 0x0,
length = 0}, prepared_stmt_code_is_varref = false, prepared_stmt_params = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50de2a0, elements = 0}, <No data fields>}, sphead = 0x0, spname = 0x0, sp_lex_in_use = false,
all_privileges = false, proxy_priv = false, is_change_password = false, is_set_password_sql = false, contains_plaintext_password = false, m_broken = false, sp_current_parsing_ctx = 0x0, sp_chistics = {comment = {str = 0x0, length = 0}, suid = SP_IS_DEFAULT_SUID,
detistic = false, daccess = SP_DEFAULT_ACCESS}, event_parse_data = 0x0, only_view = false, empty_field_list_on_rset = false, create_view_suid = 0 '\000', {stmt_definition_begin = 0x0, keyword_delayed_begin_offset = 0}, {stmt_definition_end = 0x0,
keyword_delayed_end_offset = 0}, use_only_table_context = false, alter_tablespace_info = 0x0, escape_used = false, is_lex_started = true, used_tables = 0, explain_format = 0x0}, main_mem_root = {free = 0x7ffee4004ae0, used = 0x0, pre_alloc = 0x7ffee4004ae0,
min_malloc = 32, block_size = 8160, block_num = 4, first_block_usage = 0, error_handler = 0x6a8330 <sql_alloc_error_handler()>}, main_da = {m_is_sent = true, m_can_overwrite_status = false, m_message = '\000' <repeats 511 times>, m_sql_errno = 0,
m_sqlstate = "\000\000\000\000\000", m_affected_rows = 0, m_last_insert_id = 0, m_statement_warn_count = 0, m_status = Diagnostics_area::DA_OK, m_main_wi = {m_warn_root = {free = 0x5092b00, used = 0x0, pre_alloc = 0x5092b00, min_malloc = 32, block_size = 2016,
block_num = 4, first_block_usage = 0, error_handler = 0x6a8330 <sql_alloc_error_handler()>}, m_warn_list = {<I_P_List_counter> = {m_counter = 0}, <I_P_List_fast_push_back<Sql_condition>> = {m_last = 0x50de5e8}, m_first = 0x0}, m_warn_count = {0, 0, 0},
m_current_statement_warn_count = 0, m_current_row_for_warning = 1, m_warn_id = 0, m_error_condition = 0x0, m_allow_unlimited_warnings = false, m_read_only = false, m_next_in_da = 0x0, m_prev_in_da = 0x50de658,
m_marked_sql_conditions = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x131cc00 <end_of_list>, last = 0x50de630, elements = 0}, <No data fields>}}, m_wi_stack = {<I_P_List_counter> = {m_counter = 1}, <I_P_List_fast_push_back<Warning_info>> = {
m_last = 0x50de620}, m_first = 0x50de5a0}}, m_stmt_da = 0x50de378, m_binlog_invoker = false, invoker_user = {str = 0x0, length = 0}, invoker_host = {str = 0x0, length = 0}}
$3 = {len = 2048, used = 174,
data = 0x7ffee4009e50 "{\"msg-type\":\"activity\",\"date\":\"1438184021217\",\"thread-id\":\"182\",\"query-id\":\"1161\",\"user\":\"root\",\"priv_user\":\"root\",\"host\":\"localhost\",\"ip\":\"\",\"cmd\":\"Init DB\",\"objects\":[{\"db\"", alloc = 0x7ffee4007590}Hi,
Thanks for all the info. Unfortunately, this is one sneaky bug. I would like to schedule an online session with you. I think it will be easier to debug this instead of going back and forth all the time with further requests. Please send me an email to guy@guylichtman.com .
riern
commented
9 years ago Hi we made a small script that will cause the crash, it's only the "use db" command in multiple threads.
#!/bin/bash
set -e
threads=20
itterations_in_thread=20
sleep_per_itteration="0.001"
mysql_connection="/usr/local/mysql/bin/mysql --login-path=root_main_fi_s_b"
mysql_command="use test; use mysql;"
function do_in_thread {
for ((i=0; i<$itterations_in_thread; i++)); do
$mysql_connection -e "${mysql_command}"
sleep ${sleep_per_itteration}
done
}
while [ $threads -gt 0 ]; do
echo "Start backgroud thread $threads"
do_in_thread &
let threads=threads-1
done
echo "All threads started... "Have done some more testing, have done test with the following combinations
CentOS7 & MySQL Community: Works CentOS7 & MariaDB: Works CentOS7 & Percona-Server: Crash
Ubuntu14.04 & MySQL Community: Works Ubuntu14.04 & MariaDB: Works Ubuntu14.04 & Percona-Server: Crash
Debian8 & MySQL Community: Works Debian8 & MariaDB: Works Debian8 & Percona-Server: Crash
All OS, was updated with the latest available patches
Server versions: MySQL-Community: 5.6.26 MariaDB: 10.0.21 Percona-Server: 5.6.25
glicht
commented
9 years ago Thanks for the update. It looks like something specific to percona from your results.
Still investigating what could be the root cause. Will keep you updated. On Aug 7, 2015 2:04 PM, "dthorell" notifications@github.com wrote:
Have done some more testing, have done test with the following combinations
CentOS7 & MySQL Community: Works CentOS7 & MariaDB: Works CentOS7 & Percona-Server: Crash
Ubuntu14.04 & MySQL Community: Works Ubuntu14.04 & MariaDB: Works Ubuntu14.04 & Percona-Server: Crash
Debian8 & MySQL Community: Works Debian8 & MariaDB: Works Debian8 & Percona-Server: Crash
All OS, was updated with the latest available patches
Server versions: MySQL-Community: 5.6.26 MariaDB: 10.0.21 Percona-Server: 5.6.25
— Reply to this email directly or view it on GitHub https://github.com/mcafee/mysql-audit/issues/118#issuecomment-128674479.
glicht
commented
9 years ago Issue seems to be that you didn't use the proper offset-extract.sh script. It looks like you used an old script which didn't include the latest 2 offsets. You should be using the following script: https://raw.githubusercontent.com/mcafee/mysql-audit/master/offset-extract/offset-extract.sh
For Percona 5.6.20 you should have the following offsets:
audit_offsets = 8624, 8672, 4376, 5016, 88, 2720, 96, 0, 32, 104, 152, 8792Please try using the proper offsets and report back.
dthorell
commented
9 years ago Seems to be right, must have mixed up two versions of the script. Will try with load on the database, will report back if it's still an issue.
Suggestion: Add a check for number of offsets in startup & refuse to start if wrong number of offsets
glicht
commented
9 years ago Your suggestion is valid and we plan to add a sanity check for this soon.
This still seams to be a issue.
Not on every statement but during load on db running the statement:
use test;
Might cause the mysql_db to crash.
Tested with: Percona-Server-5.6.20-rel68.0-656.Linux.x86_64
[client] port = 13208 socket = /tmp/db1.sock character_set_client=utf8mb4 collation_connection=utf8mb4_swedish_ci [mysqld] plugin-load=AUDIT=libaudit_plugin.so audit_offsets = 8624, 8672, 4376, 5016, 88, 2720, 96, 0, 32, 104 audit_json_file = 1 audit_json_log_file = /db-log/db1/auditlog/audit.log audit_json_file_bufsize=262144 audit_validate_checksum=ON audit_offsets_by_version=1 basedir=/usr/local/mysql skip-slave-start character_set_server=utf8mb4 collation_server=utf8mb4_swedish_ci skip_character_set_client_handshake slave_type_conversions="ALL_NON_LOSSY" default_tmp_storage_engine=myisam federated default_storage_engine = innodb slave_skip_errors = 1146 port = 13208 socket = /tmp/db1.sock skip-external-locking datadir = /db/db1/ key_buffer_size = 256M max_allowed_packet = 16M table_open_cache = 8192 myisam_sort_buffer_size = 512M thread_cache_size = 64 query_cache_size = 0 query_cache_type=OFF join_buffer_size = 4M thread_concurrency = 4 max_connections = 1500 max_user_connections = 1000 max_heap_table_size = 4G max_connect_errors = 1000 tmp_table_size = 4G long_query_time=1 group_concat_max_len=8192 concurrent_insert=2 tmpdir = /db/db1/tmp/ sql-mode="NO_UNSIGNED_SUBTRACTION" bulk_insert_buffer_size=512M default_week_format=3 slow_query_log=1 slow_query_log_file=/db-log/db1/slowlog/slowquery.log server-id = 8 relay-log=/db-log/db1/relaylog/mysql-relay-bin relay-log-index=/db-log/db1/relaylog/relay-bin.index relay-log-info-file=/db-log/db1/relaylog/relay-bin.info innodb_buffer_pool_size = 2G innodb_log_file_size = 512M innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 2 innodb_lock_wait_timeout = 50 innodb_flush_method = O_DIRECT innodb_thread_concurrency = 0 innodb_io_capacity = 1200 innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_file_per_table=1 innodb_file_format=barracuda transaction-isolation = READ-COMMITTED [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer_size = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer_size = 2048M sort_buffer_size = 4096M read_buffer = 4M write_buffer = 4M [mysqlhotcopy]
interactive-timeout
150724 09:52:30 mysqld_safe Starting mysqld daemon with databases from /db/db1/ 2015-07-24 09:52:31 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-07-24 09:52:31 10002 [Warning] option 'audit-json-file-bufsize': signed value 0 adjusted to 1 2015-07-24 09:52:31 10002 [Warning] option 'plugin-audit-json-file-bufsize': signed value 0 adjusted to 1 2015-07-24 09:52:31 10002 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-07-24 09:52:31 10002 [Note] InnoDB: The InnoDB memory heap is disabled 2015-07-24 09:52:31 10002 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-07-24 09:52:31 10002 [Note] InnoDB: Memory barrier is not used 2015-07-24 09:52:31 10002 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-07-24 09:52:31 10002 [Note] InnoDB: Using Linux native AIO 2015-07-24 09:52:31 10002 [Note] InnoDB: Using CPU crc32 instructions 2015-07-24 09:52:31 10002 [Note] InnoDB: Initializing buffer pool, size = 2.0G 2015-07-24 09:52:31 10002 [Note] InnoDB: Completed initialization of buffer pool 2015-07-24 09:52:31 10002 [Note] InnoDB: Highest supported file format is Barracuda. 2015-07-24 09:52:31 10002 [Note] InnoDB: 128 rollback segment(s) are active. 2015-07-24 09:52:31 10002 [Note] InnoDB: Waiting for purge to start 2015-07-24 09:52:31 10002 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.20-rel68.0 started; log sequence number 780118033375 2015-07-24 09:52:31 10002 [Note] Audit Plugin: starting up. Version: 1.0.8 , Revision: 527 (64bit). AUDIT plugin interface version: 769 (0x301). MySQL Server version: 5.6.20-68.0-log. 2015-07-24 09:52:31 10002 [Note] Audit Plugin: setup_offsets audit_offsets: 8624, 8672, 4376, 5016, 88, 2720, 96, 0, 32, 104 validate_checksum: 1 offsets_by_version: 1 2015-07-24 09:52:32 10002 [Note] Audit Plugin: mysqld: /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld (86559c027aa9a33b7d3694cef7c6f4be) 2015-07-24 09:52:32 10002 [Note] Audit Plugin: setup_offsets Audit_formatter::thd_offsets values: 8624 8672 4376 5016 88 2720 96 0 32 104 2015-07-24 09:52:32 10002 [Note] Audit Plugin: extended offsets validate res: MySQL thread id 123456, OS thread handle 0x0, query id 789 aud_tusr 2015-07-24 09:52:32 10002 [Note] Audit Plugin: Validation passed. Using offsets from audit_offsets: 8624, 8672, 4376, 5016, 88, 2720, 96, 0, 32, 104 2015-07-24 09:52:32 10002 [Note] Audit Plugin: Set password_masking_cmds num: 7, value: CREATE_USER,GRANT,SET_OPTION,SLAVE_START,CREATE_SERVER,ALTER_SERVER,CHANGE_MASTER 2015-07-24 09:52:32 10002 [Note] Audit Plugin: Compile password_masking_regex res: [0] 2015-07-24 09:52:32 10002 [Note] Audit Plugin: Set password_maskingregex value: [identified(?:/*.?_/|\s)?by(?:/_.?_/|\s)?(?:password)?(?:/_.?_/|\s)?'|"(?<!)['|"]|password(?:/_.?_/|\s)?((?:/_.?_/|\s)?'|"(?<!)'|"?)|password(?:/.?_/|\s)?(?:for(?:/_.?_/|\s)?\S+?)?(?:/_.?_/|\s)?=(?:/_.?_/|\s)?['|"](?. ?)(?<!)['|"]|password(?:/_.?_/|\s)?'|"(?<!)['|"]]
2015-07-24 09:52:32 10002 [Note] Audit Plugin: Set json_socket_name str: [] value: [/tmp/mysql.audit__db_db1_13208]
2015-07-24 09:52:32 10002 [Note] Audit Plugin: bufsize for file [/db-log/db1/auditlog/audit.log]: 4096. Value of json_file_bufsize: 262144.
2015-07-24 09:52:32 10002 [Note] Audit Plugin: success opening file: /db-log/db1/auditlog/audit.log.
2015-07-24 09:52:32 10002 [Note] Audit Plugin: mem func addr: 0x7f4bf4bc66b0 mem start addr: 0x7f4bf4bc7000 page size: 4096
2015-07-24 09:52:32 10002 [Note] Audit Plugin: hot patching function: 0x6f84c0, trampolineFunction: 0x7f4bf4bc7000 trampolinePage: 0x7f4bf4bc7000
2015-07-24 09:52:32 10002 [Note] Audit Plugin: hot patch for: mysql_execute_command (0x6f84c0) complete. Audit func: 0x7f4bf4bc6040, Trampoline address: 0x7f4bf4bc7000 size: 16.
2015-07-24 09:52:32 10002 [Note] Audit Plugin: hot patching function: 0x6bc880, trampolineFunction: 0x7f4bf4bc7020 trampolinePage: 0x7f4bf4bc7000
2015-07-24 09:52:32 10002 [Note] Audit Plugin: hot patch for: send_result_to_client (0x6bc880) complete. Audit func: 0x7f4bf4bc5cc0, Trampoline address: 0x7f4bf4bc7020 size: 15.
2015-07-24 09:52:32 10002 [Note] Audit Plugin: hot patching function: 0x6f4820, trampolineFunction: 0x7f4bf4bc7040 trampolinePage: 0x7f4bf4bc7000
2015-07-24 09:52:32 10002 [Note] Audit Plugin: hot patch for: check_table_access (0x6f4820) complete. Audit func: 0x7f4bf4bc5b70, Trampoline address: 0x7f4bf4bc7040 size: 15.
2015-07-24 09:52:32 10002 [Note] Audit Plugin: hot patching function: 0x6b5580, trampolineFunction: 0x7f4bf4bc7060 trampolinePage: 0x7f4bf4bc7000
2015-07-24 09:52:32 10002 [Note] Audit Plugin: hot patch for: open_tables (0x6b5580) complete. Audit func: 0x7f4bf4bc5d90, Trampoline address: 0x7f4bf4bc7060 size: 18.
2015-07-24 09:52:32 10002 [Note] Audit Plugin: Done initializing sql command names. status_vars_index: [152], com_status_vars: [0x1215060].
2015-07-24 09:52:32 10002 [Note] Audit Plugin: Init completed successfully.
2015-07-24 09:52:32 10002 [Note] RSA private key file not found: /db/db1//private_key.pem. Some authentication plugins will not work.
2015-07-24 09:52:32 10002 [Note] RSA public key file not found: /db/db1//publickey.pem. Some authentication plugins will not work.
2015-07-24 09:52:32 10002 [Note] Server hostname (bind-address): ''; port: 13208
2015-07-24 09:52:32 10002 [Note] IPv6 is available.
2015-07-24 09:52:32 10002 [Note] - '::' resolves to '::';
2015-07-24 09:52:32 10002 [Note] Server socket created on IP: '::'.
2015-07-24 09:52:32 10002 [Note] Event Scheduler: Loaded 0 events
2015-07-24 09:52:32 10002 [Note] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld: ready for connections.
Version: '5.6.20-68.0-log' socket: '/tmp/db1.sock' port: 13208 Percona Server (GPL), Release 68.0, Revision 656
2015-07-24 09:52:47 10002 [Warning] IP address '172.17.2.57' could not be resolved: Name or service not known
07:52:48 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
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.
Please help us make Percona Server better by reporting any
bugs at http://bugs.percona.com/
key_buffer_size=268435456 read_buffer_size=131072 max_used_connections=22 max_threads=1502 thread_count=17 connection_count=17 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 861028 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x6f50ea0 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 = 7f4b386d5d80 thread_stack 0x40000 /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(my_print_stacktrace+0x2c)[0x8eb45c] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(handle_fatal_signal+0x461)[0x678f01] /lib64/libpthread.so.0(+0xf130)[0x7f4c2b3c6130] /lib64/libc.so.6(+0x1627d1)[0x7f4c29b457d1] /usr/local/mysql/lib/mysql/plugin/libaudit_plugin.so(+0x118b0)[0x7f4bf4bcb8b0] /usr/local/mysql/lib/mysql/plugin/libaudit_plugin.so(+0x10a75)[0x7f4bf4bcaa75] /usr/local/mysql/lib/mysql/plugin/libaudit_plugin.so(+0x105f7)[0x7f4bf4bca5f7] /usr/local/mysql/lib/mysql/plugin/libaudit_plugin.so(+0x1066e)[0x7f4bf4bca66e] /usr/local/mysql/lib/mysql/plugin/libaudit_plugin.so(+0xb89a)[0x7f4bf4bc589a] /usr/local/mysql/lib/mysql/plugin/libaudit_plugin.so(+0xbe38)[0x7f4bf4bc5e38] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld[0x6a8935] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(_Z18mysql_audit_notifyP3THDjjz+0xa8)[0x6a8b08] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x9b8)[0x700558] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x162)[0x6ce8e2] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(handle_one_connection+0x40)[0x6ce9d0] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(pfs_spawn_thread+0x143)[0x9224a3] /lib64/libpthread.so.0(+0x7df3)[0x7f4c2b3bedf3] /lib64/libc.so.6(clone+0x6d)[0x7f4c29ad91ad]
Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 215 Status: NOT_KILLED
You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 150724 09:52:48 mysqld_safe Number of processes running now: 0 150724 09:52:48 mysqld_safe mysqld restarted 2015-07-24 09:52:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-07-24 09:52:49 13110 [Warning] option 'audit-json-file-bufsize': signed value 0 adjusted to 1 2015-07-24 09:52:49 13110 [Warning] option 'plugin-audit-json-file-bufsize': signed value 0 adjusted to 1 2015-07-24 09:52:49 13110 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-07-24 09:52:49 13110 [Note] InnoDB: The InnoDB memory heap is disabled 2015-07-24 09:52:49 13110 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-07-24 09:52:49 13110 [Note] InnoDB: Memory barrier is not used 2015-07-24 09:52:49 13110 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-07-24 09:52:49 13110 [Note] InnoDB: Using Linux native AIO 2015-07-24 09:52:49 13110 [Note] InnoDB: Using CPU crc32 instructions 2015-07-24 09:52:49 13110 [Note] InnoDB: Initializing buffer pool, size = 2.0G 2015-07-24 09:52:49 13110 [Note] InnoDB: Completed initialization of buffer pool 2015-07-24 09:52:49 13110 [Note] InnoDB: Highest supported file format is Barracuda. 2015-07-24 09:52:49 13110 [Note] InnoDB: Log scan progressed past the checkpoint lsn 780118036899 2015-07-24 09:52:49 13110 [Note] InnoDB: Database was not shutdown normally! 2015-07-24 09:52:49 13110 [Note] InnoDB: Starting crash recovery. 2015-07-24 09:52:49 13110 [Note] InnoDB: Reading tablespace information from the .ibd files... 2015-07-24 09:52:50 13110 [Note] InnoDB: Restoring possible half-written data pages 2015-07-24 09:52:50 13110 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 780118068475 2015-07-24 09:52:50 13110 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 367868047, file name mysql-bin.000012 2015-07-24 09:52:50 13110 [Note] InnoDB: 128 rollback segment(s) are active. 2015-07-24 09:52:50 13110 [Note] InnoDB: Waiting for purge to start 2015-07-24 09:52:51 13110 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.20-rel68.0 started; log sequence number 780118068475 2015-07-24 09:52:51 13110 [Note] Audit Plugin: starting up. Version: 1.0.8 , Revision: 527 (64bit). AUDIT plugin interface version: 769 (0x301). MySQL Server version: 5.6.20-68.0-log. 2015-07-24 09:52:51 13110 [Note] Audit Plugin: setup_offsets audit_offsets: 8624, 8672, 4376, 5016, 88, 2720, 96, 0, 32, 104 validate_checksum: 1 offsets_by_version: 1 2015-07-24 09:52:51 13110 [Note] Audit Plugin: mysqld: /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld (86559c027aa9a33b7d3694cef7c6f4be) 2015-07-24 09:52:51 13110 [Note] Audit Plugin: setup_offsets Audit_formatter::thd_offsets values: 8624 8672 4376 5016 88 2720 96 0 32 104 2015-07-24 09:52:51 13110 [Note] Audit Plugin: extended offsets validate res: MySQL thread id 123456, OS thread handle 0x0, query id 789 aud_tusr 2015-07-24 09:52:51 13110 [Note] Audit Plugin: Validation passed. Using offsets from audit_offsets: 8624, 8672, 4376, 5016, 88, 2720, 96, 0, 32, 104 2015-07-24 09:52:51 13110 [Note] Audit Plugin: Set password_masking_cmds num: 7, value: CREATE_USER,GRANT,SET_OPTION,SLAVE_START,CREATE_SERVER,ALTER_SERVER,CHANGE_MASTER 2015-07-24 09:52:51 13110 [Note] Audit Plugin: Compile password_masking_regex res: [0] 2015-07-24 09:52:51 13110 [Note] Audit Plugin: Set password_maskingregex value: [identified(?:/*.?_/|\s)?by(?:/_.?_/|\s)?(?:password)?(?:/_.?_/|\s)?'|"(?<!)['|"]|password(?:/_.?_/|\s)?((?:/_.?_/|\s)?'|"(?<!)'|"?)|password(?:/.?_/|\s)?(?:for(?:/_.?_/|\s)?\S+?)?(?:/_.?_/|\s)?=(?:/_.?_/|\s)?['|"](?. ?)(?<!)['|"]|password(?:/_.?_/|\s)?'|"(?<!)['|"]]
2015-07-24 09:52:51 13110 [Note] Audit Plugin: Set json_socket_name str: [] value: [/tmp/mysql.audit__db_db1_13208]
2015-07-24 09:52:51 13110 [Note] Audit Plugin: bufsize for file [/db-log/db1/auditlog/audit.log]: 4096. Value of json_file_bufsize: 262144.
2015-07-24 09:52:51 13110 [Note] Audit Plugin: success opening file: /db-log/db1/auditlog/audit.log.
2015-07-24 09:52:51 13110 [Note] Audit Plugin: mem func addr: 0x7f41e8a496b0 mem start addr: 0x7f41e8a4a000 page size: 4096
2015-07-24 09:52:51 13110 [Note] Audit Plugin: hot patching function: 0x6f84c0, trampolineFunction: 0x7f41e8a4a000 trampolinePage: 0x7f41e8a4a000
2015-07-24 09:52:51 13110 [Note] Audit Plugin: hot patch for: mysql_execute_command (0x6f84c0) complete. Audit func: 0x7f41e8a49040, Trampoline address: 0x7f41e8a4a000 size: 16.
2015-07-24 09:52:51 13110 [Note] Audit Plugin: hot patching function: 0x6bc880, trampolineFunction: 0x7f41e8a4a020 trampolinePage: 0x7f41e8a4a000
2015-07-24 09:52:51 13110 [Note] Audit Plugin: hot patch for: send_result_to_client (0x6bc880) complete. Audit func: 0x7f41e8a48cc0, Trampoline address: 0x7f41e8a4a020 size: 15.
2015-07-24 09:52:51 13110 [Note] Audit Plugin: hot patching function: 0x6f4820, trampolineFunction: 0x7f41e8a4a040 trampolinePage: 0x7f41e8a4a000
2015-07-24 09:52:51 13110 [Note] Audit Plugin: hot patch for: check_table_access (0x6f4820) complete. Audit func: 0x7f41e8a48b70, Trampoline address: 0x7f41e8a4a040 size: 15.
2015-07-24 09:52:51 13110 [Note] Audit Plugin: hot patching function: 0x6b5580, trampolineFunction: 0x7f41e8a4a060 trampolinePage: 0x7f41e8a4a000
2015-07-24 09:52:51 13110 [Note] Audit Plugin: hot patch for: open_tables (0x6b5580) complete. Audit func: 0x7f41e8a48d90, Trampoline address: 0x7f41e8a4a060 size: 18.
2015-07-24 09:52:51 13110 [Note] Audit Plugin: Done initializing sql command names. status_vars_index: [152], com_status_vars: [0x1215060].
2015-07-24 09:52:51 13110 [Note] Audit Plugin: Init completed successfully.
2015-07-24 09:52:51 13110 [Note] RSA private key file not found: /db/db1//private_key.pem. Some authentication plugins will not work.
2015-07-24 09:52:51 13110 [Note] RSA public key file not found: /db/db1//publickey.pem. Some authentication plugins will not work.
2015-07-24 09:52:51 13110 [Note] Server hostname (bind-address): ''; port: 13208
2015-07-24 09:52:51 13110 [Note] IPv6 is available.
2015-07-24 09:52:51 13110 [Note] - '::' resolves to '::';
2015-07-24 09:52:51 13110 [Note] Server socket created on IP: '::'.
2015-07-24 09:52:51 13110 [Note] Event Scheduler: Loaded 0 events
2015-07-24 09:52:51 13110 [Note] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld: ready for connections.
Version: '5.6.20-68.0-log' socket: '/tmp/db1.sock' port: 13208 Percona Server (GPL), Release 68.0, Revision 656
2015-07-24 09:52:51 13110 [Warning] IP address '172.17.2.57' could not be resolved: Name or service not known
07:52:52 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
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.
Please help us make Percona Server better by reporting any
bugs at http://bugs.percona.com/
key_buffer_size=268435456 read_buffer_size=131072 max_used_connections=17 max_threads=1502 thread_count=15 connection_count=15 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 861028 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x5fdbb80 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 = 7f412d1a9d80 thread_stack 0x40000 /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(my_print_stacktrace+0x2c)[0x8eb45c] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(handle_fatal_signal+0x461)[0x678f01] /lib64/libpthread.so.0(+0xf130)[0x7f421c39a130] /lib64/libc.so.6(+0x1627d1)[0x7f421ab197d1] /usr/local/mysql/lib/mysql/plugin/libaudit_plugin.so(+0x118b0)[0x7f41e8a4e8b0] /usr/local/mysql/lib/mysql/plugin/libaudit_plugin.so(+0x10a75)[0x7f41e8a4da75] /usr/local/mysql/lib/mysql/plugin/libaudit_plugin.so(+0x105f7)[0x7f41e8a4d5f7] /usr/local/mysql/lib/mysql/plugin/libaudit_plugin.so(+0x1066e)[0x7f41e8a4d66e] /usr/local/mysql/lib/mysql/plugin/libaudit_plugin.so(+0xb89a)[0x7f41e8a4889a] /usr/local/mysql/lib/mysql/plugin/libaudit_plugin.so(+0xbe38)[0x7f41e8a48e38] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld[0x6a8935] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(_Z18mysql_audit_notifyP3THDjjz+0xa8)[0x6a8b08] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x9b8)[0x700558] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x162)[0x6ce8e2] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(handle_one_connection+0x40)[0x6ce9d0] /usr/local/Percona-Server-5.6.20-rel68.0-656.Linux.x86_64/bin/mysqld(pfs_spawn_thread+0x143)[0x9224a3] /lib64/libpthread.so.0(+0x7df3)[0x7f421c392df3] /lib64/libc.so.6(clone+0x6d)[0x7f421aaad1ad]
Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 96 Status: NOT_KILLED