[postgis-tickets] [PostGIS] #5301: PostgreSQL 11 3.0.1 upgrade to 3.3.2 fails with ERROR: row is too big: size 8824, maximum size 8160

[PostGIS]

#5301: PostgreSQL 11 3.0.1 upgrade to 3.3.2 fails with ERROR:  row is too big:
size 8824, maximum size 8160
------------------------------------+---------------------------
  Reporter:  robe                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  medium                 |  Milestone:  PostGIS 3.3.3
 Component:  build/upgrade/install  |    Version:  3.3.x
Resolution:                         |   Keywords:
------------------------------------+---------------------------
Comment (by robe):

 Okay the good news is this issue shouldn't be very common and I don't
 think it's the issue I thought it was.  I think it's the backup config at
 fault.  Now I remember that's the last time I have seen this issue before.


 To try to check if the issue was what I thought it was:
 To try to replicate I did this:


 {{{
 CREATE EXTENSION postgis; --3.3.2

 TRUNCATE TABLE spatial_ref_sys;

 -- restored the backup of spatial_ref_sys I was given

 SELECT COUNT(*) FROM spatial_ref_sys;
 -- output 471 rows

 SELECT postgis_extensions_upgrade();   -- worked fine


 SELECT count(*) FROM spatial_ref_sys;  -- 8508 rows
 }}}



 So update of spatial_ref_sys entries I suspect is not the culprit here.
 My next guess is our long
 call to


 {{{
 SELECT pg_catalog.pg_extension_config_dump('spatial_ref_sys', 'WHERE NOT
 (...');
 }}}

 There was a time which I thought it was fixed, when I complained to Tom
 Lane about this that instead of overriting it just kept on appending to
 it.  I forget his comment about it and if he thought it should behave that
 was or is something that needs fixing or if I was supposed to be doing
 something different.

 So next time I have access to that system I'll check what kind of mess
 that entry looks like.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5301#comment:4>
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.