[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:9 neteler]:
 > Still failing in current GRASS 7 SVN:

 and the two other branches.

 >
 > It likely affects #1418 (v.dissolve failure) which suppresses error
 messages from v.reclass.

 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.

 BTW, there is a test in lib/db if a database is already opened when
 opening a database, this test is called quite often but it never
 complains.

 Markus M

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