>>>>> "gunardi" == gunardi <[EMAIL PROTECTED]> writes:
>> Description:
gunardi> Tables always gets corrupted after INSERT
>> How-To-Repeat:
gunardi> CREATE TABLE Admin (
gunardi> adminid varchar(15) DEFAULT '' NOT NULL,
gunardi> origin varchar(15) DEFAULT '' NOT NULL,
gunardi> level enum('frontdesk','administrator','accounting','reporting') DEFAULT
'frontdesk' NOT NULL,
gunardi> PRIMARY KEY (adminid),
gunardi> KEY origin (origin),
gunardi> KEY level (level)
gunardi> );
gunardi> #
gunardi> # Dumping data for table 'Admin'
gunardi> #
gunardi> INSERT INTO Admin VALUES ('dihen','bandung','frontdesk');
gunardi> INSERT INTO Admin VALUES ('endang','salatiga','frontdesk');
gunardi> INSERT INTO Admin VALUES ('hendarko','cianjur','frontdesk');
gunardi> INSERT INTO Admin VALUES ('xbram','salatiga','administrator');
gunardi> INSERT INTO Admin VALUES ('juni','bandung','accounting');
gunardi> Then ('gunardi','bandung','administrator') was inserted later through mysql
client
gunardi> isamchk -a /usr/local/var/customer/Admin.ISM
gunardi> Checking ISAM file: /usr/local/var/customer/Admin.ISM
gunardi> Data records: 6 Deleted blocks: 0
gunardi> - check file-size
gunardi> isamchk: error: Size of datafile is: 103 Should be: 124
gunardi> - check delete-chain
gunardi> - check index reference
gunardi> - check data record references index: 1
gunardi> isamchk: error: Found key at page 1024 that points to record outside datafile
gunardi> - check record links
gunardi> isamchk: error: Record-count is not ok; is 5 Should be: 6
gunardi> isamchk: warning: Found 5 parts Should be: 6 parts
gunardi> ISAM-table '/usr/local/var/customer/Admin.ISM' is corrupted
gunardi> Fix it using switch "-r" or "-o"
gunardi> And this happen again an again
Hi!
Are you sure your mysqld doesn't restart ?
Check the *.log' and *.err' files in the MySQL database directory for
clues.
You should definitely run mysqld with --log to find out exactly what
commands you send to the mysqld server!
Please read the section 'Debugging MySQL' in the MySQL manual; You
may find some tips here that may help you find out what's wrong.
Without being able to reproduce the problem we have a hard time
helping you :(
Regards,
Monty
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
