Bug #90140 | mysql-5.7.21 coredump on ut0ut.cc ine942 | ||
---|---|---|---|
Submitted: | 20 Mar 2018 13:28 | Modified: | 20 Mar 2018 15:33 |
Reporter: | yghmgl yang | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.7.21-debug | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[20 Mar 2018 13:28]
yghmgl yang
[20 Mar 2018 15:33]
MySQL Verification Team
Thank you for the bug report. 2018-03-20T15:28:42.806020Z 0 [Note] /home/miguel/dbs/5.7/bin/mysqld: ready for connections. Version: '5.7.23-debug' socket: '/tmp/mysql57.sock' port: 3357 Source distribution 2018-03-20T15:29:02.057066Z 2 [Note] Access denied for user 'root'@'localhost' (using password: YES) 2018-03-20T15:30:18.917002Z 4 [ERROR] [FATAL] InnoDB: Data field type 0, len 1084484608 2018-03-20 12:30:18 0x7fa704255700 InnoDB: Assertion failure in thread 140355305821952 in file ut0ut.cc line 942 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 15:30:18 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=151 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68260 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fa6a8000dd0 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 = 7fa704254e20 thread_stack 0x40000 /home/miguel/dbs/5.7/bin/mysqld(my_print_stacktrace+0x35)[0x18ab144] /home/miguel/dbs/5.7/bin/mysqld(handle_fatal_signal+0x3e4)[0xefe41b] /lib64/libpthread.so.0(+0x12af0)[0x7fa70d397af0] /lib64/libc.so.6(gsignal+0xcb)[0x7fa70bea266b] /lib64/libc.so.6(abort+0x141)[0x7fa70bea4381] /home/miguel/dbs/5.7/bin/mysqld[0x1b2ca63] /home/miguel/dbs/5.7/bin/mysqld(_ZN2ib5fatalD1Ev+0x62)[0x1b313e6] /home/miguel/dbs/5.7/bin/mysqld(_Z18dfield_check_typedPK8dfield_t+0xff)[0x1bbd20d] /home/miguel/dbs/5.7/bin/mysqld(_Z18dtuple_check_typedPK8dtuple_t+0x4e)[0x1bbd289] /home/miguel/dbs/5.7/bin/mysqld[0x1c7063d] /home/miguel/dbs/5.7/bin/mysqld[0x1c72de5] /home/miguel/dbs/5.7/bin/mysqld(_Z25rtr_page_split_and_insertmP9btr_cur_tPPmPP16mem_block_info_tPK8dtuple_tmP5mtr_t+0x363)[0x1c7524b] /home/miguel/dbs/5.7/bin/mysqld(_Z25btr_root_raise_and_insertmP9btr_cur_tPPmPP16mem_block_info_tPK8dtuple_tmP5mtr_t+0x7b8)[0x1b44eb6] /home/miguel/dbs/5.7/bin/mysqld(_Z26btr_cur_pessimistic_insertmP9btr_cur_tPPmPP16mem_block_info_tP8dtuple_tPPhPP9big_rec_tmP9que_thr_tP5mtr_t+0x3f7)[0x1b5eed5] /home/miguel/dbs/5.7/bin/mysqld[0x1c74468] /home/miguel/dbs/5.7/bin/mysqld(_Z25rtr_page_split_and_insertmP9btr_cur_tPPmPP16mem_block_info_tPK8dtuple_tmP5mtr_t+0xce4)[0x1c75bcc] /home/miguel/dbs/5.7/bin/mysqld(_Z25btr_page_split_and_insertmP9btr_cur_tPPmPP16mem_block_info_tPK8dtuple_tmP5mtr_t+0xa9)[0x1b46aa8] /home/miguel/dbs/5.7/bin/mysqld(_Z26btr_cur_pessimistic_insertmP9btr_cur_tPPmPP16mem_block_info_tP8dtuple_tPPhPP9big_rec_tmP9que_thr_tP5mtr_t+0x434)[0x1b5ef12] /home/miguel/dbs/5.7/bin/mysqld(_Z27row_ins_sec_index_entry_lowmmP12dict_index_tP16mem_block_info_tS2_P8dtuple_tmP9que_thr_tb+0xfcd)[0x1a3141e] /home/miguel/dbs/5.7/bin/mysqld(_Z23row_ins_sec_index_entryP12dict_index_tP8dtuple_tP9que_thr_tb+0x1b9)[0x1a31dd1] /home/miguel/dbs/5.7/bin/mysqld[0x1a31f7e] /home/miguel/dbs/5.7/bin/mysqld[0x1a324bc] /home/miguel/dbs/5.7/bin/mysqld[0x1a32855] /home/miguel/dbs/5.7/bin/mysqld(_Z12row_ins_stepP9que_thr_t+0x2c8)[0x1a32e7e] /home/miguel/dbs/5.7/bin/mysqld[0x1a509d2] /home/miguel/dbs/5.7/bin/mysqld(_Z20row_insert_for_mysqlPKhP14row_prebuilt_t+0x4c)[0x1a50f57] /home/miguel/dbs/5.7/bin/mysqld(_ZN11ha_innobase9write_rowEPh+0x6e0)[0x18fcc82] /home/miguel/dbs/5.7/bin/mysqld(_ZN7handler12ha_write_rowEPh+0x23a)[0xf83e20] /home/miguel/dbs/5.7/bin/mysqld(_Z12write_recordP3THDP5TABLEP9COPY_INFOS4_+0xe71)[0x1796bc5] /home/miguel/dbs/5.7/bin/mysqld(_ZN14Sql_cmd_insert12mysql_insertEP3THDP10TABLE_LIST+0xdea)[0x1793de0] /home/miguel/dbs/5.7/bin/mysqld(_ZN14Sql_cmd_insert7executeEP3THD+0x194)[0x179a5e0] /home/miguel/dbs/5.7/bin/mysqld(_Z21mysql_execute_commandP3THDb+0x2ac5)[0x15797c0] /home/miguel/dbs/5.7/bin/mysqld(_Z11mysql_parseP3THDP12Parser_state+0x602)[0x157f1ff] /home/miguel/dbs/5.7/bin/mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xcb8)[0x157484e] /home/miguel/dbs/5.7/bin/mysqld(_Z10do_commandP3THD+0x4ba)[0x157369e] /home/miguel/dbs/5.7/bin/mysqld(handle_connection+0x1ee)[0x16a21c0] /home/miguel/dbs/5.7/bin/mysqld(pfs_spawn_thread+0x173)[0x1d356ee] /lib64/libpthread.so.0(+0x761b)[0x7fa70d38c61b] /lib64/libc.so.6(clone+0x3f)[0x7fa70bf8298f] Trying to get some variables.
[20 Mar 2018 15:35]
MySQL Verification Team
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.7.23-debug Source distribution Copyright (c) 2000, 2018, 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 5.7 > DROP DATABASE test;CREATE DATABASE test;USE test; Query OK, 3 rows affected (0.70 sec) Query OK, 1 row affected (0.00 sec) Database changed mysql 5.7 > CREATE TABLE t1(fid INT KEY,g POLYGON NOT NULL,a int,spatial index (g)) engine=InnoDB;#NOERROR Query OK, 0 rows affected (0.35 sec) mysql 5.7 > SET GLOBAL innodb_limit_optimistic_insert_debug=2;#NOERROR Query OK, 0 rows affected (0.00 sec) mysql 5.7 > INSERT INTO t1 VALUES(300,ST_PolygonFromText('POLYGON((183670 10,2470 10,20 249380,10 254760,183670 10))'),12),(301,ST_PolygonFromText('POLYGON((10 10,20 10,20 20,10 20,10 10))'),2),(302,ST_PolygonFromText('POLYGON((110 10,320 310,2550 8520,1059 2590,110 10))'),2),(303,ST_PolygonFromText('POLYGON((180 160,55620 5610,240 206560,10 285960,180 160))'),2); ERROR 2013 (HY000): Lost connection to MySQL server during query mysql 5.7 >