(sorry for my english, I am from Russia)
I have a problem this MySQL on my linux (2.2.14) server.
In some pretty day after reboot MySQL-server (3.22.25) stopped to answer on
any exposure.
I tried to do something and after all remove it completely and install
again - nothing happens.
I install MySQL on another server - it's work so funny.
I upgrade MySQL to 3.23.33 - nothing happens.
So, what I can see.
I can't connect to MySQL though telnet or socket (locally).
Then i start debug, MySQL say this:
T@1024 : >fn_format
T@1024 : | enter: name: / dsk: form: flag: 16
T@1024 : | >dirname_part
T@1024 : | | enter: '/'
T@1024 : | <dirname_part
[........]
T@1024 : <my_malloc
T@1024 : >init_signals
T@1026 : >signal_hand
T@1026 : | >init_thr_alarm
T@1026 : | | >init_queue
T@1026 : | | | >my_malloc
T@1026 : | | | | my: Size: 488 MyFlags: 16
T@1026 : | | | | exit: ptr: 823d5d8
T@1026 : | | | <my_malloc
T@1026 : | | <init_queue
T@1026 : | <init_thr_alarm
T@1026 : | >my_create
T@1026 : | | my: Name: '/var/lib/mysql/pres.pid' CreateFlags: 436
AccessFlags: 1 MyFlags: 16
T@1026 : | <my_create
T@1026 : | >my_malloc
T@1026 : | | my: Size: 24 MyFlags: 16
T@1026 : | | exit: ptr: 823d7c8
T@1026 : | <my_malloc
T@1026 : | exit: fd: 10
T@1026 : | >my_write
T@1026 : | | my: Fd: 10 Buffer: 7f7ffcb0 Count: 5 MyFlags: 16
T@1026 : | <my_write
T@1026 : | >my_close
T@1026 : | | my: fd: 10 MyFlags: 0
T@1026 : | | >my_free
T@1026 : | | | my: ptr: 823d7c8
T@1026 : | | <my_free
T@1026 : | <my_close
Now server going to sleep and then I try to stop process, it write to
trace-log this, but don't want to dead.
T@1024 : | >end_thread_signal
T@1024 : | <end_thread_signal
T@1026 : | >end_thread_signal
T@1026 : | <end_thread_signal
Then I use strace, i get this:
execve("/usr/sbin/mysqld", ["/usr/sbin/mysqld"], [/* 18 vars */]) = 0
personality(PER_LINUX) = 0
geteuid() = 100
getuid() = 100
getegid() = 234
getgid() = 234
getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=RLIM_INFINITY}) = 0
setrlimit(RLIMIT_STACK, {rlim_cur=2040*1024, rlim_max=RLIM_INFINITY}) = 0
getpid() = 13859
[......]
/* 17 entries */, 3391) = 340
lseek(5, 0, SEEK_CUR) = 1024
getdents(5, /* 0 entries */, 3391) = 0
close(5) = 0
SYS_174(0x2, 0x7ffff764, 0x7ffff6d8, 0x8, 0x2) = 0
SYS_174(0xe, 0x7ffff780, 0x7ffff6f4, 0x8, 0xe) = 0
SYS_175(0x2, 0x7ffffa14, 0, 0x8, 0x2) = 0
SYS_174(0xb, 0x7ffff868, 0, 0x8, 0xb) = 0
SYS_174(0x7, 0x7ffff880, 0, 0x8, 0x7) = 0
SYS_174(0x4, 0x7ffff874, 0, 0x8, 0x4) = 0
SYS_174(0xd, 0x7ffff7e4, 0x7ffff758, 0x8, 0xd) = 0
SYS_174(0xf, 0x7ffff7f8, 0x7ffff76c, 0x8, 0xf) = 0
SYS_174(0x1, 0x7ffff7f0, 0x7ffff764, 0x8, 0x1) = 0
SYS_175(0x2, 0x7ffff940, 0, 0x8, 0x2) = 0
sched_get_priority_max(0, 0, 0x7ffff9d8, 0x7ffffa9c, 0x7ffffa9c) = 0
sched_get_priority_min(0, 0, 0x7ffff9d8, 0x7ffffa9c, 0) = 0
pipe([5, 6]) = 0
clone() = 13860
write(6, "\0\0\0\0\5\0\0\0\0\0\0\0\0\0\0\0"..., 148) = 148
SYS_175(0x2, 0, 0x7ffff940, 0x8, 0x2) = 0
write(6, "\300\220\37\10\0\0\0\0\234\372\377"..., 148) = 148
SYS_175(0x2, 0, 0x7ffff8ac, 0x8, 0x2) = 0
SYS_179(0x7ffff8ac, 0x8, 0, 0, 0x7ffff8ac
On another computer I cant see continue of this data:
SYS_179(0xbffff7b8, 0x8, 0, 0, 0xbffff7b8 <unfinished ...>
--- (null) (Real-time signal 0) ---
<... SYS_179 resumed> ) = -1 EINTR (Interrupted system call)
sigreturn() = ? (mask now [HUP QUIT TERM TSTP])
SYS_175(0x2, 0, 0xbffff854, 0x8, 0x2) = 0
SYS_179(0xbffff854, 0x8, 0, 0x4, 0xbffff854 <unfinished ...>
--- (null) (Real-time signal 0) ---
<... SYS_179 resumed> ) = -1 EINTR (Interrupted system call)
sigreturn() = ? (mask now [HUP QUIT TERM TSTP])
SYS_175(0x2, 0, 0xbffff70c, 0x8, 0x2) = 0
SYS_179(0xbffff70c, 0x8, 0, 0x4, 0xbffff70c <unfinished ...>
--- (null) (Real-time signal 0) ---
<... SYS_179 resumed> ) = -1 EINTR (Interrupted system call)
sigreturn() = ? (mask now [HUP QUIT TERM TSTP])
[.........]
Then I want to stop MySQL, I can do it only by 'kill -9'.
I mean, MySQL can't do something in function init_signals.
Maybe, somebody can to talk to me, that is trouble?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
