search

CyferShepard / Jellystat

Jellystat is a free and open source Statistics App for Jellyfin
MIT License
1.09k stars 32 forks source link

Error occurred while executing query: duplicate key value violates unique constraint "app_config_pkey" #230

Open JonasunderscoreJones opened 3 months ago

JonasunderscoreJones commented 3 months ago

Describe the bug When setting up the docker image of jellystat and creating a new user in First Time Setup Step 1 of 2 and hitting "Create User" the page refreshes to the exact same prompt and I get the following error message in the logs:

[JELLYSTAT]: Error occurred while executing query: duplicate key value violates unique constraint "app_config_pkey"

I have created the docker container with docker-compose.yaml and the default configuration.

Environment Details (please complete the following information):

To Reproduce Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Task Logs If applicable, add Task Logs for your problem.

Container Logs If applicable, add Container Logs for your problem.

Additional context Add any other context about the problem here.

MBR-0001 commented 3 months ago

I had the same thing happen to me, I fixed it by deleting the database (by default /postgres-data), starting the db container and waiting for it to init, after 30s I ran the second container and it worked