erreur démarrage MySql

erreur démarrage MySql - Logiciels - Linux et OS Alternatifs

Marsh Posté le 09-04-2014 à 18:07:36    

Bonsoir tout le monde , j'ai un probléme de démarrage MySql  
 

Code :
  1. [root@www ~]# service mysql start
  2. Starting MySQL..........The server quit without updating PID file (/var/lib/mysql/www.exemple.com.pid


 
j'ai fais cettes commands mais ça marche pas :
 

Code :
  1. [root@www ~]# ps aux | grep mysql
  2. root      2600  0.0  0.1   4164   648 pts/1    S+   14:46   0:00 grep mysql
  3. [root@www ~]# kill -9 2600
  4. -bash: kill: (2600) - Aucun processus de ce type
  5. [root@www ~]# mv /etc/my.cnf /etc/my.cnf.backup
  6. [root@www ~]#mv /var/lib/mysql/ib_logfile* /root/


 
et voici le fichier (/var/lib/mysql/www.exemple.com.err )
 

Code :
  1. 140409 14:24:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/
  2. mysql
  3. 2014-04-09 14:24:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
  4. ted. Please use --explicit_defaults_for_timestamp server option (see documentati
  5. on for more details).
  6. 2014-04-09 14:24:50 2291 [ERROR] Can't read from messagefile '/usr/share/mysql/e
  7. nglish/errmsg.sys'
  8. 2014-04-09 14:24:50 2291 [Note] Plugin 'FEDERATED' is disabled.
  9. 2014-04-09 14:24:51 2291 [Note] InnoDB: The InnoDB memory heap is disabled
  10. 2014-04-09 14:24:51 2291 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own im
  11. plementation
  12. 2014-04-09 14:24:51 2291 [Note] InnoDB: Compressed tables use zlib 1.2.3
  13. 2014-04-09 14:24:51 2291 [Note] InnoDB: Using Linux native AIO
  14. 2014-04-09 14:24:51 2291 [Note] InnoDB: Not using CPU crc32 instructions
  15. 2014-04-09 14:24:51 2291 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  16. 2014-04-09 14:24:51 2291 [Note] InnoDB: Completed initialization of buffer pool
  17. 2014-04-09 14:24:51 2291 [Note] InnoDB: Highest supported file format is Barracu
  18. da.
  19. 2014-04-09 14:24:54 2291 [Note] InnoDB: 128 rollback segment(s) are active.
  20. 2014-04-09 14:24:54 2291 [Note] InnoDB: Waiting for purge to start
  21. 2014-04-09 14:24:54 2291 [Note] InnoDB: 5.6.12 started; log sequence number 3430
  22. 0076
  23. 2014-04-09 14:24:54 2291 [ERROR] Aborting
  25. 2014-04-09 14:24:54 2291 [Note] Binlog end
  26. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'partition'
  27. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'BLACKHOLE'
  28. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'ARCHIVE'
  29. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  30. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  31. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  32. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  33. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  34. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  35. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  36. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  37. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  38. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  39. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  40. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  41. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  42. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  43. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  44. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD
  45. '
  46. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_METRICS'
  47. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  48. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  49. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  50. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET
  51. '
  52. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  53. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  54. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_CMPMEM'
  55. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  56. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_CMP'
  57. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  58. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_LOCKS'
  59. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_TRX'
  60. 2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'InnoDB'
  61. 2014-04-09 14:24:54 2291 [Note] InnoDB: FTS optimize thread exiting.
  62. 2014-04-09 14:24:54 2291 [Note] InnoDB: Starting shutdown...
  63. 2014-04-09 14:24:56 2291 [Note] InnoDB: Shutdown completed; log sequence number
  64. 34300086
  65. 2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'MRG_MYISAM'
  66. 2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'MEMORY'
  67. 2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'MyISAM'
  68. 2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'CSV'
  69. 2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'sha256_password'
  70. 2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'mysql_old_password'
  71. 2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'mysql_native_password'
  72. 2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'binlog'
  73. 2014-04-09 14:24:56 2291 [Note]
  74. 140409 14:24:57 mysqld_safe mysqld from pid file /var/lib/mysql/www.exemple.com.pid ended
  75. 140409 14:42:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/
  76. mysql
  77. 2014-04-09 14:42:26 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
  78. ted. Please use --explicit_defaults_for_timestamp server option (see documentati
  79. on for more details).
  80. 2014-04-09 14:42:26 2536 [ERROR] Can't read from messagefile '/usr/share/mysql/e
  81. nglish/errmsg.sys'
  82. 2014-04-09 14:42:27 2536 [Note] Plugin 'FEDERATED' is disabled.
  83. 2014-04-09 14:42:27 2536 [Note] InnoDB: The InnoDB memory heap is disabled
  84. 2014-04-09 14:42:27 2536 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own im
  85. plementation
  86. 2014-04-09 14:42:27 2536 [Note] InnoDB: Compressed tables use zlib 1.2.3
  87. 2014-04-09 14:42:27 2536 [Note] InnoDB: Using Linux native AIO
  88. 2014-04-09 14:42:27 2536 [Note] InnoDB: Not using CPU crc32 instructions
  89. 2014-04-09 14:42:27 2536 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  90. 2014-04-09 14:42:27 2536 [Note] InnoDB: Completed initialization of buffer pool
  91. 2014-04-09 14:42:28 2536 [Note] InnoDB: Highest supported file format is Barracu
  92. da.
  93. 2014-04-09 14:42:32 2536 [Note] InnoDB: 128 rollback segment(s) are active.
  94. 2014-04-09 14:42:32 2536 [Note] InnoDB: Waiting for purge to start
  95. 2014-04-09 14:42:33 2536 [Note] InnoDB: 5.6.12 started; log sequence number 3430
  96. 0086
  97. 2014-04-09 14:42:33 2536 [ERROR] Aborting
  99. 2014-04-09 14:42:33 2536 [Note] Binlog end
  100. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'partition'
  101. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'BLACKHOLE'
  102. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'ARCHIVE'
  103. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  104. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  105. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  106. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  107. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  108. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  109. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  110. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  111. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  112. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  113. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  114. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  115. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  116. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  117. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  118. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD
  119. '
  120. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_METRICS'
  121. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  122. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  123. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  124. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET
  125. '
  126. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  127. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  128. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_CMPMEM'
  129. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  130. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_CMP'
  131. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  132. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_LOCKS'
  133. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_TRX'
  134. 2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'InnoDB'
  135. 2014-04-09 14:42:33 2536 [Note] InnoDB: FTS optimize thread exiting.
  136. 2014-04-09 14:42:33 2536 [Note] InnoDB: Starting shutdown...
  137. 2014-04-09 14:42:34 2536 [Note] InnoDB: Shutdown completed; log sequence number
  138. 34300096
  139. 2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'MRG_MYISAM'
  140. 2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'MEMORY'
  141. 2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'MyISAM'
  142. 2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'CSV'
  143. 2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'sha256_password'
  144. 2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'mysql_old_password'
  145. 2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'mysql_native_password'
  146. 2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'binlog'
  147. 2014-04-09 14:42:34 2536 [Note]
  148. 140409 14:42:35 [B]mysqld_safe mysqld from pid file /var/lib/mysql/www.exemple.com.pid ended[/B]


 
 
merci d avance

Reply

Marsh Posté le 09-04-2014 à 18:07:36   

Reply

Marsh Posté le 27-06-2014 à 20:14:33    

   [root@www ~]# ps aux | grep mysql
    root      2600  0.0  0.1   4164   648 pts/1    S+   14:46   0:00 grep mysql
    [root@www ~]# kill -9 2600
    -bash: kill: (2600) - Aucun processus de ce type
    [root@www ~]# mv /etc/my.cnf /etc/my.cnf.backup
    [root@www ~]#mv /var/lib/mysql/ib_logfile* /root/
 
C'est quoi le but ?
Tu sais ce que tu fais à chaque commande ?
 
tu cherches le processus mysql,
il te renvoie la commande grep elle même, que tu essayes de killer...
tu déplaces ta conf mysql.
tu déplaces tes fichiers des transactions temporaires ( ok, peut être ).
 
tu as encore de la place sur ton serveur ?
 
df -k
 
mysql à encore les droits sur le dossier /var/lib/mysql ?
ls -al /var/lib
ls -al /var/lib/mysql
 


---------------
Les avis, c'est comme les anus, tout le monde en a un.
Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed