topic Re: Metrics stop loading to Postgres in ArcGIS Monitor Questions

Metrics stop loading to Postgres

TimLehn — Mon, 03 Mar 2025 21:09:14 GMT

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.

Re: Metrics stop loading to Postgres

DerekLaw — Thu, 06 Mar 2025 04:29:46 GMT

HI @TimLehn,

What version/release of ArcGIS Monitor are you using?

> ERROR: nextval: reached maximum value of sequence "metrics_id_seq" (2147483647).

Where are you seeing this error message?

> In my metrics table, I see large gaps in the metrics ID each time I add a new server (host), service, portal, etc.

Can you please elaborate - what do you mean by "metrics table"? Can you please provide a screenshot? I'm not clear on your issue.

Re: Metrics stop loading to Postgres

Craig_Lunde — Thu, 06 Mar 2025 13:44:12 GMT

I recently had this issue where monitor stopped collecting all data for me. I changed the cycle value from no to yes.

Postgres offers various methods to deal with the stated issue, such as resetting the sequence, altering the maximum value of the sequence, repeating the sequence, and so on. Method 1: Use Cycle Option - Specifying the cycle option will restart the sequence once it reaches the maximum limit.

https://www.commandprompt.com/education/how-to-fix-nextval-reached-maximum-value-of-sequence-error-in-postgresql/

Re: Metrics stop loading to Postgres

anasga_81182 — Fri, 23 May 2025 06:56:40 GMT

Hi all, I have encountered the same issue. I have the latest version of Monitor installed and i was forced to activate the cycled option in the sequence called metrics_id_seq. using this command,
ALTER SEQUENCE metrics_id_seq CYCLE;
I am not sure if this is the best option to tackle this. there are absolutely other options.
I guess @DerekLaw this is a bug or an enhancement that needs to be considered in the next version
Thanks
Anas

Re: Metrics stop loading to Postgres

DerekLaw — Mon, 26 May 2025 16:19:28 GMT

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.

Re: Metrics stop loading to Postgres

JamesBrattonVHB — Mon, 23 Jun 2025 19:03:34 GMT

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")

Re: Metrics stop loading to Postgres

JamesBrattonVHB — Tue, 01 Jul 2025 12:45:03 GMT

Here it is - BUG-000175372 for ArcGIS Monitor