This is happening on
2017-10-24T13:03:59.288946-05:00 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.19-17 started;
The top of the stack trace is identical, and the query is an INSERT with a TEXT column involved, but stored procedures are not involved (am waiting for input regarding how the query gets executed).
/bin/mysql/percona5.7.19/bin/mysqld(my_print_stacktrace+0x2c)[0xed36bc] /bin/mysql/percona5.7.19/bin/mysqld(handle_fatal_signal+0x461)[0x7a26e1] /lib64/libpthread.so.0[0x3798c0f7e0] /lib64/libc.so.6(memcpy+0xd2)[0x37980898d2] /bin/mysql/percona5.7.19/bin/mysqld(Field_blob::copy_blob_value(st_mem_root*)+0x75)[0x7e62e5] /bin/mysql/percona5.7.19/bin/mysqld(mysql_prepare_blob_values(THD*, List<Item>&, st_mem_root*)+0x2b8)[0xe1c748] /bin/mysql/percona5.7.19/bin/mysqld(write_record(THD*, TABLE*, COPY_INFO*, COPY_INFO*)+0x9c0)[0xe1d450] /bin/mysql/percona5.7.19/bin/mysqld(Sql_cmd_insert::mysql_insert(THD*, TABLE_LIST*)+0x825)[0xe1dec5] /bin/mysql/percona5.7.19/bin/mysqld(Sql_cmd_insert::execute(THD*)+0xc2)[0xe1e702] /bin/mysql/percona5.7.19/bin/mysqld(mysql_execute_command(THD*, bool)+0x18d7)[0xcad217] /bin/mysql/percona5.7.19/bin/mysqld(mysql_parse(THD*, Parser_state*)+0x5d5)[0xcb3385] /bin/mysql/percona5.7.19/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0xaba)[0xcb3eca] /bin/mysql/percona5.7.19/bin/mysqld(do_command(THD*)+0x1b7)[0xcb5917] /bin/mysql/percona5.7.19/bin/mysqld(handle_connection+0x2a0)[0xd79a60] /bin/mysql/percona5.7.19/bin/mysqld(pfs_spawn_thread+0x1b4)[0x123cf24] /lib64/libpthread.so.0[0x3798c07aa1] /lib64/libc.so.6(clone+0x6d)[0x37980e8aad]
Table looks like CREATE TABLE `t` ( `id` int(11) NOT NULL AUTO_INCREMENT, `f_id` int(11) NOT NULL, `l` varchar(512) NOT NULL, `t` varchar(128) NOT NULL, `a` varchar(128) DEFAULT NULL, `t2` text, `s` text, `c` datetime DEFAULT '0000-00-00 00:00:00', `m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `rss_id_unique` (`l`,`f_id`) USING BTREE, KEY `Index_3` (`c`), KEY `Index_4` (`f_id`) ) ENGINE=InnoDB AUTO_INCREMENT=663473641 DEFAULT CHARSET=latin1
This is happening on
2017-10- 24T13:03: 59.288946- 05:00 0 [Note] InnoDB: Percona XtraDB (http:// www.percona. com) 5.7.19-17 started;
The top of the stack trace is identical, and the query is an INSERT with a TEXT column involved, but stored procedures are not involved (am waiting for input regarding how the query gets executed).
/bin/mysql/ percona5. 7.19/bin/ mysqld( my_print_ stacktrace+ 0x2c)[0xed36bc] percona5. 7.19/bin/ mysqld( handle_ fatal_signal+ 0x461)[ 0x7a26e1] libpthread. so.0[0x3798c0f7 e0] libc.so. 6(memcpy+ 0xd2)[0x3798089 8d2] percona5. 7.19/bin/ mysqld( Field_blob: :copy_blob_ value(st_ mem_root* )+0x75) [0x7e62e5] percona5. 7.19/bin/ mysqld( mysql_prepare_ blob_values( THD*, List<Item>&, st_mem_ root*)+ 0x2b8)[ 0xe1c748] percona5. 7.19/bin/ mysqld( write_record( THD*, TABLE*, COPY_INFO*, COPY_INFO* )+0x9c0) [0xe1d450] percona5. 7.19/bin/ mysqld( Sql_cmd_ insert: :mysql_ insert( THD*, TABLE_LIST* )+0x825) [0xe1dec5] percona5. 7.19/bin/ mysqld( Sql_cmd_ insert: :execute( THD*)+0xc2) [0xe1e702] percona5. 7.19/bin/ mysqld( mysql_execute_ command( THD*, bool)+0x18d7) [0xcad217] percona5. 7.19/bin/ mysqld( mysql_parse( THD*, Parser_ state*) +0x5d5) [0xcb3385] percona5. 7.19/bin/ mysqld( dispatch_ command( THD*, COM_DATA const*, enum_server_ command) +0xaba) [0xcb3eca] percona5. 7.19/bin/ mysqld( do_command( THD*)+0x1b7) [0xcb5917] percona5. 7.19/bin/ mysqld( handle_ connection+ 0x2a0)[ 0xd79a60] percona5. 7.19/bin/ mysqld( pfs_spawn_ thread+ 0x1b4)[ 0x123cf24] libpthread. so.0[0x3798c07a a1] libc.so. 6(clone+ 0x6d)[0x37980e8 aad]
/bin/mysql/
/lib64/
/lib64/
/bin/mysql/
/bin/mysql/
/bin/mysql/
/bin/mysql/
/bin/mysql/
/bin/mysql/
/bin/mysql/
/bin/mysql/
/bin/mysql/
/bin/mysql/
/bin/mysql/
/lib64/
/lib64/
Table looks like 663473641 DEFAULT CHARSET=latin1
CREATE TABLE `t` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`f_id` int(11) NOT NULL,
`l` varchar(512) NOT NULL,
`t` varchar(128) NOT NULL,
`a` varchar(128) DEFAULT NULL,
`t2` text,
`s` text,
`c` datetime DEFAULT '0000-00-00 00:00:00',
`m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `rss_id_unique` (`l`,`f_id`) USING BTREE,
KEY `Index_3` (`c`),
KEY `Index_4` (`f_id`)
) ENGINE=InnoDB AUTO_INCREMENT=