[MDEV-16647] InnoDB fails to drop large temporary table on disconnect Created: 2018-06-30  Updated: 2019-07-22  Resolved: 2018-08-31

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1.35
Fix Version/s: 10.1.36

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-16515 InnoDB: Failing assertion: ++retries ... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest-big/builds/1907

10.1 be5698265a4195586142d1a34fdd1cce

 
innodb.sp_temp_table 'xtradb'            w2 [ fail ]  Found warnings/errors in server log file!
 
        Test ended at 2018-06-27 22:34:49
 
line
 
2018-06-27 22:34:48 139627042478848 [Warning] Could not remove temporary table: '/mnt/buildbot/build/mariadb-10.1.35/mysql-test/var/tmp/2/mysqld.1/#sql32e0_3_0', error: 2
 
^ Found warnings in /mnt/buildbot/build/mariadb-10.1.35/mysql-test/var/2/log/mysqld.1.err
 
ok
 
 
 
 - saving '/mnt/buildbot/build/mariadb-10.1.35/mysql-test/var/2/log/innodb.sp_temp_table-xtradb/' to '/mnt/buildbot/build/mariadb-10.1.35/mysql-test/var/log/innodb.sp_temp_table-xtradb/'
 
worker[2] > Restart  - not started



 Comments   
Comment by Marko Mäkelä [ 2018-08-31 ]

Only MariaDB Server 10.1.35 is affected by this. In 10.2 and later, the code path would not be executed for temporary tables, because temporary tables would always reside in the dedicated tablespace, not in .ibd files.

Generated at Thu Feb 08 08:30:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.