server crashes ocasionally on replication
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Undecided
|
Unassigned |
Bug Description
Recently upgraded to Percona 5.5.20. Slave crashes 2-3 times a day or hangs and needs to be killed.
When it crashes it is always in this stack:
*** glibc detected *** /usr/sbin/mysqld: double free or corruption (!prev): 0x00007f2a14378420 ***
======= Backtrace: =========
/lib64/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/lib64/
/lib64/
When it hangs there is always this message:
*** glibc detected *** /usr/sbin/mysqld: malloc(): memory corruption: 0x00007fe418187040 ***
There is a ton of other info in the log. Let me know what else is needed. This is a heavily replicating slave. I don't think I know how to reproduce it or what causes it but it happens very often.
I'm also getting this crash on 5.5.20:
mysql> show variables like 'version'; ------- --+---- ------- ----+ ------- --+---- ------- ----+ ------- --+---- ------- ----+
+------
| Variable_name | Value |
+------
| version | 5.5.20-55-log |
+------
1 row in set (0.00 sec)
Unlike https:/ /bugs.launchpad .net/percona- server/ +bug/705688, the query_cache_ strip_comments is off: ------- ------- ------- ---+--- ------- -+ ------- ------- ------- ---+--- ------- -+ min_res_ unit | 4096 | strip_comments | OFF | wlock_invalidat e | OFF | ------- ------- ------- ---+--- ------- -+
mysql> show variables like 'query_cache%';
+------
| Variable_name | Value |
+------
| query_cache_limit | 1048576 |
| query_cache_
| query_cache_size | 268435456 |
| query_cache_
| query_cache_type | ON |
| query_cache_
+------
6 rows in set (0.00 sec)
I have just set query_cache_size=0 and query_cache_type=0, I'm hoping that will fix this problem.