EW -> Dante - [TYPE_MAGNITUDE] Duplicate entry 'NOCI-HNE----IV' for key 'sta'
@matteo.quintiliani te lo riporto qui, nel caso volessi indagare...
Il giorno 2021-05-31 Dante ha ritornato un codice 500
ad hew3 con il seguente messaggio:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'NOCI-HNE----IV' for key 'sta' (SQL: insert into scnl (net, sta, cha, loc, modified, inserted) values (IV, NOCI, HNE, --, 2021-05-31T22:42:31.289+00:00, 2021-05-31T22:42:31.289+00:00))
questo il JSON di input:
{
"data": {
"ewLogo": {
"type": "TYPE_MAGNITUDE",
"module": "MOD_LOCALMAG_PREL",
"installation": "INST_INGV",
"instance": "hew3_mole",
"user": "ew",
"hostname": "hew3"
},
"ewMessage": {
"quakeId": 459818,
"version": "ew prelim",
"mag": 2.6,
"error": 0.23,
"quality": 0.62,
"minDist": 26.37,
"azimuth": -1,
"nStations": 6,
"nChannels": 16,
"qAuthor": "014101073:028129073",
"qddsVersion": 0,
"iMagType": 1,
"magType": "ML",
"algorithm": "MED",
"ingvQuality": "B ",
"phases": [
{
"sta": "NOCI",
"comp": "HNE",
"net": "IV",
"loc": "--",
"mag": 2.94,
"dist": 26.37,
"corr": 0.0,
"time1": "2021-05-31T22:41:30.390Z",
"amp1": -3.5,
"period1": -1.0,
"time2": "2021-05-31T22:41:30.020Z",
"amp2": 4.5,
"period2": -1.0
},
{
"sta": "NOCI",
"comp": "HNN",
"net": "IV",
"loc": "--",
"mag": 3.14,
"dist": 26.37,
"corr": 0.0,
"time1": "2021-05-31T22:41:30.210Z",
"amp1": -5.78,
"period1": -1.0,
"time2": "2021-05-31T22:41:30.050Z",
"amp2": 6.79,
"period2": -1.0
},
{
"sta": "NOCI",
"comp": "HHE",
"net": "IV",
"loc": "--",
"mag": 2.65,
"dist": 26.37,
"corr": 0.0,
"time1": "2021-05-31T22:41:30.620Z",
"amp1": -2.02,
"period1": -1.0,
"time2": "2021-05-31T22:41:30.270Z",
"amp2": 2.06,
"period2": -1.0
},
{
"sta": "NOCI",
"comp": "HHN",
"net": "IV",
"loc": "--",
"mag": 3.18,
"dist": 26.37,
"corr": 0.0,
"time1": "2021-05-31T22:41:30.210Z",
"amp1": -6.44,
"period1": -1.0,
"time2": "2021-05-31T22:41:30.050Z",
"amp2": 7.54,
"period2": -1.0
},
{
"sta": "TAR1",
"comp": "HHE",
"net": "OT",
"loc": "--",
"mag": 2.83,
"dist": 43.95,
"corr": 0.0,
"time1": "2021-05-31T22:41:36.050Z",
"amp1": -1.98,
"period1": -1.0,
"time2": "2021-05-31T22:41:35.950Z",
"amp2": 1.87,
"period2": -1.0
},
{
"sta": "TAR1",
"comp": "HHN",
"net": "OT",
"loc": "--",
"mag": 3.02,
"dist": 43.95,
"corr": 0.0,
"time1": "2021-05-31T22:41:34.810Z",
"amp1": -2.43,
"period1": -1.0,
"time2": "2021-05-31T22:41:34.660Z",
"amp2": 3.48,
"period2": -1.0
},
{
"sta": "MESG",
"comp": "HHE",
"net": "IV",
"loc": "--",
"mag": 2.75,
"dist": 57.65,
"corr": 0.0,
"time1": "2021-05-31T22:41:40.430Z",
"amp1": -1.1,
"period1": -1.0,
"time2": "2021-05-31T22:41:40.180Z",
"amp2": 1.21,
"period2": -1.0
},
{
"sta": "MESG",
"comp": "HHN",
"net": "IV",
"loc": "--",
"mag": 2.57,
"dist": 57.65,
"corr": 0.0,
"time1": "2021-05-31T22:41:41.680Z",
"amp1": -0.823,
"period1": -1.0,
"time2": "2021-05-31T22:41:41.620Z",
"amp2": 0.715,
"period2": -1.0
},
{
"sta": "MATE",
"comp": "HHE",
"net": "GE",
"loc": "--",
"mag": 2.56,
"dist": 60.41,
"corr": 0.0,
"time1": "2021-05-31T22:41:39.500Z",
"amp1": -0.73,
"period1": -1.0,
"time2": "2021-05-31T22:41:39.680Z",
"amp2": 0.682,
"period2": -1.0
},
{
"sta": "MATE",
"comp": "HHN",
"net": "GE",
"loc": "--",
"mag": 2.5,
"dist": 60.41,
"corr": 0.0,
"time1": "2021-05-31T22:41:40.730Z",
"amp1": -0.73,
"period1": -1.0,
"time2": "2021-05-31T22:41:41.240Z",
"amp2": 0.504,
"period2": -1.0
},
{
"sta": "AMUR",
"comp": "HNE",
"net": "IV",
"loc": "--",
"mag": 2.52,
"dist": 60.72,
"corr": 0.0,
"time1": "2021-05-31T22:41:40.170Z",
"amp1": -0.561,
"period1": -1.0,
"time2": "2021-05-31T22:41:40.000Z",
"amp2": 0.725,
"period2": -1.0
},
{
"sta": "AMUR",
"comp": "HNN",
"net": "IV",
"loc": "--",
"mag": 2.41,
"dist": 60.72,
"corr": 0.0,
"time1": "2021-05-31T22:41:39.990Z",
"amp1": -0.614,
"period1": -1.0,
"time2": "2021-05-31T22:41:40.390Z",
"amp2": 0.391,
"period2": -1.0
},
{
"sta": "AMUR",
"comp": "HHE",
"net": "IV",
"loc": "--",
"mag": 2.27,
"dist": 60.72,
"corr": 0.0,
"time1": "2021-05-31T22:41:41.050Z",
"amp1": -0.317,
"period1": -1.0,
"time2": "2021-05-31T22:41:41.140Z",
"amp2": 0.422,
"period2": -1.0
},
{
"sta": "AMUR",
"comp": "HHN",
"net": "IV",
"loc": "--",
"mag": 2.42,
"dist": 60.72,
"corr": 0.0,
"time1": "2021-05-31T22:41:41.390Z",
"amp1": -0.605,
"period1": -1.0,
"time2": "2021-05-31T22:41:41.290Z",
"amp2": 0.424,
"period2": -1.0
},
{
"sta": "MRVN",
"comp": "HHE",
"net": "IV",
"loc": "--",
"mag": 2.49,
"dist": 96.27,
"corr": 0.0,
"time1": "2021-05-31T22:41:49.590Z",
"amp1": -0.393,
"period1": -1.0,
"time2": "2021-05-31T22:41:50.040Z",
"amp2": 0.238,
"period2": -1.0
},
{
"sta": "MRVN",
"comp": "HHN",
"net": "IV",
"loc": "--",
"mag": 2.57,
"dist": 96.27,
"corr": 0.0,
"time1": "2021-05-31T22:41:50.130Z",
"amp1": -0.431,
"period1": -1.0,
"time2": "2021-05-31T22:41:50.270Z",
"amp2": 0.319,
"period2": -1.0
}
]
}
}
}