Question about mount points and database file

[Aetherinox]

Probably an odd question.

Much like with Jellyfin and other apps that I need to store data on, I keep ROMs and games on a network shared drive (NFS). I then share that drive with my Linux server with docker so that it can access the files.

SQLite3 will not allow you to store a database file on a shared samba drive. It will throw an error that the database is locked.

In your image, it appears you keep the sqlite database and the folder where the ROMs will go in the same location. I've tried to manually specify each one, but it doesn't work:

    retro:
        container_name: ${RETRO_CONTAINER:-retro}
        image: ${RETRO_IMAGE:-arianrhodsandlot/retroassembly}:${RETRO_TAG:-latest}
        restart: unless-stopped
        volumes:
            - /etc/timezone:/etc/timezone:ro
            - /etc/localtime:/etc/localtime:ro
            - /var/run/docker.sock:/var/run/docker.sock
            - /server/multimedia/games:/app/data:rw
            - ./database/retroassembly.sqlite:/app/data/retroassembly.sqlite

However, this doesn't work and just throws the error:

Error response from daemon: failed to create task for container: failed to create shim task: OCI runtime create failed: runc create failed: unable to start container process: error during container init: error mounting "/home/docker/retro/database/retroassembly.sqlite" to rootfs at "/app/data/retroassembly.sqlite": mount src=/home/docker/retro/database/retroassembly.sqlite, dst=/app/data/retroassembly.sqlite, dstFd=/proc/thread-self/fd/8, flags=0x5000: not a directory: unknown: Are you trying to mount a directory onto a file (or vice-versa)? Check if the specified host path exists and is the expected type

Is their any way that I could break these two mount points up? I want to mount the sqlite3 database file from a local folder. But then share my ROMs from my shared drive, which doesn't support sqlite3 storage.

I assume you also use this to store save points for games played. I uploaded one and looked in the image, and it stores to /app/data/storage/roms

I also noticed unless I'm blind, I don't see a way to delete a ROM from the list. I'm going to go look harder just to make sure it's not somewhere I missed. Alright, I found it, you have to right-click on the ROM in the menu. Perhaps maybe a delete button next to the play button when you click the ROM would also help.

[arianrhodsandlot]

Now we don't support setting database and storage to different directories. I think I can add support for this later. And if you are not storing plenty of games, putting them together with the database can be ok as retro games are not as big as videos for jellyfin.

[Aetherinox]

Yeah right now they're all together. It's only like 104 games. Just helps to keep everything structured how I normally do, because that mounted drive is also accessible from other machines and just makes it easier. All media gets categorized and put in the same location.

Having that ability later would be great.

[marcreichman-pfi]

@Aetherinox can you try :shared?

[grosbedos]

Hi,

Thanks, it's working with :shared !