<html style="direction: ltr;">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body bidimailui-charset-is-forced="true" style="direction: ltr;"
text="#000000" bgcolor="#FFFFFF">
<br>
<br>
<div class="moz-cite-prefix">On 2017-07-10 10:56 AM, Sören Gebbert
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAPHDReJaOgXUq52627zFNayKc7+Rt-RK7BSnUz4cLfXV0sF2Jg@mail.gmail.com">
<div dir="auto">
<div>Hi,
<div dir="auto">This seems to be a bug in the name creation of
the output raster maps. Can you please try grass 7.3? Mybe
it was already fixed there.</div>
<div dir="auto"><br>
</div>
</div>
</div>
</blockquote>
Fixed in the daily release, Thanks!<br>
<br>
<blockquote type="cite"
cite="mid:CAPHDReJaOgXUq52627zFNayKc7+Rt-RK7BSnUz4cLfXV0sF2Jg@mail.gmail.com">
<div dir="auto">
<div>
<div dir="auto">Best regards</div>
<div dir="auto">Soeren</div>
<br>
<div class="gmail_extra"><br>
<div class="gmail_quote">Am 10.07.2017 9:53 AM schrieb
"Micha Silver" <<a href="mailto:tsvibar@gmail.com"
moz-do-not-send="true">tsvibar@gmail.com</a>>:<br
type="attribution">
<blockquote class="quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="elided-text">Hello:<br>
<br>
I'm trying to do pattern detection of an STRDS (hourly
precipitation from radar images) with a cycle of 3
hrs. The last step, t.rast.accdetect errors as follows
(after finishing to create the pattern rasters):<br>
<br>
Traceback (most recent call last):<br>
File "/usr/lib/grass72/scripts/t.ra<wbr>st.accdetect",
line 592, in <module><br>
ERROR: Unable to main()<br>
execute transaction: File
"/usr/lib/grass72/scripts/t.ra<wbr>st.accdetect", line
437, in main<br>
<br>
INSERT INTO raster_base ( name ,creator ,mapset
,creation_time<br>
,temporal_type ,id ) VALUES ('pat_2016_07_12_10'
,'micha' ,'micha'<br>
,'2017-07-09 23:51:24.106063' ,'absolute'
,'pat_2016_07_12_10@micha') ;<br>
INSERT INTO raster_absolute_time ( start_time
,idregister_null, empty_maps, dbif)<br>
,end_time ) File "/usr/lib/grass72/scripts/t.ra<wbr>st.accdetect",
line 479, in create_strds_register_maps<br>
VALUES<br>
('2016-07-12 10:00:00' ,'pat_2016_07_12_10@micha'
,'2016-07-12 11:00:00') ;<br>
INSERT INTO raster_spatial_extent ( north ,bottom
,west ,top ,proj ,east<br>
,id ,south ) VALUES (-3758645.000000 ,0.000000
,-523462.000000 ,0.000000<br>
,'XY' ,376538.000000 ,'pat_2016_07_12_10@micha'
,-4658645.000000) ;<br>
INSERT INTO raster_metadata ( max ,rows
map.insert(dbif)<br>
,min File "/usr/lib/grass72/etc/python/g<wbr>rass/temporal/abstract_map_dat<wbr>aset.py",
line 275, in insert<br>
,datatype ,number_of_cells<br>
,cols ,ewres ,nsres ,id ) VALUES (2.000000 ,900
,1.000000 ,'CELL' ,810000<br>
,900 return AbstractDataset.insert(self,
dbif=dbif, execute=execute)<br>
,1000.000000 ,1000.000000 File
"/usr/lib/grass72/etc/python/g<wbr>rass/temporal/abstract_dataset<wbr>.py",
line 405, in insert<br>
,'pat_2016_07_12_10@micha') ;<br>
INSERT INTO raster_stds_register ( id ,registered_stds
) VALUES<br>
('pat_2016_07_12_10@micha' ,NULL) ;<br>
dbif.execute_transaction(state<wbr>ment)<br>
File "/usr/lib/grass72/etc/python/g<wbr>rass/temporal/core.py",
line 1021, in execute_transaction<br>
return self.connections[mapset].execu<wbr>te_transaction(statement)<br>
File "/usr/lib/grass72/etc/python/g<wbr>rass/temporal/core.py",
line 1315, in execute_transaction<br>
self.cursor.executescript(stat<wbr>ement)<br>
sqlite3.IntegrityError: UNIQUE constraint failed: <a
href="http://raster_base.id" rel="noreferrer"
target="_blank" moz-do-not-send="true">raster_base.id</a><br>
<br>
</div>
If I understand correctly, the 'id' (Primary Key) in
raster_base is created from the raster name and mapset.
So why am I getting this "UNIQUE constraint failed"
error? Any tips?
<div class="quoted-text"><br>
<br>
Thanks, Micha<br>
<br>
-- <br>
Micha Silver<br>
</div>
Ben Gurion Univ.<br>
Sde Boker, Remote Sensing Lab<br>
<a href="tel:052-3665918" value="+49523665918"
target="_blank" moz-do-not-send="true">052-3665918</a><br>
<br>
______________________________<wbr>_________________<br>
grass-user mailing list<br>
<a href="mailto:grass-user@lists.osgeo.org"
target="_blank" moz-do-not-send="true">grass-user@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/grass-user"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://lists.osgeo.org/mailma<wbr>n/listinfo/grass-user</a></blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
052-3665918</pre>
</body>
</html>