[GRASS-dev] possible error in WIKI could cause data corruption

[Markus Neteler]

On Sep 6, 2015 1:10 AM, "Michael Barton" <Michael.Barton at asu.edu> wrote:
>
> So I decided to try this with 7.0 and looked again at the mapset. It
turns out that the folder is there but not the sqlite.db.
>
> So perhaps we need to add to the WIKI that you might need to create the
sqlite.db

To my knowledge GRASS is designed to generate the file automatically, so
the absence in your car is a bug.

> However, when I tried to create the database, it doesn’t seem to work.
>
> db.createdb driver=sqlite
database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db
> dbmi: db_create_database() not implemented
> dbmi: db_create_database() not implemented
>
> No error. Just no database.

I never used that for above mentioned reason...

Markus

>
> Michael
> ____________________
> C. Michael Barton
> Director, Center for Social Dynamics & Complexity
> Professor of Anthropology, School of Human Evolution & Social Change
> Head, Graduate Faculty in Complex Adaptive Systems Science
> Arizona State University
>
> voice:  480-965-6262 (SHESC), 480-965-8130/727-9746 (CSDC)
> fax: 480-965-7671 (SHESC),  480-727-0709 (CSDC)
> www: http://www.public.asu.edu/~cmbarton, http://csdc.asu.edu
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> > On Sep 5, 2015, at 11:26 AM, Markus Neteler <neteler at osgeo.org> wrote:
> >
> > On Sat, Sep 5, 2015 at 7:51 PM, Michael Barton <Michael.Barton at asu.edu>
wrote:
> >> I don’t know if this is bad advice in the GRASS WIKI or a bug in a
GRASS
> >> database module. I have some vector files that were somehow imported
into a
> >> dbf DBMS last year. I wanted to switch them all to sqlite. The GRASS
WIKI
> >> advises…
> >>
> >> Convert automatically all GRASS 6 vector maps to GRASS 7 (including
> >> attribute transfer from DBF to SQLite)
> >
> >
> >
https://grasswiki.osgeo.org/wiki/Convert_all_GRASS_6_vector_maps_to_GRASS_7
> >
> > ...
> >
> >> The vectors already had GRASS 7 topology, but I ran v.rebuild.all just
to be
> >> sure. No problem.
> >>
> >> db.connect -d ran with no problem
> >>
> >> But v.db.reconnect.all -cd did not create tables in the sqlite database
> >
> > But the sqlite file is there?
> >
> >> and corrupted the existing connection of the first table it hit.
Fortunately, I
> >> made a backup of the mapset before I started this.
> >
> > Perhaps a problem on Mac?
> > This is strange - I have converted so many mapsets like that ..., even
> > with lots of vector maps inside.
> > The wiki page is there for a long time, I didn't see such reports so
far.
> >
> >> GRASS 7.1.svn (Spain_fieldwork_medlands_ERTS89_Z30):~ >
v.db.reconnect.all
> >> -cd
> >>
> >>
--------------------------------------------------------------------------------
> >> Reconnecting vector map <catastro at surveyboundaries> (1 of 9)...
> >>
--------------------------------------------------------------------------------
> >> Copying table <catastro> to target database...
> >> Traceback (most recent call last):
> >>  File
> >>
"/Applications/GRASS/GRASS-7.1.app/Contents/MacOS/scripts/db.droptable",
> >> line 99, in <module>
> >>    main()
> >>  File
> >>
"/Applications/GRASS/GRASS-7.1.app/Contents/MacOS/scripts/db.droptable",
> >> line 77, in main
> >>    used = grass.db.db_table_in_vector(table)
> >>  File
> >>
"/Applications/GRASS/GRASS-7.1.app/Contents/MacOS/etc/python/grass/script/db.py",
> >> line 184, in db_table_in_vector
> >>    from vector import vector_db
> >> ImportError: No module named vector
> >
> > Maybe something got broken in GRASS 7.1?
> >
> > I would definitely use 7.0 for such operations.
> >
> > Markus
> >
> >> ERROR: Unable to drop table <catastro>
> >> GRASS 7.1.svn (Spain_fieldwork_medlands_ERTS89_Z30):~ >
> >>
> >> Michael
> >> ____________________
> >> C. Michael Barton
> >> Director, Center for Social Dynamics & Complexity
> >> Professor of Anthropology, School of Human Evolution & Social Change
> >> Head, Graduate Faculty in Complex Adaptive Systems Science
> >> Arizona State University
> >>
> >> voice:  480-965-6262 (SHESC), 480-965-8130/727-9746 (CSDC)
> >> fax: 480-965-7671 (SHESC),  480-727-0709 (CSDC)
> >> www: http://www.public.asu.edu/~cmbarton, http://csdc.asu.edu
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-dev/attachments/20150906/6e6db3c0/attachment.html>