Comment 2 for bug 1309026

Revision history for this message
Aurimas Mikalauskas (aurimas-mikalauskas) wrote :

For the record, same crash was reproduced with Performance Schema disabled and the problem on a reproducible case on the customer system was reduced to:

CREATE DATABASE ms ;
CREATE TABLE t1 (a INT PRIMARY KEY AUTO_INCREMENT, b INT, c VARCHAR(50)) ;

- Put the following in q.sql:
SELECT FLOOR(RAND() * 1000000), MD5(RAND()), FLOOR(RAND() * 10000) INTO @ri, @rs, @rid
INSERT INTO t1 (b, c) VALUES (@ri, @rs)
INSERT INTO t1 (b, c) VALUES (@ri, @rs)
INSERT INTO t1 (b, c) VALUES (@ri, @rs)
INSERT INTO t1 (b, c) VALUES (@ri, @rs)
UPDATE t1 SET c = 'UPDATED' WHERE a = @rid

- And run:
mysqlslap --create-schema=ms -c 50 -i1000000 -q q.sql

This crashes the server within seconds when I run it with the thread-pool enabled. It is yet to crash the server w/o thread-pool.