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. wrote:

>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
>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?
>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');
>Before posting, please check:
>   (the manual)
>           (the list archive)
>To request this thread, e-mail <mysql-thread116720@stripped>
>To unsubscribe, e-mail
> <>
>Trouble unsubscribing? Try:

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