RootForum Community

Resources for System-Administrators
https://www.rootforum.org/forum/

MySQL hängt sich sporadisch auf - strace Resultat

https://www.rootforum.org/forum/viewtopic.php?t=49816

Page 1 of 1

MySQL hängt sich sporadisch auf - strace Resultat

Posted: 2008-12-18 14:32
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?

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

Posted: 2008-12-19 15:35
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.

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

Posted: 2008-12-20 13:55
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!

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

Posted: 2009-01-19 11:21
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?
All times are UTC+02:00
Page 1 of 1