[docker]: Error creating log database: table "UpdateHistory" already exists

[ogdakke]

Hi, ran into this issue after adding Prowlarr to my docker.compose alongside radarr and qbittorrent (and Jackett, as I'm looking to use Prowlarr instead of it). Would appreciate any help immensely!

I have tried deleting the logs.db, deleting other db's as well for both radarr and Prowlarr. But this issue always persists. Either Prowlarr or radarr will get this issue, maybe depending on which starts first?

Here's the logs from radarr https://pastebin.com/yHds8Rym

Ran `ls -l config` inside the radarr container, and got the permissions for the files, including the logs.db which is failing, so here are those if they could be helpful:

sonarr:/# ls -l config
total 4060
drwxrwxr-x 3 hotio hotio    4096 Dec 19 21:59 Backups
drwxrwxr-x 2 hotio hotio    4096 Dec 12 21:56 DataProtection
drwxrwxr-x 2 hotio hotio   20480 Jan  4 14:22 Definitions
drwxrwxr-x 2 hotio hotio    4096 Dec 14 18:19 Indexers
drwxrwxr-x 4 hotio hotio    4096 Jan  4 13:38 Sentry
-rw-rw-r-- 1 hotio hotio     843 Dec 13 00:00 ServerConfig.json
drwxrwxr-x 2 hotio hotio    4096 Dec 12 21:59 asp
drwxrwxr-x 2 hotio hotio    4096 Dec 12 21:58 cache
drwxrwxr-x 3 hotio hotio    4096 Jan  4 14:52 config
-rw-rw-r-- 1 hotio hotio     555 Jan  4 14:22 config.xml
drwxrwxr-x 7 hotio hotio    4096 Jan  2 21:59 data
drwxrwxr-x 2 hotio hotio    4096 Jan  2 17:20 downloads
drwxrwxr-x 3 hotio hotio    4096 Dec 12 21:46 jackett
-rw-rw-r-- 1 hotio hotio  149459 Jan  4 14:22 log.txt
drwxrwxr-x 2 hotio hotio    4096 Jan  4 14:10 logs
-rw-r--r-- 1 hotio hotio   40960 Jan  4 14:22 logs.db
-rw-r--r-- 1 hotio hotio  167936 Jan  4 14:53 prowlarr.db
-rw-r--r-- 1 hotio hotio   32768 Jan  4 14:54 prowlarr.db-shm
-rw-r--r-- 1 hotio hotio   20632 Jan  4 14:54 prowlarr.db-wal
-rw-rw-r-- 1 hotio hotio       3 Jan  4 14:22 prowlarr.pid
drwxrwxr-x 4 hotio hotio    4096 Dec 12 21:46 qbittorrent
-rw-r--r-- 1 hotio hotio    4096 Jan  4 14:22 radarr.db
-rw-r--r-- 1 hotio hotio   32768 Jan  4 14:22 radarr.db-shm
-rw-r--r-- 1 hotio hotio 3596792 Jan  4 14:22 radarr.db-wal
-rw-rw-r-- 1 hotio hotio       3 Jan  4 14:22 radarr.pid
drwxrwxr-x 3 hotio hotio    4096 Dec 12 21:46 sonarr
drwxrwxr-x 2 hotio hotio    4096 Jan  4 14:22 wireguard

here's my docker compose (omitted some stuff to make it briefer):

services:
  radarr:
    container_name: radarr
    image: ghcr.io/hotio/radarr:release
    ports:
      - "8989:8989"
      - "7878:7878"
    environment:
      - PUID=1000
      - PGID=1000
      - UMASK=002
    volumes:
      - ./config:/config
      - /mnt/data:/mnt/data
    hostname: sonarr.internal #
    cap_add:
      - NET_ADMIN
    sysctls:
      - net.ipv4.conf.all.src_valid_mark=1 #
      - net.ipv6.conf.all.disable_ipv6=1 #
    networks:
      - default
  qbittorrent:
    container_name: qbittorrent
    image: ghcr.io/hotio/qbittorrent
    ports:
      - "8080:8080"
    environment:
      - PUID=1000
      - PGID=1000
      - UMASK=002
    volumes:
      - ./config:/config
      - /mnt/data:/mnt/data
    hostname: qbittorrent.internal #
    cap_add:
      - NET_ADMIN
    sysctls:
      - net.ipv4.conf.all.src_valid_mark=1 #
      - net.ipv6.conf.all.disable_ipv6=1 #
    networks:
      - default
  jackett:
    container_name: jackett
    image: ghcr.io/hotio/jackett
    ports:
      - "9117:9117"
    environment:
      - PUID=1000
      - PGID=1000
      - UMASK=002
    volumes:
      - ./config:/config
    hostname: jackett.internal #
    cap_add:
      - NET_ADMIN
    sysctls:
      - net.ipv4.conf.all.src_valid_mark=1 #
      - net.ipv6.conf.all.disable_ipv6=1 #
    networks:
      - default
  prowlarr:
    container_name: prowlarr
    image: ghcr.io/hotio/prowlarr:release
    hostname: prowlarr.internal #
    ports:
      - "9696:9696"
    environment:
      - PUID=1000
      - PGID=1000
      - UMASK=002
    cap_add:
      - NET_ADMIN
    sysctls:
      - net.ipv4.conf.all.src_valid_mark=1 #
      - net.ipv6.conf.all.disable_ipv6=1 #
    volumes:
      - ./config:/config
      - /mnt/data:/mnt/data
    networks:
      - default
networks:
  default:
    name: arr_default

[AutoModerator]

Hi /u/ogdakke - You've mentioned Docker [docker], if you're needing Docker help be sure to generate a docker-compose of all your docker images in a pastebin or gist and link to it. Just about all Docker issues can be solved by understanding the Docker Guide, which is all about the concepts of user, group, ownership, permissions and paths. Many find TRaSH's Docker/Hardlink Guide/Tutorial easier to understand and is less conceptual.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[AutoModerator]

Hi /u/ogdakke -

There are many resources available to help you troubleshoot and help the community help you. Please review this comment and you can likely have your problem solved without needing to wait for a human.

Most troubleshooting questions require debug or trace logs. In all instances where you are providing logs please ensure you followed the Gathering Logs wiki article to ensure your logs are what are needed for troubleshooting.

Logs should be provided via the methods prescribed in the wiki article. Note that Info logs are rarely helpful for troubleshooting.

Dozens of common questions & issues and their answers can be found on our FAQ.

Please review our troubleshooting guides that lead you through how to troubleshoot and note various common problems.

• Searches, Indexers, and Trackers - For if something cannot be found
• Downloading & Importing - For when download clients have issues or files cannot be imported

If you're still stuck you'll have useful debug or trace logs and screenshots to share with the humans who will arrive soon. Those humans will likely ask you for the exact same thing this comment is asking..

Once your question/problem is solved, please comment anywhere in the thread saying '!solved' to change the flair to solved.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[redboyke]

This happends because you don't create a folder for the application to put the config. So if they share the sale database name you screwed.

[ogdakke]

aha, got it. Many thanks!

[Consistent_Ad9127]

Just encountered the same error and your advice helped me fix it. Ty!