search

nextcloud / calendar

📆 Calendar app for Nextcloud
https://apps.nextcloud.com/apps/calendar
GNU Affero General Public License v3.0
989 stars 240 forks source link

Database error when running migration latest for app calendar #4022

Closed zagub59 closed 2 years ago

zagub59 commented 2 years ago

Steps to reproduce

  1. Update Nextcloud from 23.0.0 to 23.0.2 with occ upgrade
  2. App:calendar disable to restore access to Nextcloud

Expected behavior

Calendar app updates successfully

Actual behaviour

Database error when running migration latest for app calendar thrown when trying to update. Forced to disable app to restore access to Nextcloud. Same issue when deleting the app and trying to enable it again.

Calendar app version

3.1.0

CalDAV-clients used

DAVx5

Browser

Firefox 97.0.1

Client operating system

Debian

Server operating system

Debian 9.13

Web server

Apache

Database engine version

MariaDB

PHP engine version

PHP 8.0

Nextcloud version

23.0.2

Updated from an older installed version or fresh install

Updated from an older version

List of activated apps

Enabled:
  - activity: 2.15.0
  - admin_audit: 1.13.0
  - bookmarks: 10.1.0
  - bruteforcesettings: 2.3.0
  - circles: 23.0.1
  - cloud_federation_api: 1.6.0
  - collectives: 0.22.22
  - comments: 1.13.0
  - contacts: 4.0.8
  - cookbook: 0.9.10
  - cospend: 1.4.4
  - dashboard: 7.3.0
  - dav: 1.21.0
  - deck: 1.6.0
  - federatedfilesharing: 1.13.0
  - files: 1.18.0
  - files_downloadactivity: 1.12.0
  - files_external: 1.15.0
  - files_sharing: 1.15.0
  - files_versions: 1.16.0
  - logreader: 2.8.0
  - lookup_server_connector: 1.11.0
  - mail: 1.11.7
  - maps: 0.1.10
  - news: 18.0.0
  - notes: 4.3.1
  - notifications: 2.11.1
  - oauth2: 1.11.0
  - password_policy: 1.13.0
  - photos: 1.5.0
  - polls: 3.5.4
  - previewgenerator: 4.0.0
  - provisioning_api: 1.13.0
  - qownnotesapi: 21.12.0
  - ransomware_protection: 1.12.0
  - richdocuments: 5.0.3
  - richdocumentscode: 21.11.204
  - serverinfo: 1.13.0
  - settings: 1.5.0
  - spreed: 13.0.3
  - talk_matterbridge: 1.23.2
  - tasks: 0.14.2
  - text: 3.4.0
  - theming: 1.14.0
  - twofactor_backupcodes: 1.12.0
  - twofactor_totp: 6.2.0
  - updatenotification: 1.13.0
  - user_status: 1.3.1
  - viewer: 1.7.0
  - weather_status: 1.3.0
  - workflowengine: 2.5.0
Disabled:
  - accessibility: 1.7.0
  - calendar: 3.0.5
  - contactsinteraction: 1.4.0
  - encryption
  - federation: 1.13.0
  - files_pdfviewer: 2.4.0
  - files_rightclick: 1.2.0
  - files_trashbin: 1.13.0
  - files_videoplayer: 1.10.0
  - firstrunwizard: 2.12.0
  - gestion: 1.2.12
  - libresign
  - nextcloud_announcements: 1.10.0
  - privacy: 1.7.0
  - recommendations: 1.2.0
  - sharebymail: 1.13.0
  - support: 1.4.0
  - survey_client: 1.11.0
  - systemtags: 1.13.0
  - user_ldap: 1.13.0

Nextcloud configuration

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "192.168.50.14",
            "collab.gb-consulting.fr"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "23.0.2.1",
        "overwrite.cli.url": "http:\/\/192.168.50.14",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "log_type": "file",
        "logfile": "\/var\/log\/nextcloud.log",
        "logfilemode": 416,
        "loglevel": 0,
        "logdateformat": "F d, Y H:i:s",
        "default_phone_region": "FR",
        "default_language": "fr",
        "htaccess.RewriteBase": "\/",
        "trashbin_retention_obligation": "auto, 15",
        "filelocking.enabled": "true",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": "0",
            "timeout": "0.0"
        },
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "maintenance": false,
        "mysql.utf8mb4": true,
        "mail_smtpmode": "smtp",
        "mail_smtpsecure": "tls",
        "mail_sendmailmode": "smtp",
        "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***",
        "app_install_overwrite": [
            "whiteboard",
            "bruteforcesettings",
            "spreedme"
        ],
        "has_rebuilt_cache": true,
        "theme": "",
        "preview_max_x": "2048",
        "preview_max_y": "2048",
        "jpeg_quality": "60",
        "allow_local_remote_servers": true,
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    }
}

Web server error log

No response

Log file

Erreur  settings    Exception: Database error when running migration latest for app calendar

    /var/www/nextcloud/lib/private/Installer.php - line 154:

    OC\DB\MigrationService->migrate()

    /var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php - line 452:

    OC\Installer->installApp()

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Settings\Controller\AppSettingsController->enableApps()

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController()

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 157:

    OC\AppFramework\Http\Dispatcher->dispatch()

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main()

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match()

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Causé par Doctrine\DBAL\Exception\ConnectionLost: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1780:

    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1719:

    Doctrine\DBAL\Connection->handleDriverException()

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1067:

    Doctrine\DBAL\Connection->convertExceptionDuringQuery()

    /var/www/nextcloud/lib/private/DB/Connection.php - line 237:

    Doctrine\DBAL\Connection->executeQuery()

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1809:

    OC\DB\Connection->executeQuery()

    /var/www/nextcloud/lib/private/DB/Migrator.php - line 175:

    Doctrine\DBAL\Connection->query()

    /var/www/nextcloud/lib/private/DB/Migrator.php - line 76:

    OC\DB\Migrator->applySchema()

    /var/www/nextcloud/lib/private/DB/Connection.php - line 546:

    OC\DB\Migrator->migrate()

    /var/www/nextcloud/lib/private/DB/MigrationService.php - line 540:

    OC\DB\Connection->migrateToSchema()

    /var/www/nextcloud/lib/private/DB/MigrationService.php - line 425:

    OC\DB\MigrationService->executeStep()

    /var/www/nextcloud/lib/private/Installer.php - line 154:

    OC\DB\MigrationService->migrate()

    /var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php - line 452:

    OC\Installer->installApp()

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Settings\Controller\AppSettingsController->enableApps()

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController()

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 157:

    OC\AppFramework\Http\Dispatcher->dispatch()

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main()

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match()

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Causé par Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php - line 87:

    Doctrine\DBAL\Driver\PDO\Exception::new()

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1062:

    Doctrine\DBAL\Driver\PDO\Connection->query()

    /var/www/nextcloud/lib/private/DB/Connection.php - line 237:

    Doctrine\DBAL\Connection->executeQuery()

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1809:

    OC\DB\Connection->executeQuery()

    /var/www/nextcloud/lib/private/DB/Migrator.php - line 175:

    Doctrine\DBAL\Connection->query()

    /var/www/nextcloud/lib/private/DB/Migrator.php - line 76:

    OC\DB\Migrator->applySchema()

    /var/www/nextcloud/lib/private/DB/Connection.php - line 546:

    OC\DB\Migrator->migrate()

    /var/www/nextcloud/lib/private/DB/MigrationService.php - line 540:

    OC\DB\Connection->migrateToSchema()

    /var/www/nextcloud/lib/private/DB/MigrationService.php - line 425:

    OC\DB\MigrationService->executeStep()

    /var/www/nextcloud/lib/private/Installer.php - line 154:

    OC\DB\MigrationService->migrate()

    /var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php - line 452:

    OC\Installer->installApp()

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Settings\Controller\AppSettingsController->enableApps()

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController()

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 157:

    OC\AppFramework\Http\Dispatcher->dispatch()

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main()

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match()

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Causé par PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php - line 82:

    PDO->query()

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1062:

    Doctrine\DBAL\Driver\PDO\Connection->query()

    /var/www/nextcloud/lib/private/DB/Connection.php - line 237:

    Doctrine\DBAL\Connection->executeQuery()

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1809:

    OC\DB\Connection->executeQuery()

    /var/www/nextcloud/lib/private/DB/Migrator.php - line 175:

    Doctrine\DBAL\Connection->query()

    /var/www/nextcloud/lib/private/DB/Migrator.php - line 76:

    OC\DB\Migrator->applySchema()

    /var/www/nextcloud/lib/private/DB/Connection.php - line 546:

    OC\DB\Migrator->migrate()

    /var/www/nextcloud/lib/private/DB/MigrationService.php - line 540:

    OC\DB\Connection->migrateToSchema()

    /var/www/nextcloud/lib/private/DB/MigrationService.php - line 425:

    OC\DB\MigrationService->executeStep()

    /var/www/nextcloud/lib/private/Installer.php - line 154:

    OC\DB\MigrationService->migrate()

    /var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php - line 452:

    OC\Installer->installApp()

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Settings\Controller\AppSettingsController->enableApps()

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController()

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 157:

    OC\AppFramework\Http\Dispatcher->dispatch()

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main()

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match()

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Browser log

No response

Additional info

No response

ChristophWurst commented 2 years ago

General error: 2006 MySQL server has gone away

Your server crashed.

zagub59 commented 2 years ago

Hi @ChristophWurst, Thanks for your fast answer.

Yes, Mariadb indeed crashes when I attempt to update : Mar 7 13:49:31 Nextcloud mariadbd[1577]: 2022-03-07 13:49:31 0x7f1548e60700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/mariadb-10.5.15/storage/i$ Mar 7 13:49:31 Nextcloud mariadbd[1577]: InnoDB: Failing assertion: dict_tf2_is_valid(flags, flags2) Mar 7 13:49:31 Nextcloud mariadbd[1577]: InnoDB: We intentionally generate a memory trap. Mar 7 13:49:31 Nextcloud mariadbd[1577]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Mar 7 13:49:31 Nextcloud mariadbd[1577]: InnoDB: If you get repeated assertion failures or crashes, even Mar 7 13:49:31 Nextcloud mariadbd[1577]: InnoDB: immediately after the mysqld startup, there may be Mar 7 13:49:31 Nextcloud mariadbd[1577]: InnoDB: corruption in the InnoDB tablespace. Please refer to Mar 7 13:49:31 Nextcloud mariadbd[1577]: InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ Mar 7 13:49:31 Nextcloud mariadbd[1577]: InnoDB: about forcing recovery. Mar 7 13:49:31 Nextcloud mariadbd[1577]: 220307 13:49:31 [ERROR] mysqld got signal 6 ; Mar 7 13:49:31 Nextcloud mariadbd[1577]: This could be because you hit a bug. It is also possible that this binary Mar 7 13:49:31 Nextcloud mariadbd[1577]: or one of the libraries it was linked against is corrupt, improperly built, Mar 7 13:49:31 Nextcloud mariadbd[1577]: or misconfigured. This error can also be caused by malfunctioning hardware. Mar 7 13:49:31 Nextcloud mariadbd[1577]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Mar 7 13:49:31 Nextcloud mariadbd[1577]: We will try our best to scrape up some info that will hopefully help Mar 7 13:49:31 Nextcloud mariadbd[1577]: diagnose the problem, but since we have already crashed, Mar 7 13:49:31 Nextcloud mariadbd[1577]: something is definitely wrong and this may fail. Mar 7 13:49:31 Nextcloud mariadbd[1577]: Server version: 10.5.15-MariaDB-1:10.5.15+maria~stretch-log Mar 7 13:49:31 Nextcloud mariadbd[1577]: key_buffer_size=67108864 Mar 7 13:49:31 Nextcloud mariadbd[1577]: read_buffer_size=131072 Mar 7 13:49:31 Nextcloud mariadbd[1577]: max_used_connections=5 Mar 7 13:49:31 Nextcloud mariadbd[1577]: max_threads=153 Mar 7 13:49:31 Nextcloud mariadbd[1577]: thread_count=5 Mar 7 13:49:31 Nextcloud mariadbd[1577]: It is possible that mysqld could use up to Mar 7 13:49:31 Nextcloud mariadbd[1577]: key_buffer_size + (read_buffer_size + sort_buffer_size)max_threads = 402336 K bytes of memory Mar 7 13:49:31 Nextcloud mariadbd[1577]: Hope that's ok; if not, decrease some variables in the equation. Mar 7 13:49:31 Nextcloud mariadbd[1577]: Thread pointer: 0x7f14b80009b8 Mar 7 13:49:31 Nextcloud mariadbd[1577]: Attempting backtrace. You can use the following information to find out Mar 7 13:49:31 Nextcloud mariadbd[1577]: where mysqld died. If you see no messages after this, something went Mar 7 13:49:31 Nextcloud mariadbd[1577]: terribly wrong... Mar 7 13:49:31 Nextcloud mariadbd[1577]: stack_bottom = 0x7f1548e5fc78 thread_stack 0x49000 Mar 7 13:49:31 Nextcloud mariadbd[1577]: ??:0(my_print_stacktrace)[0x560d710e440e] Mar 7 13:49:31 Nextcloud mariadbd[1577]: ??:0(handle_fatal_signal)[0x560d70af3aff] Mar 7 13:49:31 Nextcloud mariadbd[1577]: ??:0(__restore_rt)[0x7f156620d0e0] Mar 7 13:49:31 Nextcloud mariadbd[1577]: ??:0(gsignal)[0x7f1565605fff] Mar 7 13:49:31 Nextcloud mariadbd[1577]: ??:0(abort)[0x7f156560742a] Mar 7 13:49:32 Nextcloud mariadbd[1577]: /usr/sbin/mariadbd(+0x615c5e)[0x560d707e0c5e] Mar 7 13:49:32 Nextcloud mariadbd[1577]: ??:0(std::_Rb_tree<unsigned int, unsigned int, std::_Identity, std::less, std::allocator<unsigned$ Mar 7 13:49:32 Nextcloud mariadbd[1577]: /usr/sbin/mariadbd(+0x60b785)[0x560d707d6785] Mar 7 13:49:32 Nextcloud mariadbd[1577]: ??:0(wsrep_notify_status(wsrep::server_state::state, wsrep::view const))[0x560d70e0dd08] Mar 7 13:49:32 Nextcloud mariadbd[1577]: ??:0(mysql_alter_table(THD, st_mysql_const_lex_string const, st_mysql_const_lex_string const, HA_CREATE_INFO, TABLE_LIST$ Mar 7 13:49:32 Nextcloud mariadbd[1577]: ??:0(Sql_cmd_alter_table::execute(THD))[0x560d709e81e0] Mar 7 13:49:32 Nextcloud mariadbd[1577]: ??:0(mysql_execute_command(THD))[0x560d708eb6d9] Mar 7 13:49:32 Nextcloud mariadbd[1577]: ??:0(mysql_parse(THD, char, unsigned int, Parser_state, bool, bool))[0x560d708f209c] Mar 7 13:49:32 Nextcloud mariadbd[1577]: ??:0(dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool))[0x560d708e7e39] Mar 7 13:49:32 Nextcloud mariadbd[1577]: ??:0(do_command(THD))[0x560d708e620b] Mar 7 13:49:32 Nextcloud mariadbd[1577]: ??:0(do_handle_one_connection(CONNECT, bool))[0x560d709e33e0] Mar 7 13:49:32 Nextcloud mariadbd[1577]: ??:0(handle_one_connection)[0x560d709e3aa4] Mar 7 13:49:32 Nextcloud mariadbd[1577]: ??:0(MyCTX_nopad::finish(unsigned char, unsigned int))[0x560d70d34deb] Mar 7 13:49:32 Nextcloud mariadbd[1577]: ??:0(start_thread)[0x7f15662034a4] Mar 7 13:49:32 Nextcloud mariadbd[1577]: ??:0(clone)[0x7f15656bbd0f] Mar 7 13:49:32 Nextcloud mariadbd[1577]: Trying to get some variables. Mar 7 13:49:32 Nextcloud mariadbd[1577]: Some pointers may be invalid and cause the dump to abort. Mar 7 13:49:32 Nextcloud mariadbd[1577]: Query (0x7f14b8010490): ALTER TABLE oc_calendar_appt_configs ADD future_limit INT DEFAULT NULL Mar 7 13:49:32 Nextcloud mariadbd[1577]: Connection ID (thread ID): 85 Mar 7 13:49:32 Nextcloud mariadbd[1577]: Status: NOT_KILLED Mar 7 13:49:32 Nextcloud mariadbd[1577]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_mergesort$ Mar 7 13:49:32 Nextcloud mariadbd[1577]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains Mar 7 13:49:32 Nextcloud mariadbd[1577]: information that should help you find out what is causing the crash. Mar 7 13:49:32 Nextcloud mariadbd[1577]: Writing a core file... Mar 7 13:49:32 Nextcloud mariadbd[1577]: Working directory at /var/lib/mysql Mar 7 13:49:32 Nextcloud mariadbd[1577]: Resource Limits: Mar 7 13:49:32 Nextcloud mariadbd[1577]: Limit Soft Limit Hard Limit Units Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max cpu time unlimited unlimited seconds Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max file size unlimited unlimited bytes Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max data size unlimited unlimited bytes Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max stack size 8388608 unlimited bytes Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max core file size 0 unlimited bytes Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max resident set unlimited unlimited bytes Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max processes 7927 7927 processes Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max open files 32768 32768 files Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max locked memory 65536 65536 bytes Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max address space unlimited unlimited bytes Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max file locks unlimited unlimited locks Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max pending signals 7927 7927 signals Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max msgqueue size 819200 819200 bytes Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max nice priority 0 0 Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max realtime priority 0 0 Mar 7 13:49:32 Nextcloud mariadbd[1577]: Max realtime timeout unlimited unlimited us Mar 7 13:49:32 Nextcloud mariadbd[1577]: Core pattern: core Mar 7 13:49:32 Nextcloud systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT Mar 7 13:49:32 Nextcloud systemd[1]: mariadb.service: Unit entered failed state. Mar 7 13:49:32 Nextcloud systemd[1]: mariadb.service: Failed with result 'signal'. Mar 7 13:49:37 Nextcloud systemd[1]: mariadb.service: Service hold-off time over, scheduling restart. Mar 7 13:49:37 Nextcloud systemd[1]: Stopped MariaDB 10.5.15 database server. Mar 7 13:49:37 Nextcloud systemd[1]: Starting MariaDB 10.5.15 database server...

zagub59 commented 2 years ago

In case it might be useful to some, I fixed the issue by running the following command : mysqlcheck --optimize --all-databases --auto-repair

Have a good day !