Skip to content

ERROR: invalid input syntax for type integer: "generic" in /api/v4/projects/:id/vulnerability_findings

https://sentry.gitlab.net/gitlab/gitlabcom/issues/2829727/?referrer=gitlab_plugin

PG::InvalidTextRepresentation: ERROR:  invalid input syntax for type integer: "generic"
LINE 1: ...ty_scans"."scan_type" IN (1, 2, 3, 4, 5, 6, 7, 8, 'generic')...
                                                             ^

  lib/gitlab/database/load_balancing/connection_proxy.rb:103:in `block in read_using_load_balancer'
    connection.send(...)
  lib/gitlab/database/load_balancing/load_balancer.rb:53:in `read'
    return yield connection
  lib/gitlab/database/load_balancing/connection_proxy.rb:102:in `read_using_load_balancer'
    @load_balancer.read do |connection|
  lib/gitlab/database/load_balancing/connection_proxy.rb:53:in `block (2 levels) in <class:ConnectionProxy>'
    read_using_load_balancer(name, *args, **kwargs, &block)
  lib/api/api_guard.rb:213:in `call'
    response = super(env)
...
(196 additional frame(s) were not displayed)

ActiveRecord::StatementInvalid: PG::InvalidTextRepresentation: ERROR:  invalid input syntax for type integer: "generic"
LINE 1: ...ty_scans"."scan_type" IN (1, 2, 3, 4, 5, 6, 7, 8, 'generic')...
                                                             ^