| Bug #40829 | main.slow_query_log_func random failures | ||
|---|---|---|---|
| Submitted: | 18 Nov 2008 16:48 | Modified: | 12 May 2009 10:08 |
| Reporter: | Matthias Leich | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Tests: Server | Severity: | S3 (Non-critical) |
| Version: | 5.1.30 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | sporadic | ||
[12 May 2009 10:08]
Philip Stoev
This test case has already been fixed. The offending query no longer exists in this test - it has been replaced with the safer SELECT COUNT(*) > 1. bzr annotate suite/sys_vars/t/slow_query_log_func.test 2815.2.1 horst@m | SELECT count(*) > 0 FROM mysql.slow_log; revno: 2815.2.1 committer: Horst Hunger <horst@mysql.com> branch nick: mysql-5.1-37962 timestamp: Fri 2009-03-20 18:11:22 +0100 message: Reviewed fix for bug#37962 also including the revised result files for failing system variable tests.
Description: Testing of 5.1.30 by build team: -------------------------------- EST : main.slow_query_log_func (debug) LOG : log/production,linux-x86-icc,5.1-enterprise-gpl-pro.log @@ -19,6 +19,6 @@ 0 SELECT count(*) FROM mysql.slow_log; count(*) -1 +2 SET @@global.log_output = @global_log_output; SET @global.slow_query_log = @global_slow_query_log; This looks like a weakness within the test and not like a server bug. How to repeat: This worked within my 5.1-bugteam tree (last Changeset Fri 2008-11-14) on my notebook: <as root>: dd if=<some partition of my disk> of=/dev/null <as user>: ./mysql-test-run.pl \ `perl -e 'for (1 .. 300) { print "slow_query_log_func "}'`