>Description:
Tables always gets corrupted after INSERT
>How-To-Repeat:
CREATE TABLE Admin (
adminid varchar(15) DEFAULT '' NOT NULL,
origin varchar(15) DEFAULT '' NOT NULL,
level enum('frontdesk','administrator','accounting','reporting') DEFAULT 'frontdesk'
NOT NULL,
PRIMARY KEY (adminid),
KEY origin (origin),
KEY level (level)
);
#
# Dumping data for table 'Admin'
#
INSERT INTO Admin VALUES ('dihen','bandung','frontdesk');
INSERT INTO Admin VALUES ('endang','salatiga','frontdesk');
INSERT INTO Admin VALUES ('hendarko','cianjur','frontdesk');
INSERT INTO Admin VALUES ('xbram','salatiga','administrator');
INSERT INTO Admin VALUES ('juni','bandung','accounting');
Then ('gunardi','bandung','administrator') was inserted later through mysql client
isamchk -a /usr/local/var/customer/Admin.ISM
Checking ISAM file: /usr/local/var/customer/Admin.ISM
Data records: 6 Deleted blocks: 0
- check file-size
isamchk: error: Size of datafile is: 103 Should be: 124
- check delete-chain
- check index reference
- check data record references index: 1
isamchk: error: Found key at page 1024 that points to record outside datafile
- check record links
isamchk: error: Record-count is not ok; is 5 Should be: 6
isamchk: warning: Found 5 parts Should be: 6 parts
ISAM-table '/usr/local/var/customer/Admin.ISM' is corrupted
Fix it using switch "-r" or "-o"
And this happen again an again
>Submitter-Id: <submitter ID>
>Originator: System Administrator
>Organization:
>MySQL support: none<[none | licence | email support | extended email support ]>
>Synopsis: Corrupted table Repeats
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.22.14b-gamma (Source distribution)
>Environment:
System: BSD/OS andromeda.starindo.net 3.0 BSDI BSD/OS 3.0 Kernel #0: Wed Apr 16
15:15:49 MDT 1997 [EMAIL PROTECTED]:/home/polk/sys-3.0patches/compile/GENERIC
i386
Required patches as described in the manual have been applied
Some paths: /usr/bin/perl /usr/bin/make /usr/contrib/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: gcc version 2.7.2.1
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock
--with-low-memory --with-mit-threads=yes
Perl: This is perl, version 5.004_04 built for i386-bsdos
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
