[BUG] Issues with a large database is back since ls337

[terabyte-gc]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

The problem from issue #99 is back again with version 4.6.0-ls337. The meal plan and recipes pages are not loading but show a blank page.

The culprit is most likely the recent sqlite version upgrade from 3.51.2 to 3.53.4: v4.6.0-ls336...v4.6.0-ls337

Expected Behavior

The meal plan and recipes page should load.

• Reverting to 4.6.0-ls336 the pages load again.
• A fresh install of 4.6.0-ls337 without any existing data also works.

Steps To Reproduce

1. Simply update to version 4.6.0-ls337 and the meal plan and other pages will show a blank page when using a medium/big database instead of loading properly.

Environment

CPU architecture

arm64

Docker creation

services:
  grocy:
    #image: linuxserver/grocy:v4.5.0-ls290
    #image: linuxserver/grocy:v4.6.0-ls336
    image: linuxserver/grocy:latest
    container_name: grocy
    environment:
      - PUID=1000
      - PGID=110
      - TZ=Europe/Rome
    volumes:
      - /volume1/docker/grocy:/config
    ports:
      - 9283:80
    restart: unless-stopped

Container logs

[migrations] started
[migrations] 01-nginx-site-confs-default: skipped
[migrations] 02-default-location: skipped
[migrations] done
───────────────────────────────────────
      ██╗     ███████╗██╗ ██████╗
      ██║     ██╔════╝██║██╔═══██╗
      ██║     ███████╗██║██║   ██║
      ██║     ╚════██║██║██║   ██║
      ███████╗███████║██║╚██████╔╝
      ╚══════╝╚══════╝╚═╝ ╚═════╝
   Brought to you by linuxserver.io
───────────────────────────────────────
To support LSIO projects visit:
https://www.linuxserver.io/donate/
───────────────────────────────────────
GID/UID
───────────────────────────────────────
User UID:    1024
User GID:    100
───────────────────────────────────────
Linuxserver.io version: v4.6.0-ls337
Build-date: 2026-08-23T08:01:09+00:00
───────────────────────────────────────
    
using keys found in /config/keys
**** The following active confs have different version dates than the samples that are shipped. ****
**** This may be due to user customization or an update to the samples. ****
**** You should compare the following files to the samples in the same folder and update them. ****
**** Use the link at the top of the file to view the changelog. ****
┌────────────┬────────────┬────────────────────────────────────────────────────────────────────────┐
│  old date  │  new date  │ path                                                                   │
├────────────┼────────────┼────────────────────────────────────────────────────────────────────────┤
│ 2023-08-13 │ 2026-05-04 │ /config/nginx/ssl.conf                                                 │
│ 2024-05-27 │ 2025-12-26 │ /config/nginx/nginx.conf                                               │
│ 2024-07-16 │ 2025-12-26 │ /config/nginx/site-confs/default.conf                                  │
└────────────┴────────────┴────────────────────────────────────────────────────────────────────────┘
[custom-init] No custom files found, skipping...
[ls.io-init] done.

[github-actions]

Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.

[MononeV]

I could access the meal plan page and log meal plans as before, but could not consume the ingredients of the meal plan.

I had to downgrade the image to ls336 and that fixed the issue at the moment.

[terabyte-gc]

Yeah. It depends on how much data is in the database.

With the previous issue, I had a similar problem to yours. Now that I have more, nothing works on those pages.

[terabyte-gc]

Sqlite is still the same as ls337, so I'll be skipping ls338. 🙄

[terabyte-gc]

Just to keep track: still no SQLite changes in v4.7.1-ls341.

[j0nnymoe]

Remind me, the last time this was an issue, we needed it to be patched at grocy level?

[terabyte-gc]

The fix last time was to upgrade SQLite to version 3.50+ (from 3.48): https://rudd-o.com/linux-and-free-software/grocy-users-update-to-sqlite-3.50

I have not tested whether version 3.53 has the same bug as 3.48, but SQLite was indeed updated from 3.51.2 (working) to 3.53.4 (not working) in build ls337 when the pages stopped loading, as before.