LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 10-22-2006, 08:45 AM   #1
jalla
Member
 
Registered: Oct 2003
Posts: 33

Rep: Reputation: 15
disk troubleshooting


Hi,

We are running Oracle DB in RHEL (with raid 5) and having problems with disk performance. It takes ages for some queries and I suspect we have a problem with the disk hardware, because one of the disks crash and we replaced it and performance problems began after that. Why I think its not related to oracle and queries is that the same database dump on windows box does not have any performance problems and query execution is very fast.

I see a lot of errors in /var/log/messages

Code:
Oct 22 14:28:44 locdb kernel: hda: tray open
Oct 22 14:28:45 locdb kernel: end_request: I/O error, dev 03:00 (hda), sector 4
Oct 22 14:28:45 locdb kernel: hda: tray open
Oct 22 14:28:45 locdb kernel: end_request: I/O error, dev 03:00 (hda), sector 6
When I try to test wiht hdparm I get:
Code:
[root@locdb root]# hdparm -Tt /dev/hda

/dev/hda:
read() failed: Input/output error
 Timing buffered disk reads:  read() failed: Input/output error
Would appreciate any troubleshooting tips for a newbie here.

Thanks.
-T
 
Old 10-23-2006, 02:04 AM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,965
Blog Entries: 11

Rep: Reputation: 865Reputation: 865Reputation: 865Reputation: 865Reputation: 865Reputation: 865Reputation: 865
What's the hardware that you're running that RAID-5 on? hda doesn't look
like any array I've ever seen.


Cheers,
Tink
 
Old 10-23-2006, 02:56 AM   #3
timmeke
Senior Member
 
Registered: Nov 2005
Location: Belgium
Distribution: Red Hat, Fedora
Posts: 1,515

Rep: Reputation: 61
I'm no expert with RAID volumes, but doesn't "tray open" suggest that you didn't insert the replacement disk properly and for instance accidentally left a lock (that holds the disk in place) open/unlocked?
Your drive/device may detect this and consider the unfixed drive as "unusable". Of course, RAID can compensate for this, but with some performance loss (just like if you had a faulty disk). So it would explain your symptoms, no?
 
Old 10-23-2006, 03:40 AM   #4
jalla
Member
 
Registered: Oct 2003
Posts: 33

Original Poster
Rep: Reputation: 15
Tinkster, thanks and: How do I check that? When I run fdisk nothing happens:
Code:
[root@locdb root]# fdisk -l
[root@locdb root]#
Output from df -h:

Code:
[root@locdb root]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/rd/c0d0p2        6.8G  5.7G  770M  89% /
/dev/rd/c0d0p1         99M   14M   80M  15% /boot
none                  502M     0  502M   0% /dev/shm
/dev/rd/c0d0p3        2.9G  1.3G  1.5G  48% /var
/dev/rd/c0d0p6        3.8G  3.4G  209M  95% /u01/app/oracle
/dev/rd/c0d0p7         36G   25G  8.5G  75% /u01/app/oracle/oradata
[root@locdb root]#
First I thought it was a software RAID,
Code:
[root@locdb root]# ps  waux | grep mdad
root      3173  0.0  0.0  1592  148 ?        S    Sep17   0:00 mdadm --monitor --scan -f
root     27471  0.0  0.0  3684  696 pts/0    S    09:30   0:00 grep mdad
[root@locdb root]#
But the output from lspci shows that there is a hardware in there (RAID bus controller)

The output from lspci:
Code:
[root@locdb root]# lspci
00:00.0 Host bridge: Intel Corp. 82845G/GL[Brookdale-G]/GE/PE DRAM Controller/Host-Hub Interface (rev 03)
00:02.0 VGA compatible controller: Intel Corp. 82845G/GL[Brookdale-G]/GE Chipset Integrated Graphics Device (rev 03)
00:1d.0 USB Controller: Intel Corp. 82801DB/DBL/DBM (ICH4/ICH4-L/ICH4-M) USB UHCI Controller #1 (rev 02)
00:1d.1 USB Controller: Intel Corp. 82801DB/DBL/DBM (ICH4/ICH4-L/ICH4-M) USB UHCI Controller #2 (rev 02)
00:1d.2 USB Controller: Intel Corp. 82801DB/DBL/DBM (ICH4/ICH4-L/ICH4-M) USB UHCI Controller #3 (rev 02)
00:1d.7 USB Controller: Intel Corp. 82801DB/DBM (ICH4/ICH4-M) USB 2.0 EHCI Controller (rev 02)
00:1e.0 PCI bridge: Intel Corp. 82801BA/CA/DB/EB/ER Hub interface to PCI Bridge (rev 82)
00:1f.0 ISA bridge: Intel Corp. 82801DB/DBL (ICH4/ICH4-L) LPC Bridge (rev 02)
00:1f.1 IDE interface: Intel Corp. 82801DB/DBL (ICH4/ICH4-L) UltraATA-100 IDE Controller (rev 02)
00:1f.3 SMBus: Intel Corp. 82801DB/DBL/DBM (ICH4/ICH4-L/ICH4-M) SMBus Controller (rev 02)
00:1f.5 Multimedia audio controller: Intel Corp. 82801DB/DBL/DBM (ICH4/ICH4-L/ICH4-M) AC'97 Audio Controller (rev 02)
01:05.0 PCI bridge: Intel Corp. 80960RM [i960RM Bridge] (rev 02)
01:05.1 RAID bus controller: Mylex Corporation AcceleRAID 352/170/160 support Device (rev 02)
01:08.0 Ethernet controller: Intel Corp. 82801BD PRO/100 VE (CNR) Ethernet Controller (rev 82)
[root@locdb root]#
 
Old 10-23-2006, 12:20 PM   #5
jalla
Member
 
Registered: Oct 2003
Posts: 33

Original Poster
Rep: Reputation: 15
Think it is hardware raid, because /etc/mdadm.conf is almost empty, only email address is set there. How do I check each disk for error?
 
Old 10-23-2006, 12:39 PM   #6
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,965
Blog Entries: 11

Rep: Reputation: 865Reputation: 865Reputation: 865Reputation: 865Reputation: 865Reputation: 865Reputation: 865
Hmmm ... if you have SCSI disks on the Mylex the hda makes even less
sense. I'd suggest you get some local Linux expert with RAID experience
in to check this out - from the output above I can't really assess anything,
plus I'm not that familiar with Mylex controllers (the last time I saw one
was about 8 years ago). If this was a box at my workplace I'd schedule an
outage and look at the RAID via a) the Mylex' BIOS tools or b) with a service
CD (assuming that Mylex provides similar things to IBMs ServeRAID controllers).

If you're using hardware RAID mdadm shouldn't be running. And the fact
that fdisk -l doesn't output anything (you DID do that as root, right?) is a
major worry. :}


Cheers,
Tink
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Asterisk troubleshooting procfs Linux - Software 2 07-21-2006 05:48 AM
floppy only reads first disk, if new disk is inserted data from first disk is shown. lakosked Debian 3 02-18-2006 08:44 PM
troubleshooting how-to? chilehead Linux - Hardware 2 02-06-2005 04:58 PM
PHP Troubleshooting merana Programming 6 01-03-2005 04:08 PM
Samba troubleshooting BaWL Linux - Networking 8 05-09-2002 04:30 PM


All times are GMT -5. The time now is 12:49 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration