Bug #26888 | func_in fails on many different platforms, but with low probability | ||
---|---|---|---|
Submitted: | 6 Mar 2007 18:09 | Modified: | 30 Oct 2008 18:57 |
Reporter: | Daniel Fischer | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
Version: | 5.0 + 5.1 + 5.5 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[6 Mar 2007 18:09]
Daniel Fischer
[30 Oct 2008 18:57]
Joerg Bruehe
This happens in many release builds, but often was not reported. Scanning the isolated failures in the archive (which is incomplete, because for some builds this isolation wasn't done) I find these occurrences: 5.0.21 Linux/x86(RPM) 5.0.26 Windows-64 5.0.30sp1 Linux/IA64, Linux/s390 5.0.32 Linux/s390 5.0.34 Linux/IA64, Linux/s390 5.0.36 Linux/s390 5.0.37 Windows-64 5.0.42 Linux/x86_64, Linux/s390 5.0.44 Linux/s390 5.0.50 Linux/s390 5.0.50sp1a Linux/s390 5.0.56 Linux/s390 5.0.58 Linux/s390 5.0.62 Windows-64 5.0.64 Windows-64 5.0.66 Windows-64 5.0.68 Linux/s390 5.0.72 Linux/x86_64/icc, Solaris-10/x86, Solaris-10/x86_64, AIX 5.2(32) 5.1.21 OS-X/x86 5.1.22 Linux/x86_64(RPM) 5.1.23 Linux/x86, Linux/x86_64, Solaris-8/Sparc, Solaris-10/x86 5.1.26 Linux/x86_64 5.1.27 Linux/x86_64 So we have it in many releases, on many different platforms (using different compilers), some occurrences in optimized builds, some in debug, but always with a low probability only (the test passes in the majority of runs).
[26 Jan 2009 18:51]
Matthias Leich
There is some interesting observation when using xref on main.func_in: 1. Output pattern "%free space%" - ~34 failures with this pattern - ~32 of these ~34 are like At line 230: query 'select count(*) from ( select @str:=concat(@str, @cnt:=@cnt+1, ",") from t1 A, t1 B, t1 C, t1 D) Z' failed: 20: Disk is full writing '/dev/shm/pbtmp-n_mix-120/#sql_3424_0.MAD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs 2. Output pattern "%line 230%" - ~179 failures with this pattern - ~32 of these ~179 with "Waiting for someone to free space" - ~30 of these ~179 with "2013: Lost connection to MySQL server ..", but only Dec 2007 and Maria tree - most remaining of the ~179 are with 126: Incorrect key file for table '/dev/shm/pbtmp-embedded- 112/#sql_751b_0.MYI'; try to repair it Could it be that the effect at the beginning of bug report At line 230: query 'select count(*) from (. ... failed: 126: Incorrect key file for table ... try to repair it is caused by file system full?
[22 Feb 2010 19:33]
Joerg Bruehe
Still happens in 5.5.2-m2