Bonjour à tous,

Je n'ai pas trouvé de cas similaire sur la toile mais je n'ai peut-être pas utilisé les bons mots-clés du coup je tente ma chance ici.

J'ai eu 2 serveurs applicatifs où MySQL server (+ common, librairies, client) est installé en version 5.5.57. Une mise à jour de sécurité est passé semaine dernière (5.5.58-0ubuntu0.14.04.1). Sur les 2 serveurs, la mise à jours via unattended-upgrades s'est bien passée, dans les logs pas d'erreur au niveau de dpkg.

Unattended-upgrades semble indiquer un arrêt puis la maj et le rédémarrage. La log MySQL indique par contre 5 A/R suivi d'un arrêt. Le service Mysql est resté plusieurs heures arrêté avant que je fasse une relance manuelle sur les 2 serveurs. Mon chef me demande des comptes mais je ne comprends pas l'échec de la relance suite aux mises à jours.

Extrait de la log :

error.log

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
171026  6:42:21 [Note] /usr/sbin/mysqld: Normal shutdown
 
171026  6:42:21 [Note] Event Scheduler: Killing the scheduler thread, thread id 1
171026  6:42:21 [Note] Event Scheduler: Waiting for the scheduler thread to reply
171026  6:42:21 [Note] Event Scheduler: Stopped
171026  6:42:21 [Note] Event Scheduler: Purging the queue. 0 events
171026  6:42:23 [Warning] /usr/sbin/mysqld: Forcing close of thread 1359  user: 'root'
 
171026  6:42:23 [Warning] /usr/sbin/mysqld: Forcing close of thread 1358  user: 'root'
 
171026  6:42:23 [Warning] /usr/sbin/mysqld: Forcing close of thread 1357  user: 'root'
 
171026  6:42:23 [Warning] /usr/sbin/mysqld: Forcing close of thread 1356  user: 'root'
 
171026  6:42:23  InnoDB: Starting shutdown...
171026  6:42:25  InnoDB: Shutdown completed; log sequence number 666888019
171026  6:42:25 [Note] /usr/sbin/mysqld: Shutdown complete
 
171026  6:42:35 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
171026  6:42:35 [Note] Plugin 'FEDERATED' is disabled.
171026  6:42:35 InnoDB: The InnoDB memory heap is disabled
171026  6:42:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
171026  6:42:35 InnoDB: Compressed tables use zlib 1.2.8
171026  6:42:35 InnoDB: Using Linux native AIO
171026  6:42:35 InnoDB: Initializing buffer pool, size = 128.0M
171026  6:42:35 InnoDB: Completed initialization of buffer pool
171026  6:42:35 InnoDB: highest supported file format is Barracuda.
171026  6:42:35  InnoDB: Waiting for the background threads to start
171026  6:42:36 InnoDB: 5.5.58 started; log sequence number 666888019
171026  6:42:36  InnoDB: Starting shutdown...
171026  6:42:37  InnoDB: Shutdown completed; log sequence number 666888019
171026  6:42:38 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
171026  6:42:38 [Note] Plugin 'FEDERATED' is disabled.
171026  6:42:38 InnoDB: The InnoDB memory heap is disabled
171026  6:42:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
171026  6:42:38 InnoDB: Compressed tables use zlib 1.2.8
171026  6:42:38 InnoDB: Using Linux native AIO
171026  6:42:38 InnoDB: Initializing buffer pool, size = 128.0M
171026  6:42:38 InnoDB: Completed initialization of buffer pool
171026  6:42:38 InnoDB: highest supported file format is Barracuda.
171026  6:42:38  InnoDB: Waiting for the background threads to start
171026  6:42:39 InnoDB: 5.5.58 started; log sequence number 666888019
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
171026  6:42:39 [ERROR] Aborting
 
171026  6:42:39  InnoDB: Starting shutdown...
171026  6:42:40  InnoDB: Shutdown completed; log sequence number 666888019
171026  6:42:40 [Note] /usr/sbin/mysqld: Shutdown complete
 
171026  6:42:40 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
171026  6:42:40 [Note] Plugin 'FEDERATED' is disabled.
171026  6:42:40 InnoDB: The InnoDB memory heap is disabled
171026  6:42:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
171026  6:42:40 InnoDB: Compressed tables use zlib 1.2.8
171026  6:42:40 InnoDB: Using Linux native AIO
171026  6:42:40 InnoDB: Initializing buffer pool, size = 128.0M
171026  6:42:40 InnoDB: Completed initialization of buffer pool
171026  6:42:40 InnoDB: highest supported file format is Barracuda.
171026  6:42:41  InnoDB: Waiting for the background threads to start
171026  6:42:42 InnoDB: 5.5.58 started; log sequence number 666888019
171026  6:42:42  InnoDB: Starting shutdown...
171026  6:42:43  InnoDB: Shutdown completed; log sequence number 666888019
171026  6:42:43 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
171026  6:42:43 [Note] Plugin 'FEDERATED' is disabled.
171026  6:42:43 InnoDB: The InnoDB memory heap is disabled
171026  6:42:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
171026  6:42:43 InnoDB: Compressed tables use zlib 1.2.8
171026  6:42:43 InnoDB: Using Linux native AIO
171026  6:42:43 InnoDB: Initializing buffer pool, size = 128.0M
171026  6:42:43 InnoDB: Completed initialization of buffer pool
171026  6:42:43 InnoDB: highest supported file format is Barracuda.
171026  6:42:43  InnoDB: Waiting for the background threads to start
171026  6:42:44 InnoDB: 5.5.58 started; log sequence number 666888019
ERROR: 1050  Table 'plugin' already exists
171026  6:42:44 [ERROR] Aborting
 
171026  6:42:44  InnoDB: Starting shutdown...
171026  6:42:45  InnoDB: Shutdown completed; log sequence number 666888019
171026  6:42:45 [Note] /usr/sbin/mysqld: Shutdown complete
Log Syslog :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
Oct 26 06:42:34 ns3065913 mysqld_safe[28964]: 171026  6:42:34 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Oct 26 06:42:34 ns3065913 mysqld_safe[28964]: 171026  6:42:34 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
Oct 26 06:42:34 ns3065913 mysqld_safe[28964]: 171026  6:42:34 [Note] /usr/sbin/mysqld (mysqld 5.5.58-0ubuntu0.14.04.1) starting as process 28984 ...
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: 171026  6:42:35 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: 171026  6:42:35 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: 171026  6:42:35 [Note] /usr/sbin/mysqld (mysqld 5.5.58-0ubuntu0.14.04.1) starting as process 28991 ...
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: 
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: To do so, start the server, then issue the following commands:
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: 
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: /usr/bin/mysqladmin -u root password 'new-password'
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: /usr/bin/mysqladmin -u root -h ns3065913.ip-51-255-78.eu password 'new-password'
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: 
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: Alternatively you can run:
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: /usr/bin/mysql_secure_installation
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: 
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: which will also give you the option of removing the test
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: databases and anonymous user created by default.  This is
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: strongly recommended for production servers.
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: 
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: See the manual for more instructions.
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: 
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: Please report any problems at http://bugs.mysql.com/
Oct 26 06:42:35 ns3065913 mysqld_safe[28964]: 
Oct 26 06:42:35 ns3065913 mysqld_safe[29009]: 171026  6:42:35 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Oct 26 06:42:35 ns3065913 mysqld_safe[29009]: 171026  6:42:35 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
Oct 26 06:42:35 ns3065913 mysqld_safe[29009]: 171026  6:42:35 [Note] /usr/sbin/mysqld (mysqld 5.5.58-0ubuntu0.14.04.1) starting as process 29008 ...
Oct 26 06:42:38 ns3065913 mysqld_safe[29034]: 171026  6:42:38 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Oct 26 06:42:38 ns3065913 mysqld_safe[29034]: 171026  6:42:38 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
Oct 26 06:42:38 ns3065913 mysqld_safe[29034]: 171026  6:42:38 [Note] /usr/sbin/mysqld (mysqld 5.5.58-0ubuntu0.14.04.1) starting as process 29033 ...
Oct 26 06:42:40 ns3065913 mysqld_safe[29150]: 171026  6:42:40 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Oct 26 06:42:40 ns3065913 mysqld_safe[29150]: 171026  6:42:40 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
Oct 26 06:42:40 ns3065913 mysqld_safe[29150]: 171026  6:42:40 [Note] /usr/sbin/mysqld (mysqld 5.5.58-0ubuntu0.14.04.1) starting as process 29149 ...
Oct 26 06:42:43 ns3065913 mysqld_safe[29171]: 171026  6:42:43 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Oct 26 06:42:43 ns3065913 mysqld_safe[29171]: 171026  6:42:43 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
Oct 26 06:42:43 ns3065913 mysqld_safe[29171]: 171026  6:42:43 [Note] /usr/sbin/mysqld (mysqld 5.5.58-0ubuntu0.14.04.1) starting as process 29170 ...
Merci pour vos idées !!

Bonne journée.