Re: Extraño error en la mysql
El miércoles, 25 feb 2015, a las 23:29 UTC+1 horas,
Fabián Bonetti escribió:
>On Wed, 25 Feb 2015 14:06:15 -0300
>Felix Perez <felix.listadebian@gmail.com> wrote:
>
>El resultado del disco duro
>
>smartctl 5.41 2011-06-09 r3365 [i686-linux-3.2.0-4-686-pae] (local build)
>Copyright (C) 2002-11 by Bruce Allen, http://smartmontools.sourceforge.net
>
>=== START OF INFORMATION SECTION ===
>Device Model: Hitachi HDS721616PLA320
>Serial Number: PVF904ZFTALALN
>LU WWN Device Id: 5 000cca 33ae0ff92
>Firmware Version: P22OABGA
>User Capacity: 160,041,885,696 bytes [160 GB]
>Sector Size: 512 bytes logical/physical
>Device is: Not in smartctl database [for details use: -P showall]
>ATA Version is: 7
>ATA Standard is: ATA/ATAPI-7 T13 1532D revision 1
>Local Time is: Wed Feb 25 19:26:38 2015 ART
>SMART support is: Available - device has SMART capability.
>SMART support is: Enabled
>
>=== START OF READ SMART DATA SECTION ===
>SMART overall-health self-assessment test result: PASSED
>
>General SMART Values:
>Offline data collection status: (0x00) Offline data collection activity
> was never started.
> Auto Offline Data Collection: Disabled.
>Self-test execution status: ( 241) Self-test routine in progress...
> 10% of test remaining.
>Total time to complete Offline
>data collection: ( 2865) seconds.
>Offline data collection
>capabilities: (0x5b) SMART execute Offline immediate.
> Auto Offline data collection on/off support.
> Suspend Offline collection upon new
> command.
> Offline surface scan supported.
> Self-test supported.
> No Conveyance Self-test supported.
> Selective Self-test supported.
>SMART capabilities: (0x0003) Saves SMART data before entering
> power-saving mode.
> Supports SMART auto save timer.
>Error logging capability: (0x01) Error logging supported.
> General Purpose Logging supported.
>Short self-test routine
>recommended polling time: ( 1) minutes.
>Extended self-test routine
>recommended polling time: ( 48) minutes.
>SCT capabilities: (0x003f) SCT Status supported.
> SCT Error Recovery Control supported.
> SCT Feature Control supported.
> SCT Data Table supported.
>
>SMART Attributes Data Structure revision number: 16
>Vendor Specific SMART Attributes with Thresholds:
>ID# ATTRIBUTE_NAME FLAG VALUE WORST THRESH TYPE UPDATED WHEN_FAILED RAW_VALUE
> 1 Raw_Read_Error_Rate 0x000b 086 086 016 Pre-fail Always - 4194387
> 2 Throughput_Performance 0x0005 100 100 050 Pre-fail Offline - 0
> 3 Spin_Up_Time 0x0007 125 125 024 Pre-fail Always - 160 (Average 160)
> 4 Start_Stop_Count 0x0012 099 099 000 Old_age Always - 4794
> 5 Reallocated_Sector_Ct 0x0033 100 100 005 Pre-fail Always - 21
> 7 Seek_Error_Rate 0x000b 100 100 067 Pre-fail Always - 0
> 8 Seek_Time_Performance 0x0005 100 100 020 Pre-fail Offline - 0
> 9 Power_On_Hours 0x0012 094 094 000 Old_age Always - 45309
> 10 Spin_Retry_Count 0x0013 100 100 060 Pre-fail Always - 0
> 12 Power_Cycle_Count 0x0032 099 099 000 Old_age Always - 4790
>192 Power-Off_Retract_Count 0x0032 095 095 000 Old_age Always - 6533
>193 Load_Cycle_Count 0x0012 095 095 000 Old_age Always - 6533
>194 Temperature_Celsius 0x0002 157 157 000 Old_age Always - 38 (Min/Max 9/52)
>196 Reallocated_Event_Count 0x0032 100 100 000 Old_age Always - 21
>197 Current_Pending_Sector 0x0022 100 100 000 Old_age Always - 0
>198 Offline_Uncorrectable 0x0008 100 100 000 Old_age Offline - 0
>199 UDMA_CRC_Error_Count 0x000a 200 253 000 Old_age Always - 135
>
>SMART Error Log Version: 1
>Warning: ATA error count 25 inconsistent with error log pointer 3
>
>ATA Error Count: 25 (device log contains only the most recent five errors)
> CR = Command Register [HEX]
> FR = Features Register [HEX]
> SC = Sector Count Register [HEX]
> SN = Sector Number Register [HEX]
> CL = Cylinder Low Register [HEX]
> CH = Cylinder High Register [HEX]
> DH = Device/Head Register [HEX]
> DC = Device Command Register [HEX]
> ER = Error register [HEX]
> ST = Status register [HEX]
>Powered_Up_Time is measured from power on, and printed as
>DDd+hh:mm:SS.sss where DD=days, hh=hours, mm=minutes,
>SS=sec, and sss=millisec. It "wraps" after 49.710 days.
>
>Error 25 occurred at disk power-on lifetime: 45287 hours (1886 days + 23 hours)
> When the command that caused the error occurred, the device was active or idle.
>
> After command completion occurred, registers were:
> ER ST SC SN CL CH DH
> -- -- -- -- -- -- --
> 84 51 01 01 00 00 00 Error: ICRC, ABRT at LBA = 0x00000001 = 1
>
> Commands leading to the command that caused the error were:
> CR FR SC SN CL CH DH DC Powered_Up_Time Command/Feature_Name
> -- -- -- -- -- -- -- -- ---------------- --------------------
> 61 08 00 20 a4 ba 41 ff 04:18:15.100 WRITE FPDMA QUEUED
> 61 08 b8 d8 8a 48 40 08 04:18:15.100 WRITE FPDMA QUEUED
> 61 10 b0 80 8a 48 40 08 04:18:15.100 WRITE FPDMA QUEUED
> 61 08 a8 88 52 cc 40 08 04:18:15.100 WRITE FPDMA QUEUED
> 61 08 a0 18 a4 ba 40 08 04:18:15.100 WRITE FPDMA QUEUED
>
>Error 24 occurred at disk power-on lifetime: 45285 hours (1886 days + 21 hours)
> When the command that caused the error occurred, the device was active or idle.
>
> After command completion occurred, registers were:
> ER ST SC SN CL CH DH
> -- -- -- -- -- -- --
> 84 51 01 01 00 00 00 Error: ICRC, ABRT at LBA = 0x00000001 = 1
>
> Commands leading to the command that caused the error were:
> CR FR SC SN CL CH DH DC Powered_Up_Time Command/Feature_Name
> -- -- -- -- -- -- -- -- ---------------- --------------------
> 61 80 30 f0 72 81 44 ff 02:44:11.000 WRITE FPDMA QUEUED
> 61 80 68 a0 70 81 40 08 02:44:10.200 WRITE FPDMA QUEUED
> 61 00 60 a0 6c 81 40 08 02:44:10.000 WRITE FPDMA QUEUED
> 61 a0 58 90 35 84 40 08 02:44:09.400 WRITE FPDMA QUEUED
> 61 00 50 90 31 84 40 08 02:44:09.400 WRITE FPDMA QUEUED
>
>Error 23 occurred at disk power-on lifetime: 45285 hours (1886 days + 21 hours)
> When the command that caused the error occurred, the device was active or idle.
>
> After command completion occurred, registers were:
> ER ST SC SN CL CH DH
> -- -- -- -- -- -- --
> 84 51 01 01 00 00 00 Error: ICRC, ABRT at LBA = 0x00000001 = 1
>
> Commands leading to the command that caused the error were:
> CR FR SC SN CL CH DH DC Powered_Up_Time Command/Feature_Name
> -- -- -- -- -- -- -- -- ---------------- --------------------
> 61 e0 c0 f9 c6 82 44 ff 02:43:54.600 WRITE FPDMA QUEUED
> 61 e0 78 00 d9 82 40 08 02:43:54.600 WRITE FPDMA QUEUED
> 61 60 70 98 d8 82 40 08 02:43:54.600 WRITE FPDMA QUEUED
> 61 e0 68 f8 cf 82 40 08 02:43:54.600 WRITE FPDMA QUEUED
> 61 00 60 f8 cb 82 40 08 02:43:54.600 WRITE FPDMA QUEUED
>
>Error 22 occurred at disk power-on lifetime: 45189 hours (1882 days + 21 hours)
> When the command that caused the error occurred, the device was active or idle.
>
> After command completion occurred, registers were:
> ER ST SC SN CL CH DH
> -- -- -- -- -- -- --
> 84 51 01 01 00 00 00 Error: ICRC, ABRT at LBA = 0x00000001 = 1
>
> Commands leading to the command that caused the error were:
> CR FR SC SN CL CH DH DC Powered_Up_Time Command/Feature_Name
> -- -- -- -- -- -- -- -- ---------------- --------------------
> 61 08 00 a0 3f b8 41 ff 1d+18:46:29.100 WRITE FPDMA QUEUED
> 61 08 20 08 3a be 40 08 1d+18:46:29.100 WRITE FPDMA QUEUED
> 61 08 18 88 88 bd 40 08 1d+18:46:29.100 WRITE FPDMA QUEUED
> 61 10 10 80 8a 1e 40 08 1d+18:46:29.100 WRITE FPDMA QUEUED
> 61 08 08 90 45 1e 40 08 1d+18:46:29.100 WRITE FPDMA QUEUED
>
>Error 21 occurred at disk power-on lifetime: 45176 hours (1882 days + 8 hours)
> When the command that caused the error occurred, the device was active or idle.
>
> After command completion occurred, registers were:
> ER ST SC SN CL CH DH
> -- -- -- -- -- -- --
> 84 51 01 01 00 00 00 Error: ICRC, ABRT at LBA = 0x00000001 = 1
>
> Commands leading to the command that caused the error were:
> CR FR SC SN CL CH DH DC Powered_Up_Time Command/Feature_Name
> -- -- -- -- -- -- -- -- ---------------- --------------------
> 61 20 00 60 05 c9 41 ff 1d+06:01:42.700 WRITE FPDMA QUEUED
> 61 20 d0 48 ab db 40 08 1d+06:01:42.700 WRITE FPDMA QUEUED
> 61 20 c8 40 05 c9 40 08 1d+06:01:42.700 WRITE FPDMA QUEUED
> 61 20 c0 b0 53 9e 40 08 1d+06:01:42.700 WRITE FPDMA QUEUED
> 61 20 b8 90 45 9e 40 08 1d+06:01:42.700 WRITE FPDMA QUEUED
>
>SMART Self-test log structure revision number 1
>Num Test_Description Status Remaining LifeTime(hours) LBA_of_first_error
># 1 Short offline Completed without error 00% 44549 -
># 2 Extended offline Interrupted (host reset) 90% 44548 -
># 3 Short offline Completed without error 00% 44548 -
># 4 Short offline Completed without error 00% 39672 -
># 5 Short offline Completed without error 00% 19768 -
># 6 Extended offline Aborted by host 60% 10947 -
># 7 Short offline Completed without error 00% 10896 -
># 8 Short offline Completed without error 00% 10838 -
># 9 Short offline Completed without error 00% 10838 -
>#10 Short offline Completed without error 00% 10838 -
>#11 Short offline Completed without error 00% 10838 -
>
>SMART Selective self-test log data structure revision number 1
> SPAN MIN_LBA MAX_LBA CURRENT_TEST_STATUS
> 1 0 0 Not_testing
> 2 0 0 Not_testing
> 3 0 0 Not_testing
> 4 0 0 Not_testing
> 5 0 0 Not_testing
>Selective self-test flags (0x0):
> After scanning selected spans, do NOT read-scan remainder of disk.
>If Selective self-test is pending on power-up, resume after 0 minute delay.
>
>
>
>Segun entiendo es usable.
Pues no sé qué decirte. Si entiendo bien la tabla, tu disco tiene
capacidad para realojar 5 sectores defectuosos, y la cuenta va ya por
21. Tiene también 25 errores contados, mantiene el registro de los
últimos 5, y estos se suceden en horas o días.
Saludos.
--
Manolo Díaz
Reply to: