Mantis Bugtracker
Main | My View | View Issues | Change Log | Roadmap | Docs | My Account
  

Viewing Issue Simple Details [ Jump to Notes ] [ View Advanced ] [ Issue History ] [ Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000097 [sqliteman] SQL engine minor always 2008-02-05 15:23 2009-09-25 14:49
Reporter yura_dev View Status public  
Assigned To
Priority normal Resolution open  
Status new   Product Version
Summary 0000097: Locked database's file after open another database
Description OS: Windows
Build: svn revision 390
Reproduce:
1. Open database1 with any table
2. Run sql query, for example "select * from <table_name>"
3. Open database2.

Result: file with database1 locked.
I think maybe previrous file or database not close, when you open another database.
Additional Information
Tags No tags attached.
Attached Files

- Relationships

-  Notes
(0000169)
subzero (administrator)
2008-02-05 15:38

 is it locked in the meaning of "database locks" or "filesystem lock"?
(0000170)
yura_dev (reporter)
2008-02-05 15:39

 filesystem
(0000178)
subzero (administrator)
2008-02-11 14:03

 I cannot reproduce it at all. But I did some changes in the DB closing/opening. Can you test latest SVN, please?

BTW where to find that is the file locked in Windows, please? Properties/Attributes?
(0000179)
yura_dev (reporter)
2008-02-11 16:19

 In revision 404 is still exist.

> BTW where to find that is the file locked in Windows, please? Properties/Attributes?

I don't know easy way to see it. When I open database2 (third step reproduce) I try delete database1. Windows dont delete file because it use. I think because file's database not closed.
(0000182)
wiaz (developer)
2008-02-13 11:23

 open database1, do something, then open another database2. when i want to open database with another manager i have database1 file locked till i ecit sqliteman! it is similar, isnt it? :D
(0000183)
wiaz (developer)
2008-02-13 11:25

 i think after every query, commit or something, database or file should be leaved.. alone in peace:) all connections should be closed...
(0000277)
thenlich (reporter)
2009-05-28 14:32

 I have the same bug with version 1.2.1. Very annoying.

Here is how to reproduce:

C>sqlite3 db1.sdb
sqlite> create table t(a);
sqlite> .exit
C>sqlite3 db2.sdb
sqlite> create table t(a);
sqlite> .exit
C>sqliteman db1.sdb
[double click table t]
[open db2.sdb]
C>del db1.sdb
 Cannot delete the file, File is used by other process
(0000280)
liteman (reporter)
2009-09-25 14:49

 I have the same problem with a locked database file (sqliteman 1.2.1).
The only difference to the before mentioned cases is that the database file itself has some problems and therefore can not be loaded by sqliteman ("Can not open database file xyz - possibly not a database file") or something like that.
Afterwards sqliteman holds the file handle of the database file that can not be loaded.

BTW: Opened file handles can AFAIK only be viewed using external tools, e.g. Sysinternals ProcessExplorer.

- Issue History
Date Modified Username Field Change
2008-02-05 15:23 yura_dev New Issue
2008-02-05 15:38 subzero Note Added: 0000169
2008-02-05 15:39 yura_dev Note Added: 0000170
2008-02-11 14:03 subzero Note Added: 0000178
2008-02-11 16:19 yura_dev Note Added: 0000179
2008-02-13 11:23 wiaz Note Added: 0000182
2008-02-13 11:25 wiaz Note Added: 0000183
2009-05-28 14:32 thenlich Note Added: 0000277
2009-09-25 14:49 liteman Note Added: 0000280

Mantis 1.1.7[^]
Copyright © 2000 - 2008 Mantis Group
Powered by Mantis Bugtracker