>Description:
Hi!
My name is Ales Perme. A college of mine Samo Login gave me this adress, which was
given to him by Monty, to report MySQL bugs to.
Production configurations:
1. Windows NT 4.0, Service pack 6a, MySQL 3.23.36
2. Slackware Linux, kernel version: SMP 2.4.18, MySQL 3.23.42-log
The structure of the table we are experianceing problems with is:
CREATE TABLE `repository` (
`DIGEST` varchar(32) NOT NULL default '',
`CONTENT` longblob NOT NULL,
`CONTENT_TYPE` varchar(60) NOT NULL default '',
`CONTENT_LENGTH` int(11) NOT NULL default '-1',
`CONTENT_LANGUAGE` tinyblob,
`LAST_MODIFIED` datetime default NULL,
`LAST_ACCESSED` datetime NOT NULL default '0000-00-00 00:00:00',
`CONTENT_TIMESTAMP` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`DIGEST`),
KEY `REPOSITORY_LAST_ACCESSED` (`LAST_ACCESSED`)
) TYPE=MyISAM MAX_ROWS=400000000
The table has
mysql> select count(*) from repository;
+----------+
| count(*) |
+----------+
| 5673838 |
+----------+
records inside.
1. I get table a "table crashed" whenever I try to fix it or check it with MYISAMCHK
using -r, -o or -f parameters. And the table is then no longer usable.
2. "BACKUP TABLE repository to ..." gives a response code OK. Successfull! But when I
try to restore it with "RESTORE TABLE repository FROM ...", the restore fails and
tryes to restore the table without "quicksort". MySQL server on Windows NT 4.0,
Service Pach 6a crashes with drwatson.
3. If I check the table with SQL statement "CHECK TABLE repository" then I get an OK!
result code.
What can I do? What seems to be the problem. If you need any aditional info please
contact me.
The table itself is 13.1 GB in size and index is 430 MB.
With best regards,
Ales Perme
IT Manager
Novifroum Ltd.
Stegne 31
Ljubljana
S L O V E N I A
>How-To-Repeat:
1. I get table a "table crashed" whenever I try to fix it or check it with MYISAMCHK
using -r, -o or -f parameters. And the table is then no longer usable.
2. "BACKUP TABLE repository to ..." gives a response code OK. Successfull!
But when I try to restore it with "RESTORE TABLE repository FROM ...", the restore
fails and tryes to restore the table without "quicksort". MySQL server on Windows NT
4.0, Service Pach 6a crashes with drwatson.
>Fix:
None available!
>Submitter-Id: <submitter ID>
>Originator: Ales Perme
>Organization: Noviforum Ltd.
>MySQL support: none
>Synopsis: Table crash!
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.36 (Official MySQL binary)
>Server: 3.23.36 for Windows NT
>Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.36-log
>Environment:
System: Windows NT Server v4.0 , Service pack 6a
Architecture: i686
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
