forwarded 352468 http://bugs.mysql.com/bug.php?id=17601 tags 352468 + upstream thanks
Hello Jamie On 2006-02-12 Jamie L. Penman-Smithson wrote: > 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 = > '[EMAIL PROTECTED]' Can you send me a copy of the table files in /var/lib/mysql/ or a "mysqldump --opt ..." output? So that I can try to reproduce it? Or simpler, if you dump the table and re-insert it, can you still reproduce the bug? There is one open issue with tables generated with MySQL 4.1 that seem not to be 100% compatible with MySQL 5.0. See http://bugs.mysql.com/bug.php?id=16281 > Feb 11 21:41:40 lorien mysqld[18859]: 060211 21:41:40InnoDB: > Assertion failure in thread 2965867440 in file row0mysql.c line 341 This happens in a function that is commented with: /* Remove trailing spaces from old style VARCHAR columns. */ So it would be really great if you could send the raw table files from your harddisc. I assume you tried "CHECK TABLE" etc? bye, -christian- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
