CI-only failure: ProcessFreeTest::testGettingAvailableSlotsFor3Requests — SQLSTATE[42S02] 'zmsbo.calendarscope' missing; passes locally/when isolated"

[ThomasAFink]

What we know (facts only)

• The test BO\Zmsapi\Tests\ProcessFreeTest::testGettingAvailableSlotsFor3Requests fails in GitHub Actions when the full test suite runs.
• The same test passes:
  • when run locally, and
  • when run alone in the CI pipeline (e.g., with --filter "ProcessFreeTest::testGettingAvailableSlotsFor3Requests").
• ⚠️ Re-running any previously green pipelines for older commits now fails with the same error (even from weeks ago).
• ⚠️Same issue for re-runs on all Branches main next and Feature Branches
• Error reported in CI:
  BO\Zmsdb\Exception\Pdo\PDOFailed: SQL: Err: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zmsbo.calendarscope' doesn't exist
• A corresponding PDOException is also shown with the same 42S02 error.
• Stack trace excerpts point to:
  • zmsdb/src/Zmsdb/Base.php: Line [122]
  • zmsdb/src/Zmsdb/Base.php: Line [181]
  • zmsdb/src/Zmsdb/ProcessStatusFree.php: Line [45]
  • zmsdb/src/Zmsdb/ProcessStatusFree.php: Line [67]
  • zmsapi/src/Zmsapi/ProcessFree.php: Line [40]
  • zmsslim/src/Slim/PhpUnit/Base.php: Line [192]
  • zmsapi/tests/Zmsapi/ProcessFreeTest.php: Line [191]
• CI log context around the failure includes repeated messages such as:
  • "Writing temporary scope list"
  • "Temporary scope list written"
  • Multiple "Scope cache set"/"Cluster cache set"/"AvailabilityListUpdateFailed" warnings (noise-level context only)
• Example CI environment details observed alongside the failure:
  • PHP 8.3.24 with Xdebug 3.3.0
  • PHPUnit 11.5.45
  • Test runtime ~36s, 579 tests, 1293 assertions, 1 error (this test)
• Older Mariadb versions also fail (So that's not the issue)
• Probably isn't code changes releated.
• It may be test data (also unlikely) related or some dependency version

Reproduction (as observed)

• GitHub Actions, full suite run via phpunit.xml → 1 error:
  ProcessFreeTest::testGettingAvailableSlotsFor3Requests with SQLSTATE[42S02] 'zmsbo.calendarscope' doesn't exist.
• GitHub Actions, isolated run (single test with --filter) → passes.
• Local developer environment → passes.

Optional: temporary TODO in the test (fill in the new issue URL/number after you create it)

// TODO: Track CI-only calendarscope failure; see <new-issue-url-or-#number>.
// Temporarily disable to keep the pipeline green; restore once the CI-only issue is resolved.
// $this->markTestSkipped('CI-only: SQLSTATE[42S02] calendarscope missing; see <issue link>.');

Stacktrace:

Time: 00:37.759, Memory: 82,00 MB
There was 1 error:
1) BO\Zmsapi\Tests\ProcessFreeTest::testGettingAvailableSlotsFor3Requests
BO\Zmsdb\Exception\Pdo\PDOFailed: SQL:  Err: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zmsbo.calendarscope' doesn't exist
/__w/eappointment/eappointment/zmsdb/src/Zmsdb/Base.php:122
/__w/eappointment/eappointment/zmsdb/src/Zmsdb/Base.php:181
/__w/eappointment/eappointment/zmsdb/src/Zmsdb/ProcessStatusFree.php:39
/__w/eappointment/eappointment/zmsdb/src/Zmsdb/ProcessStatusFree.php:61
/__w/eappointment/eappointment/zmsapi/src/Zmsapi/ProcessFree.php:40
/__w/eappointment/eappointment/zmsapi/src/Zmsapi/BaseController.php:23
/__w/eappointment/eappointment/zmsslim/src/Slim/PhpUnit/Base.php:192
/__w/eappointment/eappointment/zmsapi/tests/Zmsapi/ProcessFreeTest.php:191
Caused by
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zmsbo.calendarscope' doesn't exist
/__w/eappointment/eappointment/zmsdb/src/Zmsdb/Base.php:183
/__w/eappointment/eappointment/zmsdb/src/Zmsdb/Base.php:105
/__w/eappointment/eappointment/zmsdb/src/Zmsdb/Base.php:181
/__w/eappointment/eappointment/zmsdb/src/Zmsdb/ProcessStatusFree.php:39
/__w/eappointment/eappointment/zmsdb/src/Zmsdb/ProcessStatusFree.php:61
/__w/eappointment/eappointment/zmsapi/src/Zmsapi/ProcessFree.php:40
/__w/eappointment/eappointment/zmsapi/src/Zmsapi/BaseController.php:23
/__w/eappointment/eappointment/zmsslim/src/Slim/PhpUnit/Base.php:192
/__w/eappointment/eappointment/zmsapi/tests/Zmsapi/ProcessFreeTest.php:191
ERRORS!
Tests: 579, Assertions: 1293, Errors: 1.