Skip to content
New issue

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

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

Already on GitHub? Sign in to your account

Unable to init with postgres #117

Open
xeruf opened this issue Jan 17, 2022 · 2 comments
Open

Unable to init with postgres #117

xeruf opened this issue Jan 17, 2022 · 2 comments

Comments

@xeruf
Copy link

xeruf commented Jan 17, 2022

❯ sudo docker-compose -f ./docker-compose.postgres.yml up -d
Starting koel_database_1 ... done
Starting koel_koel_1     ... done
❯ sudo docker ps
CONTAINER ID   IMAGE         COMMAND                  CREATED             STATUS                    PORTS                                 NAMES
d762f1325c44   hyzual/koel   "koel-entrypoint apa…"   About an hour ago   Up 36 minutes (healthy)   0.0.0.0:380->80/tcp, :::380->80/tcp   koel_koel_1
912a728dd875   postgres:13   "docker-entrypoint.s…"   About an hour ago   Up 36 minutes             5432/tcp                              koel_database_1
❯ sudo docker exec --user www-data -it koel_koel_1 bash
www-data@d762f1325c44:~/html$ php artisan koel:init --no-assets
Attempting to install or upgrade Koel.
Remember, you can always install/upgrade manually following the guide here:
📙  https://docs.koel.dev

App key exists -- skipping
Migrating database
Oops! Koel installation or upgrade didn't finish successfully.
Please try again, or visit https://docs.koel.dev for manual installation.
😥 Sorry for this. You deserve better.
@xeruf
Copy link
Author

xeruf commented Jan 17, 2022

Corresponding output from the container:

database_1  | 2022-01-17 17:39:37.068 UTC [116] ERROR:  cannot drop index artists_name_unique because constraint artists_name_unique on table artists requires it
database_1  | 2022-01-17 17:39:37.068 UTC [116] HINT:  You can drop constraint artists_name_unique on table artists instead.
database_1  | 2022-01-17 17:39:37.068 UTC [116] STATEMENT:  drop index "artists_name_unique"
database_1  | 2022-01-17 17:39:37.068 UTC [116] ERROR:  current transaction is aborted, commands ignored until end of transaction block
database_1  | 2022-01-17 17:39:37.068 UTC [116] STATEMENT:  DEALLOCATE pdo_stmt_00000008

@Hyzual
Copy link
Collaborator

Hyzual commented Jan 19, 2022

Hi @xeruf, it does not look like the problem lies with the Docker image and more with koel's code. Unfortunately it looks like I cannot transfer this issue to koel/koel, could you please open an issue there ?
I could not find an existing issue similar to this. I cannot help you further as I'm not familiar with Postgres or the database code for Koel 😕.

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

No branches or pull requests

2 participants