Bug#1074781: request-tracker5/4: autopkgtests don't work directly with new MariaDB 11.4

[o***@debian.org]

Package: request-tracker5
Version: 5.0.5+dfsg-2
Severity: important

MariaDB 1:11.4.2-1 was recently uploaded to Debian. MariaDB 11.4 and MySQL 8.4
are slowly diverging more and more.

In MariaDB 11.4 the 'mysql' naming in filenames has shifted towards 'mariadb'.
Hence the request-tracker5 (both version 5 and 4) autopkgtests are currently
failing, but the reason is a bit unclear.

Could you please assist in reading what the actual error in the logs is?

https://ci.debian.net/packages/r/request-tracker5/testing/armel/48409176/
https://ci.debian.net/packages/r/request-tracker4/testing/armel/48409175/

There are 60 tests that say 'not ok' but it is hard to figure out which one of
them is new, and why they are failing with MariaDB 11.4.

[Andrew Ruthven]

Post by o***@debian.org
MariaDB 1:11.4.2-1 was recently uploaded to Debian. MariaDB 11.4 and MySQL 8.4
are slowly diverging more and more.
In MariaDB 11.4 the 'mysql' naming in filenames has shifted towards 'mariadb'.
Hence the request-tracker5 (both version 5 and 4) autopkgtests are currently
failing, but the reason is a bit unclear.
Could you please assist in reading what the actual error in the logs is?

Hi Otto, sure thing, I'll have a look.

Cheers,
Andrew

[Andrew Ruthven]

Post by o***@debian.org
In MariaDB 11.4 the 'mysql' naming in filenames has shifted towards 'mariadb'.
Hence the request-tracker5 (both version 5 and 4) autopkgtests are currently
failing, but the reason is a bit unclear.

The issue isn't related to the mariadb package changing (the tests use
SQLite), but rather that occasionally some of the tests fail. Looking at the
failing tests in https://ci.debian.net/packages/r/request-tracker5 across
various different triggers, they appear to be the same (or a similar) set of
tests. But they fail intermittently.

I have a feeling there is a race condition in the tests, but, they should be
running independently with their own server and database.

More investigation required.

[Andrew Ruthven]

Control: tags -1 normal

Hey,

I believe that I've fixed the intermittent issue with the tests failing in 5.0.7+dfsg-2 with [0]. However as I'm not 100% sure yet, I've set the tests as flaky for now.

I'll keep this bug open until I'm 100% confident the tests are reliable.

My apologies for causing people to waste their time looking into these tests. I hadn't realised how flaky they were.

Cheers,
Andrew

[0] https://salsa.debian.org/request-tracker-team/request-tracker5/-/commit/44497367f88096a9f91439682b3c0460bf905eb0