Skip to content

ProgrammingError: more than one row returned by a subquery used as an expression #1821

@sentry

Description

@sentry

Sentry Issue: MITXONLINE-31G

CardinalityViolation: more than one row returned by a subquery used as an expression

  File "django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "newrelic/hooks/database_psycopg2.py", line 64, in execute
    return super(CursorWrapper, self).execute(sql, parameters, *args,
  File "newrelic/hooks/database_dbapi2.py", line 37, in execute
    return self.__wrapped__.execute(sql, parameters,

ProgrammingError: more than one row returned by a subquery used as an expression

(21 additional frame(s) were not displayed)
...
  File "django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "django/db/utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "newrelic/hooks/database_psycopg2.py", line 64, in execute
    return super(CursorWrapper, self).execute(sql, parameters, *args,
  File "newrelic/hooks/database_dbapi2.py", line 37, in execute
    return self.__wrapped__.execute(sql, parameters,

Going to https://rc.mitxonline.mit.edu/api/products/ results in a 500 - not sure this endpoint gets used by anything (it dumps everything, we don't display lists of products anywhere) but it is failing. The endpoint on production works OK. Pulling individual products doesn't work (with a 404) on either RC or production.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions