[GRASS-dev] Re: [GRASS GIS] #548: grass7 - v.reclass with sqlite driver: "Cannot step: SQL logic error or missing database"

[GRASS GIS]

#548: grass7 - v.reclass with sqlite driver: "Cannot step: SQL logic error or
missing database"
------------------------------+---------------------------------------------
 Reporter:  mlennert          |       Owner:  grass-dev@…              
     Type:  defect            |      Status:  new                      
 Priority:  normal            |   Milestone:  7.0.0                    
Component:  Database          |     Version:  svn-trunk                
 Keywords:  v.reclass sqlite  |    Platform:  Unspecified              
      Cpu:  Unspecified       |  
------------------------------+---------------------------------------------

Comment(by mmetz):

 Replying to [comment:11 mmetz]:
 > Replying to [comment:10 mmetz]:
 > >
 > > Debugging a bit, the problem of v.reclass with the sqlite driver seems
 to be that the same database is opened twice (once by each driver
 instance), which causes database locking, therefore it is not possible to
 use one driver instance to fetch records from one table and use another
 driver instance to insert records into another table, all in the same
 sqlite database.
 >
 > Now it's possible, the other driver just has to wait a little bit until
 the first driver is finished.
 >
 Correction, only now (trunk r48333) it's possible. There were more bugs,
 both in v.reclass and in the sqlite driver.

 A test, within the sqlite mapset of nc_spm_08:
 {{{
 g.copy vect=zipcodes_wake,my_zipcodes_wake
 v.dissolve input=my_zipcodes_wake at sqlite layer=1 column=ZIPNAME
 output=zip_names
 }}}

 Markus M

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/548#comment:12>
GRASS GIS <http://grass.osgeo.org>