[GRASS-user] sqlite-db broken?

[Markus Metz]

On Mon, Jul 16, 2012 at 2:14 PM, Johannes Radinger <JRadinger at gmx.at> wrote:
> Hi again,
>
> I did another test now and found out following:
>
> It seems that the problem with the sqlite database
> might be related to the directory of my grass location.
> When I try my to save the location on my local drive
> everything works, there is just a problem when
> my location points to a directory which is actually a mounted
> samba network drive (mount cifs).
>
> Here an output of the directory which is actually a network drive:
> radinger at grassgis:~$ ls -la /home/radinger/U_Radinger/05_GRASS/GRASS_locations/
> total 0
> drwxrwxrwx 5 radinger radinger 0 Jul 16 12:01 .
> drwxrwxrwx 6 radinger radinger 0 Jul 13 14:09 ..
> drwxrwxrwx 4 radinger radinger 0 Jul 16 11:43 xxx
> drwxrwxrwx 4 radinger radinger 0 Jan 26  2009 gisdemo_ncspm
> drwxrwxrwx 4 radinger radinger 0 Jul 12 14:16 spearfish60
> drwxrwxrwx 3 radinger radinger 0 Jul 16 10:44 xxx
>
> and:
> radinger at grassgis:~$ ls -la /home/radinger/U_Radinger/05_GRASS/GRASS_locations/gisdemo_ncspm/sqlite/
> total 6
> drwxrwxrwx 3 radinger radinger   0 Jul 16 13:15 .
> drwxrwxrwx 4 radinger radinger   0 Jan 26  2009 ..
> -rwxrwxrwx 1 radinger radinger  24 Jul 16 12:08 .bash_history
> -rwxrwxrwx 1 radinger radinger 556 Jul 16 12:03 .bashrc

This file:
> -rwxrwxrwx 0 radinger radinger 512 Jul 16 12:04 cifs2e55

looks strange to me.

> -rwxrwxrwx 1 radinger radinger   0 Jul 16 12:03 sqlite.db
> drwxrwxrwx 2 radinger radinger   0 Jul 16 12:02 .tmp
> -rwxrwxrwx 1 radinger radinger  74 Nov  3  2008 VAR
> drwxrwxrwx 1 radinger radinger   0 Nov  3  2008 vector
> -rwxrwxrwx 1 radinger radinger 361 Nov  3  2008 WIND
>
>
> Does anyone know hat causes the problem exactly and what should I change?

There is a relatively new feature in sqlite3, it want to obtain an
exclusive lock on the directory where the sqlite database is. If any
file in that directory is kept open by another application, sqlite
will refuse to open the database. Maybe the above mentioned file
cifs2e55 is kept open by the cifs driver.

Some things to try:
set default db connection to
$GISDBASE/$LOCATION_NAME/$MAPSET/db/sqlite.db
manually create the directory
$GISDBASE/$LOCATION_NAME/$MAPSET/db/
and copy the vector again.

Try GRASS 7 because the sqlite driver in GRASS 7 prints many more
errors reported by sqlite3.
Try to open the sqlite database directly with sqlite3 or one of the sqlite GUIs.

Use nfs instead of cifs if possible.

HTH,

Markus M

>
> The db-connection is set to $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db (checked in the VAR file as well)
> Maybe the GRASS can't tranlate from the relative path to a hardcoded one when the $GISDBASE is already located on a mounted network drive?
>
> /Johannes
>
> -------- Original-Nachricht --------
>> Datum: Mon, 16 Jul 2012 12:04:40 +0200
>> Von: "Johannes Radinger" <JRadinger at gmx.at>
>> An: grass-user at lists.osgeo.org
>> Betreff: [GRASS-user] sqlite-db broken?
>
>> Hi,
>>
>> I used to use db.test (with test=test1) to test my sqlite database
>> connection. In the most recent verson of GRASS 6.4.3 (rev 52380) it seems to be
>> broken. I tried it on some of my own databases and a freshly downloaded
>> sample dataset (small NC dataset, mapset=sqlite). I started it from the gui but
>> it just get stucked in the process (no output after several
>> minutes)...stopping it leaves the database in an incosistent state.
>>
>> Thats why I tried just to simply copy a vector file (e.g streams) from
>> PERMANENT to sqlite. Then I get the error message: Unable to open header file
>> of vector <streams at sqlite> Unable to read head file....
>>
>> Somehow working with sqlite doesn't work properly on my machine (Ubuntu
>> 12.04) although I the command sqlite3 in the terminal works....
>>
>> I also tried it with 6.5 SVN (rev. 52380) and a fresh NC dataset again:
>> db.test just gives: Busy SQLITE db, already waiting for 10 seconds...
>>
>> What else do I need to test so that someone of you might know the problem
>> of my basic database functions (creating tables eg. when tranforming from
>> raster to vector etc.)? Can anyone reproduce this or is it just a behavior
>> due to my own compilation (configured with sqlite3 support)?
>>
>> /Johannes
>> _______________________________________________
>> grass-user mailing list
>> grass-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/grass-user
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user