[GRASS-dev] tgis bug in G7?

[Sören Gebbert]

Hi Nikos,
that seems to be a bug in the temporal framework.

Can you please create a ticket, adding your example?

Best regards
Soeren

2015-02-18 11:00 GMT+01:00 Nikos Alexandris <nik at nikosalexandris.net>:
> Nikos Alexandris wrote:
>
>> While the following
>
>
>> t.create type="strds" title="DMSP-OLS" description="Version 4
>> DMSP-OLS Nighttime Lights Time Series" output="ols"
>>
>> works fine in G71 (trunk), it doesn't work in G7 (updated last night).
>
>
>
>> Detail of interest:
>>
>> t.connect -p
>> driver:sqlite
>> database:/mnemosyne/geo/grassdb/ols/PERMANENT/tgis/sqlite.db
>
>
>> Is this a potential bug?
>
>
>
> Sorry, here the output:
>
>
> WARNING: Overwrite space time raster dataset <ols> and unregister all maps.
> Traceback (most recent call last):
>   File
> "/osgeo/src/grass7_release/dist.x86_64-unknown-linux-gnu/scripts/t.create",
> line 83, in <module>
> ERROR: Unable to execute transaction:
> --#############################################################################
> -- This     main()
> SQL script generates the table in which all registered GRASS_MAP  File
> "/osgeo/src/grass7_release/dist.x86_64-unknown-linux-gnu/scripts/t.create",
> line 79, in main
>
> maps
> -- are listed in.
> --
> --     semantic, None, grass.overwrite())
> This table   File
> "/osgeo/src/grass7_release/dist.x86_64-unknown-linux-gnu/etc/python/grass/temporal/open_stds.py",
> line 169, in open_new_space_time_dataset
> will be created for each STDS.
> --
> -- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
> --#############################################################################
>
> -- SPACETIME_NAME is a placeholder for specific stds name (SQL compliant):
> name_mapset
> -- GRASS_MAP     sp.insert(dbif)
> is a placeholder for specific map type: raster,  File
> "/osgeo/src/grass7_release/dist.x86_64-unknown-linux-gnu/etc/python/grass/temporal/abstract_space_time_dataset.py",
> line 366, in insert
>  raster3d or
> vector
>
> -- This table stores the.ids of the GRASS_MAP maps registered in the
> current spacetime GRASS_MAP table
> CREATE TABLE SPACETIME_NAME_GRASS_MAP_register (
> id VARCHAR NOT NULL, -- This colum is a primary key storing the registered
> GRASS_MAP map.ids
> PRIMARY KEY (id)
> );
> CREATE INDEX raster_map_register_dad84f0878c348b49cf467fc4a689a88_index ON
> raster_map_register_dad84f0878c348b49cf467fc4a689a88 (id);INSERT INTO
> strds_base ( name ,creator ,mapset ,creation_time ,modification_time
> ,temporal_type ,id ,semantic_type ) VALUES ('ols' ,'nik' ,'PERMANENT'
> ,'2015-02-18 13:00:57.586753' ,'2015-02-18 13:00:57.586764' ,'absolute'
> ,'ols at PERMANENT' ,'mean') ;
> INSERT INTO strds_absolute_time ( start_time ,granularity ,id ,map_time
> ,end_time ) VALUES (NULL ,NULL ,'ols at PERMANENT' ,NULL ,NULL) ;
> INSERT INTO strds_spatial_extent ( north ,bottom ,west ,top ,proj ,east ,id
> ,south ) VALUES (NULL ,NULL ,NULL ,NULL ,'XY' ,NULL ,'ols at PERMANENT' ,NULL)
> ;
> INSERT INTO strds_metadata ( max_min ,description ,ewres_min ,title
> ,min_max ,nsres_min ,nsres_max ,number_of_maps ,raster_register ,command
> ,min_min ,ewres_max ,id ,max_max ,aggregation_type ) VALUES (NULL ,'test'
> ,NULL ,'test' ,NULL ,NULL ,NULL ,NULL
> ,'raster_map_register_dad84f0878c348b49cf467fc4a689a88' ,'# 2015-02-18
> 13:00:57
> t.create type="strds" title="test" description="test"
> output="ols" --o
> ' ,NULL ,NULL ,'ols at PERMANENT' ,NULL ,NULL) ;
>     dbif.execute_transaction(statement)
>   File
> "/osgeo/src/grass7_release/dist.x86_64-unknown-linux-gnu/etc/python/grass/temporal/core.py",
> line 955, in execute_transaction
>     self.cursor.executescript(statement)
> sqlite3.OperationalError: table SPACETIME_NAME_GRASS_MAP_register already
> exists
>
>
>
> Nikos
> _______________________________________________
> grass-dev mailing list
> grass-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-dev