Comment 11 for bug 1686340

Revision history for this message
markus_albe (markus-albe) wrote :

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