[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 trac at osgeo.org
Sun Dec 11 10:09:30 PST 2022


#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):

 I did a quick test running pg_extensions_postgis_upgrade() in a DO loop
 100 times.


 {{{
 DO $$
     BEGIN
         FOR i IN 1..100 LOOP
             PERFORM postgis_extensions_upgrade();
             COMMIT;
         END LOOP;
     END;
 $$;
 }}}

 and I checked:

 {{{
 SELECT extcondition
         FROM pg_catalog.pg_extension where extname = 'postgis';
 }}}

 and it's not appending, so I think that old issue I remembered is long
 fixed.

 I guess I'll just have to wait till I have access to that server again, so
 confirm that is just filled in with piles of stuff.

 It is still a little suspicious it only broke on 3.3.2 upgrade and not any
 of the others.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5301#comment:5>
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