errore database
ciao a tutti,
ho un problema con il mio server web in partcolare con il servizio mysql.
da ieri accedendo a un paio di siti il kernel mi da un errore di lettura
su un settore (sempre lo stesso), poi si pianta il server sql e si riavvia.
Per il momento ho disabilitato il sito con database danneggiato, ma tra
i database che causano problemi c'è anche information_schema.
in tutto i database danneggiati sembrano essere solo due ( e di entrambi
ho il backup di un paio di giorni fa).
come posso sovrascrivere tali db senza mandare in crash il servizio mysql?
Oct 30 06:26:43 srv kernel: [99993.239623] end_request: I/O error, dev sda, sector 3471943568
Oct 30 06:26:28 srv kernel: [99978.199829] ata1.00: exception Emask 0x0 SAct 0x3 SErr 0x0 action 0x0
Oct 30 06:26:28 srv kernel: [99978.199862] ata1.00: irq_stat 0x40000008
Oct 30 06:26:28 srv kernel: [99978.199887] ata1.00: failed command: READ FPDMA QUEUED
Oct 30 06:26:28 srv kernel: [99978.199918] ata1.00: cmd 60/70:08:90:a7:f1/00:00:ce:00:00/40 tag 1 ncq 57344 in
Oct 30 06:26:28 srv kernel: [99978.199920] res 41/40:70:90:a7:f1/00:00:ce:00:00/00 Emask 0x409 (media error) <F>
Oct 30 06:26:28 srv kernel: [99978.200008] ata1.00: status: { DRDY ERR }
Oct 30 06:26:28 srv kernel: [99978.200032] ata1.00: error: { UNC }
Oct 30 06:26:28 srv kernel: [99978.364990] ata1.00: configured for UDMA/133
Oct 30 06:26:31 srv kernel: [99981.244589] ata1.00: exception Emask 0x0 SAct 0x3 SErr 0x0 action 0x0
Oct 30 06:26:31 srv kernel: [99981.244621] ata1.00: irq_stat 0x40000008
Oct 30 06:26:31 srv kernel: [99981.244646] ata1.00: failed command: READ FPDMA QUEUED
Oct 30 06:26:31 srv kernel: [99981.244676] ata1.00: cmd 60/70:00:90:a7:f1/00:00:ce:00:00/40 tag 0 ncq 57344 in
Oct 30 06:26:31 srv kernel: [99981.244678] res 41/40:70:90:a7:f1/00:00:ce:00:00/00 Emask 0x409 (media error) <F>
Oct 30 06:26:31 srv kernel: [99981.244765] ata1.00: status: { DRDY ERR }
Oct 30 06:26:31 srv kernel: [99981.244789] ata1.00: error: { UNC }
Oct 30 06:26:31 srv kernel: [99981.316560] ata1.00: configured for UDMA/133
Oct 30 06:26:34 srv kernel: [99984.235653] ata1.00: exception Emask 0x0 SAct 0x2 SErr 0x0 action 0x0
Oct 30 06:26:34 srv kernel: [99984.235685] ata1.00: irq_stat 0x40000008
Oct 30 06:26:34 srv kernel: [99984.235709] ata1.00: failed command: READ FPDMA QUEUED
Oct 30 06:26:34 srv kernel: [99984.235740] ata1.00: cmd 60/70:08:90:a7:f1/00:00:ce:00:00/40 tag 1 ncq 57344 in
Oct 30 06:26:34 srv kernel: [99984.235742] res 41/40:70:90:a7:f1/00:00:ce:00:00/00 Emask 0x409 (media error) <F>
Oct 30 06:26:34 srv kernel: [99984.235829] ata1.00: status: { DRDY ERR }
Oct 30 06:26:34 srv kernel: [99984.235853] ata1.00: error: { UNC }
Oct 30 06:26:34 srv kernel: [99984.307662] ata1.00: configured for UDMA/133
Oct 30 06:26:37 srv kernel: [99987.210084] ata1.00: exception Emask 0x0 SAct 0x1 SErr 0x0 action 0x0
Oct 30 06:26:37 srv kernel: [99987.210117] ata1.00: irq_stat 0x40000008
Oct 30 06:26:37 srv kernel: [99987.210141] ata1.00: failed command: READ FPDMA QUEUED
Oct 30 06:26:37 srv kernel: [99987.210172] ata1.00: cmd 60/70:00:90:a7:f1/00:00:ce:00:00/40 tag 0 ncq 57344 in
Oct 30 06:26:37 srv kernel: [99987.210174] res 41/40:70:90:a7:f1/00:00:ce:00:00/00 Emask 0x409 (media error) <F>
Oct 30 06:26:37 srv kernel: [99987.210261] ata1.00: status: { DRDY ERR }
Oct 30 06:26:37 srv kernel: [99987.210285] ata1.00: error: { UNC }
Oct 30 06:26:37 srv kernel: [99987.282038] ata1.00: configured for UDMA/133
Oct 30 06:26:40 srv kernel: [99990.176213] ata1.00: exception Emask 0x0 SAct 0x1 SErr 0x0 action 0x0
Oct 30 06:26:40 srv kernel: [99990.176245] ata1.00: irq_stat 0x40000008
Oct 30 06:26:40 srv kernel: [99990.176269] ata1.00: failed command: READ FPDMA QUEUED
Oct 30 06:26:40 srv kernel: [99990.176300] ata1.00: cmd 60/70:00:90:a7:f1/00:00:ce:00:00/40 tag 0 ncq 57344 in
Oct 30 06:26:40 srv kernel: [99990.176302] res 41/40:70:90:a7:f1/00:00:ce:00:00/00 Emask 0x409 (media error) <F>
Oct 30 06:26:40 srv kernel: [99990.176390] ata1.00: status: { DRDY ERR }
Oct 30 06:26:40 srv kernel: [99990.176414] ata1.00: error: { UNC }
Oct 30 06:26:40 srv kernel: [99990.256544] ata1.00: configured for UDMA/133
Oct 30 06:26:43 srv kernel: [99993.158984] ata1.00: exception Emask 0x0 SAct 0x1 SErr 0x0 action 0x0
Oct 30 06:26:43 srv kernel: [99993.159016] ata1.00: irq_stat 0x40000008
Oct 30 06:26:43 srv kernel: [99993.159041] ata1.00: failed command: READ FPDMA QUEUED
Oct 30 06:26:43 srv kernel: [99993.159072] ata1.00: cmd 60/70:00:90:a7:f1/00:00:ce:00:00/40 tag 0 ncq 57344 in
Oct 30 06:26:43 srv kernel: [99993.159074] res 41/40:70:90:a7:f1/00:00:ce:00:00/00 Emask 0x409 (media error) <F>
Oct 30 06:26:43 srv kernel: [99993.159161] ata1.00: status: { DRDY ERR }
Oct 30 06:26:43 srv kernel: [99993.159184] ata1.00: error: { UNC }
Oct 30 06:26:43 srv kernel: [99993.239306] ata1.00: configured for UDMA/133
Oct 30 06:26:43 srv kernel: [99993.239341] sd 0:0:0:0: [sda] Unhandled sense code
Oct 30 06:26:43 srv kernel: [99993.239367] sd 0:0:0:0: [sda] Result: hostbyte=DID_OK driverbyte=DRIVER_SENSE
Oct 30 06:26:43 srv kernel: [99993.239398] sd 0:0:0:0: [sda] Sense Key : Medium Error [current] [descriptor]
Oct 30 06:26:43 srv kernel: [99993.239433] Descriptor sense data with sense descriptors (in hex):
Oct 30 06:26:43 srv kernel: [99993.239461] 72 03 11 04 00 00 00 0c 00 0a 80 00 00 00 00 00
Oct 30 06:26:43 srv kernel: [99993.239506] ce f1 a7 90
Oct 30 06:26:43 srv kernel: [99993.239532] sd 0:0:0:0: [sda] Add. Sense: Unrecovered read error - auto reallocate failed
Oct 30 06:26:43 srv kernel: [99993.239581] sd 0:0:0:0: [sda] CDB: Read(10): 28 00 ce f1 a7 90 00 00 70 00
Oct 30 06:26:46 srv kernel: [99996.116787] ata1.00: exception Emask 0x0 SAct 0x1 SErr 0x0 action 0x0
Oct 30 06:26:46 srv kernel: [99996.116819] ata1.00: irq_stat 0x40000008
Oct 30 06:26:46 srv kernel: [99996.116844] ata1.00: failed command: READ FPDMA QUEUED
Oct 30 06:26:46 srv kernel: [99996.116874] ata1.00: cmd 60/08:00:90:a7:f1/00:00:ce:00:00/40 tag 0 ncq 4096 in
Oct 30 06:26:46 srv kernel: [99996.116876] res 41/40:08:90:a7:f1/00:00:ce:00:00/00 Emask 0x409 (media error) <F>
Oct 30 06:26:46 srv kernel: [99996.116963] ata1.00: status: { DRDY ERR }
Oct 30 06:26:46 srv kernel: [99996.116988] ata1.00: error: { UNC }
Oct 30 06:26:46 srv kernel: [99996.205485] ata1.00: configured for UDMA/133
Oct 30 06:26:49 srv kernel: [99999.099578] ata1.00: exception Emask 0x0 SAct 0x1 SErr 0x0 action 0x0
Oct 30 06:26:49 srv kernel: [99999.099611] ata1.00: irq_stat 0x40000008
Oct 30 06:26:49 srv kernel: [99999.099635] ata1.00: failed command: READ FPDMA QUEUED
Oct 30 06:26:49 srv kernel: [99999.099666] ata1.00: cmd 60/08:00:90:a7:f1/00:00:ce:00:00/40 tag 0 ncq 4096 in
Oct 30 06:26:49 srv kernel: [99999.099668] res 41/40:08:90:a7:f1/00:00:ce:00:00/00 Emask 0x409 (media error) <F>
Oct 30 06:26:49 srv kernel: [99999.099755] ata1.00: status: { DRDY ERR }
Oct 30 06:26:49 srv kernel: [99999.099797] ata1.00: error: { UNC }
Oct 30 06:26:49 srv kernel: [99999.171592] ata1.00: configured for UDMA/133
Oct 30 06:26:52 srv kernel: [100002.148983] ata1.00: exception Emask 0x0 SAct 0x1 SErr 0x0 action 0x0
Oct 30 06:26:52 srv kernel: [100002.149015] ata1.00: irq_stat 0x40000008
Oct 30 06:26:52 srv kernel: [100002.149040] ata1.00: failed command: READ FPDMA QUEUED
Oct 30 06:26:52 srv kernel: [100002.149071] ata1.00: cmd 60/08:00:90:a7:f1/00:00:ce:00:00/40 tag 0 ncq 4096 in
Oct 30 06:26:52 srv kernel: [100002.149073] res 41/40:08:90:a7:f1/00:00:ce:00:00/00 Emask 0x409 (media error) <F>
Oct 30 06:26:52 srv kernel: [100002.149160] ata1.00: status: { DRDY ERR }
Oct 30 06:26:52 srv kernel: [100002.149184] ata1.00: error: { UNC }
Oct 30 06:26:52 srv kernel: [100002.220700] ata1.00: configured for UDMA/133
Oct 30 06:26:55 srv kernel: [100005.148432] ata1.00: exception Emask 0x0 SAct 0x1 SErr 0x0 action 0x0
Oct 30 06:26:55 srv kernel: [100005.148466] ata1.00: irq_stat 0x40000008
Oct 30 06:26:55 srv kernel: [100005.148491] ata1.00: failed command: READ FPDMA QUEUED
Oct 30 06:26:55 srv kernel: [100005.148522] ata1.00: cmd 60/08:00:90:a7:f1/00:00:ce:00:00/40 tag 0 ncq 4096 in
Oct 30 06:26:55 srv kernel: [100005.148524] res 41/40:08:90:a7:f1/00:00:ce:00:00/00 Emask 0x409 (media error) <F>
Oct 30 06:26:55 srv kernel: [100005.148631] ata1.00: status: { DRDY ERR }
Oct 30 06:26:55 srv kernel: [100005.148657] ata1.00: error: { UNC }
Oct 30 06:26:55 srv kernel: [100005.220421] ata1.00: configured for UDMA/133
Oct 30 06:26:58 srv kernel: [100008.056259] ata1.00: exception Emask 0x0 SAct 0x1 SErr 0x0 action 0x0
Oct 30 06:26:58 srv kernel: [100008.056291] ata1.00: irq_stat 0x40000008
Oct 30 06:26:58 srv kernel: [100008.056316] ata1.00: failed command: READ FPDMA QUEUED
Oct 30 06:26:58 srv kernel: [100008.056347] ata1.00: cmd 60/08:00:90:a7:f1/00:00:ce:00:00/40 tag 0 ncq 4096 in
Oct 30 06:26:58 srv kernel: [100008.056349] res 41/40:08:90:a7:f1/00:00:ce:00:00/00 Emask 0x409 (media error) <F>
Oct 30 06:26:58 srv kernel: [100008.056436] ata1.00: status: { DRDY ERR }
Oct 30 06:26:58 srv kernel: [100008.056460] ata1.00: error: { UNC }
Oct 30 06:26:58 srv kernel: [100008.234412] ata1.00: configured for UDMA/133
Oct 30 06:27:01 srv kernel: [100011.114059] ata1.00: exception Emask 0x0 SAct 0x1 SErr 0x0 action 0x0
Oct 30 06:27:01 srv kernel: [100011.114091] ata1.00: irq_stat 0x40000008
Oct 30 06:27:01 srv kernel: [100011.114117] ata1.00: failed command: READ FPDMA QUEUED
Oct 30 06:27:01 srv kernel: [100011.114148] ata1.00: cmd 60/08:00:90:a7:f1/00:00:ce:00:00/40 tag 0 ncq 4096 in
Oct 30 06:27:01 srv kernel: [100011.114150] res 41/40:08:90:a7:f1/00:00:ce:00:00/00 Emask 0x409 (media error) <F>
Oct 30 06:27:01 srv kernel: [100011.114238] ata1.00: status: { DRDY ERR }
Oct 30 06:27:01 srv kernel: [100011.114262] ata1.00: error: { UNC }
Oct 30 06:27:01 srv mysqld: InnoDB: Error: tried to read 16384 bytes at offset 0 857669632.
Oct 30 06:27:01 srv mysqld: InnoDB: Was only able to read 8192.
Oct 30 06:27:01 srv mysqld: 131030 6:27:01 InnoDB: Operating system error number 0 in a file operation.
Oct 30 06:27:01 srv mysqld: InnoDB: Error number 0 means 'Success'.
Oct 30 06:27:01 srv mysqld: InnoDB: Some operating system error numbers are described at
Oct 30 06:27:01 srv mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
Oct 30 06:27:01 srv mysqld: InnoDB: File operation call: 'read'.
Oct 30 06:27:01 srv mysqld: InnoDB: Cannot continue operation.
Oct 30 06:27:01 srv kernel: [100011.186059] ata1.00: configured for UDMA/133
Oct 30 06:27:01 srv kernel: [100011.186096] sd 0:0:0:0: [sda] Unhandled sense code
Oct 30 06:27:01 srv kernel: [100011.186121] sd 0:0:0:0: [sda] Result: hostbyte=DID_OK driverbyte=DRIVER_SENSE
Oct 30 06:27:01 srv kernel: [100011.186167] sd 0:0:0:0: [sda] Sense Key : Medium Error [current] [descriptor]
Oct 30 06:27:01 srv kernel: [100011.186215] Descriptor sense data with sense descriptors (in hex):
Oct 30 06:27:01 srv kernel: [100011.186244] 72 03 11 04 00 00 00 0c 00 0a 80 00 00 00 00 00
Oct 30 06:27:01 srv kernel: [100011.186288] ce f1 a7 90
Oct 30 06:27:01 srv kernel: [100011.187816] sd 0:0:0:0: [sda] Add. Sense: Unrecovered read error - auto reallocate failed
Oct 30 06:27:01 srv kernel: [100011.187865] sd 0:0:0:0: [sda] CDB: Read(10): 28 00 ce f1 a7 90 00 00 08 00
Oct 30 06:27:01 srv mysqld_safe: Number of processes running now: 0
Oct 30 06:27:01 srv mysqld_safe: mysqld restarted
Oct 30 06:27:04 srv mysqld: 131030 6:27:04 [Note] Plugin 'FEDERATED' is disabled.
Oct 30 06:27:04 srv mysqld: 131030 6:27:04 InnoDB: Initializing buffer pool, size = 8.0M
Oct 30 06:27:04 srv mysqld: 131030 6:27:04 InnoDB: Completed initialization of buffer pool
Oct 30 06:27:04 srv mysqld: InnoDB: Log scan progressed past the checkpoint lsn 13 409485884
Oct 30 06:27:04 srv mysqld: 131030 6:27:04 InnoDB: Database was not shut down normally!
Oct 30 06:27:04 srv mysqld: InnoDB: Starting crash recovery.
Oct 30 06:27:04 srv mysqld: InnoDB: Reading tablespace information from the .ibd files...
Oct 30 06:27:04 srv mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite
Oct 30 06:27:04 srv mysqld: InnoDB: buffer...
Oct 30 06:27:04 srv mysqld: InnoDB: Doing recovery: scanned up to log sequence number 13 409499089
Oct 30 06:27:05 srv postfix/proxymap[14532]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
Oct 30 06:27:06 srv mysqld: 131030 6:27:06 InnoDB: Starting an apply batch of log records to the database...
Oct 30 06:27:06 srv amavis[32566]: (32566-16) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 103) line 166, <GEN234> line 4.
Oct 30 06:27:06 srv amavis[32566]: (32566-16) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=dbispconfig;host=127.0.0.1;port=3306': Can't connect to MySQL server on '127.0.0.1' (111)
Oct 30 06:27:06 srv amavis[32566]: (32566-16) (!)lookup_sql: connect_to_sql: unable to connect to any dataset at (eval 103) line 241, <GEN234> line 4., 2003, Can't connect to MySQL server on '127.0.0.1' (111)
Oct 30 06:27:06 srv amavis[32566]: (32566-16) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 103) line 241, <GEN234> line 4. at (eval 104) line 280, <GEN234> line 4.
Oct 30 06:27:06 srv amavis[32566]: (32566-16) (!)Requesting process rundown after fatal error
Oct 30 06:27:07 srv mysqld: InnoDB: Progress in percents: 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 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
Oct 30 06:27:07 srv mysqld: InnoDB: Apply batch completed
Oct 30 06:27:07 srv amavis[31535]: (31535-19) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 103) line 166, <GEN312> line 4.
--
Nicola
Ser.Tec s.r.l.
Via E. Salgari 14/E
31056 Roncade, Treviso
http://dpidgprinting.com
http://twitter.com/sertecsrl
http://www.facebook.com/sertecsrl
http://www.youtube.com/sertectube
Reply to: