ERROR HY000 (1105): target: fk-test2.-.master: no healthy tablet available for 'keyspace:"fk-test2" shard:"-" tablet_type:MASTER ''

[janpio]

When testing Prisma Migrate on a database fk-test2 I got the following error, roughly 10 minutes after I created the database (and an additional branch):

C:\Users\Jan\Documents\throwaway\planetscale>npx prisma migrate dev --create-only
Environment variables loaded from .env
Prisma schema loaded from prisma\schema.prisma
Datasource "db": MySQL database "fk-test2" at "127.0.0.1:3306"

Error: Database error
Error querying the database: Server error: `ERROR HY000 (1105): target: fk-test2.-.master: no healthy tablet available for 'keyspace:"fk-test2" shard:"-" tablet_type:MASTER ''
   0: sql_migration_connector::flavour::mysql::sql_schema_from_migration_history
             at migration-engine\connectors\sql-migration-connector\src\flavour\mysql.rs:321
   1: sql_migration_connector::sql_database_migration_inferrer::calculate_drift
             at migration-engine\connectors\sql-migration-connector\src\sql_database_migration_inferrer.rs:57
   2: migration_core::api::DevDiagnostic
             at migration-engine\core\src\api.rs:95

I was connected to both the main and my manually created shadow branch in different terminal windows, and my code would have used both, so I can unfortunately not say which one threw the error. Trying the same command again did not throw the same error again.

[janpio]

Ok, a bit later it seems I was just lucky. Now I get the error above, ERROR HY000 (1105): unknown database 'fk-test2'' and semi working queries interchangeably.

[janpio]

6 hours later, this seems to have solved itself and I could successfully create a schema in that branch.