[GRASS-dev] tgis bug in G7?

[Nikos Alexandris]

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