Pixelfed not starting, some kind of DB error it seems
Pixelfed
11
Posts
3
Posters
136
Views
3
Watching
-
It may have started with the Sept update. All my backups are only for the current version so I can't restore to an earlier version to see what happens. This is from the logs:
Oct 13 22:06:57 "} Oct 13 22:06:57 2025-10-13T15:06:57Z Oct 13 22:06:57 Illuminate\Database\QueryException Oct 13 22:06:57 2025-10-13T15:06:57Z Oct 13 22:06:57 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 13 22:06:57 2025-10-13T15:06:57Z Oct 13 22:06:57 at vendor/laravel/framework/src/Illuminate/Database/Connection.php:824 Oct 13 22:06:57 820▕ $this->getName(), $query, $this->prepareBindings($bindings), $e Oct 13 22:06:57 821▕ ); Oct 13 22:06:57 822▕ } Oct 13 22:06:57 823▕ Oct 13 22:06:57 ➜ 824▕ throw new QueryException( Oct 13 22:06:57 825▕ $this->getName(), $query, $this->prepareBindings($bindings), $e Oct 13 22:06:57 826▕ ); Oct 13 22:06:57 827▕ } Oct 13 22:06:57 828▕ } Oct 13 22:06:57 2025-10-13T15:06:57Z Oct 13 22:06:57 +9 vendor frames Oct 13 22:06:57 2025-10-13T15:06:57Z Oct 13 22:06:57 10 database/migrations/2025_04_08_103433_create_custom_filter_statuses_table.php:14 Oct 13 22:06:57 Illuminate\Support\Facades\Facade::__callStatic() Oct 13 22:06:57 +25 vendor frames Oct 13 22:06:57 2025-10-13T15:06:57Z Oct 13 22:06:57 36 artisan:35 Oct 13 22:06:57 Illuminate\Foundation\Console\Kernel::handle() Oct 13 22:06:57 2025-10-13T15:06:57ZAny ideas?
-
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() -
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.
