| 2017-04-26 08:44:29 |
Kirill |
description |
Hi!
percona 5.7.17-13 (check CentOS, Ubuntu on default config) crash on UPDATE ON DUPLICATE KEY
percona 5.6 All ok
How to reproduce:
<---Structure DB----->
create database buk;
use buk;
CREATE TABLE tablica_s_govnom (
pri1 int(11) UNSIGNED NOT NULL,
DT datetime DEFAULT NULL,
dop1 text DEFAULT NULL ,
PRIMARY KEY (pri1),
INDEX UK_tablica_s_govnom (DT)
)
ENGINE = INNODB
AVG_ROW_LENGTH = 16384
CHARACTER SET utf8
COLLATE utf8_general_ci
ROW_FORMAT = DYNAMIC;
INSERT INTO tablica_s_govnom(pri1,DT,dop1) VALUES(1,NOW(),'2222');
DELIMITER //
CREATE PROCEDURE Sucks_test()
BEGIN
DECLARE pri1,pri3 int;
DECLARE pri2,comment VARCHAR(255);
DECLARE dop1_1,dop2,dop3 VARCHAR(255) DEFAULT '222';
set pri1=1,pri2='1',pri3=1,comment='123';
INSERT INTO tablica_s_govnom(pri1, DT, dop1)
VALUES(pri1, NOW() ,dop1_1)
ON DUPLICATE KEY UPDATE DT=NOW(), dop1=VALUES(dop1);
END//
</---Structure DB----->
<---test---->
use buk;
CALL Sucks_test();
CALL Sucks_test();
</---test---->
run test in loop wait 5-10sec and mysql DIE with "mysqld got signal 11 ;" |
Hi!
percona 5.7.17-13 (check CentOS 7.3, Ubuntu 16.04 on default config) crash on UPDATE ON DUPLICATE KEY
percona 5.6 All ok
How to reproduce:
<---Structure DB----->
create database buk;
use buk;
CREATE TABLE tablica_s_govnom (
pri1 int(11) UNSIGNED NOT NULL,
DT datetime DEFAULT NULL,
dop1 text DEFAULT NULL ,
PRIMARY KEY (pri1),
INDEX UK_tablica_s_govnom (DT)
)
ENGINE = INNODB
AVG_ROW_LENGTH = 16384
CHARACTER SET utf8
COLLATE utf8_general_ci
ROW_FORMAT = DYNAMIC;
INSERT INTO tablica_s_govnom(pri1,DT,dop1) VALUES(1,NOW(),'2222');
DELIMITER //
CREATE PROCEDURE Sucks_test()
BEGIN
DECLARE pri1,pri3 int;
DECLARE pri2,comment VARCHAR(255);
DECLARE dop1_1,dop2,dop3 VARCHAR(255) DEFAULT '222';
set pri1=1,pri2='1',pri3=1,comment='123';
INSERT INTO tablica_s_govnom(pri1, DT, dop1)
VALUES(pri1, NOW() ,dop1_1)
ON DUPLICATE KEY UPDATE DT=NOW(), dop1=VALUES(dop1);
END//
</---Structure DB----->
<---test.sql---->
use buk;
CALL Sucks_test();
CALL Sucks_test();
</---test.sql---->
run test in loop wait 5-10sec and mysql DIE with "mysqld got signal 11 ;"
while true; do mysql < test.sql ; done |
|
