Getting Error: Table 'subscription_settings' already exists when Migrating to V2

[techmechanic1]

Here are some of the logs..

==> logs/auth.log <== query: SELECT VERSION() AS version info: All classes found using provided glob pattern "dist/migrations/mysql/*.js" : "dist/migrations/mysql/1606470249553-init_database.js,dist/migrations/mysql/1610015065194-add_revoked_sessions.js,dist/migrations/mysql/1610025371088-add_foreign_key_to_revoked_sessions.js,dist/migrations/mysql/1612191669523-add_roles_and_permissions.js,dist/migrations/mysql/1612255683992-add_roles_and_permissions_data.js,dist/migrations/mysql/1612433739754-add_more_roles_and_permissions.js,dist/migrations/mysql/1614678016791-add_user_settings.js,dist/migrations/mysql/1614771815912-add_encrypted_version.js,dist/migrations/mysql/1614775877590-add_encrypted_version_for_user.js,dist/migrations/mysql/1624434102642-update_roles_and_permissions.js,dist/migrations/mysql/1625164984414-change_setting_timestamps.js,dist/migrations/mysql/1625227894975-change_setting_value_size.js,dist/migrations/mysql/1625767770284-change_setting_value_to_nullable.js,dist/migrations/mysql/1625807999951-add_unique_setting_index.js,dist/migrations/mysql/1626268390207-remove_unique_setting_index.js,dist/migrations/mysql/1626689139110-add_user_subscriptions.js,dist/migrations/mysql/1626717016896-fix_subscription_foreign_key.js,dist/migrations/mysql/1627638504691-move_mfa_items_to_user_settings.js,dist/migrations/mysql/1629215600192-generate_user_server_key.js,dist/migrations/mysql/1629217630132-encrypt_encoded_mfa_settings.js,dist/migrations/mysql/1629223072059-flatten_mfa_setting_and_encrypt.js,dist/migrations/mysql/1629703896382-add_markdown_math.js,dist/migrations/mysql/1629705289178-add_sensitive_flag.js,dist/migrations/mysql/1629972294975-fix_basic_and_core_user.js,dist/migrations/mysql/1630661830850-fix_encryption_version_on_mfa_settings.js,dist/migrations/mysql/1630905831679-add-cancelled-flag.js,dist/migrations/mysql/1634064348750-add_offline_settings.js,dist/migrations/mysql/1634102065310-add_offline_subscriptions.js,dist/migrations/mysql/1634102764797-add_offline_user_roles.js,dist/migrations/mysql/1635167238332-remove_spreadsheets_from_plus_plan.js,dist/migrations/mysql/1635172524403-add_subscription_id.js,dist/migrations/mysql/1635344737460-add_missing_permissions.js,dist/migrations/mysql/1635860707639-add_mandatory_subscription_id.js,dist/migrations/mysql/1638388151083-add_tags_and_focus_permissions.js,dist/migrations/mysql/1639998097029-add_role_version.js,dist/migrations/mysql/1640701224273-add-smart-tags.js,dist/migrations/mysql/1640862425427-remove_no_distraction_theme.js,dist/migrations/mysql/1645094434931-add_sign_in_alerts_permission.js,dist/migrations/mysql/1646817642385-add_markdown_visual_editor_permissions.js,dist/migrations/mysql/1647253634773-fix_storage_quota_on_plans.js,dist/migrations/mysql/1647421277767-remove_user_agent.js,dist/migrations/mysql/1647862631224-add_readonly_sessions.js,dist/migrations/mysql/1648112718114-add_tag_nesting_permission.js,dist/migrations/mysql/1648458841415-add_shared_subscription_invitations.js,dist/migrations/mysql/1648550676786-add_subscription_types.js,dist/migrations/mysql/1648629732139-add_beta_files_user_role.js,dist/migrations/mysql/1649660400536-add_subscription_settings.js,dist/migrations/mysql/1649679945386-remove_files_settings_from_user_settings.js,dist/migrations/mysql/1650890853447-change_upload_quota_tiers.js,dist/migrations/mysql/1651046286472-add_2fa.js,dist/migrations/mysql/1651064332146-remove_2fa_manager.js,dist/migrations/mysql/1652258146238-add_missing_plus_permissions.js,dist/migrations/mysql/1652786070920-remove_basic_user_role.js,dist/migrations/mysql/1652880249670-add_analytics_entities.js,dist/migrations/mysql/1654760926952-add_email_backup_permission.js,dist/migrations/mysql/1654877423147-add_advanced_checklist_editor_permission.js,dist/migrations/mysql/1661771230400-revoked_session_data.js,dist/migrations/mysql/1663073954000-add_subcription_sharing_permission.js,dist/migrations/mysql/1663321030000-add_renewed_at_column.js,dist/migrations/mysql/1664971834974-groups.js,dist/migrations/mysql/1665047863774-remove-groups.js,dist/migrations/mysql/1667818539829-remove_analytics.js,dist/migrations/mysql/1671448907955-add_session_traces.js,dist/migrations/mysql/1671561748264-add_session_traces_compound_index.js,dist/migrations/mysql/1672223738686-add_authenticators.js,dist/migrations/mysql/1672227471677-add_authenticator_challenges.js,dist/migrations/mysql/1672232035280-fix_authenticator_data_types.js,dist/migrations/mysql/1672299743840-add_unique_index_on_challenges.js,dist/migrations/mysql/1672307975117-remove_compound_index.js,dist/migrations/mysql/1672317378817-add_authenticator_name.js,dist/migrations/mysql/1673951291148-add_super_editor.js,dist/migrations/mysql/1674739193816-fix-client-id-type-in-authenticators.js,dist/migrations/mysql/1678110075698-remove-sign-in-emails-on-free-acounts.js,dist/migrations/mysql/1678266947362-add-internal-team-user-role.js,dist/migrations/mysql/1678340701766-remove-authenticator-names-from-server.js,dist/migrations/mysql/1680597887475-emergency-access-invitations.js,dist/migrations/mysql/1681984540867-enable-u2f.js,dist/migrations/mysql/1682926032072-cache-entries.js,dist/migrations/mysql/1683017908845-change-cache-table-name.js" query: SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'standard_notes_db' AND TABLE_NAME = 'migrations' query: SELECT * FROM standard_notes_db.migrations migrations ORDER BY id DESC 63 migrations are already loaded in the database. 79 migrations were found in the source code. makeUserUuidNullable1669735585016 is the last executed migration. It was executed on Tue Nov 29 2022 15:26:25 GMT+0000 (Coordinated Universal Time). 33 migrations are new migrations must be executed. query: START TRANSACTION query: CREATE TABLE subscription_settings (uuid varchar(36) NOT NULL, name varchar(255) NOT NULL, value text NULL, server_encryption_version tinyint NOT NULL DEFAULT 0, created_at bigint NOT NULL, updated_at bigint NOT NULL, sensitive tinyint(1) NOT NULL DEFAULT 0, user_subscription_uuid varchar(36) NOT NULL, INDEX index_subcsription_settings_on_updated_at (updated_at), INDEX index_settings_on_name_and_user_subscription_uuid (name, user_subscription_uuid), PRIMARY KEY (uuid)) ENGINE=InnoDB query failed: CREATE TABLE subscription_settings (uuid varchar(36) NOT NULL, name varchar(255) NOT NULL, value text NULL, server_encryption_version tinyint NOT NULL DEFAULT 0, created_at bigint NOT NULL, updated_at bigint NOT NULL, sensitive tinyint(1) NOT NULL DEFAULT 0, user_subscription_uuid varchar(36) NOT NULL, INDEX index_subcsription_settings_on_updated_at (updated_at), INDEX index_settings_on_name_and_user_subscription_uuid (name, user_subscription_uuid), PRIMARY KEY (uuid)) ENGINE=InnoDB error: Error: Table 'subscription_settings' already exists query: ROLLBACK

==> logs/supervisord.log <== 2023-05-15 16:12:53,425 WARN exited: auth (exit status 1; not expected) 2023-05-15 16:12:54,429 INFO spawned: 'auth' with pid 234

==> logs/auth.log <== localhost:3101 is up. Proceeding to startup.

==> logs/supervisord.log <== 2023-05-15 16:12:55,448 INFO success: auth entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)

==> logs/auth-worker.log <== localhost:3103 is unavailable yet - waiting for it to start