server crash in main.percona_query_response_time-stored and main.percona_query_response_time-replication
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Laurynas Biveinis | ||
5.1 |
Fix Released
|
Critical
|
Laurynas Biveinis | ||
5.5 |
Fix Released
|
Medium
|
Laurynas Biveinis |
Bug Description
I see the following failure in Jenkins which has seemingly not been reported yet:
main.percona_
Test ended at 2011-06-28 14:45:46
CURRENT_TEST: main.percona_
mysqltest: At line 31: query 'SELECT test_f()' failed: 2013: Lost connection to MySQL server during query
The result from queries just before the failure was:
< snip >
512.000000
1024.000000
2048.000000
4096.000000
8192.000000
16384.000000
32768.000000
65536.000000
131072.000000
262144.000000
524288.000000
1048576.00000
2097152.00000
4194304.00000
8388608.00000
TOO LONG
SET GLOBAL ENABLE_
SELECT test_f();
test_f()
Hello, world!
More results from queries before failure can be found in /mnt/workspace/
Server [mysqld.1 - pid: 21158, winpid: 21158, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
110628 17:45:46 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.
key_buffer_
read_buffer_
max_used_
max_threads=151
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0xb69245c0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0xb6b0736c thread_stack 0x30000
/mnt/workspace/
/mnt/workspace/
[0xb77ae400]
/mnt/workspace/
/mnt/workspace/
/mnt/workspace/
/mnt/workspace/
/lib/tls/
/lib/tls/
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x9b839b0): SELECT test_f()
Connection ID (thread ID): 2277
Status: NOT_KILLED
The manual page at http://
information that should help you find out what is causing the crash.
Writing a core file
----------SERVER LOG END-------------
- saving '/mnt/workspace
- found 'core' (0/5)
Trying 'dbx' to get a backtrace
Trying 'gdb' to get a backtrace
Guessing that core was generated by '/mnt/workspace
Output from gdb follows. The first stack trace is from the failing thread.
The following stack traces are from all threads (so the failing one is
duplicated).
-------
[New Thread 13523]
[New Thread 21159]
[New Thread 21163]
warning: Can't read pathname for load map: Input/output error.
Core was generated by `/mnt/workspace
Program terminated with signal 11, Segmentation fault.
#0 0xb77ae424 in __kernel_vsyscall ()
#0 0xb77ae424 in __kernel_vsyscall ()
#1 0xb7792123 in __pthread_kill (threadid=
at ../nptl/
#2 0x085449d4 in my_write_core (sig=11) at stacktrace.c:426
#3 0x08201a47 in handle_segfault (sig=11) at mysqld.cc:2660
#4 <signal handler called>
#5 0x08230e07 in my_atomic_cas64 (query_
at ../include/
#6 my_atomic_add64 (query_
#7 query_response_
at query_response_
#8 query_response_
at query_response_
#9 query_response_
at query_response_
#10 0x082100be in log_slow_statement (thd=0xb69245c0) at sql_parse.cc:1780
#11 0x0821f150 in dispatch_command (command=COM_QUERY, thd=0xb69245c0,
packet=
#12 0x0821f6ea in do_command (thd=0xb69245c0) at sql_parse.cc:903
#13 0x0820dad2 in handle_
at sql_connect.cc:1898
#14 0xb778c985 in start_thread (arg=0xb6b07b70) at pthread_
#15 0xb755113e in clone () at ../sysdeps/
Thread 3 (Thread 21163):
#0 0xb77ae424 in __kernel_vsyscall ()
#1 0xb779522d in do_sigwait (set=0xb6b9a350, sig=<value optimized out>)
at ../nptl/
#2 0xb77952d0 in __sigwait (set=0xb6b9a2bc, sig=0xb6b9a350)
at ../nptl/
#3 0x082013af in signal_hand (arg=0x0) at mysqld.cc:2854
#4 0xb778c985 in start_thread (arg=0xb6b9ab70) at pthread_
#5 0xb755113e in clone () at ../sysdeps/
Thread 2 (Thread 21159):
#0 0xb77ae424 in __kernel_vsyscall ()
#1 0xb7542ab6 in *__GI___poll (fds=0xb75daff4, nfds=2, timeout=-1)
at ../sysdeps/
#2 0x082067a3 in handle_
#3 0x0820894c in main (argc=9, argv=0xbfc04a14) at mysqld.cc:4769
Thread 1 (Thread 13523):
#0 0xb77ae424 in __kernel_vsyscall ()
#1 0xb7792123 in __pthread_kill (threadid=
at ../nptl/
#2 0x085449d4 in my_write_core (sig=11) at stacktrace.c:426
#3 0x08201a47 in handle_segfault (sig=11) at mysqld.cc:2660
#4 <signal handler called>
#5 0x08230e07 in my_atomic_cas64 (query_
at ../include/
#6 my_atomic_add64 (query_
#7 query_response_
at query_response_
#8 query_response_
at query_response_
#9 query_response_
at query_response_
#10 0x082100be in log_slow_statement (thd=0xb69245c0) at sql_parse.cc:1780
#11 0x0821f150 in dispatch_command (command=COM_QUERY, thd=0xb69245c0,
packet=
#12 0x0821f6ea in do_command (thd=0xb69245c0) at sql_parse.cc:903
#13 0x0820dad2 in handle_
at sql_connect.cc:1898
#14 0xb778c985 in start_thread (arg=0xb6b07b70) at pthread_
#15 0xb755113e in clone () at ../sysdeps/
Related branches
- Stewart Smith (community): Approve
-
Diff: 51 lines (+12/-17)1 file modifiedresponse-time-distribution.patch (+12/-17)
- Stewart Smith (community): Approve
-
Diff: 49 lines (+42/-0)1 file modifiedresponse_time_distribution.patch (+42/-0)
Changed in percona-server: | |
status: | New → Confirmed |
Changed in percona-server: | |
assignee: | nobody → Oleg Tsarev (tsarev) |
Changed in percona-server: | |
status: | Confirmed → Fix Committed |
Changed in percona-server: | |
status: | Fix Committed → Confirmed |
Changed in percona-server: | |
assignee: | Oleg Tsarev (tsarev) → Laurynas Biveinis (laurynas-biveinis) |
assignee: | Laurynas Biveinis (laurynas-biveinis) → Stewart Smith (stewart) |
Changed in percona-server: | |
status: | Confirmed → In Progress |
importance: | Undecided → Critical |
main.percona_ query_response_ time-replicatio n fails with the same backtrace.