[Bug 257194] databases/postgresql13-server: server process was terminated by signal 11: Segmentation fault
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
Date: Wed, 14 Jul 2021 21:12:00 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=257194 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 enabled. 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 FreeBSD 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 ===> The following configuration options are available for postgresql13-server-13.3_1: DEBUG=off: Build with debugging support DOCS=on: Build and/or install documentation DTRACE=off: Build with DTrace probes GSSAPI=on: Build with GSSAPI support INTDATE=on: Builds with 64-bit date/time type LDAP=on: Build with LDAP authentication support LLVM=on: Build with support for JIT-compiling expressions NLS=on: Use internationalized messages OPTIMIZED_CFLAGS=on: Builds with compiler optimizations (-O3) PAM=on: Build with PAM Support SSL=on: Build with OpenSSL support TZDATA=on: Use internal timezone database XML=on: Build with XML data type ===> 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 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 [...] That is on login, on access via other client software (for instance www/nextcloud, php74). -- You are receiving this mail because: You are the assignee for the bug.