From: Serge Sozonoff
Date: November 7 2000 4:38pm
Subject: isamchk behavoir
List-Archive: http://lists.mysql.com/internals/103
Message-Id: <27404B604041D411AE8F00010219959F22B4C1@mail1.globalbeach.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"

Hello all,

I have a problem with isamchk I can't figure out, I am running the
following:

Redhat 7.0
with following patches
glibc-2.1.94-3.i686.rpm
gnupg-1.04-5.i386.rpm
iputils-20001010-1.i386.rpm
tmpwatch-2.6.2-1.7.i386.rpm

mysql Version 3.22.32


Thanks for any help, Serge


** This is the error when I run: isamchk /usr/local/var/mysql/*.ISM **

isamchk: error: 22 when opening ISAM-table
'/usr/local/var/mysql/columns_priv.ISM'

---------

isamchk: error: 22 when opening ISAM-table '/usr/local/var/mysql/db.ISM'

---------

isamchk: error: 22 when opening ISAM-table '/usr/local/var/mysql/func.ISM'

---------

isamchk: error: 22 when opening ISAM-table '/usr/local/var/mysql/host.ISM'

---------

isamchk: error: 22 when opening ISAM-table
'/usr/local/var/mysql/tables_priv.ISM'

---------

isamchk: error: 22 when opening ISAM-table '/usr/local/var/mysql/user.ISM'


------------------- strace output below ----------------------------------

[root@webbox bin]# ./strace isamchk /usr/local/var/mysql/*.ISM
execve("/usr/local/bin/isamchk", ["isamchk",
"/usr/local/var/mysql/columns_priv.ISM", "/usr/local/var/mysql/db.ISM",
"/usr/local/var/mysql/func.ISM", "/usr/local/var/mysql/host.ISM",
"/usr/local/var/mysql/tables_priv.ISM", "/usr/local/var/mysql/user.ISM"],
[/* 23 vars */]) = 0
uname({sys="Linux", node="webbox", ...}) = 0
brk(0)                                  = 0x806beac
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x40017000
open("/etc/ld.so.preload", O_RDONLY)    = -1 ENOENT (No such file or
directory)
open("/etc/ld.so.cache", O_RDONLY)      = 3
fstat64(3, 0xbffff10c)                  = -1 ENOSYS (Function not
implemented)
fstat(3, {st_mode=S_IFREG|0644, st_size=31352, ...}) = 0
old_mmap(NULL, 31352, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40018000
close(3)                                = 0
open("/lib/libdl.so.2", O_RDONLY)       = 3
fstat(3, {st_mode=S_IFREG|0755, st_size=58734, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0P\34\0\000"...,
4096) = 4096
old_mmap(NULL, 12268, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40020000
mprotect(0x40022000, 4076, PROT_NONE)   = 0
old_mmap(0x40022000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x1000) = 0x40022000
close(3)                                = 0
open("/lib/libnsl.so.1", O_RDONLY)      = 3
fstat(3, {st_mode=S_IFREG|0755, st_size=381641, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0 ?\0\000"..., 4096)
= 4096
old_mmap(NULL, 90432, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40023000
mprotect(0x40036000, 12608, PROT_NONE)  = 0
old_mmap(0x40036000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x12000) = 0x40036000
old_mmap(0x40037000, 8512, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40037000
close(3)                                = 0
open("/lib/libm.so.6", O_RDONLY)        = 3
fstat(3, {st_mode=S_IFREG|0755, st_size=502643, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20J\0\000"...,
4096) = 4096
old_mmap(NULL, 128744, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x4003a000
mprotect(0x40059000, 1768, PROT_NONE)   = 0
old_mmap(0x40059000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x1e000) = 0x40059000
close(3)                                = 0
open("/usr/lib/libz.so.1", O_RDONLY)    = 3
fstat(3, {st_mode=S_IFREG|0755, st_size=58940, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0000\36\0"..., 4096)
= 4096
old_mmap(NULL, 54064, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x4005a000
mprotect(0x40066000, 4912, PROT_NONE)   = 0
old_mmap(0x40066000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0xb000) = 0x40066000
close(3)                                = 0
open("/lib/libcrypt.so.1", O_RDONLY)    = 3
fstat(3, {st_mode=S_IFREG|0755, st_size=81044, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\320\17"..., 4096) =
4096
old_mmap(NULL, 184124, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40068000
mprotect(0x4006d000, 163644, PROT_NONE) = 0
old_mmap(0x4006d000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x4000) = 0x4006d000
old_mmap(0x4006e000, 159548, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4006e000
close(3)                                = 0
open("/lib/libpthread.so.0", O_RDONLY)  = 3
fstat(3, {st_mode=S_IFREG|0755, st_size=465899, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0@O\0\000"..., 4096)
= 4096
old_mmap(NULL, 89048, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40095000
mprotect(0x400a3000, 31704, PROT_NONE)  = 0
old_mmap(0x400a3000, 32768, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0xd000) = 0x400a3000
close(3)                                = 0
open("/lib/libc.so.6", O_RDONLY)        = 3
fstat(3, {st_mode=S_IFREG|0755, st_size=4796386, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0P\277\1"..., 4096) =
4096
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x400ab000
old_mmap(NULL, 1203880, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x400ac000
mprotect(0x401c9000, 36520, PROT_NONE)  = 0
old_mmap(0x401c9000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x11c000) = 0x401c9000
old_mmap(0x401ce000, 16040, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x401ce000
close(3)                                = 0
mprotect(0x4005a000, 49152, PROT_READ|PROT_WRITE) = 0
mprotect(0x4005a000, 49152, PROT_READ|PROT_EXEC) = 0
munmap(0x40018000, 31352)               = 0
getpid()                                = 1073
getpid()                                = 1073
rt_sigaction(SIGRT_0, {0x4009e8f0, [], 0x4000000}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {0x4009de00, [], 0x4000000}, NULL, 8) = 0
rt_sigaction(SIGRT_2, {0x4009e980, [], 0x4000000}, NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [RT_0], NULL, 8) = 0
_sysctl({{CTL_KERN, KERN_VERSION}, 2, 0xbffff6bc, 31, (nil), 0}) = 0
brk(0)                                  = 0x806beac
brk(0x806bedc)                          = 0x806bedc
brk(0x806c000)                          = 0x806c000
brk(0x806d000)                          = 0x806d000
open("/etc/my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or
directory)
open("/usr/local/var/my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such
file or directory)
open("/root/.my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or
directory)
ioctl(1, TCGETS, {B38400 opost isig icanon echo ...}) = 0
lstat64("/usr", 0xbfffdec0)             = -1 ENOSYS (Function not
implemented)
lstat("/usr", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
lstat("/usr/local", {st_mode=S_IFDIR|S_ISGID|0755, st_size=4096, ...}) = 0
lstat("/usr/local/var", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
lstat("/usr/local/var/mysql", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
lstat("/usr/local/var/mysql/columns_priv.ISM", {st_mode=S_IFREG|0660,
st_size=1024, ...}) = 0
open("/usr/local/var/mysql/columns_priv.ISM", O_RDWR|O_LARGEFILE) = 3
read(3, "\376\376\5\2\2\0\352\2\310\0\234\0\0\2\0\0", 16) = 16
_llseek(3, 0, [0], SEEK_SET)            = 0
fcntl64(3, 0xd /* F_??? */, 0x806bb40)  = -1 ENOSYS (Function not
implemented)
fcntl(3, 0xd /* F_??? */, 0xbfffee60)   = -1 EINVAL (Invalid argument)
alarm(2)                                = 0
rt_sigaction(SIGALRM, {0x4009efe0, [ALRM], SA_RESTART|0x4000000}, {SIG_DFL},
8) = 0
fcntl(3, 0xe /* F_??? */, 0xbfffee60)   = -1 EINVAL (Invalid argument)
rt_sigaction(SIGALRM, {SIG_DFL}, {0x4009efe0, [ALRM], SA_RESTART|0x4000000},
8) = 0
alarm(0)                                = 2
close(3)                                = 0
write(2, "isamchk: error: ", 16isamchk: error: )        = 16
write(2, "22 when opening ISAM-table \'/usr"..., 6622 when opening
ISAM-table '/usr/local/var/mysql/columns_priv.ISM') = 66
write(2, "\n", 1
)                       = 1
fstat(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 1), ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x40018000
ioctl(1, TCGETS, {B38400 opost isig icanon echo ...}) = 0
write(1, "\n", 1
)                       = 1
write(1, "---------\n", 10---------
)             = 10
write(1, "\n", 1
)                       = 1
lstat("/usr", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
lstat("/usr/local", {st_mode=S_IFDIR|S_ISGID|0755, st_size=4096, ...}) = 0
lstat("/usr/local/var", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
lstat("/usr/local/var/mysql", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
lstat("/usr/local/var/mysql/db.ISM", {st_mode=S_IFREG|0660, st_size=3072,
...}) = 0
open("/usr/local/var/mysql/db.ISM", O_RDWR|O_LARGEFILE) = 3
read(3, "\376\376\5\2\2\0\f\3\310\0\234\0\0\2\0\0", 16) = 16
_llseek(3, 0, [0], SEEK_SET)            = 0
fcntl(3, 0xd /* F_??? */, 0xbfffee40)   = -1 EINVAL (Invalid argument)
alarm(2)                                = 0
rt_sigaction(SIGALRM, {0x4009efe0, [ALRM], SA_RESTART|0x4000000}, {SIG_DFL},
8) = 0
fcntl(3, 0xe /* F_??? */, 0xbfffee40)   = -1 EINVAL (Invalid argument)
rt_sigaction(SIGALRM, {SIG_DFL}, {0x4009efe0, [ALRM], SA_RESTART|0x4000000},
8) = 0
alarm(0)                                = 2
close(3)                                = 0
write(2, "isamchk: error: ", 16isamchk: error: )        = 16
write(2, "22 when opening ISAM-table \'/usr"..., 5622 when opening
ISAM-table '/usr/local/var/mysql/db.ISM') = 56
write(2, "\n", 1
)                       = 1
write(1, "\n---------\n", 11
---------
)           = 11
write(1, "\n", 1
)                       = 1
lstat("/usr", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
lstat("/usr/local", {st_mode=S_IFDIR|S_ISGID|0755, st_size=4096, ...}) = 0
lstat("/usr/local/var", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
lstat("/usr/local/var/mysql", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
lstat("/usr/local/var/mysql/func.ISM", {st_mode=S_IFREG|0660, st_size=1024,
...}) = 0
open("/usr/local/var/mysql/func.ISM", O_RDWR|O_LARGEFILE) = 3
read(3, "\376\376\5\2\2\0\306\2\310\0\234\0\0\2\0\0", 16) = 16
_llseek(3, 0, [0], SEEK_SET)            = 0
fcntl(3, 0xd /* F_??? */, 0xbfffee80)   = -1 EINVAL (Invalid argument)
alarm(2)                                = 0
rt_sigaction(SIGALRM, {0x4009efe0, [ALRM], SA_RESTART|0x4000000}, {SIG_DFL},
8) = 0
fcntl(3, 0xe /* F_??? */, 0xbfffee80)   = -1 EINVAL (Invalid argument)
rt_sigaction(SIGALRM, {SIG_DFL}, {0x4009efe0, [ALRM], SA_RESTART|0x4000000},
8) = 0
alarm(0)                                = 2
close(3)                                = 0
write(2, "isamchk: error: ", 16isamchk: error: )        = 16
write(2, "22 when opening ISAM-table \'/usr"..., 5822 when opening
ISAM-table '/usr/local/var/mysql/func.ISM') = 58
write(2, "\n", 1
)                       = 1
write(1, "\n---------\n", 11
---------
)           = 11
write(1, "\n", 1
)                       = 1
lstat("/usr", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
lstat("/usr/local", {st_mode=S_IFDIR|S_ISGID|0755, st_size=4096, ...}) = 0
lstat("/usr/local/var", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
lstat("/usr/local/var/mysql", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
lstat("/usr/local/var/mysql/host.ISM", {st_mode=S_IFREG|0660, st_size=1024,
...}) = 0
open("/usr/local/var/mysql/host.ISM", O_RDWR|O_LARGEFILE) = 3
read(3, "\376\376\5\2\2\0\354\2\310\0\234\0\0\2\0\0", 16) = 16
_llseek(3, 0, [0], SEEK_SET)            = 0
fcntl(3, 0xd /* F_??? */, 0xbfffee60)   = -1 EINVAL (Invalid argument)
alarm(2)                                = 0
rt_sigaction(SIGALRM, {0x4009efe0, [ALRM], SA_RESTART|0x4000000}, {SIG_DFL},
8) = 0
fcntl(3, 0xe /* F_??? */, 0xbfffee60)   = -1 EINVAL (Invalid argument)
rt_sigaction(SIGALRM, {SIG_DFL}, {0x4009efe0, [ALRM], SA_RESTART|0x4000000},
8) = 0
alarm(0)                                = 2
close(3)                                = 0
write(2, "isamchk: error: ", 16isamchk: error: )        = 16
write(2, "22 when opening ISAM-table \'/usr"..., 5822 when opening
ISAM-table '/usr/local/var/mysql/host.ISM') = 58
write(2, "\n", 1
)                       = 1
write(1, "\n---------\n", 11
---------
)           = 11
write(1, "\n", 1
)                       = 1
lstat("/usr", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
lstat("/usr/local", {st_mode=S_IFDIR|S_ISGID|0755, st_size=4096, ...}) = 0
lstat("/usr/local/var", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
lstat("/usr/local/var/mysql", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
lstat("/usr/local/var/mysql/tables_priv.ISM", {st_mode=S_IFREG|0660,
st_size=1024, ...}) = 0
open("/usr/local/var/mysql/tables_priv.ISM", O_RDWR|O_LARGEFILE) = 3
read(3, "\376\376\5\2\2\0\376\2\310\0\234\0\0\2\0\0", 16) = 16
_llseek(3, 0, [0], SEEK_SET)            = 0
fcntl(3, 0xd /* F_??? */, 0xbfffee50)   = -1 EINVAL (Invalid argument)
alarm(2)                                = 0
rt_sigaction(SIGALRM, {0x4009efe0, [ALRM], SA_RESTART|0x4000000}, {SIG_DFL},
8) = 0
fcntl(3, 0xe /* F_??? */, 0xbfffee50)   = -1 EINVAL (Invalid argument)
rt_sigaction(SIGALRM, {SIG_DFL}, {0x4009efe0, [ALRM], SA_RESTART|0x4000000},
8) = 0
alarm(0)                                = 2
close(3)                                = 0
write(2, "isamchk: error: ", 16isamchk: error: )        = 16
write(2, "22 when opening ISAM-table \'/usr"..., 6522 when opening
ISAM-table '/usr/local/var/mysql/tables_priv.ISM') = 65
write(2, "\n", 1
)                       = 1
write(1, "\n---------\n", 11
---------
)           = 11
write(1, "\n", 1
)                       = 1
lstat("/usr", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
lstat("/usr/local", {st_mode=S_IFDIR|S_ISGID|0755, st_size=4096, ...}) = 0
lstat("/usr/local/var", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
lstat("/usr/local/var/mysql", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
lstat("/usr/local/var/mysql/user.ISM", {st_mode=S_IFREG|0660, st_size=2048,
...}) = 0
open("/usr/local/var/mysql/user.ISM", O_RDWR|O_LARGEFILE) = 3
read(3, "\376\376\5\2\2\0\0\3\310\0\234\0\0\2\0\0", 16) = 16
_llseek(3, 0, [0], SEEK_SET)            = 0
fcntl(3, 0xd /* F_??? */, 0xbfffee50)   = -1 EINVAL (Invalid argument)
alarm(2)                                = 0
rt_sigaction(SIGALRM, {0x4009efe0, [ALRM], SA_RESTART|0x4000000}, {SIG_DFL},
8) = 0
fcntl(3, 0xe /* F_??? */, 0xbfffee50)   = -1 EINVAL (Invalid argument)
rt_sigaction(SIGALRM, {SIG_DFL}, {0x4009efe0, [ALRM], SA_RESTART|0x4000000},
8) = 0
alarm(0)                                = 2
close(3)                                = 0
write(2, "isamchk: error: ", 16isamchk: error: )        = 16
write(2, "22 when opening ISAM-table \'/usr"..., 5822 when opening
ISAM-table '/usr/local/var/mysql/user.ISM') = 58
write(2, "\n", 1
)                       = 1
munmap(0x40018000, 4096)                = 0
_exit(1)                                = ?