De putin timp nu mai pot sa ma conectez la mysql prin retea (nu socket
local). In /var/log/mysqld.log am:
Number of processes running now: 1
mysqld process hanging, pid 25365 - killed
021014 12:07:54 mysqld restarted
/usr/libexec/mysqld: ready for connections
Number of processes running now: 1
mysqld process hanging, pid 25389 - killed
021014 12:08:02 mysqld restarted
/usr/libexec/mysqld: ready for connections
Number of processes running now: 1
mysqld process hanging, pid 25413 - killed
021014 12:08:12 mysqld restarted
(Asta pentru fiecare incercare de conectare)
Versiunea de mysql e 3.23.41 asa cum vine cu RH 7.3. Am incercat un
strace, dar nu m-a luminat prea tare:
[root@viper root]# ps afxuw | grep '^mysql'
mysql 29347 0.4 3.5 26872 4472 pts/0 S 13:04 0:00 \_
/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --dat
mysql 29349 0.0 3.5 26872 4472 pts/0 S 13:04 0:00 \_
/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr -
mysql 29350 0.0 3.5 26872 4472 pts/0 S 13:04 0:00 \_
/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/u
mysql 29351 0.0 3.5 26872 4472 pts/0 S 13:04 0:00 \_
/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/u
[root@viper root]# strace -p 29347 -p 29349 -p 29350 -p 29351
[pid 29349] getppid() = 29347
[pid 29349] poll( <unfinished ...>
[pid 29347] select(5, [3 4], NULL, NULL, NULL <unfinished ...>
[pid 29349] <... poll resumed> [{fd=7, events=POLLIN}], 1, 2000) = 0
[pid 29349] getppid() = 29347
[pid 29349] poll([{fd=7, events=POLLIN}], 1, 2000) = 0
[pid 29349] getppid() = 29347
[pid 29349] poll([{fd=7, events=POLLIN}], 1, 2000) = 0
[pid 29349] getppid() = 29347
[pid 29349] poll( <unfinished ...>
[pid 29347] <... select resumed> ) = 1 (in [3])
[pid 29347] fcntl64(0x3, 0x4, 0x802, 0x4) = 0
[pid 29347] accept(3, {sin_family=AF_INET, sin_port=htons(2726),
sin_addr=inet_addr("62.231.112.4")}}, [16]) = 9
[pid 29347] fcntl64(0x3, 0x4, 0x2, 0x4) = 0
[pid 29347] getsockname(9, {sin_family=AF_INET, sin_port=htons(3306),
sin_addr=inet_addr("62.231.112.6")}}, [16]) = 0
[pid 29347] fcntl64(0x9, 0x3, 0x9, 0x3) = 2
[pid 29347] fcntl64(0x9, 0x4, 0x802, 0x4) = 0
[pid 29347] time(NULL) = 1034589971
[pid 29347] rt_sigprocmask(SIG_SETMASK, NULL, [HUP QUIT PIPE TERM TSTP
32], 8) = 0
[pid 29347] write(8,
"\200\357\3@\0\0\0\0@8$\0100n\v\10\270\276&\10\5P\10\200"..., 148
<unfinished ...>
[pid 29349] <... poll resumed> [{fd=7, events=POLLIN, revents=POLLIN}], 1,
2000) = 1
[pid 29349] getppid() = 29347
[pid 29349] read(7,
"\200\357\3@\0\0\0\0@8$\0100n\v\10\270\276&\10\5P\10\200"..., 148) = 148
[pid 29349] mmap2(NULL, 69632, PROT_READ|PROT_WRITE|PROT_EXEC,
MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x41803000
[pid 29349] mprotect(0x41803000, 4096, PROT_NONE) = 0
[pid 29349] clone(child_stack=0x41813bd8,
flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|0x21) = 29429
[pid 29347] <... write resumed> ) = 148
[pid 29349] kill(29347, SIGRT_0 <unfinished ...>
[pid 29347] rt_sigprocmask(SIG_SETMASK, NULL, <unfinished ...>
[pid 29349] <... kill resumed> ) = 0
[pid 29347] <... rt_sigprocmask resumed> [HUP QUIT PIPE TERM TSTP 32], 8)
= 0
[pid 29349] --- SIGRT_1 (Real-time signal 1) ---
[pid 29347] rt_sigsuspend([HUP QUIT PIPE TERM TSTP] <unfinished ...>
[pid 29349] sigreturn( <unfinished ...>
[pid 29347] --- SIGRT_0 (Real-time signal 0) ---
[pid 29349] <... sigreturn resumed> ) = ? (mask now ~[TRAP KILL STOP])
[pid 29349] poll([{fd=7, events=POLLIN}], 1, 2000) = 0
[pid 29349] getppid() = 29347
[pid 29349] wait4(-1, [WIFSIGNALED(s) && WTERMSIG(s) == SIGSEGV],
WNOHANG|__WCLONE, NULL) = 29429
[pid 29349] modify_ldt(0x1, 0x8265834, 0x10) = 0
[pid 29349] munmap(0x41803000, 69632) = 0
[pid 29349] kill(29351, SIGSEGV <unfinished ...>
[pid 29351] --- SIGSEGV (Segmentation fault) ---
[pid 29349] <... kill resumed> ) = 0
[pid 29349] --- SIGRT_1 (Real-time signal 1) ---
[pid 29349] sigreturn() = ? (mask now ~[TRAP KILL STOP])
[pid 29349] kill(29350, SIGSEGV) = 0
[pid 29349] kill(29347, SIGSEGV) = 0
[pid 29349] _exit(0) = ?
+++ killed by SIGKILL +++
/etc/my.cnf este curat:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
As fi recunoscator pentru o sugestie.
Numai bine,
rudigrec
---
Pentru dezabonare, trimiteti mail la
[EMAIL PROTECTED] cu subiectul 'unsubscribe rlug'.
REGULI, arhive si alte informatii: http://www.lug.ro/mlist/
