Avamar: Reporting error code 22602: The database encountered an error for "ERROR: numeric field overflow"

The Avamar Administrator may display the following error:

ID          366048 
Date        2014-12-19 06:23:34 EST 
Type        ERROR 
Code        22602 
Category    SYSTEM 
Severity    PROCESS 
Domain      / 
Summary     The database encountered an error.
SW Source   MCS:DPN_Proxy 
For Whom    All Users 
HW Source   avamar.customer.com 
Description The database encountered an error. 
Remedy      Contact Product Support 
Notes       N/A 
Data        <data><entry key="error" type="xml" value="&amp;lt;exception 

Log data shows an exception similar to:

SQLState="22003" 
errorCode="0" message="
ERROR: numeric field overflow
  
Detail: A field with precision 5, scale 2 must round to an absolute 
value less than 10^3." sql="
insert into sv_node_util ( date_time, node, state, load_avg, cpu_user_pct, 
cpu_sys_pct, net_ping, net_in_kbytes_per_sec, net_out_kbytes_per_sec, 
disk_reads_per_sec, disk_writes_per_sec, utilization,diskreadonly ) values 
( '2014-12-19 11:23:11.000000 +00:00:00','
0.0','ONLINE','
1135.24','0.06','0.21'
,'1.24','0','0','1','78'
,'28.46','65' )
&amp;quot;/&amp;gt;" version="1"/></data>

This indicates that the load_avg value inserted exceeded the allowable precision.

The load_avg metric is sourced from the Linux /proc/loadavg file, which reports average system load over 1, 5, and 15 minutes, along with active task counts and the most recent Process ID (PID).

Examples:

admin@utility:~/>: cat /proc/loadavg
0.00 0.01 0.00 2/262 114867

• Field reports indicate that some grids running Avamar 7.0, 7.0.1, and 7.1 record load averages in the 1100–1300 range during garbage collection.
• It is not yet confirmed whether the reported load values are inaccurate or if momentary system load actually exceeds the expected threshold.

This behavior is considered benign and typically occurs only for a few minutes during heavy garbage‑collection cycles.

The error is unlikely to appear more than once per day and does not indicate a functional failure.

If additional investigation is required, contact Dell Product Support