Wheezy + Mysql -Server

[vandman]

Bonjour à tous,

J’ai un gros soucis avec mysql. Il a planté méchamment, Le fichier /var/run/mysqld/mysqld.sock n’existe plus.
j’ai lu qu’il etait possible que que mysql se soit arreté de manière anormale. j’ai essayé plein de truc mais ne suis arrivé à rien. Donc j’ai pris une solution barbare qui consiste à désinstaller tout les éléments de mysql et de les réinstaller.

La ca fait ch… car il ne veut plus s’installer.

Voici ce que j’ai pendant l’intall via synaptic.

[code]L’interface GTK a besoin de python-gtk2 et python-glade2.
Ces modules n’ont pas été trouvés. Retour à l’afficheur page à page.
L’erreur est :No module named glade
Préconfiguration des paquets…
Sélection du paquet mysql-common précédemment désélectionné.
(Lecture de la base de données… 115424 fichiers et répertoires déjà installés.)
Dépaquetage de mysql-common (à partir de …/mysql-common_5.5.28+dfsg-1_all.deb) …
Sélection du paquet libmysqlclient18:amd64 précédemment désélectionné.
Dépaquetage de libmysqlclient18:amd64 (à partir de …/libmysqlclient18_5.5.28+dfsg-1_amd64.deb) …
Sélection du paquet libdbd-mysql-perl précédemment désélectionné.
Dépaquetage de libdbd-mysql-perl (à partir de …/libdbd-mysql-perl_4.021-1+b1_amd64.deb) …
Sélection du paquet mysql-client-5.5 précédemment désélectionné.
Dépaquetage de mysql-client-5.5 (à partir de …/mysql-client-5.5_5.5.28+dfsg-1_amd64.deb) …
Sélection du paquet mysql-server-core-5.5 précédemment désélectionné.
Dépaquetage de mysql-server-core-5.5 (à partir de …/mysql-server-core-5.5_5.5.28+dfsg-1_amd64.deb) …
Traitement des actions différées (« triggers ») pour « man-db »…
Paramétrage de mysql-common (5.5.28+dfsg-1) …
Sélection du paquet mysql-server-5.5 précédemment désélectionné.
(Lecture de la base de données… 115610 fichiers et répertoires déjà installés.)
Dépaquetage de mysql-server-5.5 (à partir de …/mysql-server-5.5_5.5.28+dfsg-1_amd64.deb) …
Sélection du paquet mysql-server précédemment désélectionné.
Dépaquetage de mysql-server (à partir de …/mysql-server_5.5.28+dfsg-1_all.deb) …
Traitement des actions différées (« triggers ») pour « man-db »…
Paramétrage de libmysqlclient18:amd64 (5.5.28+dfsg-1) …
Paramétrage de libdbd-mysql-perl (4.021-1+b1) …
Paramétrage de mysql-client-5.5 (5.5.28+dfsg-1) …
Paramétrage de mysql-server-core-5.5 (5.5.28+dfsg-1) …
Paramétrage de mysql-server-5.5 (5.5.28+dfsg-1) …
[ ok ] Stopping MySQL database server: mysqld.
121211 17:47:22 [Note] Plugin ‘FEDERATED’ is disabled.
121211 17:47:22 InnoDB: The InnoDB memory heap is disabled
121211 17:47:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121211 17:47:22 InnoDB: Compressed tables use zlib 1.2.7
121211 17:47:22 InnoDB: Using Linux native AIO
121211 17:47:22 InnoDB: Initializing buffer pool, size = 128.0M
121211 17:47:22 InnoDB: Completed initialization of buffer pool
121211 17:47:22 InnoDB: highest supported file format is Barracuda.
121211 17:47:23 InnoDB: Waiting for the background threads to start
121211 17:47:24 InnoDB: 1.1.8 started; log sequence number 1595675
121211 17:47:24 InnoDB: Starting shutdown…
121211 17:47:24 InnoDB: Shutdown completed; log sequence number 1595675
insserv: warning: current start runlevel(s) (empty) of script mysql' overrides LSB defaults (2 3 4 5). insserv: warning: current stop runlevel(s) (1) of scriptmysql’ overrides LSB defaults (0 1 6).
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action “start” failed.
dpkg: erreur de traitement de mysql-server-5.5 (–configure) :
le sous-processus script post-installation installé a retourné une erreur de sortie d’état 1
dpkg: des problèmes de dépendances empêchent la configuration de mysql-server :
mysql-server dépend de mysql-server-5.5 ; cependant :
Le paquet mysql-server-5.5 n’est pas encore configuré.

dpkg: erreur de traitement de mysql-server (–configure) :
problèmes de dépendances - laissé non configuré
Des erreurs ont été rencontrées pendant l’exécution :
mysql-server-5.5
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
Échec de l’installation d’un paquet. Tentative de récupération :
Paramétrage de mysql-server-5.5 (5.5.28+dfsg-1) …
[ ok ] Stopping MySQL database server: mysqld.
insserv: warning: current start runlevel(s) (empty) of script mysql' overrides LSB defaults (2 3 4 5). insserv: warning: current stop runlevel(s) (1) of scriptmysql’ overrides LSB defaults (0 1 6).
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action “start” failed.
dpkg: erreur de traitement de mysql-server-5.5 (–configure) :
le sous-processus script post-installation installé a retourné une erreur de sortie d’état 1
dpkg: des problèmes de dépendances empêchent la configuration de mysql-server :
mysql-server dépend de mysql-server-5.5 ; cependant :
Le paquet mysql-server-5.5 n’est pas encore configuré.

dpkg: erreur de traitement de mysql-server (–configure) :
problèmes de dépendances - laissé non configuré
Des erreurs ont été rencontrées pendant l’exécution :
mysql-server-5.5
mysql-server
[/code]

Plus une petite fenetre m’indiquant:

E: mysql-server-5.5: le sous-processus script post-installation installé a retourné une erreur de sortie d'état 1 E: mysql-server: problèmes de dépendances - laissé non configuré

1Ere occurance dans les logs SYSLOG:

Dec 9 15:15:09 serveur2 /etc/init.d/mysql[3647]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Dec 9 15:15:09 serveur2 /etc/init.d/mysql[3647]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Dec 9 15:15:09 serveur2 /etc/init.d/mysql[3647]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Dec 9 15:15:09 serveur2 /etc/init.d/mysql[3647]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Dec 9 15:15:09 serveur2 /etc/init.d/mysql[3647]:
2eme occurance dans les logs SYSLOG:

[code]Dec 10 23:33:42 serveur2 HORDE: PHP ERROR: mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘/run/mysqld/mysqld.sock’ (2) [pid 11810 on line 136 of “/usr/share/php/Horde/Db/Adapter/Mysqli.php”]
Dec 10 23:33:42 serveur2 HORDE: Connect failed: (2002) Can’t connect to local MySQL server through socket ‘/run/mysqld/mysqld.sock’ (2) [pid 11810 on line 139 of “/usr/share/php/Horde/Db/Adapter/Mysqli.php”]

… => j’ai supprimé cette parti car elle se répète et que nous somme limité à 60000 caractères…

Dec 10 23:35:33 serveur2 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Dec 10 23:35:33 serveur2 mysqld: 121210 23:35:33 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 10 23:35:33 serveur2 mysqld: 121210 23:35:33 InnoDB: The InnoDB memory heap is disabled
Dec 10 23:35:33 serveur2 mysqld: 121210 23:35:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 10 23:35:33 serveur2 mysqld: 121210 23:35:33 InnoDB: Compressed tables use zlib 1.2.7
Dec 10 23:35:33 serveur2 mysqld: 121210 23:35:33 InnoDB: Using Linux native AIO
Dec 10 23:35:33 serveur2 mysqld: 121210 23:35:33 InnoDB: Initializing buffer pool, size = 128.0M
Dec 10 23:35:33 serveur2 mysqld: 121210 23:35:33 InnoDB: Completed initialization of buffer pool
Dec 10 23:35:33 serveur2 mysqld: 121210 23:35:33 InnoDB: highest supported file format is Barracuda.
Dec 10 23:35:33 serveur2 mysqld: 121210 23:35:33 InnoDB: Waiting for the background threads to start
Dec 10 23:35:34 serveur2 mysqld: 121210 23:35:34 InnoDB: 1.1.8 started; log sequence number 161172881
Dec 10 23:35:34 serveur2 mysqld: 121210 23:35:34 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306
Dec 10 23:35:34 serveur2 mysqld: 121210 23:35:34 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’;
Dec 10 23:35:34 serveur2 mysqld: 121210 23:35:34 [Note] Server socket created on IP: ‘127.0.0.1’.
Dec 10 23:35:34 serveur2 mysqld: 121210 23:35:34 [ERROR] Can’t start server: Bind on TCP/IP port: Cannot assign requested address
Dec 10 23:35:34 serveur2 mysqld: 121210 23:35:34 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Dec 10 23:35:34 serveur2 mysqld: 121210 23:35:34 [ERROR] Aborting
Dec 10 23:35:34 serveur2 mysqld:
Dec 10 23:35:34 serveur2 mysqld: 121210 23:35:34 InnoDB: Starting shutdown…
Dec 10 23:35:35 serveur2 mysqld: 121210 23:35:35 InnoDB: Shutdown completed; log sequence number 161172881
Dec 10 23:35:35 serveur2 mysqld: 121210 23:35:35 [Note] /usr/sbin/mysqld: Shutdown complete
Dec 10 23:35:35 serveur2 mysqld:
Dec 10 23:35:35 serveur2 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Dec 10 23:35:47 serveur2 /etc/init.d/mysql[27729]: 0 processes alive and ‘/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping’ resulted in
Dec 10 23:35:47 serveur2 /etc/init.d/mysql[27729]: #007/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
Dec 10 23:35:47 serveur2 /etc/init.d/mysql[27729]: error: 'Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)'
Dec 10 23:35:47 serveur2 /etc/init.d/mysql[27729]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
Dec 10 23:35:47 serveur2 /etc/init.d/mysql[27729]:
Dec 10 23:39:01 serveur2 /USR/SBIN/CRON[29032]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -depth -mindepth 1 -maxdepth 1 -type f -ignore_readdir_race -cmin +$(/usr/lib/php5/maxlifetime) ! -execdir fuser -s {} 2>/dev/null ; -delete)
Dec 10 23:51:35 serveur2 dbus[2208]: [system] Reloaded configuration
Dec 10 23:51:35 serveur2 dbus[2208]: [system] Reloaded configuration
Dec 10 23:51:45 serveur2 dbus[2208]: [system] Reloaded configuration
Dec 10 23:53:13 serveur2 kernel: [52176.130492] ip_tables: © 2000-2006 Netfilter Core Team
Dec 11 00:09:01 serveur2 /USR/SBIN/CRON[8857]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -depth -mindepth 1 -maxdepth 1 -type f -ignore_readdir_race -cmin +$(/usr/lib/php5/maxlifetime) ! -execdir fuser -s {} 2>/dev/null ; -delete)
Dec 11 00:17:01 serveur2 /USR/SBIN/CRON[11895]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Dec 11 00:26:23 serveur2 dbus[2208]: [system] Activating service name=‘org.freedesktop.PackageKit’ (using servicehelper)
Dec 11 00:26:23 serveur2 AptDaemon: INFO: Initializing daemon
Dec 11 00:26:23 serveur2 AptDaemon.PackageKit: INFO: Initializing PackageKit compat layer
Dec 11 00:26:23 serveur2 dbus[2208]: [system] Successfully activated service 'org.freedesktop.PackageKit’
Dec 11 00:32:23 serveur2 AptDaemon: INFO: Quitting due to inactivity
Dec 11 00:32:23 serveur2 AptDaemon: INFO: Quitting was requested
Dec 11 00:34:33 serveur2 dbus[2208]: [system] Activating service name=‘gufw.Daemon’ (using servicehelper)
Dec 11 00:34:33 serveur2 dbus[2208]: [system] Successfully activated service 'gufw.Daemon’
Dec 11 00:34:49 serveur2 kernel: [54671.750550] nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Dec 11 00:34:49 serveur2 kernel: [54671.819195] ip6_tables: © 2000-2006 Netfilter Core Team
Dec 11 00:39:01 serveur2 /USR/SBIN/CRON[20450]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -depth -mindepth 1 -maxdepth 1 -type f -ignore_readdir_race -cmin +$(/usr/lib/php5/maxlifetime) ! -execdir fuser -s {} 2>/dev/null ; -delete)
Dec 11 00:54:40 serveur2 dhclient: DHCPREQUEST on eth1 to 192.168.0.1 port 67
Dec 11 00:54:40 serveur2 dhclient: DHCPACK from 192.168.0.1
Dec 11 00:54:40 serveur2 dhclient: bound to 192.168.0.102 – renewal in 21137 seconds.
Dec 11 00:56:13 serveur2 mysqld_safe[27722]:

… => j’ai supprimé cette parti car elle se répète et que nous somme limité à 60000 caractères…

Dec 11 01:03:09 serveur2 mysqld_safe[6900]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Dec 11 01:03:09 serveur2 mysqld_safe[6900]: To do so, start the server, then issue the following commands:
Dec 11 01:03:09 serveur2 mysqld_safe[6900]:
Dec 11 01:03:09 serveur2 mysqld_safe[6900]: /usr/bin/mysqladmin -u root password 'new-password’
Dec 11 01:03:09 serveur2 mysqld_safe[6900]: /usr/bin/mysqladmin -u root -h serveur2 password 'new-password’
Dec 11 01:03:09 serveur2 mysqld_safe[6900]:
Dec 11 01:03:09 serveur2 mysqld_safe[6900]: Alternatively you can run:
Dec 11 01:03:09 serveur2 mysqld_safe[6900]: /usr/bin/mysql_secure_installation
Dec 11 01:03:09 serveur2 mysqld_safe[6900]:
Dec 11 01:03:09 serveur2 mysqld_safe[6900]: which will also give you the option of removing the test
Dec 11 01:03:09 serveur2 mysqld_safe[6900]: databases and anonymous user created by default. This is
Dec 11 01:03:09 serveur2 mysqld_safe[6900]: strongly recommended for production servers.
Dec 11 01:03:09 serveur2 mysqld_safe[6900]:
Dec 11 01:03:09 serveur2 mysqld_safe[6900]: See the manual for more instructions.
Dec 11 01:03:09 serveur2 mysqld_safe[6900]:
Dec 11 01:03:09 serveur2 mysqld_safe[6900]: Please report any problems with the /usr/scripts/mysqlbug script!
Dec 11 01:03:09 serveur2 mysqld_safe[6900]:
Dec 11 01:03:09 serveur2 mysqld_safe[6963]: 121211 1:03:09 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:03:09 serveur2 mysqld_safe[6963]: 121211 1:03:09 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:03:09 serveur2 mysqld_safe[6963]: 121211 1:03:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:03:09 serveur2 mysqld_safe[6963]: 121211 1:03:09 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:03:09 serveur2 mysqld_safe[6963]: 121211 1:03:09 InnoDB: Using Linux native AIO
Dec 11 01:03:09 serveur2 mysqld_safe[6963]: 121211 1:03:09 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:03:09 serveur2 mysqld_safe[6963]: 121211 1:03:09 InnoDB: Completed initialization of buffer pool
Dec 11 01:03:09 serveur2 mysqld_safe[6963]: 121211 1:03:09 InnoDB: highest supported file format is Barracuda.
Dec 11 01:03:09 serveur2 mysqld_safe[6963]: 121211 1:03:09 InnoDB: Waiting for the background threads to start
Dec 11 01:03:10 serveur2 mysqld_safe[6963]: 121211 1:03:10 InnoDB: 1.1.8 started; log sequence number 161172881
Dec 11 01:03:10 serveur2 mysqld_safe[6963]: 121211 1:03:10 InnoDB: Starting shutdown…
Dec 11 01:03:11 serveur2 mysqld_safe[6963]: 121211 1:03:11 InnoDB: Shutdown completed; log sequence number 161172881
Dec 11 01:03:11 serveur2 mysqld_safe[7003]: 121211 1:03:11 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:03:11 serveur2 mysqld_safe[7003]: 121211 1:03:11 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:03:11 serveur2 mysqld_safe[7003]: 121211 1:03:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:03:11 serveur2 mysqld_safe[7003]: 121211 1:03:11 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:03:11 serveur2 mysqld_safe[7003]: 121211 1:03:11 InnoDB: Using Linux native AIO
Dec 11 01:03:11 serveur2 mysqld_safe[7003]: 121211 1:03:11 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:03:11 serveur2 mysqld_safe[7003]: 121211 1:03:11 InnoDB: Completed initialization of buffer pool
Dec 11 01:03:11 serveur2 mysqld_safe[7003]: 121211 1:03:11 InnoDB: highest supported file format is Barracuda.
Dec 11 01:03:11 serveur2 mysqld_safe[7003]: 121211 1:03:11 InnoDB: Waiting for the background threads to start
Dec 11 01:03:12 serveur2 mysqld_safe[7003]: 121211 1:03:12 InnoDB: 1.1.8 started; log sequence number 161172881
Dec 11 01:03:12 serveur2 mysqld_safe[7003]: ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum(‘N’,‘Y’) CHARACTER SET utf8 NOT ’ at line 1
Dec 11 01:03:12 serveur2 mysqld_safe[7003]: 121211 1:03:12 [ERROR] Aborting
Dec 11 01:03:12 serveur2 mysqld_safe[7003]:
Dec 11 01:03:12 serveur2 mysqld_safe[7003]: 121211 1:03:12 InnoDB: Starting shutdown…
Dec 11 01:03:13 serveur2 mysqld_safe[7003]: 121211 1:03:13 InnoDB: Shutdown completed; log sequence number 161172881
Dec 11 01:03:13 serveur2 mysqld_safe[7003]: 121211 1:03:13 [Note] /usr/sbin/mysqld: Shutdown complete
Dec 11 01:03:13 serveur2 mysqld_safe[7003]:
Dec 11 01:03:13 serveur2 mysqld_safe[7043]: 121211 1:03:13 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:03:13 serveur2 mysqld_safe[7043]: 121211 1:03:13 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:03:13 serveur2 mysqld_safe[7043]: 121211 1:03:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:03:13 serveur2 mysqld_safe[7043]: 121211 1:03:13 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:03:13 serveur2 mysqld_safe[7043]: 121211 1:03:13 InnoDB: Using Linux native AIO
Dec 11 01:03:13 serveur2 mysqld_safe[7043]: 121211 1:03:13 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:03:13 serveur2 mysqld_safe[7043]: 121211 1:03:13 InnoDB: Completed initialization of buffer pool
Dec 11 01:03:13 serveur2 mysqld_safe[7043]: 121211 1:03:13 InnoDB: highest supported file format is Barracuda.
Dec 11 01:03:13 serveur2 mysqld_safe[7043]: 121211 1:03:13 InnoDB: Waiting for the background threads to start
Dec 11 01:03:14 serveur2 mysqld_safe[7043]: 121211 1:03:14 InnoDB: 1.1.8 started; log sequence number 161172881
Dec 11 01:03:14 serveur2 mysqld_safe[7043]: 121211 1:03:14 InnoDB: Starting shutdown…
Dec 11 01:03:15 serveur2 mysqld_safe[7043]: 121211 1:03:15 InnoDB: Shutdown completed; log sequence number 161172881
Dec 11 01:03:15 serveur2 mysqld_safe[7080]: 121211 1:03:15 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:03:15 serveur2 mysqld_safe[7080]: 121211 1:03:15 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:03:15 serveur2 mysqld_safe[7080]: 121211 1:03:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:03:15 serveur2 mysqld_safe[7080]: 121211 1:03:15 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:03:15 serveur2 mysqld_safe[7080]: 121211 1:03:15 InnoDB: Using Linux native AIO
Dec 11 01:03:15 serveur2 mysqld_safe[7080]: 121211 1:03:15 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:03:15 serveur2 mysqld_safe[7080]: 121211 1:03:15 InnoDB: Completed initialization of buffer pool
Dec 11 01:03:15 serveur2 mysqld_safe[7080]: 121211 1:03:15 InnoDB: highest supported file format is Barracuda.
Dec 11 01:03:15 serveur2 mysqld_safe[7080]: 121211 1:03:15 InnoDB: Waiting for the background threads to start
Dec 11 01:03:16 serveur2 mysqld_safe[7080]: 121211 1:03:16 InnoDB: 1.1.8 started; log sequence number 161172881
Dec 11 01:03:16 serveur2 mysqld_safe[7080]: ERROR: 1050 Table ‘plugin’ already exists
Dec 11 01:03:16 serveur2 mysqld_safe[7080]: 121211 1:03:16 [ERROR] Aborting
Dec 11 01:03:16 serveur2 mysqld_safe[7080]:
Dec 11 01:03:16 serveur2 mysqld_safe[7080]: 121211 1:03:16 InnoDB: Starting shutdown…
Dec 11 01:03:17 serveur2 mysqld_safe[7080]: 121211 1:03:17 InnoDB: Shutdown completed; log sequence number 161172881
Dec 11 01:03:17 serveur2 mysqld_safe[7080]: 121211 1:03:17 [Note] /usr/sbin/mysqld: Shutdown complete
Dec 11 01:03:17 serveur2 mysqld_safe[7080]:
Dec 11 01:03:18 serveur2 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Dec 11 01:03:18 serveur2 mysqld: 121211 1:03:18 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:03:18 serveur2 mysqld: 121211 1:03:18 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:03:18 serveur2 mysqld: 121211 1:03:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:03:18 serveur2 mysqld: 121211 1:03:18 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:03:18 serveur2 mysqld: 121211 1:03:18 InnoDB: Using Linux native AIO
Dec 11 01:03:18 serveur2 mysqld: 121211 1:03:18 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:03:18 serveur2 mysqld: 121211 1:03:18 InnoDB: Completed initialization of buffer pool
Dec 11 01:03:18 serveur2 mysqld: 121211 1:03:18 InnoDB: highest supported file format is Barracuda.
Dec 11 01:03:18 serveur2 mysqld: 121211 1:03:18 InnoDB: Waiting for the background threads to start
Dec 11 01:03:19 serveur2 mysqld: 121211 1:03:19 InnoDB: 1.1.8 started; log sequence number 161172881
Dec 11 01:03:19 serveur2 mysqld: 121211 1:03:19 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306
Dec 11 01:03:19 serveur2 mysqld: 121211 1:03:19 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’;
Dec 11 01:03:19 serveur2 mysqld: 121211 1:03:19 [Note] Server socket created on IP: ‘127.0.0.1’.
Dec 11 01:03:19 serveur2 mysqld: 121211 1:03:19 [ERROR] Can’t start server: Bind on TCP/IP port: Cannot assign requested address
Dec 11 01:03:19 serveur2 mysqld: 121211 1:03:19 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Dec 11 01:03:19 serveur2 mysqld: 121211 1:03:19 [ERROR] Aborting
Dec 11 01:03:19 serveur2 mysqld:
Dec 11 01:03:19 serveur2 mysqld: 121211 1:03:19 InnoDB: Starting shutdown…
Dec 11 01:03:20 serveur2 mysqld: 121211 1:03:20 InnoDB: Shutdown completed; log sequence number 161172881
Dec 11 01:03:20 serveur2 mysqld: 121211 1:03:20 [Note] /usr/sbin/mysqld: Shutdown complete
Dec 11 01:03:20 serveur2 mysqld:
Dec 11 01:03:20 serveur2 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Dec 11 01:03:32 serveur2 /etc/init.d/mysql[7775]: 0 processes alive and ‘/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping’ resulted in
Dec 11 01:03:32 serveur2 /etc/init.d/mysql[7775]: #007/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
Dec 11 01:03:32 serveur2 /etc/init.d/mysql[7775]: error: 'Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)'
Dec 11 01:03:32 serveur2 /etc/init.d/mysql[7775]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
Dec 11 01:03:32 serveur2 /etc/init.d/mysql[7775]:
Dec 11 01:09:01 serveur2 /USR/SBIN/CRON[9839]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -depth -mindepth 1 -maxdepth 1 -type f -ignore_readdir_race -cmin +$(/usr/lib/php5/maxlifetime) ! -execdir fuser -s {} 2>/dev/null ; -delete)
Dec 11 01:12:26 serveur2 avahi-daemon[2443]: Files changed, reloading.
Dec 11 01:17:01 serveur2 /USR/SBIN/CRON[15892]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Dec 11 01:20:05 serveur2 dbus[2208]: [system] Activating service name=‘com.ubuntu.SoftwareProperties’ (using servicehelper)
Dec 11 01:20:05 serveur2 dbus[2208]: [system] Successfully activated service 'com.ubuntu.SoftwareProperties’
Dec 11 01:24:24 serveur2 mysqld_safe[21519]:
Dec 11 01:24:24 serveur2 mysqld_safe[21519]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Dec 11 01:24:24 serveur2 mysqld_safe[21519]: To do so, start the server, then issue the following commands:
Dec 11 01:24:24 serveur2 mysqld_safe[21519]:
Dec 11 01:24:24 serveur2 mysqld_safe[21519]: /usr/bin/mysqladmin -u root password 'new-password’
Dec 11 01:24:24 serveur2 mysqld_safe[21519]: /usr/bin/mysqladmin -u root -h serveur2 password 'new-password’
Dec 11 01:24:24 serveur2 mysqld_safe[21519]:
Dec 11 01:24:24 serveur2 mysqld_safe[21519]: Alternatively you can run:
Dec 11 01:24:24 serveur2 mysqld_safe[21519]: /usr/bin/mysql_secure_installation
Dec 11 01:24:24 serveur2 mysqld_safe[21519]:
Dec 11 01:24:24 serveur2 mysqld_safe[21519]: which will also give you the option of removing the test
Dec 11 01:24:24 serveur2 mysqld_safe[21519]: databases and anonymous user created by default. This is
Dec 11 01:24:24 serveur2 mysqld_safe[21519]: strongly recommended for production servers.
Dec 11 01:24:24 serveur2 mysqld_safe[21519]:
Dec 11 01:24:24 serveur2 mysqld_safe[21519]: See the manual for more instructions.
Dec 11 01:24:24 serveur2 mysqld_safe[21519]:
Dec 11 01:24:24 serveur2 mysqld_safe[21519]: Please report any problems with the /usr/scripts/mysqlbug script!
Dec 11 01:24:24 serveur2 mysqld_safe[21519]:
Dec 11 01:24:24 serveur2 mysqld_safe[21585]: 121211 1:24:24 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:24:24 serveur2 mysqld_safe[21585]: 121211 1:24:24 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:24:24 serveur2 mysqld_safe[21585]: 121211 1:24:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:24:24 serveur2 mysqld_safe[21585]: 121211 1:24:24 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:24:24 serveur2 mysqld_safe[21585]: 121211 1:24:24 InnoDB: Using Linux native AIO
Dec 11 01:24:25 serveur2 mysqld_safe[21585]: 121211 1:24:24 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:24:25 serveur2 mysqld_safe[21585]: 121211 1:24:25 InnoDB: Completed initialization of buffer pool
Dec 11 01:24:25 serveur2 mysqld_safe[21585]: InnoDB: The first specified data file ./ibdata1 did not exist:
Dec 11 01:24:25 serveur2 mysqld_safe[21585]: InnoDB: a new database to be created!
Dec 11 01:24:25 serveur2 mysqld_safe[21585]: 121211 1:24:25 InnoDB: Setting file ./ibdata1 size to 10 MB
Dec 11 01:24:25 serveur2 mysqld_safe[21585]: InnoDB: Database physically writes the file full: wait…
Dec 11 01:24:25 serveur2 mysqld_safe[21585]: 121211 1:24:25 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
Dec 11 01:24:25 serveur2 mysqld_safe[21585]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
Dec 11 01:24:25 serveur2 mysqld_safe[21585]: InnoDB: Database physically writes the file full: wait…
Dec 11 01:24:25 serveur2 mysqld_safe[21585]: 121211 1:24:25 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
Dec 11 01:24:25 serveur2 mysqld_safe[21585]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
Dec 11 01:24:25 serveur2 mysqld_safe[21585]: InnoDB: Database physically writes the file full: wait…
Dec 11 01:24:25 serveur2 mysqld_safe[21585]: InnoDB: Doublewrite buffer not found: creating new
Dec 11 01:24:26 serveur2 mysqld_safe[21585]: InnoDB: Doublewrite buffer created
Dec 11 01:24:26 serveur2 mysqld_safe[21585]: InnoDB: 127 rollback segment(s) active.
Dec 11 01:24:26 serveur2 mysqld_safe[21585]: InnoDB: Creating foreign key constraint system tables
Dec 11 01:24:26 serveur2 mysqld_safe[21585]: InnoDB: Foreign key constraint system tables created
Dec 11 01:24:26 serveur2 mysqld_safe[21585]: 121211 1:24:26 InnoDB: Waiting for the background threads to start
Dec 11 01:24:27 serveur2 mysqld_safe[21585]: 121211 1:24:27 InnoDB: 1.1.8 started; log sequence number 0
Dec 11 01:24:27 serveur2 mysqld_safe[21585]: 121211 1:24:27 InnoDB: Starting shutdown…
Dec 11 01:24:28 serveur2 mysqld_safe[21585]: 121211 1:24:28 InnoDB: Shutdown completed; log sequence number 1595675
Dec 11 01:24:30 serveur2 mysqld_safe[21665]: 121211 1:24:30 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:24:30 serveur2 mysqld_safe[21665]: 121211 1:24:30 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:24:30 serveur2 mysqld_safe[21665]: 121211 1:24:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:24:30 serveur2 mysqld_safe[21665]: 121211 1:24:30 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:24:30 serveur2 mysqld_safe[21665]: 121211 1:24:30 InnoDB: Using Linux native AIO
Dec 11 01:24:30 serveur2 mysqld_safe[21665]: 121211 1:24:30 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:24:30 serveur2 mysqld_safe[21665]: 121211 1:24:30 InnoDB: Completed initialization of buffer pool
Dec 11 01:24:30 serveur2 mysqld_safe[21665]: 121211 1:24:30 InnoDB: highest supported file format is Barracuda.
Dec 11 01:24:30 serveur2 mysqld_safe[21665]: 121211 1:24:30 InnoDB: Waiting for the background threads to start
Dec 11 01:24:31 serveur2 mysqld_safe[21665]: 121211 1:24:31 InnoDB: 1.1.8 started; log sequence number 1595675
Dec 11 01:24:31 serveur2 mysqld_safe[21665]: ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum(‘N’,‘Y’) CHARACTER SET utf8 NOT ’ at line 1
Dec 11 01:24:31 serveur2 mysqld_safe[21665]: 121211 1:24:31 [ERROR] Aborting
Dec 11 01:24:31 serveur2 mysqld_safe[21665]:
Dec 11 01:24:31 serveur2 mysqld_safe[21665]: 121211 1:24:31 InnoDB: Starting shutdown…
Dec 11 01:24:32 serveur2 mysqld_safe[21665]: 121211 1:24:32 InnoDB: Shutdown completed; log sequence number 1595675
Dec 11 01:24:32 serveur2 mysqld_safe[21665]: 121211 1:24:32 [Note] /usr/sbin/mysqld: Shutdown complete
Dec 11 01:24:32 serveur2 mysqld_safe[21665]:
Dec 11 01:24:32 serveur2 mysqld_safe[21700]: 121211 1:24:32 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:24:32 serveur2 mysqld_safe[21700]: 121211 1:24:32 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:24:32 serveur2 mysqld_safe[21700]: 121211 1:24:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:24:32 serveur2 mysqld_safe[21700]: 121211 1:24:32 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:24:32 serveur2 mysqld_safe[21700]: 121211 1:24:32 InnoDB: Using Linux native AIO
Dec 11 01:24:32 serveur2 mysqld_safe[21700]: 121211 1:24:32 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:24:32 serveur2 mysqld_safe[21700]: 121211 1:24:32 InnoDB: Completed initialization of buffer pool
Dec 11 01:24:32 serveur2 mysqld_safe[21700]: 121211 1:24:32 InnoDB: highest supported file format is Barracuda.
Dec 11 01:24:32 serveur2 mysqld_safe[21700]: 121211 1:24:32 InnoDB: Waiting for the background threads to start
Dec 11 01:24:33 serveur2 mysqld_safe[21700]: 121211 1:24:33 InnoDB: 1.1.8 started; log sequence number 1595675
Dec 11 01:24:33 serveur2 mysqld_safe[21700]: 121211 1:24:33 InnoDB: Starting shutdown…
Dec 11 01:24:34 serveur2 mysqld_safe[21700]: 121211 1:24:34 InnoDB: Shutdown completed; log sequence number 1595675
Dec 11 01:24:34 serveur2 mysqld_safe[21734]: 121211 1:24:34 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:24:34 serveur2 mysqld_safe[21734]: 121211 1:24:34 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:24:34 serveur2 mysqld_safe[21734]: 121211 1:24:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:24:34 serveur2 mysqld_safe[21734]: 121211 1:24:34 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:24:34 serveur2 mysqld_safe[21734]: 121211 1:24:34 InnoDB: Using Linux native AIO
Dec 11 01:24:34 serveur2 mysqld_safe[21734]: 121211 1:24:34 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:24:34 serveur2 mysqld_safe[21734]: 121211 1:24:34 InnoDB: Completed initialization of buffer pool
Dec 11 01:24:34 serveur2 mysqld_safe[21734]: 121211 1:24:34 InnoDB: highest supported file format is Barracuda.
Dec 11 01:24:34 serveur2 mysqld_safe[21734]: 121211 1:24:34 InnoDB: Waiting for the background threads to start
Dec 11 01:24:35 serveur2 mysqld_safe[21734]: 121211 1:24:35 InnoDB: 1.1.8 started; log sequence number 1595675
Dec 11 01:24:35 serveur2 mysqld_safe[21734]: ERROR: 1050 Table ‘plugin’ already exists
Dec 11 01:24:35 serveur2 mysqld_safe[21734]: 121211 1:24:35 [ERROR] Aborting
Dec 11 01:24:35 serveur2 mysqld_safe[21734]:
Dec 11 01:24:35 serveur2 mysqld_safe[21734]: 121211 1:24:35 InnoDB: Starting shutdown…
Dec 11 01:24:36 serveur2 mysqld_safe[21734]: 121211 1:24:36 InnoDB: Shutdown completed; log sequence number 1595675
Dec 11 01:24:36 serveur2 mysqld_safe[21734]: 121211 1:24:36 [Note] /usr/sbin/mysqld: Shutdown complete
Dec 11 01:24:36 serveur2 mysqld_safe[21734]:
Dec 11 01:24:37 serveur2 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Dec 11 01:24:37 serveur2 mysqld: 121211 1:24:37 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:24:37 serveur2 mysqld: 121211 1:24:37 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:24:37 serveur2 mysqld: 121211 1:24:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:24:37 serveur2 mysqld: 121211 1:24:37 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:24:37 serveur2 mysqld: 121211 1:24:37 InnoDB: Using Linux native AIO
Dec 11 01:24:37 serveur2 mysqld: 121211 1:24:37 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:24:37 serveur2 mysqld: 121211 1:24:37 InnoDB: Completed initialization of buffer pool
Dec 11 01:24:37 serveur2 mysqld: 121211 1:24:37 InnoDB: highest supported file format is Barracuda.
Dec 11 01:24:37 serveur2 mysqld: 121211 1:24:37 InnoDB: Waiting for the background threads to start
Dec 11 01:24:38 serveur2 mysqld: 121211 1:24:38 InnoDB: 1.1.8 started; log sequence number 1595675
Dec 11 01:24:38 serveur2 mysqld: 121211 1:24:38 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306
Dec 11 01:24:38 serveur2 mysqld: 121211 1:24:38 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’;
Dec 11 01:24:38 serveur2 mysqld: 121211 1:24:38 [Note] Server socket created on IP: ‘127.0.0.1’.
Dec 11 01:24:38 serveur2 mysqld: 121211 1:24:38 [ERROR] Can’t start server: Bind on TCP/IP port: Cannot assign requested address
Dec 11 01:24:38 serveur2 mysqld: 121211 1:24:38 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Dec 11 01:24:38 serveur2 mysqld: 121211 1:24:38 [ERROR] Aborting
Dec 11 01:24:38 serveur2 mysqld:
Dec 11 01:24:38 serveur2 mysqld: 121211 1:24:38 InnoDB: Starting shutdown…
Dec 11 01:24:39 serveur2 mysqld: 121211 1:24:39 InnoDB: Shutdown completed; log sequence number 1595675
Dec 11 01:24:39 serveur2 mysqld: 121211 1:24:39 [Note] /usr/sbin/mysqld: Shutdown complete
Dec 11 01:24:39 serveur2 mysqld:
Dec 11 01:24:39 serveur2 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Dec 11 01:24:51 serveur2 /etc/init.d/mysql[22426]: 0 processes alive and ‘/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping’ resulted in
Dec 11 01:24:51 serveur2 /etc/init.d/mysql[22426]: #007/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
Dec 11 01:24:51 serveur2 /etc/init.d/mysql[22426]: error: 'Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)'
Dec 11 01:24:51 serveur2 /etc/init.d/mysql[22426]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
Dec 11 01:24:51 serveur2 /etc/init.d/mysql[22426]:
Dec 11 01:26:20 serveur2 mysqld_safe[23092]:
Dec 11 01:26:20 serveur2 mysqld_safe[23092]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Dec 11 01:26:20 serveur2 mysqld_safe[23092]: To do so, start the server, then issue the following commands:
Dec 11 01:26:20 serveur2 mysqld_safe[23092]:
Dec 11 01:26:20 serveur2 mysqld_safe[23092]: /usr/bin/mysqladmin -u root password 'new-password’
Dec 11 01:26:20 serveur2 mysqld_safe[23092]: /usr/bin/mysqladmin -u root -h serveur2 password 'new-password’
Dec 11 01:26:20 serveur2 mysqld_safe[23092]:
Dec 11 01:26:20 serveur2 mysqld_safe[23092]: Alternatively you can run:
Dec 11 01:26:20 serveur2 mysqld_safe[23092]: /usr/bin/mysql_secure_installation
Dec 11 01:26:20 serveur2 mysqld_safe[23092]:
Dec 11 01:26:20 serveur2 mysqld_safe[23092]: which will also give you the option of removing the test
Dec 11 01:26:20 serveur2 mysqld_safe[23092]: databases and anonymous user created by default. This is
Dec 11 01:26:20 serveur2 mysqld_safe[23092]: strongly recommended for production servers.
Dec 11 01:26:20 serveur2 mysqld_safe[23092]:
Dec 11 01:26:20 serveur2 mysqld_safe[23092]: See the manual for more instructions.
Dec 11 01:26:20 serveur2 mysqld_safe[23092]:
Dec 11 01:26:20 serveur2 mysqld_safe[23092]: Please report any problems with the /usr/scripts/mysqlbug script!
Dec 11 01:26:20 serveur2 mysqld_safe[23092]:
Dec 11 01:26:20 serveur2 mysqld_safe[23152]: 121211 1:26:20 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:26:20 serveur2 mysqld_safe[23152]: 121211 1:26:20 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:26:20 serveur2 mysqld_safe[23152]: 121211 1:26:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:26:20 serveur2 mysqld_safe[23152]: 121211 1:26:20 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:26:20 serveur2 mysqld_safe[23152]: 121211 1:26:20 InnoDB: Using Linux native AIO
Dec 11 01:26:20 serveur2 mysqld_safe[23152]: 121211 1:26:20 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:26:21 serveur2 mysqld_safe[23152]: 121211 1:26:20 InnoDB: Completed initialization of buffer pool
Dec 11 01:26:21 serveur2 mysqld_safe[23152]: 121211 1:26:21 InnoDB: highest supported file format is Barracuda.
Dec 11 01:26:21 serveur2 mysqld_safe[23152]: 121211 1:26:21 InnoDB: Waiting for the background threads to start
Dec 11 01:26:22 serveur2 mysqld_safe[23152]: 121211 1:26:22 InnoDB: 1.1.8 started; log sequence number 1595675
Dec 11 01:26:22 serveur2 mysqld_safe[23152]: 121211 1:26:22 InnoDB: Starting shutdown…
Dec 11 01:26:23 serveur2 mysqld_safe[23152]: 121211 1:26:23 InnoDB: Shutdown completed; log sequence number 1595675
Dec 11 01:26:23 serveur2 mysqld_safe[23209]: 121211 1:26:23 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:26:23 serveur2 mysqld_safe[23209]: 121211 1:26:23 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:26:23 serveur2 mysqld_safe[23209]: 121211 1:26:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:26:23 serveur2 mysqld_safe[23209]: 121211 1:26:23 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:26:23 serveur2 mysqld_safe[23209]: 121211 1:26:23 InnoDB: Using Linux native AIO
Dec 11 01:26:23 serveur2 mysqld_safe[23209]: 121211 1:26:23 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:26:23 serveur2 mysqld_safe[23209]: 121211 1:26:23 InnoDB: Completed initialization of buffer pool
Dec 11 01:26:23 serveur2 mysqld_safe[23209]: 121211 1:26:23 InnoDB: highest supported file format is Barracuda.
Dec 11 01:26:23 serveur2 mysqld_safe[23209]: 121211 1:26:23 InnoDB: Waiting for the background threads to start
Dec 11 01:26:23 serveur2 dbus[2208]: [system] Activating service name=‘org.freedesktop.PackageKit’ (using servicehelper)
Dec 11 01:26:23 serveur2 AptDaemon: INFO: Initializing daemon
Dec 11 01:26:23 serveur2 AptDaemon.PackageKit: INFO: Initializing PackageKit compat layer
Dec 11 01:26:23 serveur2 dbus[2208]: [system] Successfully activated service 'org.freedesktop.PackageKit’
Dec 11 01:26:24 serveur2 mysqld_safe[23209]: 121211 1:26:24 InnoDB: 1.1.8 started; log sequence number 1595675
Dec 11 01:26:24 serveur2 mysqld_safe[23209]: ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum(‘N’,‘Y’) CHARACTER SET utf8 NOT ’ at line 1
Dec 11 01:26:24 serveur2 mysqld_safe[23209]: 121211 1:26:24 [ERROR] Aborting
Dec 11 01:26:24 serveur2 mysqld_safe[23209]:
Dec 11 01:26:24 serveur2 mysqld_safe[23209]: 121211 1:26:24 InnoDB: Starting shutdown…
Dec 11 01:26:25 serveur2 mysqld_safe[23209]: 121211 1:26:25 InnoDB: Shutdown completed; log sequence number 1595675
Dec 11 01:26:25 serveur2 mysqld_safe[23209]: 121211 1:26:25 [Note] /usr/sbin/mysqld: Shutdown complete
Dec 11 01:26:25 serveur2 mysqld_safe[23209]:
Dec 11 01:26:25 serveur2 mysqld_safe[23250]: 121211 1:26:25 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:26:25 serveur2 mysqld_safe[23250]: 121211 1:26:25 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:26:25 serveur2 mysqld_safe[23250]: 121211 1:26:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:26:25 serveur2 mysqld_safe[23250]: 121211 1:26:25 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:26:25 serveur2 mysqld_safe[23250]: 121211 1:26:25 InnoDB: Using Linux native AIO
Dec 11 01:26:25 serveur2 mysqld_safe[23250]: 121211 1:26:25 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:26:25 serveur2 mysqld_safe[23250]: 121211 1:26:25 InnoDB: Completed initialization of buffer pool
Dec 11 01:26:25 serveur2 mysqld_safe[23250]: 121211 1:26:25 InnoDB: highest supported file format is Barracuda.
Dec 11 01:26:25 serveur2 mysqld_safe[23250]: 121211 1:26:25 InnoDB: Waiting for the background threads to start
Dec 11 01:26:26 serveur2 mysqld_safe[23250]: 121211 1:26:26 InnoDB: 1.1.8 started; log sequence number 1595675
Dec 11 01:26:26 serveur2 mysqld_safe[23250]: 121211 1:26:26 InnoDB: Starting shutdown…
Dec 11 01:26:27 serveur2 mysqld_safe[23250]: 121211 1:26:27 InnoDB: Shutdown completed; log sequence number 1595675
Dec 11 01:26:27 serveur2 mysqld_safe[23286]: 121211 1:26:27 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:26:27 serveur2 mysqld_safe[23286]: 121211 1:26:27 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:26:27 serveur2 mysqld_safe[23286]: 121211 1:26:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:26:27 serveur2 mysqld_safe[23286]: 121211 1:26:27 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:26:27 serveur2 mysqld_safe[23286]: 121211 1:26:27 InnoDB: Using Linux native AIO
Dec 11 01:26:27 serveur2 mysqld_safe[23286]: 121211 1:26:27 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:26:27 serveur2 mysqld_safe[23286]: 121211 1:26:27 InnoDB: Completed initialization of buffer pool
Dec 11 01:26:27 serveur2 mysqld_safe[23286]: 121211 1:26:27 InnoDB: highest supported file format is Barracuda.
Dec 11 01:26:27 serveur2 mysqld_safe[23286]: 121211 1:26:27 InnoDB: Waiting for the background threads to start
Dec 11 01:26:28 serveur2 mysqld_safe[23286]: 121211 1:26:28 InnoDB: 1.1.8 started; log sequence number 1595675
Dec 11 01:26:28 serveur2 mysqld_safe[23286]: ERROR: 1050 Table ‘plugin’ already exists
Dec 11 01:26:28 serveur2 mysqld_safe[23286]: 121211 1:26:28 [ERROR] Aborting
Dec 11 01:26:28 serveur2 mysqld_safe[23286]:
Dec 11 01:26:28 serveur2 mysqld_safe[23286]: 121211 1:26:28 InnoDB: Starting shutdown…
Dec 11 01:26:29 serveur2 mysqld_safe[23286]: 121211 1:26:29 InnoDB: Shutdown completed; log sequence number 1595675
Dec 11 01:26:29 serveur2 mysqld_safe[23286]: 121211 1:26:29 [Note] /usr/sbin/mysqld: Shutdown complete
Dec 11 01:26:29 serveur2 mysqld_safe[23286]:
Dec 11 01:26:29 serveur2 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Dec 11 01:26:29 serveur2 mysqld: 121211 1:26:29 [Note] Plugin ‘FEDERATED’ is disabled.
Dec 11 01:26:29 serveur2 mysqld: 121211 1:26:29 InnoDB: The InnoDB memory heap is disabled
Dec 11 01:26:29 serveur2 mysqld: 121211 1:26:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 11 01:26:29 serveur2 mysqld: 121211 1:26:29 InnoDB: Compressed tables use zlib 1.2.7
Dec 11 01:26:29 serveur2 mysqld: 121211 1:26:29 InnoDB: Using Linux native AIO
Dec 11 01:26:29 serveur2 mysqld: 121211 1:26:29 InnoDB: Initializing buffer pool, size = 128.0M
Dec 11 01:26:29 serveur2 mysqld: 121211 1:26:29 InnoDB: Completed initialization of buffer pool
Dec 11 01:26:29 serveur2 mysqld: 121211 1:26:29 InnoDB: highest supported file format is Barracuda.
Dec 11 01:26:29 serveur2 mysqld: 121211 1:26:29 InnoDB: Waiting for the background threads to start
Dec 11 01:26:30 serveur2 mysqld: 121211 1:26:30 InnoDB: 1.1.8 started; log sequence number 1595675
Dec 11 01:26:30 serveur2 mysqld: 121211 1:26:30 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306
Dec 11 01:26:30 serveur2 mysqld: 121211 1:26:30 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’;
Dec 11 01:26:30 serveur2 mysqld: 121211 1:26:30 [Note] Server socket created on IP: ‘127.0.0.1’.
Dec 11 01:26:30 serveur2 mysqld: 121211 1:26:30 [ERROR] Can’t start server: Bind on TCP/IP port: Cannot assign requested address
Dec 11 01:26:30 serveur2 mysqld: 121211 1:26:30 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Dec 11 01:26:30 serveur2 mysqld: 121211 1:26:30 [ERROR] Aborting
Dec 11 01:26:30 serveur2 mysqld:
Dec 11 01:26:30 serveur2 mysqld: 121211 1:26:30 InnoDB: Starting shutdown…
Dec 11 01:26:31 serveur2 mysqld: 121211 1:26:31 InnoDB: Shutdown completed; log sequence number 1595675
Dec 11 01:26:31 serveur2 mysqld: 121211 1:26:31 [Note] /usr/sbin/mysqld: Shutdown complete
Dec 11 01:26:31 serveur2 mysqld:
Dec 11 01:26:31 serveur2 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Dec 11 01:26:43 serveur2 /etc/init.d/mysql[23989]: 0 processes alive and ‘/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping’ resulted in
Dec 11 01:26:43 serveur2 /etc/init.d/mysql[23989]: #007/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
Dec 11 01:26:43 serveur2 /etc/init.d/mysql[23989]: error: 'Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)'
Dec 11 01:26:43 serveur2 /etc/init.d/mysql[23989]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
Dec 11 01:26:43 serveur2 /etc/init.d/mysql[23989]:
Dec 11 01:29:57 serveur2 shutdown[31971]: shutting down for system halt[/code]

Ici les log d’install

2012-12-11 17:46:59 install mysql-common:all <aucun> 5.5.28+dfsg-1 2012-12-11 17:46:59 status half-installed mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:46:59 status unpacked mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:46:59 status unpacked mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:46:59 install libmysqlclient18:amd64 <aucun> 5.5.28+dfsg-1 2012-12-11 17:46:59 status half-installed libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:47:00 status unpacked libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:47:00 status unpacked libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:47:00 install libdbd-mysql-perl:amd64 <aucun> 4.021-1+b1 2012-12-11 17:47:00 status half-installed libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:47:00 status triggers-pending man-db:amd64 2.6.2-1 2012-12-11 17:47:00 status half-installed libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:47:00 status unpacked libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:47:01 status unpacked libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:47:01 install mysql-client-5.5:amd64 <aucun> 5.5.28+dfsg-1 2012-12-11 17:47:01 status half-installed mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:01 status half-installed mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:02 status unpacked mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:02 status unpacked mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:02 install mysql-server-core-5.5:amd64 <aucun> 5.5.28+dfsg-1 2012-12-11 17:47:02 status half-installed mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:03 status half-installed mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:03 status unpacked mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:03 status unpacked mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:03 trigproc man-db:amd64 2.6.2-1 2.6.2-1 2012-12-11 17:47:03 status half-configured man-db:amd64 2.6.2-1 2012-12-11 17:47:07 status installed man-db:amd64 2.6.2-1 2012-12-11 17:47:08 startup packages configure 2012-12-11 17:47:08 configure mysql-common:all 5.5.28+dfsg-1 <aucun> 2012-12-11 17:47:08 status unpacked mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:47:08 status unpacked mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:47:08 status unpacked mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:47:08 status half-configured mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:47:09 status installed mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:47:09 startup archives unpack 2012-12-11 17:47:10 install mysql-server-5.5:amd64 <aucun> 5.5.28+dfsg-1 2012-12-11 17:47:10 status half-installed mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:12 status triggers-pending man-db:amd64 2.6.2-1 2012-12-11 17:47:13 status half-installed mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:13 status unpacked mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:13 status unpacked mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:13 install mysql-server:all <aucun> 5.5.28+dfsg-1 2012-12-11 17:47:13 status half-installed mysql-server:all 5.5.28+dfsg-1 2012-12-11 17:47:13 status unpacked mysql-server:all 5.5.28+dfsg-1 2012-12-11 17:47:13 status unpacked mysql-server:all 5.5.28+dfsg-1 2012-12-11 17:47:14 trigproc man-db:amd64 2.6.2-1 2.6.2-1 2012-12-11 17:47:14 status half-configured man-db:amd64 2.6.2-1 2012-12-11 17:47:14 status installed man-db:amd64 2.6.2-1 2012-12-11 17:47:15 startup packages configure 2012-12-11 17:47:15 configure libmysqlclient18:amd64 5.5.28+dfsg-1 <aucun> 2012-12-11 17:47:15 status unpacked libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:47:15 status half-configured libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:47:16 status installed libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:47:16 configure libdbd-mysql-perl:amd64 4.021-1+b1 <aucun> 2012-12-11 17:47:16 status unpacked libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:47:16 status half-configured libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:47:16 status installed libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:47:16 configure mysql-client-5.5:amd64 5.5.28+dfsg-1 <aucun> 2012-12-11 17:47:16 status unpacked mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:16 status half-configured mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:16 status installed mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:16 configure mysql-server-core-5.5:amd64 5.5.28+dfsg-1 <aucun> 2012-12-11 17:47:16 status unpacked mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:16 status half-configured mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:16 status installed mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:16 configure mysql-server-5.5:amd64 5.5.28+dfsg-1 <aucun> 2012-12-11 17:47:16 status unpacked mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:16 status unpacked mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:16 status unpacked mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:16 status unpacked mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:17 status unpacked mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:17 status unpacked mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:17 status unpacked mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:17 status unpacked mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:17 status half-configured mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:47:47 startup packages configure 2012-12-11 17:47:47 configure mysql-server-5.5:amd64 5.5.28+dfsg-1 <aucun> 2012-12-11 17:47:47 status half-configured mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:34 startup packages purge 2012-12-11 17:49:34 status unpacked mysql-server:all 5.5.28+dfsg-1 2012-12-11 17:49:34 remove mysql-server:all 5.5.28+dfsg-1 <aucun> 2012-12-11 17:49:34 status half-installed mysql-server:all 5.5.28+dfsg-1 2012-12-11 17:49:34 status config-files mysql-server:all 5.5.28+dfsg-1 2012-12-11 17:49:34 status config-files mysql-server:all 5.5.28+dfsg-1 2012-12-11 17:49:34 status config-files mysql-server:all 5.5.28+dfsg-1 2012-12-11 17:49:34 status not-installed mysql-server:all <aucun> 2012-12-11 17:49:34 status half-configured mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:34 remove mysql-server-5.5:amd64 5.5.28+dfsg-1 <aucun> 2012-12-11 17:49:34 status half-configured mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:35 status half-installed mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:35 status triggers-pending man-db:amd64 2.6.2-1 2012-12-11 17:49:35 status half-installed mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:36 status config-files mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:36 purge mysql-server-5.5:amd64 5.5.28+dfsg-1 <aucun> 2012-12-11 17:49:36 status config-files mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:36 status config-files mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:36 status config-files mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:37 status config-files mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:37 status config-files mysql-server-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:37 status not-installed mysql-server-5.5:amd64 <aucun> 2012-12-11 17:49:37 status installed mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:37 remove mysql-client-5.5:amd64 5.5.28+dfsg-1 <aucun> 2012-12-11 17:49:37 status half-configured mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:37 status half-installed mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:37 status half-installed mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:37 status config-files mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:37 status config-files mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:37 status config-files mysql-client-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:38 status not-installed mysql-client-5.5:amd64 <aucun> 2012-12-11 17:49:38 status installed libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:49:38 remove libdbd-mysql-perl:amd64 4.021-1+b1 <aucun> 2012-12-11 17:49:38 status half-configured libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:49:38 status half-installed libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:49:38 status half-installed libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:49:38 status config-files libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:49:38 status config-files libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:49:38 status config-files libdbd-mysql-perl:amd64 4.021-1+b1 2012-12-11 17:49:38 status not-installed libdbd-mysql-perl:amd64 <aucun> 2012-12-11 17:49:38 status installed libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:49:39 remove libmysqlclient18:amd64 5.5.28+dfsg-1 <aucun> 2012-12-11 17:49:39 status half-configured libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:49:39 status half-installed libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:49:39 status config-files libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:49:39 purge libmysqlclient18:amd64 5.5.28+dfsg-1 <aucun> 2012-12-11 17:49:39 status config-files libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:49:39 status config-files libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:49:39 status config-files libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:49:39 status config-files libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:49:39 status config-files libmysqlclient18:amd64 5.5.28+dfsg-1 2012-12-11 17:49:39 status not-installed libmysqlclient18:amd64 <aucun> 2012-12-11 17:49:39 status installed mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:49:40 remove mysql-common:all 5.5.28+dfsg-1 <aucun> 2012-12-11 17:49:40 status half-configured mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:49:40 status half-installed mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:49:40 status config-files mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:49:40 purge mysql-common:all 5.5.28+dfsg-1 <aucun> 2012-12-11 17:49:40 status config-files mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:49:40 status config-files mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:49:40 status config-files mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:49:40 status config-files mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:49:40 status config-files mysql-common:all 5.5.28+dfsg-1 2012-12-11 17:49:40 status not-installed mysql-common:all <aucun> 2012-12-11 17:49:40 status installed mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:40 remove mysql-server-core-5.5:amd64 5.5.28+dfsg-1 <aucun> 2012-12-11 17:49:40 status half-configured mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:41 status half-installed mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:41 status half-installed mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:41 status config-files mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:41 status config-files mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:41 status config-files mysql-server-core-5.5:amd64 5.5.28+dfsg-1 2012-12-11 17:49:41 status not-installed mysql-server-core-5.5:amd64 <aucun> 2012-12-11 17:49:41 trigproc man-db:amd64 2.6.2-1 <aucun> 2012-12-11 17:49:41 status half-configured man-db:amd64 2.6.2-1 2012-12-11 17:49:43 status installed man-db:amd64 2.6.2-1
Je précise que j’ai eu des comportement étrange lors de précédentes installes. Synaptic indiquait des problèmes de dépendances. J’installais les paquets les uns après les autres sans problèmes jusqu’à installer mysql. Ca a fonctionner un mois. maintenant, pour éviter les futurs désagrément, je voudrais pouvoir régler ce problème d’installation car j’ai l’impression que je suis le seul. j’ai tout de meme regardé un peux s’il y avait des problème dans wheezy, mais je n’ai rien trouvé.
Alors, comment je fait pour réistaller et refaire fonctionner Mysql?

Cordialement,
Vandman

[loreleil]

Salut,

Laisses tomber définitivement synaptic !

Suis donc ce fil récent Désinstallation propre de logiciels la solution à ton souci mysql s’y trouve!

Si tu rencontres un souci, fais en part …

[vandman]

J’ai essayé de suivre le fil, mais ca ne fonctionne pas.

Voici ce que j’ai après surpression de mysql:

p mysql-client - MySQL database client (metapackage depending on the latest version) p mysql-client-5.5 - Exécutables client pour la base de données MySQL p mysql-common - fichiers communs pour la base de données MySql, par exemple /etc/mysql/my.cnf p mysql-server - MySQL database server (metapackage depending on the latest version) p mysql-server-5.5 - serveur de bases de données MySQL - binaires et configuration v mysql-server-core - p mysql-server-core-5.5 - binaires du serveur de bases de données MySQL v virtual-mysql-client - v virtual-mysql-server -

Aucun paquet ne va être installé, mis à jour ou enlevé. 0 paquets mis à jour, 0 nouvellement installés, 0 à enlever et 0 non mis à jour. Il est nécessaire de télécharger 0 o d'archives. Après dépaquetage, 0 o seront utilisés.

Aucun paquet ne va être installé, mis à jour ou enlevé. 0 paquets mis à jour, 0 nouvellement installés, 0 à enlever et 0 non mis à jour. Il est nécessaire de télécharger 0 o d'archives. Après dépaquetage, 0 o seront utilisés. Charger/installer/enlever des paquets.

/var/cache/apt/archives/mysql-client_5.5.28+dfsg-1_all.deb /var/cache/apt/archives/mysql-server_5.5.28+dfsg-1_all.deb /var/cache/apt/archives/libmysqlclient18_5.5.28+dfsg-1_amd64.deb /var/cache/apt/archives/mysql-server-5.5_5.5.28+dfsg-1_amd64.deb /var/cache/apt/archives/mysql-server-core-5.5_5.5.28+dfsg-1_amd64.deb /var/cache/apt/archives/libdbd-mysql-perl_4.021-1+b1_amd64.deb /var/cache/apt/archives/libqt4-sql-mysql_4%3a4.8.2+dfsg-2_amd64.deb /var/cache/apt/archives/mysql-common_5.5.28+dfsg-1_all.deb /var/cache/apt/archives/php5-mysql_5.4.4-10_amd64.deb /var/cache/apt/archives/php5-mysqlnd_5.4.4-10_amd64.deb /var/cache/apt/archives/mysql-client-5.5_5.5.28+dfsg-1_amd64.deb /var/tmp/phpmyadmin.phpmyadmin.2012-11-27-00.03.mysql.pP9U6s /usr/share/nmap/nselib/mysql.lua /usr/share/nmap/nselib/data/mysql-cis.audit /usr/share/nmap/scripts/mysql-brute.nse /usr/share/nmap/scripts/mysql-users.nse /usr/share/nmap/scripts/mysql-audit.nse /usr/share/nmap/scripts/mysql-databases.nse /usr/share/nmap/scripts/mysql-info.nse /usr/share/nmap/scripts/mysql-variables.nse /usr/share/nmap/scripts/mysql-empty-password.nse /usr/share/php/test/MDB2/tests/MDB2_nonstandard_mysqli.php /usr/share/php/test/MDB2/tests/MDB2_nonstandard_mysql.php /usr/share/php/DB/mysqli.php /usr/share/php/DB/mysql.php /usr/share/doc/php5-common/PEAR/Horde_Rdo/examples/clotho.mysql.sql /usr/share/doc/php5-common/PEAR/Horde_Rdo/examples/users.mysql.sql /usr/share/kde4/apps/katepart/syntax/sql-mysql.xml /usr/share/app-install/icons/mysql-workbench.xpm /usr/share/app-install/icons/gmysqlcc-32.png /usr/share/app-install/desktop/gmysqlcc.desktop /usr/share/bash-completion/completions/mysql /usr/share/bash-completion/completions/mysqladmin /usr/include/php5/ext/mysqli /usr/include/php5/ext/mysqli/php_mysqli_structs.h /usr/lib/libreoffice/program/libmysqllo.so /root/.mysql_history /root/.local/share/Trash/files/mysql.5 /root/.local/share/Trash/files/mysql /root/.local/share/Trash/files/mysql/mysql /root/.local/share/Trash/files/K02mysql.2 /root/.local/share/Trash/files/S18mysql.4 /root/.local/share/Trash/files/S18mysql.2 /root/.local/share/Trash/files/mysql.4 /root/.local/share/Trash/files/mysql.3 /root/.local/share/Trash/files/S18mysql.3 /root/.local/share/Trash/files/K02mysql /root/.local/share/Trash/files/S18mysql /root/.local/share/Trash/files/mysql.2 /root/.local/share/Trash/files/mysql_upgrade_info /root/.local/share/Trash/info/mysql.2.trashinfo /root/.local/share/Trash/info/K02mysql.trashinfo /root/.local/share/Trash/info/mysql.4.trashinfo /root/.local/share/Trash/info/S18mysql.trashinfo /root/.local/share/Trash/info/mysql_upgrade_info.trashinfo /root/.local/share/Trash/info/S18mysql.3.trashinfo /root/.local/share/Trash/info/mysql.3.trashinfo /root/.local/share/Trash/info/S18mysql.4.trashinfo /root/.local/share/Trash/info/K02mysql.2.trashinfo /root/.local/share/Trash/info/S18mysql.2.trashinfo /root/.local/share/Trash/info/mysql.5.trashinfo /root/.local/share/Trash/info/mysql.trashinfo
Pas de référence trouvé pour mysql-server et mysql-client dans /var/lib/dpkg/status
Une fois propre, j’installe…

[code]Lecture des listes de paquets… Fait
Construction de l’arbre des dépendances
Lecture des informations d’état… Fait
Les paquets supplémentaires suivants seront installés :
libdbd-mysql-perl libmysqlclient18 mysql-client-5.5 mysql-common mysql-server-5.5 mysql-server-core-5.5
Paquets suggérés :
libterm-readkey-perl tinyca
Les NOUVEAUX paquets suivants seront installés :
libdbd-mysql-perl libmysqlclient18 mysql-client mysql-client-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5
0 mis à jour, 8 nouvellement installés, 0 à enlever et 0 non mis à jour.
Il est nécessaire de prendre 0 o/8 433 ko dans les archives.
Après cette opération, 94,3 Mo d’espace disque supplémentaires seront utilisés.
Souhaitez-vous continuer [O/n] ? o
Préconfiguration des paquets…
Sélection du paquet mysql-common précédemment désélectionné.
(Lecture de la base de données… 115424 fichiers et répertoires déjà installés.)
Dépaquetage de mysql-common (à partir de …/mysql-common_5.5.28+dfsg-1_all.deb) …
Sélection du paquet libmysqlclient18:amd64 précédemment désélectionné.
Dépaquetage de libmysqlclient18:amd64 (à partir de …/libmysqlclient18_5.5.28+dfsg-1_amd64.deb) …
Sélection du paquet libdbd-mysql-perl précédemment désélectionné.
Dépaquetage de libdbd-mysql-perl (à partir de …/libdbd-mysql-perl_4.021-1+b1_amd64.deb) …
Sélection du paquet mysql-client-5.5 précédemment désélectionné.
Dépaquetage de mysql-client-5.5 (à partir de …/mysql-client-5.5_5.5.28+dfsg-1_amd64.deb) …
Sélection du paquet mysql-server-core-5.5 précédemment désélectionné.
Dépaquetage de mysql-server-core-5.5 (à partir de …/mysql-server-core-5.5_5.5.28+dfsg-1_amd64.deb) …
Traitement des actions différées (« triggers ») pour « man-db »…
Paramétrage de mysql-common (5.5.28+dfsg-1) …
Sélection du paquet mysql-server-5.5 précédemment désélectionné.
(Lecture de la base de données… 115610 fichiers et répertoires déjà installés.)
Dépaquetage de mysql-server-5.5 (à partir de …/mysql-server-5.5_5.5.28+dfsg-1_amd64.deb) …
Sélection du paquet mysql-client précédemment désélectionné.
Dépaquetage de mysql-client (à partir de …/mysql-client_5.5.28+dfsg-1_all.deb) …
Sélection du paquet mysql-server précédemment désélectionné.
Dépaquetage de mysql-server (à partir de …/mysql-server_5.5.28+dfsg-1_all.deb) …
Traitement des actions différées (« triggers ») pour « man-db »…
Paramétrage de libmysqlclient18:amd64 (5.5.28+dfsg-1) …
Paramétrage de libdbd-mysql-perl (4.021-1+b1) …
Paramétrage de mysql-client-5.5 (5.5.28+dfsg-1) …
Paramétrage de mysql-server-core-5.5 (5.5.28+dfsg-1) …
Paramétrage de mysql-server-5.5 (5.5.28+dfsg-1) …
[ ok ] Stopping MySQL database server: mysqld.
121213 16:28:34 [Note] Plugin ‘FEDERATED’ is disabled.
121213 16:28:34 InnoDB: The InnoDB memory heap is disabled
121213 16:28:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121213 16:28:34 InnoDB: Compressed tables use zlib 1.2.7
121213 16:28:34 InnoDB: Using Linux native AIO
121213 16:28:34 InnoDB: Initializing buffer pool, size = 128.0M
121213 16:28:34 InnoDB: Completed initialization of buffer pool
121213 16:28:34 InnoDB: highest supported file format is Barracuda.
121213 16:28:35 InnoDB: Waiting for the background threads to start
121213 16:28:36 InnoDB: 1.1.8 started; log sequence number 1595675
121213 16:28:36 InnoDB: Starting shutdown…
121213 16:28:37 InnoDB: Shutdown completed; log sequence number 1595675
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action “start” failed.
dpkg: erreur de traitement de mysql-server-5.5 (–configure) :
le sous-processus script post-installation installé a retourné une erreur de sortie d’état 1
Paramétrage de mysql-client (5.5.28+dfsg-1) …
dpkg: des problèmes de dépendances empêchent la configuration de mysql-server :
mysql-server dépend de mysql-server-5.5 ; cependant :
Le paquet mysql-server-5.5 n’est pas encore configuré.

dpkg: erreur de traitement de mysql-server (–configure) :
problèmes de dépendances - laissé non configuré
Des erreurs ont été rencontrées pendant l’exécution :
mysql-server-5.5
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
[/code]
Je ne comprends pas bien pourquoi pendant l’installe, après les paramétrage, mysql a besoin de s’arrêter avant de démarrer?
Comment je fais pour repartir de bon pied. Je pense qu’il me manque encore des éléments???

merci d’avance.

[fluo]

[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.

=> Peut-être que le fichier /usr/lib/mysql/ibdata1 a été corrompu à la suite une interruption accidentelle du daemon mysqld.

Donc, essaye en root (on ne sait jamais) :

1. tu supprime le fichier ibdata1 (en renommant le fichier pour le sauvegarder) :

cd /usr/lib/mysql/
mv -a ibdata1 ibdata1.bak

2. tu restart mysql :

/etc/init.d/mysql restart

Et si le restart marche, le fichier /usr/lib/mysql/ibdata1 a été regénéré, et mysql remarche.

[vandman]

Sauf erreur, je n’ai pas trouvé ibdata1 dans /usr/lib/mysql/ mais dans /var/lib/mysql/

cd /var/lib/mysql/ cp -a ibdata1 ibdata1.bak /etc/init.d/mysql restart

[ ok ] Stopping MySQL database server: mysqld. [FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

Pas de chance???

[fluo]

Sauf erreur, je n’ai pas trouvé ibdata1 dans /usr/lib/mysql/ mais dans /var/lib/mysql/

=> excuse moi, j’ai été trop vite, c’est bien dans /var/lib/mysql/.

[quote=“vandman”]cd /var/lib/mysql/
cp -a ibdata1 ibdata1.bak
/etc/init.d/mysql restart[/quote]
=>Excuse moi, tu dois supprimer aussi l’original après l’avoir copier en .bak :

Donc

cp -a ibdata1 ibdata1.bak
rm -f ibdata1
/etc/init.d/mysql restart

[vandman]

même résultat qu’avant avec les correction???

[fluo]

Après le restart de mysql, colle ici le syslog, mysql.err, et mysql.log

[vandman]

je suis reparti de 0.

Il n’y a rien dans /var/log/mysql.log et /var/log/mysql.err

Voila le log:

ec 13 18:24:56 serveur2 mysqld_safe[15585]: Dec 13 18:24:56 serveur2 mysqld_safe[15585]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Dec 13 18:24:56 serveur2 mysqld_safe[15585]: To do so, start the server, then issue the following commands: Dec 13 18:24:56 serveur2 mysqld_safe[15585]: Dec 13 18:24:56 serveur2 mysqld_safe[15585]: /usr/bin/mysqladmin -u root password 'new-password' Dec 13 18:24:56 serveur2 mysqld_safe[15585]: /usr/bin/mysqladmin -u root -h serveur2 password 'new-password' Dec 13 18:24:56 serveur2 mysqld_safe[15585]: Dec 13 18:24:56 serveur2 mysqld_safe[15585]: Alternatively you can run: Dec 13 18:24:56 serveur2 mysqld_safe[15585]: /usr/bin/mysql_secure_installation Dec 13 18:24:56 serveur2 mysqld_safe[15585]: Dec 13 18:24:56 serveur2 mysqld_safe[15585]: which will also give you the option of removing the test Dec 13 18:24:56 serveur2 mysqld_safe[15585]: databases and anonymous user created by default. This is Dec 13 18:24:56 serveur2 mysqld_safe[15585]: strongly recommended for production servers. Dec 13 18:24:56 serveur2 mysqld_safe[15585]: Dec 13 18:24:56 serveur2 mysqld_safe[15585]: See the manual for more instructions. Dec 13 18:24:56 serveur2 mysqld_safe[15585]: Dec 13 18:24:56 serveur2 mysqld_safe[15585]: Please report any problems with the /usr/scripts/mysqlbug script! Dec 13 18:24:56 serveur2 mysqld_safe[15585]: Dec 13 18:24:56 serveur2 mysqld_safe[15643]: 121213 18:24:56 [Note] Plugin 'FEDERATED' is disabled. Dec 13 18:24:56 serveur2 mysqld_safe[15643]: 121213 18:24:56 InnoDB: The InnoDB memory heap is disabled Dec 13 18:24:56 serveur2 mysqld_safe[15643]: 121213 18:24:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins Dec 13 18:24:56 serveur2 mysqld_safe[15643]: 121213 18:24:56 InnoDB: Compressed tables use zlib 1.2.7 Dec 13 18:24:56 serveur2 mysqld_safe[15643]: 121213 18:24:56 InnoDB: Using Linux native AIO Dec 13 18:24:56 serveur2 mysqld_safe[15643]: 121213 18:24:56 InnoDB: Initializing buffer pool, size = 128.0M Dec 13 18:24:56 serveur2 mysqld_safe[15643]: 121213 18:24:56 InnoDB: Completed initialization of buffer pool Dec 13 18:24:56 serveur2 mysqld_safe[15643]: 121213 18:24:56 InnoDB: highest supported file format is Barracuda. Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: The log sequence number in ibdata files does not match Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: the log sequence number in the ib_logfiles! Dec 13 18:24:56 serveur2 mysqld_safe[15643]: 121213 18:24:56 InnoDB: Database was not shut down normally! Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: Starting crash recovery. Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: Reading tablespace information from the .ibd files... Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: Restoring possible half-written data pages from the doublewrite Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: buffer... Dec 13 18:24:56 serveur2 mysqld_safe[15643]: 121213 18:24:56 InnoDB: Assertion failure in thread 139637911537440 in file fsp0fsp.c line 2102 Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: Failing assertion: inode Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: We intentionally generate a memory trap. Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: Submit a detailed bug report to http://bugs.mysql.com. Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: If you get repeated assertion failures or crashes, even Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: immediately after the mysqld startup, there may be Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: corruption in the InnoDB tablespace. Please refer to Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html Dec 13 18:24:56 serveur2 mysqld_safe[15643]: InnoDB: about forcing recovery. Dec 13 18:24:56 serveur2 mysqld_safe[15643]: 17:24:56 UTC - mysqld got signal 6 ; Dec 13 18:24:56 serveur2 mysqld_safe[15643]: This could be because you hit a bug. It is also possible that this binary Dec 13 18:24:56 serveur2 mysqld_safe[15643]: or one of the libraries it was linked against is corrupt, improperly built, Dec 13 18:24:56 serveur2 mysqld_safe[15643]: or misconfigured. This error can also be caused by malfunctioning hardware. Dec 13 18:24:56 serveur2 mysqld_safe[15643]: We will try our best to scrape up some info that will hopefully help Dec 13 18:24:56 serveur2 mysqld_safe[15643]: diagnose the problem, but since we have already crashed, Dec 13 18:24:56 serveur2 mysqld_safe[15643]: something is definitely wrong and this may fail. Dec 13 18:24:56 serveur2 mysqld_safe[15643]: Dec 13 18:24:56 serveur2 mysqld_safe[15643]: key_buffer_size=16777216 Dec 13 18:24:56 serveur2 mysqld_safe[15643]: read_buffer_size=131072 Dec 13 18:24:56 serveur2 mysqld_safe[15643]: max_used_connections=0 Dec 13 18:24:56 serveur2 mysqld_safe[15643]: max_threads=151 Dec 13 18:24:56 serveur2 mysqld_safe[15643]: thread_count=0 Dec 13 18:24:56 serveur2 mysqld_safe[15643]: connection_count=0 Dec 13 18:24:56 serveur2 mysqld_safe[15643]: It is possible that mysqld could use up to Dec 13 18:24:56 serveur2 mysqld_safe[15643]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346681 K bytes of memory Dec 13 18:24:56 serveur2 mysqld_safe[15643]: Hope that's ok; if not, decrease some variables in the equation. Dec 13 18:24:56 serveur2 mysqld_safe[15643]: Dec 13 18:24:56 serveur2 mysqld_safe[15643]: Thread pointer: 0x0 Dec 13 18:24:56 serveur2 mysqld_safe[15643]: Attempting backtrace. You can use the following information to find out Dec 13 18:24:56 serveur2 mysqld_safe[15643]: where mysqld died. If you see no messages after this, something went Dec 13 18:24:56 serveur2 mysqld_safe[15643]: terribly wrong... Dec 13 18:24:56 serveur2 mysqld_safe[15643]: stack_bottom = 0 thread_stack 0x30000 Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(my_print_stacktrace+0x29)[0x7efffc724c39] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(handle_fatal_signal+0x3d8)[0x7efffc60e388] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /lib/x86_64-linux-gnu/libpthread.so.0(+0xf030)[0x7efffbdc4030] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35)[0x7efffa657475] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180)[0x7efffa65a6f0] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(+0x630490)[0x7efffc823490] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(+0x635dfb)[0x7efffc828dfb] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(+0x641dc7)[0x7efffc834dc7] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(+0x60e5f5)[0x7efffc8015f5] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(+0x5bee43)[0x7efffc7b1e43] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(+0x58b69f)[0x7efffc77e69f] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x41)[0x7efffc610641] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(+0x32cd57)[0x7efffc51fd57] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(_Z11plugin_initPiPPci+0xa43)[0x7efffc523123] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(+0x2b11c5)[0x7efffc4a41c5] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x45b)[0x7efffc4a8f0b] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd)[0x7efffa643ead] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: /usr/sbin/mysqld(+0x2ad649)[0x7efffc4a0649] Dec 13 18:24:56 serveur2 mysqld_safe[15643]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Dec 13 18:24:56 serveur2 mysqld_safe[15643]: information that should help you find out what is causing the crash. Dec 13 18:24:56 serveur2 mysqld_safe[15661]: 121213 18:24:56 [Note] Plugin 'FEDERATED' is disabled. Dec 13 18:24:56 serveur2 mysqld_safe[15661]: 121213 18:24:56 InnoDB: The InnoDB memory heap is disabled Dec 13 18:24:56 serveur2 mysqld_safe[15661]: 121213 18:24:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins Dec 13 18:24:56 serveur2 mysqld_safe[15661]: 121213 18:24:56 InnoDB: Compressed tables use zlib 1.2.7 Dec 13 18:24:56 serveur2 mysqld_safe[15661]: 121213 18:24:56 InnoDB: Using Linux native AIO Dec 13 18:24:56 serveur2 mysqld_safe[15661]: 121213 18:24:56 InnoDB: Initializing buffer pool, size = 128.0M Dec 13 18:24:56 serveur2 mysqld_safe[15661]: 121213 18:24:56 InnoDB: Completed initialization of buffer pool Dec 13 18:24:56 serveur2 mysqld_safe[15661]: 121213 18:24:56 InnoDB: highest supported file format is Barracuda. Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: The log sequence number in ibdata files does not match Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: the log sequence number in the ib_logfiles! Dec 13 18:24:56 serveur2 mysqld_safe[15661]: 121213 18:24:56 InnoDB: Database was not shut down normally! Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: Starting crash recovery. Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: Reading tablespace information from the .ibd files... Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: Restoring possible half-written data pages from the doublewrite Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: buffer... Dec 13 18:24:56 serveur2 mysqld_safe[15661]: 121213 18:24:56 InnoDB: Assertion failure in thread 139914703202080 in file fsp0fsp.c line 2102 Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: Failing assertion: inode Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: We intentionally generate a memory trap. Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: Submit a detailed bug report to http://bugs.mysql.com. Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: If you get repeated assertion failures or crashes, even Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: immediately after the mysqld startup, there may be Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: corruption in the InnoDB tablespace. Please refer to Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html Dec 13 18:24:56 serveur2 mysqld_safe[15661]: InnoDB: about forcing recovery. Dec 13 18:24:56 serveur2 mysqld_safe[15661]: 17:24:56 UTC - mysqld got signal 6 ; Dec 13 18:24:56 serveur2 mysqld_safe[15661]: This could be because you hit a bug. It is also possible that this binary Dec 13 18:24:56 serveur2 mysqld_safe[15661]: or one of the libraries it was linked against is corrupt, improperly built, Dec 13 18:24:56 serveur2 mysqld_safe[15661]: or misconfigured. This error can also be caused by malfunctioning hardware. Dec 13 18:24:56 serveur2 mysqld_safe[15661]: We will try our best to scrape up some info that will hopefully help Dec 13 18:24:56 serveur2 mysqld_safe[15661]: diagnose the problem, but since we have already crashed, Dec 13 18:24:56 serveur2 mysqld_safe[15661]: something is definitely wrong and this may fail. Dec 13 18:24:56 serveur2 mysqld_safe[15661]: Dec 13 18:24:56 serveur2 mysqld_safe[15661]: key_buffer_size=16777216 Dec 13 18:24:56 serveur2 mysqld_safe[15661]: read_buffer_size=131072 Dec 13 18:24:56 serveur2 mysqld_safe[15661]: max_used_connections=0 Dec 13 18:24:56 serveur2 mysqld_safe[15661]: max_threads=151 Dec 13 18:24:56 serveur2 mysqld_safe[15661]: thread_count=0 Dec 13 18:24:56 serveur2 mysqld_safe[15661]: connection_count=0 Dec 13 18:24:56 serveur2 mysqld_safe[15661]: It is possible that mysqld could use up to Dec 13 18:24:56 serveur2 mysqld_safe[15661]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346681 K bytes of memory Dec 13 18:24:56 serveur2 mysqld_safe[15661]: Hope that's ok; if not, decrease some variables in the equation. Dec 13 18:24:56 serveur2 mysqld_safe[15661]: Dec 13 18:24:56 serveur2 mysqld_safe[15661]: Thread pointer: 0x0 Dec 13 18:24:56 serveur2 mysqld_safe[15661]: Attempting backtrace. You can use the following information to find out Dec 13 18:24:56 serveur2 mysqld_safe[15661]: where mysqld died. If you see no messages after this, something went Dec 13 18:24:56 serveur2 mysqld_safe[15661]: terribly wrong... Dec 13 18:24:56 serveur2 mysqld_safe[15661]: stack_bottom = 0 thread_stack 0x30000 Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(my_print_stacktrace+0x29)[0x7f406e83ec39] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(handle_fatal_signal+0x3d8)[0x7f406e728388] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /lib/x86_64-linux-gnu/libpthread.so.0(+0xf030)[0x7f406dede030] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35)[0x7f406c771475] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180)[0x7f406c7746f0] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(+0x630490)[0x7f406e93d490] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(+0x635dfb)[0x7f406e942dfb] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(+0x641dc7)[0x7f406e94edc7] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(+0x60e5f5)[0x7f406e91b5f5] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(+0x5bee43)[0x7f406e8cbe43] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(+0x58b69f)[0x7f406e89869f] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x41)[0x7f406e72a641] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(+0x32cd57)[0x7f406e639d57] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(_Z11plugin_initPiPPci+0xa43)[0x7f406e63d123] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(+0x2b11c5)[0x7f406e5be1c5] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x45b)[0x7f406e5c2f0b] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd)[0x7f406c75dead] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: /usr/sbin/mysqld(+0x2ad649)[0x7f406e5ba649] Dec 13 18:24:56 serveur2 mysqld_safe[15661]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Dec 13 18:24:56 serveur2 mysqld_safe[15661]: information that should help you find out what is causing the crash. Dec 13 18:24:56 serveur2 mysqld_safe[15675]: 121213 18:24:56 [Note] Plugin 'FEDERATED' is disabled. Dec 13 18:24:56 serveur2 mysqld_safe[15675]: 121213 18:24:56 InnoDB: The InnoDB memory heap is disabled Dec 13 18:24:56 serveur2 mysqld_safe[15675]: 121213 18:24:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins Dec 13 18:24:56 serveur2 mysqld_safe[15675]: 121213 18:24:56 InnoDB: Compressed tables use zlib 1.2.7 Dec 13 18:24:56 serveur2 mysqld_safe[15675]: 121213 18:24:56 InnoDB: Using Linux native AIO Dec 13 18:24:56 serveur2 mysqld_safe[15675]: 121213 18:24:56 InnoDB: Initializing buffer pool, size = 128.0M Dec 13 18:24:56 serveur2 mysqld_safe[15675]: 121213 18:24:56 InnoDB: Completed initialization of buffer pool Dec 13 18:24:56 serveur2 mysqld_safe[15675]: 121213 18:24:56 InnoDB: highest supported file format is Barracuda. Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: The log sequence number in ibdata files does not match Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: the log sequence number in the ib_logfiles! Dec 13 18:24:56 serveur2 mysqld_safe[15675]: 121213 18:24:56 InnoDB: Database was not shut down normally! Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: Starting crash recovery. Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: Reading tablespace information from the .ibd files... Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: Restoring possible half-written data pages from the doublewrite Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: buffer... Dec 13 18:24:56 serveur2 mysqld_safe[15675]: 121213 18:24:56 InnoDB: Assertion failure in thread 140272742295328 in file fsp0fsp.c line 2102 Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: Failing assertion: inode Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: We intentionally generate a memory trap. Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: Submit a detailed bug report to http://bugs.mysql.com. Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: If you get repeated assertion failures or crashes, even Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: immediately after the mysqld startup, there may be Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: corruption in the InnoDB tablespace. Please refer to Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html Dec 13 18:24:56 serveur2 mysqld_safe[15675]: InnoDB: about forcing recovery. Dec 13 18:24:56 serveur2 mysqld_safe[15675]: 17:24:56 UTC - mysqld got signal 6 ; Dec 13 18:24:56 serveur2 mysqld_safe[15675]: This could be because you hit a bug. It is also possible that this binary Dec 13 18:24:56 serveur2 mysqld_safe[15675]: or one of the libraries it was linked against is corrupt, improperly built, Dec 13 18:24:56 serveur2 mysqld_safe[15675]: or misconfigured. This error can also be caused by malfunctioning hardware. Dec 13 18:24:56 serveur2 mysqld_safe[15675]: We will try our best to scrape up some info that will hopefully help Dec 13 18:24:56 serveur2 mysqld_safe[15675]: diagnose the problem, but since we have already crashed, Dec 13 18:24:56 serveur2 mysqld_safe[15675]: something is definitely wrong and this may fail. Dec 13 18:24:56 serveur2 mysqld_safe[15675]: Dec 13 18:24:56 serveur2 mysqld_safe[15675]: key_buffer_size=16777216 Dec 13 18:24:56 serveur2 mysqld_safe[15675]: read_buffer_size=131072 Dec 13 18:24:56 serveur2 mysqld_safe[15675]: max_used_connections=0 Dec 13 18:24:56 serveur2 mysqld_safe[15675]: max_threads=151 Dec 13 18:24:56 serveur2 mysqld_safe[15675]: thread_count=0 Dec 13 18:24:56 serveur2 mysqld_safe[15675]: connection_count=0 Dec 13 18:24:56 serveur2 mysqld_safe[15675]: It is possible that mysqld could use up to Dec 13 18:24:56 serveur2 mysqld_safe[15675]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346681 K bytes of memory Dec 13 18:24:56 serveur2 mysqld_safe[15675]: Hope that's ok; if not, decrease some variables in the equation. Dec 13 18:24:56 serveur2 mysqld_safe[15675]: Dec 13 18:24:56 serveur2 mysqld_safe[15675]: Thread pointer: 0x0 Dec 13 18:24:56 serveur2 mysqld_safe[15675]: Attempting backtrace. You can use the following information to find out Dec 13 18:24:56 serveur2 mysqld_safe[15675]: where mysqld died. If you see no messages after this, something went Dec 13 18:24:56 serveur2 mysqld_safe[15675]: terribly wrong... Dec 13 18:24:56 serveur2 mysqld_safe[15675]: stack_bottom = 0 thread_stack 0x30000 Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(my_print_stacktrace+0x29)[0x7f93cb4eec39] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(handle_fatal_signal+0x3d8)[0x7f93cb3d8388] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /lib/x86_64-linux-gnu/libpthread.so.0(+0xf030)[0x7f93cab8e030] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35)[0x7f93c9421475] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180)[0x7f93c94246f0] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(+0x630490)[0x7f93cb5ed490] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(+0x635dfb)[0x7f93cb5f2dfb] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(+0x641dc7)[0x7f93cb5fedc7] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(+0x60e5f5)[0x7f93cb5cb5f5] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(+0x5bee43)[0x7f93cb57be43] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(+0x58b69f)[0x7f93cb54869f] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x41)[0x7f93cb3da641] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(+0x32cd57)[0x7f93cb2e9d57] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(_Z11plugin_initPiPPci+0xa43)[0x7f93cb2ed123] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(+0x2b11c5)[0x7f93cb26e1c5] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x45b)[0x7f93cb272f0b] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd)[0x7f93c940dead] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: /usr/sbin/mysqld(+0x2ad649)[0x7f93cb26a649] Dec 13 18:24:56 serveur2 mysqld_safe[15675]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Dec 13 18:24:56 serveur2 mysqld_safe[15675]: information that should help you find out what is causing the crash. Dec 13 18:24:56 serveur2 mysqld_safe[15690]: 121213 18:24:56 [Note] Plugin 'FEDERATED' is disabled. Dec 13 18:24:56 serveur2 mysqld_safe[15690]: 121213 18:24:56 InnoDB: The InnoDB memory heap is disabled Dec 13 18:24:56 serveur2 mysqld_safe[15690]: 121213 18:24:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins Dec 13 18:24:56 serveur2 mysqld_safe[15690]: 121213 18:24:56 InnoDB: Compressed tables use zlib 1.2.7 Dec 13 18:24:56 serveur2 mysqld_safe[15690]: 121213 18:24:56 InnoDB: Using Linux native AIO Dec 13 18:24:56 serveur2 mysqld_safe[15690]: 121213 18:24:56 InnoDB: Initializing buffer pool, size = 128.0M Dec 13 18:24:56 serveur2 mysqld_safe[15690]: 121213 18:24:56 InnoDB: Completed initialization of buffer pool Dec 13 18:24:57 serveur2 mysqld_safe[15690]: 121213 18:24:56 InnoDB: highest supported file format is Barracuda. Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: The log sequence number in ibdata files does not match Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: the log sequence number in the ib_logfiles! Dec 13 18:24:57 serveur2 mysqld_safe[15690]: 121213 18:24:56 InnoDB: Database was not shut down normally! Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: Starting crash recovery. Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: Reading tablespace information from the .ibd files... Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: Restoring possible half-written data pages from the doublewrite Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: buffer... Dec 13 18:24:57 serveur2 mysqld_safe[15690]: 121213 18:24:57 InnoDB: Assertion failure in thread 139734359914272 in file fsp0fsp.c line 2102 Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: Failing assertion: inode Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: We intentionally generate a memory trap. Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: Submit a detailed bug report to http://bugs.mysql.com. Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: If you get repeated assertion failures or crashes, even Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: immediately after the mysqld startup, there may be Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: corruption in the InnoDB tablespace. Please refer to Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html Dec 13 18:24:57 serveur2 mysqld_safe[15690]: InnoDB: about forcing recovery. Dec 13 18:24:57 serveur2 mysqld_safe[15690]: 17:24:57 UTC - mysqld got signal 6 ; Dec 13 18:24:57 serveur2 mysqld_safe[15690]: This could be because you hit a bug. It is also possible that this binary Dec 13 18:24:57 serveur2 mysqld_safe[15690]: or one of the libraries it was linked against is corrupt, improperly built, Dec 13 18:24:57 serveur2 mysqld_safe[15690]: or misconfigured. This error can also be caused by malfunctioning hardware. Dec 13 18:24:57 serveur2 mysqld_safe[15690]: We will try our best to scrape up some info that will hopefully help Dec 13 18:24:57 serveur2 mysqld_safe[15690]: diagnose the problem, but since we have already crashed, Dec 13 18:24:57 serveur2 mysqld_safe[15690]: something is definitely wrong and this may fail. Dec 13 18:24:57 serveur2 mysqld_safe[15690]: Dec 13 18:24:57 serveur2 mysqld_safe[15690]: key_buffer_size=16777216 Dec 13 18:24:57 serveur2 mysqld_safe[15690]: read_buffer_size=131072 Dec 13 18:24:57 serveur2 mysqld_safe[15690]: max_used_connections=0 Dec 13 18:24:57 serveur2 mysqld_safe[15690]: max_threads=151 Dec 13 18:24:57 serveur2 mysqld_safe[15690]: thread_count=0 Dec 13 18:24:57 serveur2 mysqld_safe[15690]: connection_count=0 Dec 13 18:24:57 serveur2 mysqld_safe[15690]: It is possible that mysqld could use up to Dec 13 18:24:57 serveur2 mysqld_safe[15690]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346681 K bytes of memory Dec 13 18:24:57 serveur2 mysqld_safe[15690]: Hope that's ok; if not, decrease some variables in the equation. Dec 13 18:24:57 serveur2 mysqld_safe[15690]: Dec 13 18:24:57 serveur2 mysqld_safe[15690]: Thread pointer: 0x0 Dec 13 18:24:57 serveur2 mysqld_safe[15690]: Attempting backtrace. You can use the following information to find out Dec 13 18:24:57 serveur2 mysqld_safe[15690]: where mysqld died. If you see no messages after this, something went Dec 13 18:24:57 serveur2 mysqld_safe[15690]: terribly wrong... Dec 13 18:24:57 serveur2 mysqld_safe[15690]: stack_bottom = 0 thread_stack 0x30000 Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(my_print_stacktrace+0x29)[0x7f167137bc39] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(handle_fatal_signal+0x3d8)[0x7f1671265388] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /lib/x86_64-linux-gnu/libpthread.so.0(+0xf030)[0x7f1670a1b030] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35)[0x7f166f2ae475] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180)[0x7f166f2b16f0] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(+0x630490)[0x7f167147a490] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(+0x635dfb)[0x7f167147fdfb] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(+0x641dc7)[0x7f167148bdc7] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(+0x60e5f5)[0x7f16714585f5] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(+0x5bee43)[0x7f1671408e43] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(+0x58b69f)[0x7f16713d569f] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x41)[0x7f1671267641] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(+0x32cd57)[0x7f1671176d57] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(_Z11plugin_initPiPPci+0xa43)[0x7f167117a123] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(+0x2b11c5)[0x7f16710fb1c5] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x45b)[0x7f16710fff0b] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd)[0x7f166f29aead] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: /usr/sbin/mysqld(+0x2ad649)[0x7f16710f7649] Dec 13 18:24:57 serveur2 mysqld_safe[15690]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Dec 13 18:24:57 serveur2 mysqld_safe[15690]: information that should help you find out what is causing the crash. Dec 13 18:24:57 serveur2 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Dec 13 18:24:57 serveur2 mysqld: 121213 18:24:57 [Note] Plugin 'FEDERATED' is disabled. Dec 13 18:24:57 serveur2 mysqld: 121213 18:24:57 InnoDB: The InnoDB memory heap is disabled Dec 13 18:24:57 serveur2 mysqld: 121213 18:24:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins Dec 13 18:24:57 serveur2 mysqld: 121213 18:24:57 InnoDB: Compressed tables use zlib 1.2.7 Dec 13 18:24:57 serveur2 mysqld: 121213 18:24:57 InnoDB: Using Linux native AIO Dec 13 18:24:57 serveur2 mysqld: 121213 18:24:57 InnoDB: Initializing buffer pool, size = 128.0M Dec 13 18:24:57 serveur2 mysqld: 121213 18:24:57 InnoDB: Completed initialization of buffer pool Dec 13 18:24:57 serveur2 mysqld: 121213 18:24:57 InnoDB: highest supported file format is Barracuda. Dec 13 18:24:57 serveur2 mysqld: InnoDB: The log sequence number in ibdata files does not match Dec 13 18:24:57 serveur2 mysqld: InnoDB: the log sequence number in the ib_logfiles! Dec 13 18:24:57 serveur2 mysqld: 121213 18:24:57 InnoDB: Database was not shut down normally! Dec 13 18:24:57 serveur2 mysqld: InnoDB: Starting crash recovery. Dec 13 18:24:57 serveur2 mysqld: InnoDB: Reading tablespace information from the .ibd files... Dec 13 18:24:57 serveur2 mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite Dec 13 18:24:57 serveur2 mysqld: InnoDB: buffer... Dec 13 18:24:57 serveur2 mysqld: 121213 18:24:57 InnoDB: Assertion failure in thread 140376945182496 in file fsp0fsp.c line 2102 Dec 13 18:24:57 serveur2 mysqld: InnoDB: Failing assertion: inode Dec 13 18:24:57 serveur2 mysqld: InnoDB: We intentionally generate a memory trap. Dec 13 18:24:57 serveur2 mysqld: InnoDB: Submit a detailed bug report to http://bugs.mysql.com. Dec 13 18:24:57 serveur2 mysqld: InnoDB: If you get repeated assertion failures or crashes, even Dec 13 18:24:57 serveur2 mysqld: InnoDB: immediately after the mysqld startup, there may be Dec 13 18:24:57 serveur2 mysqld: InnoDB: corruption in the InnoDB tablespace. Please refer to Dec 13 18:24:57 serveur2 mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html Dec 13 18:24:57 serveur2 mysqld: InnoDB: about forcing recovery. Dec 13 18:24:57 serveur2 mysqld: 17:24:57 UTC - mysqld got signal 6 ; Dec 13 18:24:57 serveur2 mysqld: This could be because you hit a bug. It is also possible that this binary Dec 13 18:24:57 serveur2 mysqld: or one of the libraries it was linked against is corrupt, improperly built, Dec 13 18:24:57 serveur2 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Dec 13 18:24:57 serveur2 mysqld: We will try our best to scrape up some info that will hopefully help Dec 13 18:24:57 serveur2 mysqld: diagnose the problem, but since we have already crashed, Dec 13 18:24:57 serveur2 mysqld: something is definitely wrong and this may fail. Dec 13 18:24:57 serveur2 mysqld: Dec 13 18:24:57 serveur2 mysqld: key_buffer_size=16777216 Dec 13 18:24:57 serveur2 mysqld: read_buffer_size=131072 Dec 13 18:24:57 serveur2 mysqld: max_used_connections=0 Dec 13 18:24:57 serveur2 mysqld: max_threads=151 Dec 13 18:24:57 serveur2 mysqld: thread_count=0 Dec 13 18:24:57 serveur2 mysqld: connection_count=0 Dec 13 18:24:57 serveur2 mysqld: It is possible that mysqld could use up to Dec 13 18:24:57 serveur2 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346681 K bytes of memory Dec 13 18:24:57 serveur2 mysqld: Hope that's ok; if not, decrease some variables in the equation. Dec 13 18:24:57 serveur2 mysqld: Dec 13 18:24:57 serveur2 mysqld: Thread pointer: 0x0 Dec 13 18:24:57 serveur2 mysqld: Attempting backtrace. You can use the following information to find out Dec 13 18:24:57 serveur2 mysqld: where mysqld died. If you see no messages after this, something went Dec 13 18:24:57 serveur2 mysqld: terribly wrong... Dec 13 18:24:57 serveur2 mysqld: stack_bottom = 0 thread_stack 0x30000 Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x29)[0x7fac0e48cc39] Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x3d8)[0x7fac0e376388] Dec 13 18:24:57 serveur2 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0xf030)[0x7fac0db2c030] Dec 13 18:24:57 serveur2 mysqld: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35)[0x7fac0c3bf475] Dec 13 18:24:57 serveur2 mysqld: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180)[0x7fac0c3c26f0] Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(+0x630490)[0x7fac0e58b490] Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(+0x635dfb)[0x7fac0e590dfb] Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(+0x641dc7)[0x7fac0e59cdc7] Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(+0x60e5f5)[0x7fac0e5695f5] Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(+0x5bee43)[0x7fac0e519e43] Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(+0x58b69f)[0x7fac0e4e669f] Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x41)[0x7fac0e378641] Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(+0x32cd57)[0x7fac0e287d57] Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(_Z11plugin_initPiPPci+0xa43)[0x7fac0e28b123] Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(+0x2b11c5)[0x7fac0e20c1c5] Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x45b)[0x7fac0e210f0b] Dec 13 18:24:57 serveur2 mysqld: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd)[0x7fac0c3abead] Dec 13 18:24:57 serveur2 mysqld: /usr/sbin/mysqld(+0x2ad649)[0x7fac0e208649] Dec 13 18:24:57 serveur2 mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Dec 13 18:24:57 serveur2 mysqld: information that should help you find out what is causing the crash. Dec 13 18:24:57 serveur2 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Dec 13 18:25:11 serveur2 /etc/init.d/mysql[16352]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Dec 13 18:25:11 serveur2 /etc/init.d/mysql[16352]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Dec 13 18:25:11 serveur2 /etc/init.d/mysql[16352]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Dec 13 18:25:11 serveur2 /etc/init.d/mysql[16352]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Dec 13 18:25:11 serveur2 /etc/init.d/mysql[16352]:

[mazarini]

Je suppose que tu as fait une croix sur tes données ?

Dans ce cas, désinstalle mysql-server-5.5 et mysql-server-core-5.5 avec l’option purge.

Vérifie que mysql ne tourne pas sinon, arrête le (stop si possible kill -9 sinon)

Puis fait le ménage complet dans /var/lib/mysql (bases de données utilisateurs et système et autres fichiers) et recherche mysql (avec locate par exemple) pour supprimer d’autres traces de mysql.

[vandman]

Re,

Déjà fait avec la commande:

aptitude remove --purge mysql-server mysql-client mysql-server-5.5 mysql-server-core-5.5 mysql-common

et

aptitude purge ~c

J’ai même été dans /var/cache/apt/archives pour supprimer toute référence à des paquets mysql, de peur d’avoir des paquets corrompus.

Je ne comprend pas, tout est comme si j’avais fait un raz, mais je ne peux pas réinstaller???

[vandman]

Est-ce que mon probleme ne viendrait pas de cette ligne?

Je ne comprends pas comment je peux avoir cette erreur vu que j’ai tout effacé. Les bases et tables sont censées être recrées lors de l’installation???

[loreleil]

Salut,

À mon avis ton souci réside ici …

[quote=“vandman”]insserv: warning: current start runlevel(s) (empty) of script `mysql’ overrides LSB defaults (2 3 4 5).

insserv: warning: current stop runlevel(s) (1) of script `mysql’ overrides LSB defaults (0 1 6).
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

invoke-rc.d: initscript mysql, action “start” failed.

[/quote]

Ce qui sous entend que ton nettoyage n’était pas dès plus propice!

:~$ ls -a /etc/
...
rc0.d
rc1.d
rc2.d
rc3.d
rc4.d
rc5.d
rc6.d 
...

# rm /init.d/mysql

ls -la /etc/rc0.d
...
/etc/rc0.d/K01mysql -> ../init.d/mysql
...

# rm /etc/rc0.d/K01mysql

Ainsi de suite …

...
/etc/rc1.d/K01mysql -> ../init.d/mysql
...
/etc/rc2.d/S03mysql -> ../init.d/mysql
...
/etc/rc3.d/S03mysql -> ../init.d/mysql
...
/etc/rc4.d/S03mysql -> ../init.d/mysql
...
/etc/rc5.d/S03mysql -> ../init.d/mysql
...
/etc/rc6.d/K01mysql -> ../init.d/mysql
...

[vandman]

ca me l’a fait au début mais maintenant, je n’ai plus cette erreur.

Avant d’installé mysql, je n’ai pas les fichier dans les répertoires rcN.d.
Quand j’installe, ils réapparaissent bien???

J’avais remarqué la chose et avait restaurer les fichiers depuis. Mais je ne peux toujours pas réinstaller mysql???

[vandman]

Faut-il que je réinstalle mon ordi?

Je suis bien en galère!!!

[vandman]

J’ai réinstallé et ça fonctionne.

Je n’ai pas pu résoudre le problème même avec votre aide et celle d’un ami qui s’y connaît bien???
Pour éviter de réinstallé encore et encore, je vais dédier une machine virtuelle à mysql et d’autres pour mes autres services. c’est le début de la réflection sur mon architecture…

Merci tout de même à ceux qui ont pris du temps pour me répondre et bonne fêtes de fin d’année…