debian 6.0 squeeze, kernel 3.2, Intel® Core™ Quad-Core i7-2600 processor, 16 GB DDR 3, 2 x 3 TB SATA RAID and intel ssd for with mysql database.

relevant part:

Jun 3 07:46:35 Debian-60-squeeze-64-minimal mysqld: InnoDB: Failing assertion: btr_page_get_prev(next_page, mtr) == buf_block_get_page_no(btr_pcur_get_block(cursor))
Jun 3 07:46:35 Debian-60-squeeze-64-minimal mysqld: InnoDB: We intentionally generate a memory trap.

Removed the link to http://bugs.mysql.com/bug.php?id=59910 because http://bugs.mysql.com/bug.php?id=60613 claims it was fixed in 5.5 (while still exists in 5.1).

Hi Stanislav,

1. Discussions around similar problems in the past suggest that the most likely reason is a hard disk problem. Can be the case in your environment?
2. How big is the datadir? It seems that InnoDB recovery finishes fast enough, so hopefully it's not too big – would you be able then to upload it to our FTP server? (ftp.askmonty.org/private)

Thanks.

The data dir has 7GB but I can try to copy it to different HDD and try to run mariadb from there. I will try it at night and then I will post the result.
Thank you

I migrated database to different HDD but it did not helped
Mariadb crashed four times in hour from migration

this night I will try it with mariadb 5.5.30

It did not helped...next step I will try dump whole database and reload it.

I found the database which is bad, should I upload it to ftp?

Hi, how big is it?

it has 55MB compressed.

Sure, please upload it. Thanks!

uploaded

Thank you. So what's the story – does it crash for you on startup, or on executing some work flow, or while the server is idle, or ... ?

It does not crashes on startup or idle. It crashes for example on mysql dump.

Hi,

There is no system tablespace in the archive, so the tables don't work. Could you please upload the system tablespace as well (ibdata* files), and just in case also upload or attach your cnf file?

Thanks.

Closing for now due to the lack of information to go on with. Please comment to re-open the issue if you have more details.