Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upgrade to NC 21 with official Helm chart #26395

Closed
angelnu opened this issue Mar 31, 2021 · 6 comments
Closed

Upgrade to NC 21 with official Helm chart #26395

angelnu opened this issue Mar 31, 2021 · 6 comments
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap bug

Comments

@angelnu
Copy link

angelnu commented Mar 31, 2021

How to use GitHub

  • Please use the 👍 reaction to show that you are affected by the same issue.
  • Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
  • Subscribe to receive notifications on status change and new comments.

Steps to reproduce

  1. Running sucesfully with NC 20 in K8S with PostgreSQL 13
  2. Upgraded docker container tag to "21.0.0". Config can be seen [here](
  3. Exec into container to manually run sudo -u www-data php -d memory_limit=-1 ./occ upgrade -vvv

Expected behaviour

upgrade should complete

Actual behaviour

Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
2021-03-31T12:55:06+00:00 Setting log level to debug
2021-03-31T12:55:06+00:00 Repair step: Repair MySQL collation
2021-03-31T12:55:06+00:00 Repair info: Not a mysql database -> nothing to do
2021-03-31T12:55:06+00:00 Repair step: Repair SQLite autoincrement
2021-03-31T12:55:06+00:00 Repair step: Copy data from accounts table when migrating from ownCloud
2021-03-31T12:55:06+00:00 Repair step: Drop account terms table when migrating from ownCloud
2021-03-31T12:55:06+00:00 Updating database schema
2021-03-31T12:55:08+00:00 Doctrine\DBAL\Exception: Unknown database type name requested, Doctrine\DBAL\Platforms\PostgreSQL100Platform may not support it.
2021-03-31T12:55:08+00:00 Update failed
2021-03-31T12:55:08+00:00 Maintenance mode is kept active
2021-03-31T12:55:08+00:00 Resetting log level

Server configuration

Operating system: x86_64 Ubuntu 20.04 with microk8s snap

Web server: Apache 2.4.38 as in Nextcloud docker 21.0.0

Database: PostgreSQL 13

PHP version: PHP 7.4 in Nextcloud docker 21.0.0

Nextcloud version: 21.0.0

Updated from an older Nextcloud/ownCloud or fresh install: Upgraded, originally from ownCloud but now from NC 20.0.8

Where did you install Nextcloud from: Docker Hub

Signing status:

Signing status ``` NA - cannot log-in while in maintenance ```

List of activated apps:

App list
Enabled:
  - accessibility: 1.6.0
  - activity: 2.13.4
  - admin_audit: 1.10.0
  - cloud_federation_api: 1.3.0
  - comments: 1.10.0
  - contactsinteraction: 1.1.0
  - dav: 1.16.2
  - federatedfilesharing: 1.10.2
  - federation: 1.10.1
  - files: 1.15.0
  - files_external: 1.11.1
  - files_pdfviewer: 2.0.1
  - files_rightclick: 0.17.0
  - files_sharing: 1.12.2
  - files_trashbin: 1.10.1
  - files_versions: 1.13.0
  - files_videoplayer: 1.9.0
  - firstrunwizard: 2.9.0
  - logreader: 2.5.0
  - lookup_server_connector: 1.8.0
  - nextcloud_announcements: 1.9.0
  - notifications: 2.8.0
  - oauth2: 1.8.0
  - password_policy: 1.10.1
  - photos: 1.2.3
  - privacy: 1.4.0
  - provisioning_api: 1.10.0
  - recommendations: 0.8.0
  - serverinfo: 1.10.0
  - settings: 1.2.0
  - sharebymail: 1.10.0
  - support: 1.3.0
  - survey_client: 1.8.0
  - systemtags: 1.10.0
  - text: 3.1.0
  - theming: 1.11.0
  - twofactor_backupcodes: 1.9.0
  - updatenotification: 1.10.0
  - user_ldap: 1.10.2
  - user_status: 1.0.1
  - viewer: 1.4.0
  - weather_status: 1.0.0
  - workflowengine: 2.2.0
Disabled:
  - dashboard
  - encryption

Nextcloud configuration:

Config report
{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": {
            "0": "nextcloud.home.angelnu.com",
            "1": "10.34.0.170",
            "2": "localhost",
            "3": "nextcloud",
            "6": "nextcloud.angelnu.com"
        },
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "forwarded_for_headers": [
            "HTTP_X_FORWARDED_FOR"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "http:\/\/localhost",
        "dbtype": "pgsql",
        "version": "20.0.8.1",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "5432",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "overwriteprotocol": "https",
        "maintenance": true,
        "loglevel": 0,
        "updater.release.channel": "stable",
        "theme": "",
        "mail_sendmailmode": "smtp",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25",
        "app_install_overwrite": [
            "gluusso"
        ],
        "updater.secret": "***REMOVED SENSITIVE VALUE***",
        "ldapIgnoreNamingRules": false,
        "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory"
    }
}

Are you using external storage, if yes which one: NFS mounted as local by K8S

Are you using encryption: no

Are you using an external user-backend, if yes which one: None yet

Client configuration

Browser: Firefox 86.0.1

Operating system: Windows 10

Logs

Web server error log

Web server error log
10.1.167.77 - javier [31/Mar/2021:13:34:03 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - mireille [31/Mar/2021:13:34:07 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - eduardo [31/Mar/2021:13:34:08 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/2.6.5stable-Win64 (build 20200710) (Nextcloud)"
10.1.167.75 - javier [31/Mar/2021:13:34:21 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.77 - windows [31/Mar/2021:13:34:25 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - windows [31/Mar/2021:13:34:33 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.75 - mireille [31/Mar/2021:13:34:33 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.77 - javier [31/Mar/2021:13:34:35 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - mireille [31/Mar/2021:13:34:39 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.77 - eduardo [31/Mar/2021:13:34:40 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/2.6.5stable-Win64 (build 20200710) (Nextcloud)"
10.1.167.75 - javier [31/Mar/2021:13:34:53 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - - [31/Mar/2021:13:34:56 +0000] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 503 1144 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36"
10.1.167.77 - windows [31/Mar/2021:13:34:57 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.77 - windows [31/Mar/2021:13:35:05 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.77 - mireille [31/Mar/2021:13:35:05 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.75 - javier [31/Mar/2021:13:35:07 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - - [31/Mar/2021:13:35:09 +0000] "GET /cron.php HTTP/1.1" 200 1505 "-" "curl/7.64.0"
10.1.167.77 - mireille [31/Mar/2021:13:35:11 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - eduardo [31/Mar/2021:13:35:12 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/2.6.5stable-Win64 (build 20200710) (Nextcloud)"
10.1.167.75 - javier [31/Mar/2021:13:35:25 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.77 - windows [31/Mar/2021:13:35:29 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - - [31/Mar/2021:13:35:35 +0000] "GET / HTTP/1.1" 503 7471 "-" "Statping"
10.1.167.75 - windows [31/Mar/2021:13:35:37 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.77 - mireille [31/Mar/2021:13:35:37 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.75 - javier [31/Mar/2021:13:35:39 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.77 - mireille [31/Mar/2021:13:35:43 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.77 - eduardo [31/Mar/2021:13:35:44 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/2.6.5stable-Win64 (build 20200710) (Nextcloud)"
10.1.167.77 - javier [31/Mar/2021:13:35:57 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - windows [31/Mar/2021:13:36:01 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - jose [31/Mar/2021:13:36:04 +0000] "GET /status.php HTTP/1.1" 200 1150 "-" "Mozilla/5.0 (Linux) mirall/2.6.5-20200713.144448.adada8b2e-1.0~bionic1 (Nextcloud)"
10.1.167.77 - mireille [31/Mar/2021:13:36:09 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.77 - windows [31/Mar/2021:13:36:09 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.75 - jose [31/Mar/2021:13:36:09 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Linux) mirall/2.6.5-20200713.144448.adada8b2e-1.0~bionic1 (Nextcloud)"
10.1.167.77 - javier [31/Mar/2021:13:36:11 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - mireille [31/Mar/2021:13:36:15 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - eduardo [31/Mar/2021:13:36:16 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/2.6.5stable-Win64 (build 20200710) (Nextcloud)"
10.1.167.77 - jose [31/Mar/2021:13:36:28 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Linux) mirall/2.6.5-20200713.144448.adada8b2e-1.0~bionic1 (Nextcloud)"
10.1.167.77 - javier [31/Mar/2021:13:36:29 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - windows [31/Mar/2021:13:36:33 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - windows [31/Mar/2021:13:36:41 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.75 - mireille [31/Mar/2021:13:36:41 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.77 - javier [31/Mar/2021:13:36:43 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - mireille [31/Mar/2021:13:36:47 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - eduardo [31/Mar/2021:13:36:48 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/2.6.5stable-Win64 (build 20200710) (Nextcloud)"
10.1.167.77 - - [31/Mar/2021:13:36:56 +0000] "GET /index.php/csrftoken HTTP/1.1" 503 10994 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36"
10.1.167.77 - jose [31/Mar/2021:13:37:00 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Linux) mirall/2.6.5-20200713.144448.adada8b2e-1.0~bionic1 (Nextcloud)"
10.1.167.77 - javier [31/Mar/2021:13:37:01 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - windows [31/Mar/2021:13:37:05 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.77 - - [31/Mar/2021:13:37:07 +0000] "PUT /index.php/apps/user_status/heartbeat HTTP/1.1" 503 10749 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:86.0) Gecko/20100101 Firefox/86.0"
10.1.167.77 - mireille [31/Mar/2021:13:37:13 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.75 - windows [31/Mar/2021:13:37:13 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.75 - javier [31/Mar/2021:13:37:15 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - mireille [31/Mar/2021:13:37:19 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - eduardo [31/Mar/2021:13:37:20 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/2.6.5stable-Win64 (build 20200710) (Nextcloud)"
10.1.167.75 - jose [31/Mar/2021:13:37:32 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Linux) mirall/2.6.5-20200713.144448.adada8b2e-1.0~bionic1 (Nextcloud)"
10.1.167.77 - javier [31/Mar/2021:13:37:33 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.75 - - [31/Mar/2021:13:37:36 +0000] "GET / HTTP/1.1" 503 7469 "-" "Statping"
10.1.167.75 - windows [31/Mar/2021:13:37:37 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.77 - - [31/Mar/2021:13:37:40 +0000] "GET /index.php/204 HTTP/1.1" 503 7463 "-" "Mozilla/5.0 (Android) Nextcloud-android/3.15.1"
10.1.167.75 - windows [31/Mar/2021:13:37:45 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.75 - mireille [31/Mar/2021:13:37:45 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.2stable-Win64 (build 20210128) (Nextcloud)"
10.1.167.77 - javier [31/Mar/2021:13:37:47 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.77 - mireille [31/Mar/2021:13:37:51 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.77 - eduardo [31/Mar/2021:13:37:52 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/2.6.5stable-Win64 (build 20200710) (Nextcloud)"
10.1.167.77 - - [31/Mar/2021:13:37:53 +0000] "GET /index.php/204 HTTP/1.1" 503 7463 "-" "Mozilla/5.0 (Android) Nextcloud-android/3.15.1"
10.1.167.77 - jose [31/Mar/2021:13:38:04 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Linux) mirall/2.6.5-20200713.144448.adada8b2e-1.0~bionic1 (Nextcloud)"
10.1.167.75 - javier [31/Mar/2021:13:38:05 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"
10.1.167.77 - - [31/Mar/2021:13:38:08 +0000] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 503 1144 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:86.0) Gecko/20100101 Firefox/86.0"
10.1.167.77 - windows [31/Mar/2021:13:38:09 +0000] "GET /status.php HTTP/1.1" 200 1051 "-" "Mozilla/5.0 (Windows) mirall/3.1.3stable-Win64 (build 20210218) (Nextcloud)"

Nextcloud log (data/nextcloud.log)

Nextcloud log
{"reqId":"sk7QFsgpiWfaMB6Ki2jO","level":1,"time":"2021-03-31T13:39:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Repair::info: Repair info: Not a mysql database -> nothing to do","userAgent":"--","version":"20.0.8.1"}
{"reqId":"sk7QFsgpiWfaMB6Ki2jO","level":1,"time":"2021-03-31T13:39:43+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"--","version":"20.0.8.1"}
{"reqId":"sk7QFsgpiWfaMB6Ki2jO","level":1,"time":"2021-03-31T13:39:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Repair::step: Repair step: Repair SQLite autoincrement","userAgent":"--","version":"20.0.8.1"}
{"reqId":"sk7QFsgpiWfaMB6Ki2jO","level":1,"time":"2021-03-31T13:39:43+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"--","version":"20.0.8.1"}
{"reqId":"sk7QFsgpiWfaMB6Ki2jO","level":1,"time":"2021-03-31T13:39:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Repair::step: Repair step: Copy data from accounts table when migrating from ownCloud","userAgent":"--","version":"20.0.8.1"}
{"reqId":"sk7QFsgpiWfaMB6Ki2jO","level":3,"time":"2021-03-31T13:39:44+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"Unknown database type name requested, Doctrine\\DBAL\\Platforms\\PostgreSQL100Platform may not support it.","Code":0,"Trace":[{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":231,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Exception"}]},{"file":"/var/www/html/lib/private/Repair/Owncloud/SaveAccountsTableData.php","line":102,"function":"createSchema","class":"OC\\DB\\ConnectionAdapter","type":"->","args":[]},{"file":"/var/www/html/lib/private/Repair/Owncloud/SaveAccountsTableData.php","line":70,"function":"shouldRun","class":"OC\\Repair\\Owncloud\\SaveAccountsTableData","type":"->","args":[]},{"file":"/var/www/html/lib/private/Repair.php","line":117,"function":"run","class":"OC\\Repair\\Owncloud\\SaveAccountsTableData","type":"->","args":[{"__class__":"OC\\Repair"}]},{"file":"/var/www/html/lib/private/Updater.php","line":247,"function":"run","class":"OC\\Repair","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":132,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["21.0.0.18","20.0.8.1"]},{"file":"/var/www/html/core/Command/Upgrade.php","line":255,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/3rdparty/symfony/console/Command/Command.php","line":255,"function":"execute","class":"OC\\Core\\Command\\Upgrade","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":1009,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":273,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"installer":{"__class__":"OC\\Installer"},"__class__":"OC\\Core\\Command\\Upgrade"},{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":149,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/lib/private/Console/Application.php","line":215,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/console.php","line":100,"function":"run","class":"OC\\Console\\Application","type":"->","args":[]},{"file":"/var/www/html/occ","line":11,"args":["/var/www/html/console.php"],"function":"require_once"}],"File":"/var/www/html/lib/private/DB/Exceptions/DbalException.php","Line":70,"Previous":{"Exception":"Doctrine\\DBAL\\Exception","Message":"Unknown database type name requested, Doctrine\\DBAL\\Platforms\\PostgreSQL100Platform may not support it.","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Schema/PostgreSQLSchemaManager.php","line":355,"function":"getDoctrineTypeMapping","class":"Doctrine\\DBAL\\Platforms\\AbstractPlatform","type":"->","args":["name"]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Schema/AbstractSchemaManager.php","line":826,"function":"_getPortableTableColumnDefinition","class":"Doctrine\\DBAL\\Schema\\PostgreSQLSchemaManager","type":"->","args":[{"attnum":9,"field":"jobname","type":"name","complete_type":"name","collation":"C","domain_type":null,"domain_complete_type":null,"isnotnull":false,"pri":null,"default":null,"comment":null,"name":""}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Schema/AbstractSchemaManager.php","line":172,"function":"_getPortableTableColumnList","class":"Doctrine\\DBAL\\Schema\\AbstractSchemaManager","type":"->","args":["cron.job","postgres",[{"attnum":1,"field":"jobid","type":"int8","complete_type":"bigint","collation":null,"domain_type":null,"domain_complete_type":null,"isnotnull":true,"pri":"t","default":"nextval('cron.jobid_seq'::regclass)","comment":null},{"attnum":2,"field":"schedule","type":"text","complete_type":"text","collation":"","domain_type":null,"domain_complete_type":null,"isnotnull":true,"pri":null,"default":null,"comment":null},{"attnum":3,"field":"command","type":"text","complete_type":"text","collation":"","domain_type":null,"domain_complete_type":null,"isnotnull":true,"pri":null,"default":null,"comment":null},{"attnum":4,"field":"nodename","type":"text","complete_type":"text","collation":"","domain_type":null,"domain_complete_type":null,"isnotnull":true,"pri":null,"default":"'localhost'::text","comment":null},{"attnum":5,"field":"nodeport","type":"int4","complete_type":"integer","collation":null,"domain_type":null,"domain_complete_type":null,"isnotnull":true,"pri":null,"default":"inet_server_port()","comment":null},{"attnum":6,"field":"database","type":"text","complete_type":"text","collation":"","domain_type":null,"domain_complete_type":null,"isnotnull":true,"pri":null,"default":"current_database()","comment":null},{"attnum":7,"field":"username","type":"text","complete_type":"text","collation":"","domain_type":null,"domain_complete_type":null,"isnotnull":true,"pri":null,"default":"CURRENT_USER","comment":null},{"attnum":8,"field":"active","type":"bool","complete_type":"boolean","collation":null,"domain_type":null,"domain_complete_type":null,"isnotnull":true,"pri":null,"default":"true","comment":null},{"attnum":9,"field":"jobname","type":"name","complete_type":"name","collation":"C","domain_type":null,"domain_complete_type":null,"isnotnull":false,"pri":null,"default":null,"comment":null}]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Schema/AbstractSchemaManager.php","line":276,"function":"listTableColumns","class":"Doctrine\\DBAL\\Schema\\AbstractSchemaManager","type":"->","args":["cron.job"]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Schema/PostgreSQLSchemaManager.php","line":512,"function":"listTableDetails","class":"Doctrine\\DBAL\\Schema\\AbstractSchemaManager","type":"->","args":["cron.job"]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Schema/AbstractSchemaManager.php","line":261,"function":"listTableDetails","class":"Doctrine\\DBAL\\Schema\\PostgreSQLSchemaManager","type":"->","args":["cron.job"]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Schema/AbstractSchemaManager.php","line":1074,"function":"listTables","class":"Doctrine\\DBAL\\Schema\\AbstractSchemaManager","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Migrator.php","line":188,"function":"createSchema","class":"Doctrine\\DBAL\\Schema\\AbstractSchemaManager","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":511,"function":"createSchema","class":"OC\\DB\\Migrator","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":229,"function":"createSchema","class":"OC\\DB\\Connection","type":"->","args":[]},{"file":"/var/www/html/lib/private/Repair/Owncloud/SaveAccountsTableData.php","line":102,"function":"createSchema","class":"OC\\DB\\ConnectionAdapter","type":"->","args":[]},{"file":"/var/www/html/lib/private/Repair/Owncloud/SaveAccountsTableData.php","line":70,"function":"shouldRun","class":"OC\\Repair\\Owncloud\\SaveAccountsTableData","type":"->","args":[]},{"file":"/var/www/html/lib/private/Repair.php","line":117,"function":"run","class":"OC\\Repair\\Owncloud\\SaveAccountsTableData","type":"->","args":[{"__class__":"OC\\Repair"}]},{"file":"/var/www/html/lib/private/Updater.php","line":247,"function":"run","class":"OC\\Repair","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":132,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["21.0.0.18","20.0.8.1"]},{"file":"/var/www/html/core/Command/Upgrade.php","line":255,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/3rdparty/symfony/console/Command/Command.php","line":255,"function":"execute","class":"OC\\Core\\Command\\Upgrade","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":1009,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":273,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"installer":{"__class__":"OC\\Installer"},"__class__":"OC\\Core\\Command\\Upgrade"},{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":149,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/lib/private/Console/Application.php","line":215,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/console.php","line":100,"function":"run","class":"OC\\Console\\Application","type":"->","args":[]},{"file":"/var/www/html/occ","line":11,"args":["/var/www/html/console.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Platforms/AbstractPlatform.php","Line":398},"CustomMessage":"--"},"userAgent":"--","version":"20.0.8.1"}
{"reqId":"sk7QFsgpiWfaMB6Ki2jO","level":3,"time":"2021-03-31T13:39:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::failure: OC\\DB\\Exceptions\\DbalException: Unknown database type name requested, Doctrine\\DBAL\\Platforms\\PostgreSQL100Platform may not support it.","userAgent":"--","version":"20.0.8.1"}
{"reqId":"sk7QFsgpiWfaMB6Ki2jO","level":3,"time":"2021-03-31T13:39:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::updateEnd: Update failed","userAgent":"--","version":"20.0.8.1"}
{"reqId":"sk7QFsgpiWfaMB6Ki2jO","level":1,"time":"2021-03-31T13:39:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::maintenanceActive: Maintenance mode is kept active","userAgent":"--","version":"20.0.8.1"}
{"reqId":"sk7QFsgpiWfaMB6Ki2jO","level":1,"time":"2021-03-31T13:39:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::resetLogLevel: Reset log level to Debug(0)","userAgent":"--","version":"20.0.8.1"}

Browser log

Browser log
NA during maintenance
@angelnu angelnu added 0. Needs triage Pending check for reproducibility or if it fits our roadmap bug labels Mar 31, 2021
@angelnu
Copy link
Author

angelnu commented Mar 31, 2021

I am able to go back to NC 20.0.8 so I will stay there for now but I can easily reproduce this problem again if additional debug data is required.

My full GtiOps settings for Nextcloud are publicly available at https://github.com/angelnu/k8s-gitops/blob/c3457338d0c2a28693f2cdd1b28b9ad2f3fbba3f/apps/base/default/nextcloud/release.yaml

@kesselb
Copy link
Contributor

kesselb commented Mar 31, 2021

Fixed by #25882. As workaround move tables unrelated to nextcloud to a different database or wait for 21.0.1.

@kesselb kesselb closed this as completed Mar 31, 2021
@angelnu
Copy link
Author

angelnu commented Mar 31, 2021

@kesselb - I saw that issue and checked that I did not have any external tables: I only have oc_ tables and postgres_logs in my DB. To double check I also patched my install with the same line that filters non oc_ tables but still the same error.

I will add the list of tables:

You are now connected to database "postgres" as user "postgres".
postgres=# \dt
                    List of relations
 Schema |            Name             | Type  |  Owner   
--------+-----------------------------+-------+----------
 public | oc_accounts                 | table | postgres
 public | oc_activity                 | table | postgres
 public | oc_activity_mq              | table | postgres
 public | oc_addressbookchanges       | table | postgres
 public | oc_addressbooks             | table | postgres
 public | oc_appconfig                | table | postgres
 public | oc_authtoken                | table | postgres
 public | oc_bruteforce_attempts      | table | postgres
 public | oc_calendar_invitations     | table | postgres
 public | oc_calendar_reminders       | table | postgres
 public | oc_calendar_resources       | table | postgres
 public | oc_calendar_resources_md    | table | postgres
 public | oc_calendar_rooms           | table | postgres
 public | oc_calendar_rooms_md        | table | postgres
 public | oc_calendarchanges          | table | postgres
 public | oc_calendarobjects          | table | postgres
 public | oc_calendarobjects_props    | table | postgres
 public | oc_calendars                | table | postgres
 public | oc_calendarsubscriptions    | table | postgres
 public | oc_cards                    | table | postgres
 public | oc_cards_properties         | table | postgres
 public | oc_carnet_metadata          | table | postgres
 public | oc_circles_circles          | table | postgres
 public | oc_circles_clouds           | table | postgres
 public | oc_circles_groups           | table | postgres
 public | oc_circles_links            | table | postgres
 public | oc_circles_members          | table | postgres
 public | oc_circles_shares           | table | postgres
 public | oc_collres_accesscache      | table | postgres
 public | oc_collres_collections      | table | postgres
 public | oc_collres_resources        | table | postgres
 public | oc_comments                 | table | postgres
 public | oc_comments_read_markers    | table | postgres
 public | oc_dav_cal_proxy            | table | postgres
 public | oc_dav_shares               | table | postgres
 public | oc_deck_assigned_labels     | table | postgres
 public | oc_deck_assigned_users      | table | postgres
 public | oc_deck_attachment          | table | postgres
 public | oc_deck_board_acl           | table | postgres
 public | oc_deck_boards              | table | postgres
 public | oc_deck_cards               | table | postgres
 public | oc_deck_labels              | table | postgres
 public | oc_deck_stacks              | table | postgres
 public | oc_direct_edit              | table | postgres
 public | oc_directlink               | table | postgres
 public | oc_external_applicable      | table | postgres
 public | oc_external_config          | table | postgres
 public | oc_external_mounts          | table | postgres
 public | oc_external_options         | table | postgres
 public | oc_federated_reshares       | table | postgres
 public | oc_file_locks               | table | postgres
 public | oc_filecache                | table | postgres
 public | oc_filecache_extended       | table | postgres
 public | oc_files_trash              | table | postgres
 public | oc_flow_checks              | table | postgres
 public | oc_flow_operations          | table | postgres
 public | oc_flow_operations_scope    | table | postgres
 public | oc_flowupload_directories   | table | postgres
 public | oc_gluu_sso                 | table | postgres
 public | oc_group_admin              | table | postgres
 public | oc_group_folders            | table | postgres
 public | oc_group_folders_acl        | table | postgres
 public | oc_group_folders_groups     | table | postgres
 public | oc_group_folders_manage     | table | postgres
 public | oc_group_folders_trash      | table | postgres
 public | oc_group_user               | table | postgres
 public | oc_groups                   | table | postgres
 public | oc_jobs                     | table | postgres
 public | oc_ldap_group_mapping       | table | postgres
 public | oc_ldap_group_members       | table | postgres
 public | oc_ldap_user_mapping        | table | postgres
 public | oc_login_flow_v2            | table | postgres
 public | oc_migrations               | table | postgres
 public | oc_mimetypes                | table | postgres
 public | oc_mounts                   | table | postgres
 public | oc_news_feeds               | table | postgres
 public | oc_news_folders             | table | postgres
 public | oc_news_items               | table | postgres
 public | oc_notes_meta               | table | postgres
 public | oc_notifications            | table | postgres
 public | oc_notifications_pushtokens | table | postgres
 public | oc_oauth2_access_tokens     | table | postgres
 public | oc_oauth2_clients           | table | postgres
 public | oc_pdfdraw_items            | table | postgres
 public | oc_preferences              | table | postgres
 public | oc_privacy_admins           | table | postgres
 public | oc_properties               | table | postgres
 public | oc_recent_contact           | table | postgres
 public | oc_richdocuments_assets     | table | postgres
 public | oc_richdocuments_direct     | table | postgres
 public | oc_richdocuments_wopi       | table | postgres
 public | oc_schedulingobjects        | table | postgres
 public | oc_share                    | table | postgres
 public | oc_share_external           | table | postgres
 public | oc_sociallogin_connect      | table | postgres
 public | oc_storages                 | table | postgres
 public | oc_storages_credentials     | table | postgres
 public | oc_systemtag                | table | postgres
 public | oc_systemtag_group          | table | postgres
 public | oc_systemtag_object_mapping | table | postgres
 public | oc_text_documents           | table | postgres
 public | oc_text_sessions            | table | postgres
 public | oc_text_steps               | table | postgres
 public | oc_trusted_servers          | table | postgres
 public | oc_twofactor_backupcodes    | table | postgres
 public | oc_twofactor_providers      | table | postgres
 public | oc_user_status              | table | postgres
 public | oc_user_transfer_owner      | table | postgres
 public | oc_users                    | table | postgres
 public | oc_vcategory                | table | postgres
 public | oc_vcategory_to_object      | table | postgres
 public | oc_webauthn                 | table | postgres
 public | oc_whats_new                | table | postgres
 public | postgres_log                | table | postgres
(114 rows)

@angelnu
Copy link
Author

angelnu commented Mar 31, 2021

@kesselb - please also notice that the error is different:
Unknown database type name requested
vs
Unknown database type enum requested

@kesselb
Copy link
Contributor

kesselb commented Mar 31, 2021

any external tables

cron.job is the table.

Unknown database type name requested vs Unknown database type enum requested

https://github.com/nextcloud/3rdparty/blob/67f4c90ffb75bdd5c3deb79cef8a9a4122ca8e55/doctrine/dbal/src/Platforms/AbstractPlatform.php#L399

name or enum - the reason is the same.

@angelnu
Copy link
Author

angelnu commented Mar 31, 2021

I see - thanks! I did not see that the offending table was in the log.

It seems to be added by Patroni which is part of the Zalando K8S operator for Postgress.

Weird that it did not show up in the tables dump - I will check the fix again and see that it fixes the issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap bug
Projects
None yet
Development

No branches or pull requests

2 participants