no debug symbols for mysql-server

Status changed to 'Confirmed' because the bug affects multiple users.

Any idea who might be able to help guide me with this?

I haven't had luck yet compiling mysql-server with debug symbols. Although I've added -DWITH_DEBUG=1 to debian/rules build, when dh_strip runs it says that the packages have already been stripped. ddebs are not being built in /var/cache/pbuilder/result/. Based on that I think -DWITH_DEBUG=1 isn't taking effect. I confirmed -DWITH_DEBUG=1 is the correct option (http://dev.mysql.com/doc/refman//5.5/en/compiling-for-debugging.html). Any thoughts?

Here's the steps I'm taking:

# apt-get source mysql-server

Add -DWITH_DEBUG=1 to debian/rules

# grep -C2 DEBUG mysql-5.5-5.5.24/debian/rules
            -DWITH_ARCHIVE_STORAGE_ENGINE=ON \
            -DWITH_BLACKHOLE_STORAGE_ENGINE=ON \
            -DWITH_DEBUG=1 \
            -DWITH_FEDERATED_STORAGE_ENGINE=ON \
                -DWITH_EXTRA_CHARSETS=all ..'

# pbuilder create --debootstrapopts --variant=buildd
# pbuilder --update --extrapackages pkg-create-dbgsym
# pbuilder build mysql-5.5_5.5.24-0ubuntu0.12.04.1.dsc 2>&1 | tee /tmp/pbuildlog

# grep strip /tmp/pbuildlog
dh_strip -a
dh_strip debug symbol extraction: all non-arch-all packages for this build platform amd64: libmysqlclient18 libmysqld-pic libmysqld-dev libmysqlclient-dev mysql-client-core-5.5 mysql-client-5.5 mysql-server-core-5.5 mysql-server-5.5 mysql-testsuite-5.5 mysql-source-5.5
dh_strip debug symbol extraction: packages to act on: libmysqlclient18 libmysqld-pic libmysqld-dev libmysqlclient-dev mysql-client-core-5.5 mysql-client-5.5 mysql-server-core-5.5 mysql-server-5.5 mysql-testsuite-5.5 mysql-source-5.5
dh_strip debug symbol extraction: ignored packages:
libmysqlclient18 is already stripped, ignoring
libmysqld-pic is already stripped, ignoring
libmysqld-dev is already stripped, ignoring
libmysqlclient-dev is already stripped, ignoring
mysql-client-core-5.5 is already stripped, ignoring
mysql-client-5.5 is already stripped, ignoring
mysql-server-core-5.5 is already stripped, ignoring
mysql-server-5.5 is already stripped, ignoring
mysql-testsuite-5.5 is already stripped, ignoring
mysql-source-5.5 is already stripped, ignoring

Chris: Are you planning on fixing this one or should we poke the server team about it?

If there are at least any thoughts that could help me continue debugging this problem that would be helpful.

I'd like to submit a full backtrace to report a crash in Mysql. If I can build the debug symbols correctly without messing with the packaging, I can go that route as well.

This bug was fixed in the package mysql-5.5 - 5.5.28-0ubuntu1

---------------
mysql-5.5 (5.5.28-0ubuntu1) raring; urgency=low

  [ Alex Bligh ]
  * debian/mysql-server-5.5.postinst: Add Create_tablespace_priv which
    was missed in the 5.1 -> 5.5 transition, and regressed GRANT
    privileges for the debian-sys-maint user. (LP: #1062716)

  [ Clint Byrum ]
  * d/rules: Build with debug symbols (LP: #1014872)
 -- Clint Byrum <email address hidden> Tue, 27 Nov 2012 03:50:57 -0800

The Precise Pangolin has reached end of life, so this bug will not be fixed for that release