Good evening,
We have moved to a new server and are running the latest available Nextcloud version and PHP 8.3 again.
We exported the database using the export option and then imported it again on a new server using PHPmyAdmin. That all worked. The databases also often work smoothly. We have also transferred the users of the respective databases via the export/import function.
However, the MySQL service sometimes “hangs” and cannot be started via
sudo service mysql restart
restarting (start / stop) does not work either.
If you shut down the complete system running on a virtual machine on TrueNas, MySQL does not stop either. The virtual machine must then be switched off differently.
The error occurs irregularly and has no particular connection.
If I use the code
sudo service mysql status
I always get a different error message:
Thread 6316 (user : 'nextclouduser") did not exit
The funny thing is that we haven’t actively changed anything about this “person” - after a restart, everything is gone again.
But sometimes there are also completely different errors that have nothing to do with the Nextcloud, but still destroy MySQL:
mariadb: Table 'x' is marked as crashed and should be repaired
Many thanks for your answers in advance,
schBenedikt