incearca ca mysql "root" user sa dai un "flush hosts;" in mysql si ia vezi
dupa aia :)
PS: daca asta era cauza mareste numarul de connection errors cu parametru
de start
On Mon, 14 Oct 2002 [EMAIL PROTECTED] wrote:
>
>
> 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/
>
>
>
----------------------------
Mihai RUSU
Disclaimer: Any views or opinions presented within this e-mail are solely
those of the author and do not necessarily represent those of any company,
unless otherwise specifically stated.
---
Pentru dezabonare, trimiteti mail la
[EMAIL PROTECTED] cu subiectul 'unsubscribe rlug'.
REGULI, arhive si alte informatii: http://www.lug.ro/mlist/
