Bug #16865 MSAccess *.ldb Lockfile leave-behind
Submitted: 28 Jan 2006 10:28 Modified: 14 Jun 2006 15:15
Reporter: Paul Birkel Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S3 (Non-critical)
Version:1.0.22rc OS:Windows (WinXP)
Assigned to: Michael G. Zinner CPU Architecture:Any

[28 Jan 2006 10:28] Paul Birkel 
Description:
After completion of a migration from MSAccess2003 the lockfile (*.ldb) is left behind.  This appears to indicate that the connection to the Jet engine is not being properly closed before exit from the Migration Toolkit.  My MSJET40.dll version is "4.0.8618.0".

How to repeat:
Migrate any MSAccess database, then examine the files in the directory where the MSAccess source *.mdb resides.  The new *.ldb lockfile will be present.

Suggested fix:
Properly close the connection to the Jet engine before exiting the Migration Toolkit.
[28 Jan 2006 13:49] MySQL Verification Team 
Thank you for the bug report.

Before migration:

C:\testmigration>dir
 O volume na unidade C não tem nome.
 O número de série do volume é 609E-599F

 Pasta de C:\testmigration

28/01/2006  11:44    <DIR>          .
28/01/2006  11:44    <DIR>          ..
28/01/2006  11:45           139.264 mydb.mdb
               1 arquivo(s)        139.264 bytes
               2 pasta(s) 26.902.851.584 bytes disponíveis

After migration done and toolkit closed:

C:\testmigration>dir
 O volume na unidade C não tem nome.
 O número de série do volume é 609E-599F

 Pasta de C:\testmigration

28/01/2006  11:47    <DIR>          .
28/01/2006  11:47    <DIR>          ..
28/01/2006  11:47               128 mydb.ldb
28/01/2006  11:45           139.264 mydb.mdb
               2 arquivo(s)        139.392 bytes
               2 pasta(s) 26.902.786.048 bytes disponíveis
[10 Feb 2006 13:37] MySQL Verification Team 
Bug: http://bugs.mysql.com/bug.php?id=17301 marked as duplicate
of this one.
[14 Jun 2006 15:15] Michael G. Zinner 
We are using the ODBC/JDBC bridge and therefor have no control of how the bridge closes the connection to the Jet engine. If somebody knows hows to fix this, feedback is welcome.