search

nextcloud / server

☁️ Nextcloud server, a safe home for all your data
https://nextcloud.com
GNU Affero General Public License v3.0
26.93k stars 4.02k forks source link

Can't finish ALTER TABLE after enabling Mysql 4 byte support #25501

Closed maxidebiax closed 3 years ago

maxidebiax commented 3 years ago

How to use GitHub

Steps to reproduce

  1. I followed this guide: https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/mysql_4byte_support.html in order to enable Mysql 4 byte support.
  2. Now, I’m Running now: sudo -u www-data php occ maintenance:repair
  3. I'm stuck in maintenance mode

Expected behaviour

Don't be stuck in maintenance mode anymore ;)

Actual behaviour

I've got a CLI return after : sudo -u www-data php occ maintenance:repair

Here is it:

In AbstractMySALDriver.php line 106:
An exception occured while executing 'ALTER TABLE `oc_news_items` ROW_FORMAT = DYNAMIC;':
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

In PDOStatement.php line 129:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

In PDOStatement.php line 127:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

Server configuration

Operating system: Debian BUSTER

Web server: Apache 2.4.38

Database: MariaDB 10.3.27

PHP version: PHP 7.3

Nextcloud version: 19.0.8.1

Updated from an older Nextcloud/ownCloud or fresh install: Updated from........ Nextcloud 19.0.1 (and from Owncloud, right after the split between owncloud and nextcloud)

Where did you install Nextcloud from: On a dedicated server

Signing status: I can't do that, i'm in maintenance mode....

Signing status ``` Login as admin user into your Nextcloud and access I can't do that, i'm in maintenance mode.... ```

List of activated apps:

Enabled:
  - accessibility: 1.5.0
  - activity: 2.12.1
  - admin_audit: 1.9.0
  - bookmarks: 3.4.9
  - bruteforcesettings: 2.0.1
  - calendar: 2.0.4
  - cloud_federation_api: 1.2.0
  - comments: 1.9.0
  - contacts: 3.4.3
  - contactsinteraction: 1.0.0
  - dav: 1.15.0
  - federatedfilesharing: 1.9.0
  - federation: 1.9.0
  - files: 1.14.0
  - files_external: 1.10.0
  - files_pdfviewer: 1.8.0
  - files_rightclick: 0.16.0
  - files_sharing: 1.11.0
  - files_trashbin: 1.9.0
  - files_versions: 1.12.0
  - files_videoplayer: 1.8.0
  - firstrunwizard: 2.8.0
  - forms: 2.1.0
  - logreader: 2.4.0
  - lookup_server_connector: 1.7.0
  - mail: 1.4.2
  - news: 14.1.11
  - nextcloud_announcements: 1.8.0
  - notifications: 2.7.0
  - oauth2: 1.7.0
  - password_policy: 1.9.1
  - photos: 1.1.0
  - privacy: 1.3.0
  - provisioning_api: 1.9.0
  - recommendations: 0.7.0
  - serverinfo: 1.9.0
  - settings: 1.1.0
  - sharebymail: 1.9.0
  - support: 1.2.1
  - survey_client: 1.7.0
  - systemtags: 1.9.0
  - tasks: 0.13.6
  - text: 3.0.1
  - theming: 1.10.0
  - twofactor_backupcodes: 1.8.0
  - updatenotification: 1.9.0
  - viewer: 1.3.0
  - workflowengine: 2.1.0
Disabled:
  - dashboard
  - encryption
  - ocsms
  - user_ldap
  - user_status
  - weather_status
App list ``` If you have access to your command line run e.g.: sudo -u www-data php occ app:list from within your Nextcloud installation folder ```

Nextcloud configuration:

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "cloud.XXXXXXX.fr",
            "web.XXXXXXX.fr"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "http:\/\/cloud.XXXXXXX.fr",
        "dbtype": "mysql",
        "version": "19.0.8.1",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "forcessl": true,
        "forceSSLforSubdomains": true,
        "mail_smtpmode": "smtp",
        "mail_smtpsecure": "tls",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "theme": "",
        "maintenance": true,
        "loglevel": 1,
        "trashbin_retention_obligation": "auto",
        "htaccess.RewriteBase": "\/",
        "updater.release.channel": "stable",
        "mysql.utf8mb4": true
    }
}
Config report ``` If you have access to your command line run e.g.: sudo -u www-data php occ config:list system from within your Nextcloud installation folder or Insert your config.php content here. Make sure to remove all sensitive content such as passwords. (e.g. database password, passwordsalt, secret, smtp password, …) ```

Are you using external storage, if yes which one: No

Are you using encryption: No

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

Client configuration

Browser: Firefox, Chrome,....

Operating system: Windows, Linux Debian

Logs

Web server error log

Web server error log ``` 54.36.148.211 - - [05/Feb/2021:00:16:19 +0100] "GET /robots.txt HTTP/1.1" 200 369 "-" "Mozilla/5.0 (compatible; AhrefsBot/6.1; +http://ahrefs.com/robot/)" 54.36.148.74 - - [05/Feb/2021:00:16:20 +0100] "GET / HTTP/1.1" 200 26118 "-" "Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" 207.46.13.70 - - [05/Feb/2021:00:21:34 +0100] "GET /akita2/wp-content/uploads/2014/11/pedigree_katsuchiyo.jpg HTTP/1.1" 200 313481 "-" "Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:00:22:35 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:00:22:48 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:00:30:13 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:00:40:05 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:01:37:03 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:01:40:04 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 180.149.125.168 - - [05/Feb/2021:01:54:42 +0100] "GET / HTTP/1.1" 200 26370 "-" "Mozilla/5.0 (Windows NT 5.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:01:59:56 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:02:10:20 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:02:25:44 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:02:40:57 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:02:43:10 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:03:39:52 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:03:50:47 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 35.243.252.220 - - [05/Feb/2021:04:54:52 +0100] "GET /robots.txt HTTP/1.0" 200 388 "-" "ZoominfoBot (zoominfobot at zoominfo dot com)" 35.243.252.220 - - [05/Feb/2021:04:54:53 +0100] "GET / HTTP/1.0" 200 26536 "-" "ZoominfoBot (zoominfobot at zoominfo dot com)" 45.155.205.108 - - [05/Feb/2021:05:04:37 +0100] "POST /api/jsonws/invoke HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36" 45.155.205.108 - - [05/Feb/2021:05:04:37 +0100] "POST /vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36" 45.155.205.108 - - [05/Feb/2021:05:04:37 +0100] "GET /vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36" 45.155.205.108 - - [05/Feb/2021:05:04:37 +0100] "GET /solr/admin/info/system?wt=json HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36" 45.155.205.108 - - [05/Feb/2021:05:04:37 +0100] "GET /index.php?s=/Index/\\think\\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=HelloThinkPHP21 HTTP/1.1" 200 26700 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36" 45.155.205.108 - - [05/Feb/2021:05:04:37 +0100] "GET /?a=fetch&content=die(@md5(HelloThinkCMF)) HTTP/1.1" 200 26594 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36" 45.155.205.108 - - [05/Feb/2021:05:04:37 +0100] "GET /console/ HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36" 45.155.205.108 - - [05/Feb/2021:05:04:37 +0100] "GET /?XDEBUG_SESSION_START=phpstorm HTTP/1.1" 200 26489 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36" 45.155.205.108 - - [05/Feb/2021:05:04:38 +0100] "GET /wp-content/plugins/wp-file-manager/readme.txt HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36" 45.155.205.108 - - [05/Feb/2021:05:04:38 +0100] "GET /_ignition/execute-solution HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36" 45.155.205.108 - - [05/Feb/2021:05:04:39 +0100] "POST /Autodiscover/Autodiscover.xml HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36" 35.243.252.220 - - [05/Feb/2021:05:06:46 +0100] "GET /robots.txt HTTP/1.0" 200 388 "-" "ZoominfoBot (zoominfobot at zoominfo dot com)" 35.243.252.220 - - [05/Feb/2021:05:06:46 +0100] "GET / HTTP/1.0" 200 26539 "-" "ZoominfoBot (zoominfobot at zoominfo dot com)" 104.168.215.28 - - [05/Feb/2021:05:17:33 +0100] "GET /.env HTTP/1.1" 404 493 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.129 Safari/537.36" 104.168.215.28 - - [05/Feb/2021:05:17:33 +0100] "POST / HTTP/1.1" 200 26638 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.129 Safari/537.36" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:05:21:16 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:05:27:10 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:05:27:13 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:05:28:31 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:05:30:21 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:05:30:25 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:05:31:21 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 92.118.161.1 - - [05/Feb/2021:06:09:43 +0100] "GET / HTTP/1.1" 200 101131 "-" "NetSystemsResearch studies the availability of various services across the internet. Our website is netsystemsresearch.com" 185.224.129.247 - - [05/Feb/2021:06:47:14 +0100] "GET /config/getuser?index=0 HTTP/1.1" 404 456 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0" 23.94.32.243 - - [05/Feb/2021:06:47:57 +0100] "GET / HTTP/1.0" 200 26573 "-" "Mozilla/5.0 (Windows; U; Windows NT 6.0 (x86_64); de-DE) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/4.0.202.2 Safari/532.0" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:07:01:47 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:07:11:57 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 91.121.147.218 - - [05/Feb/2021:07:35:14 +0100] "GET /robots.txt HTTP/1.0" 200 388 "-" "Googlebot/Nutch-1.7" 91.121.147.218 - - [05/Feb/2021:07:35:14 +0100] "GET / HTTP/1.0" 200 26479 "-" "Googlebot/Nutch-1.7" 91.121.147.218 - - [05/Feb/2021:07:36:35 +0100] "GET /robots.txt HTTP/1.0" 200 388 "-" "Googlebot/Nutch-1.7" 91.121.147.218 - - [05/Feb/2021:07:36:35 +0100] "GET /wordpress/ HTTP/1.0" 404 457 "-" "Googlebot/Nutch-1.7" 2.57.122.97 - - [05/Feb/2021:07:46:17 +0100] "GET / HTTP/1.1" 200 26253 "-" "Mozilla/5.0 zgrab/0.x" 54.36.148.74 - - [05/Feb/2021:08:12:42 +0100] "GET / HTTP/1.1" 200 26322 "-" "Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" 61.219.11.153 - - [05/Feb/2021:08:50:37 +0100] "-" 408 0 "-" "-" 206.41.187.118 - - [05/Feb/2021:08:52:19 +0100] "GET / HTTP/1.0" 200 26580 "-" "Mozilla/5.0 (Windows; U; Windows NT 6.0 (x86_64); de-DE) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/4.0.202.2 Safari/532.0" 59.127.128.57 - - [05/Feb/2021:08:57:14 +0100] "GET / HTTP/1.1" 200 26497 "-" "Mozilla/5.0" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:09:02:08 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 193.118.53.194 - - [05/Feb/2021:09:12:30 +0100] "GET / HTTP/1.1" 200 26377 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36" ::1 - - [05/Feb/2021:09:31:32 +0100] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.38 (Debian) OpenSSL/1.1.1d (internal dummy connection)" ::1 - - [05/Feb/2021:09:31:33 +0100] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.38 (Debian) OpenSSL/1.1.1d (internal dummy connection)" 180.149.125.168 - - [05/Feb/2021:09:49:30 +0100] "GET /c/ HTTP/1.1" 404 437 "-" "Mozilla/5.0 (Windows NT 5.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:10:01:57 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 103.224.185.104 - - [05/Feb/2021:10:10:24 +0100] "GET / HTTP/1.1" 200 101323 "-" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36" 172.105.89.161 - - [05/Feb/2021:10:11:14 +0100] "GET /0bef HTTP/1.0" 404 457 "-" "-" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:10:11:54 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:10:12:11 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 139.162.119.197 - - [05/Feb/2021:10:12:45 +0100] "GET / HTTP/1.1" 200 101151 "-" "HTTP Banner Detection (https://security.ipip.net)" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:10:16:26 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:10:16:34 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:10:21:56 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 64.202.189.187 - - [05/Feb/2021:10:37:24 +0100] "GET /wp-login.php HTTP/1.1" 404 453 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:62.0) Gecko/20100101 Firefox/62.0" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:10:51:27 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 106.13.148.11 - - [05/Feb/2021:10:56:20 +0100] "GET /TP/public/index.php HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows; U; Windows NT 6.0;en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6)" 106.13.148.11 - - [05/Feb/2021:10:56:20 +0100] "GET /TP/index.php HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows; U; Windows NT 6.0;en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6)" 106.13.148.11 - - [05/Feb/2021:10:56:21 +0100] "GET /thinkphp/html/public/index.php HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows; U; Windows NT 6.0;en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6)" 106.13.148.11 - - [05/Feb/2021:10:56:22 +0100] "GET /html/public/index.php HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows; U; Windows NT 6.0;en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6)" 106.13.148.11 - - [05/Feb/2021:10:56:22 +0100] "GET /public/index.php HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows; U; Windows NT 6.0;en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6)" 106.13.148.11 - - [05/Feb/2021:10:56:23 +0100] "GET /TP/html/public/index.php HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows; U; Windows NT 6.0;en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6)" 106.13.148.11 - - [05/Feb/2021:10:56:23 +0100] "GET /elrekt.php HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows; U; Windows NT 6.0;en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6)" 106.13.148.11 - - [05/Feb/2021:10:56:25 +0100] "GET /index.php HTTP/1.1" 200 26375 "-" "Mozilla/5.0 (Windows; U; Windows NT 6.0;en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6)" 106.13.148.11 - - [05/Feb/2021:10:56:26 +0100] "GET / HTTP/1.1" 200 26391 "-" "Mozilla/5.0 (Windows; U; Windows NT 6.0;en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6)" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:11:02:27 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 146.196.63.105 - - [05/Feb/2021:11:08:42 +0100] "GET / HTTP/1.1" 200 101303 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:11:12:28 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 185.250.240.175 - - [05/Feb/2021:11:13:35 +0100] "GET / HTTP/1.1" 200 100832 "-" "-" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:11:22:26 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 120.52.152.3 - - [05/Feb/2021:11:23:57 +0100] "GET / HTTP/1.0" 200 100749 "-" "-" 120.52.152.3 - - [05/Feb/2021:11:24:29 +0100] "GET / HTTP/1.1" 200 102235 "-" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36" 120.52.152.3 - - [05/Feb/2021:11:24:34 +0100] "GET /favicon.ico HTTP/1.1" 404 456 "-" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:11:32:19 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:11:40:01 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:12:02:25 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:12:11:05 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" 2001:41d0:1:dfb7::1 - - [05/Feb/2021:12:13:17 +0100] "POST /piwik/ HTTP/1.1" 503 360 "-" "WP-Piwik" ```

Nextcloud log (data/nextcloud.log)

Nextcloud log ``` {"reqId":"JDLGxMZs8pn6P8Zaggtt","level":1,"time":"2021-02-05T11:11:13+00:00","remoteAddr":"90.103.73.213","user":"--","app":"no app in context","method":"GET","url":"/csrftoken","message":{"Exception":"Symfony\\Component\\Routing\\Exception\\RouteNotFoundException","Message":"Unable to generate a URL for the named route \"photos.page.index\" as such route does not exist.","Code":0,"Trace":[{"file":"/home/web/public/cloud/lib/private/Route/Router.php","line":372,"function":"generate","class":"Symfony\\Component\\Routing\\Generator\\UrlGenerator","type":"->","args":["photos.page.index",[],1]},{"file":"/home/web/public/cloud/lib/private/URLGenerator.php","line":83,"function":"generate","class":"OC\\Route\\Router","type":"->","args":["photos.page.index",[]]},{"file":"/home/web/public/cloud/lib/private/NavigationManager.php","line":282,"function":"linkToRoute","class":"OC\\URLGenerator","type":"->","args":["photos.page.index"]},{"file":"/home/web/public/cloud/lib/private/NavigationManager.php","line":108,"function":"init","class":"OC\\NavigationManager","type":"->","args":[]},{"file":"/home/web/public/cloud/apps/theming/lib/ThemingDefaults.php","line":183,"function":"getAll","class":"OC\\NavigationManager","type":"->","args":["guest"]},{"file":"/home/web/public/cloud/lib/public/Defaults.php","line":160,"function":"getShortFooter","class":"OCA\\Theming\\ThemingDefaults","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/Template/JSConfigHelper.php","line":291,"function":"getShortFooter","class":"OCP\\Defaults","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/TemplateLayout.php","line":210,"function":"getConfig","class":"OC\\Template\\JSConfigHelper","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/legacy/OC_Template.php","line":183,"function":"__construct","class":"OC\\TemplateLayout","type":"->","args":["guest",""]},{"file":"/home/web/public/cloud/lib/private/Template/Base.php","line":132,"function":"fetchPage","class":"OC_Template","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/base.php","line":303,"function":"printPage","class":"OC\\Template\\Base","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/base.php","line":956,"function":"checkMaintenanceMode","class":"OC","type":"::","args":[]},{"file":"/home/web/public/cloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/home/web/public/cloud/3rdparty/symfony/routing/Generator/UrlGenerator.php","Line":143,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0","version":"19.0.8.1"} {"reqId":"JDLGxMZs8pn6P8Zaggtt","level":1,"time":"2021-02-05T11:11:13+00:00","remoteAddr":"90.103.73.213","user":"--","app":"no app in context","method":"GET","url":"/csrftoken","message":{"Exception":"Symfony\\Component\\Routing\\Exception\\RouteNotFoundException","Message":"Unable to generate a URL for the named route \"tasks.page.index\" as such route does not exist.","Code":0,"Trace":[{"file":"/home/web/public/cloud/lib/private/Route/Router.php","line":372,"function":"generate","class":"Symfony\\Component\\Routing\\Generator\\UrlGenerator","type":"->","args":["tasks.page.index",[],1]},{"file":"/home/web/public/cloud/lib/private/URLGenerator.php","line":83,"function":"generate","class":"OC\\Route\\Router","type":"->","args":["tasks.page.index",[]]},{"file":"/home/web/public/cloud/lib/private/NavigationManager.php","line":282,"function":"linkToRoute","class":"OC\\URLGenerator","type":"->","args":["tasks.page.index"]},{"file":"/home/web/public/cloud/lib/private/NavigationManager.php","line":108,"function":"init","class":"OC\\NavigationManager","type":"->","args":[]},{"file":"/home/web/public/cloud/apps/theming/lib/ThemingDefaults.php","line":183,"function":"getAll","class":"OC\\NavigationManager","type":"->","args":["guest"]},{"file":"/home/web/public/cloud/lib/public/Defaults.php","line":160,"function":"getShortFooter","class":"OCA\\Theming\\ThemingDefaults","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/Template/JSConfigHelper.php","line":291,"function":"getShortFooter","class":"OCP\\Defaults","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/TemplateLayout.php","line":210,"function":"getConfig","class":"OC\\Template\\JSConfigHelper","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/legacy/OC_Template.php","line":183,"function":"__construct","class":"OC\\TemplateLayout","type":"->","args":["guest",""]},{"file":"/home/web/public/cloud/lib/private/Template/Base.php","line":132,"function":"fetchPage","class":"OC_Template","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/base.php","line":303,"function":"printPage","class":"OC\\Template\\Base","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/base.php","line":956,"function":"checkMaintenanceMode","class":"OC","type":"::","args":[]},{"file":"/home/web/public/cloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/home/web/public/cloud/3rdparty/symfony/routing/Generator/UrlGenerator.php","Line":143,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0","version":"19.0.8.1"} {"reqId":"VXcyOB9ALrkOeEZHQMM5","level":1,"time":"2021-02-05T11:13:17+00:00","remoteAddr":"139.162.116.133","user":"--","app":"core","method":"GET","url":"/","message":"Trusted domain error. \"139.162.116.133\" tried to access using \"91.121.158.183\" as host.","userAgent":"HTTP Banner Detection (https://security.ipip.net)","version":"19.0.8.1"} {"reqId":"VXcyOB9ALrkOeEZHQMM5","level":1,"time":"2021-02-05T11:13:17+00:00","remoteAddr":"139.162.116.133","user":"--","app":"no app in context","method":"GET","url":"/","message":{"Exception":"Symfony\\Component\\Routing\\Exception\\RouteNotFoundException","Message":"Unable to generate a URL for the named route \"ocs.files.DirectEditing.info\" as such route does not exist.","Code":0,"Trace":[{"file":"/home/web/public/cloud/lib/private/Route/Router.php","line":372,"function":"generate","class":"Symfony\\Component\\Routing\\Generator\\UrlGenerator","type":"->","args":["ocs.files.DirectEditing.info",[],1]},{"file":"/home/web/public/cloud/lib/private/URLGenerator.php","line":99,"function":"generate","class":"OC\\Route\\Router","type":"->","args":["ocs.files.DirectEditing.info",[],false]},{"file":"/home/web/public/cloud/apps/files/lib/Capabilities.php","line":72,"function":"linkToOCSRouteAbsolute","class":"OC\\URLGenerator","type":"->","args":["files.DirectEditing.info"]},{"file":"/home/web/public/cloud/lib/private/CapabilitiesManager.php","line":72,"function":"getCapabilities","class":"OCA\\Files\\Capabilities","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/Template/JSConfigHelper.php","line":181,"function":"getCapabilities","class":"OC\\CapabilitiesManager","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/TemplateLayout.php","line":210,"function":"getConfig","class":"OC\\Template\\JSConfigHelper","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/legacy/OC_Template.php","line":183,"function":"__construct","class":"OC\\TemplateLayout","type":"->","args":["guest","core"]},{"file":"/home/web/public/cloud/lib/private/Template/Base.php","line":132,"function":"fetchPage","class":"OC_Template","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/base.php","line":793,"function":"printPage","class":"OC\\Template\\Base","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/base.php","line":1091,"function":"init","class":"OC","type":"::","args":[]},{"file":"/home/web/public/cloud/index.php","line":35,"args":["/home/web/public/cloud/lib/base.php"],"function":"require_once"}],"File":"/home/web/public/cloud/3rdparty/symfony/routing/Generator/UrlGenerator.php","Line":143,"CustomMessage":"--"},"userAgent":"HTTP Banner Detection (https://security.ipip.net)","version":"19.0.8.1"} {"reqId":"VXcyOB9ALrkOeEZHQMM5","level":1,"time":"2021-02-05T11:13:17+00:00","remoteAddr":"139.162.116.133","user":"--","app":"no app in context","method":"GET","url":"/","message":{"Exception":"Symfony\\Component\\Routing\\Exception\\RouteNotFoundException","Message":"Unable to generate a URL for the named route \"cloud_federation_api.RequestHandler.addShare\" as such route does not exist.","Code":0,"Trace":[{"file":"/home/web/public/cloud/lib/private/Route/Router.php","line":372,"function":"generate","class":"Symfony\\Component\\Routing\\Generator\\UrlGenerator","type":"->","args":["cloud_federation_api.RequestHandler.addShare",[],1]},{"file":"/home/web/public/cloud/lib/private/URLGenerator.php","line":83,"function":"generate","class":"OC\\Route\\Router","type":"->","args":["cloud_federation_api.RequestHandler.addShare",[]]},{"file":"/home/web/public/cloud/lib/private/URLGenerator.php","line":95,"function":"linkToRoute","class":"OC\\URLGenerator","type":"->","args":["cloud_federation_api.requesthandlercontroller.addShare",[]]},{"file":"/home/web/public/cloud/apps/cloud_federation_api/lib/Capabilities.php","line":45,"function":"linkToRouteAbsolute","class":"OC\\URLGenerator","type":"->","args":["cloud_federation_api.requesthandlercontroller.addShare"]},{"file":"/home/web/public/cloud/lib/private/CapabilitiesManager.php","line":72,"function":"getCapabilities","class":"OCA\\CloudFederationAPI\\Capabilities","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/Template/JSConfigHelper.php","line":181,"function":"getCapabilities","class":"OC\\CapabilitiesManager","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/TemplateLayout.php","line":210,"function":"getConfig","class":"OC\\Template\\JSConfigHelper","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/legacy/OC_Template.php","line":183,"function":"__construct","class":"OC\\TemplateLayout","type":"->","args":["guest","core"]},{"file":"/home/web/public/cloud/lib/private/Template/Base.php","line":132,"function":"fetchPage","class":"OC_Template","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/base.php","line":793,"function":"printPage","class":"OC\\Template\\Base","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/base.php","line":1091,"function":"init","class":"OC","type":"::","args":[]},{"file":"/home/web/public/cloud/index.php","line":35,"args":["/home/web/public/cloud/lib/base.php"],"function":"require_once"}],"File":"/home/web/public/cloud/3rdparty/symfony/routing/Generator/UrlGenerator.php","Line":143,"CustomMessage":"--"},"userAgent":"HTTP Banner Detection (https://security.ipip.net)","version":"19.0.8.1"} {"reqId":"VXcyOB9ALrkOeEZHQMM5","level":1,"time":"2021-02-05T11:13:17+00:00","remoteAddr":"139.162.116.133","user":"--","app":"no app in context","method":"GET","url":"/","message":{"Exception":"Symfony\\Component\\Routing\\Exception\\RouteNotFoundException","Message":"Unable to generate a URL for the named route \"ocs.password_policy.API.generate\" as such route does not exist.","Code":0,"Trace":[{"file":"/home/web/public/cloud/lib/private/Route/Router.php","line":372,"function":"generate","class":"Symfony\\Component\\Routing\\Generator\\UrlGenerator","type":"->","args":["ocs.password_policy.API.generate",[],1]},{"file":"/home/web/public/cloud/lib/private/URLGenerator.php","line":99,"function":"generate","class":"OC\\Route\\Router","type":"->","args":["ocs.password_policy.API.generate",[],false]},{"file":"/home/web/public/cloud/apps/password_policy/lib/Capabilities.php","line":57,"function":"linkToOCSRouteAbsolute","class":"OC\\URLGenerator","type":"->","args":["password_policy.API.generate"]},{"file":"/home/web/public/cloud/lib/private/CapabilitiesManager.php","line":72,"function":"getCapabilities","class":"OCA\\Password_Policy\\Capabilities","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/Template/JSConfigHelper.php","line":181,"function":"getCapabilities","class":"OC\\CapabilitiesManager","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/TemplateLayout.php","line":210,"function":"getConfig","class":"OC\\Template\\JSConfigHelper","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/legacy/OC_Template.php","line":183,"function":"__construct","class":"OC\\TemplateLayout","type":"->","args":["guest","core"]},{"file":"/home/web/public/cloud/lib/private/Template/Base.php","line":132,"function":"fetchPage","class":"OC_Template","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/base.php","line":793,"function":"printPage","class":"OC\\Template\\Base","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/base.php","line":1091,"function":"init","class":"OC","type":"::","args":[]},{"file":"/home/web/public/cloud/index.php","line":35,"args":["/home/web/public/cloud/lib/base.php"],"function":"require_once"}],"File":"/home/web/public/cloud/3rdparty/symfony/routing/Generator/UrlGenerator.php","Line":143,"CustomMessage":"--"},"userAgent":"HTTP Banner Detection (https://security.ipip.net)","version":"19.0.8.1"} {"reqId":"VXcyOB9ALrkOeEZHQMM5","level":1,"time":"2021-02-05T11:13:17+00:00","remoteAddr":"139.162.116.133","user":"--","app":"no app in context","method":"GET","url":"/","message":{"Exception":"Symfony\\Component\\Routing\\Exception\\RouteNotFoundException","Message":"Unable to generate a URL for the named route \"ocs.password_policy.API.validate\" as such route does not exist.","Code":0,"Trace":[{"file":"/home/web/public/cloud/lib/private/Route/Router.php","line":372,"function":"generate","class":"Symfony\\Component\\Routing\\Generator\\UrlGenerator","type":"->","args":["ocs.password_policy.API.validate",[],1]},{"file":"/home/web/public/cloud/lib/private/URLGenerator.php","line":99,"function":"generate","class":"OC\\Route\\Router","type":"->","args":["ocs.password_policy.API.validate",[],false]},{"file":"/home/web/public/cloud/apps/password_policy/lib/Capabilities.php","line":58,"function":"linkToOCSRouteAbsolute","class":"OC\\URLGenerator","type":"->","args":["password_policy.API.validate"]},{"file":"/home/web/public/cloud/lib/private/CapabilitiesManager.php","line":72,"function":"getCapabilities","class":"OCA\\Password_Policy\\Capabilities","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/Template/JSConfigHelper.php","line":181,"function":"getCapabilities","class":"OC\\CapabilitiesManager","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/TemplateLayout.php","line":210,"function":"getConfig","class":"OC\\Template\\JSConfigHelper","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/private/legacy/OC_Template.php","line":183,"function":"__construct","class":"OC\\TemplateLayout","type":"->","args":["guest","core"]},{"file":"/home/web/public/cloud/lib/private/Template/Base.php","line":132,"function":"fetchPage","class":"OC_Template","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/base.php","line":793,"function":"printPage","class":"OC\\Template\\Base","type":"->","args":[]},{"file":"/home/web/public/cloud/lib/base.php","line":1091,"function":"init","class":"OC","type":"::","args":[]},{"file":"/home/web/public/cloud/index.php","line":35,"args":["/home/web/public/cloud/lib/base.php"],"function":"require_once"}],"File":"/home/web/public/cloud/3rdparty/symfony/routing/Generator/UrlGenerator.php","Line":143,"CustomMessage":"--"},"userAgent":"HTTP Banner Detection (https://security.ipip.net)","version":"19.0.8.1"} ```

Browser log

Browser log ``` Insert your browser log here, this could for example include: a) The javascript console log b) The network log c) ... ```
kesselb commented 3 years ago

Thank you for taking the time to report a problem :+1:

As this seems to be a setup issue I would like to ask you to raise your question at https://help.nextcloud.com

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

Is the response of your sql server. Make sure the sql server has enough resources.