Metrics stop loading to Postgres

Question

I am getting the following error: ERROR: nextval: reached maximum value of sequence "metrics_id_seq" (2147483647).

The maximum ID for metrics is slightly lower than this value, but the sequencer seems to grab a block that puts it over the maximum state. In my metrics table, I see large gaps in the metrics ID each time I add a new server (host), service, portal, etc. I cleaned up some old components I did not need, but the sequencer does not seem to reuse old, unused IDs.

It seems that I either need to renumber all my metrics IDs and the corresponding child tables or set this ID to a much higher number. Has anyone else encountered this issue and found a solution? So far, I have received no help from the ticket I opened, and I do not want to touch the database without ESRI approval.

JamesBrattonVHB · Answer

Here it is - BUG-000175372 for ArcGIS Monitor

JamesBrattonVHB · Answer

I'm getting the same error on ArcGIS Monitor 2024.1.1.  I opened a case with Esri Support on 6/17 explaining that this looks like a database error, but the analyst has still not looked at the database.  When ArcGIS Monitor attempts to insert a new metric reading into the database, it fails.  All the charts in Monitor show "No data available".  I assume that is because Monitor has stopped inserting data.

postgresql_data\log files show

ERROR: nextval: reached maximum value of sequence "metrics_id_seq" (2147483647)
STATEMENT: insert into "metrics" ("base_r_id", "component_id", "observer_id", "r_id")

Derek Law · Answer

Hi @anasga_81182,

It would help if you and @TimLehn could please open a case with Esri Tech Support. They can collect more detailed information about your scenarios. We need to be able to reproduce this behavior to verify it's a bug.

Thanks.