Opened 6 months ago

Closed 6 months ago

#5591 closed defect (fixed)

Upgrading to 3.3.5dev: ERROR: extension "postgis" has no update path from version "3.3.5dev" to version "ANY"

Reported by: strk Owned by: strk
Priority: blocker Milestone: PostGIS 3.3.5
Component: QA/testsuite Version: 3.3.x
Keywords: Cc:

Description

After backporting run_test.pl to the stable-3.3 branch we got these failures:

Upgrading PostGIS in 'postgis_reg-3.3' using: ALTER EXTENSION postgis UPDATE TO 'ANY'; ALTER EXTENSION postgis UPDATE TO '3.3.5dev'
...
ERROR:  extension "postgis" has no update path from version "3.3.5dev" to version "ANY"

See https://woodie.osgeo.org/repos/30/pipeline/1379/6#L3915

I guess run_test.pl is just assuming too much about the target database upgrade mechanism (ANY was introduced in 3.4?)

Change History (6)

comment:1 by strk, 6 months ago

I confirm commit [fb96c51744307232166e48d600b6ca9e1fbb7900/git] changed the run_test.pl in stable-3.3 from using the "next" suffix to using "ANY". I guess we want to use either one or the other based on target version.

comment:2 by strk, 6 months ago

it's to be noted that I didn't notice this because on MY system the 3.3.5dev—ANY upgrade is available because I wanted it to be able to upgrade to current master and thus used postgis install-extension-upgrades 3.3.5dev which installed that file.

comment:3 by Sandro Santilli <strk@…>, 6 months ago

In 0ea22f44/git:

run_test.pl: fix extension upgrades to 3.3 targets

It was 3.4.0 introducing the ANY intermediate path, not 3.3.0

References #5591 in master branch (3.5.0dev)

comment:4 by strk, 6 months ago

Component: postgisQA/testsuite
Owner: changed from pramsey to strk

comment:5 by Sandro Santilli <strk@…>, 6 months ago

In fafdbc3/git:

run_test.pl: fix extension upgrades to 3.3 targets

It was 3.4.0 introducing the ANY intermediate path, not 3.3.0

References #5591 in 3.4 branch (3.4.1dev)

comment:6 by Sandro Santilli <strk@…>, 6 months ago

Resolution: fixed
Status: newclosed

In f01a765/git:

run_test.pl: fix extension upgrades to 3.3 targets

It was 3.4.0 introducing the ANY intermediate path, not 3.3.0

Closes #5591 in 3.3 branch (3.3.5dev)

Note: See TracTickets for help on using tickets.