Description:
observed crash LOG_SERVICE_INSTANCE_RELEASE_ALL() IN LOG_BUILTINS.CC when enabling logging services concurrently
How to repeat:
./mysqld -uroot --basedir=../ --datadir=./data --initialize-insecure --gdb &
./mysqld -uroot --basedir=../ --datadir=./data --log-error-services='log_filter_internal;log_sink_internal' --gdb &
run below statements from multiple clients for some time:
cat setcom.sql
install component "file://component_log_sink_json";
set @@global.log_error_services='log_sink_json';
set @@global.log_error_services='';
uninstall component "file://component_log_sink_json";
install component "file://component_log_sink_syseventlog";
set @@global.log_error_services='log_sink_syseventlog';
set @@global.log_error_services='';
uninstall component "file://component_log_sink_syseventlog";
install component "file://component_log_sink_test";
set @@global.log_error_services='log_sink_test';
set @@global.log_error_services='';
uninstall component "file://component_log_sink_test";
observe crash after some iterations
call stack:
Core was generated by `./mysqld -uroot --basedir=../ --datadir=./data --log-error-services=log_filter_'.
Program terminated with signal 11, Segmentation fault.
#0 log_service_instance_release_all () at ../../../mysqlcom-pro-8.0.2-dmr/components/mysql_server/log_builtins.cc:1823
1823 ../../../mysqlcom-pro-8.0.2-dmr/components/mysql_server/log_builtins.cc: No such file or directory.
Missing separate debuginfos, use: debuginfo-install glibc-2.17-157.el7.x86_64 libaio-0.3.109-13.el7.x86_64 libgcc-4.8.5-11.el7.x86_64 libstdc++-4.8.5-11.el7.x86_64 nss-softokn-freebl-3.16.2.3-14.4.el7.x86_64 numactl-libs-2.0.9-6.el7_2.x86_64
(gdb) bt
#0 log_service_instance_release_all () at ../../../mysqlcom-pro-8.0.2-dmr/components/mysql_server/log_builtins.cc:1823
#1 log_builtins_error_stack (conf=0x7f8240011160 "log_sink_syseventlog", check_only=check_only@entry=false)
at ../../../mysqlcom-pro-8.0.2-dmr/components/mysql_server/log_builtins.cc:1907
#2 0x0000000000a94c45 in fix_log_error_services (self=<optimized out>, thd=<optimized out>, type=<optimized out>) at ../../mysqlcom-pro-8.0.2-dmr/sql/sys_vars.cc:2141
#3 0x0000000000986132 in sys_var::update (this=0x2a8d300 <Sys_log_error_services>, thd=thd@entry=0x7f8240000b50, var=var@entry=0x7f8240009180)
at ../../mysqlcom-pro-8.0.2-dmr/sql/set_var.cc:225
#4 0x00000000009879f6 in set_var::update (this=0x7f8240009180, thd=0x7f8240000b50) at ../../mysqlcom-pro-8.0.2-dmr/sql/set_var.cc:992
#5 0x00000000009876e9 in sql_set_variables (thd=thd@entry=0x7f8240000b50, var_list=var_list@entry=0x7f8240002fe0, opened=opened@entry=true)
at ../../mysqlcom-pro-8.0.2-dmr/sql/set_var.cc:773
#6 0x00000000009fa8bc in mysql_execute_command (thd=thd@entry=0x7f8240000b50, first_level=first_level@entry=true) at ../../mysqlcom-pro-8.0.2-dmr/sql/sql_parse.cc:3426
#7 0x00000000009fe025 in mysql_parse (thd=thd@entry=0x7f8240000b50, parser_state=parser_state@entry=0x7f82a504d650) at ../../mysqlcom-pro-8.0.2-dmr/sql/sql_parse.cc:5316
#8 0x00000000009fefe5 in dispatch_command (thd=thd@entry=0x7f8240000b50, com_data=com_data@entry=0x7f82a504dd00, command=COM_QUERY)
at ../../mysqlcom-pro-8.0.2-dmr/sql/sql_parse.cc:1600
#9 0x0000000000a00920 in do_command (thd=thd@entry=0x7f8240000b50) at ../../mysqlcom-pro-8.0.2-dmr/sql/sql_parse.cc:1187
#10 0x0000000000c93ce8 in handle_connection (arg=arg@entry=0x69cc140) at ../../mysqlcom-pro-8.0.2-dmr/sql/conn_handler/connection_handler_per_thread.cc:324
#11 0x00000000016fe756 in pfs_spawn_thread (arg=0x6b8ce10) at ../../../mysqlcom-pro-8.0.2-dmr/storage/perfschema/pfs.cc:2393
#12 0x00007f82b090cdc5 in start_thread () from /lib64/libpthread.so.0
#13 0x00007f82af3c973d in clone () from /lib64/libc.so.6
this issue verified with below commit:
cat ../docs/INFO_SRC
commit: 73ba33e6e5d895e0e3aa8d17172e5877f4b0041f
date: 2017-05-29 15:31:17 +0200
build-date: 2017-05-29 17:00:27 +0200
short: 73ba33e
branch: mysql-trunk
MySQL source 8.0.2
it seems like same bug was found and fixed here some time back:Bug#25584494 and appearing again
Description: observed crash LOG_SERVICE_INSTANCE_RELEASE_ALL() IN LOG_BUILTINS.CC when enabling logging services concurrently How to repeat: ./mysqld -uroot --basedir=../ --datadir=./data --initialize-insecure --gdb & ./mysqld -uroot --basedir=../ --datadir=./data --log-error-services='log_filter_internal;log_sink_internal' --gdb & run below statements from multiple clients for some time: cat setcom.sql install component "file://component_log_sink_json"; set @@global.log_error_services='log_sink_json'; set @@global.log_error_services=''; uninstall component "file://component_log_sink_json"; install component "file://component_log_sink_syseventlog"; set @@global.log_error_services='log_sink_syseventlog'; set @@global.log_error_services=''; uninstall component "file://component_log_sink_syseventlog"; install component "file://component_log_sink_test"; set @@global.log_error_services='log_sink_test'; set @@global.log_error_services=''; uninstall component "file://component_log_sink_test"; observe crash after some iterations call stack: Core was generated by `./mysqld -uroot --basedir=../ --datadir=./data --log-error-services=log_filter_'. Program terminated with signal 11, Segmentation fault. #0 log_service_instance_release_all () at ../../../mysqlcom-pro-8.0.2-dmr/components/mysql_server/log_builtins.cc:1823 1823 ../../../mysqlcom-pro-8.0.2-dmr/components/mysql_server/log_builtins.cc: No such file or directory. Missing separate debuginfos, use: debuginfo-install glibc-2.17-157.el7.x86_64 libaio-0.3.109-13.el7.x86_64 libgcc-4.8.5-11.el7.x86_64 libstdc++-4.8.5-11.el7.x86_64 nss-softokn-freebl-3.16.2.3-14.4.el7.x86_64 numactl-libs-2.0.9-6.el7_2.x86_64 (gdb) bt #0 log_service_instance_release_all () at ../../../mysqlcom-pro-8.0.2-dmr/components/mysql_server/log_builtins.cc:1823 #1 log_builtins_error_stack (conf=0x7f8240011160 "log_sink_syseventlog", check_only=check_only@entry=false) at ../../../mysqlcom-pro-8.0.2-dmr/components/mysql_server/log_builtins.cc:1907 #2 0x0000000000a94c45 in fix_log_error_services (self=<optimized out>, thd=<optimized out>, type=<optimized out>) at ../../mysqlcom-pro-8.0.2-dmr/sql/sys_vars.cc:2141 #3 0x0000000000986132 in sys_var::update (this=0x2a8d300 <Sys_log_error_services>, thd=thd@entry=0x7f8240000b50, var=var@entry=0x7f8240009180) at ../../mysqlcom-pro-8.0.2-dmr/sql/set_var.cc:225 #4 0x00000000009879f6 in set_var::update (this=0x7f8240009180, thd=0x7f8240000b50) at ../../mysqlcom-pro-8.0.2-dmr/sql/set_var.cc:992 #5 0x00000000009876e9 in sql_set_variables (thd=thd@entry=0x7f8240000b50, var_list=var_list@entry=0x7f8240002fe0, opened=opened@entry=true) at ../../mysqlcom-pro-8.0.2-dmr/sql/set_var.cc:773 #6 0x00000000009fa8bc in mysql_execute_command (thd=thd@entry=0x7f8240000b50, first_level=first_level@entry=true) at ../../mysqlcom-pro-8.0.2-dmr/sql/sql_parse.cc:3426 #7 0x00000000009fe025 in mysql_parse (thd=thd@entry=0x7f8240000b50, parser_state=parser_state@entry=0x7f82a504d650) at ../../mysqlcom-pro-8.0.2-dmr/sql/sql_parse.cc:5316 #8 0x00000000009fefe5 in dispatch_command (thd=thd@entry=0x7f8240000b50, com_data=com_data@entry=0x7f82a504dd00, command=COM_QUERY) at ../../mysqlcom-pro-8.0.2-dmr/sql/sql_parse.cc:1600 #9 0x0000000000a00920 in do_command (thd=thd@entry=0x7f8240000b50) at ../../mysqlcom-pro-8.0.2-dmr/sql/sql_parse.cc:1187 #10 0x0000000000c93ce8 in handle_connection (arg=arg@entry=0x69cc140) at ../../mysqlcom-pro-8.0.2-dmr/sql/conn_handler/connection_handler_per_thread.cc:324 #11 0x00000000016fe756 in pfs_spawn_thread (arg=0x6b8ce10) at ../../../mysqlcom-pro-8.0.2-dmr/storage/perfschema/pfs.cc:2393 #12 0x00007f82b090cdc5 in start_thread () from /lib64/libpthread.so.0 #13 0x00007f82af3c973d in clone () from /lib64/libc.so.6 this issue verified with below commit: cat ../docs/INFO_SRC commit: 73ba33e6e5d895e0e3aa8d17172e5877f4b0041f date: 2017-05-29 15:31:17 +0200 build-date: 2017-05-29 17:00:27 +0200 short: 73ba33e branch: mysql-trunk MySQL source 8.0.2 it seems like same bug was found and fixed here some time back:Bug#25584494 and appearing again