Error creating project: UndefinedColumn('column "organization_id" of relation "sentry_savedsearch" does not exist

On-Premise
1

I am self-hosting Sentry. When I try to create a project it displays Internal Error and in the logs I see

ERR ProgrammingError: UndefinedColumn('column "organization_id" of relation "sentry_savedsearch" does not exist\nLINE 1: INSERT INTO "sentry_savedsearch" ("project_id", "organizatio...\n                                                        ^\n',)
ERR SQL: INSERT INTO "sentry_savedsearch" ("project_id", "organization_id", "type", "name", "query", "date_added", "is_default", "is_global", "owner_id") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s) RETURNING "sentry_savedsearch"."id"

Any idea how I can resolve this error?

  • List item
2

sentry upgrade should resolve it. If you provide more details about your setup, we can understand how you ended up with this scenario though.

3

Thanks for the reply,

If you provide more details about your setup, we can understand how you ended up with this scenario though.

I am trying to host sentry on a CloudFoundry instance following these instructions:

Once I ran sentry upgrade it resolved this issue. However, when I try to click ‘Create a sample event’ I am getting a new exception:

ERR ProgrammingError: UndefinedFunction('function sentry_increment_project_counter(integer, integer) does not exist\nLINE 2:                 select sentry_increment_project_counter(8, 1...\n                               ^\nHINT:  No function matches the given name and argument types. You might need to add explicit type casts.\n',)
ERR SQL: 
ERR                 select sentry_increment_project_counter(%s, %s)

Any idea how I can resolve this error?

4

I think you are using a Postgres version that is not supported by Sentry. By the way these instructions seem quite dated. I think they can work for Sentry 9.1 but for v10 you’d need more services. Check out the official repo for this: https://github.com/getsentry/onpremise