Forum |  HardWare.fr | News | Articles | PC | S'identifier | S'inscrire | Shop Recherche
1755 connectés 

  FORUM HardWare.fr
  Linux et OS Alternatifs
  Logiciels

  erreur démarrage MySql

 


 Mot :   Pseudo :  
 
Bas de page
Auteur Sujet :

erreur démarrage MySql

n°1356004
walid ouss​ama
Posté le 09-04-2014 à 18:07:36  profilanswer
 

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


 
 
merci d avance

mood
Publicité
Posté le 09-04-2014 à 18:07:36  profilanswer
 

n°1360185
l4nkou
Dr House Fan
Posté le 27-06-2014 à 20:14:33  profilanswer
 

   [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.

Aller à :
Ajouter une réponse
  FORUM HardWare.fr
  Linux et OS Alternatifs
  Logiciels

  erreur démarrage MySql

 

Sujets relatifs
openmediavault : erreur lors d'une modificationErreur script bash : TSET: 5: TSET: Syntax error: "(" unexpected
[RESOLU] Mysql dump et Expect[Résolu]Dual boot grub-install erreur et lilo
Pb avec MySQL - ne fonctionne pasErreur 500 qui vient de .htaccess
Script bash de démarrage qui se lance après un sudo haltRestauration ghost : OK sur PC physique / Erreur sous VirtualBox
[php] php5-pdo_mysql freebsd et réseau local[Debian] Erreur démarrage mysql :/
Plus de sujets relatifs à : erreur démarrage MySql


Copyright © 1997-2022 Hardware.fr SARL (Signaler un contenu illicite / Données personnelles) / Groupe LDLC / Shop HFR