Bug 729040

Summary: Debuginfo package issues in mysql
Product: Red Hat Enterprise Linux 6 Reporter: Karel Klíč <kklic>
Component: mysqlAssignee: Jakub Dorňák <jdornak>
Status: CLOSED WONTFIX QA Contact: qe-baseos-daemons
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.3CC: byte, databases-maint, hhorak, kklic, ovasik, praiskup, psklenar, rvokal
Target Milestone: rc   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-07-31 09:23:05 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 727919, 947775, 1070830, 1159820    

Description Karel Klíč 2011-08-08 15:20:44 UTC
Several problems related to debuginfo were found in the mysql-5.1.52-1.el6_0.1 package. These issues might affect crash analysis done by Automatic Bug Reporting Tool and its retrace server, and also prevent proper debugging of crashes via GDB.

Debuginfo symbolic link pointing to another path
------------------------------------------------
Debuginfo package includes a symbolic link to each binary that has the debugging symbols stored there. For mysql, one symbolic link does not point to the right binary, and that makes it impossible to use build ids from a coredump to get a list of packages required by it. Usually, this is a packaging error caused usually by placing identical binary into several locations instead of creating a symlink. If one copy of the binary is SUID/SGID, it is not possible to use symlink. You can add a dependency on bug #727872 and rebuild mysql when that bug is fixed.

affected binary: /usr/bin/mysql_config
affected package: mysql-5.1.52-1.el6_0.1.i686
referenced binary: /usr/bin/mysqlbug
referenced package: mysql-server-5.1.52-1.el6_0.1.i686
debuginfo symlink: /usr/lib/debug/.build-id/e0/b1f30f49dbd475b2086462da896661cd2a0f5a

This issue has been solved in Fedora by /usr/lib/rpm/find-debuginfo.sh creating additional symlinks for identical binaries. However, symlinks should be used instead of duplicating a binary when possible.

Source file missing in debuginfo package
----------------------------------------
Multiple source files that were used by the compiler to generate a binary are missing from the debuginfo package. This is usually caused by the build script creating temporary source files during the build and deleting them after usage, or by moving source files between directories. Missing source files in debuginfo packages make debugging of crashes more difficult.

debuginfo package: mysql-debuginfo-5.1.52-1.el6_0.1.i686
  debuginfo file: /usr/lib/debug/usr/bin/mysqltest_embedded.debug
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/pars0lex.l
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/pars0grm.y
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/pars0grm.tab.c
    missing source: /usr/src/debug/mysql-5.1.52/libmysqld/sql_yacc.yy
    missing source: /usr/src/debug/mysql-5.1.52/libmysqld/sql_yacc.h
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/_flex_tmp.c
  debuginfo file: /usr/lib/debug/usr/lib/mysql/libmysqld.so.0.0.1.debug
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/pars0lex.l
    missing source: /usr/src/debug/mysql-5.1.52/libmysqld/sql_yacc.h
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/pars0grm.y
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/pars0grm.tab.c
    missing source: /usr/src/debug/mysql-5.1.52/libmysqld/sql_yacc.yy
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/_flex_tmp.c
  debuginfo file: /usr/lib/debug/usr/libexec/mysqld.debug
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/pars0lex.l
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/pars0grm.y
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/pars0grm.tab.c
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/_flex_tmp.c
  debuginfo file: /usr/lib/debug/usr/bin/mysql_client_test_embedded.debug
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/pars0lex.l
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/pars0grm.y
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/pars0grm.tab.c
    missing source: /usr/src/debug/mysql-5.1.52/libmysqld/sql_yacc.yy
    missing source: /usr/src/debug/mysql-5.1.52/libmysqld/sql_yacc.h
    missing source: /usr/src/debug/mysql-5.1.52/storage/innobase/_flex_tmp.c

Please consider changing the package build script (if that is the cause of this issue) to keep the source files on their compilation place, so rpmbuild can find them when generating debuginfo package.

(This bug was detected and filed by a script.)

Comment 2 RHEL Program Management 2011-08-08 15:41:09 UTC
This request was evaluated by Red Hat Product Management for
inclusion in the current release of Red Hat Enterprise Linux.
Because the affected component is not scheduled to be updated
in the current release, Red Hat is unfortunately unable to
address this request at this time. Red Hat invites you to
ask your support representative to propose this request, if
appropriate and relevant, in the next release of Red Hat
Enterprise Linux. If you would like it considered as an
exception in the current release, please ask your support
representative.

Comment 4 Honza Horak 2013-07-29 10:21:26 UTC
Something like the following seems to make this problem better, except we'll still miss files _flex_tmp.c and pars0grm.tab.c:

# debuginfo extraction scripts fail to find source files in their real
# location -- satisfy them by copying these files into location, which
# is expected by scripts
for e in innobase innodb_plugin ; do
  for f in pars0grm.c pars0grm.y pars0lex.l lexyy.c ; do
    cp -p "storage/$e/pars/$f" "storage/$e/$f" || :
  done
done
for f in sql_yacc.h sql_yacc.yy ; do
  cp -p "sql/$f" "libmysqld/$f" || :
done

Comment 7 Jakub Dorňák 2016-07-27 17:04:19 UTC
Is this issue still valid (years since bug #727872 has been closed)?

Comment 8 Honza Horak 2016-07-31 09:23:05 UTC
I think it has no real consequences, so let's close it.