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>

3 files changed, 37 insertions, 23 deletions

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
diff --git a/frontends/etc/relayd.conf.tpl b/frontends/etc/relayd.conf.tpl
index 59f9b90..90a0266 100644
--- a/frontends/etc/relayd.conf.tpl
+++ b/frontends/etc/relayd.conf.tpl
@@ -106,29 +106,29 @@ relay "https6" {
 
 # Jellyfin alternative ports for Android app discovery
 # Use the same "https" protocol to get X-Forwarded headers
-relay "jellyfin-8096-ipv4" {
-    listen on <%= $vio0_ip %> port 8096 tls
-    protocol "https"
-    forward to <f3s_jellyfin> port 30096 check tcp
-}
-
-relay "jellyfin-8096-ipv6" {
-    listen on <%= $ipv6address->($hostname) %> port 8096 tls
-    protocol "https"
-    forward to <f3s_jellyfin> port 30096 check tcp
-}
-
-relay "jellyfin-8920-ipv4" {
-    listen on <%= $vio0_ip %> port 8920 tls
-    protocol "https"
-    forward to <f3s_jellyfin> port 30096 check tcp
-}
-
-relay "jellyfin-8920-ipv6" {
-    listen on <%= $ipv6address->($hostname) %> port 8920 tls
-    protocol "https"
-    forward to <f3s_jellyfin> port 30096 check tcp
-}
+# relay "jellyfin-8096-ipv4" {
+#     listen on <%= $vio0_ip %> port 8096 tls
+#     protocol "https"
+#     forward to <f3s_jellyfin> port 30096 check tcp
+# }
+
+# relay "jellyfin-8096-ipv6" {
+#     listen on <%= $ipv6address->($hostname) %> port 8096 tls
+#     protocol "https"
+#     forward to <f3s_jellyfin> port 30096 check tcp
+# }
+
+# relay "jellyfin-8920-ipv4" {
+#     listen on <%= $vio0_ip %> port 8920 tls
+#     protocol "https"
+#     forward to <f3s_jellyfin> port 30096 check tcp
+# }
+
+# relay "jellyfin-8920-ipv6" {
+#     listen on <%= $ipv6address->($hostname) %> port 8920 tls
+#     protocol "https"
+#     forward to <f3s_jellyfin> port 30096 check tcp
+# }
 
 tcp protocol "gemini" {
     tls keypair foo.zone