Bug#360709: mysql-server: corruption unfixed by myisamchk -r/-o or repair table
On Mon, Jan 17, 2011 at 7:30 AM, Marc Lehmann schm...@schmorp.de wrote: On Sun, Jan 16, 2011 at 07:28:52PM +0100, Olaf van der Spek olafvds...@gmail.com wrote: I don't know, I don't have such a table anymore (I fixed it by dumping and reimporting). Can the bug be closed? Don't know, has the bug been fixed? I can confirm that myisamchk -A doesn't have any effect either, and maybe these two are related. I don't know. Your best bet is to ask upstream. Olaf -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#360709: mysql-server: corruption unfixed by myisamchk -r/-o or repair table
On Sun, Jan 16, 2011 at 7:21 PM, Marc Lehmann schm...@schmorp.de wrote: On Sun, Jan 16, 2011 at 04:49:13PM +0100, Olaf van der Spek olafvds...@gmail.com wrote: Is this still an issue in Debian Squeeze? I don't know, I don't have such a table anymore (I fixed it by dumping and reimporting). Can the bug be closed? Olaf -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#360709: mysql-server: corruption unfixed by myisamchk -r/-o or repair table
On Sun, Jan 16, 2011 at 07:28:52PM +0100, Olaf van der Spek olafvds...@gmail.com wrote: I don't know, I don't have such a table anymore (I fixed it by dumping and reimporting). Can the bug be closed? Don't know, has the bug been fixed? I can confirm that myisamchk -A doesn't have any effect either, and maybe these two are related. -- The choice of a Deliantra, the free code+content MORPG -==- _GNU_ http://www.deliantra.net ==-- _ generation ---==---(_)__ __ __ Marc Lehmann --==---/ / _ \/ // /\ \/ / schm...@schmorp.de -=/_/_//_/\_,_/ /_/\_\ -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#360709: mysql-server: corruption unfixed by myisamchk -r/-o or repair table
retitle 360709 mysql-server: corrupted auto increment values are not repaired tags 360709 + confirmed upstream wontfix thanks Hello Marc I seem to have overlooked this bug report.. anyway such a problem in 4.0 is best solved by dumping, editing and reimporting the table, AFAIK mysql can or at least could not repair such issues. bye, -christian- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#360709: mysql-server: corruption unfixed by myisamchk -r/-o or repair table
Package: mysql-server Version: 4.0.24-10 Severity: normal The database at http://data.plan9.de/database.tar.gz contains a single table event. Running myisamchk on the event.MYI results in: myisamchk: warning: Auto-increment value: 3295 is smaller than max used value: 1768843105 - check record links MyISAM-table 'event.MYI' is usable but should be fixed The table does not contain a row with a value of 1768843105. Running myisamchk -r (or -o) seems to repair the table, as does the repair table sql command (no error status returned), but the problem persists when running myisamchk. -- System Information: Debian Release: testing/unstable APT prefers unstable APT policy: (500, 'unstable'), (500, 'testing'), (500, 'stable') Architecture: amd64 (x86_64) Shell: /bin/sh linked to /bin/dash Kernel: Linux 2.6.15.1 Locale: LANG=C, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8) Versions of packages mysql-server depends on: ii adduser 3.85Add and remove users and groups ii debconf 1.4.71 Debian configuration management sy hi libc62.3.5-12GNU C Library: Shared libraries an ii libdbi-perl 1.50-2 Perl5 database interface by Tim Bu ii libgcc1 1:4.0.2-5 GCC support library ii libmysqlclient12 4.0.24-10 mysql database client library ii libstdc++5 1:3.3.6-12 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-9 Wietse Venema's TCP wrappers libra ii mailx1:8.1.2-0.20050715cvs-1 A simple mail user agent ii mysql-client 4.0.24-10 mysql database client binaries ii mysql-common 5.0.18-9mysql database common files (e.g. ii passwd 1:4.0.14-3 change and administer password and ii perl 5.8.7-10Larry Wall's Practical Extraction ii psmisc 22.1-1 Utilities that use the proc filesy ii zlib1g 1:1.2.3-11 compression library - runtime mysql-server recommends no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
