[GRASS-dev] [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:  minor                    |   Milestone:  6.4.4                    
Component:  Database                 |     Version:  6.4.1 RCs                
 Keywords:  wingrass, SQLite driver  |    Platform:  MSWindows 7              
      Cpu:  x86-64                   |  
-------------------------------------+--------------------------------------

Comment(by mlennert):

 Replying to [comment:12 mmetz]:
 > Replying to [comment:11 mlennert]:
 > > Replying to [comment:10 mmetz]:
 > > > Replying to [comment:9 hamish]:
 > > > > unless someone has a bright idea for a minimally invasive fix,
 bumping it down the road a little ...
 > > >
 > > > With GRASS default settings, i.e. the sqlite database in the default
 folder, this does not happen. Changing priority to minor, but the ticket
 could also be closed as invalid. Essentially, this is a sqlite bug with
 sqlite calling fsync() on the directory of the sqlite database even if the
 directory contains files not related to the sqlite database.
 > >
 > > With the latest wingrass7 (July 18), after installation and download
 of the NC data set, I get the following error:
 > >
 > {{{
 > g.copy vect=roadsmajor at PERMANENT,roads2
 > DBMI-SQLite driver error:
 > Unable to open database:
 > C:\grassdata\North_Carolina\user1\sqlite\sqlite.db
 > unable to open database file
 > no database is open
 > [...]
 > }}}
 >
 > The sqlite mapset has the default settings
 > {{{
 > DB_DRIVER: sqlite
 > DB_DATABASE: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db
 > }}}
 >
 > You must have changed DB_DATABASE to
 > {{{
 > DB_DATABASE: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db
 > }}}

 I didn't touch any config settings. Just installed using the native GRASS
 installer, downloaded the NC dataset, launched GRASS and tried a g.copy.
 From your comment:8 above, I thought that now the second form is the
 normal form (i.e. sqlite/sqlite.db).

 >
 > but I guess that path does not exist.

 Yes, it does not exist.

 >
 > The sqlite driver should be intelligent enough to create a new database
 including the path to the new database if need be.

 Apparently it is not...

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