From 96be13bbdda6581c15319fdfbde1dbb9742e57f1 Mon Sep 17 00:00:00 2001
From: Paul Buetow <paul@buetow.org>
Date: Sat, 31 Jan 2026 12:23:04 +0200
Subject: Fix Jellyfin slow database: set SQLite locking mode to Optimistic

Amp-Thread-ID: https://ampcode.com/threads/T-019c1392-78a3-7440-9d95-1a1b2fd7dfec
Co-authored-by: Amp <amp@ampcode.com>
---
 f3s/jellyfin/helm-chart/templates/configmap.yaml  | 5 +++++
 f3s/jellyfin/helm-chart/templates/deployment.yaml | 9 +++++++++
 2 files changed, 14 insertions(+)

(limited to 'f3s')

diff --git a/f3s/jellyfin/helm-chart/templates/configmap.yaml b/f3s/jellyfin/helm-chart/templates/configmap.yaml
index 5ce6fe4..6248f7d 100644
--- a/f3s/jellyfin/helm-chart/templates/configmap.yaml
+++ b/f3s/jellyfin/helm-chart/templates/configmap.yaml
@@ -4,6 +4,11 @@ metadata:
   name: jellyfin-network-config
   namespace: services
 data:
+  database.xml: |
+    <?xml version="1.0" encoding="utf-8"?>
+    <SqliteOptions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
+      <LockMode>Optimistic</LockMode>
+    </SqliteOptions>
   network.xml: |
     <?xml version="1.0" encoding="utf-8"?>
     <NetworkConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
diff --git a/f3s/jellyfin/helm-chart/templates/deployment.yaml b/f3s/jellyfin/helm-chart/templates/deployment.yaml
index 0289dfe..cbed57e 100644
--- a/f3s/jellyfin/helm-chart/templates/deployment.yaml
+++ b/f3s/jellyfin/helm-chart/templates/deployment.yaml
@@ -33,6 +33,9 @@ spec:
               mountPath: /media/libraries
             - name: jellyfin-data
               mountPath: /data
+            - name: jellyfin-database-config
+              mountPath: /config/database.xml
+              subPath: database.xml
       volumes:
         - name: jellyfin-config
           persistentVolumeClaim:
@@ -43,6 +46,12 @@ spec:
         - name: jellyfin-data
           persistentVolumeClaim:
             claimName: jellyfin-data-pvc
+        - name: jellyfin-database-config
+          configMap:
+            name: jellyfin-network-config
+            items:
+              - key: database.xml
+                path: database.xml
 ---
 apiVersion: v1
 kind: Service
-- 
cgit v1.2.3