MySQL Forums
Forum List  »  General

Mysql Crashes
Posted by: Derek Meyer
Date: October 09, 2014 04:52PM

I have been bugged just recently with crashes and I have not been able to find
the meaning of the stack trace.. This server has been pretty stable for a year or so.. No recent changes to anything... (other than some mysql upgrades but I have been running 5.6.14 for a month or two)

In two days I have had 5 resets... Three of the 5 have the below error message

Thread pointer: 0x2eaab0e0
Thread pointer: 0x2f086e70
Thread pointer: 0x2dd7f770
Thread pointer: 0x2d3a76e0
Thread pointer: 0x2ed0cf70

I have even gone to the point of sqldumping all tables wiping the data dir doing the mysqlinstall db script and reimporting all the data... Im somewhat puzzled...

PLEASE help?


mysql Ver 14.14 Distrib 5.6.14, for Linux (x86_64) using EditLine wrapper





22:31:41 UTC - 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_size=272629760
read_buffer_size=1548288
max_used_connections=106
max_threads=1000
thread_count=64
connection_count=58
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2047888 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x2ed0cf70
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 = 7f4ff244de18 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8cea15]
/usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65e0d4]
/lib64/libpthread.so.0[0x35ae60f500]
/lib64/libc.so.6[0x35ae283d1d]
/usr/sbin/mysqld(_ZN12Field_string6unpackEPhPKhjb+0x7f)[0x7a94cf]
141009 18:31:53 mysqld_safe Number of processes running now: 0

Options: ReplyQuote


Subject
Written By
Posted
Mysql Crashes
October 09, 2014 04:52PM
October 10, 2014 03:07AM
October 10, 2014 12:37PM
October 15, 2014 02:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.