[Bug 256844] www/nextcloud: apache/occ/php causes segmentation fault error

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=256844

O. Hartmann <ohartmann@walstatt.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |257194

--- Comment #9 from O. Hartmann <ohartmann@walstatt.org> ---
(In reply to Michael Gmelin from comment #8)

I found the issue:

Jul 14 22:53:54 <16.6> host postgres[60832]: [2-1] 2021-07-14 22:54:21.477 CEST
[60832] LOG:  \
   starting PostgreSQL 13.3 on amd64-portbld-freebsd14.0, compiled by FreeBSD
clang version 12.0.1 \
   (git@github.com:llvm/llvm-project.git llvmorg-12.0.1-rc2-0-ge7dac564cd0e),
64-bit

[...]
Jul 14 22:54:22 <16.6> host postgres[75483]: [16-1] 2021-07-14 22:54:49.591
CEST [75483] LOG:  redo done at 1/827D0370
Jul 14 22:54:22 <16.6> host postgres[60832]: [12-1] 2021-07-14 22:54:49.852
CEST [60832] LOG:  database system is ready to accept connections
Jul 14 22:54:51 <16.6> host postgres[60832]: [13-1] 2021-07-14 22:55:18.170
CEST [60832] LOG:  server process (PID 93689) was terminated by signal 11:
Segmentation fault
Jul 14 22:54:51 <16.6> host postgres[60832]: [14-1] 2021-07-14 22:55:18.170
CEST [60832] LOG:  terminating any other active server processes
Jul 14 22:54:51 <16.5> host postgres[85999]: [12-1] 2021-07-14 22:55:18.170
CEST [85999] WARNING:  terminating connection because of crash of another
server process
Jul 14 22:54:51 <16.5> host postgres[85999]: [12-2] 2021-07-14 22:55:18.170
CEST [85999] DETAIL:  The postmaster has commanded this server process to roll
back the current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
Jul 14 22:54:51 <16.5> host postgres[85999]: [12-3] 2021-07-14 22:55:18.170
CEST [85999] HINT:  In a moment you should be able to reconnect to the database
and repeat your command.
Jul 14 22:54:51 <16.6> host postgres[60832]: [15-1] 2021-07-14 22:55:18.172
CEST [60832] LOG:  all server processes terminated; reinitializing
Jul 14 22:54:51 <16.6> host postgres[94255]: [16-1] 2021-07-14 22:55:18.185
CEST [94255] LOG:  database system was interrupted; last known up at 2021-07-14
22:54:49 CEST
Jul 14 22:54:51 <16.6> host postgres[94255]: [17-1] 2021-07-14 22:55:18.579
CEST [94255] LOG:  database system was not properly shut down; automatic
recovery in progress
Jul 14 22:54:51 <16.6> host postgres[94255]: [18-1] 2021-07-14 22:55:18.597
CEST [94255] LOG:  redo starts at 1/827D0420
Jul 14 22:54:51 <16.6> host postgres[94255]: [19-1] 2021-07-14 22:55:18.597
CEST [94255] LOG:  invalid record length at 1/827D0458: wanted 24, got 0
Jul 14 22:54:51 <16.6> host postgres[94255]: [20-1] 2021-07-14 22:55:18.597
CEST [94255] LOG:  redo done at 1/827D0420
Jul 14 22:54:51 <16.6> host postgres[60832]: [16-1] 2021-07-14 22:55:18.649
CEST [60832] LOG:  database system is ready to accept connections
[...]

The host is running recent FreeBSD 14-CURRENT, and
databases/postgresql13-server as the  DB backend.
In postgresql.conf, SSL is enabled as well as encryption via scram-sha-256 (if
this is of use, just for the record).

The database is mainly used for nextcloud at the moment, so the issue -
obviously existing since May, 26th, hasn't been revealed. The database is seg
faulting periodically, I do  not see why.

I tried to recompile the port databases/postgresql13-server without option LLVM
avoiding usage of JIT, but that did not have any effect.


Referenced Bugs:

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=257194
[Bug 257194] databases/postgresql13-server: server process was terminated by
signal 11: Segmentation fault
-- 
You are receiving this mail because:
You are on the CC list for the bug.