| Bug #33304 | Test 'func_group' hangs on Mac OS X 10.4 PowerPC 64-bit | ||
|---|---|---|---|
| Submitted: | 18 Dec 2007 0:50 | Modified: | 27 Mar 20:29 |
| Reporter: | Kent Boortz | ||
| Status: | Closed | ||
| Category: | Server: DML | Severity: | S3 (Non-critical) |
| Version: | 5.0.54 | OS: | Mac OS X (10.4 PowerPC 64-bit) |
| Assigned to: | Ramil Kalimullin | Target Version: | 5.0+,5.1.24 |
| Triage: | D1 (Critical) / R3 (Medium) / E1 (None/Negligible) | ||
[15 Feb 8:04]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/42329 ChangeSet@1.2570, 2008-02-15 11:04:11+04:00, ramil@mysql.com +1 -0 Fix for bug #33304: Test 'func_group' hangs on Mac OS X 10.4 PowerPC 64-bit Problem: SLEEP(0) never returns on 64-bit Mac OS X due to a bug in pthread_cond_timedwait(). Fix: when given a very short timeout just return immediately.
[15 Feb 13:04]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/42348 ChangeSet@1.2570, 2008-02-15 16:03:54+04:00, ramil@mysql.com +1 -0 Fix for bug #33304: Test 'func_group' hangs on Mac OS X 10.4 PowerPC 64-bit Problem: SLEEP(0) never returns on 64-bit Mac OS X due to a bug in pthread_cond_timedwait(). Fix: when given a very short timeout just return immediately.
[27 Mar 12:21]
Bugs System
Pushed into 5.0.60
[27 Mar 12:22]
Bugs System
Pushed into 5.1.24-rc
[27 Mar 18:54]
Bugs System
Pushed into 6.0.5-alpha
[27 Mar 20:29]
Paul DuBois
Noted in 5.0.60, 5.1.24, 6.0.5 changelogs.
[2 Apr 17:57]
Jon Stephens
Also noted fix in 5.1.23-ndb-6.3.11 changelog.
Description: Test 'func_group' hangs on Mac OS X 10.4 PowerPC 64-bit hangs in query SELECT (SELECT SLEEP(0) FROM t1 ORDER BY AVG(DISTINCT a) ) as x FROM t1 GROUP BY x At least that is the last query visible in the server query log. How to repeat: Build a 64 bit binary, and run the test on Mac OS X 10.4 PowerPC. You can configure like CC="ccache gcc" \ CFLAGS="-Os -arch ppc64 -fno-common" \ CXX="ccache gcc" \ CXXFLAGS="-Os -arch ppc64 -felide-constructors -fno-common" \ LDFLAGS="-arch ppc64" \ ./configure \ --enable-thread-safe-client \ --enable-local-infile \ --with-pic \ --with-client-ldflags="-static" \ --with-mysqld-ldflags="-static" \ --with-zlib-dir=bundled \ --with-big-tables \ --with-yassl \ --with-libedit \ --with-archive-storage-engine \ --with-blackhole-storage-engine \ --with-csv-storage-engine \ --with-example-storage-engine \ --without-falcon \ --with-federated-storage-engine \ --without-innodb \ --with-extra-charsets=complex