Database crash when creating raster_in function

[Regina Obe]

Most of that fix should already be in the PG15 3.3.5 except for the parts that have PG16 guards, cause they wouldn’t work in PG15 or lower.

So If you find trying to reapply to 3.3.5 works I’d be surprised and be interested in which portion of patch you applied.

 

 

 

From: Nikhil Shetty <nikhil.dba04 at gmail.com> 
Sent: Sunday, March 17, 2024 9:49 AM
To: Regina Obe <lr at pcorp.us>
Cc: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: Database crash when creating raster_in function

 

I am  are using raster extension 

 

The creation of raster_in function breaks on PG15 as well, JFYI, I have created package for 3.3.5 on rhel7(this is not available in Postgres repo)

 

Will the fix given in 

  <https://trac.osgeo.org/postgis/ticket/5277> https://trac.osgeo.org/postgis/ticket/5277

 solve the issue? if yes, I can add the same fix and create new rpms for 3.3.5 on rhel7

 

Thanks,

Nikhil

 

On Sun, 17 Mar 2024 at 10:07, Regina Obe <lr at pcorp.us <mailto:lr at pcorp.us> > wrote:

Yap that was fixed in PostGIS 3.3.3.

The change there was to support a change in PG16, so you shouldn’t need it for upgrading from PG13 to PG15.

 

Are you using postgis_raster or you just have it installed?

 

If you don’t need postgis_raster, I would suggest uninstalling it before upgrading. 

 

From: Nikhil Shetty <nikhil.dba04 at gmail.com <mailto:nikhil.dba04 at gmail.com> > 
Sent: Saturday, March 16, 2024 10:55 AM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> >
Subject: Database crash when creating raster_in function

 

Hi Team,

 

I am trying to upgrade the postgres database from PG13 to PG15. pg_upgrade is crashing with below error when creating the raster_in function

 

pg_restore: creating FUNCTION "public.raster_in("cstring")"
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 394; 1255 16439 FUNCTION raster_in("cstring") postgres
pg_restore: error: could not execute query: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Command was: CREATE FUNCTION "public"."raster_in"("cstring") RETURNS "public"."raster"
    LANGUAGE "c" IMMUTABLE STRICT PARALLEL SAFE
    AS '$libdir/postgis_raster-3', 'RASTER_in';

 

 

PostGIS version : 3.3.5

 

This looks similar to the issue mentioned in https://trac.osgeo.org/postgis/ticket/5277. Is this fixed in 3.3.5 ?

 

Thanks,

Nikhil

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240318/814ca70b/attachment.htm>