List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:August 9 2002 1:25pm
Subject:Re: myisamchk: Can't unlock file (Errcode: 11)
View as plain text  
DO NOT run myisamchk while the server is running.

lorenzo.kh wrote:

>Hi,
>I am using mysql 4.0.0-aplha on win 2000 professional.
>I install mysql in c:\mysql.
>I write a script ( customerscript.txt) and i save this script in
>c:\mysql\bin.
>The contents of customerscript.txt I will paste at the bottom of this mail.
>Then,I run my script at the command prompt.
>
>C:\mysql\bin>mysql < customerscript.txt
>
>And later on I try to check the table using the command below.
>And I get the error and warning.
>
>C:\mysql\bin>myisamchk ../data/test/customer
>Checking MyISAM file: ../data/test/customer
>Data records:       1   Deleted blocks:       0
>myisamchk: warning: 1 clients is using or hasn't closed the table properly
>- check file-size
>- check key delete-chain
>- check record delete-chain
>- check index reference
>- check data record references index: 1
>myisamchk: Can't unlock file (Errcode: 11)
>- check record links
>myisamchk: error:  11 when locking indexfile '../data/test/customer'
>
>Can anybody tell me what actually is this error?
>
>**************************************
>customerscript.txt
>**************************************
>use test;
>
>create table customer(
>id integer not null auto_increment primary key,
>name varchar(20),
>address varchar(150)
>);
>
>insert into customer (id,name,address) values
>(null,'Good customer','Good customer address');
>
>quit
>
>******************************************
>
>---------------------------------------------------------------------
>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 <mysql-thread116720@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
myisamchk: Can't unlock file (Errcode: 11)lorenzo.kh9 Aug
  • Re: myisamchk: Can't unlock file (Errcode: 11)Gerald Clark9 Aug