MySQL Bugs: #41189: No debug symbols in 5.1.30 build for Mac OSX (mysql-5.1.30-osx10.5-x86.dmg)

Bug #41189	No debug symbols in 5.1.30 build for Mac OSX (mysql-5.1.30-osx10.5-x86.dmg)
Submitted:	2 Dec 2008 22:59	Modified:	25 Dec 2008 8:15
Reporter:	Andrew Hanna	Email Updates:
Status:	Verified
Category:	Server: Packaging	Severity:	S2 (Serious)
Version:	5.1.30	OS:	Mac OS X (10.5.5)
Assigned to:	Kent Boortz	Target Version:	5.1+
Tags:	debugging symbols, regression
Triage:	Triaged: D3 (Medium)

Description:
After upgrading the MySQL 5.1.30 I get tons of errors when trying to debug an Apache/PHP request through gdb.  The errors occur when gdb is trying to load the symbols for MySQL.

How to repeat:
cd /path/to/apache/bin
gdb httpd
run -X

Output attached as separate file.

Suggested fix:
My assumption is that the debugging symbols are not included in the distribution I downloaded.  This also did not work in 5.0.67 which I was using before.  It did work in 5.0.51-b which was the version I was using previous to 5.0.67.

My apologies if the error messages are not what they seem, but this was my best guess as to what the problem is.

Symbol errors.

Attachment: symbols.txt (text/plain), 31.88 KiB.

Thank you for the report.

How did you compile PHP?

'./configure' '--with-mysqli=/usr/local/mysql/bin/mysql_config' '--prefix=/usr/local/php-5.3' '--enable-mbstring' '--enable-mbregex' '--disable-simplexml' '--with-zlib' '--with-mysql=/usr/local/mysql' '--with-tidy' '--with-openssl' '--with-curl=/usr/local/' '--with-pcre-regex' '--with-apxs2=/usr/sbin/apxs' '--enable-debug'

I can repeat the problem using the following command.

shell> gdb --args /usr/local/mysql-advanced-gpl-5.1.30-osx10.5-x86_64/bin/mysqld [someoptions]
GNU gdb 6.3.50-20050815 (Apple version gdb-962) (Sat Jul 26 08:14:40 UTC 2008)
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "i386-apple-darwin"...Reading symbols for shared libraries .. done

warning: Could not find object file "/Users/mysqldev/tmp-200811061622-5.1.30-9082/osx10.5-x86_64/mysql-5.1.30/sql/sql_lex.o" - no debug information available for "sql_lex.cc".

warning: Could not find object file "/Users/mysqldev/tmp-200811061622-5.1.30-9082/osx10.5-x86_64/mysql-5.1.30/sql/sql_handler.o" - no debug information available for "sql_handler.cc".

warning: Could not find object file "/Users/mysqldev/tmp-200811061622-5.1.30-9082/osx10.5-x86_64/mysql-5.1.30/sql/sql_partition.o" - no debug information available for "sql_partition.cc".

warning: Could not find object file "/Users/mysqldev/tmp-200811061622-5.1.30-9082/osx10.5-x86_64/mysql-5.1.30/sql/item.o" - no debug information available for "item.cc".

warning: Could not find object file "/Users/mysqldev/tmp-200811061622-5.1.30-9082/osx10.5-x86_64/mysql-5.1.30/sql/item_sum.o" - no debug information available for "item_sum.cc".

:
snip
:

I also confirmed that the problem happens on MySQL Enterprise 5.0.74 and 5.0.66sp1. MySQL Community 5.0.51b didn't cause such a problem like below:

shell> gdb --args /usr/local/mysql-5.0.51b-osx10.5-x86_64/bin/mysqld [someoptions]
GNU gdb 6.3.50-20050815 (Apple version gdb-962) (Sat Jul 26 08:14:40 UTC 2008)
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "i386-apple-darwin"...Reading symbols for shared libraries ... done

(gdb)

Also ran into this problem working with mysql-advanced-gpl-5.1.30-osx10.5-x86