Your message dated Fri, 09 May 2008 04:47:07 +0000 with message-id <[EMAIL PROTECTED]> and subject line Bug#478256: fixed in mysql-dfsg-5.0 5.0.51a-6 has caused the Debian Bug report #478256, regarding mysql-server-5.0: since last upgrade, mysql reports error when starting to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [EMAIL PROTECTED] immediately.) -- 478256: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=478256 Debian Bug Tracking System Contact [EMAIL PROTECTED] with problems
--- Begin Message ---Package: mysql-server-5.0 Version: 5.0.51a-4 Severity: normal Hi, since last upgrade, each time is start mysql-server, I get a mail with subject WARNING: mysqlcheck has found corrupt tables and with content: 345 0 0 0 84 29880 1259065 29880 29880 197059 21001375 0 3 0 36 401 825 475 0 0 0 0 0 0 0 0 0 5 Improperly closed tables are also reported if clients are accessing the tables *now*. A list of current connections is below. +----+------------------+-----------+----+---------+------+-------+------------------+ +----+------------------+-----------+----+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------------------+-----------+----+---------+------+-------+------------------+ | 35 | debian-sys-maint | localhost | | Query | 0 | | show processlist | +----+------------------+-----------+----+---------+------+-------+------------------+ Uptime: 1 Threads: 1 Questions: 99 Slow queries: 0 Opens: 30 Flush tables: 1 Open tables: 24 Queries per second avg: 99.000 when running mysqlcheck or myisamchk, I don't find an error. That error report comes from check_for_crashed_tables when running from command line: mysql -N -b -p -e 'select concat("select count(*) from ",TABLE_SCHEMA,".", TABLE_NAME) from information_schema.TABLES where ENGINE="MyISAM"' | xargs -i mysql -N -q -p -e "{}" I get numbers reported in the mail (345, 0, 0, 0, 84 etc) on stdin and nothing on stderr. It looks like check_for_crashed_tables checks to see if there is anything on stdout or stderr whereas it should check only if there is something on stderr. arno -- System Information: Debian Release: lenny/sid APT prefers unstable APT policy: (990, 'unstable'), (1, 'experimental') Architecture: i386 (i686) Kernel: Linux 2.6.22custom Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages mysql-server-5.0 depends on: ii adduser 3.107 add and remove users and groups ii debconf [debconf-2.0] 1.5.21 Debian configuration management sy ii libc6 2.7-10 GNU C Library: Shared libraries ii libdbi-perl 1.604-1 Perl5 database interface by Tim Bu ii libgcc1 1:4.3.0-3 GCC support library ii libmysqlclient15off 5.0.51a-4 MySQL database client library ii libncurses5 5.6+20080419-2 Shared libraries for terminal hand ii libreadline5 5.2-3 GNU readline and history libraries ii libstdc++6 4.3.0-3 The GNU Standard C++ Library v3 ii libwrap0 7.6.q-15 Wietse Venema's TCP wrappers libra ii lsb-base 3.2-10 Linux Standard Base 3.2 init scrip ii mysql-client-5.0 5.0.51a-4 MySQL database client binaries ii mysql-common 5.0.51a-4 MySQL database common files ii passwd 1:4.1.1-1 change and administer password and ii perl 5.8.8-12 Larry Wall's Practical Extraction ii psmisc 22.6-1 Utilities that use the proc filesy ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime Versions of packages mysql-server-5.0 recommends: ii bsd-mailx [mailx] 8.1.2-0.20071201cvs-2 A simple mail user agent ii libhtml-template-p 2.9-1 HTML::Template : A module for usin ii mailx 1:20071201-2 Transitional package for mailx ren -- debconf information: mysql-server-5.0/really_downgrade: false * mysql-server-5.0/need_sarge_compat: false mysql-server-5.0/start_on_boot: true mysql-server/error_setting_password: mysql-server-5.0/nis_warning: mysql-server-5.0/postrm_remove_databases: false mysql-server-5.0/need_sarge_compat_done: true mysql-server/password_mismatch:
--- End Message ---
--- Begin Message ---Source: mysql-dfsg-5.0 Source-Version: 5.0.51a-6 We believe that the bug you reported is fixed in the latest version of mysql-dfsg-5.0, which is due to be installed in the Debian FTP archive: libmysqlclient15-dev_5.0.51a-6_i386.deb to pool/main/m/mysql-dfsg-5.0/libmysqlclient15-dev_5.0.51a-6_i386.deb libmysqlclient15off_5.0.51a-6_i386.deb to pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.51a-6_i386.deb mysql-client-5.0_5.0.51a-6_i386.deb to pool/main/m/mysql-dfsg-5.0/mysql-client-5.0_5.0.51a-6_i386.deb mysql-client_5.0.51a-6_all.deb to pool/main/m/mysql-dfsg-5.0/mysql-client_5.0.51a-6_all.deb mysql-common_5.0.51a-6_all.deb to pool/main/m/mysql-dfsg-5.0/mysql-common_5.0.51a-6_all.deb mysql-dfsg-5.0_5.0.51a-6.diff.gz to pool/main/m/mysql-dfsg-5.0/mysql-dfsg-5.0_5.0.51a-6.diff.gz mysql-dfsg-5.0_5.0.51a-6.dsc to pool/main/m/mysql-dfsg-5.0/mysql-dfsg-5.0_5.0.51a-6.dsc mysql-server-5.0_5.0.51a-6_i386.deb to pool/main/m/mysql-dfsg-5.0/mysql-server-5.0_5.0.51a-6_i386.deb mysql-server_5.0.51a-6_all.deb to pool/main/m/mysql-dfsg-5.0/mysql-server_5.0.51a-6_all.deb A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [EMAIL PROTECTED], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Monty Taylor <[EMAIL PROTECTED]> (supplier of updated mysql-dfsg-5.0 package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [EMAIL PROTECTED]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.8 Date: Tue, 29 Apr 2008 20:49:05 -0700 Source: mysql-dfsg-5.0 Binary: libmysqlclient15off libmysqlclient15-dev mysql-common mysql-client-5.0 mysql-server-5.0 mysql-server mysql-client Architecture: source all i386 Version: 5.0.51a-6 Distribution: unstable Urgency: low Maintainer: Debian MySQL Maintainers <[EMAIL PROTECTED]> Changed-By: Monty Taylor <[EMAIL PROTECTED]> Description: libmysqlclient15-dev - MySQL database development files libmysqlclient15off - MySQL database client library mysql-client - MySQL database client (meta package depending on the latest versi mysql-client-5.0 - MySQL database client binaries mysql-common - MySQL database common files mysql-server - MySQL database server (meta package depending on the latest versi mysql-server-5.0 - MySQL database server binaries Closes: 478256 479697 Changes: mysql-dfsg-5.0 (5.0.51a-6) unstable; urgency=low . * Fix debian-start.inc.sh to not print the row counts of the tables queried. (closes: #478256, #479697) Checksums-Sha1: 5810af95c38bc88e0c3b60cf0d0b394e2cb30586 1707 mysql-dfsg-5.0_5.0.51a-6.dsc 2a327122cb03c60948b06b72f3dc45ebf12d9fd7 618540 mysql-dfsg-5.0_5.0.51a-6.diff.gz 10820a51ecf5845999a7ba0fb00542e159c75b0e 58750 mysql-common_5.0.51a-6_all.deb a22f03bf9c3b4258be91197b93840fe2d156b989 52612 mysql-server_5.0.51a-6_all.deb 6d1cbd0f7ebb8392312c3a2c9378cccf4ac75012 50418 mysql-client_5.0.51a-6_all.deb 5413d0481db52f97c9dda6afba5ec46533d37f59 1852044 libmysqlclient15off_5.0.51a-6_i386.deb dbdbc7db890d7124fe0bd0e6c9facc9c7f51f3a4 7208786 libmysqlclient15-dev_5.0.51a-6_i386.deb 46ffdcd52fa18861447f9f331b2477ac5993c374 7791492 mysql-client-5.0_5.0.51a-6_i386.deb c1c8639b66d29c667474431a61c6aec8fe5649b0 27468728 mysql-server-5.0_5.0.51a-6_i386.deb Checksums-Sha256: ab471a520c678e76da9a2e63cc0cba33fb92bba4e4d4c7d41d2b68ba3f2645ad 1707 mysql-dfsg-5.0_5.0.51a-6.dsc a6fad924eda717fc800a86b5d20b318f93b33708f3afd0d9414a163d18dfd0ee 618540 mysql-dfsg-5.0_5.0.51a-6.diff.gz 5c492308f5758c15b83ad3b9f53d5bfd12c5686e3505301913d54cb05da198a9 58750 mysql-common_5.0.51a-6_all.deb c2eb7687ff2aea779a1bc3ad16aa85818420bac004864e82dfd763b47ab79d4f 52612 mysql-server_5.0.51a-6_all.deb fd21d0b074665186ce6d4bdecffc4ca61b36819e8ed562c198b7fdc1c87f9d9f 50418 mysql-client_5.0.51a-6_all.deb 655e11e84dda838e821af375b8e640e7656608934466dbe834d94b1d9c9489d6 1852044 libmysqlclient15off_5.0.51a-6_i386.deb abc5b42e643a13101125c62e3d2097a44c59ee5892f74b3f5440aca9e27e0731 7208786 libmysqlclient15-dev_5.0.51a-6_i386.deb 633958d20b8844761046c526b7618be5d75d8098618a17a874ed4f1ea7291c12 7791492 mysql-client-5.0_5.0.51a-6_i386.deb c4a3f81abd28adc483321d00d244791a9f9355f114b7caff980d8fc399b8a21e 27468728 mysql-server-5.0_5.0.51a-6_i386.deb Files: 318058bc979815901102333e501aaaee 1707 misc optional mysql-dfsg-5.0_5.0.51a-6.dsc 211a4704d4ff56b31b745de94d62f6b8 618540 misc optional mysql-dfsg-5.0_5.0.51a-6.diff.gz a3addebd1a745949f7580fbb1a264259 58750 misc optional mysql-common_5.0.51a-6_all.deb 9c45fdc606bc77b08a9d710af1f2f854 52612 misc optional mysql-server_5.0.51a-6_all.deb b20b44f190274a79cc644e9816b9f10a 50418 misc optional mysql-client_5.0.51a-6_all.deb 90fd4cdf09b3e652c766b45ef17537eb 1852044 libs optional libmysqlclient15off_5.0.51a-6_i386.deb 9f0a4cac4ad330196b623bb5a83c709f 7208786 libdevel optional libmysqlclient15-dev_5.0.51a-6_i386.deb 2b49765a9ee1c5d9044116b3f61578cb 7791492 misc optional mysql-client-5.0_5.0.51a-6_i386.deb c5816e68d44437788f1665f141a35688 27468728 misc optional mysql-server-5.0_5.0.51a-6_i386.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFII9Rcr/RnCw96jQERArOzAKCG5lo7SWq/uTFF3VghpTzhl4mZRgCeIoMQ Sl8pcQFrDlrDLjPw7x+o11A= =Wopx -----END PGP SIGNATURE-----
--- End Message ---
