[MDEV-32507] Spider tests with init-file using $MYSQL_TEST_DIR fails in certain CIs due to different directory structure Created: 2023-10-18  Updated: 2023-12-07  Resolved: 2023-10-24

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.10
Fix Version/s: 10.10.7, 10.11.6, 11.0.4, 11.1.3

Type: Bug Priority: Critical
Reporter: Yuchen Pei Assignee: Yuchen Pei
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-22979 "mysqld --bootstrap" / mysql_install_... Closed

 Description   

Example:

https://buildbot.mariadb.net/buildbot/builders/kvm-deb-bullseye-amd64/builds/3107

The mtr failures all have to do with the $MYSQL_TEST_DIR being /usr/share/mysql/mysql-test on the CI machine, whose parent dir does not contain storage/spider/mysql-test, so paths like the one in --init-file=$MYSQL_TEST_DIR/../storage/spider/mysql-test/spider/bugfix/t/mdev_28218_mixed.sql are not found.

 Comments   
Comment by Yuchen Pei [ 2023-10-18 ]

An initial fix, waiting for CI builders to pick it up

bb-10.10-mdev-3250X upstream/bb-10.10-all-builders f63845524aacdd06431399c857c93aa52559b76c
 
[fixup] Spider: Use $MTR_SUITE_DIR for init-file files
 
 
 
This should fix certain CI builds where the spider suite test files
 
and the main suite test files do not follow the same relative paths
 
relations as the mariadb source.

https://buildbot.mariadb.net/buildbot/grid?category=main&branch=bb-10.10-all-builders
https://buildbot.mariadb.net/buildbot/builders/kvm-deb-bullseye-amd64/builds/3143

Update on [2023-10-19 Thu]: the fix worked, as the failures caused
by this issue are gone. There's still failure in
spider/bugfix.mdev_30370 but that is a separate issue, for which I
have opened MDEV-32515.

Comment by Yuchen Pei [ 2023-10-19 ]

Hi holyfoot, ptal thanks

upstream/bb-10.10-mdev-32507 bb-10.10-all-builders e776d00fb2027183240d3b932b3394c2f923f1b7
 
MDEV-32507 Spider: Use $MTR_SUITE_DIR for init-file files
 
 
 
This should fix certain CI builds where the spider suite test files
 
and the main suite test files do not follow the same relative paths
 
relations as the mariadb source.

Comment by Alexey Botchkov [ 2023-10-23 ]

ok to push.

Comment by Yuchen Pei [ 2023-10-24 ]

Thanks for the review.

Pushed 15a1168b36e to 10.10

Generated at Thu Feb 08 10:31:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.