#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@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>
_______________________________________________
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev
