ActiveRecord::StatementInvalid: PG::AmbiguousColumn: ERROR: column reference "report_type" is ambiguous
https://sentry.gitlab.net/gitlab/gitlabcom/issues/1060403/
PG::AmbiguousColumn: ERROR: column reference "report_type" is ambiguous
LINE 1: SELECT report_type, vulnerability_id, project_fingerprint, r...
^
active_record/connection_adapters/postgresql_adapter.rb:611:in `async_exec_params'
@connection.exec_params(sql, type_casted_binds)
active_record/connection_adapters/postgresql_adapter.rb:611:in `block (2 levels) in exec_no_cache'
@connection.exec_params(sql, type_casted_binds)
active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
yield
active_support/concurrency/share_lock.rb:187:in `yield_shares'
yield
active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
@lock.yield_shares(compatible: [:load]) do
...
(108 additional frame(s) were not displayed)
ActiveRecord::StatementInvalid: PG::AmbiguousColumn: ERROR: column reference "report_type" is ambiguous
LINE 1: SELECT report_type, vulnerability_id, project_fingerprint, r...
^
: SELECT report_type, vulnerability_id, project_fingerprint, raw_metadata, vulnerabilities.id, vulnerabilities.state FROM "vulnerability_occurrences" INNER JOIN "vulnerabilities" ON "vulnerabilities"."id" = "vulnerability_occurrences"."vulnerability_id" WHERE "vulnerability_occurrences"."project_id" = 278964 AND "vulnerability_occurrences"."report_type" = 1 AND "vulnerability_occurrences"."project_fingerprint" IN ('\x209a1cccd0ffa6d01462ab3d85e976325abd780e', '\xf29311618b446bd33a65202d4f4d9e084c870993', '\xcac022d8c6fdc0272b0c3a2af5232f0c3c3c846e', '\xb83dd50341ad18e8b248e7935be3fe9f77fdf48c', '\xa7f6eef5f117bac6d69b3ddfd5de1d1391134c5c', '\xdb8e431eb997a8ac216a4296ea6a0eb2f26e2f27', '\xf8a3995f709005c0f17f2ceb2a82122bdef9f5a2', '\x5e7f24448826e28148cef87f93198e1ccc6fa635', '\x5386926697604bd6e8ca43a4368e5ab7affdcd0b', '\x288b6ced087969f6f52041ddf608aca152c473b1', '\xc2696182d113de5870439e4e3ef0ad01ef1ddb48', '\xa85f379295d9961607208c295907ff53a9721cb7', '\x09352fca18d2c66f36fade5d23abfc12f4e53d32', '\x1cc65991fd1dfe37186b0a9916796e9427fcc828', '\xb55ec1e010106a8cb56ed64be7f50cfb7f6de6d9', '\xe599872d4cbd9c31081ab981de20213c45d7e113', '\x22fdd503bd865c7d262282c786f580ba99f5d785', '\x2453d515d79487b3de5079059d087d7b302c7833', '\x1cf3585991ccc053e7d2a88fa071c40e15100ba9', '\x6c3f8e78dd0076116fc600385019408ebf6f4144', '\x0c1c10106764916b3bad366fdbaab4863a9655c1', '\x74704b563f545fb1b99603828adb9c05eabe5a5f', '\x73310ba9308eecd34ec4ae18ef89958cedace312', '\x2843fbac574d97b3a799864c43c733bfac43761c', '\xa17ffd4547a910acbd510460c793e9f68fa838d7', '\xd83d2a305c09def2de41637dc536a2a42a6d76a5', '\x3c2e56812b0dc5cb8bfa6cc0b7bfbf0ea111a7be', '\xdf5afc81f922f2c71b80c22a9286a10405a1671a', '\xbfbf17791010264cb351ac1342a9fe47d649a198')
PG::AmbiguousColumn: ERROR: column reference "report_type" is ambiguous
LINE 1: SELECT report_type, vulnerability_id, project_fingerprint, r...
^
: SELECT report_type, vulnerability_id, project_fingerprint, raw_metadata, vulnerabilities.id, vulnerabilities.state FROM "vulnerability_occurrences" INNER JOIN "vulnerabilities" ON "vulnerabilities"."id" = "vulnerability_occurrences"."vulnerability_id" WHERE "vulnerability_occurrences"."project_id" = 278964 AND "vulnerability_occurrences"."report_type" = 1 AND "vulnerability_occurrences"."project_fingerprint" IN ('\x209a1cccd0ffa6d01462ab3d85e976325abd780e', '\xf29311618b446bd33a65202d4f4d9e084c870993', '\xcac022d8c6fdc0272b0c3a2af5232f0c3c3c846e', '\xb83dd50341ad18e8b248e7935be3fe9f77fdf48c', '\xa7f6eef5f117bac6d69b3ddfd5de1d1391134c5c', '\xdb8e431eb997a8ac216a4296ea6a0eb2f26e2f27', '\xf8a3995f709005c0f17f2ceb2a82122bdef9f5a2', '\x5e7f24448826e28148cef87f93198e1ccc6fa635', '\x5386926697604bd6e8ca43a4368e5ab7affdcd0b', '\x288b6ced087969f6f52041ddf608aca152c473b1', '\xc2696182d113de5870439e4e3ef0ad01ef1ddb48', '\xa85f379295d9961607208c295907ff53a9721cb7', '\x09352fca18d2c66f36fade5d23abfc12f4e53d32', '\x1cc65991fd1dfe37186b0a9916796e9427fcc828', '\xb55ec1e010106a8cb56ed64be7f50cfb7f6de6d9', '\xe599872d4cbd9c31081ab981de20213c45d7e113', '\x22fdd503bd865c7d262282c786f580ba99f5d785', '\x2453d515d79487b3de5079059d087d7b302c7833', '\x1cf3585991ccc053e7d2a88fa071c40e15100ba9', '\x6c3f8e78dd0076116fc600385019408ebf6f4144', '\x0c1c10106764916b3bad366fdbaab4863a9655c1', '\x74704b563f545fb1b99603828adb9c05eabe5a5f', '\x73310ba9308eecd34ec4ae18ef89958cedace312', '\x2843fbac574d97b3a799864c43c733bfac43761c', '\xa17ffd4547a910acbd510460c793e9f68fa838d7', '\xd83d2a305c09def2de41637dc536a2a42a6d76a5', '\x3c2e56812b0dc5cb8bfa6cc0b7bfbf0ea111a7be', '\xdf5afc81f922f2c71b80c22a9286a10405a1671a', '\xbfbf17791010264cb351ac1342a9fe47d649a198')