Gitlab Exporter : PG::NumericValueOutOfRange: ERROR: integer out of range

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Label this issue
• Close this issue

Gitlab exporter is complaining about NumericValueOutOfRange :

# curl localhost:9168/metrics

PG::NumericValueOutOfRange: ERROR: integer out of range

/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/database/ci_builds.rb:278:in `exec'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/database/ci_builds.rb:278:in `block (2 levels) in exec_query_with_custom_random_page_cost'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/database/ci_builds.rb:276:in `transaction'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/database/ci_builds.rb:276:in `block in exec_query_with_custom_random_page_cost'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/database/base.rb:59:in `block in with_connection_pool'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/connection_pool-2.2.5/lib/connection_pool.rb:63:in `block (2 levels) in with'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/connection_pool-2.2.5/lib/connection_pool.rb:62:in `handle_interrupt'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/connection_pool-2.2.5/lib/connection_pool.rb:62:in `block in with'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/connection_pool-2.2.5/lib/connection_pool.rb:59:in `handle_interrupt'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/connection_pool-2.2.5/lib/connection_pool.rb:59:in `with'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/database/base.rb:58:in `with_connection_pool'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/database/ci_builds.rb:275:in `exec_query_with_custom_random_page_cost'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/database/ci_builds.rb:195:in `builds'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/database/ci_builds.rb:180:in `run'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/database/ci_builds.rb:303:in `probe_db'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/prober.rb:18:in `block (3 levels) in probe_all'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/prober.rb:17:in `each'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/prober.rb:17:in `block (2 levels) in probe_all'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/prober.rb:15:in `each'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/prober.rb:15:in `block in probe_all'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/prober.rb:14:in `each'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/prober.rb:14:in `probe_all'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/web_exporter.rb:139:in `block (2 levels) in setup_probes'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1697:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1697:in `block in compile!'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1030:in `block (3 levels) in route!'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1049:in `route_eval'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1030:in `block (2 levels) in route!'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1078:in `block in process_route'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1076:in `catch'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1076:in `process_route'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1028:in `block in route!'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1025:in `each'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1025:in `route!'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1147:in `block in dispatch!'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1119:in `block in invoke'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1119:in `catch'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1119:in `invoke'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1142:in `dispatch!'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:956:in `block in call!'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1119:in `block in invoke'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1119:in `catch'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1119:in `invoke'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:956:in `call!'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:945:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/web_exporter.rb:51:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/rack-2.2.7/lib/rack/logger.rb:17:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/gitlab-exporter-12.1.1/lib/gitlab_exporter/web_exporter.rb:25:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/rack-protection-2.2.4/lib/rack/protection/xss_header.rb:18:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/rack-protection-2.2.4/lib/rack/protection/path_traversal.rb:16:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/rack-protection-2.2.4/lib/rack/protection/json_csrf.rb:26:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/rack-protection-2.2.4/lib/rack/protection/base.rb:50:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/rack-protection-2.2.4/lib/rack/protection/base.rb:50:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/rack-protection-2.2.4/lib/rack/protection/frame_options.rb:31:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/rack-2.2.7/lib/rack/null_logger.rb:11:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/rack-2.2.7/lib/rack/head.rb:12:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/show_exceptions.rb:22:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:218:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:2004:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1564:in `block in call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1780:in `synchronize'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/sinatra-2.2.4/lib/sinatra/base.rb:1564:in `call'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/rack-2.2.7/lib/rack/handler/webrick.rb:95:in `service'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/webrick-1.8.1/lib/webrick/httpserver.rb:140:in `service'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/webrick-1.8.1/lib/webrick/httpserver.rb:96:in `run'
/opt/gitlab/embedded/lib/ruby/gems/3.0.0/gems/webrick-1.8.1/lib/webrick/server.rb:310:in `block in start_thread'</details>