🐛 Bug Report: Migrate: Base table or view not found: 1146 Table 'appwrite._console_' doesn't exist

[silberGuy]

👟 Reproduction steps

Hi :)
I am trying to upgradte appwrite from 0.14 to 1.0.3, step by step.
First I did a backup for the DB and the volumes. Later I installed version 0.15.3, and ran

docker-compose exec appwrite migrate

the migration output gives the following error (full logs added below):
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'appwrite.\_console\_' doesn't exist

👍 Expected behavior

Having the app migrated to version 0.15 with all the existing data.

👎 Actual Behavior

The console loads and allows me to log in, but my projects are not shown.
I did see that the projects still exist in the db using mysql select queries on the mariaDb container.

Full migration output:

Starting Data Migration to version 0.15.3
[PDO] MySQL connection restarted
Migrating project: Appwrite (console)
Migrating Collections

• _metadata
• audit
• abuse
• databases
• collections
• attributes
  'databaseInternalId' from attributes: Attribute already exists
  'databaseInternalId' from attributes: Attribute already exists
  'collectionInternalId' from attributes: Attribute already exists
  [PDO] MySQL connection restarted
  '_key_collection' from attributes: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX _key_collection; check that it exists
• indexes
  'databaseInternalId' from indexes: Attribute already exists
  'databaseInternalId' from indexes: Attribute already exists
  'collectionInternalId' from indexes: Attribute already exists
  [PDO] MySQL connection restarted
  '_key_collection' from indexes: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX _key_collection; check that it exists
• projects
  'teamInternalId' from projects: Attribute already exists
• platforms
  'projectInternalId' from platforms: Attribute already exists
• domains
  'projectInternalId' from domains: Attribute already exists
• keys
  'projectInternalId' from keys: Attribute already exists
  'expire' from keys: Attribute already exists
• webhooks
  'signatureKey' from webhooks: Attribute already exists
  'projectInternalId' from webhooks: Attribute already exists
• users
  'phone' from users: Attribute already exists
  'phoneVerification' from users: Attribute already exists
  '_key_phone' from users: Index already exists
• tokens
  'userInternalId' from tokens: Attribute already exists
• sessions
  'userInternalId' from sessions: Attribute already exists
• teams
• memberships
  'teamInternalId' from memberships: Attribute already exists
  'userInternalId' from memberships: Attribute already exists
• functions
• deployments
• builds
• executions
• certificates
• buckets
• stats
• realtime
• files
  Create Default Database Layer
  Migrating Documents
  Migrating Collection _metadata:
  24 / 24
  Migrating Collection audit:
  53 / 53
  Migrating Collection abuse:
  100 / 573
  200 / 573
  300 / 573
  400 / 573
  500 / 573
  573 / 573
  Migrating Collection databases:
  [PDO] MySQL connection restarted
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'appwrite._console_' doesn't exist

🎲 Appwrite version

Version 0.15.x

💻 Operating system

Linux

🧱 Your Environment

No response

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[stnguyen90]

@silberGuy is that migration output the first time you ran the migrate for 0.15?

[silberGuy]

@stnguyen90 The error is the same as the first time, although this is not the first