Bug #19388 On MacOSX 10.4 mysqld fails to load system framework
Submitted: 26 Apr 2006 23:12 Modified: 3 Sep 2006 14:23
Reporter: Matthew Kosnik Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.21-standard-log OS:MacOS (MacOSX 10.4.6 Client)
Assigned to: CPU Architecture:Any

[26 Apr 2006 23:12] Matthew Kosnik
Description:
For the past several versions I have noticed mysqld taking up an entire processor on my dual G5.  The following is a typical sample the process (mysqld):

2006-04-27 09:06:20.437 sample[23987] Waiting 20 msecs for System framework to be loaded...
2006-04-27 09:06:20.458 sample[23987] Waiting 40 msecs for System framework to be loaded...
2006-04-27 09:06:20.498 sample[23987] Waiting 80 msecs for System framework to be loaded...
2006-04-27 09:06:20.580 sample[23987] Waiting 160 msecs for System framework to be loaded...
2006-04-27 09:06:20.740 sample[23987] Waiting 320 msecs for System framework to be loaded...
2006-04-27 09:06:21.060 sample[23987] Waiting 640 msecs for System framework to be loaded...
2006-04-27 09:06:21.700 sample[23987] Waiting 1280 msecs for System framework to be loaded...
2006-04-27 09:06:22.988 sample[23987] Waiting 2560 msecs for System framework to be loaded...
2006-04-27 09:06:25.548 sample[23987] *** Process unreadable: 1
2006-04-27 09:06:25.550 sample[23987] thread_read_stack: invalid frame pointer: fffff840
2006-04-27 09:06:25.561 sample[23987] thread_read_stack: invalid frame pointer: fffff840
...
2006-04-27 09:06:28.542 sample[23987] thread_read_stack: invalid frame pointer: fffff840

How to repeat:
This occurs on my machine (Dual G5 2.0GHz) running MacOSX 10.4.6 (Darwin Kernel Version 8.6.0) and mysql standard-5.0.20a-osx10.4-powerpc-64bit (also occured using: mysql-standard-5.0.18-osx10.4-powerpc-64bit)...  I am willing to provide whatever additional information I can to help solve this problem.
[26 Apr 2006 23:14] Matthew Kosnik
mysqld sample

Attachment: Sample of mysqld.txt (text/plain), 73.36 KiB.

[27 Apr 2006 14:33] Valeriy Kravchuk
Thank you for a problem report. Please, send the my.cnf content and usual results of SHOW PROCESSLIST while mysqld demonstrates the behaviour you described. Is there anything unusual in the error log?
[27 Apr 2006 22:14] Matthew Kosnik
my.cnf file

Attachment: my.cnf (application/octet-stream, text), 4.83 KiB.

[27 Apr 2006 22:16] Matthew Kosnik
There is never anything "happening" or unusual with the process list... I checked this first, because I have on a few occasions written infinite joins or some such thing and had to kill the resulting process.

Process list:

+-------+---------+-----------+------+---------+-------+-------+------------------+
| Id    | User    | Host      | db   | Command | Time  | State | Info             |
+-------+---------+-----------+------+---------+-------+-------+------------------+
| 26310 | gbr     | localhost |      | Sleep   | 7357  |       |                  |
| 27737 | gbr     | localhost |      | Sleep   | 7313  |       |                  |
| 28539 | gbr     | localhost |      | Sleep   | 21075 |       |                  |
| 30007 | gbr     | localhost |      | Sleep   | 21043 |       |                  |
| 30334 | gbr     | localhost |      | Sleep   | 20934 |       |                  |
| 30465 | gbr     | localhost |      | Sleep   | 7420  |       |                  |
| 32420 | mkosnik | localhost |      | Query   | 0     |       | show processlist |
+-------+---------+-----------+------+---------+-------+-------+------------------+
[12 May 2006 10:14] Valeriy Kravchuk
Please, try to repeat with a newer version, 5.0.21 (64-bit, if possible), and inform about the results.
[2 Jun 2006 4:31] Matthew Kosnik
happened again...

mysql 5.0.21-standard-log
Darwin Kernel Version 8.6.0: Tue Mar  7 16:58:48 PST 2006
[2 Jun 2006 4:32] Matthew Kosnik
sample of mysqld

Attachment: Sample of mysqld 20060602.txt (text/plain), 24.08 KiB.

[2 Jun 2006 4:34] Matthew Kosnik
mysql> show processlist;
+-------+---------+-----------+------+---------+-------+-------+------------------+
| Id    | User    | Host      | db   | Command | Time  | State | Info             |
+-------+---------+-----------+------+---------+-------+-------+------------------+
| 14000 | mkosnik | localhost | NULL | Sleep   | 24429 | NULL  | NULL             | 
| 14302 | gbr     | localhost | NULL | Sleep   | 16243 | NULL  | NULL             | 
| 14565 | gbr     | localhost | NULL | Sleep   | 13341 | NULL  | NULL             | 
| 15854 | gbr     | localhost | NULL | Sleep   |  5470 | NULL  | NULL             | 
| 16703 | gbr     | localhost | NULL | Sleep   |  1598 | NULL  | NULL             | 
| 16999 | mkosnik | localhost | NULL | Query   |     0 | NULL  | show processlist | 
+-------+---------+-----------+------+---------+-------+-------+------------------+
6 rows in set (0.00 sec)
[3 Aug 2006 14:23] Valeriy Kravchuk
Please, try to repeat with a newer version, 5.0.24, just released, and inform about the results.
[3 Sep 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".