Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 14 Jul 2021 21:12:41 +0000
From:      bugzilla-noreply@freebsd.org
To:        apache@FreeBSD.org
Subject:   [Bug 256844] www/nextcloud: apache/occ/php causes segmentation fault error
Message-ID:  <bug-256844-16115-90nRv8nZUy@https.bugs.freebsd.org/bugzilla/>
In-Reply-To: <bug-256844-16115@https.bugs.freebsd.org/bugzilla/>
References:  <bug-256844-16115@https.bugs.freebsd.org/bugzilla/>

next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D256844

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 FreeB=
SD
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 r=
oll
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 data=
base
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-0=
7-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 s=
eg
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=3D257194
[Bug 257194] databases/postgresql13-server: server process was terminated by
signal 11: Segmentation fault
--=20
You are receiving this mail because:
You are on the CC list for the bug.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-256844-16115-90nRv8nZUy>