MySQL hängt sich sporadisch auf - strace Resultat

exilist
Posts: 3
Joined: 2008-12-18 14:00

MySQL hängt sich sporadisch auf - strace Resultat

Post by exilist »

Hallo!

Habe das Problem, das sich MySQL 5.0.32, auf Debian Etch mit Kernel 2.6.24-etchnhalf.1-686 sporadisch aufhängt,
genauer gesagt der MySQL Prozess braucht dann 100% CPU Last.
Die LOAD der Maschine ist nicht sonderlich hoch, aber ab dem Zeitpunkt sind keine weiteren Verbindungen zur DB möglich.

Auch ein /etc/init.d/mysql stop funktioniert in dem Fall nicht mehr, nur ein kill des entspr. mysqld_safe Prozesses,
dabei erhielt ich folgenden strace Auszug:

Code: Select all

waitpid(-1, 0xbfc9d87c, 0)              = ? ERESTARTSYS (To be restarted)
--- SIGTERM (Terminated) @ 0 (0) ---
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
sigreturn()                             = ? (mask now [])
rt_sigprocmask(SIG_BLOCK, [TERM], [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [TERM], 8) = 0
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [TERM], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e34708) = 14970
rt_sigprocmask(SIG_SETMASK, [TERM], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
sigreturn()                             = ? (mask now [TERM])
rt_sigprocmask(SIG_BLOCK, [CHLD], [TERM], 8) = 0
rt_sigprocmask(SIG_SETMASK, [TERM], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [TERM], 8) = 0
rt_sigaction(SIGINT, {0x807b920, [], 0}, {SIG_IGN}, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {0x807b920, [], 0}, 8) = 0
waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 1}], WNOHANG) = 14970
waitpid(-1, 0xbfc9da9c, WNOHANG)        = 0
rt_sigprocmask(SIG_SETMASK, [TERM], NULL, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {SIG_IGN}, 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8)  = 0
stat64("/var/run/mysqld/mysqld.pid", {st_mode=S_IFREG|0660, st_size=5, ...}) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8)  = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
pipe([3, 4])                            = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e34708) = 14971
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigaction(SIGCHLD, {0x807acd0, [], 0}, {0x807acd0, [], 0}, 8) = 0
close(4)                                = 0
read(3, "1n", 128)                     = 2
read(3, "", 128)                        = 0
close(3)                                = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigaction(SIGINT, {0x807b920, [], 0}, {SIG_IGN}, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {0x807b920, [], 0}, 8) = 0
waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0) = 14971
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
waitpid(-1, 0xbfc9d90c, WNOHANG)        = 0
sigreturn()                             = ? (mask now [])
rt_sigaction(SIGINT, {SIG_IGN}, {SIG_IGN}, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
pipe([3, 4])                            = 0
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [CHLD], 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [INT CHLD], 8) = 0
rt_sigprocmask(SIG_SETMASK, [INT CHLD], NULL, 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e34708) = 14976
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
close(4)                                = 0
close(4)                                = -1 EBADF (Bad file descriptor)
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [CHLD], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e34708) = 14977
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
close(3)                                = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0
rt_sigaction(SIGINT, {0x807b920, [], 0}, {SIG_IGN}, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {0x807b920, [], 0}, 8) = 0
waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0) = 14976
waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0) = 14977
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {SIG_IGN}, 8) = 0
close(3)                                = -1 EBADF (Bad file descriptor)
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
waitpid(-1, 0xbfc9ddec, WNOHANG)        = 0
sigreturn()                             = ? (mask now [])
rt_sigprocmask(SIG_BLOCK, NULL, [], 8)  = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
pipe([3, 4])                            = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e34708) = 14978
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigaction(SIGCHLD, {0x807acd0, [], 0}, {0x807acd0, [], 0}, 8) = 0
close(4)                                = 0
read(3, " 6571 ?        Sl   788:00 /usr/"..., 128) = 128
read(3, "ld.pid --skip-external-locking -"..., 128) = 80
read(3, "", 128)                        = 0
close(3)                                = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigaction(SIGINT, {0x807b920, [], 0}, {SIG_IGN}, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {0x807b920, [], 0}, 8) = 0
waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0) = 14978
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
waitpid(-1, 0xbfc9d57c, WNOHANG)        = 0
sigreturn()                             = ? (mask now [])
rt_sigaction(SIGINT, {SIG_IGN}, {SIG_IGN}, 8) = 0
open(".", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = 3
fstat64(3, {st_mode=S_IFDIR|0755, st_size=1024, ...}) = 0
fcntl64(3, F_SETFD, FD_CLOEXEC)         = 0
brk(0x8108000)                          = 0x8108000
getdents64(3, /* 28 entries */, 1024)   = 768
getdents64(3, /* 0 entries */, 1024)    = 0
close(3)                                = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
kill(6571, SIGKILL)                     = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
pipe([3, 4])                            = 0
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [CHLD], 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [INT CHLD], 8) = 0
rt_sigprocmask(SIG_SETMASK, [INT CHLD], NULL, 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e34708) = 14984
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
close(4)                                = 0
close(4)                                = -1 EBADF (Bad file descriptor)
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [CHLD], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e34708) = 14985
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
close(3)                                = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0
rt_sigaction(SIGINT, {0x807b920, [], 0}, {SIG_IGN}, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {0x807b920, [], 0}, 8) = 0
waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0) = 14984
waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0) = 14985
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {SIG_IGN}, 8) = 0
close(3)                                = -1 EBADF (Bad file descriptor)
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
waitpid(-1, 0xbfc9da5c, WNOHANG)        = 0
sigreturn()                             = ? (mask now [])
pipe([3, 4])                            = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e34708) = 14986
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG) = 14986
waitpid(-1, 0xbfc9d94c, WNOHANG)        = 0
sigreturn()                             = ? (mask now [])
rt_sigaction(SIGCHLD, {0x807acd0, [], 0}, {0x807acd0, [], 0}, 8) = 0
close(4)                                = 0
read(3, "2n", 128)                     = 2
read(3, "", 128)                        = 0
close(3)                                = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigaction(SIGINT, {0x807b920, [], 0}, {SIG_IGN}, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {0x807b920, [], 0}, 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {SIG_IGN}, 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8)  = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
pipe([3, 4])                            = 0
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [CHLD], 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [INT CHLD], 8) = 0
rt_sigprocmask(SIG_SETMASK, [INT CHLD], NULL, 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e34708) = 14987
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
close(4)                                = 0
close(4)                                = -1 EBADF (Bad file descriptor)
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [CHLD], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e34708) = 14988
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
close(3)                                = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0
rt_sigaction(SIGINT, {0x807b920, [], 0}, {SIG_IGN}, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {0x807b920, [], 0}, 8) = 0
waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0) = 14987
waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0) = 14988
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {SIG_IGN}, 8) = 0
close(3)                                = -1 EBADF (Bad file descriptor)
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
waitpid(-1, 0xbfc9e6cc, WNOHANG)        = 0
sigreturn()                             = ? (mask now [])
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
stat64("/bin/rm", {st_mode=S_IFREG|0755, st_size=34472, ...}) = 0
stat64(".", {st_mode=S_IFDIR|0755, st_size=1024, ...}) = 0
stat64("/usr/local/sbin/rm", 0xbfc9e308) = -1 ENOENT (No such file or directory)
stat64("/usr/local/bin/rm", 0xbfc9e308) = -1 ENOENT (No such file or directory)
stat64("/usr/sbin/rm", 0xbfc9e308)      = -1 ENOENT (No such file or directory)
stat64("/usr/bin/rm", 0xbfc9e308)       = -1 ENOENT (No such file or directory)
stat64("/sbin/rm", 0xbfc9e308)          = -1 ENOENT (No such file or directory)
stat64("/bin/rm", {st_mode=S_IFREG|0755, st_size=34472, ...}) = 0
stat64("/bin/rm", {st_mode=S_IFREG|0755, st_size=34472, ...}) = 0
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e34708) = 14989
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigaction(SIGINT, {0x807b920, [], 0}, {SIG_IGN}, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {0x807b920, [], 0}, 8) = 0
waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0) = 14989
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
waitpid(-1, 0xbfc9dffc, WNOHANG)        = 0
sigreturn()                             = ? (mask now [])
rt_sigaction(SIGINT, {SIG_IGN}, {SIG_IGN}, 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8)  = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8)  = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
pipe([3, 4])                            = 0
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [CHLD], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e34708) = 14990
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
close(4)                                = 0
close(4)                                = -1 EBADF (Bad file descriptor)
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [CHLD], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7e34708) = 14991
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
close(3)                                = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
close(3)                                = -1 EBADF (Bad file descriptor)
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8)  = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigaction(SIGINT, {0x807b920, [], 0}, {SIG_IGN}, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {0x807b920, [], 0}, 8) = 0
waitpid(-1, [{WIFSIGNALED(s) && WTERMSIG(s) == SIGKILL}], 0) = 6571
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
waitpid(-1, 0xbfc9d4dc, WNOHANG)        = 0
sigreturn()                             = ? (mask now [])
rt_sigaction(SIGINT, {SIG_IGN}, {SIG_IGN}, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigaction(SIGINT, {0x807b920, [], 0}, {SIG_IGN}, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {0x807b920, [], 0}, 8) = 0
waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0) = 14991


Das bringt mich nur leider auch nicht weiter. Hat jemand einen hilfreichen Tipp?
Top

User avatar
isotopp
RSAC
Posts: 482
Joined: 2003-08-21 10:21
Location: Berlin

Re: MySQL hängt sich sporadisch auf - strace Resultat

Post by isotopp »

exilist wrote:Das bringt mich nur leider auch nicht weiter. Hat jemand einen hilfreichen Tipp?


Tritt das Problem auch dann noch auf, wenn Du in dieser Reihenfolge ein 5.0.67 installierst und danach einmal "REPAIR TABLE" über alle Tabellen hetzt?

select concat("repair table ", table_schema, ".", table_name, ";") as cmd into outfile "/tmp/doit.sh" from information_schema.tables where table_schema not in ("mysql", "information_schema") and engine = "myisam";

und danach /tmp/doit bearbeiten und mit "source /tmp/doit" im Commandline-Client einlesen.

Wenn das das Problem behebt, wär es ein guter Zeitpunkt, um in der mysql-Sektion Deiner my.cnf einmal

myisam_recover = FORCE,BACKUP
myisam_repair_threads = 1

zu hinterlassen.
Top

exilist
Posts: 3
Joined: 2008-12-18 14:00

Re: MySQL hängt sich sporadisch auf - strace Resultat

Post by exilist »

Tritt das Problem auch dann noch auf, wenn Du in dieser Reihenfolge ein 5.0.67 installierst und danach einmal "REPAIR TABLE" über alle Tabellen hetzt?


Muss es 5.0.67 sein, oder reicht auch die verfügbare Paketversion 5.0.51a aus den Backports?
Auf diese habe ich jetzt aktualisiert.
Das explizite Repair ist ein guter Tipp, den werde ich probieren und berichten.
Vielen Dank!
Top

exilist
Posts: 3
Joined: 2008-12-18 14:00

Re: MySQL hängt sich sporadisch auf - strace Resultat

Post by exilist »

Habe alle Tabellen wie angegeben repariert,
ein check vorher brachte bei einigen Tabellen diesen Fehler:

Code: Select all

check warning 3 clients are using or haven't closed the table properly


Leider ist die Datenbank danach schon wieder mit dem selben Verhalten in einen unbrauchbaren Zustand geraten,
einmal als gerade ein mysqldump lief, ein andermal einfach so.

Kann ich in irgendeiner Form noch das Loglevel erhöhen? Oder hat noch jemand andere Tipps für mich?
Top