[MariaDB] Je n'arrive plus à me connecter (résolu)

Applications, problèmes de configuration réseau
stephan08
Daikyu
Messages : 93
Inscription : jeu. 19 nov. 2015, 23:18

[MariaDB] Je n'arrive plus à me connecter (résolu)

Message par stephan08 »

Bonjour,

Je n'arrive plus à me connecter à MariaDB.

Lorsque je lance:

Code : Tout sélectionner

systemctl start mysqld
Rien ne se passe.

Et

Code : Tout sélectionner

systemctl status mysqld
me donne:

Code : Tout sélectionner

● mariadb.service - MariaDB 10.4.8 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: inactive (dead) since Sun 2019-10-06 14:47:37 CEST; 1h 12min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 3718 ExecStart=/usr/bin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSI>
 Main PID: 3718 (code=exited, status=0/SUCCESS)
   Status: "MariaDB server is down"

oct. 06 14:47:35 stephanpc mysqld[3718]: 2019-10-06 14:47:35 0 [Note] Event Scheduler: Purgin>
oct. 06 14:47:35 stephanpc mysqld[3718]: 2019-10-06 14:47:35 0 [Note] InnoDB: FTS optimize th>
oct. 06 14:47:35 stephanpc mysqld[3718]: 2019-10-06 14:47:35 0 [Note] InnoDB: Starting shutdo>
oct. 06 14:47:35 stephanpc mysqld[3718]: 2019-10-06 14:47:35 0 [Note] InnoDB: Dumping buffer >
oct. 06 14:47:35 stephanpc mysqld[3718]: 2019-10-06 14:47:35 0 [Note] InnoDB: Buffer pool(s) >
oct. 06 14:47:37 stephanpc mysqld[3718]: 2019-10-06 14:47:37 0 [Note] InnoDB: Shutdown comple>
oct. 06 14:47:37 stephanpc mysqld[3718]: 2019-10-06 14:47:37 0 [Note] InnoDB: Removed tempora>
oct. 06 14:47:37 stephanpc mysqld[3718]: 2019-10-06 14:47:37 0 [Note] /usr/bin/mysqld: Shutdo>
oct. 06 14:47:37 stephanpc systemd[1]: mariadb.service: Succeeded.
oct. 06 14:47:37 stephanpc systemd[1]: Stopped MariaDB 10.4.8 database server.
Comment résoudre ce problème?

Merci par avance
Dernière modification par stephan08 le lun. 07 oct. 2019, 18:26, modifié 1 fois.
Avatar de l’utilisateur
benjarobin
Maître du Kyudo
Messages : 17187
Inscription : sam. 30 mai 2009, 15:48
Localisation : Lyon

Re: [MariaDB] Je n'arrive plus à me connecter

Message par benjarobin »

Bonjour, pense à donner tous les log, et non ce qui est visible à l'écran.
Le mieux est que tu donnes la sortie (que tu auras redirigé dans un fichier) de : journalctl -b -u mariadb.service
Zsh | KDE | PC fixe : core i7, carte nvidia
Titre d'un sujet : [Thème] Sujet (état) / Règles du forum
stephan08
Daikyu
Messages : 93
Inscription : jeu. 19 nov. 2015, 23:18

Re: [MariaDB] Je n'arrive plus à me connecter

Message par stephan08 »

journalctl -b -u mariadb.service

me donne:

Code : Tout sélectionner

Hint: You are currently not seeing messages from other users and the system.
      Users in groups 'adm', 'systemd-journal', 'wheel' can see all messages.
      Pass -q to turn off this notice.
-- Logs begin at Sun 2019-01-13 01:03:59 CET, end at Sun 2019-10-06 16:10:47 CEST. --
-- No entries --
Je l'ai lancé du coup en root et j'obtiens:

Code : Tout sélectionner

-- Logs begin at Sat 2019-01-12 23:15:16 CET, end at Sun 2019-10-06 18:47:20 CEST. --
oct. 06 13:10:33 stephanpc systemd[1]: Starting MariaDB 10.4.8 database server...
oct. 06 13:10:34 stephanpc sh[482]: [109B blob data]
oct. 06 13:10:34 stephanpc sh[482]: Fatal error in defaults handling. Program aborted
oct. 06 13:10:35 stephanpc mysqld[493]: [98B blob data]
oct. 06 13:10:35 stephanpc mysqld[493]: Fatal error in defaults handling. Program aborted
oct. 06 13:10:36 stephanpc systemd[1]: mariadb.service: Main process exited, code=exited, sta>
oct. 06 13:10:36 stephanpc systemd[1]: mariadb.service: Failed with result 'exit-code'.
oct. 06 13:10:36 stephanpc systemd[1]: Failed to start MariaDB 10.4.8 database server.
oct. 06 14:23:50 stephanpc systemd[1]: Starting MariaDB 10.4.8 database server...
oct. 06 14:23:50 stephanpc mysqld[3718]: 2019-10-06 14:23:50 0 [Note] /usr/bin/mysqld (mysqld>
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Using Linux nat>
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Mutexes and rw_>
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Uses event mute>
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Compressed tabl>
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Number of pools>
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Using SSE2 crc3>
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] mysqld: O_TMPFILE is no>
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Initializing bu>
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Completed initi>
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: If the mysqld e>
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Upgrading redo >
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Starting to del>
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Setting log fil>
lines 1-24...skipping...
-- Logs begin at Sat 2019-01-12 23:15:16 CET, end at Sun 2019-10-06 18:47:20 CEST. --
oct. 06 13:10:33 stephanpc systemd[1]: Starting MariaDB 10.4.8 database server...
oct. 06 13:10:34 stephanpc sh[482]: [109B blob data]
oct. 06 13:10:34 stephanpc sh[482]: Fatal error in defaults handling. Program aborted
oct. 06 13:10:35 stephanpc mysqld[493]: [98B blob data]
oct. 06 13:10:35 stephanpc mysqld[493]: Fatal error in defaults handling. Program aborted
oct. 06 13:10:36 stephanpc systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
oct. 06 13:10:36 stephanpc systemd[1]: mariadb.service: Failed with result 'exit-code'.
oct. 06 13:10:36 stephanpc systemd[1]: Failed to start MariaDB 10.4.8 database server.
oct. 06 14:23:50 stephanpc systemd[1]: Starting MariaDB 10.4.8 database server...
oct. 06 14:23:50 stephanpc mysqld[3718]: 2019-10-06 14:23:50 0 [Note] /usr/bin/mysqld (mysqld 10.4.8-MariaDB) starting as process 3718 ...
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Using Linux native AIO
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Uses event mutexes
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Number of pools: 1
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Using SSE2 crc32 instructions
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Completed initialization of buffer pool
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of se>
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Upgrading redo log: 2*50331648 bytes; LSN=1630345
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Starting to delete and rewrite log files.
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
oct. 06 14:23:51 stephanpc mysqld[3718]: 2019-10-06 14:23:51 0 [Note] InnoDB: New log files created, LSN=1630345
oct. 06 14:23:52 stephanpc mysqld[3718]: 2019-10-06 14:23:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
oct. 06 14:23:52 stephanpc mysqld[3718]: 2019-10-06 14:23:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
oct. 06 14:23:52 stephanpc mysqld[3718]: 2019-10-06 14:23:52 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
oct. 06 14:23:52 stephanpc mysqld[3718]: 2019-10-06 14:23:52 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
oct. 06 14:23:52 stephanpc mysqld[3718]: 2019-10-06 14:23:52 0 [Note] InnoDB: Waiting for purge to start
oct. 06 14:23:52 stephanpc mysqld[3718]: 2019-10-06 14:23:52 0 [Note] InnoDB: 10.4.8 started; log sequence number 1630345; transaction id 23
oct. 06 14:23:52 stephanpc mysqld[3718]: 2019-10-06 14:23:52 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
oct. 06 14:23:52 stephanpc mysqld[3718]: 2019-10-06 14:23:52 0 [Note] Server socket created on IP: '::'.
oct. 06 14:23:52 stephanpc mysqld[3718]: 2019-10-06 14:23:52 0 [Note] InnoDB: Buffer pool(s) load completed at 191006 14:23:52
oct. 06 14:23:52 stephanpc mysqld[3718]: 2019-10-06 14:23:52 0 [Note] Reading of all Master_info entries succeeded
oct. 06 14:23:52 stephanpc mysqld[3718]: 2019-10-06 14:23:52 0 [Note] Added new Master_info '' to hash table
oct. 06 14:23:52 stephanpc mysqld[3718]: 2019-10-06 14:23:52 0 [Note] /usr/bin/mysqld: ready for connections.
oct. 06 14:23:52 stephanpc mysqld[3718]: Version: '10.4.8-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Arch Linux
oct. 06 14:23:52 stephanpc systemd[1]: Started MariaDB 10.4.8 database server.
oct. 06 14:24:37 stephanpc mysqld[3718]: 2019-10-06 14:24:37 8 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
oct. 06 14:24:55 stephanpc mysqld[3718]: 2019-10-06 14:24:55 9 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
oct. 06 14:25:13 stephanpc mysqld[3718]: 2019-10-06 14:25:13 10 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
oct. 06 14:25:17 stephanpc mysqld[3718]: 2019-10-06 14:25:17 11 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
oct. 06 14:25:21 stephanpc mysqld[3718]: 2019-10-06 14:25:21 12 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
oct. 06 14:38:53 stephanpc mysqld[3718]: 2019-10-06 14:38:53 15 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
oct. 06 14:39:49 stephanpc mysqld[3718]: 2019-10-06 14:39:49 17 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
oct. 06 14:39:55 stephanpc mysqld[3718]: 2019-10-06 14:39:55 18 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
oct. 06 14:41:12 stephanpc mysqld[3718]: 2019-10-06 14:41:12 19 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
oct. 06 14:41:34 stephanpc mysqld[3718]: 2019-10-06 14:41:34 20 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
oct. 06 14:47:35 stephanpc mysqld[3718]: 2019-10-06 14:47:35 0 [Note] /usr/bin/mysqld (initiated by: unknown): Normal shutdown
oct. 06 14:47:35 stephanpc systemd[1]: Stopping MariaDB 10.4.8 database server...
oct. 06 14:47:35 stephanpc mysqld[3718]: 2019-10-06 14:47:35 0 [Note] Event Scheduler: Purging the queue. 0 events
stephan08
Daikyu
Messages : 93
Inscription : jeu. 19 nov. 2015, 23:18

Re: [MariaDB] Je n'arrive plus à me connecter

Message par stephan08 »

Je l'ai redirigé vers un fichier:

Code : Tout sélectionner

oct. 06 16:01:19 stephanpc mysqld[6416]: 2019-10-06 16:01:19 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:20 stephanpc mysqld[6416]: 2019-10-06 16:01:20 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:20 stephanpc mysqld[6416]: 2019-10-06 16:01:20 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:21 stephanpc mysqld[6416]: 2019-10-06 16:01:21 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:21 stephanpc mysqld[6416]: 2019-10-06 16:01:21 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:22 stephanpc mysqld[6416]: 2019-10-06 16:01:22 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:22 stephanpc mysqld[6416]: 2019-10-06 16:01:22 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:23 stephanpc mysqld[6416]: 2019-10-06 16:01:23 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:23 stephanpc mysqld[6416]: 2019-10-06 16:01:23 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:24 stephanpc mysqld[6416]: 2019-10-06 16:01:24 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:24 stephanpc mysqld[6416]: 2019-10-06 16:01:24 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:25 stephanpc mysqld[6416]: 2019-10-06 16:01:25 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:25 stephanpc mysqld[6416]: 2019-10-06 16:01:25 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:26 stephanpc mysqld[6416]: 2019-10-06 16:01:26 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:26 stephanpc mysqld[6416]: 2019-10-06 16:01:26 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:27 stephanpc mysqld[6416]: 2019-10-06 16:01:27 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:27 stephanpc mysqld[6416]: 2019-10-06 16:01:27 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:28 stephanpc mysqld[6416]: 2019-10-06 16:01:28 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:28 stephanpc mysqld[6416]: 2019-10-06 16:01:28 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:29 stephanpc mysqld[6416]: 2019-10-06 16:01:29 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:29 stephanpc mysqld[6416]: 2019-10-06 16:01:29 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:30 stephanpc mysqld[6416]: 2019-10-06 16:01:30 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:30 stephanpc mysqld[6416]: 2019-10-06 16:01:30 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:31 stephanpc mysqld[6416]: 2019-10-06 16:01:31 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:31 stephanpc mysqld[6416]: 2019-10-06 16:01:31 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:32 stephanpc mysqld[6416]: 2019-10-06 16:01:32 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:32 stephanpc mysqld[6416]: 2019-10-06 16:01:32 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:33 stephanpc mysqld[6416]: 2019-10-06 16:01:33 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:33 stephanpc mysqld[6416]: 2019-10-06 16:01:33 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:34 stephanpc mysqld[6416]: 2019-10-06 16:01:34 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:34 stephanpc mysqld[6416]: 2019-10-06 16:01:34 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:35 stephanpc mysqld[6416]: 2019-10-06 16:01:35 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:35 stephanpc mysqld[6416]: 2019-10-06 16:01:35 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:36 stephanpc mysqld[6416]: 2019-10-06 16:01:36 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:36 stephanpc mysqld[6416]: 2019-10-06 16:01:36 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:37 stephanpc mysqld[6416]: 2019-10-06 16:01:37 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:37 stephanpc mysqld[6416]: 2019-10-06 16:01:37 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:38 stephanpc mysqld[6416]: 2019-10-06 16:01:38 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:38 stephanpc mysqld[6416]: 2019-10-06 16:01:38 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:39 stephanpc mysqld[6416]: 2019-10-06 16:01:39 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:39 stephanpc mysqld[6416]: 2019-10-06 16:01:39 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:40 stephanpc mysqld[6416]: 2019-10-06 16:01:40 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:40 stephanpc mysqld[6416]: 2019-10-06 16:01:40 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:41 stephanpc mysqld[6416]: 2019-10-06 16:01:41 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:41 stephanpc mysqld[6416]: 2019-10-06 16:01:41 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:42 stephanpc mysqld[6416]: 2019-10-06 16:01:42 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:42 stephanpc mysqld[6416]: 2019-10-06 16:01:42 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:43 stephanpc mysqld[6416]: 2019-10-06 16:01:43 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:43 stephanpc mysqld[6416]: 2019-10-06 16:01:43 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:44 stephanpc mysqld[6416]: 2019-10-06 16:01:44 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:44 stephanpc mysqld[6416]: 2019-10-06 16:01:44 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:45 stephanpc mysqld[6416]: 2019-10-06 16:01:45 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:45 stephanpc mysqld[6416]: 2019-10-06 16:01:45 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:46 stephanpc mysqld[6416]: 2019-10-06 16:01:46 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:46 stephanpc mysqld[6416]: 2019-10-06 16:01:46 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:47 stephanpc mysqld[6416]: 2019-10-06 16:01:47 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:47 stephanpc mysqld[6416]: 2019-10-06 16:01:47 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:48 stephanpc mysqld[6416]: 2019-10-06 16:01:48 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:48 stephanpc mysqld[6416]: 2019-10-06 16:01:48 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:49 stephanpc mysqld[6416]: 2019-10-06 16:01:49 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:49 stephanpc mysqld[6416]: 2019-10-06 16:01:49 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:50 stephanpc mysqld[6416]: 2019-10-06 16:01:50 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:50 stephanpc mysqld[6416]: 2019-10-06 16:01:50 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:51 stephanpc mysqld[6416]: 2019-10-06 16:01:51 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:51 stephanpc mysqld[6416]: 2019-10-06 16:01:51 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:52 stephanpc mysqld[6416]: 2019-10-06 16:01:52 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:52 stephanpc mysqld[6416]: 2019-10-06 16:01:52 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:53 stephanpc mysqld[6416]: 2019-10-06 16:01:53 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:53 stephanpc mysqld[6416]: 2019-10-06 16:01:53 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:54 stephanpc mysqld[6416]: 2019-10-06 16:01:54 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:54 stephanpc mysqld[6416]: 2019-10-06 16:01:54 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:55 stephanpc mysqld[6416]: 2019-10-06 16:01:55 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:55 stephanpc mysqld[6416]: 2019-10-06 16:01:55 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:56 stephanpc mysqld[6416]: 2019-10-06 16:01:56 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:56 stephanpc mysqld[6416]: 2019-10-06 16:01:56 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:57 stephanpc mysqld[6416]: 2019-10-06 16:01:57 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:57 stephanpc mysqld[6416]: 2019-10-06 16:01:57 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:58 stephanpc mysqld[6416]: 2019-10-06 16:01:58 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:58 stephanpc mysqld[6416]: 2019-10-06 16:01:58 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:59 stephanpc mysqld[6416]: 2019-10-06 16:01:59 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:01:59 stephanpc mysqld[6416]: 2019-10-06 16:01:59 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:01:59 stephanpc systemd[1]: mariadb.service: start operation timed out. Terminating.
oct. 06 16:02:00 stephanpc mysqld[6416]: 2019-10-06 16:02:00 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:00 stephanpc mysqld[6416]: 2019-10-06 16:02:00 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:01 stephanpc mysqld[6416]: 2019-10-06 16:02:01 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:01 stephanpc mysqld[6416]: 2019-10-06 16:02:01 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:02 stephanpc mysqld[6416]: 2019-10-06 16:02:02 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:02 stephanpc mysqld[6416]: 2019-10-06 16:02:02 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:03 stephanpc mysqld[6416]: 2019-10-06 16:02:03 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:03 stephanpc mysqld[6416]: 2019-10-06 16:02:03 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:04 stephanpc mysqld[6416]: 2019-10-06 16:02:04 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:04 stephanpc mysqld[6416]: 2019-10-06 16:02:04 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:05 stephanpc mysqld[6416]: 2019-10-06 16:02:05 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:05 stephanpc mysqld[6416]: 2019-10-06 16:02:05 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:06 stephanpc mysqld[6416]: 2019-10-06 16:02:06 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:06 stephanpc mysqld[6416]: 2019-10-06 16:02:06 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:07 stephanpc mysqld[6416]: 2019-10-06 16:02:07 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:07 stephanpc mysqld[6416]: 2019-10-06 16:02:07 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:08 stephanpc mysqld[6416]: 2019-10-06 16:02:08 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:08 stephanpc mysqld[6416]: 2019-10-06 16:02:08 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:09 stephanpc mysqld[6416]: 2019-10-06 16:02:09 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:09 stephanpc mysqld[6416]: 2019-10-06 16:02:09 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:10 stephanpc mysqld[6416]: 2019-10-06 16:02:10 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:10 stephanpc mysqld[6416]: 2019-10-06 16:02:10 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:11 stephanpc mysqld[6416]: 2019-10-06 16:02:11 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:11 stephanpc mysqld[6416]: 2019-10-06 16:02:11 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:12 stephanpc mysqld[6416]: 2019-10-06 16:02:12 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:12 stephanpc mysqld[6416]: 2019-10-06 16:02:12 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:13 stephanpc mysqld[6416]: 2019-10-06 16:02:13 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:13 stephanpc mysqld[6416]: 2019-10-06 16:02:13 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:14 stephanpc mysqld[6416]: 2019-10-06 16:02:14 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:14 stephanpc mysqld[6416]: 2019-10-06 16:02:14 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:15 stephanpc mysqld[6416]: 2019-10-06 16:02:15 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:15 stephanpc mysqld[6416]: 2019-10-06 16:02:15 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:16 stephanpc mysqld[6416]: 2019-10-06 16:02:16 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:16 stephanpc mysqld[6416]: 2019-10-06 16:02:16 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:17 stephanpc mysqld[6416]: 2019-10-06 16:02:17 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:17 stephanpc mysqld[6416]: 2019-10-06 16:02:17 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:18 stephanpc mysqld[6416]: 2019-10-06 16:02:18 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:18 stephanpc mysqld[6416]: 2019-10-06 16:02:18 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:19 stephanpc mysqld[6416]: 2019-10-06 16:02:19 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:19 stephanpc mysqld[6416]: 2019-10-06 16:02:19 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:20 stephanpc mysqld[6416]: 2019-10-06 16:02:20 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:20 stephanpc mysqld[6416]: 2019-10-06 16:02:20 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:21 stephanpc mysqld[6416]: 2019-10-06 16:02:21 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:21 stephanpc mysqld[6416]: 2019-10-06 16:02:21 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:22 stephanpc mysqld[6416]: 2019-10-06 16:02:22 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:22 stephanpc mysqld[6416]: 2019-10-06 16:02:22 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:23 stephanpc mysqld[6416]: 2019-10-06 16:02:23 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:23 stephanpc mysqld[6416]: 2019-10-06 16:02:23 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:24 stephanpc mysqld[6416]: 2019-10-06 16:02:24 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:24 stephanpc mysqld[6416]: 2019-10-06 16:02:24 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:25 stephanpc mysqld[6416]: 2019-10-06 16:02:25 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:25 stephanpc mysqld[6416]: 2019-10-06 16:02:25 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:26 stephanpc mysqld[6416]: 2019-10-06 16:02:26 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:26 stephanpc mysqld[6416]: 2019-10-06 16:02:26 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:27 stephanpc mysqld[6416]: 2019-10-06 16:02:27 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:27 stephanpc mysqld[6416]: 2019-10-06 16:02:27 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:28 stephanpc mysqld[6416]: 2019-10-06 16:02:28 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:28 stephanpc mysqld[6416]: 2019-10-06 16:02:28 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:29 stephanpc mysqld[6416]: 2019-10-06 16:02:29 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:29 stephanpc mysqld[6416]: 2019-10-06 16:02:29 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:30 stephanpc mysqld[6416]: 2019-10-06 16:02:30 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:30 stephanpc mysqld[6416]: 2019-10-06 16:02:30 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:31 stephanpc mysqld[6416]: 2019-10-06 16:02:31 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:31 stephanpc mysqld[6416]: 2019-10-06 16:02:31 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:32 stephanpc mysqld[6416]: 2019-10-06 16:02:32 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:32 stephanpc mysqld[6416]: 2019-10-06 16:02:32 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:33 stephanpc mysqld[6416]: 2019-10-06 16:02:33 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:33 stephanpc mysqld[6416]: 2019-10-06 16:02:33 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:34 stephanpc mysqld[6416]: 2019-10-06 16:02:34 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:34 stephanpc mysqld[6416]: 2019-10-06 16:02:34 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:35 stephanpc mysqld[6416]: 2019-10-06 16:02:35 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:35 stephanpc mysqld[6416]: 2019-10-06 16:02:35 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:36 stephanpc mysqld[6416]: 2019-10-06 16:02:36 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:36 stephanpc mysqld[6416]: 2019-10-06 16:02:36 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:37 stephanpc mysqld[6416]: 2019-10-06 16:02:37 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:37 stephanpc mysqld[6416]: 2019-10-06 16:02:37 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:38 stephanpc mysqld[6416]: 2019-10-06 16:02:38 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:38 stephanpc mysqld[6416]: 2019-10-06 16:02:38 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:39 stephanpc mysqld[6416]: 2019-10-06 16:02:39 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:39 stephanpc mysqld[6416]: 2019-10-06 16:02:39 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:40 stephanpc mysqld[6416]: 2019-10-06 16:02:40 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:02:40 stephanpc mysqld[6416]: 2019-10-06 16:02:40 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:02:40 stephanpc mysqld[6416]: 2019-10-06 16:02:40 0 [Note] InnoDB: Unable to open the first data file
oct. 06 16:02:40 stephanpc mysqld[6416]: 2019-10-06 16:02:40 0 [ERROR] InnoDB: Operating system error number 11 in a file operation.
oct. 06 16:02:40 stephanpc mysqld[6416]: 2019-10-06 16:02:40 0 [ERROR] InnoDB: Error number 11 means 'Resource temporarily unavailable'
oct. 06 16:02:40 stephanpc mysqld[6416]: 2019-10-06 16:02:40 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
oct. 06 16:02:40 stephanpc mysqld[6416]: 2019-10-06 16:02:40 0 [ERROR] InnoDB: Cannot open datafile './ibdata1'
oct. 06 16:02:40 stephanpc mysqld[6416]: 2019-10-06 16:02:40 0 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
oct. 06 16:02:40 stephanpc mysqld[6416]: 2019-10-06 16:02:40 0 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file
oct. 06 16:02:40 stephanpc mysqld[6416]: 2019-10-06 16:02:40 0 [Note] InnoDB: Starting shutdown...
oct. 06 16:02:41 stephanpc mysqld[6416]: 2019-10-06 16:02:41 0 [ERROR] Plugin 'InnoDB' init function returned error.
oct. 06 16:02:41 stephanpc mysqld[6416]: 2019-10-06 16:02:41 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
oct. 06 16:02:41 stephanpc mysqld[6416]: 2019-10-06 16:02:41 0 [ERROR] Failed to initialize plugins.
oct. 06 16:02:41 stephanpc mysqld[6416]: 2019-10-06 16:02:41 0 [ERROR] Aborting
oct. 06 16:02:41 stephanpc systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
oct. 06 16:02:41 stephanpc systemd[1]: mariadb.service: Failed with result 'timeout'.
oct. 06 16:02:41 stephanpc systemd[1]: Failed to start MariaDB 10.4.8 database server.
oct. 06 16:10:27 stephanpc systemd[1]: Starting MariaDB 10.4.8 database server...
oct. 06 16:10:27 stephanpc mysqld[7170]: 2019-10-06 16:10:27 0 [Note] /usr/bin/mysqld (mysqld 10.4.8-MariaDB) starting as process 7170 ...
oct. 06 16:10:27 stephanpc mysqld[7170]: 2019-10-06 16:10:27 0 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [ERROR] Plugin 'Aria' init function returned error.
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [Note] InnoDB: Using Linux native AIO
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [Note] InnoDB: Uses event mutexes
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [Note] InnoDB: Number of pools: 1
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [Note] InnoDB: Completed initialization of buffer pool
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:10:58 stephanpc mysqld[7170]: 2019-10-06 16:10:58 0 [Note] InnoDB: Retrying to lock the first data file
oct. 06 16:10:59 stephanpc mysqld[7170]: 2019-10-06 16:10:59 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:10:59 stephanpc mysqld[7170]: 2019-10-06 16:10:59 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:00 stephanpc mysqld[7170]: 2019-10-06 16:11:00 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:00 stephanpc mysqld[7170]: 2019-10-06 16:11:00 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:01 stephanpc mysqld[7170]: 2019-10-06 16:11:01 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:01 stephanpc mysqld[7170]: 2019-10-06 16:11:01 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:02 stephanpc mysqld[7170]: 2019-10-06 16:11:02 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:02 stephanpc mysqld[7170]: 2019-10-06 16:11:02 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:03 stephanpc mysqld[7170]: 2019-10-06 16:11:03 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:03 stephanpc mysqld[7170]: 2019-10-06 16:11:03 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:04 stephanpc mysqld[7170]: 2019-10-06 16:11:04 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:04 stephanpc mysqld[7170]: 2019-10-06 16:11:04 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:05 stephanpc mysqld[7170]: 2019-10-06 16:11:05 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:05 stephanpc mysqld[7170]: 2019-10-06 16:11:05 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:06 stephanpc mysqld[7170]: 2019-10-06 16:11:06 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:06 stephanpc mysqld[7170]: 2019-10-06 16:11:06 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:07 stephanpc mysqld[7170]: 2019-10-06 16:11:07 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:07 stephanpc mysqld[7170]: 2019-10-06 16:11:07 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:08 stephanpc mysqld[7170]: 2019-10-06 16:11:08 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:08 stephanpc mysqld[7170]: 2019-10-06 16:11:08 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:09 stephanpc mysqld[7170]: 2019-10-06 16:11:09 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:09 stephanpc mysqld[7170]: 2019-10-06 16:11:09 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:10 stephanpc mysqld[7170]: 2019-10-06 16:11:10 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:10 stephanpc mysqld[7170]: 2019-10-06 16:11:10 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:11 stephanpc mysqld[7170]: 2019-10-06 16:11:11 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:11 stephanpc mysqld[7170]: 2019-10-06 16:11:11 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:12 stephanpc mysqld[7170]: 2019-10-06 16:11:12 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:12 stephanpc mysqld[7170]: 2019-10-06 16:11:12 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:13 stephanpc mysqld[7170]: 2019-10-06 16:11:13 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:13 stephanpc mysqld[7170]: 2019-10-06 16:11:13 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:14 stephanpc mysqld[7170]: 2019-10-06 16:11:14 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:14 stephanpc mysqld[7170]: 2019-10-06 16:11:14 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:15 stephanpc mysqld[7170]: 2019-10-06 16:11:15 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:15 stephanpc mysqld[7170]: 2019-10-06 16:11:15 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:16 stephanpc mysqld[7170]: 2019-10-06 16:11:16 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:16 stephanpc mysqld[7170]: 2019-10-06 16:11:16 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:17 stephanpc mysqld[7170]: 2019-10-06 16:11:17 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:17 stephanpc mysqld[7170]: 2019-10-06 16:11:17 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:18 stephanpc mysqld[7170]: 2019-10-06 16:11:18 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:18 stephanpc mysqld[7170]: 2019-10-06 16:11:18 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:19 stephanpc mysqld[7170]: 2019-10-06 16:11:19 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:19 stephanpc mysqld[7170]: 2019-10-06 16:11:19 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:20 stephanpc mysqld[7170]: 2019-10-06 16:11:20 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:20 stephanpc mysqld[7170]: 2019-10-06 16:11:20 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:21 stephanpc mysqld[7170]: 2019-10-06 16:11:21 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:21 stephanpc mysqld[7170]: 2019-10-06 16:11:21 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:22 stephanpc mysqld[7170]: 2019-10-06 16:11:22 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:22 stephanpc mysqld[7170]: 2019-10-06 16:11:22 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:23 stephanpc mysqld[7170]: 2019-10-06 16:11:23 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:23 stephanpc mysqld[7170]: 2019-10-06 16:11:23 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:24 stephanpc mysqld[7170]: 2019-10-06 16:11:24 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:24 stephanpc mysqld[7170]: 2019-10-06 16:11:24 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:25 stephanpc mysqld[7170]: 2019-10-06 16:11:25 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:25 stephanpc mysqld[7170]: 2019-10-06 16:11:25 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:26 stephanpc mysqld[7170]: 2019-10-06 16:11:26 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:26 stephanpc mysqld[7170]: 2019-10-06 16:11:26 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:27 stephanpc mysqld[7170]: 2019-10-06 16:11:27 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:27 stephanpc mysqld[7170]: 2019-10-06 16:11:27 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:28 stephanpc mysqld[7170]: 2019-10-06 16:11:28 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:28 stephanpc mysqld[7170]: 2019-10-06 16:11:28 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:29 stephanpc mysqld[7170]: 2019-10-06 16:11:29 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:29 stephanpc mysqld[7170]: 2019-10-06 16:11:29 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:30 stephanpc mysqld[7170]: 2019-10-06 16:11:30 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:30 stephanpc mysqld[7170]: 2019-10-06 16:11:30 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:31 stephanpc mysqld[7170]: 2019-10-06 16:11:31 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:31 stephanpc mysqld[7170]: 2019-10-06 16:11:31 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:32 stephanpc mysqld[7170]: 2019-10-06 16:11:32 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:32 stephanpc mysqld[7170]: 2019-10-06 16:11:32 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:33 stephanpc mysqld[7170]: 2019-10-06 16:11:33 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:33 stephanpc mysqld[7170]: 2019-10-06 16:11:33 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:34 stephanpc mysqld[7170]: 2019-10-06 16:11:34 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:34 stephanpc mysqld[7170]: 2019-10-06 16:11:34 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:35 stephanpc mysqld[7170]: 2019-10-06 16:11:35 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:35 stephanpc mysqld[7170]: 2019-10-06 16:11:35 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:36 stephanpc mysqld[7170]: 2019-10-06 16:11:36 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:36 stephanpc mysqld[7170]: 2019-10-06 16:11:36 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:37 stephanpc mysqld[7170]: 2019-10-06 16:11:37 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:37 stephanpc mysqld[7170]: 2019-10-06 16:11:37 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:38 stephanpc mysqld[7170]: 2019-10-06 16:11:38 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:38 stephanpc mysqld[7170]: 2019-10-06 16:11:38 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:39 stephanpc mysqld[7170]: 2019-10-06 16:11:39 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:39 stephanpc mysqld[7170]: 2019-10-06 16:11:39 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:40 stephanpc mysqld[7170]: 2019-10-06 16:11:40 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:40 stephanpc mysqld[7170]: 2019-10-06 16:11:40 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:41 stephanpc mysqld[7170]: 2019-10-06 16:11:41 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:41 stephanpc mysqld[7170]: 2019-10-06 16:11:41 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:42 stephanpc mysqld[7170]: 2019-10-06 16:11:42 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:42 stephanpc mysqld[7170]: 2019-10-06 16:11:42 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:43 stephanpc mysqld[7170]: 2019-10-06 16:11:43 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:43 stephanpc mysqld[7170]: 2019-10-06 16:11:43 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:44 stephanpc mysqld[7170]: 2019-10-06 16:11:44 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:44 stephanpc mysqld[7170]: 2019-10-06 16:11:44 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:45 stephanpc mysqld[7170]: 2019-10-06 16:11:45 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:45 stephanpc mysqld[7170]: 2019-10-06 16:11:45 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:46 stephanpc mysqld[7170]: 2019-10-06 16:11:46 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:46 stephanpc mysqld[7170]: 2019-10-06 16:11:46 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:47 stephanpc mysqld[7170]: 2019-10-06 16:11:47 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:47 stephanpc mysqld[7170]: 2019-10-06 16:11:47 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:48 stephanpc mysqld[7170]: 2019-10-06 16:11:48 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:48 stephanpc mysqld[7170]: 2019-10-06 16:11:48 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:49 stephanpc mysqld[7170]: 2019-10-06 16:11:49 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:49 stephanpc mysqld[7170]: 2019-10-06 16:11:49 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:50 stephanpc mysqld[7170]: 2019-10-06 16:11:50 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:50 stephanpc mysqld[7170]: 2019-10-06 16:11:50 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:51 stephanpc mysqld[7170]: 2019-10-06 16:11:51 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:51 stephanpc mysqld[7170]: 2019-10-06 16:11:51 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:52 stephanpc mysqld[7170]: 2019-10-06 16:11:52 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:52 stephanpc mysqld[7170]: 2019-10-06 16:11:52 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:53 stephanpc mysqld[7170]: 2019-10-06 16:11:53 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:53 stephanpc mysqld[7170]: 2019-10-06 16:11:53 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:54 stephanpc mysqld[7170]: 2019-10-06 16:11:54 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:54 stephanpc mysqld[7170]: 2019-10-06 16:11:54 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:55 stephanpc mysqld[7170]: 2019-10-06 16:11:55 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:55 stephanpc mysqld[7170]: 2019-10-06 16:11:55 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:56 stephanpc mysqld[7170]: 2019-10-06 16:11:56 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:56 stephanpc mysqld[7170]: 2019-10-06 16:11:56 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:57 stephanpc systemd[1]: mariadb.service: start operation timed out. Terminating.
oct. 06 16:11:57 stephanpc mysqld[7170]: 2019-10-06 16:11:57 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:57 stephanpc mysqld[7170]: 2019-10-06 16:11:57 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:58 stephanpc mysqld[7170]: 2019-10-06 16:11:58 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:58 stephanpc mysqld[7170]: 2019-10-06 16:11:58 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:11:59 stephanpc mysqld[7170]: 2019-10-06 16:11:59 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:11:59 stephanpc mysqld[7170]: 2019-10-06 16:11:59 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:00 stephanpc mysqld[7170]: 2019-10-06 16:12:00 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:00 stephanpc mysqld[7170]: 2019-10-06 16:12:00 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:01 stephanpc mysqld[7170]: 2019-10-06 16:12:01 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:01 stephanpc mysqld[7170]: 2019-10-06 16:12:01 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:02 stephanpc mysqld[7170]: 2019-10-06 16:12:02 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:02 stephanpc mysqld[7170]: 2019-10-06 16:12:02 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:03 stephanpc mysqld[7170]: 2019-10-06 16:12:03 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:03 stephanpc mysqld[7170]: 2019-10-06 16:12:03 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:04 stephanpc mysqld[7170]: 2019-10-06 16:12:04 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:04 stephanpc mysqld[7170]: 2019-10-06 16:12:04 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:05 stephanpc mysqld[7170]: 2019-10-06 16:12:05 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:05 stephanpc mysqld[7170]: 2019-10-06 16:12:05 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:06 stephanpc mysqld[7170]: 2019-10-06 16:12:06 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:06 stephanpc mysqld[7170]: 2019-10-06 16:12:06 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:07 stephanpc mysqld[7170]: 2019-10-06 16:12:07 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:07 stephanpc mysqld[7170]: 2019-10-06 16:12:07 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:08 stephanpc mysqld[7170]: 2019-10-06 16:12:08 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:08 stephanpc mysqld[7170]: 2019-10-06 16:12:08 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:09 stephanpc mysqld[7170]: 2019-10-06 16:12:09 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:09 stephanpc mysqld[7170]: 2019-10-06 16:12:09 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:10 stephanpc mysqld[7170]: 2019-10-06 16:12:10 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:10 stephanpc mysqld[7170]: 2019-10-06 16:12:10 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:11 stephanpc mysqld[7170]: 2019-10-06 16:12:11 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:11 stephanpc mysqld[7170]: 2019-10-06 16:12:11 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:12 stephanpc mysqld[7170]: 2019-10-06 16:12:12 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:12 stephanpc mysqld[7170]: 2019-10-06 16:12:12 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:13 stephanpc mysqld[7170]: 2019-10-06 16:12:13 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:13 stephanpc mysqld[7170]: 2019-10-06 16:12:13 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:14 stephanpc mysqld[7170]: 2019-10-06 16:12:14 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:14 stephanpc mysqld[7170]: 2019-10-06 16:12:14 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:15 stephanpc mysqld[7170]: 2019-10-06 16:12:15 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:15 stephanpc mysqld[7170]: 2019-10-06 16:12:15 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:16 stephanpc mysqld[7170]: 2019-10-06 16:12:16 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:16 stephanpc mysqld[7170]: 2019-10-06 16:12:16 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:17 stephanpc mysqld[7170]: 2019-10-06 16:12:17 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:17 stephanpc mysqld[7170]: 2019-10-06 16:12:17 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:18 stephanpc mysqld[7170]: 2019-10-06 16:12:18 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:18 stephanpc mysqld[7170]: 2019-10-06 16:12:18 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:19 stephanpc mysqld[7170]: 2019-10-06 16:12:19 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:19 stephanpc mysqld[7170]: 2019-10-06 16:12:19 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:20 stephanpc mysqld[7170]: 2019-10-06 16:12:20 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:20 stephanpc mysqld[7170]: 2019-10-06 16:12:20 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:21 stephanpc mysqld[7170]: 2019-10-06 16:12:21 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:21 stephanpc mysqld[7170]: 2019-10-06 16:12:21 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:22 stephanpc mysqld[7170]: 2019-10-06 16:12:22 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:22 stephanpc mysqld[7170]: 2019-10-06 16:12:22 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:23 stephanpc mysqld[7170]: 2019-10-06 16:12:23 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:23 stephanpc mysqld[7170]: 2019-10-06 16:12:23 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:24 stephanpc mysqld[7170]: 2019-10-06 16:12:24 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:24 stephanpc mysqld[7170]: 2019-10-06 16:12:24 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:25 stephanpc mysqld[7170]: 2019-10-06 16:12:25 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:25 stephanpc mysqld[7170]: 2019-10-06 16:12:25 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:26 stephanpc mysqld[7170]: 2019-10-06 16:12:26 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:26 stephanpc mysqld[7170]: 2019-10-06 16:12:26 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:27 stephanpc mysqld[7170]: 2019-10-06 16:12:27 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:27 stephanpc mysqld[7170]: 2019-10-06 16:12:27 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:28 stephanpc mysqld[7170]: 2019-10-06 16:12:28 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:28 stephanpc mysqld[7170]: 2019-10-06 16:12:28 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:29 stephanpc mysqld[7170]: 2019-10-06 16:12:29 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:29 stephanpc mysqld[7170]: 2019-10-06 16:12:29 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:30 stephanpc mysqld[7170]: 2019-10-06 16:12:30 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:30 stephanpc mysqld[7170]: 2019-10-06 16:12:30 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:31 stephanpc mysqld[7170]: 2019-10-06 16:12:31 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:31 stephanpc mysqld[7170]: 2019-10-06 16:12:31 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:32 stephanpc mysqld[7170]: 2019-10-06 16:12:32 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:32 stephanpc mysqld[7170]: 2019-10-06 16:12:32 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:33 stephanpc mysqld[7170]: 2019-10-06 16:12:33 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:33 stephanpc mysqld[7170]: 2019-10-06 16:12:33 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:34 stephanpc mysqld[7170]: 2019-10-06 16:12:34 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:34 stephanpc mysqld[7170]: 2019-10-06 16:12:34 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:35 stephanpc mysqld[7170]: 2019-10-06 16:12:35 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:35 stephanpc mysqld[7170]: 2019-10-06 16:12:35 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:36 stephanpc mysqld[7170]: 2019-10-06 16:12:36 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:36 stephanpc mysqld[7170]: 2019-10-06 16:12:36 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:37 stephanpc mysqld[7170]: 2019-10-06 16:12:37 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:37 stephanpc mysqld[7170]: 2019-10-06 16:12:37 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [Note] InnoDB: Unable to open the first data file
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [ERROR] InnoDB: Operating system error number 11 in a file operation.
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [ERROR] InnoDB: Error number 11 means 'Resource temporarily unavailable'
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [ERROR] InnoDB: Cannot open datafile './ibdata1'
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [Note] InnoDB: Starting shutdown...
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [ERROR] Plugin 'InnoDB' init function returned error.
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [ERROR] Failed to initialize plugins.
oct. 06 16:12:38 stephanpc mysqld[7170]: 2019-10-06 16:12:38 0 [ERROR] Aborting
oct. 06 16:12:38 stephanpc systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
oct. 06 16:12:38 stephanpc systemd[1]: mariadb.service: Failed with result 'timeout'.
oct. 06 16:12:38 stephanpc systemd[1]: Failed to start MariaDB 10.4.8 database server.
stephan08
Daikyu
Messages : 93
Inscription : jeu. 19 nov. 2015, 23:18

Re: [MariaDB] Je n'arrive plus à me connecter

Message par stephan08 »

Finalement, j'arrive bien à lancer le service mariadb via systemctl start mysqld.

Par contre, le lancement de:
mysql -u root -p avec le mot de passe me donne:

Code : Tout sélectionner

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Comment réinitialiser le mot de passe?

Voila les dernières lignes de journalctl -b -u mariadb.service

Code : Tout sélectionner

oct. 07 13:01:04 stephanpc mysqld[510]: 2019-10-07 13:01:04 0 [Note] Added new Master_info '' to hash table
oct. 07 13:01:04 stephanpc mysqld[510]: 2019-10-07 13:01:04 0 [Note] /usr/bin/mysqld: ready for connections.
oct. 07 13:01:04 stephanpc mysqld[510]: Version: '10.4.8-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Arch Linux
oct. 07 13:01:04 stephanpc systemd[1]: Started MariaDB 10.4.8 database server.
oct. 07 13:29:18 stephanpc mysqld[510]: 2019-10-07 13:29:18 8 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
Merci par avance
Backtoback
yeomen
Messages : 263
Inscription : jeu. 26 avr. 2012, 23:33

Re: [MariaDB] Je n'arrive plus à me connecter

Message par Backtoback »

stephan08
Daikyu
Messages : 93
Inscription : jeu. 19 nov. 2015, 23:18

Re: [MariaDB] Je n'arrive plus à me connecter

Message par stephan08 »

Merci pour le lien. J'ai réussi à résoudre le problème.
Répondre