MySQL Bugs: #57898: Server crashed, assertion failure in thread 1092319552 in file buf/buf0buf.c

Bug #57898	Server crashed, assertion failure in thread 1092319552 in file buf/buf0buf.c
Submitted:	1 Nov 2010 14:41	Modified:	2 Jan 2011 20:13
Reporter:	Vojtech Kurka	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: InnoDB Plugin storage engine	Severity:	S3 (Non-critical)
Version:	5.1.50	OS:	Linux (2.6.18-164.9.1.el5.centos.plus)
Assigned to:		CPU Architecture:	Any
Tags:	assertion, crash, decompress, innodb, plugin

Description:
Today, we hit this crash on 5.1.50 + innodb plugin:

InnoDB: unable to decompress space 11829 page 37443
101101  9:16:11  InnoDB: Assertion failure in thread 1092319552 in file buf/buf0buf.c
line 2254
InnoDB: Failing assertion: success
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
InnoDB: about forcing recovery.
101101  9:16:11 - mysqld got signal 6 ;

I'll attach the complete error log

How to repeat:
don't know

error log from the startup until the crash

Attachment: mysqld_error.log (application/octet-stream, text), 82.15 KiB.

>Version: '5.1.50-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi

According to this string it's not original version of mysql. Does it contain any 3-rd party patches?

rpm -qi mysql-server-5.1.50-2.el5.remi
Name        : mysql-server                 Relocations: (not relocatable)
Version     : 5.1.50                            Vendor: Remi Collet
Release     : 2.el5.remi                    Build Date: Sat 28 Aug 2010 08:05:45 PM CEST
Install Date: Mon 06 Sep 2010 03:06:52 PM CEST      Build Host: goddard.famillecollet.com
Group       : Applications/Databases        Source RPM: mysql-5.1.50-2.el5.remi.src.rpm
Size        : 25424128                         License: GPLv2 with exceptions
Signature   : DSA/SHA1, Sat 28 Aug 2010 08:09:31 PM CEST, Key ID 004e6f4700f97f56
Packager    : http://blog.famillecollet.com/
URL         : http://www.mysql.com
Summary     : The MySQL server and related files.
Description :
MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
client/server implementation consisting of a server daemon (mysqld)
and many different client programs and libraries. This package contains
the MySQL server and some accompanying files and directories.

Our sysadmin has used this repo: http://blog.famillecollet.com/post/2010/08/20/mysql-5.1.50-en

Is it a problem? Is that build different?

we dont know. It _could_ be a problem, because we know nothing about patches in this build.

Could you please confirm the problem persists if you use original version of mysql from mysql.com?

OK, we will try to upgrade to standard 5.1.52 and we will see. This was the first crash for the last few months so I assume it doesn't appear in the near future.

Thank you, I think you can close this bugreport until we run in a crash on standard mysql binary.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".