http://bugzilla.novell.com/show_bug.cgi?id=516339 Summary: mysqld regularly crashes Classification: openSUSE Product: openSUSE 11.0 Version: Final Platform: x86-64 OS/Version: Other Status: NEW Severity: Critical Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: per.jessen@enidan.com QAContact: qa@suse.de Found By: --- User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-GB; rv:1.8.1.6) Gecko/20070730 SUSE/2.0.0.6-25 Firefox/2.0.0.6 I'm not sure where this report really belongs, but as I am running an openSUSE built mysql binary I thought I'd start here. Not quite every day but perhaps 3-4 times a week, my mysql server crashes. It happens at roughly the same time every day, during some morning batch processing. Usually the table 'quarantine_archive' will need repairing, but not always. It has some 38 million rows. The batchjob that is running does a few hundred queries like this: mysql -Ddb_spamchek -h localhost -u spamchek_batch --password=spamchek -s -B -e "INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE state=1 AND domain='example.com'; DELETE FROM quarantine WHERE state=1 AND domain='example.com'" They're not running in parallel, but one-by-one. I'll attach the mysqld.log and some hardware info. Reproducible: Sometimes -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.