Failed to prepare your database:

[Z-Loft]

⚠️ Please verify that this bug has NOT been raised before.

• I checked and didn't find similar issue

🛡️ Security Policy

• I agree to have read this project Security Policy

📝 Describe your problem

My container is throwing an error when running dockge from a CIFS mounted via fstab. I dont get any error when running from /opt

I

File/folder permissions seem to be the same. Ubuntu 24

📝 Error Message(s) or Log

/etc/fstab/
//10.40.1.201/VOL-SSD /mnt/Z-LOFT/VOL-SSD cifs credentials=/home/neptune/.DKR-ADMIN-CRED 0 0

neptune@FRG-DKR-01:/mnt/Z-LOFT/VOL-SSD/dockge$ ls -la
total 1
drwxr-xr-x 2 root root 0 Aug 9 22:57 .
drwxr-xr-x 2 root root 0 Aug 9 22:55 ..
-rwxr-xr-x 1 root root 638 Aug 9 22:57 compose.yaml
drwxr-xr-x 2 root root 0 Aug 9 22:57 data
neptune@FRG-DKR-01:/mnt/Z-LOFT/VOL-SSD/dockge$

neptune@FRG-DKR-01:/mnt/Z-LOFT/VOL-SSD/dockge$ cat compose.yaml
version: "3.8"
services:
dockge:
image: louislam/dockge:1
restart: unless-stopped
ports:
- 5001:5001
volumes:
- /var/run/docker.sock:/var/run/docker.sock
- ./data:/app/data
# Stacks Directory
# ⚠️ READ IT CAREFULLY. If you did it wrong, your data could end up writing into a WRONG PATH.
# ⚠️ 1. FULL path only. No relative path (MUST)
# ⚠️ 2. Left Stacks Path === Right Stacks Path (MUST)
- /mnt/Z-LOFT/VOL-SSD/stacks:/mnt/Z-LOFT/VOL-SSD/stacks
environment:
# Tell Dockge where to find the stacks
- DOCKGE_STACKS_DIR=/mnt/Z-LOFT/VOL-SSD/stacks

neptune@FRG-DKR-01:/mnt/Z-LOFT/VOL-SSD/dockge$ docker compose up
WARN[0000] /mnt/Z-LOFT/VOL-SSD/dockge/compose.yaml: the attribute version is obsolete, it will be ignored, please remove it to avoid potential confusion
[+] Running 1/1
✔ Container dockge-dockge-1 Recreated 0.1s
Attaching to dockge-1
dockge-1 | 2024-08-10T03:57:55Z [SERVER] INFO: Welcome to dockge!
dockge-1 | 2024-08-10T03:57:55Z [SERVER] INFO: NODE_ENV: production
dockge-1 | 2024-08-10T03:57:55Z [SERVER] INFO: Server Type: HTTP
dockge-1 | 2024-08-10T03:57:55Z [SERVER] INFO: Data Dir: ./data/
dockge-1 | 2024-08-10T03:57:55Z [DB] WARN: ENOENT: no such file or directory, open 'data/db-config.json'
dockge-1 | 2024-08-10T03:57:55Z [DB] INFO: Database Type: sqlite
dockge-1 | 2024-08-10T03:57:57Z [SERVER] ERROR: Failed to prepare your database: PRAGMA journal_mode = WAL - SQLITE_BUSY: database is locked

🐻 Dockge Version

1.4.2

💻 Operating System and Arch

Ubuntu 24 LTS

🌐 Browser

Chrome

🐋 Docker Version

Docker 27.1.1

🟩 NodeJS Version

No response

[Z-Loft]

So the issue is that SQL does not like running over a networked file system CIFS or NFS. In sort the locking does not work as needed by SQL.

The solution for a single process SQL is to mount the share with locking disabled. On CIFS that’s via the nobtl option.

I learned about it via this article