| Bug #76432 | handle_fatal_signal (sig=11) in __strlen_sse2_pminub on CHANGE MASTER | ||
|---|---|---|---|
| Submitted: | 22 Mar 2015 22:50 | Modified: | 28 Jun 2015 23:42 |
| Reporter: | Roel Van de Paar | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S1 (Critical) |
| Version: | 5.7.6, 5.7.8, 8.0.0 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[22 Mar 2015 22:50]
Roel Van de Paar
[23 Mar 2015 8:12]
MySQL Verification Team
Hello Roel, Thank you for the report and test case. Confirmed that 5.7.6, 5.7.8 and 5.8.0 release builds are affected. Thanks, Umesh
[23 Mar 2015 8:13]
MySQL Verification Team
// 5.7.6, 5.7.8, 5.8.0 release builds affected
bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/76432 -v
bin/mysqld --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/76432 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.7.6/76432/log.err 2>&1 &
- build
commit: e1298eb6a8e2247361533811930a07fde7aff618
date: 2015-02-26 15:29:31 +0100
build-date: 2015-02-26 15:35:58 +0100
short: e1298eb
branch: mysql-5.7.6-m16-release
MySQL source 5.7.6
(gdb) bt
#0 0x00007f285b9bb771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006f64d4 in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/signal_handler.cc:220
#2 <signal handler called>
#3 0x00007f285a6ec701 in __strlen_sse2_pminub () from /lib64/libc.so.6
#4 0x0000000000cdf394 in Rpl_info_table::Rpl_info_table (this=0x7f280c00fda0, nparam=<optimized out>, param_schema=0x0, param_table=0x0)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/rpl_info_table.cc:33
#5 0x0000000000cd21bf in Rpl_info_factory::init_repositories (table_data=..., file_data=..., rep_option=<optimized out>, instance=<optimized out>, handler_src=0x7f28501e3588,
handler_dest=0x7f28501e3580, msg=<optimized out>) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/rpl_info_factory.cc:869
#6 0x0000000000cd2f0d in Rpl_info_factory::create_mi (mi_option=1, channel=<optimized out>, to_decide_repo=false)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/rpl_info_factory.cc:84
#7 0x0000000000cd3048 in Rpl_info_factory::create_slave_per_channel (mi_option=<optimized out>, rli_option=1, channel=0x7f280c005b30 "0th_channel", to_decide_repo=false,
pmsr_map=0x1aff360 <msr_map>, channel_type=SLAVE_REPLICATION_CHANNEL) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/rpl_info_factory.cc:1237
#8 0x0000000000cb4846 in add_new_channel (mi=0x7f28501e36a8, channel=0x7f280c005b30 "0th_channel", channel_type=SLAVE_REPLICATION_CHANNEL)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/rpl_slave.cc:10716
#9 0x0000000000cc24b7 in change_master_cmd (thd=0x7f280c000b40) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/rpl_slave.cc:10778
#10 0x0000000000af0e98 in mysql_execute_command (thd=0x7f280c000b40) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:2605
#11 0x0000000000af5248 in mysql_parse (thd=0x7f280c000b40, parser_state=<optimized out>) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:5129
#12 0x0000000000af6788 in dispatch_command (command=COM_QUERY, thd=0x7f280c000b40, packet=0x7f280c009c21 "CHANGE MASTER TO MASTER_LOG_POS=0 FOR CHANNEL \"0th_channel\"", packet_length=59)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:1249
#13 0x0000000000bb94a4 in handle_connection (arg=<optimized out>) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
#14 0x0000000000f79aba in pfs_spawn_thread (arg=0x345abb0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/perfschema/pfs.cc:2147
#15 0x00007f285b9b6df3 in start_thread () from /lib64/libpthread.so.0
#16 0x00007f285a68247d in clone () from /lib64/libc.so.6
(gdb)
[23 Mar 2015 8:13]
MySQL Verification Team
// 5.7.8
bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.8 --datadir=/export/umesh/mysql-5.7.8/76434 -v
bin/mysqld --basedir=/export/umesh/mysql-5.7.8 --datadir=/export/umesh/mysql-5.7.8/76434 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.7.8/76434/log.err 2>&1 &
- build
commit: 91153f3385c4917a215aa4c7818b3f6265608286
date: 2015-03-20 14:48:27 +0100
build-date: 2015-03-20 18:03:24 +0100
short: 91153f3
branch: mysql-5.7
MySQL source 5.7.8
(gdb) bt
#0 0x00007f4a0e8de771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000007817d5 in handle_fatal_signal (sig=11) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/signal_handler.cc:220
#2 <signal handler called>
#3 0x00007f4a0d60f701 in __strlen_sse2_pminub () from /lib64/libc.so.6
#4 0x0000000000e12789 in Rpl_info_table::Rpl_info_table (this=0x7f49a80226c0, nparam=<optimized out>, param_schema=0x0, param_table=0x0)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/rpl_info_table.cc:33
#5 0x0000000000e050a2 in Rpl_info_factory::init_repositories (table_data=..., file_data=..., rep_option=rep_option@entry=1, instance=instance@entry=1,
handler_src=handler_src@entry=0x7f49f6cec700, handler_dest=handler_dest@entry=0x7f49f6cec710, msg=msg@entry=0x7f49f6cec720)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/rpl_info_factory.cc:871
#6 0x0000000000e052af in Rpl_info_factory::create_mi (mi_option=1, channel=channel@entry=0x7f49a8005c18 "0th_channel", to_decide_repo=to_decide_repo@entry=false)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/rpl_info_factory.cc:84
#7 0x0000000000e05bfd in Rpl_info_factory::create_slave_per_channel (mi_option=<optimized out>, rli_option=1, channel=channel@entry=0x7f49a8005c18 "0th_channel",
to_decide_repo=to_decide_repo@entry=false, pmsr_map=pmsr_map@entry=0x1e0c780 <msr_map>, channel_type=channel_type@entry=SLAVE_REPLICATION_CHANNEL)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/rpl_info_factory.cc:1237
#8 0x0000000000df88b3 in add_new_channel (mi=mi@entry=0x7f49f6cec800, channel=0x7f49a8005c18 "0th_channel", channel_type=channel_type@entry=SLAVE_REPLICATION_CHANNEL)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/rpl_slave.cc:10772
#9 0x0000000000dfa0a7 in change_master_cmd (thd=thd@entry=0x7f49a8000b40) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/rpl_slave.cc:10830
#10 0x0000000000c2b280 in mysql_execute_command (thd=thd@entry=0x7f49a8000b40) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:2623
#11 0x0000000000c2fdf8 in mysql_parse (thd=thd@entry=0x7f49a8000b40, parser_state=parser_state@entry=0x7f49f6ced7b0)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:5201
#12 0x0000000000c310f7 in dispatch_command (thd=thd@entry=0x7f49a8000b40, com_data=com_data@entry=0x7f49f6cede00, command=COM_QUERY)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:1280
#13 0x0000000000c3202f in do_command (thd=thd@entry=0x7f49a8000b40) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:851
#14 0x0000000000ce39b0 in handle_connection (arg=arg@entry=0x35f18b0)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/conn_handler/connection_handler_per_thread.cc:299
#15 0x00000000011502b3 in pfs_spawn_thread (arg=0x371bdb0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/perfschema/pfs.cc:2147
#16 0x00007f4a0e8d9df3 in start_thread () from /lib64/libpthread.so.0
#17 0x00007f4a0d5a547d in clone () from /lib64/libc.so.6
(gdb)
[23 Mar 2015 8:14]
MySQL Verification Team
// 5.8.0
bin/mysql_install_db --basedir=/export/umesh/mysql-5.8.0 --datadir=/export/umesh/mysql-5.8.0/76434 -v
bin/mysqld --basedir=/export/umesh/mysql-5.8.0 --datadir=/export/umesh/mysql-5.8.0/76434 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.8.0/76434/log.err 2>&1 &
- build
commit: b48798db34fbcaf5dbb5c8ae7ef738afeb60eccc
date: 2015-03-20 14:52:33 +0100
build-date: 2015-03-20 17:03:10 +0100
short: b48798d
branch: mysql-trunk
MySQL source 5.8.0
(gdb) bt
#0 0x00007fe2cc865771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000776eb5 in handle_fatal_signal (sig=11) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/signal_handler.cc:221
#2 <signal handler called>
#3 0x00007fe2cb596701 in __strlen_sse2_pminub () from /lib64/libc.so.6
#4 0x0000000000e017b9 in Rpl_info_table::Rpl_info_table (this=0x7fe270010180, nparam=<optimized out>, param_schema=0x0, param_table=0x0)
at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/rpl_info_table.cc:34
#5 0x0000000000df3b32 in Rpl_info_factory::init_repositories (table_data=..., file_data=..., rep_option=rep_option@entry=1, instance=instance@entry=1,
handler_src=handler_src@entry=0x7fe2c108d710, handler_dest=handler_dest@entry=0x7fe2c108d720, msg=msg@entry=0x7fe2c108d730)
at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/rpl_info_factory.cc:872
#6 0x0000000000df3d3f in Rpl_info_factory::create_mi (mi_option=1, channel=channel@entry=0x7fe270021148 "0th_channel", to_decide_repo=to_decide_repo@entry=false)
at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/rpl_info_factory.cc:85
#7 0x0000000000df468d in Rpl_info_factory::create_slave_per_channel (mi_option=<optimized out>, rli_option=1, channel=channel@entry=0x7fe270021148 "0th_channel",
to_decide_repo=to_decide_repo@entry=false, pmsr_map=pmsr_map@entry=0x1df3d40 <msr_map>, channel_type=channel_type@entry=SLAVE_REPLICATION_CHANNEL)
at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/rpl_info_factory.cc:1238
#8 0x0000000000de7283 in add_new_channel (mi=mi@entry=0x7fe2c108d810, channel=0x7fe270021148 "0th_channel", channel_type=channel_type@entry=SLAVE_REPLICATION_CHANNEL)
at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/rpl_slave.cc:10779
#9 0x0000000000de89b7 in change_master_cmd (thd=thd@entry=0x7fe270012310) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/rpl_slave.cc:10837
#10 0x0000000000c18b30 in mysql_execute_command (thd=thd@entry=0x7fe270012310) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:2592
#11 0x0000000000c1d418 in mysql_parse (thd=thd@entry=0x7fe270012310, parser_state=parser_state@entry=0x7fe2c108e7b0)
at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:5158
#12 0x0000000000c1e4d5 in dispatch_command (thd=thd@entry=0x7fe270012310, com_data=com_data@entry=0x7fe2c108ee00, command=COM_QUERY)
at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:1245
#13 0x0000000000c1f51f in do_command (thd=thd@entry=0x7fe270012310) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:814
#14 0x0000000000cd0e50 in handle_connection (arg=arg@entry=0x2e86110)
at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/conn_handler/connection_handler_per_thread.cc:300
#15 0x00000000010f2123 in pfs_spawn_thread (arg=0x2fd0440) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/perfschema/pfs.cc:2147
#16 0x00007fe2cc860df3 in start_thread () from /lib64/libpthread.so.0
#17 0x00007fe2cb52c47d in clone () from /lib64/libc.so.6
(gdb)
[23 Mar 2015 8:15]
MySQL Verification Team
// 5.6.25 not affected (FOR CHANNEL.. introduced in 5.7 onward)
[10 Apr 2015 6:50]
MySQL Verification Team
// João Gramacho requested to reverify against daily builds // 5.7.8 -- start up command bin/mysql_install_db --insecure --basedir=/export/umesh/server/binaries/mysql-5.7.8 --datadir=/export/umesh/server/binaries/mysql-5.7.8/76432 -v bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.7.8 --datadir=/export/umesh/server/binaries/mysql-5.7.8/76432 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.7.8/76432/log.err 2>&1 & -- build used for tests commit: ab488a87c1b0ca95f505b625060a1f6abba62935 date: 2015-04-09 13:50:57 +0800 build-date: 2015-04-09 07:56:43 +0200 short: ab488a8 branch: mysql-5.7 MySQL source 5.7.8 // connect and execute test case to see the issue [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8: bin/mysql -uroot -p -S/tmp/mysql_ushastry.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.8-rc-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> mysql> DROP DATABASE test;CREATE DATABASE test;USE test; ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist Query OK, 1 row affected (0.00 sec) Database changed mysql> SET GLOBAL master_info_repository='TABLE'; Query OK, 0 rows affected (0.00 sec) mysql> SET @@global.relay_log_info_repository="TABLE"; Query OK, 0 rows affected (0.00 sec) mysql> CHANGE MASTER TO MASTER_LOG_POS=0 FOR CHANNEL "0th_channel"; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> mysql> \q Bye [1]+ Segmentation fault (core dumped) bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.7.8 --datadir=/export/umesh/server/binaries/mysql-5.7.8/76432 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.7.8/76432/log.err 2>&1 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8: gdb bin/mysqld 76432/core.22997 GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-51.el7 Copyright (C) 2013 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-redhat-linux-gnu". For bug reporting instructions, please see: <http://www.gnu.org/software/gdb/bugs/>... Reading symbols from /export/umesh/server/binaries/mysql-5.7.8/bin/mysqld...done. Illegal process-id: 76432/core.22997. [New LWP 23063] [New LWP 23022] [New LWP 22997] [New LWP 23026] [New LWP 23013] [New LWP 23018] [New LWP 23015] [New LWP 23020] [New LWP 23017] [New LWP 23011] [New LWP 23014] [New LWP 23032] [New LWP 23009] [New LWP 23031] [New LWP 23036] [New LWP 23024] [New LWP 23034] [New LWP 23023] [New LWP 23008] [New LWP 23010] [New LWP 23048] [New LWP 23012] [New LWP 23021] [New LWP 23016] [New LWP 23035] [New LWP 23030] [New LWP 23038] [New LWP 23019] [New LWP 23047] [New LWP 23052] [New LWP 23043] [New LWP 22998] [New LWP 23053] [New LWP 23039] [New LWP 23037] [New LWP 23041] [New LWP 23042] [New LWP 23033] [New LWP 23007] [New LWP 23006] [New LWP 23029] [New LWP 23054] [New LWP 23049] [New LWP 23040] [New LWP 23050] [New LWP 23027] [New LWP 23028] [New LWP 23057] [New LWP 23056] [New LWP 23055] [New LWP 23051] [New LWP 23025] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.7.8 --datadir=/expor'. Program terminated with signal 11, Segmentation fault. #0 0x00007f29df1ea771 in pthread_kill () from /lib64/libpthread.so.0 Missing separate debuginfos, use: debuginfo-install glibc-2.17-55.0.4.el7_0.1.x86_64 libaio-0.3.109-12.el7.x86_64 libgcc-4.8.2-16.2.el7_0.x86_64 libstdc++-4.8.2-16.2.el7_0.x86_64 nss-softokn-freebl-3.16.2-1.el7_0.x86_64 (gdb) bt #0 0x00007f29df1ea771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000781714 in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-14944609-1428564108.0/mysqlcom-pro-5.7.8-rc/sql/signal_handler.cc:220 #2 <signal handler called> #3 0x00007f29ddf1b701 in __strlen_sse2_pminub () from /lib64/libc.so.6 #4 0x0000000000e97444 in Rpl_info_table::Rpl_info_table (this=0x7ef118023f20, nparam=<optimized out>, param_schema=0x0, param_table=0x0) at /export/home/pb2/build/sb_0-14944609-1428564108.0/mysqlcom-pro-5.7.8-rc/sql/rpl_info_table.cc:33 #5 0x0000000000e8a35f in Rpl_info_factory::init_repositories (table_data=..., file_data=..., rep_option=<optimized out>, instance=<optimized out>, handler_src=0x7ef1440a5508, handler_dest=0x7ef1440a5500, msg=<optimized out>) at /export/home/pb2/build/sb_0-14944609-1428564108.0/mysqlcom-pro-5.7.8-rc/sql/rpl_info_factory.cc:875 #6 0x0000000000e8b0ed in Rpl_info_factory::create_mi (mi_option=1, channel=<optimized out>, to_decide_repo=false) at /export/home/pb2/build/sb_0-14944609-1428564108.0/mysqlcom-pro-5.7.8-rc/sql/rpl_info_factory.cc:84 #7 0x0000000000e8b228 in Rpl_info_factory::create_slave_per_channel (mi_option=<optimized out>, rli_option=1, channel=0x7ef118005c38 "0th_channel", to_decide_repo=false, pmsr_map=0x1e63f60 <msr_map>, channel_type=SLAVE_REPLICATION_CHANNEL) at /export/home/pb2/build/sb_0-14944609-1428564108.0/mysqlcom-pro-5.7.8-rc/sql/rpl_info_factory.cc:1243 #8 0x0000000000e6cc36 in add_new_channel (mi=0x7ef1440a5628, channel=0x7ef118005c38 "0th_channel", channel_type=SLAVE_REPLICATION_CHANNEL) at /export/home/pb2/build/sb_0-14944609-1428564108.0/mysqlcom-pro-5.7.8-rc/sql/rpl_slave.cc:10782 #9 0x0000000000e80407 in change_master_cmd (thd=0x7ef118000b40) at /export/home/pb2/build/sb_0-14944609-1428564108.0/mysqlcom-pro-5.7.8-rc/sql/rpl_slave.cc:10844 #10 0x0000000000ca0d78 in mysql_execute_command (thd=0x7ef118000b40) at /export/home/pb2/build/sb_0-14944609-1428564108.0/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:2623 #11 0x0000000000ca5320 in mysql_parse (thd=0x7ef118000b40, parser_state=<optimized out>) at /export/home/pb2/build/sb_0-14944609-1428564108.0/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:5206 #12 0x0000000000ca6650 in dispatch_command (thd=0x7ef118000b40, com_data=0x7ef1440a6de0, command=COM_QUERY) at /export/home/pb2/build/sb_0-14944609-1428564108.0/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:1280 #13 0x0000000000ca7814 in do_command (thd=0x7ef118000b40) at /export/home/pb2/build/sb_0-14944609-1428564108.0/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:851 #14 0x0000000000d6b21c in handle_connection (arg=<optimized out>) at /export/home/pb2/build/sb_0-14944609-1428564108.0/mysqlcom-pro-5.7.8-rc/sql/conn_handler/connection_handler_per_thread.cc:299 #15 0x000000000113c07a in pfs_spawn_thread (arg=0x197f65a50) at /export/home/pb2/build/sb_0-14944609-1428564108.0/mysqlcom-pro-5.7.8-rc/storage/perfschema/pfs.cc:2147 #16 0x00007f29df1e5df3 in start_thread () from /lib64/libpthread.so.0 #17 0x00007f29ddeb147d in clone () from /lib64/libc.so.6 (gdb)
[10 Apr 2015 6:52]
MySQL Verification Team
// 5.7.6 -- start up command bin/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-5.7.6 --datadir=/export/umesh/server/binaries/mysql-5.7.6/76432_re -v bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.7.6 --datadir=/export/umesh/server/binaries/mysql-5.7.6/76432_re --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.7.6/76432_re/log.err 2>&1 & commit: e1298eb6a8e2247361533811930a07fde7aff618 date: 2015-02-26 15:29:31 +0100 build-date: 2015-02-26 15:35:58 +0100 short: e1298eb branch: mysql-5.7.6-m16-release MySQL source 5.7.6 // connect and execute test case to trigge rthe issue [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.6: bin/mysql -uroot -p -S/tmp/mysql_ushastry.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.6-m16 Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> set password=''; Query OK, 0 rows affected (0.00 sec) mysql> DROP DATABASE test;CREATE DATABASE test;USE test; ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist Query OK, 1 row affected (0.00 sec) Database changed mysql> SET GLOBAL master_info_repository='TABLE'; Query OK, 0 rows affected (0.00 sec) mysql> SET @@global.relay_log_info_repository="TABLE"; Query OK, 0 rows affected (0.00 sec) mysql> CHANGE MASTER TO MASTER_LOG_POS=0 FOR CHANNEL "0th_channel"; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> \q Bye [1]+ Segmentation fault (core dumped) bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.7.6 --datadir=/export/umesh/server/binaries/mysql-5.7.6/76432_re --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.7.6/76432_re/log.err 2>&1 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.6: gdb bin/mysqld 76432_re/core.22532 GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-51.el7 Copyright (C) 2013 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-redhat-linux-gnu". For bug reporting instructions, please see: <http://www.gnu.org/software/gdb/bugs/>... Reading symbols from /export/umesh/server/binaries/mysql-5.7.6/bin/mysqld...done. Illegal process-id: 76432_re/core.22532. [New LWP 22609] [New LWP 22556] [New LWP 22570] [New LWP 22558] [New LWP 22532] [New LWP 22557] [New LWP 22572] [New LWP 22568] [New LWP 22553] [New LWP 22577] [New LWP 22578] [New LWP 22565] [New LWP 22580] [New LWP 22584] [New LWP 22581] [New LWP 22576] [New LWP 22571] [New LWP 22554] [New LWP 22569] [New LWP 22582] [New LWP 22575] [New LWP 22567] [New LWP 22561] [New LWP 22564] [New LWP 22598] [New LWP 22599] [New LWP 22586] [New LWP 22602] [New LWP 22573] [New LWP 22535] [New LWP 22583] [New LWP 22585] [New LWP 22555] [New LWP 22603] [New LWP 22562] [New LWP 22597] [New LWP 22601] [New LWP 22604] [New LWP 22560] [New LWP 22579] [New LWP 22600] [New LWP 22559] [New LWP 22566] [New LWP 22587] [New LWP 22563] [New LWP 22606] [New LWP 22596] [New LWP 22605] [New LWP 22574] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.7.6 --datadir=/expor'. Program terminated with signal 11, Segmentation fault. #0 0x00007fa9a0c92771 in pthread_kill () from /lib64/libpthread.so.0 Missing separate debuginfos, use: debuginfo-install glibc-2.17-55.0.4.el7_0.1.x86_64 libaio-0.3.109-12.el7.x86_64 libgcc-4.8.2-16.2.el7_0.x86_64 libstdc++-4.8.2-16.2.el7_0.x86_64 nss-softokn-freebl-3.16.2-1.el7_0.x86_64 (gdb) bt #0 0x00007fa9a0c92771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000006f64d4 in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/signal_handler.cc:220 #2 <signal handler called> #3 0x00007fa99f9c3701 in __strlen_sse2_pminub () from /lib64/libc.so.6 #4 0x0000000000cdf394 in Rpl_info_table::Rpl_info_table (this=0x7f711c042df0, nparam=<optimized out>, param_schema=0x0, param_table=0x0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/rpl_info_table.cc:33 #5 0x0000000000cd21bf in Rpl_info_factory::init_repositories (table_data=..., file_data=..., rep_option=<optimized out>, instance=<optimized out>, handler_src=0x7fa99404a588, handler_dest=0x7fa99404a580, msg=<optimized out>) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/rpl_info_factory.cc:869 #6 0x0000000000cd2f0d in Rpl_info_factory::create_mi (mi_option=1, channel=<optimized out>, to_decide_repo=false) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/rpl_info_factory.cc:84 #7 0x0000000000cd3048 in Rpl_info_factory::create_slave_per_channel (mi_option=<optimized out>, rli_option=1, channel=0x7f711c005b30 "0th_channel", to_decide_repo=false, pmsr_map=0x1aff360 <msr_map>, channel_type=SLAVE_REPLICATION_CHANNEL) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/rpl_info_factory.cc:1237 #8 0x0000000000cb4846 in add_new_channel (mi=0x7fa99404a6a8, channel=0x7f711c005b30 "0th_channel", channel_type=SLAVE_REPLICATION_CHANNEL) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/rpl_slave.cc:10716 #9 0x0000000000cc24b7 in change_master_cmd (thd=0x7f711c000b40) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/rpl_slave.cc:10778 #10 0x0000000000af0e98 in mysql_execute_command (thd=0x7f711c000b40) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:2605 #11 0x0000000000af5248 in mysql_parse (thd=0x7f711c000b40, parser_state=<optimized out>) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:5129 #12 0x0000000000af6788 in dispatch_command (command=COM_QUERY, thd=0x7f711c000b40, packet=0x7f711c009c21 "CHANGE MASTER TO MASTER_LOG_POS=0 FOR CHANNEL \"0th_channel\"", packet_length=59) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:1249 #13 0x0000000000bb94a4 in handle_connection (arg=<optimized out>) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298 #14 0x0000000000f79aba in pfs_spawn_thread (arg=0x197caed70) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/perfschema/pfs.cc:2147 #15 0x00007fa9a0c8ddf3 in start_thread () from /lib64/libpthread.so.0 #16 0x00007fa99f95947d in clone () from /lib64/libc.so.6 (gdb)
[10 Apr 2015 6:58]
MySQL Verification Team
// 5.8.0 -- start up command bin/mysql_install_db --insecure --basedir=/export/umesh/server/binaries/mysql-5.8.0 --datadir=/export/umesh/server/binaries/mysql-5.8.0/76432 -v bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.8.0 --datadir=/export/umesh/server/binaries/mysql-5.8.0/76432 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.8.0/76432/log.err 2>&1 & -- build used commit: 91482f6083191ec428ef1bfdb931f8b31fb2b957 date: 2015-04-09 13:52:56 +0800 build-date: 2015-04-09 08:01:42 +0200 short: 91482f6 branch: mysql-trunk MySQL source 5.8.0 -- Connect and execute test case to trigger the issue [umshastr@hod03]/export/umesh/server/binaries/mysql-5.8.0: bin/mysql -uroot -p -S/tmp/mysql_ushastry.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.8.0-m17-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> DROP DATABASE test;CREATE DATABASE test;USE test; ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist Query OK, 1 row affected (0.00 sec) Database changed mysql> SET GLOBAL master_info_repository='TABLE'; Query OK, 0 rows affected (0.00 sec) mysql> SET @@global.relay_log_info_repository="TABLE"; Query OK, 0 rows affected (0.00 sec) mysql> CHANGE MASTER TO MASTER_LOG_POS=0 FOR CHANNEL "0th_channel"; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> mysql> \q Bye [1]+ Segmentation fault (core dumped) bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.8.0 --datadir=/export/umesh/server/binaries/mysql-5.8.0/76432 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.8.0/76432/log.err 2>&1 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.8.0: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.8.0: gdb bin/mysqld 76432/core.24092 GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-51.el7 Copyright (C) 2013 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-redhat-linux-gnu". For bug reporting instructions, please see: <http://www.gnu.org/software/gdb/bugs/>... Reading symbols from /export/umesh/server/binaries/mysql-5.8.0/bin/mysqld...done. Illegal process-id: 76432/core.24092. [New LWP 24121] [New LWP 24095] [New LWP 24092] [New LWP 24096] [New LWP 24114] [New LWP 24110] [New LWP 24098] [New LWP 24107] [New LWP 24097] [New LWP 24103] [New LWP 24102] [New LWP 24119] [New LWP 24118] [New LWP 24108] [New LWP 24101] [New LWP 24115] [New LWP 24112] [New LWP 24104] [New LWP 24099] [New LWP 24100] [New LWP 24106] [New LWP 24094] [New LWP 24109] [New LWP 24093] [New LWP 24117] [New LWP 24113] [New LWP 24111] [New LWP 24116] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.8.0 --datadir=/expor'. Program terminated with signal 11, Segmentation fault. #0 0x00007fbeee751771 in pthread_kill () from /lib64/libpthread.so.0 Missing separate debuginfos, use: debuginfo-install glibc-2.17-55.0.4.el7_0.1.x86_64 libaio-0.3.109-12.el7.x86_64 libgcc-4.8.2-16.2.el7_0.x86_64 libstdc++-4.8.2-16.2.el7_0.x86_64 nss-softokn-freebl-3.16.2-1.el7_0.x86_64 (gdb) bt #0 0x00007fbeee751771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000775d04 in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-14944746-1428561397.91/mysqlcom-pro-5.8.0-m17/sql/signal_handler.cc:221 #2 <signal handler called> #3 0x00007fbeed482701 in __strlen_sse2_pminub () from /lib64/libc.so.6 #4 0x0000000000e83f24 in Rpl_info_table::Rpl_info_table (this=0x7fbe740232a0, nparam=<optimized out>, param_schema=0x0, param_table=0x0) at /export/home/pb2/build/sb_0-14944746-1428561397.91/mysqlcom-pro-5.8.0-m17/sql/rpl_info_table.cc:34 #5 0x0000000000e7685f in Rpl_info_factory::init_repositories (table_data=..., file_data=..., rep_option=<optimized out>, instance=<optimized out>, handler_src=0x7fbec155c588, handler_dest=0x7fbec155c580, msg=<optimized out>) at /export/home/pb2/build/sb_0-14944746-1428561397.91/mysqlcom-pro-5.8.0-m17/sql/rpl_info_factory.cc:876 #6 0x0000000000e775ed in Rpl_info_factory::create_mi (mi_option=1, channel=<optimized out>, to_decide_repo=false) at /export/home/pb2/build/sb_0-14944746-1428561397.91/mysqlcom-pro-5.8.0-m17/sql/rpl_info_factory.cc:85 #7 0x0000000000e77728 in Rpl_info_factory::create_slave_per_channel (mi_option=<optimized out>, rli_option=1, channel=0x7fbe74005c38 "0th_channel", to_decide_repo=false, pmsr_map=0x1e48b60 <msr_map>, channel_type=SLAVE_REPLICATION_CHANNEL) at /export/home/pb2/build/sb_0-14944746-1428561397.91/mysqlcom-pro-5.8.0-m17/sql/rpl_info_factory.cc:1244 #8 0x0000000000e599c6 in add_new_channel (mi=0x7fbec155c678, channel=0x7fbe74005c38 "0th_channel", channel_type=SLAVE_REPLICATION_CHANNEL) at /export/home/pb2/build/sb_0-14944746-1428561397.91/mysqlcom-pro-5.8.0-m17/sql/rpl_slave.cc:10790 #9 0x0000000000e6c6ae in change_master_cmd (thd=0x7fbe74000b40) at /export/home/pb2/build/sb_0-14944746-1428561397.91/mysqlcom-pro-5.8.0-m17/sql/rpl_slave.cc:10852 #10 0x0000000000c8dbf8 in mysql_execute_command (thd=0x7fbe74000b40) at /export/home/pb2/build/sb_0-14944746-1428561397.91/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:2594 #11 0x0000000000c91fc0 in mysql_parse (thd=0x7fbe74000b40, parser_state=<optimized out>) at /export/home/pb2/build/sb_0-14944746-1428561397.91/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:5165 #12 0x0000000000c92dbc in dispatch_command (thd=0x7fbe74000b40, com_data=0x7fbec155dde0, command=COM_QUERY) at /export/home/pb2/build/sb_0-14944746-1428561397.91/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:1247 #13 0x0000000000c93c54 in do_command (thd=0x7fbe74000b40) at /export/home/pb2/build/sb_0-14944746-1428561397.91/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:816 #14 0x0000000000d57474 in handle_connection (arg=<optimized out>) at /export/home/pb2/build/sb_0-14944746-1428561397.91/mysqlcom-pro-5.8.0-m17/sql/conn_handler/connection_handler_per_thread.cc:300 #15 0x0000000000ef7d2a in pfs_spawn_thread (arg=0x28c5020) at /export/home/pb2/build/sb_0-14944746-1428561397.91/mysqlcom-pro-5.8.0-m17/storage/perfschema/pfs.cc:2147 #16 0x00007fbeee74cdf3 in start_thread () from /lib64/libpthread.so.0 #17 0x00007fbeed41847d in clone () from /lib64/libc.so.6 (gdb)
[22 May 2015 17:36]
David Moss
The changelog for this bug has been updated based on information provided for another bug - 20712720. The following is now noted in the 5.7.8 changelog to cover both of these bugs: Additional replication channels could not be added if the server had been started with server_id=0, the default. The fix ensures that a replication slave checks the server_id is greater than 0 when CHANGE MASTER TO has been issued before continuing with the initialization of a channel.
[28 Jun 2015 23:42]
Roel Van de Paar
So this fix was not in 5.7.7 RC? Bug #77524
[18 Jun 2016 21:25]
Omer Barnir
Posted by developer: Reported version value updated to reflect release name change from 5.8 to 8.0
