mysqldumpslow doesn't work

Thanks for taking the time to report a bug and help improve Ubuntu.

On Thu, Jan 17, 2008 at 01:20:27PM -0000, Arnold Daniels (Jasny) wrote:
> Binary package hint: mysql-server-5.0
>

Could you specify which version of mysql-server-5.0 you're using ?

 status incomplete

Thank you,

--
Mathias

I'm running Ubuntu 7.10
ii mysql-server-5.0 5.0.45-1ubuntu3.1 MySQL database server binaries

This what you see:
  arnold@arnold-laptop:~$ sudo mysqldumpslow
  Can't find '/var/lib/mysql/*-slow.log'

This is what it should do:
  root@prime:/home/arnold# mysqldumpslow

  Reading mysql slow query log from /var/log/mysql/mysql-slow.log
  Count: 1 Time=125.00s (125s) Lock=0.00s (0s) Rows=0.0 (0), CN20060370[CN20060370]@localhost
  ...

Please use this new patch file, the other doesn't work because I used copy/paste.

I am still able to reproduce this in hardy as well.

Regards
chuck

This bug was fixed in the package mysql-dfsg-5.0 - 5.0.51-3ubuntu1

---------------
mysql-dfsg-5.0 (5.0.51-3ubuntu1) hardy; urgency=low

  [Mathias Gug]
  * Merge from debian unstable, remaining changes:
    - debian/control:
      - Set Maintainer to Ubuntu Core dev. Move Debian maintainer
        to XSBC-Original-Maintainer.
      - Add mysql-doc-5.0 as a Suggests to mysql-client-5.0, mysql-server-5.0
        and libmysqlclient15-dev.
    - debian/rules: Apply same configuration options on lpia as for i386.
  * debian/control:
    - Preprend XS-Original- to Vcs-{Browser,Svn}.
  * debian/rules:
    - Support DEB_BUILD_OPTIONS option 'nocheck' to skip tests.
  * Dropped patches:
    - debian/patches/91_bug29389.dpatch:
        fix for mysql bug 27383 which causes mysql-test 'mysql_client_test'
        to fail due to gcc 4.x optimizations.
    - debian/libmysqlclient15-dev.files, debian/mysql-client-5.0.files,
      debian/mysql-server-5.0.files: man pages are GPLed now.
  * Improved error message when unable to connect using debian-sys-maint. (LP:
    #153868)

  [Chuck Short]
  * Replcaed --with-comment="Debian" with --with-comment="Ubuntu" in debian/rules (LP: #134384)
  * Added note about the "/etc/mysql/conf.d" directory in my.cnf (LP: #136225)
  * Fixed mysqlhotcopy failure. (LP: #162393)
  * Fixed mysqlslowdump usage. Added patch from Arnold Daniels <email address hidden>. (LP: #183762)

 -- Mathias Gug <email address hidden> Fri, 25 Jan 2008 04:10:49 -0500

The bug may have been fixed in version 5.0.51-3ubuntu1 but it is (slightly altered) back in 5.0.51a-3ubuntu5.1, that is hardy and intrepid.

Patch attached.

This bug was fixed in the package mysql-dfsg-5.0 - 5.1.30really5.0.83-0ubuntu1

---------------
mysql-dfsg-5.0 (5.1.30really5.0.83-0ubuntu1) karmic; urgency=low

  [ Norbert Tretkowski ]
  * New upstream release.

  [ Mathias Gug ]
  * Merge from debian unstable, remaining changes:
   + debian/control:
    - Add a mysql-doc-5.0 as a Suggest to mysql-client-5.0, mysql-server-5.0
      and libmysql15-dev
    - Prepend XS-Original- to Vcs-{Browser, SVN}.
    - Lower mailx from a Recommends to a Suggests, which is pulling in
      exim4 on all installs fo mysql-server. (LP: #259477)
   + debian/rules:
     - Apply same configuration options on lpia as for i386.
     - Add -fno-strict-aliasing to fix FTBFS failures in the mysql
       testsuite.
     - Install mysqld AppArmor profile.
   + debian/additions/my.cnf:
     - Error message files are located in a different directory in MySQL 5.1.
       Setting the language option to use /usr/share/mysql/ breaks 5.1.
       Both 5.0 and 5.1 use a default value that works. (LP: #316974).
     - remove skip-bdb option. This option is not available in 5.1 anymore.
       Moreover 5.0 isn't build with the BerkeleyDB engine. (LP: #316849)
   + Create mysql-server-core-5.0 package for files needed by Akonadi.
   + Add mysqld AppArmor profile:
     - debian/apparmor-profile: mysqld AppArmor profile.
     - debian/mysql-server-5.0.README.Debian: add a note about mysqld AppArmor
       profile.
     - debian/mysql-server-5.0.files: ship mysqld AppArmor profile.
     - debian/mysql-server-5.0.postinst: reload mysqld AppArmor profile.
     - debian/rules: install mysqld AppArmor profile.
     - debian/additions/my.cnf: add warning about apparmor. (LP: #201799)
   + Fixes random build failures:
     - 90_upstream_bug_23921.dpatch (http://bugs.mysql.com/bug.php?id=23921).
     - 91_ubuntu_buildd_testfailures.dpatch: disable tests that fail
       randomly only on the amd64 buildd.
   + Fix log-slow-queries option: (LP: #183762)
     - debian/patches/57-fix-mysqlslowdump-config.dpatch: support
       log_slow_queries option in mysqlslowdump.
     - debian/additions/my.cnf: use log-slow-queries instead of
       log_slow_queries.
  * debian/patches/38_scripts__mysqld_safe.sh__signals.dpatch: wait in the
    SIGHUP trap to avoid killing an existing mysqld process when a HUP
    signal is sent to mysqld_safe. (LP: #326768)
  * Dropped from Ubuntu:
    + debian/patches/92_ssl_test_cert.dpatch: Fixed in 5.0.78.
    + Fix man page conflicts with mysql-doc-5.0 when upgrading from gutsy
      for mysql-server-5.0, mysql-client-5.0, and libmysqlclient15-dev
      packages.
    + Replaces and Conflicts apparmour-profiles << 2.1+1075-0ubuntu4 to allow
      proper upgrades from gutsy.
    + Follow ApparmorProfileMigration and force apparmor complain mode on some
      upgrades (LP: #203531)
      - debian/control: Recommends apparmor >= 2.1+1075-0ubuntu6
      - debian/mysql-server-5.0.dirs: add etc/apparmor.d/force-complain
      - debian/mysql-server-5.0.preinst: create symlink for force-complain/
        on pre-feisty upgrades, upgrades where apparmor-profiles profile is
        unchanged (ie non-enforcing) and upgrades wher...