Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.2.15, 10.2.16, 10.3.8, 10.2(EOL), 10.3(EOL)
-
Ubuntu 14.04/18.04
Description
Works on 10.2.14 but hangs on 10.2.15 and 10.3.8 with repeating log entry:
[ERROR] InnoDB: Trying to read doublewrite buffer page [page id: space=0, page number=134]
|
Must kill -9 server
To reproduce, run following test case on fresh install of MariaDB server:
CREATE SCHEMA IF NOT EXISTS test;
|
USE test;
|
|
DROP PROCEDURE IF EXISTS foo;
|
DELIMITER $$
|
|
CREATE PROCEDURE foo()
|
BEGIN
|
|
DECLARE var INT UNSIGNED;
|
|
DROP TEMPORARY TABLE IF EXISTS bar;
|
CREATE TEMPORARY TABLE bar( i1 INT UNSIGNED, i2 INT UNSIGNED, KEY( i1, i2 ) );
|
|
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
|
|
START TRANSACTION;
|
|
INSERT INTO bar SET i1 = 1, i2 = 1;
|
|
UPDATE bar SET i2 = 2;
|
|
SET var = ( SELECT 1 FROM bar );
|
|
END
|
$$
|
|
DELIMITER ;
|
|
CALL foo;
|
Attachments
Issue Links
- is caused by
-
MDEV-15374 Server hangs and aborts with long semaphore wait or assertion `len < ((ulint) srv_page_size)' fails in trx_undo_rec_copy upon ROLLBACK on temporary table
- Closed
- relates to
-
MDEV-16824 InnoDB should skip MVCC and transaction locking for temporary tables.
- Confirmed