Description:
Reported against the Debian package by "Jamie L. Penman-Smithson" <jamie@silverdream.org>.
I already asked for dumps and raw table files and am waiting for answer. Will report them here
if I get more information. Original: http://bugs.debian.org/352468
Can this be related to #16281?
-christian-
P.S.: Original Mail was too long, I upload it as file, here's the important stuff:
----------------------------------------------------------------------------------
Since I upgraded to 5.0 from 4.1 mysqld has crashed regularly once an
hour as a result of the same query:
Feb 11 21:41:40 lorien mysqld[18859]: thd->query at 0x8b461d0 =
SELECT flag FROM bayes_seen
Feb 11 21:41:40 lorien mysqld[18859]: WHERE id = '2'
Feb 11 21:41:40 lorien mysqld[18859]: AND msgid =
'dba30749e2262d41c8d5acaa8e0f73380e3f31dd@sa_generated'
In an effort to discover where the problem was I tried slightly
different queries for the same information. The query should have
returned no results, instead it seems to crash the server every
single time. I don't know if this is related to #341705.
mysql> SELECT flag FROM bayes_seen WHERE
msgid='e41265bc4f18f3711bcf90553fb9294a1def2bd7@sa_generated';
Empty set (0.43 sec)
.....
mysql> SELECT flag FROM bayes_seen WHERE msgid='e41265bc4f1%' AND
id='2';
ERROR 2013 (HY000): Lost connection to MySQL server during query
^ Crashes
The only applications using mysqld are spamassassin. I'm not sure
what to do next to diagnose the problem..
Log messages:
Feb 11 21:41:40 lorien mysqld[18859]: 060211 21:41:40InnoDB:
Assertion failure in thread 2965867440 in file row0mysql.c line 341
Feb 11 21:41:40 lorien mysqld[18859]: InnoDB: Failing assertion:
mbminlen == 1
Feb 11 21:41:40 lorien mysqld[18859]: InnoDB: We intentionally
generate a memory trap.
How to repeat:
No reproducible test case yet.
Suggested fix:
-
