How to diagnose DCA controller x status: error: degraded
Post date: Nov 07, 2012 9:38:24 PM
To diagnose controller issues,Run the following commands and look at the output.
omreport system esmlog
omreport system alertlog
omreport storage battery
omreport storage pdisk controller=0
omreport storage vdisk
cat /etc/gpdb-appliance-version
omreport storage controller
For example
[gpadmin@mdw ~]$ omreport system esmlog
Embedded System Management (ESM) Log
Health : Ok
Severity : Ok
Date and Time : Wed Jul 13 17:50:45 2011
Description : Log cleared.
Severity : Ok
Date and Time : Wed Jul 13 17:51:08 2011
Description : This is an OEM record.
Severity : Ok
Date and Time : Wed Jul 13 17:51:08 2011
Description : An OS graceful shut-down occured.
*********************************************************************************************
[gpadmin@mdw ~]$ omreport storage battery
List of Batteries in the System
Controller PERC H700 Integrated (Slot Embedded)
ID : 0
Status : Ok
Name : Battery 0
State : Ready
Recharge Count : Not Applicable
Max Recharge Count : Not Applicable
Predicted Capacity Status : Ready
Learn State : Idle
Next Learn Time : 82 days 20 hours
Maximum Learn Delay : 7 days 0 hours
Learn Mode : Auto
*******************************************************************************************
[gpadmin@mdw ~]$ omreport storage pdisk controller=0
List of Physical Disks on Controller PERC H700 Integrated (Embedded)
Controller PERC H700 Integrated (Embedded)
ID : 0:0:0
Status : Ok
Name : Physical Disk 0:0:0
State : Online
Power Status : Spun Up
Bus Protocol : SAS
Media : HDD
Revision : FM08
Failure Predicted : No
Certified : Yes
Encryption Capable : No
Encrypted : Not Applicable
Progress : Not Applicable
Mirror Set ID : Not Applicable
Capacity : 558.38 GB (599550590976 bytes)
Used RAID Disk Space : 558.38 GB (599550590976 bytes)
Available RAID Disk Space : 0.00 GB (0 bytes)
Hot Spare : No
Vendor ID : DELL(tm)
Product ID : ST9600204SS
Serial No. : 3WN0GSYQ
Part Number : SG07T0DW125310BP02H1A00
Negotiated Speed : 6.00 Gbps
Capable Speed : 6.00 Gbps
Manufacture Day : 07
Manufacture Week : 48
Manufacture Year : 2010
SAS Address : 5000C50028C725B1
ID : 0:0:1
Status : Ok
Name : Physical Disk 0:0:1
State : Online
Power Status : Spun Up
Bus Protocol : SAS
Media : HDD
Revision : FM08
Failure Predicted : No
Certified : Yes
Encryption Capable : No
Encrypted : Not Applicable
Progress : Not Applicable
Mirror Set ID : Not Applicable
Capacity : 558.38 GB (599550590976 bytes)
Used RAID Disk Space : 558.38 GB (599550590976 bytes)
Available RAID Disk Space : 0.00 GB (0 bytes)
Hot Spare : No
Vendor ID : DELL(tm)
Product ID : ST9600204SS
Serial No. : 3WN0GTQK
Part Number : SG07T0DW125310BP018SA00
Negotiated Speed : 6.00 Gbps
Capable Speed : 6.00 Gbps
Manufacture Day : 07
Manufacture Week : 48
Manufacture Year : 2010
SAS Address : 5000C50028C70169
ID : 0:0:2
Status : Ok
Name : Physical Disk 0:0:2
State : Online
Power Status : Spun Up
Bus Protocol : SAS
Media : HDD
Revision : FM08
Failure Predicted : No
Certified : Yes
Encryption Capable : No
Encrypted : Not Applicable
Progress : Not Applicable
Mirror Set ID : Not Applicable
Capacity : 558.38 GB (599550590976 bytes)
Used RAID Disk Space : 558.38 GB (599550590976 bytes)
Available RAID Disk Space : 0.00 GB (0 bytes)
Hot Spare : No
Vendor ID : DELL(tm)
Product ID : ST9600204SS
Serial No. : 3WN0GTP4
Part Number : SG07T0DW125310BP0175A00
Negotiated Speed : 6.00 Gbps
Capable Speed : 6.00 Gbps
Manufacture Day : 07
Manufacture Week : 48
Manufacture Year : 2010
SAS Address : 5000C50028C70069
ID : 0:0:3
Status : Ok
Name : Physical Disk 0:0:3
State : Online
Power Status : Spun Up
Bus Protocol : SAS
Media : HDD
Revision : FM08
Failure Predicted : No
Certified : Yes
Encryption Capable : No
Encrypted : Not Applicable
Progress : Not Applicable
Mirror Set ID : Not Applicable
Capacity : 558.38 GB (599550590976 bytes)
Used RAID Disk Space : 558.38 GB (599550590976 bytes)
Available RAID Disk Space : 0.00 GB (0 bytes)
Hot Spare : No
Vendor ID : DELL(tm)
Product ID : ST9600204SS
Serial No. : 3WN0GSTC
Part Number : SG07T0DW125310BP02D0A00
Negotiated Speed : 6.00 Gbps
Capable Speed : 6.00 Gbps
Manufacture Day : 07
Manufacture Week : 48
Manufacture Year : 2010
SAS Address : 5000C50028C72389
ID : 1:0:4
Status : Ok
Name : Physical Disk 1:0:4
State : Online
Power Status : Spun Up
Bus Protocol : SAS
Media : HDD
Revision : FM08
Failure Predicted : No
Certified : Yes
Encryption Capable : No
Encrypted : Not Applicable
Progress : Not Applicable
Mirror Set ID : Not Applicable
Capacity : 558.38 GB (599550590976 bytes)
Used RAID Disk Space : 558.38 GB (599550590976 bytes)
Available RAID Disk Space : 0.00 GB (0 bytes)
Hot Spare : No
Vendor ID : DELL(tm)
Product ID : ST9600204SS
Serial No. : 3WN0G0X5
Part Number : SG07T0DW125310BP01BLA00
Negotiated Speed : 6.00 Gbps
Capable Speed : 6.00 Gbps
Manufacture Day : 07
Manufacture Week : 48
Manufacture Year : 2010
SAS Address : 5000C50028C7068D
ID : 1:0:5
Status : Ok
Name : Physical Disk 1:0:5
State : Ready
Power Status : Spun Up
Bus Protocol : SAS
Media : HDD
Revision : FM08
Failure Predicted : No
Certified : Yes
Encryption Capable : No
Encrypted : Not Applicable
Progress : Not Applicable
Mirror Set ID : Not Applicable
Capacity : 558.38 GB (599550590976 bytes)
Used RAID Disk Space : 558.38 GB (599550590976 bytes)
Available RAID Disk Space : 0.00 GB (0 bytes)
Hot Spare : Global
Vendor ID : DELL(tm)
Product ID : ST9600204SS
Serial No. : 3WN0GV1P
Part Number : SG07T0DW125310BP01LYA00
Negotiated Speed : 6.00 Gbps
Capable Speed : 6.00 Gbps
Manufacture Day : 07
Manufacture Week : 48
Manufacture Year : 2010
SAS Address : 5000C50028C70D59
*********************************************************************************************
[gpadmin@mdw ~]$ omreport storage vdisk
List of Virtual Disks in the System
Controller PERC H700 Integrated (Embedded)
ID : 0
Status : Ok
Name : boot
State : Ready
Encrypted : Not Applicable
Layout : RAID-5
Size : 48.00 GB (51539607552 bytes)
Device Name : /dev/sda
Bus Protocol : SAS
Media : HDD
Read Policy : Adaptive Read Ahead
Write Policy : Write Back
Cache Policy : Not Applicable
Stripe Element Size : 128 KB
Disk Cache Policy : Disabled
ID : 1
Status : Ok
Name : swap
State : Ready
Encrypted : Not Applicable
Layout : RAID-5
Size : 48.00 GB (51539607552 bytes)
Device Name : /dev/sdb
Bus Protocol : SAS
Media : HDD
Read Policy : Adaptive Read Ahead
Write Policy : Write Back
Cache Policy : Not Applicable
Stripe Element Size : 128 KB
Disk Cache Policy : Disabled
ID : 2
Status : Ok
Name : data
State : Ready
Encrypted : Not Applicable
Layout : RAID-5
Size : 2,137.50 GB (2295123148800 bytes)
Device Name : /dev/sdc
Bus Protocol : SAS
Media : HDD
Read Policy : Adaptive Read Ahead
Write Policy : Write Back
Cache Policy : Not Applicable
Stripe Element Size : 128 KB
Disk Cache Policy : Disabled
**********************************************************************************************
[gpadmin@mdw ~]$ cat /etc/gpdb-appliance-version
1.2.0.0s
*********************************************************************************************
[gpadmin@mdw ~]$ omreport storage controller
Controller PERC H700 Integrated (Embedded)
Controllers
ID : 0
Status : Ok
Name : PERC H700 Integrated
Slot ID : Embedded
State : Ready
Firmware Version : 12.10.2-0004
Minimum Required Firmware Version : Not Applicable
Driver Version : 00.00.05.38-rh1
Minimum Required Driver Version : Not Applicable
Storport Driver Version : Not Applicable
Minimum Required Storport Driver Version : Not Applicable
Number of Connectors : 2
Rebuild Rate : 30%
BGI Rate : 30%
Check Consistency Rate : 30%
Reconstruct Rate : 30%
Alarm State : Not Applicable
Cluster Mode : Not Applicable
SCSI Initiator ID : Not Applicable
Cache Memory Size : 512 MB
Patrol Read Mode : Auto
Patrol Read State : Stopped
Patrol Read Rate : 30%
Patrol Read Iterations : 5
Abort Check Consistency on Error : Disabled
Allow Revertible Hot Spare and Replace Member : Enabled
Load Balance : Not Applicable
Auto Replace Member on Predictive Failure : Disabled
Redundant Path view : Not Applicable
CacheCade Capable : Not Applicable
Persistent Hot Spare : Disabled
Encryption Capable : Yes
Encryption Key Present : No
Encryption Mode : None
Spin Down Unconfigured Drives : Disabled
Spin Down Hot Spares : Disabled