input/out error and bad file descriptors

Running a WHM/CPanel 6.4.2 server which had the below problem, updating to latest right now and still same problem

WHM 7.2.0 cPanel 7.2.1-S67
RedHat 7.3 - WHM X v2.1
Apache 1.3.28
Linuxe 2.4.20-18.7smp
PHP 4.3.2
MySQL 4.0.13

Dual AthlonMP 2000+
2GB PC2100 DDRAM ECC
2x 18GB 10k IBM SCSI
1x 80GB EIDE

I've tried recompiling apache using easyapache options 1 through to 6 as well

Problem 1. apache keeps gracefully restarting everyone few minutes

Problem 2.

My vBulletin word table corrupted and trying to repair it with mysqlcheck resulted in:
Code: 
mysqlcheck -s vbdbname word

vbdbname.word
warning  : Table is marked as crashed and last repair failed
warning  : Size of indexfile is: 18095104      Should be: 10494976
error    : Record at pos: 39392595 is not remove-marked
error    : record delete-link-chain corrupted
error    : Corrupt
trying to use mysqlcheck to repair it I get an error about bad file descriptors
Code: 
mysqlcheck -r vbdbname word

vbdbname.word
warning  : Duplicate key for record at 39392595 against record at 83820
error    : 5 when fixing table
error    : Can't copy datafile-header to tempfile, error 9
status   : Operation failed
----------------------------
my server current has the following limits
Code: 
ulimit -aS
core file size        (blocks, -c) 0
data seg size         (kbytes, -d) unlimited
file size             (blocks, -f) unlimited
max locked memory     (kbytes, -l) unlimited
max memory size       (kbytes, -m) unlimited
open files                    (-n) 1024
pipe size          (512 bytes, -p) 8
stack size            (kbytes, -s) 8192
cpu time             (seconds, -t) unlimited
max user processes            (-u) 7168
virtual memory        (kbytes, -v) unlimite


ulimit -aH
core file size        (blocks, -c) unlimited
data seg size         (kbytes, -d) unlimited
file size             (blocks, -f) unlimited
max locked memory     (kbytes, -l) unlimited
max memory size       (kbytes, -m) unlimited
open files                    (-n) 1024
pipe size          (512 bytes, -p) 8
stack size            (kbytes, -s) unlimited
cpu time             (seconds, -t) unlimited
max user processes            (-u) 7168
virtual memory        (kbytes, -v) unlimited

lsof | grep httpd | wc -l

returns = 8369
----------------------------
So i wanted to attempt myisamchk repair by first shutting down mysql, and copying the actual database data files for backup but i get an error in the same word table, it gives me:
Code: 
reading `vbdbname/word.MYI': Input/output error
after the input/output error showed itself, I checked database sizes for original and backup
Code: 
du /var/lib/mysql/vbdbname
1435964 

du /home/mysql190703/data/vbdbname-bak
1428532
------------------

In my apache error log i'm getting errors after i just updated from Apache 1.3.27 to 1.3.28 via WHM/CPanel /scripts/easyapache

error listed are:
[Sat Jul 19 03:10:00 2003] [error] mod_ssl: Cannot open SSLSessionCache DBM file `/usr/local/apache/logs/ssl_scache' for status retrival (System error follows)
[Sat Jul 19 03:10:00 2003] [error] System: No such file or directory (errno: 2)
[Sat Jul 19 03:10:15 2003] [notice] caught SIGTERM, shutting down
Apache seems to be gracefully restarting every few minutes input/out error and bad file descriptors

-----
trying to do myisamchk repair while mysql was shutdown, resulted in same error no5 : input/output error

check resulted in
Code: 
/usr/bin/myisamchk -s /var/lib/mysql/vbdbname/word.MYI
myisamchk: MyISAM file /var/lib/mysql/vbdbname/word.MYI
myisamchk: warning: Table is marked as crashed and last repair failed
myisamchk: warning: Size of indexfile is: 18095104      Should be: 10494976
myisamchk: error: Record at pos: 39392595 is not remove-marked
myisamchk: error: record delete-link-chain corrupted
myisamchk: error: Found 716628 keys of 716627
MyISAM-table '/var/lib/mysql/vbdbname/word.MYI' is corrupted
Fix it using switch "-r" or "-o"
repair didn't work
Code: 
/usr/bin/myisamchk -r /var/lib/mysql/vbdbname/word.MYI
- recovering (with sort) MyISAM-table '/var/lib/mysql/vbdbname/word.MYI'
Data records: 716627
- Fixing index 1
- Fixing index 2
myisamchk: warning: Duplicate key for record at   39392595 against record at      83820
/usr/bin/myisamchk: Error writing file '/var/lib/mysql/vbdbname/word.MYI' (Errcode: 5)
myisamchk: error: 5 when fixing table
MyISAM-table '/var/lib/mysql/vbdbname/word.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o) or the --force (-f) option
repair using safe recover mode didn't work
Code: 
/usr/bin/myisamchk -o /var/lib/mysql/vbdbname/word.MYI
- recovering (with keycache) MyISAM-table '/var/lib/mysql/vbdbname/word.MYI'
Data records: 716627
Duplicate key  2 for record at   39392595 against new record at      83820
myisamchk: warning: 1 records have been removed
myisamchk: error: 5 when trying to write bufferts
MyISAM-table '/var/lib/mysql/vbdbname/word.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o) or the --force (-f) option
-----
so is this actual filesystem or hard drive problem/corruption with the input/out error ??

this is the first time I ever experienced this problem input/out error and bad file descriptors

 

 

 

 

Top