[GRASS-dev] [GRASS GIS] #2590: t.create fails to create/overwrite a new strds

[GRASS GIS]

#2590: t.create fails to create/overwrite a new strds
-------------------------+--------------------------------------------------
 Reporter:  nikosa       |       Owner:  grass-dev@…              
     Type:  defect       |      Status:  new                      
 Priority:  normal       |   Milestone:  7.0.0                    
Component:  Temporal     |     Version:  svn-releasebranch70      
 Keywords:               |    Platform:  Unspecified              
      Cpu:  Unspecified  |  
-------------------------+--------------------------------------------------
 The command

 `t.create type="strds" title="DMSP-OLS" description="Version 4 DMSP-OLS
 Nighttime Lights Time Series" output="ols"`

 works fine in G71 (trunk) but fails in G7. The relevant output is:


 {{{
 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).

 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
 }}}

-- 
Ticket URL: <http://trac.osgeo.org:80/grass/ticket/2590>
GRASS GIS <http://grass.osgeo.org>