Update 7.0.1 failed
-
Hello,
My Koel application was automatically updated last night. I noticed the discussions on Koel's GitHub yesterday regarding an issue with Laravel migration. It seems that the error is still persisting for me.
There's my app log :
Jul 12 10:20:36 ==> Initializing or migrating koel Jul 12 10:20:36 ************************************ <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - * KOEL INSTALLATION WIZARD * <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - ************************************ <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - As a reminder, you can always install/upgrade manually following the guide at https://docs.koel.dev <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - Jul 12 10:20:36 <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - INFO Running in no-interaction mode. <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - Jul 12 10:20:36 Clearing caches ................................................... 3ms DONE Jul 12 10:20:36 .env file exists -- skipping .......................................... DONE Jul 12 10:20:36 Retrieving app key ................................................ 0ms DONE Jul 12 10:20:36 Using app key: base64:3GDdd3xI5.. ..................................... DONE Jul 12 10:20:36 Migrating database ............................................... 12ms FAIL Jul 12 10:20:36 <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - ERROR Oops! Koel installation or upgrade didn't finish successfully. <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - Jul 12 10:20:36 ERROR Please check the error log at storage/logs/laravel.log and try again. <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - Jul 12 10:20:36 ERROR For further troubleshooting, visit https://docs.koel.dev/troubleshooting. <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - Jul 12 10:20:36 ERROR 😥 Sorry for this. You deserve better. <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - Jul 12 10:20:47 => Healtheck error: Error: Timeout of 7000ms exceeded Jul 12 10:20:53 => Healtheck error: Error: connect EHOSTUNREACH 172.18.18.151:8000all logs that I can find here : https://www.swisstransfer.com/d/ac00d043-07f6-45f4-8d60-ffbfdfd16fef
-
The directory doesn't exist. As soon as I set the app in recovery mode. I lost this file, I guess.My bad, I just forgot to start the app.
This is the log that I can find :[2024-07-12 11:51:31] production.ERROR: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'position' in /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:587 Stack trace: #0 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(587): PDOStatement->execute() #1 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(816): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback() #3 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(588): Illuminate\Database\Connection->run() #4 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(110): Illuminate\Database\Connection->statement() #5 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(602): Illuminate\Database\Schema\Blueprint->build() #6 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(444): Illuminate\Database\Schema\Builder->build() #7 /app/code/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(355): Illuminate\Database\Schema\Builder->table() #8 /app/code/database/migrations/2024_01_27_171649_add_position_into_playlists_table.php(13): Illuminate\Support\Facades\Facade::__callStatic() #9 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(493): Illuminate\Database\Migrations\Migration@anonymous->up() #10 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(410): Illuminate\Database\Migrations\Migrator->runMethod() #11 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(419): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() #12 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\Database\Migrations\Migrator->runMigration() #13 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() #14 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(756): Illuminate\Console\View\Components\Task->render() #15 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\Database\Migrations\Migrator->write() #16 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(181): Illuminate\Database\Migrations\Migrator->runUp() #17 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(124): Illuminate\Database\Migrations\Migrator->runPending() #18 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(92): Illuminate\Database\Migrations\Migrator->run() #19 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(633): Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations\{closure}() #20 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(104): Illuminate\Database\Migrations\Migrator->usingConnection() #21 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle() #22 /app/code/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #23 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #24 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #25 /app/code/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call() #26 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call() #27 /app/code/vendor/symfony/console/Command/Command.php(326): Illuminate\Console\Command->execute() #28 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\Component\Console\Command\Command->run() #29 /app/code/vendor/symfony/console/Application.php(1096): Illuminate\Console\Command->run() #30 /app/code/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand() #31 /app/code/vendor/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun() #32 /app/code/vendor/laravel/framework/src/Illuminate/Console/Application.php(163): Symfony\Component\Console\Application->run() #33 /app/code/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(400): Illuminate\Console\Application->call() #34 /app/code/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(355): Illuminate\Foundation\Console\Kernel->call() #35 /app/code/app/Console/Commands/InitCommand.php(273): Illuminate\Support\Facades\Facade::__callStatic() #36 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): App\Console\Commands\InitCommand::App\Console\Commands\{closure}() #37 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Factory.php(58): Illuminate\Console\View\Components\Task->render() #38 /app/code/app/Console/Commands/InitCommand.php(274): Illuminate\Console\View\Components\Factory->__call() #39 /app/code/app/Console/Commands/InitCommand.php(62): App\Console\Commands\InitCommand->migrateDatabase() #40 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\InitCommand->handle() #41 /app/code/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #42 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #43 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #44 /app/code/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call() #45 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call() #46 /app/code/vendor/symfony/console/Command/Command.php(326): Illuminate\Console\Command->execute() #47 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\Component\Console\Command\Command->run() #48 /app/code/vendor/symfony/console/Application.php(1096): Illuminate\Console\Command->run() #49 /app/code/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand() #50 /app/code/vendor/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun() #51 /app/code/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\Component\Console\Application->run() #52 /app/code/artisan(35): Illuminate\Foundation\Console\Kernel->handle() #53 {main} Next Illuminate\Database\QueryException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'position' (Connection: mysql, SQL: alter table `playlist_song` add `position` int unsigned not null default '0') in /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829 Stack trace: #0 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback() #1 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(588): Illuminate\Database\Connection->run() #2 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(110): Illuminate\Database\Connection->statement() #3 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(602): Illuminate\Database\Schema\Blueprint->build() #4 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(444): Illuminate\Database\Schema\Builder->build() #5 /app/code/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(355): Illuminate\Database\Schema\Builder->table() #6 /app/code/database/migrations/2024_01_27_171649_add_position_into_playlists_table.php(13): Illuminate\Support\Facades\Facade::__callStatic() #7 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(493): Illuminate\Database\Migrations\Migration@anonymous->up() #8 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(410): Illuminate\Database\Migrations\Migrator->runMethod() #9 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(419): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() #10 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\Database\Migrations\Migrator->runMigration() #11 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() #12 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(756): Illuminate\Console\View\Components\Task->render() #13 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\Database\Migrations\Migrator->write() #14 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(181): Illuminate\Database\Migrations\Migrator->runUp() #15 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(124): Illuminate\Database\Migrations\Migrator->runPending() #16 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(92): Illuminate\Database\Migrations\Migrator->run() #17 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(633): Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations\{closure}() #18 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(104): Illuminate\Database\Migrations\Migrator->usingConnection() #19 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle() #20 /app/code/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #21 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #22 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #23 /app/code/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call() #24 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call() #25 /app/code/vendor/symfony/console/Command/Command.php(326): Illuminate\Console\Command->execute() #26 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\Component\Console\Command\Command->run() #27 /app/code/vendor/symfony/console/Application.php(1096): Illuminate\Console\Command->run() #28 /app/code/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand() #29 /app/code/vendor/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun() #30 /app/code/vendor/laravel/framework/src/Illuminate/Console/Application.php(163): Symfony\Component\Console\Application->run() #31 /app/code/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(400): Illuminate\Console\Application->call() #32 /app/code/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(355): Illuminate\Foundation\Console\Kernel->call() #33 /app/code/app/Console/Commands/InitCommand.php(273): Illuminate\Support\Facades\Facade::__callStatic() #34 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): App\Console\Commands\InitCommand::App\Console\Commands\{closure}() #35 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Factory.php(58): Illuminate\Console\View\Components\Task->render() #36 /app/code/app/Console/Commands/InitCommand.php(274): Illuminate\Console\View\Components\Factory->__call() #37 /app/code/app/Console/Commands/InitCommand.php(62): App\Console\Commands\InitCommand->migrateDatabase() #38 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\InitCommand->handle() #39 /app/code/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #40 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #41 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #42 /app/code/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call() #43 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call() #44 /app/code/vendor/symfony/console/Command/Command.php(326): Illuminate\Console\Command->execute() #45 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\Component\Console\Command\Command->run() #46 /app/code/vendor/symfony/console/Application.php(1096): Illuminate\Console\Command->run() #47 /app/code/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand() #48 /app/code/vendor/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun() #49 /app/code/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\Component\Console\Application->run() #50 /app/code/artisan(35): Illuminate\Foundation\Console\Kernel->handle() #51 {main} -
Thanks for your response. I have found a clear response to the problem and address it on the github : https://github.com/koel/koel/issues/1780
-
I resolved the issue by editing the migration that won't run.
You can mark this thread as completed.For those who might be had the same issue. I will address a PR in the GitHub of the koel project, with a various fixes and refactor of the Laravel migration to make them bulletproof.
-
N nebulon marked this topic as a question on
-
N nebulon has marked this topic as solved on