CyferShepard / Jellystat

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

Databank keeps crashing #174

Open neuleo opened 7 months ago

neuleo commented 7 months ago

Describe the bug My Data bank keeps crashing with the same Error over and over and i don't understand why

Environment Details (please complete the following information):

Docker Config version: '3' services: jellystat-db: image: postgres:15.2 environment: POSTGRES_DB: 'xxx' POSTGRES_USER: xxx POSTGRES_PASSWORD: xxx volumes:

networks: codeserver_default: external: true

To Reproduce Steps to reproduce the behavior:

  1. Set up a fresh instance
  2. Wait until it crashes (At least for me)

Expected behavior My Data bank keeps crashing, and I couldn't figure out why. So I did a fresh install and imported my old Backup. But I get the same Error.

Task Logs PostgreSQL Database directory appears to contain a database; Skipping initialization 2024-02-25 22:39:39.102 UTC [1] LOG: starting PostgreSQL 15.2 (Debian 15.2-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit 2024-02-25 22:39:39.102 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-02-25 22:39:39.102 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-02-25 22:39:39.107 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-02-25 22:39:39.117 UTC [29] LOG: database system was shut down at 2024-02-25 22:39:27 UTC 2024-02-25 22:39:39.130 UTC [1] LOG: database system is ready to accept connections 2024-02-25 22:39:44.575 UTC [33] ERROR: database "jfstat" already exists 2024-02-25 22:39:44.575 UTC [33] STATEMENT: CREATE DATABASE jfstat

Additional context I think this is the Problem: "ERROR: database "jfstat" already exists" but I have no Idea how to fix that.

CyferShepard commented 7 months ago

Hey @neuleo , that error is fine, all its saying is we tried to create the database but it found an existing one, this is then handled inside jellystat to proceed with the rest of the setup. Do you have any other logs that could help? Are you sure the database is crashing and not jellystat itself? You will have to also check in the Postgres forums for help as this issue doesn't really look like its related to jellystat from what i can see.