Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Migration fails after updating to 4.1.0 #7259

Open
3 tasks done
daryljones opened this issue May 3, 2024 · 2 comments
Open
3 tasks done

Migration fails after updating to 4.1.0 #7259

daryljones opened this issue May 3, 2024 · 2 comments
Labels

Comments

@daryljones
Copy link

⚠️ This issue respects the following points: ⚠️

  • This is a bug, not a question or a configuration/webserver/proxy issue.
  • This issue is not already reported on Github (I've searched it).
  • I agree to follow Monica's Code of Conduct.

Bug description

Migration fails after updating to 4.1.0

Steps to reproduce

  1. Existing working 4.0.0 non-docker installation
  2. Update to 4.1.0
  3. php artisan migrate
    ...

Expected behavior

I expected the migration to run without error. Instead, I get this.

$ php artisan migrate

INFO Running migrations.

2013_04_25_132851_create_accounts_table .................................................................................. 4.32ms FAIL

Illuminate\Database\QueryException

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'accounts' already exists (Connection: mysql, SQL: create table accounts (id char(36) not null, storage_limit_in_mb int not null default '0', created_at timestamp null, updated_at timestamp null, primary key (id)) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

at vendor/laravel/framework/src/Illuminate/Database/Connection.php:813
809▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
810▕ );
811▕ }
812▕
➜ 813▕ throw new QueryException(
814▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
815▕ );
816▕ }
817▕ }

  +9 vendor frames

10 database/migrations/2013_04_25_132851_create_accounts_table.php:14
Illuminate\Support\Facades\Facade::__callStatic()
+26 vendor frames

37 artisan:13
Illuminate\Foundation\Application::handleCommand()

Environment

app.monicahq.com (monica v4)

Version of Monica

4.1.0

Installation method

Manual installation with Archive

Web server

Apache

Database engine version

MariaDB

Additional info

No response

@daryljones daryljones added the bug label May 3, 2024
@asbiin
Copy link
Member

asbiin commented May 5, 2024

I don't see how version 4.1.0 could create that.
It's more related to an architecture/installation issue than a monica-related bug.
Anyway, I can't reproduce that.

@ljhanson
Copy link

I've tried this with a fresh install using the latest helm chart and have deployment issue on the migration on both PostgreSQL as well as MySQL.

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants