Advertisement
Guest User

Untitled

a guest
Nov 27th, 2014
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.23 KB | None | 0 0
  1. Nov 6 04:20:33 kevmo314 mysqld: 111106 4:20:33 InnoDB: Error: page 245802 log sequence number 61 3499737721
  2. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: is in the future! Current system log sequence number 0 8204.
  3. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: Your database may be corrupt or you may have copied the InnoDB
  4. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: tablespace but not the InnoDB log files. See
  5. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
  6. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: for more information.
  7. Nov 6 04:20:33 kevmo314 mysqld: 111106 4:20:33 InnoDB: Error: page 245788 log sequence number 61 3499737613
  8. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: is in the future! Current system log sequence number 0 8204.
  9. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: Your database may be corrupt or you may have copied the InnoDB
  10. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: tablespace but not the InnoDB log files. See
  11. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
  12. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: for more information.
  13. Nov 6 04:20:33 kevmo314 mysqld: 111106 4:20:33 InnoDB: Error: page 245816 log sequence number 61 3180676464
  14. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: is in the future! Current system log sequence number 0 8204.
  15. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: Your database may be corrupt or you may have copied the InnoDB
  16. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: tablespace but not the InnoDB log files. See
  17. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
  18. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: for more information.
  19. Nov 6 04:20:33 kevmo314 mysqld: 111106 4:20:33 InnoDB: Error: page 327684 log sequence number 61 3587218257
  20. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: is in the future! Current system log sequence number 0 8204.
  21. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: Your database may be corrupt or you may have copied the InnoDB
  22. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: tablespace but not the InnoDB log files. See
  23. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
  24. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: for more information.
  25. Nov 6 04:20:33 kevmo314 mysqld: 111106 4:20:33 InnoDB: Error: page 8 log sequence number 5 3253003088
  26. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: is in the future! Current system log sequence number 0 8204.
  27. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: Your database may be corrupt or you may have copied the InnoDB
  28. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: tablespace but not the InnoDB log files. See
  29. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
  30. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: for more information.
  31. Nov 6 04:20:33 kevmo314 mysqld: 111106 4:20:33 InnoDB: Error: page 0 log sequence number 61 3590235012
  32. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: is in the future! Current system log sequence number 0 8204.
  33. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: Your database may be corrupt or you may have copied the InnoDB
  34. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: tablespace but not the InnoDB log files. See
  35. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
  36. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: for more information.
  37. Nov 6 04:20:33 kevmo314 mysqld: 111106 4:20:33 InnoDB: Error: page 10 log sequence number 5 3253004335
  38. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: is in the future! Current system log sequence number 0 8204.
  39. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: Your database may be corrupt or you may have copied the InnoDB
  40. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: tablespace but not the InnoDB log files. See
  41. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
  42. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: for more information.
  43. Nov 6 04:20:33 kevmo314 mysqld: 111106 4:20:33 InnoDB: Error: page 9 log sequence number 5 3253003136
  44. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: is in the future! Current system log sequence number 0 8204.
  45. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: Your database may be corrupt or you may have copied the InnoDB
  46. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: tablespace but not the InnoDB log files. See
  47. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
  48. Nov 6 04:20:33 kevmo314 mysqld: InnoDB: for more information.
  49. Nov 6 04:20:36 kevmo314 kernel: [ 6553.720679] ata3.00: exception Emask 0x0 SAct 0x0 SErr 0x0 action 0x0
  50. Nov 6 04:20:36 kevmo314 kernel: [ 6553.720708] ata3.00: BMDMA stat 0x24
  51. Nov 6 04:20:36 kevmo314 kernel: [ 6553.720728] ata3.00: failed command: READ DMA
  52. Nov 6 04:20:36 kevmo314 kernel: [ 6553.720752] ata3.00: cmd c8/00:08:60:d5:89/00:00:00:00:00/e2 tag 0 dma 4096 in
  53. Nov 6 04:20:36 kevmo314 kernel: [ 6553.720753] res 51/40:00:61:d5:89/00:00:00:00:00/02 Emask 0x9 (media error)
  54. Nov 6 04:20:36 kevmo314 kernel: [ 6553.720828] ata3.00: status: { DRDY ERR }
  55. Nov 6 04:20:36 kevmo314 kernel: [ 6553.720848] ata3.00: error: { UNC }
  56. Nov 6 04:20:36 kevmo314 kernel: [ 6553.940262] ata3.00: configured for UDMA/133
  57. Nov 6 04:20:36 kevmo314 kernel: [ 6553.940274] ata3: EH complete
  58. Nov 6 04:20:39 kevmo314 kernel: [ 6556.860948] ata3.00: exception Emask 0x0 SAct 0x0 SErr 0x0 action 0x0
  59. Nov 6 04:20:39 kevmo314 kernel: [ 6556.860977] ata3.00: BMDMA stat 0x24
  60. Nov 6 04:20:39 kevmo314 kernel: [ 6556.860998] ata3.00: failed command: READ DMA
  61. Nov 6 04:20:39 kevmo314 kernel: [ 6556.861021] ata3.00: cmd c8/00:08:60:d5:89/00:00:00:00:00/e2 tag 0 dma 4096 in
  62. Nov 6 04:20:39 kevmo314 kernel: [ 6556.861022] res 51/40:00:61:d5:89/00:00:00:00:00/02 Emask 0x9 (media error)
  63. Nov 6 04:20:39 kevmo314 kernel: [ 6556.861097] ata3.00: status: { DRDY ERR }
  64. Nov 6 04:20:39 kevmo314 kernel: [ 6556.861118] ata3.00: error: { UNC }
  65. Nov 6 04:20:39 kevmo314 kernel: [ 6557.080548] ata3.00: configured for UDMA/133
  66. Nov 6 04:20:39 kevmo314 kernel: [ 6557.080565] ata3: EH complete
  67. Nov 6 04:20:42 kevmo314 kernel: [ 6560.025988] ata3.00: exception Emask 0x0 SAct 0x0 SErr 0x0 action 0x0
  68. Nov 6 04:20:42 kevmo314 kernel: [ 6560.026017] ata3.00: BMDMA stat 0x24
  69. Nov 6 04:20:42 kevmo314 kernel: [ 6560.026038] ata3.00: failed command: READ DMA
  70. Nov 6 04:20:42 kevmo314 kernel: [ 6560.026061] ata3.00: cmd c8/00:08:60:d5:89/00:00:00:00:00/e2 tag 0 dma 4096 in
  71. Nov 6 04:20:42 kevmo314 kernel: [ 6560.026062] res 51/40:00:61:d5:89/00:00:00:00:00/02 Emask 0x9 (media error)
  72. Nov 6 04:20:42 kevmo314 kernel: [ 6560.026137] ata3.00: status: { DRDY ERR }
  73. Nov 6 04:20:42 kevmo314 kernel: [ 6560.026158] ata3.00: error: { UNC }
  74. Nov 6 04:20:42 kevmo314 kernel: [ 6560.245443] ata3.00: configured for UDMA/133
  75. Nov 6 04:20:42 kevmo314 kernel: [ 6560.245458] ata3: EH complete
  76. Nov 6 04:20:45 kevmo314 kernel: [ 6563.232517] ata3.00: exception Emask 0x0 SAct 0x0 SErr 0x0 action 0x0
  77. Nov 6 04:20:45 kevmo314 kernel: [ 6563.232545] ata3.00: BMDMA stat 0x24
  78. Nov 6 04:20:45 kevmo314 kernel: [ 6563.232566] ata3.00: failed command: READ DMA
  79. Nov 6 04:20:45 kevmo314 kernel: [ 6563.232590] ata3.00: cmd c8/00:08:60:d5:89/00:00:00:00:00/e2 tag 0 dma 4096 in
  80. Nov 6 04:20:45 kevmo314 kernel: [ 6563.232591] res 51/40:00:61:d5:89/00:00:00:00:00/02 Emask 0x9 (media error)
  81. Nov 6 04:20:45 kevmo314 kernel: [ 6563.232666] ata3.00: status: { DRDY ERR }
  82. Nov 6 04:20:45 kevmo314 kernel: [ 6563.232686] ata3.00: error: { UNC }
  83. Nov 6 04:20:46 kevmo314 kernel: [ 6563.469023] ata3.00: configured for UDMA/133
  84. Nov 6 04:20:46 kevmo314 kernel: [ 6563.469039] ata3: EH complete
  85. Nov 6 04:20:46 kevmo314 /etc/init.d/mysql[11095]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
  86. Nov 6 04:20:46 kevmo314 /etc/init.d/mysql[11095]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
  87. Nov 6 04:20:46 kevmo314 /etc/init.d/mysql[11095]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
  88. Nov 6 04:20:46 kevmo314 /etc/init.d/mysql[11095]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
  89. Nov 6 04:20:46 kevmo314 /etc/init.d/mysql[11095]:
  90. Nov 6 04:20:49 kevmo314 kernel: [ 6566.439445] ata3.00: exception Emask 0x0 SAct 0x0 SErr 0x0 action 0x0
  91. Nov 6 04:20:49 kevmo314 kernel: [ 6566.439473] ata3.00: BMDMA stat 0x24
  92. Nov 6 04:20:49 kevmo314 kernel: [ 6566.439494] ata3.00: failed command: READ DMA
  93. Nov 6 04:20:49 kevmo314 kernel: [ 6566.439518] ata3.00: cmd c8/00:08:60:d5:89/00:00:00:00:00/e2 tag 0 dma 4096 in
  94. Nov 6 04:20:49 kevmo314 kernel: [ 6566.439519] res 51/40:00:61:d5:89/00:00:00:00:00/02 Emask 0x9 (media error)
  95. Nov 6 04:20:49 kevmo314 kernel: [ 6566.439594] ata3.00: status: { DRDY ERR }
  96. Nov 6 04:20:49 kevmo314 kernel: [ 6566.439614] ata3.00: error: { UNC }
  97. Nov 6 04:20:49 kevmo314 kernel: [ 6566.667239] ata3.00: configured for UDMA/133
  98. Nov 6 04:20:49 kevmo314 kernel: [ 6566.667253] ata3: EH complete
  99. Nov 6 04:20:52 kevmo314 kernel: [ 6569.637871] ata3.00: exception Emask 0x0 SAct 0x0 SErr 0x0 action 0x0
  100. Nov 6 04:20:52 kevmo314 kernel: [ 6569.637901] ata3.00: BMDMA stat 0x24
  101. Nov 6 04:20:52 kevmo314 kernel: [ 6569.637924] ata3.00: failed command: READ DMA
  102. Nov 6 04:20:52 kevmo314 kernel: [ 6569.637949] ata3.00: cmd c8/00:08:60:d5:89/00:00:00:00:00/e2 tag 0 dma 4096 in
  103. Nov 6 04:20:52 kevmo314 kernel: [ 6569.637951] res 51/40:00:61:d5:89/00:00:00:00:00/02 Emask 0x9 (media error)
  104. Nov 6 04:20:52 kevmo314 kernel: [ 6569.639649] ata3.00: status: { DRDY ERR }
  105. Nov 6 04:20:52 kevmo314 kernel: [ 6569.639687] ata3.00: error: { UNC }
  106. Nov 6 04:20:52 kevmo314 mysqld: InnoDB: Error: tried to read 786432 bytes at offset 0 196608.
  107. Nov 6 04:20:52 kevmo314 mysqld: InnoDB: Was only able to read 364544.
  108. Nov 6 04:20:52 kevmo314 mysqld: 111106 4:20:52 InnoDB: Operating system error number 0 in a file operation.
  109. Nov 6 04:20:52 kevmo314 mysqld: InnoDB: Error number 0 means 'Success'.
  110. Nov 6 04:20:52 kevmo314 mysqld: InnoDB: Some operating system error numbers are described at
  111. Nov 6 04:20:52 kevmo314 mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
  112. Nov 6 04:20:52 kevmo314 mysqld: InnoDB: File operation call: 'read'.
  113. Nov 6 04:20:52 kevmo314 mysqld: InnoDB: Cannot continue operation.
  114. Nov 6 04:20:52 kevmo314 kernel: [ 6569.857513] ata3.00: configured for UDMA/133
  115. Nov 6 04:20:52 kevmo314 kernel: [ 6569.857525] sd 2:0:0:0: [sda] Unhandled sense code
  116. Nov 6 04:20:52 kevmo314 kernel: [ 6569.857526] sd 2:0:0:0: [sda] Result: hostbyte=DID_OK driverbyte=DRIVER_SENSE
  117. Nov 6 04:20:52 kevmo314 kernel: [ 6569.857529] sd 2:0:0:0: [sda] Sense Key : Medium Error [current] [descriptor]
  118. Nov 6 04:20:52 kevmo314 kernel: [ 6569.857532] Descriptor sense data with sense descriptors (in hex):
  119. Nov 6 04:20:52 kevmo314 kernel: [ 6569.857534] 72 03 11 04 00 00 00 0c 00 0a 80 00 00 00 00 00
  120. Nov 6 04:20:52 kevmo314 kernel: [ 6569.857539] 02 89 d5 61
  121. Nov 6 04:20:52 kevmo314 kernel: [ 6569.857542] sd 2:0:0:0: [sda] Add. Sense: Unrecovered read error - auto reallocate failed
  122. Nov 6 04:20:52 kevmo314 kernel: [ 6569.857546] sd 2:0:0:0: [sda] CDB: Read(10): 28 00 02 89 d5 60 00 00 08 00
  123. Nov 6 04:20:52 kevmo314 kernel: [ 6569.857551] end_request: I/O error, dev sda, sector 42587489
  124. Nov 6 04:20:52 kevmo314 kernel: [ 6569.857590] ata3: EH complete
  125. Nov 6 04:20:52 kevmo314 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
  126.  
  127. #
  128. # The MySQL database server configuration file.
  129. #
  130. # You can copy this to one of:
  131. # - "/etc/mysql/my.cnf" to set global options,
  132. # - "~/.my.cnf" to set user-specific options.
  133. #
  134. # One can use all long options that the program supports.
  135. # Run program with --help to get a list of available options and with
  136. # --print-defaults to see which it would actually understand and use.
  137. #
  138. # For explanations see
  139. # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
  140.  
  141. # This will be passed to all mysql clients
  142. # It has been reported that passwords should be enclosed with ticks/quotes
  143. # escpecially if they contain "#" chars...
  144. # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
  145. [client]
  146. port = 3306
  147. socket = /var/run/mysqld/mysqld.sock
  148.  
  149. # Here is entries for some specific programs
  150. # The following values assume you have at least 32M ram
  151.  
  152. # This was formally known as [safe_mysqld]. Both versions are currently parsed.
  153. [mysqld_safe]
  154. socket = /var/run/mysqld/mysqld.sock
  155. nice = 0
  156.  
  157. [mysqld]
  158. #
  159. # * Basic Settings
  160. #
  161. user = mysql
  162. pid-file = /var/run/mysqld/mysqld.pid
  163. socket = /var/run/mysqld/mysqld.sock
  164. port = 3306
  165. basedir = /usr
  166. datadir = /var/lib/mysql
  167. tmpdir = /tmp
  168. language = /usr/share/mysql/english
  169. skip-external-locking
  170. #
  171. # Instead of skip-networking the default is now to listen only on
  172. # localhost which is more compatible and is not less secure.
  173. #bind-address = 127.0.0.1
  174. #
  175. # * Fine Tuning
  176. #
  177. key_buffer = 256M
  178. join_buffer_size = 4M
  179. max_allowed_packet = 32M
  180. myisam_sort_buffer_size = 128M
  181. sort_buffer_size = 4M
  182. read_buffer_size = 4M
  183. read_rnd_buffer_size = 4M
  184. thread_stack = 192K
  185. thread_cache_size = 8
  186. # This replaces the startup script and checks MyISAM tables if needed
  187. # the first time they are touched
  188. myisam-recover = BACKUP
  189. #max_connections = 100
  190. #table_cache = 64
  191. #thread_concurrency = 10
  192. #
  193. # * Query Cache Configuration
  194. #
  195. query_cache_limit = 1M
  196. query_cache_size = 64M
  197. #
  198. # * Logging and Replication
  199. #
  200. # Both location gets rotated by the cronjob.
  201. # Be aware that this log type is a performance killer.
  202. # As of 5.1 you can enable the log at runtime!
  203. #general_log_file = /var/log/mysql/mysql.log
  204. #general_log = 1
  205. #
  206. # Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
  207. #
  208. # Here you can see queries with especially long duration
  209. #log_slow_queries = /var/log/mysql/mysql-slow.log
  210. #long_query_time = 2
  211. #log-queries-not-using-indexes
  212. #
  213. # The following can be used as easy to replay backup logs or for replication.
  214. # note: if you are setting up a replication slave, see README.Debian about
  215. # other settings you may need to change.
  216. #server-id = 1
  217. #log_bin = /var/log/mysql/mysql-bin.log
  218. expire_logs_days = 10
  219. max_binlog_size = 100M
  220. #binlog_do_db = include_database_name
  221. #binlog_ignore_db = include_database_name
  222. #
  223. # * InnoDB
  224. #
  225. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
  226. # Read the manual for more InnoDB related options. There are many!
  227. #
  228. # * Security Features
  229. #
  230. # Read the manual, too, if you want chroot!
  231. # chroot = /var/lib/mysql/
  232. #
  233. # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
  234. #
  235. # ssl-ca=/etc/mysql/cacert.pem
  236. # ssl-cert=/etc/mysql/server-cert.pem
  237. # ssl-key=/etc/mysql/server-key.pem
  238. innodb_buffer_pool_size = 3G
  239.  
  240. [mysqldump]
  241. quick
  242. quote-names
  243. max_allowed_packet = 16M
  244.  
  245. [mysql]
  246. #no-auto-rehash # faster start of mysql but no tab completition
  247.  
  248. [isamchk]
  249. key_buffer = 256M
  250. sort_buffer = 256M
  251. read_buffer = 64M
  252. write_buffer = 64M
  253.  
  254. #
  255. # * IMPORTANT: Additional settings that can override those from this file!
  256. # The files must end with '.cnf', otherwise they'll be ignored.
  257. #
  258. !includedir /etc/mysql/conf.d/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement