Drupal core's Migrate API has a regression since #3124674: Refactor functionality for the SQLite driver to stop migration testing usage of the 'extra_prefix' connection option → was committed to core, because database tables of a SQLite source and SQLite ID map tables aren't joinable anymore.
Unfortunately, Migrate Drupal UI tests are performed with SQLite database driver aren't reveal this issue, because these tests are setting up a "not joinable" source and destination databases.
On the other hand, MigrateTestBase's createMigrationConnection manually attaches the destination SB to the source, so it hides this regression/bug. There isn't any (functional) migrate thing in core that calls Connection::attachDatabase(), so I'm pretty sure it shouldn't be called in tests.
I will upload a functional regression test which uses Migrate API, initializes the source plugin instance of d7_user_role (and then checks whether the map table was created), then verifies that the source plugin of d7_user_role tells us that the source and the id map tables are joinable, and then finally tries to get the source plugin instance's source values.
This will be a new test, so it can be applied on 9.2.x and so (hopefully) you will see that it works well with that core version.
Discovered in #3218083-14: Handle long media source field names → .
In settings.php you should have something like this:
// Default (destination) connection:
$databases['default']['default'] = [
'driver' => 'sqlite',
'database' => '<absolute_path_to>/sqlite.db',
];
// Fixture connection:
$databases['fixture_connection']['default'] = [
'driver' => 'sqlite',
'database' => '<absolute_path_to>/sqlite.db',
'prefix' => 'test123',
];
settings.php./upgrade, and at the credentials form select SQLite. Fill in the path to the SQLite db file and the prefix of the fixture connection.Expected result: Upgrade executed without errors on every 9.* core versions.
Actual result on 9.3.x or on 9.4.x: Upgrade failed, only those migrations are executed which have no-sql source plugin.
Depends.
Nothing.
Restored API, SQLite source and id map tables are joinable again.
Nothing.
Nothing.
Closed: cannot reproduce
10.0 ✨
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
I'm trying to resolve or close old migrate issues. It's been about a year since we've heard anything on this. I'm going to close this as 'cannot reproduce' but feel free to reopen it if the OP or original reviewers can comment as to whether the latest patch sufficiently solves the issue at hand.