From nobody Wed Jul 14 21:12:00 2021 X-Original-To: ports-bugs@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id B25BF12772C1 for ; Wed, 14 Jul 2021 21:12:00 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4GQ9Dc4bkyz4XDv for ; Wed, 14 Jul 2021 21:12:00 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 873EE1D461 for ; Wed, 14 Jul 2021 21:12:00 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 16ELC0J5095473 for ; Wed, 14 Jul 2021 21:12:00 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 16ELC0RL095472 for ports-bugs@FreeBSD.org; Wed, 14 Jul 2021 21:12:00 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 257194] databases/postgresql13-server: server process was terminated by signal 11: Segmentation fault Date: Wed, 14 Jul 2021 21:12:00 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Many People X-Bugzilla-Who: ohartmann@walstatt.org X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: pgsql@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter flagtypes.name Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports-bugs@freebsd.org X-BeenThere: freebsd-ports-bugs@freebsd.org MIME-Version: 1.0 X-ThisMailContainsUnwantedMimeParts: N https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D257194 Bug ID: 257194 Summary: databases/postgresql13-server: server process was terminated by signal 11: Segmentation fault Product: Ports & Packages Version: Latest Hardware: Any OS: Any Status: New Severity: Affects Many People Priority: --- Component: Individual Port(s) Assignee: pgsql@FreeBSD.org Reporter: ohartmann@walstatt.org Assignee: pgsql@FreeBSD.org Flags: maintainer-feedback?(pgsql@FreeBSD.org) Host is running FreeBSD 14-CURRENT (FreeBSD 14.0-CURRENT #84 main-n247978-b345b7e9e9c: Wed Jul 14 07:00:58 CEST 2021 amd64), KTLS enable= d. Running port databases/postgresql13-server: 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 with options: # make showconfig =3D=3D=3D> The following configuration options are available for postgresql13-server-13.3_1: DEBUG=3Doff: Build with debugging support DOCS=3Don: Build and/or install documentation DTRACE=3Doff: Build with DTrace probes GSSAPI=3Don: Build with GSSAPI support INTDATE=3Don: Builds with 64-bit date/time type LDAP=3Don: Build with LDAP authentication support LLVM=3Don: Build with support for JIT-compiling expressions NLS=3Don: Use internationalized messages OPTIMIZED_CFLAGS=3Don: Builds with compiler optimizations (-O3) PAM=3Don: Build with PAM Support SSL=3Don: Build with OpenSSL support TZDATA=3Don: Use internal timezone database XML=3Don: Build with XML data type =3D=3D=3D> Use 'make config' to modify these settings results in a non-usable PostgreSQL server since it periodically segfaults: [...] 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 [...] That is on login, on access via other client software (for instance www/nextcloud, php74). --=20 You are receiving this mail because: You are the assignee for the bug.=