[PostGIS] #5693: Database server kill thread
PostGIS
trac at osgeo.org
Fri Mar 8 11:49:31 PST 2024
#5693: Database server kill thread
---------------------+---------------------------
Reporter: dap42 | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 3.4.3
Component: postgis | Version: 3.4.x
Keywords: |
---------------------+---------------------------
If I run the query
select st_setUpperLeft(rast,st_upperLeftx( r.rast), st_upperLefty(r.rast))
from windproc , (select rast from rtab limit 1) r;
in psql -d windproc
PSQL drops the connection
Looking at the postgresql log, gives ie the database thread dies. No
user call should be able to kill a database.
select st_upperLeftx(rast), st_upperLefty(rast) from rtab;
Works as expected
As does
select st_setUpperLeft(cr.rast,st_upperLeftx( r.rast),
st_upperLefty(r.rast)) from colour_ras cr, (select rast from rtab limit 1)
r;
windproc=# \d windproc;
Table "public.windproc"
Column | Type | Collation | Nullable |
Default
--------------+--------------------------+-----------+----------+--------------------------------------
id | integer | | not null |
nextval('windproc_id_seq'::regclass)
lat | real | | |
lon | real | | |
uwnd | real | | |
vwnd | real | | |
angle | real | | |
speed | real | | |
reading_time | timestamp with time zone | | |
geom | geometry(Point,4326) | | |
new_lon | real | | |
new_lat | real | | |
Indexes:
"windproc_pkey" PRIMARY KEY, btree (id)
"idx_reading_time" btree (timezone('UTC'::text, reading_time))
"windproc_id_idx" btree (id)
Windproc is
2024-03-08 13:46:21.877 GMT [2420] LOG: checkpoint complete: wrote 3
buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.020 s,
sync=0.007 s, total=0.078 s; sync files=2, longest=0.004 s, average=0.004
s; distance=0 kB, estimate=0 kB; lsn=2/474B8D58, redo lsn=2/474B8D20
2024-03-08 19:16:27.674 GMT [2420] LOG: checkpoint starting: time
2024-03-08 19:16:28.983 GMT [15501] dp42 at windproc LOG: could not send
data to client: Broken pipe
2024-03-08 19:16:28.983 GMT [15501] dp42 at windproc STATEMENT: select
st_setUpperLeft(rast,st_upperLeftx( r.rast), st_upperLefty(r.rast)) from
windproc , (select rast from rtab limit 1) r;
2024-03-08 19:16:28.983 GMT [15501] dp42 at windproc FATAL: connection to
client lost
2024-03-08 19:16:28.983 GMT [15501] dp42 at windproc STATEMENT: select
st_setUpperLeft(rast,st_upperLeftx( r.rast), st_upperLefty(r.rast)) from
windproc , (select rast from rtab limit 1) r;
2024-03-08 19:16:31.817 GMT [2420] LOG: checkpoint complete: wrote 41
buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.043 s,
sync=0.026 s, total=4.146 s; sync files=34, longest=0.010 s, average=0.001
s; distance=181 kB, estimate=181 kB; lsn=2/474E6450, redo lsn=2/474E6418
postgres version PostgreSQL 16.2 (Ubuntu 16.2-1.pgdg23.10+1) on x86_64-pc-
linux-gnu, compiled by gcc (Ubuntu 13.2.0-4ubuntu3) 13.2.0, 64-bit
POSTGIS="3.4.2 c19ce56" [EXTENSION] PGSQL="160" GEOS="3.12.0-CAPI-1.18.0"
PROJ="9.2.1 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org
USER_WRITABLE_DIRECTORY=/tmp/proj DATABASE_PATH=/usr/share/proj/proj.db"
GDAL="GDAL 3.7.1, released 2023/07/06" LIBXML="2.9.14" LIBJSON="0.17"
LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)" (core procs from "3.4.1
ca035b9" need upgrade) RASTER (raster procs from "3.4.1 ca035b9" need
upgrade)
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5693>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list