[BUG] Issues with a large database since ls290

[Dinth]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

Hiya. ls291 included opcache module (as recommended by Grocy's author), but also rebased the image to a new Alpine. It was actually me who requested adding opcache back then to improve slightly sluggish performance. Unfortunately, none of the versions since ls290 ever worked for me. On few occasions i got a page load after long wait, but 99% im just getting 504 timeouts.

Looking at the logs, it looks like php-fpm is crashing on almost every request, but i dont see why, even with log_level set to debug in fpm configuration:

[01-Sep-2025 19:15:57] NOTICE: fpm is running, pid 226
[01-Sep-2025 19:15:57] NOTICE: ready to handle connections
[01-Sep-2025 19:17:31] NOTICE: Terminating ...
[01-Sep-2025 19:17:31] NOTICE: exiting, bye-bye!
[01-Sep-2025 19:17:40] NOTICE: fpm is running, pid 232
[01-Sep-2025 19:17:40] NOTICE: ready to handle connections
[01-Sep-2025 19:25:43] NOTICE: Terminating ...
[01-Sep-2025 19:25:43] NOTICE: exiting, bye-bye!
[01-Sep-2025 19:25:49] NOTICE: fpm is running, pid 223
[01-Sep-2025 19:25:49] NOTICE: ready to handle connections

Nginx log shows:

2025/09/01 19:38:24 [error] 268#268: *99 upstream timed out (110: Operation timed out) while reading response header from upstream, client: 10.55.0.5, server: _, request: "GET /api/system/db-changed-time HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "grocery.wickhay.uk", referrer: "https://grocery.wickhay.uk/stockoverview"
2025/09/01 19:40:54 [error] 265#265: *58 upstream timed out (110: Operation timed out) while reading response header from upstream, client: 10.55.0.5, server: _, request: "GET /stockoverview HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "grocery.wickhay.uk"
2025/09/01 19:41:14 [error] 273#273: *123 upstream timed out (110: Operation timed out) while reading response header from upstream, client: 10.55.0.5, server: _, request: "GET /api/system/db-changed-time HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "grocery.wickhay.uk", referrer: "https://grocery.wickhay.uk/stockoverview"
2025/09/01 19:42:37 [error] 265#265: *58 upstream timed out (110: Operation timed out) while reading response header from upstream, client: 10.55.0.5, server: _, request: "GET /stockoverview HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "grocery.wickhay.uk"
2025/09/01 19:43:38 [error] 265#265: *58 upstream timed out (110: Operation timed out) while reading response header from upstream, client: 10.55.0.5, server: _, request: "GET /stockoverview HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "grocery.wickhay.uk"
2025/09/01 19:44:24 [error] 277#277: *138 upstream timed out (110: Operation timed out) while reading response header from upstream, client: 10.55.0.5, server: _, request: "GET /api/system/db-changed-time HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "grocery.wickhay.uk", referrer: "https://grocery.wickhay.uk/stockoverview"
2025/09/01 19:45:35 [error] 265#265: *58 upstream timed out (110: Operation timed out) while reading response header from upstream, client: 10.55.0.5, server: _, request: "GET /stockoverview HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "grocery.wickhay.uk"
2025/09/01 19:45:38 [error] 276#276: *139 upstream timed out (110: Operation timed out) while reading response header from upstream, client: 10.55.0.5, server: _, request: "GET /api/system/db-changed-time HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "grocery.wickhay.uk", referrer: "https://grocery.wickhay.uk/products"

Reverting to ls290 immediately fixes the issue (although Grocy is running quite slow due to lack of opcache)

Expected Behavior

After ls290 Grocy should run at least as well, as on ls290, but really should run faster - it has opcache, it has a newer pdo_sqlite...

Steps To Reproduce

1. Have a database of at least 10MB (i think its a key factor, ls301 seems to be working fine with empty database, the problems start when i restore database backup to it)
2. Upgrade from ls290 -> ls301
3. Try opening grocy instance.

Environment

- OS: Linux r720-omv 6.12.38+deb12-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.12.38-1~bpo12+1 (2025-07-27) x86_64 GNU/Linux
- How docker service was installed: distro

CPU architecture

x86-64

Docker creation

services:
  grocy:
    cap_add:
      - AUDIT_WRITE
      - CHOWN
      - DAC_OVERRIDE
      - FOWNER
      - FSETID
      - KILL
      - MKNOD
      - NET_BIND_SERVICE
      - NET_RAW
      - SETFCAP
      - SETGID
      - SETPCAP
      - SETUID
      - SYS_CHROOT
    cap_drop:
      - ALL
    container_name: grocy
    environment:
      TZ: "${TZ}"
      PUID: "${DOCKER_PUID}"
      PGID: "${DOCKER_PGID}"
    hostname: grocy
    image: linuxserver/grocy:v4.5.0-ls290
    ipc: private
    logging:
      driver: json-file
      options:
        max-size: "10m"
        max-file: "3"
    networks:
      - grocy
      - traefik
    ports:
      - 9283:80/tcp
    labels:  
      traefik.enable: "true"
      traefik.http.routers.grocy.rule: "Host(`grocery.${DOMAIN_NAME}`)"
      traefik.http.routers.grocy.entrypoints: "websecure"
      traefik.http.routers.grocy.tls: "true"
      traefik.http.routers.grocy.tls.certresolver: "letsencrypt"
      traefik.http.routers.grocy.tls.domains[0].main: "${DOMAIN_NAME}"
      traefik.http.routers.grocy.tls.domains[0].sans: "*.${DOMAIN_NAME}"
      traefik.http.routers.grocy.middlewares: "secHeaders@file"
      traefik.http.services.grocy.loadbalancer.server.port: "80"
      homepage.group: "Home"
      homepage.name: "Grocy"
      homepage.icon: "sh-grocy.png"
      homepage.href: "https://grocery.${DOMAIN_NAME}"
      homepage.description: "Home stock and inventory management"
      wud.watch: "true"
      wud.tag.include: '^\d+\.\d+\.\d+$$'
      wud.link.template: "https://github.com/grocy/grocy/releases/tag/v$${major}.$${minor}.$${patch}"
      wud.display.name: 'Grocy'
      wud.display.icon: 'sh:grocy'
    restart: unless-stopped
    volumes:
      - /opt/docker/grocy/grocy_data:/config
#      - /mnt/tmpfs:/config
networks:
  grocy:  
    name: grocy
    driver: bridge
    external: false
  traefik:
    external: true

Container logs

grocy  | 2025-09-01T20:14:00.365891377Z [migrations] started
grocy  | 2025-09-01T20:14:00.374854868Z [migrations] 01-nginx-site-confs-default: skipped
grocy  | 2025-09-01T20:14:00.378310986Z [migrations] 02-default-location: skipped
grocy  | 2025-09-01T20:14:00.378334755Z [migrations] done
grocy  | 2025-09-01T20:14:00.553597643Z ───────────────────────────────────────
grocy  | 2025-09-01T20:14:00.553635732Z 
grocy  | 2025-09-01T20:14:00.553640694Z       ██╗     ███████╗██╗ ██████╗
grocy  | 2025-09-01T20:14:00.553646493Z       ██║     ██╔════╝██║██╔═══██╗
grocy  | 2025-09-01T20:14:00.553653198Z       ██║     ███████╗██║██║   ██║
grocy  | 2025-09-01T20:14:00.553659975Z       ██║     ╚════██║██║██║   ██║
grocy  | 2025-09-01T20:14:00.553667118Z       ███████╗███████║██║╚██████╔╝
grocy  | 2025-09-01T20:14:00.553671605Z       ╚══════╝╚══════╝╚═╝ ╚═════╝
grocy  | 2025-09-01T20:14:00.553675315Z 
grocy  | 2025-09-01T20:14:00.553678646Z    Brought to you by linuxserver.io
grocy  | 2025-09-01T20:14:00.553682020Z ───────────────────────────────────────
grocy  | 2025-09-01T20:14:00.554166100Z 
grocy  | 2025-09-01T20:14:00.554190224Z To support LSIO projects visit:
grocy  | 2025-09-01T20:14:00.554195122Z https://www.linuxserver.io/donate/
grocy  | 2025-09-01T20:14:00.554198709Z 
grocy  | 2025-09-01T20:14:00.554202142Z ───────────────────────────────────────
grocy  | 2025-09-01T20:14:00.554206886Z GID/UID
grocy  | 2025-09-01T20:14:00.554210312Z ───────────────────────────────────────
grocy  | 2025-09-01T20:14:00.560563500Z 
grocy  | 2025-09-01T20:14:00.560583907Z User UID:    1003
grocy  | 2025-09-01T20:14:00.560589829Z User GID:    100
grocy  | 2025-09-01T20:14:00.560593839Z ───────────────────────────────────────
grocy  | 2025-09-01T20:14:00.563179642Z Linuxserver.io version: v4.5.0-ls301
grocy  | 2025-09-01T20:14:00.563445593Z Build-date: 2025-08-24T07:43:29+00:00
grocy  | 2025-09-01T20:14:00.563458413Z ───────────────────────────────────────
grocy  | 2025-09-01T20:14:00.563464105Z     
grocy  | 2025-09-01T20:14:00.660327813Z using keys found in /config/keys
grocy  | 2025-09-01T20:14:00.923505287Z [custom-init] No custom files found, skipping...
grocy  | 2025-09-01T20:14:00.943762318Z [ls.io-init] done.

[Dinth]

Here's my current php config with some php optimisations, but the same behaviour persists on the default configuration:

root@grocy:/# php -ini
phpinfo()
PHP Version => 8.3.19

System => Linux grocy 6.12.38+deb12-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.12.38-1~bpo12+1 (2025-07-27) x86_64
Build Date => Mar 27 2025 11:08:15
Build System => Linux build-3-21-x86_64 6.6.33-0-lts #1-Alpine SMP PREEMPT_DYNAMIC Thu, 13 Jun 2024 07:49:22 +0000 x86_64 Linux
Configure Command =>  './configure'  '--build=x86_64-alpine-linux-musl' '--host=x86_64-alpine-linux-musl' '--prefix=/usr' '--program-suffix=83' '--libdir=/usr/lib/php83' '--datadir=/usr/share/php83' '--sysconfdir=/etc/php83' '--localstatedir=/var' '--with-layout=GNU' '--with-pic' '--with-config-file-path=/etc/php83' '--with-config-file-scan-dir=/etc/php83/conf.d' '--disable-rpath' '--disable-short-tags' '--enable-bcmath=shared' '--with-bz2=shared' '--enable-calendar=shared' '--enable-ctype=shared' '--with-curl=shared' '--enable-dba=shared' '--with-dbmaker=shared' '--with-gdbm' '--with-lmdb' '--enable-dom=shared' '--with-enchant=shared' '--enable-exif=shared' '--with-ffi=shared' '--enable-fileinfo=shared' '--enable-ftp=shared' '--enable-gd=shared' '--with-avif' '--with-freetype' '--with-jpeg' '--with-webp' '--with-xpm' '--disable-gd-jis-conv' '--with-gettext=shared' '--with-gmp=shared' '--with-iconv=shared' '--with-imap=shared' '--with-imap-ssl' '--enable-intl=shared' '--with-ldap=shared' '--with-ldap-sasl' '--with-libedit' '--with-libxml' '--enable-mbstring=shared' '--with-mysqli=shared' '--with-mysql-sock=/run/mysqld/mysqld.sock' '--enable-mysqlnd=shared' '--enable-opcache=shared' '--with-openssl=shared' '--with-kerberos' '--with-system-ciphers' '--with-password-argon2' '--enable-pcntl=shared' '--with-external-pcre' '--enable-pdo=shared' '--with-pdo-dblib=shared,/usr' '--with-pdo-mysql=shared,mysqlnd' '--with-pdo-odbc=shared,unixODBC,/usr' '--with-pdo-pgsql=shared' '--with-pdo-sqlite=shared' '--with-pgsql=shared' '--enable-phar=shared' '--enable-posix=shared' '--with-pspell=shared' '--without-readline' '--enable-session=shared' '--enable-shmop=shared' '--enable-simplexml=shared' '--with-snmp=shared' '--enable-soap=shared' '--with-sodium=shared' '--enable-sockets=shared' '--with-sqlite3=shared' '--enable-sysvmsg=shared' '--enable-sysvsem=shared' '--enable-sysvshm=shared' '--with-tidy=shared' '--enable-tokenizer=shared' '--with-unixODBC=shared,/usr' '--enable-xml=shared' '--enable-xmlreader=shared' '--enable-xmlwriter=shared' '--with-xsl=shared' '--with-zip=shared' '--with-zlib' '--enable-zend-test=shared' '--enable-phpdbg' '--with-pear=/usr/share/php83' '--enable-fpm' '--with-fpm-acl' '--enable-litespeed' '--enable-embed' 'build_alias=x86_64-alpine-linux-musl' 'host_alias=x86_64-alpine-linux-musl'
Server API => Command Line Interface
Virtual Directory Support => disabled
Configuration File (php.ini) Path => /etc/php83
Loaded Configuration File => /etc/php83/php.ini
Scan this dir for additional .ini files => :/config/php
Additional .ini files parsed => /etc/php83/conf.d/00_ctype.ini,
/etc/php83/conf.d/00_curl.ini,
/etc/php83/conf.d/00_fileinfo.ini,
/etc/php83/conf.d/00_gd.ini,
/etc/php83/conf.d/00_iconv.ini,
/etc/php83/conf.d/00_intl.ini,
/etc/php83/conf.d/00_ldap.ini,
/etc/php83/conf.d/00_mbstring.ini,
/etc/php83/conf.d/00_opcache.ini,
/etc/php83/conf.d/00_openssl.ini,
/etc/php83/conf.d/00_pdo.ini,
/etc/php83/conf.d/00_session.ini,
/etc/php83/conf.d/00_simplexml.ini,
/etc/php83/conf.d/00_tokenizer.ini,
/etc/php83/conf.d/00_xml.ini,
/etc/php83/conf.d/00_xmlwriter.ini,
/etc/php83/conf.d/00_zip.ini,
/etc/php83/conf.d/01_pdo_sqlite.ini,
/etc/php83/conf.d/01_phar.ini,
/etc/php83/conf.d/30_timezone.ini,
/etc/php83/conf.d/grocy.ini,
/config/php/php-local.ini

PHP API => 20230831
PHP Extension => 20230831
Zend Extension => 420230831
Zend Extension Build => API420230831,NTS
PHP Extension Build => API20230831,NTS
Debug Build => no
Thread Safety => disabled
Zend Signal Handling => enabled
Zend Memory Manager => enabled
Zend Multibyte Support => provided by mbstring
Zend Max Execution Timers => disabled
IPv6 Support => enabled
DTrace Support => disabled

Registered PHP Streams => compress.zlib, https, ftps, php, file, glob, data, http, ftp, zip, phar
Registered Stream Socket Transports => tcp, udp, unix, udg, ssl, tls, tlsv1.0, tlsv1.1, tlsv1.2, tlsv1.3
Registered Stream Filters => zlib.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, convert.*, consumed, dechunk

This program makes use of the Zend Scripting Language Engine:
Zend Engine v4.3.19, Copyright (c) Zend Technologies
    with Zend OPcache v8.3.19, Copyright (c), by Zend Technologies


 _______________________________________________________________________


Configuration

Core

PHP Version => 8.3.19

Directive => Local Value => Master Value
allow_url_fopen => On => On
allow_url_include => Off => Off
arg_separator.input => & => &
arg_separator.output => & => &
auto_append_file => no value => no value
auto_globals_jit => On => On
auto_prepend_file => no value => no value
browscap => no value => no value
default_charset => UTF-8 => UTF-8
default_mimetype => text/html => text/html
disable_classes => no value => no value
disable_functions => no value => no value
display_errors => Off => Off
display_startup_errors => Off => Off
doc_root => no value => no value
docref_ext => no value => no value
docref_root => no value => no value
enable_dl => Off => Off
enable_post_data_reading => On => On
error_append_string => no value => no value
error_log => no value => no value
error_log_mode => 0644 => 0644
error_prepend_string => no value => no value
error_reporting => 22527 => 22527
expose_php => On => On
extension_dir => /usr/lib/php83/modules => /usr/lib/php83/modules
fiber.stack_size => no value => no value
file_uploads => On => On
hard_timeout => 2 => 2
highlight.comment => <font style="color: #FF8000">#FF8000</font> => <font style="color: #FF8000">#FF8000</font>
highlight.default => <font style="color: #0000BB">#0000BB</font> => <font style="color: #0000BB">#0000BB</font>
highlight.html => <font style="color: #000000">#000000</font> => <font style="color: #000000">#000000</font>
highlight.keyword => <font style="color: #007700">#007700</font> => <font style="color: #007700">#007700</font>
highlight.string => <font style="color: #DD0000">#DD0000</font> => <font style="color: #DD0000">#DD0000</font>
html_errors => Off => Off
ignore_repeated_errors => Off => Off
ignore_repeated_source => Off => Off
ignore_user_abort => Off => Off
implicit_flush => On => On
include_path => .:/usr/share/php83 => .:/usr/share/php83
input_encoding => no value => no value
internal_encoding => no value => no value
log_errors => On => On
mail.add_x_header => Off => Off
mail.force_extra_parameters => no value => no value
mail.log => no value => no value
mail.mixed_lf_and_crlf => Off => Off
max_execution_time => 0 => 0
max_file_uploads => 20 => 20
max_input_nesting_level => 64 => 64
max_input_time => -1 => -1
max_input_vars => 1000 => 1000
max_multipart_body_parts => -1 => -1
memory_limit => 1024M => 1024M
open_basedir => no value => no value
output_buffering => 0 => 0
output_encoding => no value => no value
output_handler => no value => no value
post_max_size => 100M => 100M
precision => 14 => 14
realpath_cache_size => 16384k => 16384k
realpath_cache_ttl => 300 => 300
register_argc_argv => On => On
report_memleaks => On => On
report_zend_debug => Off => Off
request_order => GP => GP
sendmail_from => no value => no value
sendmail_path => /usr/sbin/sendmail -t -i => /usr/sbin/sendmail -t -i
serialize_precision => -1 => -1
short_open_tag => Off => Off
SMTP => localhost => localhost
smtp_port => 25 => 25
sys_temp_dir => no value => no value
syslog.facility => LOG_USER => LOG_USER
syslog.filter => no-ctrl => no-ctrl
syslog.ident => php => php
unserialize_callback_func => no value => no value
upload_max_filesize => 200M => 200M
upload_tmp_dir => no value => no value
user_dir => no value => no value
user_ini.cache_ttl => 300 => 300
user_ini.filename => .user.ini => .user.ini
variables_order => GPCS => GPCS
xmlrpc_error_number => 0 => 0
xmlrpc_errors => Off => Off
zend.assertions => -1 => -1
zend.detect_unicode => On => On
zend.enable_gc => On => On
zend.exception_ignore_args => On => On
zend.exception_string_param_max_len => 0 => 0
zend.max_allowed_stack_size => 0 => 0
zend.multibyte => Off => Off
zend.reserved_stack_size => 0 => 0
zend.script_encoding => no value => no value
zend.signal_check => Off => Off

ctype

ctype functions => enabled

curl

cURL support => enabled
cURL Information => 8.12.1
Age => 11
Features
AsynchDNS => Yes
CharConv => No
Debug => No
GSS-Negotiate => No
IDN => Yes
IPv6 => Yes
krb4 => No
Largefile => Yes
libz => Yes
NTLM => Yes
NTLMWB => No
SPNEGO => No
SSL => Yes
SSPI => No
TLS-SRP => Yes
HTTP2 => Yes
GSSAPI => No
KERBEROS5 => No
UNIX_SOCKETS => Yes
PSL => Yes
HTTPS_PROXY => Yes
MULTI_SSL => No
BROTLI => Yes
ALTSVC => Yes
HTTP3 => No
UNICODE => No
ZSTD => Yes
HSTS => Yes
GSASL => No
Protocols => dict, file, ftp, ftps, gopher, gophers, http, https, imap, imaps, mqtt, pop3, pop3s, rtsp, smb, smbs, smtp, smtps, telnet, tftp, ws, wss
Host => x86_64-alpine-linux-musl
SSL Version => OpenSSL/3.3.4
ZLib Version => 1.3.1

Directive => Local Value => Master Value
curl.cainfo => no value => no value

date

date/time support => enabled
timelib version => 2022.12
"Olson" Timezone Database Version => 2025.1
Timezone Database => internal
Default timezone => Europe/London

Directive => Local Value => Master Value
date.default_latitude => 31.7667 => 31.7667
date.default_longitude => 35.2333 => 35.2333
date.sunrise_zenith => 90.833333 => 90.833333
date.sunset_zenith => 90.833333 => 90.833333
date.timezone => Europe/London => Europe/London

fileinfo

fileinfo support => enabled
libmagic => 543

filter

Input Validation and Filtering => enabled

Directive => Local Value => Master Value
filter.default => unsafe_raw => unsafe_raw
filter.default_flags => no value => no value

gd

GD Support => enabled
GD Version => bundled (2.1.0 compatible)
FreeType Support => enabled
FreeType Linkage => with freetype
FreeType Version => 2.13.3
GIF Read Support => enabled
GIF Create Support => enabled
JPEG Support => enabled
libJPEG Version => 8
PNG Support => enabled
libPNG Version => 1.6.47
WBMP Support => enabled
XPM Support => enabled
libXpm Version => 30411
XBM Support => enabled
WebP Support => enabled
BMP Support => enabled
AVIF Support => enabled
AVIF Version => 1.0.4
AVIF Codecs => dav1d [dec]:1.5.0, aom [enc/dec]:v3.11.0
TGA Read Support => enabled

Directive => Local Value => Master Value
gd.jpeg_ignore_warning => On => On

hash

hash support => enabled
Hashing Engines => md2 md4 md5 sha1 sha224 sha256 sha384 sha512/224 sha512/256 sha512 sha3-224 sha3-256 sha3-384 sha3-512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b crc32c fnv132 fnv1a32 fnv164 fnv1a64 joaat murmur3a murmur3c murmur3f xxh32 xxh64 xxh3 xxh128 haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 

iconv

iconv support => enabled
iconv implementation => unknown
iconv library version => unknown

Directive => Local Value => Master Value
iconv.input_encoding => no value => no value
iconv.internal_encoding => no value => no value
iconv.output_encoding => no value => no value

intl

Internationalization support => enabled
ICU version => 74.2
ICU Data version => 74.2
ICU TZData version => 2023c
ICU Unicode version => 15.1

Directive => Local Value => Master Value
intl.default_locale => no value => no value
intl.error_level => 0 => 0
intl.use_exceptions => Off => Off

json

json support => enabled

ldap

LDAP Support => enabled
Total Links => 0/unlimited
API Version => 3001
Vendor Name => OpenLDAP
Vendor Version => 20608
SASL Support => Enabled

Directive => Local Value => Master Value
ldap.max_links => Unlimited => Unlimited

libxml

libXML support => active
libXML Compiled Version => 2.13.4
libXML Loaded Version => 21304
libXML streams => enabled

mbstring

Multibyte Support => enabled
Multibyte string engine => libmbfl
HTTP input encoding translation => disabled
libmbfl version => 1.3.2

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Multibyte (japanese) regex support => enabled
Multibyte regex (oniguruma) version => 6.9.9

Directive => Local Value => Master Value
mbstring.detect_order => no value => no value
mbstring.encoding_translation => Off => Off
mbstring.http_input => no value => no value
mbstring.http_output => no value => no value
mbstring.http_output_conv_mimetypes => ^(text/|application/xhtml\+xml) => ^(text/|application/xhtml\+xml)
mbstring.internal_encoding => no value => no value
mbstring.language => neutral => neutral
mbstring.regex_retry_limit => 1000000 => 1000000
mbstring.regex_stack_limit => 100000 => 100000
mbstring.strict_detection => Off => Off
mbstring.substitute_character => no value => no value

openssl

OpenSSL support => enabled
OpenSSL Library Version => OpenSSL 3.3.4 1 Jul 2025
OpenSSL Header Version => OpenSSL 3.3.3 11 Feb 2025
Openssl default config => /etc/ssl/openssl.cnf

Directive => Local Value => Master Value
openssl.cafile => no value => no value
openssl.capath => no value => no value

pcre

PCRE (Perl Compatible Regular Expressions) Support => enabled
PCRE Library Version => 10.43 2024-02-16
PCRE Unicode Version => 15.0.0
PCRE JIT Support => enabled
PCRE JIT Target => x86 64bit (little endian + unaligned)

Directive => Local Value => Master Value
pcre.backtrack_limit => 1000000 => 1000000
pcre.jit => On => On
pcre.recursion_limit => 100000 => 100000

PDO

PDO support => enabled
PDO drivers => sqlite

pdo_sqlite

PDO Driver for SQLite 3.x => enabled
SQLite Library => 3.48.0

Phar

Phar: PHP Archive support => enabled
Phar API version => 1.1.1
Phar-based phar archives => enabled
Tar-based phar archives => enabled
ZIP-based phar archives => enabled
gzip compression => enabled
bzip2 compression => disabled (install ext/bz2)
OpenSSL support => enabled


Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
Directive => Local Value => Master Value
phar.cache_list => no value => no value
phar.readonly => On => On
phar.require_hash => On => On

random

Version => 8.3.19

readline

Readline Support => enabled
Readline library => EditLine wrapper

Directive => Local Value => Master Value
cli.pager => no value => no value
cli.prompt => \b \>  => \b \> 

Reflection

Reflection => enabled

session

Session Support => enabled
Registered save handlers => files user 
Registered serializer handlers => php_serialize php php_binary 

Directive => Local Value => Master Value
session.auto_start => Off => Off
session.cache_expire => 180 => 180
session.cache_limiter => nocache => nocache
session.cookie_domain => no value => no value
session.cookie_httponly => Off => Off
session.cookie_lifetime => 0 => 0
session.cookie_path => / => /
session.cookie_samesite => no value => no value
session.cookie_secure => Off => Off
session.gc_divisor => 1000 => 1000
session.gc_maxlifetime => 1440 => 1440
session.gc_probability => 1 => 1
session.lazy_write => On => On
session.name => PHPSESSID => PHPSESSID
session.referer_check => no value => no value
session.save_handler => files => files
session.save_path => no value => no value
session.serialize_handler => php => php
session.sid_bits_per_character => 5 => 5
session.sid_length => 26 => 26
session.upload_progress.cleanup => On => On
session.upload_progress.enabled => On => On
session.upload_progress.freq => 1% => 1%
session.upload_progress.min_freq => 1 => 1
session.upload_progress.name => PHP_SESSION_UPLOAD_PROGRESS => PHP_SESSION_UPLOAD_PROGRESS
session.upload_progress.prefix => upload_progress_ => upload_progress_
session.use_cookies => On => On
session.use_only_cookies => On => On
session.use_strict_mode => Off => Off
session.use_trans_sid => Off => Off

SimpleXML

SimpleXML support => enabled
Schema support => enabled

SPL

SPL support => enabled
Interfaces => OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes => AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException

standard

Dynamic Library Support => enabled
Path to sendmail => /usr/sbin/sendmail -t -i

Directive => Local Value => Master Value
assert.active => On => On
assert.bail => Off => Off
assert.callback => no value => no value
assert.exception => On => On
assert.warning => On => On
auto_detect_line_endings => Off => Off
default_socket_timeout => 60 => 60
from => no value => no value
session.trans_sid_hosts => no value => no value
session.trans_sid_tags => a=href,area=href,frame=src,form= => a=href,area=href,frame=src,form=
unserialize_max_depth => 4096 => 4096
url_rewriter.hosts => no value => no value
url_rewriter.tags => form= => form=
user_agent => no value => no value

tokenizer

Tokenizer Support => enabled

xml

XML Support => active
XML Namespace Support => active
libxml2 Version => 2.13.4

xmlwriter

XMLWriter => enabled

Zend OPcache

Opcode Caching => Disabled
Optimization => Disabled
SHM Cache => Enabled
File Cache => Disabled
JIT => On
Startup Failed => Opcode Caching is disabled for CLI

Directive => Local Value => Master Value
opcache.blacklist_filename => no value => no value
opcache.dups_fix => Off => Off
opcache.enable => On => On
opcache.enable_cli => Off => Off
opcache.enable_file_override => Off => Off
opcache.error_log => no value => no value
opcache.file_cache => no value => no value
opcache.file_cache_consistency_checks => On => On
opcache.file_cache_only => Off => Off
opcache.file_update_protection => 2 => 2
opcache.force_restart_timeout => 180 => 180
opcache.huge_code_pages => Off => Off
opcache.interned_strings_buffer => 32 => 32
opcache.jit => tracing => tracing
opcache.jit_bisect_limit => 0 => 0
opcache.jit_blacklist_root_trace => 16 => 16
opcache.jit_blacklist_side_trace => 8 => 8
opcache.jit_buffer_size => 0 => 0
opcache.jit_debug => 0 => 0
opcache.jit_hot_func => 127 => 127
opcache.jit_hot_loop => 64 => 64
opcache.jit_hot_return => 8 => 8
opcache.jit_hot_side_exit => 8 => 8
opcache.jit_max_exit_counters => 8192 => 8192
opcache.jit_max_loop_unrolls => 8 => 8
opcache.jit_max_polymorphic_calls => 2 => 2
opcache.jit_max_recursive_calls => 2 => 2
opcache.jit_max_recursive_returns => 2 => 2
opcache.jit_max_root_traces => 1024 => 1024
opcache.jit_max_side_traces => 128 => 128
opcache.jit_max_trace_length => 1024 => 1024
opcache.jit_prof_threshold => 0.005 => 0.005
opcache.lockfile_path => /tmp => /tmp
opcache.log_verbosity_level => 1 => 1
opcache.max_accelerated_files => 1000000 => 1000000
opcache.max_file_size => 0 => 0
opcache.max_wasted_percentage => 10 => 10
opcache.memory_consumption => 512 => 512
opcache.opt_debug_level => 0 => 0
opcache.optimization_level => 0x7FFEBFFF => 0x7FFEBFFF
opcache.preferred_memory_model => no value => no value
opcache.preload => no value => no value
opcache.preload_user => no value => no value
opcache.protect_memory => Off => Off
opcache.record_warnings => Off => Off
opcache.restrict_api => no value => no value
opcache.revalidate_freq => 1 => 1
opcache.revalidate_path => Off => Off
opcache.save_comments => On => On
opcache.use_cwd => On => On
opcache.validate_permission => Off => Off
opcache.validate_root => Off => Off
opcache.validate_timestamps => Off => Off

zip

Zip => enabled
Zip version => 1.22.3
Libzip version => 1.11.2
BZIP2 compression => Yes
XZ compression => Yes
ZSTD compression => Yes
AES-128 encryption => Yes
AES-192 encryption => Yes
AES-256 encryption => Yes

zlib

ZLib Support => enabled
Stream Wrapper => compress.zlib://
Stream Filter => zlib.inflate, zlib.deflate
Compiled Version => 1.3.1
Linked Version => 1.3.1

Directive => Local Value => Master Value
zlib.output_compression => On => On
zlib.output_compression_level => -1 => -1
zlib.output_handler => no value => no value

Additional Modules

Module Name

Environment

Variable => Value
PHP_INI_SCAN_DIR => :/config/php
S6_STAGE2_HOOK => /docker-mods
HOSTNAME => grocy
SHLVL => 1
HOME => /root
S6_VERBOSITY => 1
PS1 => $(whoami)@$(hostname):$(pwd)\$ 
PGID => 100
LSIO_FIRST_PARTY => true
S6_CMD_WAIT_FOR_SERVICES_MAXTIME => 0
TERM => xterm
PATH => /lsiopy/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PUID => 1003
VIRTUAL_ENV => /lsiopy
PWD => /
TZ => Europe/London

PHP Variables

Variable => Value
$_SERVER['PHP_INI_SCAN_DIR'] => :/config/php
$_SERVER['S6_STAGE2_HOOK'] => /docker-mods
$_SERVER['HOSTNAME'] => grocy
$_SERVER['SHLVL'] => 1
$_SERVER['HOME'] => /root
$_SERVER['S6_VERBOSITY'] => 1
$_SERVER['PS1'] => $(whoami)@$(hostname):$(pwd)\$ 
$_SERVER['PGID'] => 100
$_SERVER['LSIO_FIRST_PARTY'] => true
$_SERVER['S6_CMD_WAIT_FOR_SERVICES_MAXTIME'] => 0
$_SERVER['TERM'] => xterm
$_SERVER['PATH'] => /lsiopy/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
$_SERVER['PUID'] => 1003
$_SERVER['VIRTUAL_ENV'] => /lsiopy
$_SERVER['PWD'] => /
$_SERVER['TZ'] => Europe/London
$_SERVER['PHP_SELF'] => 
$_SERVER['SCRIPT_NAME'] => 
$_SERVER['SCRIPT_FILENAME'] => 
$_SERVER['PATH_TRANSLATED'] => 
$_SERVER['DOCUMENT_ROOT'] => 
$_SERVER['REQUEST_TIME_FLOAT'] => 1756750694.1973
$_SERVER['REQUEST_TIME'] => 1756750694
$_SERVER['argv'] => Array
(
)

$_SERVER['argc'] => 0

And php-fpm config:

root@grocy:/config/log/php# /usr/sbin/php-fpm83 -tt
[01-Sep-2025 19:32:46] NOTICE: [global]
[01-Sep-2025 19:32:46] NOTICE:  pid = undefined
[01-Sep-2025 19:32:46] NOTICE:  error_log = /config/log/php/error.log
[01-Sep-2025 19:32:46] NOTICE:  syslog.ident = php-fpm83
[01-Sep-2025 19:32:46] NOTICE:  syslog.facility = 24
[01-Sep-2025 19:32:46] NOTICE:  log_buffering = yes
[01-Sep-2025 19:32:46] NOTICE:  log_level = unknown value
[01-Sep-2025 19:32:46] NOTICE:  log_limit = 1024
[01-Sep-2025 19:32:46] NOTICE:  emergency_restart_interval = 0s
[01-Sep-2025 19:32:46] NOTICE:  emergency_restart_threshold = 0
[01-Sep-2025 19:32:46] NOTICE:  process_control_timeout = 0s
[01-Sep-2025 19:32:46] NOTICE:  process.max = 0
[01-Sep-2025 19:32:46] NOTICE:  process.priority = undefined
[01-Sep-2025 19:32:46] NOTICE:  daemonize = yes
[01-Sep-2025 19:32:46] NOTICE:  rlimit_files = 0
[01-Sep-2025 19:32:46] NOTICE:  rlimit_core = 0
[01-Sep-2025 19:32:46] NOTICE:  events.mechanism = epoll
[01-Sep-2025 19:32:46] NOTICE:  
[01-Sep-2025 19:32:46] NOTICE: [www]
[01-Sep-2025 19:32:46] NOTICE:  prefix = undefined
[01-Sep-2025 19:32:46] NOTICE:  user = abc
[01-Sep-2025 19:32:46] NOTICE:  group = abc
[01-Sep-2025 19:32:46] NOTICE:  listen = 127.0.0.1:9000
[01-Sep-2025 19:32:46] NOTICE:  listen.backlog = -1
[01-Sep-2025 19:32:46] NOTICE:  listen.acl_users = undefined
[01-Sep-2025 19:32:46] NOTICE:  listen.acl_groups = undefined
[01-Sep-2025 19:32:46] NOTICE:  listen.owner = undefined
[01-Sep-2025 19:32:46] NOTICE:  listen.group = undefined
[01-Sep-2025 19:32:46] NOTICE:  listen.mode = undefined
[01-Sep-2025 19:32:46] NOTICE:  listen.allowed_clients = undefined
[01-Sep-2025 19:32:46] NOTICE:  process.priority = undefined
[01-Sep-2025 19:32:46] NOTICE:  process.dumpable = no
[01-Sep-2025 19:32:46] NOTICE:  pm = static
[01-Sep-2025 19:32:46] NOTICE:  pm.max_children = 10
[01-Sep-2025 19:32:46] NOTICE:  pm.start_servers = 2
[01-Sep-2025 19:32:46] NOTICE:  pm.min_spare_servers = 1
[01-Sep-2025 19:32:46] NOTICE:  pm.max_spare_servers = 3
[01-Sep-2025 19:32:46] NOTICE:  pm.max_spawn_rate = 32
[01-Sep-2025 19:32:46] NOTICE:  pm.process_idle_timeout = 10
[01-Sep-2025 19:32:46] NOTICE:  pm.max_requests = 0
[01-Sep-2025 19:32:46] NOTICE:  pm.status_path = undefined
[01-Sep-2025 19:32:46] NOTICE:  pm.status_listen = undefined
[01-Sep-2025 19:32:46] NOTICE:  ping.path = undefined
[01-Sep-2025 19:32:46] NOTICE:  ping.response = undefined
[01-Sep-2025 19:32:46] NOTICE:  access.log = undefined
[01-Sep-2025 19:32:46] NOTICE:  access.format = undefined
[01-Sep-2025 19:32:46] NOTICE:  slowlog = undefined
[01-Sep-2025 19:32:46] NOTICE:  request_slowlog_timeout = 0s
[01-Sep-2025 19:32:46] NOTICE:  request_slowlog_trace_depth = 20
[01-Sep-2025 19:32:46] NOTICE:  request_terminate_timeout = 0s
[01-Sep-2025 19:32:46] NOTICE:  request_terminate_timeout_track_finished = no
[01-Sep-2025 19:32:46] NOTICE:  rlimit_files = 0
[01-Sep-2025 19:32:46] NOTICE:  rlimit_core = 0
[01-Sep-2025 19:32:46] NOTICE:  chroot = undefined
[01-Sep-2025 19:32:46] NOTICE:  chdir = undefined
[01-Sep-2025 19:32:46] NOTICE:  catch_workers_output = no
[01-Sep-2025 19:32:46] NOTICE:  decorate_workers_output = yes
[01-Sep-2025 19:32:46] NOTICE:  clear_env = no
[01-Sep-2025 19:32:46] NOTICE:  security.limit_extensions = .php .phar
[01-Sep-2025 19:32:46] NOTICE:  
[01-Sep-2025 19:32:46] NOTICE: configuration file /etc/php83/php-fpm.conf test is successful

[Dinth]

Just checked, disabling opcache (opcache.enable=0) on ls301 doesnt fix anything, so i think that the issue is more likely related to rebase in ls291, not adding opcache

[LinuxServer-CI]

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

[terabyte-gc]

Yeah. I'm having the same issue; the meal plan page is extremely slow to load. I don't have that many products, recipes, or history added yet, only 1 month's worth, but it's noticeably slow.

I tested with a new container, and there are no issues with no data.
I'll try downgrading to version ls290 to test further.

[terabyte-gc]

I'll try downgrading to version ls290 to test further.

I forgot to post my testing results: I downgraded to ls290 and copied the data folder over. It works perfectly with no noticeable slowdown.

The pages are as fast as initially seen in the demo, especially the meal plan page, which is extremely slow on ls291+ since the rebase from Alpine 3.20 to 3.21.

[terabyte-gc]

Just to keep this up-to-date, the issue is still present in v4.5.0-ls306

[j0nnymoe]

Issue with this, I don't think anyone within the team has a database of that size to test against (I've got it running but still on my todo list to start actually using). Will have a look to see if there is a demo database we can use.

[terabyte-gc]

It doesn't really need a big database. My ls3xx Docker instance had:

• 75 products
• 37 recipes
• Data in the meal plan was from September to the first week of October, so 5 weeks' worth of it.

I noticed it slowing down starting from 2-3 weeks ago already. The meal plan took 1 minute to load, and the recipes page returned a 500 Internal Server Error.

===
After dowgrading to ls290 I now have:

• 122 products
• 48 recipes
• Data in the meal plan from the start of September to the end of October, so 2 months' worth of it.

No noticeable slowdowns.

Copying over the new data from ls290 to ls306, both recipe and mealplan pages simply return a blank page. 🤷‍♂️