Mon serveur YunoHost
Matériel: Vieil ordinateur
Version de YunoHost: 11.2.7
J’ai accès à mon serveur : En SSH | Par la webadmin | En direct avec un clavier/écran |
Êtes-vous dans un contexte particulier ou avez-vous effectué des modifications particulières sur votre instance ? : non
Si votre requête est liée à une application, précisez son nom et sa version: mysql (écritures provenant de NextCloud)
Description du problème
Bonjour à tous,
Mon service mysql ne démarre plus, suite à une manipulation pour tenter de résoudre un hypothétique problème de corruption de BD qui empêche la mise à jour de NextCloud et la synchronisation des reminders.
Extrait des dernières lignes du log NextCloud :
2023-12-05 09:47:08,473: WARNING - 2211 mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `oc_calendar_reminders` at row: 533159
2023-12-05 09:47:08,474: DEBUG - 2212 + ynh_exit_properly
2023-12-05 09:47:08,474: DEBUG - 2212 + local exit_code=3
2023-12-05 09:47:08,474: DEBUG - 2212 + [[ backup =~ ^install$|^upgrade$|^restore$ ]]
2023-12-05 09:47:08,474: DEBUG - 2212 + '[' 3 -eq 0 ']'
2023-12-05 09:47:08,969: DEBUG - 2710 + exit 1
2023-12-05 09:47:09,970: DEBUG - 3712 Échec de l'exécution du script : /var/cache/yunohost/app_tmp_work_dirs/app_lu3l0ptr/scripts/backup
2023-12-05 09:47:09,998: WARNING - 3739 Impossible de sauvegarder nextcloud
2023-12-05 09:47:10,005: DEBUG - 3746 L'opération 'Créer une archive de sauvegarde' a échoué ! Pour obtenir de l'aide, merci de partager le journal de l'opération en utilisant la commande 'yunohost log share 20231205-144706-backup_create'
2023-12-05 09:47:10,012: DEBUG - 3754 action [79274.1] executed in 3.531s
2023-12-05 09:47:10,013: WARNING - 3754 Il n'y a rien à sauvegarder
2023-12-05 09:47:10,062: DEBUG - + ynh_die '--message=Backup failed, the upgrade process was aborted.'
2023-12-05 09:47:10,078: WARNING - Backup failed, the upgrade process was aborted.
2023-12-05 09:47:11,079: ERROR - Impossible de mettre à jour nextcloud : Une erreur s'est produite durant l'exécution du script de mise à niveau de l'application
Log mysql, qui incrimine également la table ‘oc_calendar_reminders’ :
déc 05 10:47:56 mariadbd[83127]: 231205 10:47:56 [ERROR] mysqld got signal 11 ;
déc 05 10:47:56 mariadbd[83127]: This could be because you hit a bug. It is also possible that this binary
déc 05 10:47:56 mariadbd[83127]: or one of the libraries it was linked against is corrupt, improperly built,
déc 05 10:47:56 mariadbd[83127]: or misconfigured. This error can also be caused by malfunctioning hardware.
déc 05 10:47:56 mariadbd[83127]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
déc 05 10:47:56 mariadbd[83127]: We will try our best to scrape up some info that will hopefully help
déc 05 10:47:56 mariadbd[83127]: diagnose the problem, but since we have already crashed,
déc 05 10:47:56 mariadbd[83127]: something is definitely wrong and this may fail.
déc 05 10:47:56 mariadbd[83127]: Server version: 10.5.21-MariaDB-0+deb11u1 source revision: bed70468ea08c2820647f5e3ac006a9ff88144ac
déc 05 10:47:56 mariadbd[83127]: key_buffer_size=134217728
déc 05 10:47:56 mariadbd[83127]: read_buffer_size=131072
déc 05 10:47:56 mariadbd[83127]: max_used_connections=6
déc 05 10:47:56 mariadbd[83127]: max_threads=153
déc 05 10:47:56 mariadbd[83127]: thread_count=6
déc 05 10:47:56 mariadbd[83127]: It is possible that mysqld could use up to
déc 05 10:47:56 mariadbd[83127]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467881 K bytes of memory
déc 05 10:47:56 mariadbd[83127]: Hope that's ok; if not, decrease some variables in the equation.
déc 05 10:47:56 mariadbd[83127]: Thread pointer: 0x7f6638035698
déc 05 10:47:56 mariadbd[83127]: Attempting backtrace. You can use the following information to find out
déc 05 10:47:56 mariadbd[83127]: where mysqld died. If you see no messages after this, something went
déc 05 10:47:56 mariadbd[83127]: terribly wrong...
déc 05 10:47:56 mariadbd[83127]: stack_bottom = 0x7f667497fd78 thread_stack 0x49000
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x55878574fe2e]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(handle_fatal_signal+0x485)[0x5587852480a5]
déc 05 10:47:56 mariadbd[83127]: sigaction.c:0(__restore_rt)[0x7f668cab6140]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(+0xcb463e)[0x55878559363e]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(+0xd6779c)[0x55878564679c]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(+0xce4138)[0x5587855c3138]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(+0xce8364)[0x5587855c7364]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(+0xce9833)[0x5587855c8833]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(+0xce9f5f)[0x5587855c8f5f]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(+0xcf8ac5)[0x5587855d7ac5]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(+0xc541e1)[0x5587855331e1]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(_ZN7handler12ha_write_rowEPKh+0x198)[0x558785255e28]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(_Z12write_recordP3THDP5TABLEP12st_copy_infoP13select_result+0x1dd)[0x55878500f4fd]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesbP13select_result+0x1011)[0x558785017281]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THD+0x172d)[0x558785049e7d]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x20b)[0x55878504d92b]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xdb5)[0x55878504f705]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(_Z10do_commandP3THD+0x120)[0x558785051540]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x2f2)[0x558785145fb2]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(handle_one_connection+0x5d)[0x55878514622d]
déc 05 10:47:56 mariadbd[83127]: /usr/sbin/mariadbd(+0xbaa77b)[0x55878548977b]
déc 05 10:47:56 mariadbd[83127]: nptl/pthread_create.c:478(start_thread)[0x7f668caaaea7]
déc 05 10:47:56 mariadbd[83127]: x86_64/clone.S:97(__GI___clone)[0x7f668c6b1a2f]
déc 05 10:47:56 mariadbd[83127]: Trying to get some variables.
déc 05 10:47:56 mariadbd[83127]: Some pointers may be invalid and cause the dump to abort.
déc 05 10:47:56 mariadbd[83127]: Query (0x7f663803fd30): INSERT INTO `oc_calendar_reminders` (`calendar_id`, `object_id`, `uid`, `is_recurring`, `recurrence_id`, `is_recurrence_exception`, `event_hash`, `alarm_hash`, `type`, `is_relative`, `notification_date`, `is_repeat_based`) VALUES('5', '1978', '6997a6b1-87b4-4d5c-a947-774f5c85065e', '0', '1703876400', '0', '18c9a3a66dc54ca5ff0485293f7a7151', '319d02c087f99b15237e09d46d3b3c43', 'DISPLAY', '1', '1703876400', '0')
déc 05 10:47:56 mariadbd[83127]: Connection ID (thread ID): 282
déc 05 10:47:56 mariadbd[83127]: Status: NOT_KILLED
déc 05 10:47:56 mariadbd[83127]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
déc 05 10:47:56 mariadbd[83127]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
déc 05 10:47:56 mariadbd[83127]: information that should help you find out what is causing the crash.
déc 05 10:47:56 mariadbd[83127]: Writing a core file...
déc 05 10:47:56 mariadbd[83127]: Working directory at /var/lib/mysql
déc 05 10:47:56 mariadbd[83127]: Resource Limits:
déc 05 10:47:56 mariadbd[83127]: Limit Soft Limit Hard Limit Units
déc 05 10:47:56 mariadbd[83127]: Max cpu time unlimited unlimited seconds
déc 05 10:47:56 mariadbd[83127]: Max file size unlimited unlimited bytes
déc 05 10:47:56 mariadbd[83127]: Max data size unlimited unlimited bytes
déc 05 10:47:56 mariadbd[83127]: Max stack size 8388608 unlimited bytes
déc 05 10:47:56 mariadbd[83127]: Max core file size 0 unlimited bytes
déc 05 10:47:56 mariadbd[83127]: Max resident set unlimited unlimited bytes
déc 05 10:47:56 mariadbd[83127]: Max processes 47604 47604 processes
déc 05 10:47:56 mariadbd[83127]: Max open files 32768 32768 files
déc 05 10:47:56 mariadbd[83127]: Max locked memory 65536 65536 bytes
déc 05 10:47:56 mariadbd[83127]: Max address space unlimited unlimited bytes
déc 05 10:47:56 mariadbd[83127]: Max file locks unlimited unlimited locks
déc 05 10:47:56 mariadbd[83127]: Max pending signals 47604 47604 signals
déc 05 10:47:56 mariadbd[83127]: Max msgqueue size 819200 819200 bytes
déc 05 10:47:56 mariadbd[83127]: Max nice priority 0 0
déc 05 10:47:56 mariadbd[83127]: Max realtime priority 0 0
déc 05 10:47:56 mariadbd[83127]: Max realtime timeout unlimited unlimited us
déc 05 10:47:56 mariadbd[83127]: Core pattern: core
déc 05 10:47:56 mariadbd[83127]: Kernel version: Linux version 5.10.0-26-amd64 (debian-kernel@lists.debian.org) (gcc-10 (Debian 10.2.1-6) 10.2.1 20210110, GNU ld (GNU Binutils for Debian) 2.35.2) #1 SMP Debian 5.10.197-1 (2023-09-29)
déc 05 10:47:56 systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
déc 05 10:47:56 systemd[1]: mariadb.service: Failed with result 'signal'.
déc 05 10:47:56 systemd[1]: mariadb.service: Consumed 15.009s CPU time.
déc 05 10:48:02 systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 10.
déc 05 10:48:02 systemd[1]: Stopped MariaDB 10.5.21 database server.
déc 05 10:48:02 systemd[1]: mariadb.service: Consumed 15.009s CPU time.
déc 05 10:48:02 systemd[1]: Starting MariaDB 10.5.21 database server...
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [Note] Starting MariaDB 10.5.21-MariaDB-0+deb11u1 source revision bed70468ea08c2820647f5e3ac006a9ff88144ac as process 83721
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [Note] InnoDB: Uses event mutexes
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [Note] InnoDB: Number of pools: 1
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [Note] InnoDB: Using Linux native AIO
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [Note] InnoDB: Completed initialization of buffer pool
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=147713942057,147713942057
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [ERROR] InnoDB: Malformed log record; set innodb_force_recovery=1 to ignore.
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=147713942057) to 100 bytes after the record:
déc 05 10:48:02 mariadbd[83721]: len 112; hex 1b2f9db75a7aef7413c6372d6ad629b7ea0b6f144955ae1bbd0b457032eb43ecc6089ba2c8a6319cc89653aa6a8c6301465793858a5d07d36acb4d462900da65d16349c939a9bd602e1dbdb0228ea598aa8c4c328ea9dd802934154455d63793950db6b62a74174c1e84e456a16bafad; asc / Zz t 7-j ) o IU Ep2 C 1 S j c FW ] j MF) e cI 9 `. " L2 )4 DU 7 *t L V k ;
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [Warning] InnoDB: Log scan aborted at LSN 147714007040
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [Note] InnoDB: Starting shutdown...
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [ERROR] Plugin 'InnoDB' init function returned error.
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [Note] Plugin 'FEEDBACK' is disabled.
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [ERROR] Unknown/unsupported storage engine: InnoDB
déc 05 10:48:02 mariadbd[83721]: 2023-12-05 10:48:02 0 [ERROR] Aborting
déc 05 10:48:02 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
déc 05 10:48:02 systemd[1]: mariadb.service: Failed with result 'exit-code'.
déc 05 10:48:02 systemd[1]: Failed to start MariaDB 10.5.21 database server.
J’ai exécuté la commande suivante, trouvée ici https://forum.yunohost.org/t/probleme-avec-ma-mysql/4002/3 pour tenter de réparer la table oc_calendar_reminders
:
$ sudo mysqld --skip-grant-tables
(J’ai maladroitement fermé le terminal après l’execution, je ne vois donc plus les actions qui ont été faites…)
C’est juste après cette commande que je perds le service mysql, que je ne peux plus redémarrer depuis.
Voici le log mysql lorsque j’essaye de redémarrer le service depuis l’interface admin :
déc 05 11:39:18 systemd[1]: Starting MariaDB 10.5.21 database server...
déc 05 11:39:18 mariadbd[2447]: 2023-12-05 11:39:18 0 [Note] Starting MariaDB 10.5.21-MariaDB-0+deb11u1 source revision bed70468ea08c2820647f5e3ac006a9ff88144ac as process 2447
déc 05 11:39:18 mariadbd[2447]: 2023-12-05 11:39:18 0 [Note] InnoDB: Uses event mutexes
déc 05 11:39:18 mariadbd[2447]: 2023-12-05 11:39:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
déc 05 11:39:18 mariadbd[2447]: 2023-12-05 11:39:18 0 [Note] InnoDB: Number of pools: 1
déc 05 11:39:18 mariadbd[2447]: 2023-12-05 11:39:18 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [Note] InnoDB: Using Linux native AIO
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [Note] InnoDB: Completed initialization of buffer pool
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=147713942057,147713942057
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [ERROR] InnoDB: Malformed log record; set innodb_force_recovery=1 to ignore.
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=147713942057) to 100 bytes after the record:
déc 05 11:39:19 mariadbd[2447]: len 112; hex 1b2f9db75a7aef7413c6372d6ad629b7ea0b6f144955ae1bbd0b457032eb43ecc6089ba2c8a6319cc89653aa6a8c6301465793858a5d07d36acb4d462900da65d16349c939a9bd602e1dbdb0228ea598aa8c4c328ea9dd802934154455d63793950db6b62a74174c1e84e456a16bafad; asc / Zz t 7-j ) o IU Ep2 C 1 S j c FW ] j MF) e cI 9 `. " L2 )4 DU 7 *t L V k ;
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [Warning] InnoDB: Log scan aborted at LSN 147714007040
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [Note] InnoDB: Starting shutdown...
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [ERROR] Plugin 'InnoDB' init function returned error.
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [Note] Plugin 'FEEDBACK' is disabled.
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [ERROR] Unknown/unsupported storage engine: InnoDB
déc 05 11:39:19 mariadbd[2447]: 2023-12-05 11:39:19 0 [ERROR] Aborting
déc 05 11:39:19 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
déc 05 11:39:19 systemd[1]: mariadb.service: Failed with result 'exit-code'.
déc 05 11:39:19 systemd[1]: Failed to start MariaDB 10.5.21 database server.
Est-ce que quelqu’un aurait une idée de comment relancer mysql ?
Je lis plusieurs choses sur le forum mais je suis incapable de les tester par peur de me paumer encore plus… Comme https://forum.yunohost.org/t/comment-reparer-innodb-error/5603
Merci pour votre aide !