Bug#410821: How to repeat this error

2008-02-29 Thread Łukasz Cybula
After couple of days I figured out how to repeat the error. I started the attached query several times concurrently and it crashed the server. -- Chives SELECT t.id, t.title, t.filename, max((unix_timestamp(newest_created) 32) | newest.author_id) 0xFF AS newest_author,

Bug#410821: maybe same bug with some detailed info in log

2008-02-25 Thread Łukasz Cybula
Hi everyone, Yesterday one of our mysql servers (mysq-server-5.0.32-7etch1 on debian 4.0 AMD64) has crashed with this messages: Feb 24 18:19:50 vs1 mysqld[3665]: 080224 18:19:50 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_e50_9.MYI'; try to repair it Feb 24 18:19:50