[#MDEV-24075] perfschema.relaylog (and probably other tests) fail in buildbot with warning: InnoDB: Are you sure you are using the right ib

[MDEV-24075] perfschema.relaylog (and probably other tests) fail in buildbot with warning: InnoDB: Are you sure you are using the right ib_logfiles to start up the database Created: 2020-10-31 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:

Marko Mäkelä

Resolution:

Cannot Reproduce

Votes:

Labels:

None

Description

10.2 5933081d8b05893b8987c0c89237b476
perfschema.relaylog 'row' w2 [ fail ] Found warnings/errors in server log file!
Test ended at 2020-10-06 13:29:00
line
2020-10-06 13:28:58 140676923836480 [Warning] InnoDB: Are you sure you are using the right ib_logfiles to start up the database? Log sequence number in the ib_logfiles is 1628282, less than the log sequence number in the first system tablespace file header, 1628301.
^ Found warnings in /dev/shm/var/2/log/mysqld.2.err
ok

Comments

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

This type of failure has apparently never occurred in other major versions than 10.2. It last occurred on a 10.2 based pull request:

refs/pull/2076/merge b818c2c3eddca17a1a991ad88a35ba0304b130aa
perfschema.relaylog 'row' w16 [ fail ] Found warnings/errors in server log file!
Test ended at 2022-05-04 09:10:51
line
2022-05-04 9:10:50 140153635698816 [Warning] InnoDB: Are you sure you are using the right ib_logfiles to start up the database? Log sequence number in the ib_logfiles is 1628253, less than the log sequence number in the first system tablespace file header, 1628272.

The previous occurrence was almost a year earlier:

10.2 9739cf1859aaf08b88a3df1a7dc56eb514f63fcf
perfschema.relaylog 'mix' w7 [ fail ] Found warnings/errors in server log file!
Test ended at 2021-05-22 04:55:42
line
2021-05-22 4:55:40 140339397936576 [Warning] InnoDB: Are you sure you are using the right ib_logfiles to start up the database? Log sequence number in the ib_logfiles is 1628253, less than the log sequence number in the first system tablespace file header, 1628272.

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