Indexer Erroring out with Duplicate Entries for Production Build about ortelius HOT 10 CLOSED

The message: Error 1062: Duplicate entry -- is not an actual error.

from ortelius.

The message: Error 1062: Duplicate entry -- is not an actual error.

Thank you @tasinco for your response. But when we query the indexer around that time, we always get 0,

curl "http://localhost:8080/v2/aggregates?startTime=2020-09-21T00:00:00Z&endTime=2020-10-21T00:00:00Z"

{
  "aggregates": {
    "startTime": "2020-09-21T00:00:00Z",
    "endTime": "2020-10-21T00:00:00Z",
    "transactionVolume": "0",
    "transactionCount": 0,
    "addressCount": 0,
    "outputCount": 0,
    "assetCount": 0
  },
  "startTime": "2020-09-21T00:00:00Z",
  "endTime": "2020-10-21T00:00:00Z"
}

from ortelius.

The message: Error 1062: Duplicate entry -- is not an actual error.

There is no data after 2020-09-10 00:00:00.000000 and thats the date in the error too. Can you please suggest whats the issue?

from ortelius.

start time is inclusive end time is not..
remove endtime or increase it into the future..

from ortelius.

start time is inclusive end time is not..
remove endtime or increase it into the future..

Even if we try without the endTime, we don't get any results after 2020-09-10T00:00:00Z

Please have a look,

[root@ip-172-31-27-19 ~]# curl "http://localhost:8080/v2/aggregates?startTime=2020-09-10T00:00:00Z"
{"aggregates":{"startTime":"2020-09-10T00:00:00Z","endTime":"2021-02-11T22:08:40Z","transactionVolume":"359999999999990210","transactionCount":77,"addressCount":4936,"outputCount":38844,"assetCount":1},"startTime":"2020-09-10T00:00:00Z","endTime":"2021-02-11T22:08:40Z"}

[root@ip-172-31-27-19 ~]#
[root@ip-172-31-27-19 ~]#
[root@ip-172-31-27-19 ~]#
[root@ip-172-31-27-19 ~]# curl "http://localhost:8080/v2/aggregates?startTime=2020-09-11T00:00:00Z"

{"aggregates":{"startTime":"2020-09-11T00:00:00Z","endTime":"2021-02-11T22:08:52Z","transactionVolume":"0","transactionCount":0,"addressCount":0,"outputCount":0,"assetCount":0},"startTime":"2020-09-11T00:00:00Z","endTime":"2021-02-11T22:08:52Z"}
[root@ip-172-31-27-19 ~]#

from ortelius.

The duplicate row was not inserted.. The first row that did insert set the timestamp. You would need the timestamp of the first row. This is still not an issue.

from ortelius.

The duplicate row was not inserted.. The first row that did insert set the timestamp. You would need the timestamp of the first row. This is still not an issue.

Thank you @tasinco for your response. I can totally understand what you are saying that duplicate rows were not inserted. I am confused to understand that why the subsequent rows are not inserted either? The ones after the duplicated row, and how can I resume inserting the rows?

from ortelius.

Subsequent non duplicated rows will be inserted.. It is possible that you have not had any new rows added possibly because the node is still bootstrapping.
You can query the db to check what rows were added.

from ortelius.

Let the team at GitHub fix your issues asap

from ortelius.

You can review: https://github.com/ava-labs/ortelius/blob/master/docs/production.md <- on how to setup ortelius.

from ortelius.