[GRASS-dev] Re: [GRASS GIS] #1358: WinGRASS 6.4.1: SQLite driver errors: `Unable to open database'

[GRASS GIS]

#1358: WinGRASS 6.4.1: SQLite driver errors: `Unable to open database'
-------------------------------------+--------------------------------------
 Reporter:  rvanderweide             |       Owner:  grass-dev@…              
     Type:  defect                   |      Status:  new                      
 Priority:  critical                 |   Milestone:  6.4.2                    
Component:  Database                 |     Version:  6.4.1 RCs                
 Keywords:  wingrass, SQLite driver  |    Platform:  MSWindows 7              
      Cpu:  x86-64                   |  
-------------------------------------+--------------------------------------

Comment(by glynn):

 Replying to [comment:5 hamish]:

 > I would not think that you could fopen() a dir in Windows, holding the
 rest of the dir hostage.

 The message "unable to open database file" corresponds to SQLITE_CANTOPEN,
 which occurs if SQLite can't open the database for non-straightfoward
 reasons (there are separate codes for the more common cases, e.g. where
 the database doesn't exist, the database is locked, insufficient
 permissions, etc).

 Apparently, this can happen on Windows due to other programs scanning
 files in the background, which prevents them from being replaced.
 TortoiseSVN and Windows Search are common culprits. Use of "PRAGMA
 journal_mode ..." has been suggested as a workaround.

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/1358#comment:6>
GRASS GIS <http://grass.osgeo.org>