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?
Nikos
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@PERMANENT' ,'mean') ;
INSERT INTO strds_absolute_time ( start_time ,granularity ,id ,map_time
,end_time ) VALUES (NULL ,NULL ,'ols@PERMANENT' ,NULL ,NULL) ;
INSERT INTO strds_spatial_extent ( north ,bottom ,west ,top ,proj ,east ,id
,south ) VALUES (NULL ,NULL ,NULL ,NULL ,'XY' ,NULL ,'ols@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@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
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@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.dbIs 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 mainmaps
-- 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@PERMANENT' ,'mean') ;
INSERT INTO strds_absolute_time ( start_time ,granularity ,id ,map_time
,end_time ) VALUES (NULL ,NULL ,'ols@PERMANENT' ,NULL ,NULL) ;
INSERT INTO strds_spatial_extent ( north ,bottom ,west ,top ,proj ,east ,id
,south ) VALUES (NULL ,NULL ,NULL ,NULL ,'XY' ,NULL ,'ols@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@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
existsNikos
_______________________________________________
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev
Sören Gebbert wrote:
that seems to be a bug in the temporal framework.
Can you please create a ticket, adding your example?
http://trac.osgeo.org/grass/ticket/2590
Nikos