Why does DB initialization keep failing due to OOM (Out Of Memory)?

[seowon-lee]

I'm trying to deploy LogChef as a pod on Kubernetes, but I'm consistently encountering failures during SQLite initialization

Here are the logs from the pod:

{"time":"2025-05-15T12:17:00.782072187Z","level":"INFO","source":{"function":"main.main","file":"/home/karan/Code/Personal/logchef/cmd/server/main.go","line":24},"msg":"starting logchef","buildInfo":"v0.1.0-alpha.4 (e92a129e 2025-04-25T11:20:54Z, linux/amd64)"}
{"time":"2025-05-15T12:17:00.782649387Z","level":"ERROR","source":{"function":"github.com/mr-karan/logchef/internal/sqlite.New","file":"/home/karan/Code/Personal/logchef/internal/sqlite/sqlite.go","line":66},"msg":"failed to set pragmas on main database","component":"sqlite","error":"error setting pragma \"PRAGMA busy_timeout = 5000\": unable to open database file: out of memory (14)"}
{"time":"2025-05-15T12:17:00.782679547Z","level":"DEBUG","source":{"function":"github.com/mr-karan/logchef/internal/sqlite.New.func1","file":"/home/karan/Code/Personal/logchef/internal/sqlite/sqlite.go","line":53},"msg":"closing main database due to initialization error","component":"sqlite"}
{"time":"2025-05-15T12:17:00.782689747Z","level":"ERROR","source":{"function":"github.com/mr-karan/logchef/internal/app.Run","file":"/home/karan/Code/Personal/logchef/internal/app/run.go","line":25},"msg":"failed to initialize application","error":"failed to initialize sqlite: error setting pragmas on main database: error setting pragma \"PRAGMA busy_timeout = 5000\": unable to open database file: out of memory (14)"}
{"time":"2025-05-15T12:17:00.782696445Z","level":"ERROR","source":{"function":"main.main","file":"/home/karan/Code/Personal/logchef/cmd/server/main.go","line":32},"msg":"application error","error":"failed to initialize sqlite: error setting pragmas on main database: error setting pragma \"PRAGMA busy_timeout = 5000\": unable to open database file: out of memory (14)"}

config.toml:

...
    [sqlite]
    path = "/data/local.db"
...
[auth]
admin_emails = ["[email protected]"]
session_duration = "24h"
max_concurrent_sessions = 1
...

deployment.yaml:

...
    spec:
      containers:
        - name: logchef
          image: "mrkaran/logchef:v0.1.0-rc.1-amd64"
          imagePullPolicy: IfNotPresent
          ports:
            - name: logchef
              containerPort: 8125
          volumeMounts:
            - name: config
              mountPath: /etc/logchef/config.toml
              subPath: config.toml
              readOnly: true
            - name: data
              mountPath: /data
          resources:
            requests:
              cpu: 1000m
              memory: 4Gi
      volumes:
        - name: config
          configMap:
            name: {{ .Release.Name }}
        - name: data
          persistentVolumeClaim:
            claimName: {{ .Release.Name }}-data

pod describe:

...
Containers:
  logchef:
    Container ID:   containerd://cb...8144bc
    Image:          mrkaran/logchef:v0.1.0-rc.1-amd64
    Image ID:       docker.io/mrkaran/logchef@sha256:98c05f3e...7012aa0f4c
    Port:           8125/TCP
    Host Port:      0/TCP
    State:          Waiting
      Reason:       CrashLoopBackOff
    Last State:     Terminated
      Reason:       Error
      Exit Code:    1
      Started:      ...
      Finished:     ...
    Ready:          False
    Restart Count:  5
    Requests:
      cpu:        1
      memory:     4Gi
    Environment:  <none>
    Mounts:
      /data from data (rw)
      /etc/logchef/config.toml from config (ro,path="config.toml")
...

[seowon-lee]

I also tried running it in memory with path = "", but I encountered this error:

" [email protected]: getting user email [email protected]: SQL logic error: no such table: users (1)"

pod log:

{"time":"2025-05-15T12:53:32.07274263Z","level":"INFO","source":{"function":"main.main","file":"/home/karan/Code/Personal/logchef/cmd/server/main.go","line":24},"msg":"starting logchef","buildInfo":"v0.1.0-alpha.4 (e92a129e 2025-04-25T11:20:54Z, linux/amd64)"}
{"time":"2025-05-15T12:53:32.073741467Z","level":"INFO","source":{"function":"github.com/mr-karan/logchef/internal/sqlite.setupAndRunMigrations","file":"/home/karan/Code/Personal/logchef/internal/sqlite/sqlite.go","line":108},"msg":"running database migrations","component":"sqlite"}
{"time":"2025-05-15T12:53:32.074147628Z","level":"INFO","source":{"function":"github.com/mr-karan/logchef/internal/sqlite.runMigrations","file":"/home/karan/Code/Personal/logchef/internal/sqlite/sqlite.go","line":186},"msg":"applying migrations...","component":"sqlite"}
{"time":"2025-05-15T12:53:32.076941634Z","level":"INFO","source":{"function":"github.com/mr-karan/logchef/internal/sqlite.runMigrations","file":"/home/karan/Code/Personal/logchef/internal/sqlite/sqlite.go","line":196},"msg":"migrations applied successfully","component":"sqlite"}
{"time":"2025-05-15T12:53:32.07710502Z","level":"INFO","source":{"function":"github.com/mr-karan/logchef/internal/sqlite.setupAndRunMigrations","file":"/home/karan/Code/Personal/logchef/internal/sqlite/sqlite.go","line":113},"msg":"database migrations completed successfully","component":"sqlite"}
{"time":"2025-05-15T12:53:32.077121125Z","level":"DEBUG","source":{"function":"github.com/mr-karan/logchef/internal/sqlite.setupAndRunMigrations.func1","file":"/home/karan/Code/Personal/logchef/internal/sqlite/sqlite.go","line":97},"msg":"closing migration database connection","component":"sqlite"}
{"time":"2025-05-15T12:53:32.077131468Z","level":"INFO","source":{"function":"github.com/mr-karan/logchef/internal/sqlite.New","file":"/home/karan/Code/Personal/logchef/internal/sqlite/sqlite.go","line":79},"msg":"sqlite database initialized successfully","component":"sqlite","path":""}
{"time":"2025-05-15T12:53:32.077148865Z","level":"INFO","source":{"function":"github.com/mr-karan/logchef/internal/core.InitAdminUsers","file":"/home/karan/Code/Personal/logchef/internal/core/users.go","line":310},"msg":"initializing admin users","emails":["[email protected]"]}
{"time":"2025-05-15T12:53:32.077179317Z","level":"DEBUG","source":{"function":"github.com/mr-karan/logchef/internal/sqlite.(*DB).GetUserByEmail","file":"/home/karan/Code/Personal/logchef/internal/sqlite/users.go","line":88},"msg":"getting user record by email","component":"sqlite","email":"[email protected]"}
{"time":"2025-05-15T12:53:32.077239527Z","level":"DEBUG","source":{"function":"github.com/mr-karan/logchef/internal/core.InitAdminUsers","file":"/home/karan/Code/Personal/logchef/internal/core/users.go","line":317},"msg":"error checking admin user","email":"[email protected]","error":"getting user email [email protected]: SQL logic error: no such table: users (1)"}
{"time":"2025-05-15T12:53:32.077258234Z","level":"ERROR","source":{"function":"github.com/mr-karan/logchef/internal/core.InitAdminUsers","file":"/home/karan/Code/Personal/logchef/internal/core/users.go","line":336},"msg":"failed to check existing admin user [email protected]: getting user email [email protected]: SQL logic error: no such table: users (1)"}
{"time":"2025-05-15T12:53:32.077268801Z","level":"DEBUG","source":{"function":"github.com/mr-karan/logchef/internal/sqlite.(*DB).CountAdminUsers","file":"/home/karan/Code/Personal/logchef/internal/sqlite/users.go","line":163},"msg":"counting active admin users","component":"sqlite"}
{"time":"2025-05-15T12:53:32.077288101Z","level":"ERROR","source":{"function":"github.com/mr-karan/logchef/internal/sqlite.(*DB).CountAdminUsers","file":"/home/karan/Code/Personal/logchef/internal/sqlite/users.go","line":170},"msg":"failed to count admin users in db","component":"sqlite","error":"SQL logic error: no such table: users (1)"}
{"time":"2025-05-15T12:53:32.077301852Z","level":"ERROR","source":{"function":"github.com/mr-karan/logchef/internal/core.InitAdminUsers","file":"/home/karan/Code/Personal/logchef/internal/core/users.go","line":372},"msg":"failed to count admin users after initialization: failed to count admin users: SQL logic error: no such table: users (1)"}
{"time":"2025-05-15T12:53:32.077315021Z","level":"ERROR","source":{"function":"github.com/mr-karan/logchef/internal/app.(*App).Initialize","file":"/home/karan/Code/Personal/logchef/internal/app/app.go","line":72},"msg":"failed to initialize admin users","error":"errors during admin user initialization:\n - failed to check existing admin user [email protected]: getting user email [email protected]: SQL logic error: no such table: users (1)\n - failed to count admin users after initialization: failed to count admin users: SQL logic error: no such table: users (1)"}
{"time":"2025-05-15T12:53:32.077328743Z","level":"ERROR","source":{"function":"github.com/mr-karan/logchef/internal/app.Run","file":"/home/karan/Code/Personal/logchef/internal/app/run.go","line":25},"msg":"failed to initialize application","error":"failed to initialize admin users: errors during admin user initialization:\n - failed to check existing admin user [email protected]: getting user email [email protected]: SQL logic error: no such table: users (1)\n - failed to count admin users after initialization: failed to count admin users: SQL logic error: no such table: users (1)"}
{"time":"2025-05-15T12:53:32.077336722Z","level":"ERROR","source":{"function":"main.main","file":"/home/karan/Code/Personal/logchef/cmd/server/main.go","line":32},"msg":"application error","error":"failed to initialize admin users: errors during admin user initialization:\n - failed to check existing admin user [email protected]: getting user email [email protected]: SQL logic error: no such table: users (1)\n - failed to count admin users after initialization: failed to count admin users: SQL logic error: no such table: users (1)"}