[MDEV-14809] innodb.innodb-index-online failed in buildbot with timeout on saving statistics Created: 2017-12-29  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Tests
Affects Version/s: 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/p8-rhel6-bintar-debug/builds/1601/steps/test/logs/stdio

innodb.innodb-index-online '4k,crypt,innodb' w4 [ fail ]  Found warnings/errors in server log file!
 
        Test ended at 2017-12-25 11:51:12
 
line
 
2017-12-25 11:51:12 17590342644128 [ERROR] InnoDB: Cannot save index statistics for table `test`.`t1`, index `PRIMARY`, stat name "size": Lock wait timeout
 
2017-12-25 11:51:12 17590342644128 [ERROR] InnoDB: Cannot save table statistics for table `test`.`t1`: Lock wait timeout
 
^ Found warnings in /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/4/log/mysqld.1.err
 
ok

As discussed before, we might have to add the message to global suppressions, but so far it has been one occurrence, so I don't want to rush into it.

 Comments   
Comment by Marko Mäkelä [ 2023-11-29 ]

This last occurred more than 5 years ago:

10.3 da27dc995ee407cb56761393bc5dcdd4

 
innodb.innodb-index-online '8k,clear,innodb' w1 [ fail ]  Found warnings/errors in server log file!
 
        Test ended at 2018-01-16 07:30:15
 
line
 
2018-01-16  7:30:14 0 [ERROR] InnoDB: Cannot save table statistics for table `test`.`t1`: Lock wait timeout
 
^ Found warnings in /home/buildbot/maria-slave/power8-vlp06-bintar-debug/build/mysql-test/var/1/log/mysqld.1.err

I think that this error is theoretically possible until MDEV-15020 and MDEV-26603 were fixed in MariaDB Server 10.6.

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