Bonjour à tous,

J'essaye d'installer nexxtcloud sur mon serveur et tout allé bien sauf que au moment de l'installation mysql avais arete de fonctionner.

Ci dessous les log et journal,

$ sudo systemctl status mysql.service -l
● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Fri 2021-09-10 07:48:06 UTC; 11min ago
    Process: 59422 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
    Process: 59430 ExecStart=/usr/sbin/mysqld (code=exited, status=2)
   Main PID: 59430 (code=exited, status=2)
     Status: "Server startup in progress"

sept. 10 07:48:06 srvprod systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
sept. 10 07:48:06 srvprod systemd[1]: Stopped MySQL Community Server.
sept. 10 07:48:06 srvprod systemd[1]: mysql.service: Start request repeated too quickly.
sept. 10 07:48:06 srvprod systemd[1]: mysql.service: Failed with result 'exit-code'.
sept. 10 07:48:06 srvprod systemd[1]: Failed to start MySQL Community Server.

le log,

$ cat /var/log/mysql/error.log 
2021-09-09T18:34:46.680878Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.26-0ubuntu0.20.04.2) initializing of server in progress as process 11952
2021-09-09T18:34:46.727885Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-09-09T18:35:00.062586Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-09-09T18:35:27.546574Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-09-09T18:35:27.546850Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-09-09T18:35:27.598670Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2021-09-09T18:36:10.932722Z 6 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.26-0ubuntu0.20.04.2).
2021-09-09T18:36:33.673948Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.26-0ubuntu0.20.04.2) starting as process 12030
2021-09-09T18:36:34.668229Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-09-09T18:36:35.693214Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-09-09T18:36:35.929818Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
2021-09-09T18:36:35.930091Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2021-09-09T18:36:36.700788Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-09-09T18:36:36.701043Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-09-09T18:36:36.702283Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-09-09T18:36:36.702553Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-09-09T18:36:36.840262Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2021-09-09T18:36:36.859293Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.26-0ubuntu0.20.04.2'  socket: '/tmp/tmp.YOnxroyKtS/mysqld.sock'  port: 0  (Ubuntu).
2021-09-09T18:36:36.996481Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.26-0ubuntu0.20.04.2).
2021-09-09T18:36:40.020585Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.26-0ubuntu0.20.04.2)  (Ubuntu).
2021-09-09T18:36:41.013218Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.26-0ubuntu0.20.04.2) starting as process 12105
2021-09-09T18:36:41.020261Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-09-09T18:36:42.407601Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-09-09T18:36:42.566828Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2021-09-09T18:36:42.818780Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-09-09T18:36:42.819013Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-09-09T18:36:42.820182Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-09-09T18:36:42.820462Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-09-09T18:36:42.854382Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2021-09-09T18:36:42.991325Z 7 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.26-0ubuntu0.20.04.2).
2021-09-09T18:36:42.992429Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060
2021-09-09T18:36:45.897028Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.26-0ubuntu0.20.04.2)  (Ubuntu).
2021-09-09T18:36:48.266911Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.26-0ubuntu0.20.04.2) starting as process 12318
2021-09-09T18:36:48.301733Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-09-09T18:36:49.167012Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-09-09T18:36:49.659103Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-09-09T18:36:49.659536Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-09-09T18:36:49.661663Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-09-09T18:36:49.662112Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-09-09T18:36:49.682519Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2021-09-09T18:36:49.682563Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.26-0ubuntu0.20.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2021-09-10T07:42:52.648085Z 0 [ERROR] [MY-012644] [InnoDB] Encountered a problem with file './obierti_cloud/oc_collres_collections.ibd'
2021-09-10T07:42:52.975685Z 0 [ERROR] [MY-012645] [InnoDB] Disk is full. Try to clean the disk to free space.
2021-09-10T07:42:52.975744Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: fil0fil.cc:8114:err == DB_SUCCESS thread 139703927953152
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
07:42:53 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
2021-09-10T07:42:54.243235Z 41 [Warning] [MY-012128] [InnoDB] posix_fallocate(): Failed to preallocate data for file ./obierti_cloud/oc_known_users.ibd, desired size 57344 Operating system error number 28 - No such file or directory. Check that the disk is not full or a disk quota exceeded. Make sure the file system supports this function. Refer to your operating system documentation for operating system error code information.
2021-09-10T07:42:54.243372Z 41 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2021-09-10T07:42:54.243502Z 41 [ERROR] [MY-013133] [Server] Create table/tablespace 'oc_known_users' failed, as disk is full.
stack_bottom = 0 thread_stack 0x46000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x55ba775c5711]
/usr/sbin/mysqld(handle_fatal_signal+0x31b) [0x55ba7629c5bb]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x153c0) [0x7f0f712f13c0]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb) [0x7f0f7094e18b]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x12b) [0x7f0f7092d859]
/usr/sbin/mysqld(+0xf4324d) [0x55ba75fbf24d]
/usr/sbin/mysqld(fil_aio_wait(unsigned long)+0x180) [0x55ba77a299e0]
/usr/sbin/mysqld(+0x27ed6a8) [0x55ba778696a8]
/usr/sbin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)(unsigned long), unsigned long> > >::_M_run()+0xc1) [0x55ba77869841]
/lib/x86_64-linux-gnu/libstdc++

$ journalctl -xe
-- Le redémarrage automatique de l'unité (unit) mysql.service a été planifié, en
-- raison de sa configuration avec le paramètre Restart=.
sept. 10 08:02:31 srvprod systemd[1]: Stopped MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a terminé son arrêt
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- L'unité (unit) mysql.service a terminé son arrêt.
sept. 10 08:02:31 srvprod systemd[1]: Starting MySQL Community Server...
-- Subject: L'unité (unit) mysql.service a commencé à démarrer
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- L'unité (unit) mysql.service a commencé à démarrer.
sept. 10 08:02:32 srvprod audit[59679]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/59679/task/59680/mem" pid=59679 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=113 ouid=113
sept. 10 08:02:32 srvprod kernel: audit: type=1400 audit(1631260952.035:95): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/59679/task/59680/mem" pid=59679 comm="mysqld" requested_mask="r" denied_mask="r" fsui>
sept. 10 08:02:32 srvprod systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- An ExecStart= process belonging to unit mysql.service has exited.
-- 
-- The process' exit code is 'exited' and its exit status is 2.
sept. 10 08:02:32 srvprod systemd[1]: mysql.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- The unit mysql.service has entered the 'failed' state with result 'exit-code'.
sept. 10 08:02:32 srvprod systemd[1]: Failed to start MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a échoué
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- L'unité (unit) mysql.service a échoué, avec le résultat failed.
sept. 10 08:02:32 srvprod systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
-- Subject: Le redémarrage automatique d'une unité (unit) a été planifié
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- Le redémarrage automatique de l'unité (unit) mysql.service a été planifié, en
-- raison de sa configuration avec le paramètre Restart=.
sept. 10 08:02:32 srvprod systemd[1]: Stopped MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a terminé son arrêt
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- L'unité (unit) mysql.service a terminé son arrêt.
sept. 10 08:02:32 srvprod systemd[1]: mysql.service: Start request repeated too quickly.
sept. 10 08:02:32 srvprod systemd[1]: mysql.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- The unit mysql.service has entered the 'failed' state with result 'exit-code'.
sept. 10 08:02:32 srvprod systemd[1]: Failed to start MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a échoué
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- L'unité (unit) mysql.service a échoué, avec le résultat failed.

Merci d'avance pour votre aide, et de m aider à comprendre mon erreur.

Cordialement.

Bonjour,

Dans ton deuxième log, tu as quelques erreurs indiquant que le disque est plein, et d'autres erreurs, qui en sont juste la conséquence, de droits d'accès au fichier de verrouillage "/var/run/mysqld/mysqlx.sock.lock".

Apparemment, il peut arriver qu'en cas de plantage, ce fichier de verrouillage, qui est censé empêcher de lancer plusieurs instances du serveur, ne soit pas effacé en cas de plantage du serveur, donc il faudra peut-être l'effacer manuellement ou rebooter (/var/run est stocké en RAM) après avoir libéré de l'espace disque.