Managed MySQL PHPUnit multisite omits network tables

[chubes4]

Summary

A managed wordpress.phpunit run configured with MySQL and multisite boots WordPress without creating the required multisite network tables. PHPUnit continues, but WordPress emits database errors for wptests_blogs and wptests_sitemeta, so multisite behavior cannot be validated faithfully.

Evidence

• Consumer PR: fix: clear managed PHPUnit baseline Extra-Chill/extrachill-events#355
• Failing managed run: https://github.com/Extra-Chill/extrachill-events/actions/runs/30138187262
• WP Codebox source SHA reported by the run: 6aa2b97cd4170cc6a3d2e350d316541547f35a7d
• Homeboy WordPress extension revision: 1cd18d31
• Homeboy: 0.314.2+bbf556096619+cb0497a
• PHP: 8.3.32
• Database type: MySQL
• Managed bootstrap mode: managed
• Multisite: enabled

Runtime configuration:

{
  "database_type": "mysql",
  "validation_dependencies": [
    { "type": "local", "path": "<checkout>/.ci/data-machine", "plugin_slug": "data-machine", "activate": true },
    { "type": "local", "path": "<checkout>/.ci/data-machine-events", "plugin_slug": "data-machine-events", "activate": true }
  ],
  "wp_codebox_multisite": true,
  "wp_codebox_phpunit_bootstrap_mode": "managed"
}

Exact startup diagnostics:

WordPress database error Table 'runtime.wptests_blogs' doesn't exist for query SELECT wptests_blogs.blog_id ... made by pg_run_install_stage, ... wp-phpunit/includes/install.php, ... ms_load_current_site_and_network
WordPress database error Table 'runtime.wptests_sitemeta' doesn't exist for query SELECT meta_value FROM wptests_sitemeta ... made by pg_run_install_stage, ... wp-phpunit/includes/install.php, ... get_network_option
WordPress database error Table 'runtime.wptests_blogs' doesn't exist for query SELECT * FROM wptests_blogs WHERE blog_id = 1 LIMIT 1 ... ms_site_check, get_site, WP_Site::get_instance

The managed suite then reports 276 tests, but current-site lookups and every network option operation are running against an incomplete schema.

Expected

When multisite is enabled, the managed install stage creates and seeds at least the standard blogs, blogmeta, site, sitemeta, registration_log, and signups tables before WordPress multisite bootstrap and plugin activation.

Impact

Consumers cannot establish a real managed MySQL/multisite PHPUnit baseline. Adding per-test cache objects or bypassing get_site() would hide the broken runtime and would not validate multisite behavior.

[chubes4]

Additional evidence from continued consumer iterations:

• Latest run: https://github.com/Extra-Chill/extrachill-events/actions/runs/30139585251
• Head: 97164d5
• Suite still executes: 276 tests, 595 assertions, 26 errors, 52 failures.
• The runtime still reports missing runtime.wptests_blogs and runtime.wptests_sitemeta during managed multisite bootstrap.
• The declared validation dependency is also absent from its generated sandbox path. A test resolving the composed dependency through WP_PLUGIN_DIR . '/data-machine-events/contracts' reports:

Failed asserting that directory "/wordpress/wp-content/plugins/data-machine-events/contracts" exists.

The workflow checks out Data Machine Events to ${{ github.workspace }}/.ci/data-machine-events and passes that absolute path in validation_dependencies. The Homeboy adapter turns it into an extra_plugins entry plus /wordpress/wp-content/plugins/data-machine-events dependency mount, but the directory is not present when PHPUnit executes.

This means the affected managed run currently has both parts of the same composition failure:

1. no multisite network tables, so network option/site semantics cannot boot;
2. no composed network dependency directory, so Data Machine Events cannot activate or expose its contract/runtime constants.

Consumer-side host-path reads or synthetic network tables would conceal the managed runtime defect and are intentionally not being added.

[chubes4]

Current confirmation from Extra-Chill/extrachill-events PR #355 after merging current main:\n\n- Run: https://github.com/Extra-Chill/extrachill-events/actions/runs/30202648832\n- Consumer head: 11282201da537f90040eaf3593a3c51f0779a8ee\n- WP Codebox main: cf2547a\n- Homeboy WordPress extension: 65223e22\n- Result: 279 tests, 597 assertions, 28 errors, 52 failures; 199 passing, 0 skipped.\n- Startup still reports missing runtime.wptests_blogs and runtime.wptests_sitemeta.\n- The composed /wordpress/wp-content/plugins/data-machine-events/contracts directory is still absent.\n- Lint remains green.\n\nNo consumer-side synthetic schema, host-path fallback, skip, or permission workaround was added.

[chubes4]

Final corrected consumer evidence after removing process isolation that is not faithful in the managed child runtime:\n\n- Run: https://github.com/Extra-Chill/extrachill-events/actions/runs/30203253979\n- Consumer head: fbc84ef2ebf88f785530637f0ce2f06fa151cf6a\n- Result: 279 tests, 599 assertions, 26 errors, 54 failures; 199 passing, 0 skipped.\n- Lint is green (PHPCS, ESLint, PHPStan).\n- Startup still reports missing runtime.wptests_blogs and runtime.wptests_sitemeta.\n- /wordpress/wp-content/plugins/data-machine-events/contracts is still absent.\n- The two new pagination fixtures now construct real WP_Term-compatible objects; their remaining managed failures occur downstream of the same incomplete multisite runtime.\n\nNo synthetic schema, host-path fallback, skipped test, global error suppression, or permission workaround was added.

[chubes4]

Latest consumer iteration after removing an independent test-double/class-resolution failure:\n\n- Run: https://github.com/Extra-Chill/extrachill-events/actions/runs/30205097263\n- Consumer head: d44070ce43c51045846e2da84f62f98864d29c70\n- Result: 279 tests, 604 assertions, 26 errors, 50 failures; 203 passing, 0 skipped.\n- Lint remains green.\n- The four QualifyRecheckHandler cases now pass through the real FlowOps and real WordPress Ability contracts.\n- All remaining clusters still start from missing runtime.wptests_blogs/runtime.wptests_sitemeta or the absent /wordpress/wp-content/plugins/data-machine-events mount.\n\nNo synthetic schema, host-path fallback, skipped test, global error suppression, or permission workaround was added.

[chubes4]

Latest exact-head consumer evidence after all independently fixable Account Market and recheck runtime-contract groups were corrected:\n\n- Run: https://github.com/Extra-Chill/extrachill-events/actions/runs/30207544937\n- Consumer head: 18391790d653e0cb78e514ddb7e1084a3b3a8c87\n- Result: 279 tests, 637 assertions, 26 errors, 31 failures; 222 passing, 0 skipped.\n- AccountMarketTest is now fully green in managed WordPress.\n- Remaining groups are 3 absent DME-contract failures, 11 artist multisite failures, and 43 venue multisite/schema failures.\n- Runtime startup still lacks runtime.wptests_blogs/runtime.wptests_sitemeta and mounts only extrachill-events, not the declared Data Machine Events dependency.\n\nNo synthetic schema, host-path fallback, skipped test, global error suppression, or permission workaround was added.