MySQL Bugs: #28726: LCP files not removed after initial system restart

Bug #28726	LCP files not removed after initial system restart
Submitted:	28 May 2007 15:19	Modified:	11 Jun 2007 20:31
Reporter:	Johan Andersson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	5.1.*	OS:	Any
Assigned to:	Jonas Oreland	CPU Architecture:	Any

Description:
LCP directory not emptied after initial node restart

How to repeat:
X-node cluster running 

create table t1(a integer, b char(100))engine=ndb;

insert into t1 (a,b) values(1,'johan');
insert into t1 (a,b) select a,b from t1;
insert into t1 (a,b) select a,b from t1;
insert into t1 (a,b) select a,b from t1;
insert into t1 (a,b) select a,b from t1;
insert into t1 (a,b) select a,b from t1;
insert into t1 (a,b) select a,b from t1;
insert into t1 (a,b) select a,b from t1;
insert into t1 (a,b) select a,b from t1;
insert into t1 (a,b) select a,b from t1;
insert into t1 (a,b) select a,b from t1;
insert into t1 (a,b) select a,b from t1;

ndb_mgm> all clusterlog checkpoint=8
ndb_mgm> all dump 7099
wait for LCP to complete (check cluster log)

ls -al ndb_2_fs/LCP/0

ndb_mgm> all restart -i
wait for started

ls -al ndb_2_fs/LCP/0
Old files still there...

Suggested fix:
remove the files.
while you are at it, delete the data files associated with table spaces and undo logs.

Verified as above in fairly recent 5.1 BK (as 5.1.19).
Not present in 5.0.40

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/28036

ChangeSet@1.2490, 2007-06-04 11:58:25+02:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#28726
    make sure to remove LCP files aswell if specifying --initial

Pushed into 5.1.20-beta

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bugfix in 5.1.20 and telco-6.1.10 changelogs.

Also documented for telco-6.2.3 release.