[Bug 282948] databases/postgresql-ogr_fdw: postgresql17 server core dump on create materialized view of foreign table
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
Date: Sun, 24 Nov 2024 15:46:35 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=282948
Bug ID: 282948
Summary: databases/postgresql-ogr_fdw: postgresql17 server core
dump on create materialized view of foreign table
Product: Ports & Packages
Version: Latest
Hardware: Any
OS: Any
Status: New
Severity: Affects Only Me
Priority: ---
Component: Individual Port(s)
Assignee: lbartoletti@FreeBSD.org
Reporter: d8zNeCFG@aon.at
Flags: maintainer-feedback?(lbartoletti@FreeBSD.org)
Assignee: lbartoletti@FreeBSD.org
Scenario:
- FreeBSD stable/14 4e8444d5750a with minor local patches
- ports latest
- Installed databases/postgresql17-server, databases/postgis35, and
databases/postgresql-ogr_fdw
- Executing the following SQL commands via psql (database superuser only where
necessary, otherwise as the normal user "martin"):
# create extension postgis;
# create extension ogr_fdw;
# CREATE SERVER rijkswaterstaat
FOREIGN DATA WRAPPER ogr_fdw
OPTIONS (
datasource
'WFS:https://geo.rijkswaterstaat.nl/services/ogc/gdr/nwb_wegen/ows?service=WFS&request=getcapabilities&version=2.0.0',
format 'WFS');
# grant usage on foreign server rijkswaterstaat to martin;
- change to normal user
> select version();
version
----------------------------------------------------------------------------------------
PostgreSQL 17.2 on amd64-portbld-freebsd14.2, compiled by clang version
15.0.7, 64-bit
(1 row)
> select postgis_version();
postgis_version
---------------------------------------
3.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
(1 row)
> select ogr_fdw_version();
ogr_fdw_version
-----------------------------
OGR_FDW="1.1" GDAL="3.10.0"
(1 row)
martin=>
> create schema rijkswaterstaat;
> set search_path to "$user", public, rijkswaterstaat;
> import foreign schema ogr_all from server rijkswaterstaat into rijkswaterstaat;
> \d
List of relations
Schema | Name | Type | Owner
-----------------+--------------------------------+---------------+----------
public | geography_columns | view | postgres
public | geometry_columns | view | postgres
public | spatial_ref_sys | table | postgres
rijkswaterstaat | nwb_wegen_hectopunten | foreign table | martin
rijkswaterstaat | nwb_wegen_mutaties_hectopunten | foreign table | martin
rijkswaterstaat | nwb_wegen_mutaties_wegvakken | foreign table | martin
rijkswaterstaat | nwb_wegen_nwb_light | foreign table | martin
rijkswaterstaat | nwb_wegen_wegvakken | foreign table | martin
(8 rows)
> create materialized view public.nwb_wegen_wegvakken_mat as select * from rijkswaterstaat.nwb_wegen_wegvakken;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
The connection to the server was lost. Attempting reset: Failed.
!?>
Result:
- At this point the postgresql process serving the request dumps core
- Running gdb:
[0]# gdb /usr/local/bin/postgres postgres.core
GNU gdb (GDB) 15.1 [GDB v15.1 for FreeBSD]
Copyright (C) 2024 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Type "show copying" and "show warranty" for details.
This GDB was configured as "x86_64-portbld-freebsd14.2".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<https://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
<http://www.gnu.org/software/gdb/documentation/>.
For help, type "help".
Type "apropos word" to search for commands related to "word"...
Reading symbols from /usr/local/bin/postgres...
(No debugging symbols found in /usr/local/bin/postgres)
[New LWP 100757]
Core was generated by `postgres: martin martin 192.168.1.19(42834) CREATE
MATERIALIZED VIEW'.
Program terminated with signal SIGSEGV, Segmentation fault.
Address not mapped to object.
#0 0x000000083053bdab in ?? () from /usr/local/lib/postgresql/ogr_fdw.so
(gdb) where
#0 0x000000083053bdab in ?? () from /usr/local/lib/postgresql/ogr_fdw.so
#1 0x00000008305384af in ?? () from /usr/local/lib/postgresql/ogr_fdw.so
#2 0x0000000000791e64 in ExecInitForeignScan ()
#3 0x000000000077ebef in ExecInitNode ()
#4 0x0000000000778003 in standard_ExecutorStart ()
#5 0x0000000000716634 in RefreshMatViewByOid ()
#6 0x00000000006ef961 in ExecCreateTableAs ()
#7 0x000000000094e5f7 in ?? ()
#8 0x000000000094d0c8 in standard_ProcessUtility ()
#9 0x000000000094c9f1 in ProcessUtility ()
#10 0x000000000094c5ff in ?? ()
#11 0x000000000094bddc in ?? ()
#12 0x000000000094b87f in PortalRun ()
#13 0x000000000094a899 in ?? ()
#14 0x00000000009483e9 in PostgresMain ()
#15 0x0000000000943c02 in BackendMain ()
#16 0x00000000008a7ad6 in postmaster_child_launch ()
#17 0x00000000008abcd6 in ?? ()
#18 0x00000000008a959a in PostmasterMain ()
#19 0x00000000007ce9f8 in main ()
(gdb)
- The postgres log contains the following:
[0]# tail -20 /var/log/postgres.log
... (some older lines omitted)
Nov 24 16:30:50 hal postgres[1085]: [7-1] 2024-11-24 16:30:50.390 CET [1085]
LOG: server process (PID 26818) was terminated by signal 11: Segmentation
fault
Nov 24 16:30:50 hal postgres[1085]: [7-2] 2024-11-24 16:30:50.390 CET [1085]
DETAIL: Failed process was running: create materialized view
public.nwb_wegen_wegvakken_mat as select * from
rijkswaterstaat.nwb_wegen_wegvakken;
Nov 24 16:30:50 hal postgres[1085]: [8-1] 2024-11-24 16:30:50.390 CET [1085]
LOG: terminating any other active server processes
Nov 24 16:30:50 hal postgres[1085]: [9-1] 2024-11-24 16:30:50.392 CET [1085]
LOG: all server processes terminated; reinitializing
Nov 24 16:30:50 hal postgres[26820]: [10-1] 2024-11-24 16:30:50.447 CET [26820]
LOG: database system was interrupted; last known up at 2024-11-24 16:24:08 CET
Nov 24 16:30:50 hal postgres[26820]: [11-1] 2024-11-24 16:30:50.703 CET [26820]
LOG: database system was not properly shut down; automatic recovery in
progress
Nov 24 16:30:50 hal postgres[26820]: [12-1] 2024-11-24 16:30:50.747 CET [26820]
LOG: redo starts at 0/8E872518
Nov 24 16:30:55 hal postgres[26820]: [13-1] 2024-11-24 16:30:55.322 CET [26820]
LOG: invalid magic number 0000 in WAL segment 00000001000000000000009C, LSN
0/9C430000, offset 4390912
Nov 24 16:30:55 hal postgres[26820]: [14-1] 2024-11-24 16:30:55.322 CET [26820]
LOG: redo done at 0/9C42FF80 system usage: CPU: user: 1.82 s, system: 2.71 s,
elapsed: 4.59 s
Nov 24 16:30:55 hal postgres[26821]: [10-1] 2024-11-24 16:30:55.456 CET [26821]
LOG: checkpoint starting: end-of-recovery immediate wait
Nov 24 16:30:55 hal postgres[26821]: [11-1] 2024-11-24 16:30:55.913 CET [26821]
LOG: checkpoint complete: wrote 63 buffers (0.4%); 0 WAL file(s) added, 11
removed, 3 recycled; write=0.006 s, sync=0.301 s, total=0.466 s; sync files=39,
longest=0.009 s, average=0.008 s; distance=225014 kB, estimate=225014 kB;
lsn=0/9C430048, redo lsn=0/9C430048
Nov 24 16:30:55 hal postgres[1085]: [10-1] 2024-11-24 16:30:55.927 CET [1085]
LOG: database system is ready to accept connections
[0]#
- A very few times the "create materialized view" succeeded, but the "shape"
column in this view would be empty.
Expected result:
- The "create materialized view" should succeed.
Note:
- In a setup on Windows 11 using PostgreSQL 16 (installed via EnterpriseDB),
the operation works flawlessly. The following versions are installed:
[0]% psql -h localhost world martin
psql (16.2)
Type "help" for help.
> select version();
version
------------------------------------------------------------
PostgreSQL 16.2, compiled by Visual C++ build 1937, 64-bit
(1 row)
> select postgis_version();
postgis_version
---------------------------------------
3.4 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
(1 row)
> select ogr_fdw_version();
ogr_fdw_version
----------------------------
OGR_FDW="1.1" GDAL="3.7.1"
(1 row)
world=>
\q
[0]%
-- Martin
--
You are receiving this mail because:
You are the assignee for the bug.