Int. Server Error 500 // Maridb waiting for purge?

NC: 18.0.4 running on Ubuntu 16.04 LTS; Apache 2.4.?; PHP 7.2;

Suddenly, I noticed that my mobile clients (Iphone picture upload) was giving me internal server errors. While checking the admin panel I saw the following error messages:

*** Your web server is not yet properly set up to allow file synchronization, because the WebDAV interface seems to be broken.**
*** Error occurred while checking server setup**
*** Error occurred while checking server setup**
*** Error occurred while checking server setup**

  • Your web server is not properly set up to resolve “/.well-known/caldav”. Further information can be found in the documentation.
  • Your web server is not properly set up to resolve “/.well-known/carddav”. Further information can be found in the documentation.
    Is this the first time you’ve seen this error? (Y/N):

The bottom two are pending since quite a while. I have this NC installation since quite a while and have done multiple updates without any issues. But these errors came out of nowhere and I dont even know where to start :frowning:

The intersting part is that the sync to desktop clients seems to work although it shows some errors for few files (500 Internal Server Error, 2006MySQL server has goen away).

After going over a ton of stuff and practically reinstalling apache I got to the point that I believe it is related to the DB.

Appache error log

[Sun Nov 15 07:35:02.427058 2020] [ssl:warn] [pid 1101] AH01909: cloud.piphardy.com/nextcloud:443:0 server certificate does NOT include an ID which matches the server name
[Sun Nov 15 07:35:02.427964 2020] [mpm_prefork:notice] [pid 1101] AH00163: Apache/2.4.46 (Ubuntu) OpenSSL/1.1.1g configured -- resuming normal operations
[Sun Nov 15 07:35:02.427976 2020] [core:notice] [pid 1101] AH00094: Command line: '/usr/sbin/apache2'

MariaDB status:

Nov 15 16:27:33 mimir mysqld[14717]: 201115 16:27:33 [Note] InnoDB: Highest supported file format is Barracuda.
Nov 15 16:27:33 mimir mysqld[14717]: 201115 16:27:33 [Note] InnoDB: The log sequence numbers 9943433748 and 9943433748 in ibdata files do not match the log sequ
Nov 15 16:27:33 mimir mysqld[14717]: 201115 16:27:33 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
Nov 15 16:27:34 mimir mysqld[14717]: 201115 16:27:34 [Note] InnoDB: 128 rollback segment(s) are active.
Nov 15 16:27:34 mimir mysqld[14717]: 201115 16:27:34 [Note] InnoDB: Waiting for purge to start
Nov 15 16:27:34 mimir mysqld[14717]: 201115 16:27:34 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 9952426550
Nov 15 16:27:34 mimir mysqld[14717]: 201115 16:27:34 [Note] Plugin 'FEEDBACK' is disabled.
Nov 15 16:27:34 mimir mysqld[14717]: 201115 16:27:34 [Note] Server socket created on IP: '127.0.0.1'.
Nov 15 16:27:34 mimir mysqld[14717]: 201115 16:27:34 [Note] /usr/sbin/mysqld: ready for connections.
Nov 15 16:27:34 mimir mysqld[14717]: Version: '10.0.38-MariaDB-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Ubuntu 16.04

Any idea where to start? Really frustrating when out of a sudden a super stable NC install goes to shit :disappointed_relieved:

Do you have any admin tool for you db? phpmyadmin maybe?

Pleae check your db and db server.

Im a bit of a Linux starter so I didnt use an admin tool so far.

Isnt there anything I can do with system tools / logs to narrow down the problem?