Ubuntu-fr

rhiwotar

Mysql/mariadb erreur timeout mariadb

Bonjour,

Je suis pas un foufou de linux, merci de ne pas juste me balancer des commandes, si vous pouviez les expliquer en une petite phrase pour que je comprenne, ce serai cool

Je viens d'installer mysql/mariadb sur mon serveur dans le but d'une migration de BDD, mysql a marché, mais apres l'install de mariaDB, plus rien, il me mets un message de timeout à chaque fois que je le relance

voila mon error.log de mysql

2020-01-09 11:39:13 140578185690240 [ERROR] Can't open shared library '/usr/lib/x86_64-linux-gnu/mariadb18/plugin/ha_connect.so' (errno: 0, failed to map segment from shared object)
2020-01-09 11:39:13 140578185690240 [ERROR] Couldn't load plugins from 'ha_connect.so'.
2020-01-09 11:39:13 140578185690240 [ERROR] Can't open shared library '/usr/lib/x86_64-linux-gnu/mariadb18/plugin/auth_gssapi.so' (errno: 0, failed to map segment from shared object)
2020-01-09 11:39:13 140578185690240 [ERROR] Couldn't load plugins from 'auth_gssapi.so'.
2020-01-09 11:39:13 140578185690240 [ERROR] Can't open shared library '/usr/lib/x86_64-linux-gnu/mariadb18/plugin/cracklib_password_check.so' (errno: 0, failed to map segment from shared object)
2020-01-09 11:39:13 140578185690240 [ERROR] Couldn't load plugins from 'cracklib_password_check.so'.
2020-01-09 11:39:13 140578185690240 [ERROR] Can't open shared library '/usr/lib/x86_64-linux-gnu/mariadb18/plugin/ha_oqgraph.so' (errno: 0, failed to map segment from shared object)
2020-01-09 11:39:13 140578185690240 [ERROR] Couldn't load plugins from 'ha_oqgraph.so'.
2020-01-09 11:39:13 140578185690240 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2020-01-09 11:39:13 140578185690240 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-01-09 11:39:13 140578185690240 [Note] InnoDB: The InnoDB memory heap is disabled
2020-01-09 11:39:13 140578185690240 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-01-09 11:39:13 140578185690240 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-01-09 11:39:13 140578185690240 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-01-09 11:39:13 140578185690240 [Note] InnoDB: Using Linux native AIO
2020-01-09 11:39:13 140578185690240 [Note] InnoDB: Using SSE crc32 instructions
2020-01-09 11:39:13 140578185690240 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-01-09 11:39:13 140578185690240 [Note] InnoDB: Completed initialization of buffer pool
2020-01-09 11:39:13 140578185690240 [Note] InnoDB: Highest supported file format is Barracuda.
2020-01-09 11:39:13 140578185690240 [Note] InnoDB: 128 rollback segment(s) are active.
2020-01-09 11:39:13 140578185690240 [Note] InnoDB: Waiting for purge to start
2020-01-09 11:39:13 140578185690240 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.45-86.1 started; log sequence number 1616857
2020-01-09 11:39:13 140577513404160 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-01-09 11:39:13 140578185690240 [Note] Plugin 'FEEDBACK' is disabled.
2020-01-09 11:39:13 140578185690240 [Note] Server socket created on IP: '127.0.0.1'.
2020-01-09 11:39:13 140578185690240 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.43-MariaDB-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Ubuntu 18.04
2020-01-09 11:40:43 140578185070336 [Note] /usr/sbin/mysqld: Normal shutdown
2020-01-09 11:40:43 140578185070336 [Note] Event Scheduler: Purging the queue. 0 events
2020-01-09 11:40:43 140577580508928 [Note] InnoDB: FTS optimize thread exiting.
2020-01-09 11:40:43 140578185070336 [Note] InnoDB: Starting shutdown...
2020-01-09 11:40:43 140578185070336 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-01-09 11:40:45 140578185070336 [Note] InnoDB: Shutdown completed; log sequence number 1616867
2020-01-09 11:40:45 140578185070336 [Note] /usr/sbin/mysqld: Shutdown complete

Si quelqu'un a une idée, je suis preneur.
Merci d'avance

bruno

Re : Mysql/mariadb erreur timeout mariadb

Bonjour,

Il faut commencer par nous indiquer la version d'Ubuntu utilisée et comment tu as procédé pour installer MariaDB.