Your message dated Fri, 8 Apr 2005 00:40:53 +0200
with message-id <[EMAIL PROTECTED]>
and subject line Closing old bug reports
has caused the attached Bug report 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 I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 2 Jun 2004 13:10:29 +0000
>From [EMAIL PROTECTED] Wed Jun 02 06:10:29 2004
Return-path: <[EMAIL PROTECTED]>
Received: from www.iku-ag.de (smuf.rk4.iku-netz.de) [212.88.142.145]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1BVVVl-0003Op-00; Wed, 02 Jun 2004 06:10:29 -0700
Received: from smuf (smuf.rk4.iku-netz.de [212.88.142.145])
by smuf.rk4.iku-netz.de (Postfix on smtp.iku-ag.de) with ESMTP id
2FF86F9460
for <[EMAIL PROTECTED]>; Wed, 2 Jun 2004 15:10:27 +0200 (CEST)
Received: from iku-ag.de (leeloo.loc0.iku-netz.de [192.168.0.11])
by smuf.rk4.iku-netz.de (Postfix on smtp.iku-ag.de) with ESMTP id
69FBBF9457
for <[EMAIL PROTECTED]>; Wed, 2 Jun 2004 15:10:26 +0200 (CEST)
Message-ID: <[EMAIL PROTECTED]>
Date: Wed, 02 Jun 2004 15:10:26 +0200
From: Kurt Huwig <[EMAIL PROTECTED]>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113
X-Accept-Language: de-de, en-us, en
MIME-Version: 1.0
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: mysql-server: DELETE-ing a large number of records trashes the table
X-Enigmail-Version: 0.83.6.0
X-Enigmail-Supports: pgp-inline, pgp-mime
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS perl-11
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2004_03_25
X-Spam-Level:
Package: mysql-server
Version: 3.23.49-8.5
Severity: grave
Justification: renders package unusable
We had the problem desribed here (Got error 127 from table handler):
http://lists.mysql.com/mysql/164250
on our Debian System. We were able to fix it with 'REPAIR TABLE':
mysql> repair table journal;
+----------------+--------+----------+----------------------------------------------+
| Table | Op | Msg_type | Msg_text
|
+----------------+--------+----------+----------------------------------------------+
| sponts.journal | repair | info | Found wrong stored record at
7651268 |
| sponts.journal | repair | info | Found wrong stored record at
7651940 |
| sponts.journal | repair | warning | Number of rows changed from
124644 to 124639 |
| sponts.journal | repair | status | OK
|
+----------------+--------+----------+----------------------------------------------+
4 rows in set (12.59 sec)
But as we delete lots of rows every day, it is liketo to reoccur.
-- System Information
Debian Release: 3.0
Architecture: i386
Kernel: Linux minilinux 2.4.20ctx-16-p5mmx #1 Mon Mar 17 03:12:41 CET
2003 i686
Locale: LANG=C, LC_CTYPE=C
Versions of packages mysql-server depends on:
ii adduser 3.47 Add and remove users and groups
ii debconf 1.2.35 Debian configuration
management sy
ii libc6 2.2.5-11.5 GNU C Library: Shared
libraries an
ii libdbi-perl 1.21-2 The Perl5 Database
Interface by Ti
ii libmysqlclient10 3.23.49-8.5 mysql database client library
ii libstdc++2.10-glibc2.2 1:2.95.4-11woody1 The GNU stdc++ library
ii libwrap0 7.6-9 Wietse Venema's TCP
wrappers libra
ii mysql-client 3.23.49-8.5 mysql database client binaries
ii perl 5.6.1-8.6 Larry Wall's Practical
Extraction
ii psmisc 20.2-2.1 Utilities that use the proc
filesy
ii zlib1g 1:1.1.4-1.0woody0 compression library - runtime
---------------------------------------
Received: (at 252276-done) by bugs.debian.org; 7 Apr 2005 22:40:55 +0000
>From [EMAIL PROTECTED] Thu Apr 07 15:40:55 2005
Return-path: <[EMAIL PROTECTED]>
Received: from gate.lathspell.de (app109.intern) [212.117.68.82]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1DJfgE-0008PW-00; Thu, 07 Apr 2005 15:40:54 -0700
Received: by app109.intern (Postfix, from userid 1000)
id E3B1C2C909; Fri, 8 Apr 2005 00:40:53 +0200 (CEST)
Date: Fri, 8 Apr 2005 00:40:53 +0200
From: Christian Hammers <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Closing old bug reports
Message-ID: <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.6+20040907i
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-3.0 required=4.0 tests=BAYES_00 autolearn=no
version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
I'm closing these bug reports as they were quite old and flagged
unreproducible for a white.
bye,
-christian-
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]