[GRASS-dev] Re: [GRASS GIS] #548: grass7 - v.reclass with sqlite driver: Cannot step: SQL logic error or missing database
#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: 6.4.3 Component: Database | Version: svn-releasebranch64 Keywords: v.reclass sqlite |Platform: Unspecified Cpu: Unspecified | --+- Changes (by neteler): * version: svn-trunk = svn-releasebranch64 * milestone: 7.0.0 = 6.4.3 Comment: Backport of trunk r48333 to GRASS 6.5 in r51261. Can I backport to 6.4 as well? The zipcodes_wake example in comment 11 succeeds. -- Ticket URL: http://trac.osgeo.org/grass/ticket/548#comment:13 GRASS GIS http://grass.osgeo.org ___ grass-dev mailing list grass-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-dev
[GRASS-dev] Re: [GRASS GIS] #548: grass7 - v.reclass with sqlite driver: Cannot step: SQL logic error or missing database
#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
[GRASS-dev] Re: [GRASS GIS] #548: grass7 - v.reclass with sqlite driver: Cannot step: SQL logic error or missing database
#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: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. Fixed in r45156, r48157, r48158 (7.0, 6.5, 6.4.2, respectively). Markus M -- Ticket URL: http://trac.osgeo.org/grass/ticket/548#comment:11 GRASS GIS http://grass.osgeo.org ___ grass-dev mailing list grass-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-dev
[GRASS-dev] Re: [GRASS GIS] #548: grass7 - v.reclass with sqlite driver: Cannot step: SQL logic error or missing database
#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 ___ grass-dev mailing list grass-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-dev
[GRASS-dev] Re: [GRASS GIS] #548: grass7 - v.reclass with sqlite driver: Cannot step: SQL logic error or missing database
#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 |
--+-
Changes (by neteler):
* cc: martinl` (removed)
Comment:
Still failing in current GRASS 7 SVN:
{{{
GRASS 7.0.svn (nc_spm_08@grass70):~ v.reclass in=myboundary_county
out=test_recl column=DOT_GROUP_
DBMI-SQLite driver error:
Cannot step:
SQL logic error or missing database
ERROR: Unable to fetch data from table myboundary_county
GRASS 7.0.svn (nc_spm_08@grass70):~ v.db.connect -p myboundary_county
Vector map myboundary_county is connected by:
layer 1/boundary_county table myboundary_county in database
/home/neteler/grassdata/nc_spm_08/grass70/sqlite.db through driver
sqlite with key cat
}}}
It likely affects #1418 (v.dissolve failure) which suppresses error
messages from v.reclass.
--
Ticket URL: http://trac.osgeo.org/grass/ticket/548#comment:9
GRASS GIS http://grass.osgeo.org
___
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev
[GRASS-dev] Re: [GRASS GIS] #548: grass7 - v.reclass with sqlite driver: Cannot step: SQL logic error or missing database
#548: grass7 - v.reclass with sqlite driver: Cannot step: SQL logic error or
missing database
--+-
Reporter: mlennert | Owner: grass-dev@lists.osgeo.org
Type: defect | Status: new
Priority: normal | Milestone: 7.0.0
Component: Database | Version: svn-trunk
Resolution: |Keywords: v.reclass sqlite
Platform: Unspecified | Cpu: Unspecified
--+-
Comment (by wilsonadam):
I can confirm this in GRASS 6.4.0RC5 (2009) with a string field (using my
data, but it does the same thing).
{{{
v.reclass in=pgrid out=pgrid2 type=centroid column=gridID
DBMI-SQLite driver error:
Cannot step:
SQL logic error or missing database
ERROR: Unable to fetch data from table pgrid
}}}
--
Ticket URL: http://trac.osgeo.org/grass/ticket/548#comment:8
GRASS GIS http://grass.osgeo.org
___
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev
[GRASS-dev] Re: [GRASS GIS] #548: grass7 - v.reclass with sqlite driver: Cannot step: SQL logic error or missing database
#548: grass7 - v.reclass with sqlite driver: Cannot step: SQL logic error or missing database --+- Reporter: mlennert | Owner: grass-dev@lists.osgeo.org Type: defect | Status: new Priority: normal | Milestone: 7.0.0 Component: Database | Version: svn-trunk Resolution: |Keywords: v.reclass sqlite Platform: Unspecified | Cpu: Unspecified --+- Changes (by mlennert): * keywords: v.reclass = v.reclass sqlite * component: Vector = Database * summary: grass7: v.reclass segfaults on string column = grass7 - v.reclass with sqlite driver: Cannot step: SQL logic error or missing database Comment: Replying to [comment:6 neteler]: After the fix in the spatial index I can reproduce the problem with SQLite: I confirm: no more segfault, don't where that came from, but same error as Markus and Martin. Changing title of bug -- Ticket URL: http://trac.osgeo.org/grass/ticket/548#comment:7 GRASS GIS http://grass.osgeo.org ___ grass-dev mailing list grass-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-dev
