[MDEV-12173] rpl.rpl_checksum_cache failed in buildbot on ppc64le with "Error: trying to do an operation on a dropped tablespace" Created: 2017-03-03  Updated: 2018-04-06  Resolved: 2018-01-22

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB, Tests
Affects Version/s: 10.0
Fix Version/s: 10.0.34, 10.1.31, 10.2.13, 10.3.5

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

Issue Links:
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled
relates to MDEV-14163 innodb.innodb-page_compression_defaul... Closed
Sprint: 10.0.34

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-ppc64le/builds/402/steps/mtr/logs/stdio

rpl.rpl_checksum_cache 'row,xtradb'      w1 [ fail ]  Found warnings/errors in server log file!
        Test ended at 2017-02-19 22:04:23
line
InnoDB: Error: trying to do an operation on a dropped tablespace 6
^ Found warnings in /dev/shm/var/1/log/mysqld.2.err
ok
 
 - saving '/dev/shm/var/1/log/rpl.rpl_checksum_cache-row,xtradb/' to '/dev/shm/var/log/rpl.rpl_checksum_cache-row,xtradb/'



 Comments   
Comment by Elena Stepanova [ 2017-05-17 ]

Just happened again on a non-experimental builder:
https://internal.askmonty.org/buildbot/builders/kvm-bintar-quantal-x86/builds/7171/steps/test/logs/stdio

rpl.rpl_checksum_cache 'innodb_plugin,row' w1 [ fail ]  Found warnings/errors in server log file!
        Test ended at 2017-05-17 19:19:31
line
InnoDB: Error: trying to do an operation on a dropped tablespace 6
^ Found warnings in /usr/local/mariadb-10.0.31-linux-i686/mysql-test/var/1/log/mysqld.2.err
ok
 
 - saving '/usr/local/mariadb-10.0.31-linux-i686/mysql-test/var/1/log/rpl.rpl_checksum_cache-innodb_plugin,row/' to '/usr/local/mariadb-10.0.31-linux-i686/mysql-test/var/log/rpl.rpl_checksum_cache-innodb_plugin,row/'

Comment by Marko Mäkelä [ 2018-01-22 ]

I suspect that this must have something to do with the previous tests that were run on the same instance. The logs are no longer available for either failure, and I was unable to repeat the problem locally by running all 6 combinations of the test 10 times each.

I think that we can simply remove this message. The only issuers of it are the debug function lock_rec_block_validate() and the change buffer merge. While in the former function the error should ideally never occur, we happen to know that DISCARD TABLESPACE and TRUNCATE TABLE and possibly DROP TABLE are breaking locks inside InnoDB.

When it comes to the change buffer merge, the message simply is useless noise. We know perfectly well that a tablespace can be dropped while a change buffer merge is pending.. And the code is prepared to handle that, which is demonstrated by the fact that whenever the message was issued, InnoDB did not crash.

In MariaDB 10.2, the function is fil_space_acquire() or fil_space_acquire_silent() instead of fil_inc_pending_ops(). Also there, we should suppress the message during change buffer merge, but not necessarily in other places.

Comment by Marko Mäkelä [ 2018-01-22 ]

Starting with MariaDB 10.2.2, the message is a warning: Trying to access missing tablespace.
It could be issued in more places than the change buffer merge. I will only suppress the message in the change buffer merge.

Generated at Thu Feb 08 07:55:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.