search

nextcloud / all-in-one

📦 The official Nextcloud installation method. Provides easy deployment and maintenance with most features included in this one Nextcloud instance.
https://hub.docker.com/r/nextcloud/all-in-one
GNU Affero General Public License v3.0
4.63k stars 556 forks source link

Database owner nextcloud not allowed when updating from 8.3.0 to 9.0.1 #4923

Closed yannik-b closed 1 hour ago

yannik-b commented 1 week ago

Steps to reproduce

  1. Have a running Nextcloud instance with helm chart in version 8.3.0.
  2. Try an update to helm chart 9.0.1 as stated in the documentation.

Expected behavior

After a few minutes the Nextcloud should be accessable via the web interface with the new version.

Actual behavior

Nextcloud instance does not recover. In the logs of the database container, I got the following:

sed 's|Owner:||;s| ||g'
grep -a 'Name: oc_appconfig; Type: TABLE; Schema: public; Owner:' /mnt/data/database-dump.sql++ grep -oP 'Owner:.*$'

DB_OWNER=nextcloud
'[' nextcloud = nextcloud ']'
The database import failed. Please restore a backup and try again.
For further clues on what went wrong, look at the logs above.

In a earlier try, I got the issue database import failed with the notice that the database owner nextcloud must not be nextcloud or something like this.

Host OS

Debian 12, Kubernetes used

Nextcloud AIO version

AIO 9.0.1

Current channel

stable

Other valuable info

szaimen commented 1 hour ago

I got the issue database import failed with the notice that the database owner nextcloud must not be nextcloud or something like this.

Yes, this is correct. Not sure how you changed the owner?

Can you run grep -a 'Name: oc_appconfig; Type: TABLE; Schema: public; Owner:' on the database dump and post the output here?