mysql crased with signal 6

MySQL & MariaDB Other MySQL® Questions
1

Hi,

Our system is running in a two way replication mode. In one of our server, mysql crashed with the following error.

mysqld: buffer.cpp:41: void yaSSL::Check::check(unsigned int, unsigned int): Assertion `i < limit’ failed.
mysqld got signal 6;
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.

I have searched in forums and i see some thread but there were no solution to this. Please guide me in overcoming this problem. The mysql version is 5.0.22. The trace from the error log is attached.

Thanks,
Krishna.

2

Hi,

I think this is a memory related issue.
Mysql can use upto memory
key_buffer + max_connections * (join_buffer + record_buffer + sort_buffer + thread_stack + tmp_table_size)MB of memory

The amount of memory Mysql demanding is more than the available in your server.

This might be a possibility.

Regards
Sushil