Upgrade to latest release failed 8/21/25

Support
1

The latest upgrade required rebuilding the app in launcher, but it failed.

First it complained about having the adplugin as a separate install, so I removed that.

Looks like then it failed trying to migrate the secondsite database:

2025-08-21 06:44:42.493 UTC [867] discourse@discourse_nu ERROR: must be owner of extension vector
2025-08-21 06:44:42.493 UTC [867] discourse@discourse_nu STATEMENT: ALTER EXTENSION vector UPDATE TO ‘0.7.0’;

1 migrations failed!

Failed to migrate secondsite

2

Cause

  • The migration tries to upgrade the “vector” extension.
  • The PostgreSQL user running the migration (e.g. discourse) must be the owner of the extension, but it’s owned by a different user (often postgres).

Solution

  • Connect to your database as the owner
  • Run the update as the owner

Checkout the discussion on the same Still an issue: ERROR: must be owner of extension vector - #2 by Falco

3

That fixed it.

However, the problem with nginx and secondsites that I reported over a year ago is still there,

in the nginx config files within the container, it checks to see if the URL is not for the first site and changes it to that. I commented out that code–again.

1 Like