Bug #4059 | problem with indexes, after it, MYI destroyed | ||
---|---|---|---|
Submitted: | 8 Jun 2004 15:43 | Modified: | 13 Aug 2004 22:14 |
Reporter: | András Bártházi | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: MyISAM storage engine | Severity: | S1 (Critical) |
Version: | 4.1.1 | OS: | Linux (Debian Linux) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
[8 Jun 2004 15:43]
András Bártházi
[16 Jun 2004 20:10]
Hartmut Holzgraefe
I ran a test script for about an hour that uses your table definition and adds, modifies and deletes entries at random. After 10.000 INSERTS, 1.000.000 UPDATES and 5.000 DELETES i still see no corruption. Could you please try 4.1.2 and see if the problem persists?
[16 Jun 2004 21:16]
Hartmut Holzgraefe
I now stopped the test run at 160.000 INSERTS and 16.000.000 UPDATES and checked file integrity with myisamchk -> still no problems.
[16 Jun 2004 22:19]
András Bártházi
The bug may be in binary table files?
Attachment: problem.zip (application/zip, text), 1.20 KiB.
[16 Jun 2004 22:28]
András Bártházi
I've installed 4.1.2, and I created a table with the script I sent to you. And the problem wasn't there, but it was strange to me, that the re-creation (inserting the data into this "shadow" table) was so fast. So I started 4.1.1 again. And the problem wasn't there. Strange. Then I've truncated the real, live table, and started to inserting the data again. And it's there. The problem is the same: server:/backup# mysql -u username -p id <digests.sql Enter password: ********* ERROR 1062 at line 800: Duplicate entry '%s' for key 5 I've truncated the table again, and attached the zip. I hope, it'll help you. I guess comparing the bytes of table's binaries created by you, and what I sent, maybe tell you what can be a problem... If I can help you, just tell me. :) Anyway, I used MySQL 4.1.1 for about a week, and it seem'd to be OK (except this problem).
[17 Jun 2004 13:14]
Hartmut Holzgraefe
can you please upload the digests.sql script, too?