Pixelfed not starting, some kind of DB error it seems

[robi]

Seems like it has many uncomplete database migrations. Give it double the RAM temporarily and see if they complete. Watch the graphs to see how much it actually uses.

[scooke]

I gave it 6GB, and it still stalls on the one table already existing.

Oct 14 12:48:30 2025-10-14T05:48:30Z
Oct 14 12:48:30 Illuminate\Database\QueryException
Oct 14 12:48:30 2025-10-14T05:48:30Z
Oct 14 12:48:30 SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'custom_filter_statuses' already exists (Connection: mysql, SQL: create table `custom_filter_statuses` (`id` bigint unsigned not null auto_increment primary key, `custom_filter_id` bigint unsigned not null, `status_id` bigint unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
Oct 14 12:48:30 2025-10-14T05:48:30Z
Oct 14 12:48:30 at vendor/laravel/framework/src/Illuminate/Database/Connection.php:824
Oct 14 12:48:30 820▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
Oct 14 12:48:30 821▕ );
Oct 14 12:48:30 822▕ }
Oct 14 12:48:30 823▕
Oct 14 12:48:30 ➜ 824▕ throw new QueryException(
Oct 14 12:48:30 825▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
Oct 14 12:48:30 826▕ );
Oct 14 12:48:30 827▕ }
Oct 14 12:48:30 828▕ }
Oct 14 12:48:30 2025-10-14T05:48:30Z
Oct 14 12:48:30 +9 vendor frames
Oct 14 12:48:30 2025-10-14T05:48:30Z
Oct 14 12:48:30 10 database/migrations/2025_04_08_103433_create_custom_filter_statuses_table.php:14
Oct 14 12:48:30 Illuminate\Support\Facades\Facade::__callStatic()
Oct 14 12:48:30 +25 vendor frames
Oct 14 12:48:30 2025-10-14T05:48:30Z
Oct 14 12:48:30 36 artisan:35
Oct 14 12:48:30 Illuminate\Foundation\Console\Kernel::handle()
Oct 14 12:48:30 2025-10-14T05:48:30Z
Oct 14 12:48:43 ==> Creating directories
Oct 14 12:48:43 ==> Creating caches
Oct 14 12:48:44 2025-10-14T05:48:44Z
Oct 14 12:48:44 INFO Configuration cached successfully.
Oct 14 12:48:44 2025-10-14T05:48:44Z
Oct 14 12:48:45 2025-10-14T05:48:45Z
Oct 14 12:48:45 INFO Application cache cleared successfully.
Oct 14 12:48:45 2025-10-14T05:48:45Z
Oct 14 12:48:46 2025-10-14T05:48:46Z
Oct 14 12:48:46 INFO Routes cached successfully.
Oct 14 12:48:46 2025-10-14T05:48:46Z
Oct 14 12:48:47 2025-10-14T05:48:47Z
Oct 14 12:48:47 2025-10-14T05:48:47Z
Oct 14 12:48:47 INFO Blade templates cached successfully.
Oct 14 12:48:47 2025-10-14T05:48:47Z
Oct 14 12:48:47 ==> Running migrations
Oct 14 12:48:48 2025-10-14T05:48:48Z
Oct 14 12:48:48 INFO Running migrations.
Oct 14 12:48:48 2025-10-14T05:48:48Z
Oct 14 12:48:48 2025_04_08_103433_create_custom_filter_statuses_table ......... 25.95ms FAIL
Oct 14 12:48:48 [2025-10-14 05:48:48] production.ERROR: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'custom_filter_statuses' already exists (Connection: mysql, SQL: create table `custom_filter_statuses` (`id` bigint unsigned not null auto_increment primary key, `custom_filter_id` bigint unsigned not null, `status_id` bigint unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci') {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S01): SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'custom_filter_statuses' already exists (Connection: mysql, SQL: create table `custom_filter_statuses` (`id` bigint unsigned not null auto_increment primary key, `custom_filter_id` bigint unsigned not null, `status_id` bigint unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci') at /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:824)
Oct 14 12:48:48 [stacktrace]
Oct 14 12:48:48 #0 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(778): Illuminate\\Database\\Connection->runQueryCallback()
Oct 14 12:48:48 #1 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(559): Illuminate\\Database\\Connection->run()
Oct 14 12:48:48 #2 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(119): Illuminate\\Database\\Connection->statement()
Oct 14 12:48:48 #3 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(618): Illuminate\\Database\\Schema\\Blueprint->build()
Oct 14 12:48:48 #4 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(472): Illuminate\\Database\\Schema\\Builder->build()
Oct 14 12:48:48 #5 /app/code/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\\Database\\Schema\\Builder->create()
Oct 14 12:48:48 #6 /app/code/database/migrations/2025_04_08_103433_create_custom_filter_statuses_table.php(14): Illuminate\\Support\\Facades\\Facade::__callStatic()
Oct 14 12:48:48 #7 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(514): Illuminate\\Database\\Migrations\\Migration@anonymous->up()
Oct 14 12:48:48 #8 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(439): Illuminate\\Database\\Migrations\\Migrator->runMethod()
Oct 14 12:48:48 #9 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(448): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
Oct 14 12:48:48 #10 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\\Database\\Migrations\\Migrator->runMigration()
Oct 14 12:48:48 #11 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(41): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
Oct 14 12:48:48 #12 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(809): Illuminate\\Console\\View\\Components\\Task->render()
Oct 14 12:48:48 #13 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\\Database\\Migrations\\Migrator->write()
Oct 14 12:48:48 #14 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210): Illuminate\\Database\\Migrations\\Migrator->runUp()
Oct 14 12:48:48 #15 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(137): Illuminate\\Database\\Migrations\\Migrator->runPending()
Oct 14 12:48:48 #16 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\\Database\\Migrations\\Migrator->run()
Oct 14 12:48:48 #17 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(666): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
Oct 14 12:48:48 #18 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
Oct 14 12:48:48 #19 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
Oct 14 12:48:48 #20 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
Oct 14 12:48:48 #21 /app/code/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
Oct 14 12:48:48 #22 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure()
Oct 14 12:48:48 #23 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
Oct 14 12:48:48 #24 /app/code/vendor/laravel/framework/src/Illuminate/Container/Container.php(780): Illuminate\\Container\\BoundMethod::call()
Oct 14 12:48:48 #25 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()
Oct 14 12:48:48 #26 /app/code/vendor/symfony/console/Command/Command.php(318): Illuminate\\Console\\Command->execute()
Oct 14 12:48:48 #27 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()
Oct 14 12:48:48 #28 /app/code/vendor/symfony/console/Application.php(1092): Illuminate\\Console\\Command->run()
Oct 14 12:48:48 #29 /app/code/vendor/symfony/console/Application.php(341): Symfony\\Component\\Console\\Application->doRunCommand()
Oct 14 12:48:48 #30 /app/code/vendor/symfony/console/Application.php(192): Symfony\\Component\\Console\\Application->doRun()
Oct 14 12:48:48 #31 /app/code/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()
Oct 14 12:48:48 #32 /app/code/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
Oct 14 12:48:48 #33 {main}
Oct 14 12:48:48 2025-10-14T05:48:48Z
Oct 14 12:48:48 [previous exception] [object] (PDOException(code: 42S01): SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'custom_filter_statuses' already exists at /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:570)
Oct 14 12:48:48 [stacktrace]
Oct 14 12:48:48 #0 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(570): PDOStatement->execute()
Oct 14 12:48:48 #1 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(811): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
Oct 14 12:48:48 #2 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(778): Illuminate\\Database\\Connection->runQueryCallback()
Oct 14 12:48:48 #3 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(559): Illuminate\\Database\\Connection->run()
Oct 14 12:48:48 #4 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(119): Illuminate\\Database\\Connection->statement()
Oct 14 12:48:48 #5 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(618): Illuminate\\Database\\Schema\\Blueprint->build()
Oct 14 12:48:48 #6 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(472): Illuminate\\Database\\Schema\\Builder->build()
Oct 14 12:48:48 #7 /app/code/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\\Database\\Schema\\Builder->create()
Oct 14 12:48:48 #8 /app/code/database/migrations/2025_04_08_103433_create_custom_filter_statuses_table.php(14): Illuminate\\Support\\Facades\\Facade::__callStatic()
Oct 14 12:48:48 #9 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(514): Illuminate\\Database\\Migrations\\Migration@anonymous->up()
Oct 14 12:48:48 #10 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(439): Illuminate\\Database\\Migrations\\Migrator->runMethod()
Oct 14 12:48:48 #11 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(448): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
Oct 14 12:48:48 #12 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\\Database\\Migrations\\Migrator->runMigration()
Oct 14 12:48:48 #13 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(41): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
Oct 14 12:48:48 #14 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(809): Illuminate\\Console\\View\\Components\\Task->render()
Oct 14 12:48:48 #15 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\\Database\\Migrations\\Migrator->write()
Oct 14 12:48:48 #16 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210): Illuminate\\Database\\Migrations\\Migrator->runUp()
Oct 14 12:48:48 #17 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(137): Illuminate\\Database\\Migrations\\Migrator->runPending()
Oct 14 12:48:48 #18 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\\Database\\Migrations\\Migrator->run()
Oct 14 12:48:48 #19 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(666): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
Oct 14 12:48:48 #20 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
Oct 14 12:48:48 #21 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
Oct 14 12:48:48 #22 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
Oct 14 12:48:48 #23 /app/code/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
Oct 14 12:48:48 #24 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure()
Oct 14 12:48:48 #25 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
Oct 14 12:48:48 #26 /app/code/vendor/laravel/framework/src/Illuminate/Container/Container.php(780): Illuminate\\Container\\BoundMethod::call()
Oct 14 12:48:48 #27 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()
Oct 14 12:48:48 #28 /app/code/vendor/symfony/console/Command/Command.php(318): Illuminate\\Console\\Command->execute()
Oct 14 12:48:48 #29 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()
Oct 14 12:48:48 #30 /app/code/vendor/symfony/console/Application.php(1092): Illuminate\\Console\\Command->run()
Oct 14 12:48:48 #31 /app/code/vendor/symfony/console/Application.php(341): Symfony\\Component\\Console\\Application->doRunCommand()
Oct 14 12:48:48 #32 /app/code/vendor/symfony/console/Application.php(192): Symfony\\Component\\Console\\Application->doRun()
Oct 14 12:48:48 #33 /app/code/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()
Oct 14 12:48:48 #34 /app/code/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
Oct 14 12:48:48 #35 {main}
Oct 14 12:48:48 "}
Oct 14 12:48:48 2025-10-14T05:48:48Z
Oct 14 12:48:48 Illuminate\Database\QueryException
Oct 14 12:48:48 2025-10-14T05:48:48Z
Oct 14 12:48:48 SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'custom_filter_statuses' already exists (Connection: mysql, SQL: create table `custom_filter_statuses` (`id` bigint unsigned not null auto_increment primary key, `custom_filter_id` bigint unsigned not null, `status_id` bigint unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
Oct 14 12:48:48 2025-10-14T05:48:48Z
Oct 14 12:48:48 at vendor/laravel/framework/src/Illuminate/Database/Connection.php:824
Oct 14 12:48:48 820▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
Oct 14 12:48:48 821▕ );
Oct 14 12:48:48 822▕ }
Oct 14 12:48:48 823▕
Oct 14 12:48:48 ➜ 824▕ throw new QueryException(
Oct 14 12:48:48 825▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
Oct 14 12:48:48 826▕ );
Oct 14 12:48:48 827▕ }
Oct 14 12:48:48 828▕ }
Oct 14 12:48:48 2025-10-14T05:48:48Z
Oct 14 12:48:48 +9 vendor frames
Oct 14 12:48:48 2025-10-14T05:48:48Z
Oct 14 12:48:48 10 database/migrations/2025_04_08_103433_create_custom_filter_statuses_table.php:14
Oct 14 12:48:48 Illuminate\Support\Facades\Facade::__callStatic()
Oct 14 12:48:48 +25 vendor frames
Oct 14 12:48:48 2025-10-14T05:48:48Z
Oct 14 12:48:48 36 artisan:35
Oct 14 12:48:48 Illuminate\Foundation\Console\Kernel::handle()

[scooke]

Am I gonna have to go into that db manually and do something?

[robi]

Yep, probably.. unless you can restore from a good backup.

[james]

Hello @scooke
Can you please share with my what cloudron app package version of Pixelfed you were running before the update so I can attempt reproducing this issue?

[scooke]

It was updated to package version 1.22.2 on 09/06/2025, and it seems the problem started then. So, whatever version was before 1.22.2. Based on the Alerts in my Cloudron, the previous update was updated to package version 1.22.0 on 06/14/2025. So the jump from 1.22.0 to 1.22.2 did something, it seems.

[scooke]

@robi Unfortunately my backup duration is only a month, so all I have are 1.22.2 backups, and I've tried a few of them but the same issue occurs.

[james]

Hello @scooke
Thanks for that. I will look into it and try to reproduce your issue.

[scooke]

@james Any luck?

[james]

Hello @scooke
Sorry, I was not able to start working on this issue yet.