sentry upgrade crashes => FATAL ERROR - The following SQL query failed: CREATE EXTENSION IF NOT EXISTS citext

[maefinho]

Hello sentry crew,

first of all great product! Sadly I could not get the sentry server with the following configuration installed (Python installation):

OS: Ubuntu 16.04.1 LTS
Kernel: 4.4.0-042stab124.2
Postgresql: 9.5+173
Pip: 9.0.1
Virtualenv: 15.1.0
Redis-Server: 2:3.0.6-1
Python: 2.7.12
Sentry: 8.20.0

I tried to install it 3 times with little differences / approaches but always ended up with this:

sentry upgrade leads into the error:
"FATAL ERROR - The following SQL query failed: CREATE EXTENSION IF NOT EXISTS citext"

See beneath for the complete logfile:

(sentry) sentry@server:~$ SENTRY_CONF=/home/sentry/.sentry sentry upgrade
Syncing...
Creating tables ...
Creating table django_admin_log
Creating table auth_permission
Creating table auth_group_permissions
Creating table auth_group
Creating table django_content_type
Creating table django_session
Creating table django_site
Creating table south_migrationhistory
Installing custom SQL ...
Installing indexes ...
Installed 0 object(s) from 0 fixture(s)

Synced:

django.contrib.admin
django.contrib.auth
django.contrib.contenttypes
django.contrib.messages
django.contrib.sessions
django.contrib.sites
django.contrib.staticfiles
crispy_forms
debug_toolbar
raven.contrib.django.raven_compat
rest_framework
sentry.plugins.sentry_interface_types
sentry.plugins.sentry_mail
sentry.plugins.sentry_urls
sentry.plugins.sentry_useragents
sentry.plugins.sentry_webhooks
sudo
south

Not synced (use migrations):

• sentry
• sentry.nodestore
• sentry.search
• social_auth
  (use ./manage.py migrate to migrate these)
  Running migrations for sentry:
• Migrating forwards to 0351_backfillemail.

sentry:0001_initial
sentry:0002_auto__del_field_groupedmessage_url__chg_field_groupedmessage_view__chg
sentry:0003_auto__add_field_message_group__del_field_groupedmessage_server_name
sentry:0004_auto__add_filtervalue__add_unique_filtervalue_key_value
sentry:0005_auto
sentry:0006_auto
sentry:0007_auto__add_field_message_site
sentry:0008_auto__chg_field_message_view__add_field_groupedmessage_data__chg_field
sentry:0009_auto__add_field_message_message_id
sentry:0010_auto__add_messageindex__add_unique_messageindex_column_value_object_id
sentry:0011_auto__add_field_groupedmessage_score
sentry:0012_auto
sentry:0013_auto__add_messagecountbyminute__add_unique_messagecountbyminute_group_
sentry:0014_auto
sentry:0014_auto__add_project__add_projectmember__add_unique_projectmember_project
sentry:0015_auto__add_field_message_project__add_field_messagecountbyminute_projec
sentry:0016_auto__add_field_projectmember_is_superuser
sentry:0017_auto__add_field_projectmember_api_key
sentry:0018_auto__chg_field_project_owner
sentry:0019_auto__del_field_projectmember_api_key__add_field_projectmember_public_
sentry:0020_auto__add_projectdomain__add_unique_projectdomain_project_domain
sentry:0021_auto__del_message__del_groupedmessage__del_unique_groupedmessage_proje
sentry:0022_auto__del_field_group_class_name__del_field_group_traceback__del_field
sentry:0023_auto__add_field_event_time_spent
sentry:0024_auto__add_field_group_time_spent_total__add_field_group_time_spent_cou
sentry:0025_auto__add_field_messagecountbyminute_time_spent_total__add_field_messa
sentry:0026_auto__add_field_project_status
sentry:0027_auto__chg_field_event_server_name
sentry:0028_auto__add_projectoptions__add_unique_projectoptions_project_key_value
sentry:0029_auto__del_field_projectmember_is_superuser__del_field_projectmember_pe
sentry:0030_auto__add_view__chg_field_event_group
sentry:0031_auto__add_field_view_verbose_name__add_field_view_verbose_name_plural_
sentry:0032_auto__add_eventmeta
sentry:0033_auto__add_option__add_unique_option_key_value
sentry:0034_auto__add_groupbookmark__add_unique_groupbookmark_project_user_group
sentry:0034_auto__add_unique_option_key__del_unique_option_value_key__del_unique_g
sentry:0036_auto__chg_field_option_value__chg_field_projectoption_value
sentry:0037_auto__add_unique_option_key__del_unique_option_value_key__del_unique_g
sentry:0038_auto__add_searchtoken__add_unique_searchtoken_document_field_token__ad
sentry:0039_auto__add_field_searchdocument_status
sentry:0040_auto__del_unique_event_event_id__add_unique_event_project_event_id
sentry:0041_auto__add_field_messagefiltervalue_last_seen__add_field_messagefilterv
sentry:0042_auto__add_projectcountbyminute__add_unique_projectcountbyminute_projec
sentry:0043_auto__chg_field_option_value__chg_field_projectoption_value
sentry:0044_auto__add_field_projectmember_is_active
sentry:0045_auto__add_pendingprojectmember__add_unique_pendingprojectmember_projec
sentry:0046_auto__add_teammember__add_unique_teammember_team_user__add_team__add_p
sentry:0047_migrate_project_slugs
sentry:0048_migrate_project_keys
sentry:0049_create_default_project_keys
sentry:0050_remove_project_keys_from_members
sentry:0051_auto__del_pendingprojectmember__del_unique_pendingprojectmember_projec
sentry:0052_migrate_project_members
sentry:0053_auto__del_projectmember__del_unique_projectmember_project_user
sentry:0054_fix_project_keys
sentry:0055_auto__del_projectdomain__del_unique_projectdomain_project_domain
sentry:0056_auto__add_field_group_resolved_at
sentry:0057_auto__add_field_group_active_at
sentry:0058_auto__add_useroption__add_unique_useroption_user_project_key
sentry:0059_auto__add_filterkey__add_unique_filterkey_project_key
sentry:0060_fill_filter_key
sentry:0061_auto__add_field_group_group_id__add_field_group_is_public
sentry:0062_correct_del_index_sentry_groupedmessage_logger__view__checksum
sentry:0063_auto
sentry:0064_index_checksum
sentry:0065_create_default_project_key
sentry:0066_auto__del_view
sentry:0067_auto__add_field_group_platform__add_field_event_platform
sentry:0068_auto__add_field_projectkey_user_added__add_field_projectkey_date_added
sentry:0069_auto__add_lostpasswordhash
sentry:0070_projectoption_key_length
sentry:0071_auto__add_field_group_users_seen
sentry:0072_auto__add_affecteduserbygroup__add_unique_affecteduserbygroup_project_
sentry:0073_auto__add_field_project_platform
sentry:0074_correct_filtervalue_index
sentry:0075_add_groupbookmark_index
sentry:0076_add_groupmeta_index
sentry:0077_auto__add_trackeduser__add_unique_trackeduser_project_ident
sentry:0078_auto__add_field_affecteduserbygroup_tuser
sentry:0079_auto__del_unique_affecteduserbygroup_project_ident_group__add_unique_a
sentry:0080_auto__chg_field_affecteduserbygroup_ident
sentry:0081_fill_trackeduser
sentry:0082_auto__add_activity__add_field_group_num_comments__add_field_event_num_
sentry:0083_migrate_dupe_groups
sentry:0084_auto__del_unique_group_project_checksum_logger_culprit__add_unique_gro
sentry:0085_auto__del_unique_project_slug__add_unique_project_slug_team
sentry:0086_auto__add_field_team_date_added
sentry:0087_auto__del_messagefiltervalue__del_unique_messagefiltervalue_project_ke
sentry:0088_auto__del_messagecountbyminute__del_unique_messagecountbyminute_projec
sentry:0089_auto__add_accessgroup__add_unique_accessgroup_team_name
sentry:0090_auto__add_grouptagkey__add_unique_grouptagkey_project_group_key__add_f
sentry:0091_auto__add_alert
sentry:0092_auto__add_alertrelatedgroup__add_unique_alertrelatedgroup_group_alert
sentry:0093_auto__add_field_alert_status
sentry:0094_auto__add_eventmapping__add_unique_eventmapping_project_event_id
sentry:0095_rebase
sentry:0096_auto__add_field_tagvalue_data
sentry:0097_auto__del_affecteduserbygroup__del_unique_affecteduserbygroup_project_
sentry:0098_auto__add_user__chg_field_team_owner__chg_field_activity_user__chg_fie
sentry:0099_auto__del_field_teammember_is_active
sentry:0100_auto__add_field_tagkey_label
sentry:0101_ensure_teams
sentry:0102_ensure_slugs
sentry:0103_ensure_non_empty_slugs
sentry:0104_auto__add_groupseen__add_unique_groupseen_group_user
sentry:0105_auto__chg_field_projectcountbyminute_time_spent_total__chg_field_group
sentry:0106_auto__del_searchtoken__del_unique_searchtoken_document_field_token__de
sentry:0107_expand_user
sentry:0108_fix_user
sentry:0109_index_filtervalue_times_seen
sentry:0110_index_filtervalue_last_seen
sentry:0111_index_filtervalue_first_seen
sentry:0112_auto__chg_field_option_value__chg_field_useroption_value__chg_field_pr
sentry:0113_auto__add_field_team_status
sentry:0114_auto__add_field_projectkey_roles
sentry:0115_auto__del_projectcountbyminute__del_unique_projectcountbyminute_projec
sentry:0116_auto__del_field_event_server_name__del_field_event_culprit__del_field_
sentry:0117_auto__add_rule
sentry:0118_create_default_rules
sentry:0119_auto__add_field_projectkey_label
sentry:0120_auto__add_grouprulestatus
sentry:0121_auto__add_unique_grouprulestatus_rule_group
sentry:0122_add_event_group_id_datetime_index
sentry:0123_auto__add_groupassignee__add_index_event_group_datetime
sentry:0124_auto__add_grouphash__add_unique_grouphash_project_hash
sentry:0125_auto__add_field_user_is_managed
sentry:0126_auto__add_field_option_last_updated
sentry:0127_auto__add_release__add_unique_release_project_version
sentry:0128_auto__add_broadcast
sentry:0129_auto__chg_field_release_id__chg_field_pendingteammember_id__chg_field_
sentry:0130_auto__del_field_project_owner
sentry:0131_auto__add_organizationmember__add_unique_organizationmember_organizati
sentry:0132_add_default_orgs
sentry:0133_add_org_members
sentry:0134_auto__chg_field_team_organization
sentry:0135_auto__chg_field_project_team
sentry:0136_auto__add_field_organizationmember_email__chg_field_organizationmember
sentry:0137_auto__add_field_organizationmember_has_global_access
sentry:0138_migrate_team_members
sentry:0139_auto__add_auditlogentry
sentry:0140_auto__add_field_organization_slug
sentry:0141_fill_org_slugs
sentry:0142_auto__add_field_project_organization__add_unique_project_organization_
sentry:0143_fill_project_orgs
sentry:0144_auto__chg_field_project_organization
sentry:0145_auto__chg_field_organization_slug
sentry:0146_auto__add_field_auditlogentry_ip_address
sentry:0147_auto__del_unique_team_slug__add_unique_team_organization_slug
sentry:0148_auto__add_helppage
sentry:0149_auto__chg_field_groupseen_project__chg_field_groupseen_user__chg_field
sentry:0150_fix_broken_rules
sentry:0151_auto__add_file
sentry:0152_auto__add_field_file_checksum__chg_field_file_name__add_unique_file_na
sentry:0153_auto__add_field_grouprulestatus_last_active
sentry:0154_auto__add_field_tagkey_status
sentry:0155_auto__add_field_projectkey_status
sentry:0156_auto__add_apikey
sentry:0157_auto__add_authidentity__add_unique_authidentity_auth_provider_ident__a
sentry:0158_auto__add_unique_authidentity_auth_provider_user
sentry:0159_auto__add_field_authidentity_last_verified__add_field_organizationmemb
sentry:0160_auto__add_field_authprovider_default_global_access
sentry:0161_auto__chg_field_authprovider_config
sentry:0162_auto__chg_field_authidentity_data
sentry:0163_auto__add_field_authidentity_last_synced
sentry:0164_auto__add_releasefile__add_unique_releasefile_release_ident__add_field
sentry:0165_auto__del_unique_file_name_checksum
sentry:0166_auto__chg_field_user_id__add_field_apikey_allowed_origins
sentry:0167_auto__add_field_authprovider_flags
sentry:0168_unfill_projectkey_user
sentry:0169_auto__del_field_projectkey_user
sentry:0170_auto__add_organizationmemberteam__add_unique_organizationmemberteam_te
sentry:0171_auto__chg_field_team_owner
sentry:0172_auto__del_field_team_owner
sentry:0173_auto__del_teammember__del_unique_teammember_team_user
sentry:0174_auto__del_field_projectkey_user_added
sentry:0175_auto__del_pendingteammember__del_unique_pendingteammember_team_email
sentry:0176_auto__add_field_organizationmember_counter__add_unique_organizationmem
sentry:0177_fill_member_counters
sentry:0178_auto__del_unique_organizationmember_organization_counter
sentry:0179_auto__add_field_release_date_released
sentry:0180_auto__add_field_release_environment__add_field_release_ref__add_field_
sentry:0181_auto__del_field_release_environment__del_unique_release_project_versio
sentry:0182_auto__add_field_auditlogentry_actor_label__add_field_auditlogentry_act
sentry:0183_auto__del_index_grouphash_hash
sentry:0184_auto__del_field_group_checksum__del_unique_group_project_checksum__del
sentry:0185_auto__add_savedsearch__add_unique_savedsearch_project_name
sentry:0186_auto__add_field_group_first_release
sentry:0187_auto__add_index_group_project_first_release
sentry:0188_auto__add_userreport
sentry:0189_auto__add_index_userreport_project_event_id
sentry:0190_auto__add_field_release_new_groups
sentry:0191_auto__del_alert__del_alertrelatedgroup__del_unique_alertrelatedgroup_g
sentry:0192_add_model_groupemailthread
sentry:0193_auto__del_unique_groupemailthread_msgid__add_unique_groupemailthread_e
sentry:0194_auto__del_field_project_platform
sentry:0195_auto__chg_field_organization_owner
sentry:0196_auto__del_field_organization_owner
sentry:0197_auto__del_accessgroup__del_unique_accessgroup_team_name
sentry:0198_auto__add_field_release_primary_owner
sentry:0199_auto__add_field_project_first_event
sentry:0200_backfill_first_event
sentry:0201_auto__add_eventuser__add_unique_eventuser_project_ident__add_index_eve
sentry:0202_auto__add_field_eventuser_hash__add_unique_eventuser_project_hash
sentry:0203_auto__chg_field_eventuser_username__chg_field_eventuser_ident
sentry:0204_backfill_team_membership
sentry:0205_auto__add_field_organizationmember_role
sentry:0206_backfill_member_role
sentry:0207_auto__add_field_organization_default_role
sentry:0208_backfill_default_role
sentry:0209_auto__add_broadcastseen__add_unique_broadcastseen_broadcast_user
sentry:0210_auto__del_field_broadcast_badge
sentry:0211_auto__add_field_broadcast_title
sentry:0212_auto__add_fileblob__add_field_file_blob
sentry:0212_auto__add_organizationoption__add_unique_organizationoption_organizati
sentry:0213_migrate_file_blobs
Saved 0.00GB (on 0.00GB) with removal of 0 duplicate files
sentry:0214_auto__add_field_broadcast_upstream_id
sentry:0215_auto__add_field_broadcast_date_expires
sentry:0216_auto__add_groupsnooze
sentry:0217_auto__add_groupresolution
sentry:0218_auto__add_field_groupresolution_status
sentry:0219_auto__add_field_groupbookmark_date_added
sentry:0220_auto__del_field_fileblob_storage_options__del_field_fileblob_storage__
sentry:0221_auto__chg_field_user_first_name
sentry:0222_auto__del_field_user_last_name__del_field_user_first_name__add_field_u
sentry:0223_delete_old_sentry_docs_options
sentry:0224_auto__add_index_userreport_project_date_added
sentry:0225_auto__add_fileblobindex__add_unique_fileblobindex_file_blob_offset
sentry:0226_backfill_file_size
sentry:0227_auto__del_field_activity_event
sentry:0228_auto__del_field_event_num_comments
sentry:0229_drop_event_constraints
sentry:0230_auto__del_field_eventmapping_group__del_field_eventmapping_project__ad
sentry:0231_auto__add_field_savedsearch_is_default
sentry:0232_default_savedsearch
sentry:0233_add_new_savedsearch
sentry:0234_auto__add_savedsearchuserdefault__add_unique_savedsearchuserdefault_pr
sentry:0235_auto__add_projectbookmark__add_unique_projectbookmark_project_id_user_
sentry:0236_auto__add_organizationonboardingtask__add_unique_organizationonboardin
sentry:0237_auto__add_eventtag__add_unique_eventtag_event_id_key_id_value_id
sentry:0238_fill_org_onboarding_tasks
sentry:0239_auto__add_projectdsymfile__add_unique_projectdsymfile_project_uuid__ad
sentry:0240_fill_onboarding_option
sentry:0241_auto__add_counter__add_unique_counter_project_ident__add_field_group_s
sentry:0242_auto__add_field_project_forced_color
sentry:0243_remove_inactive_members
sentry:0244_auto__add_groupredirect
sentry:0245_auto__del_field_project_callsign__del_unique_project_organization_call
sentry:0246_auto__add_dsymsymbol__add_unique_dsymsymbol_object_address__add_dsymsd
sentry:0247_migrate_file_blobs
sentry:0248_auto__add_projectplatform__add_unique_projectplatform_project_id_platf
sentry:0249_auto__add_index_eventtag_project_id_key_id_value_id
sentry:0250_auto__add_unique_userreport_project_event_id
sentry:0251_auto__add_useravatar
sentry:0252_default_users_to_gravatar
sentry:0253_auto__add_field_eventtag_group_id
sentry:0254_auto__add_index_eventtag_group_id_key_id_value_id
sentry:0255_auto__add_apitoken
sentry:0256_auto__add_authenticator
sentry:0257_repair_activity
sentry:0258_auto__add_field_user_is_password_expired__add_field_user_last_password
sentry:0259_auto__add_useremail__add_unique_useremail_user_email
sentry:0260_populate_email_addresses
sentry:0261_auto__add_groupsubscription__add_unique_groupsubscription_group_user
sentry:0262_fix_tag_indexes
sentry:0263_remove_default_regression_rule
sentry:0264_drop_grouptagvalue_project_index
sentry:0265_auto__add_field_rule_status
sentry:0266_auto__add_grouprelease__add_unique_grouprelease_group_id_release_id_en
sentry:0267_auto__add_environment__add_unique_environment_project_id_name__add_rel
sentry:0268_fill_environment
sentry:0269_auto__del_helppage
sentry:0270_auto__add_field_organizationmember_token
sentry:0271_auto__del_field_organizationmember_counter
sentry:0272_auto__add_unique_authenticator_user_type
sentry:0273_auto__add_repository__add_unique_repository_organization_id_name__add_
sentry:0274_auto__add_index_commit_repository_id_date_added
sentry:0275_auto__del_index_grouptagvalue_project_key_value__add_index_grouptagval
sentry:0276_auto__add_field_user_session_nonce
sentry:0277_auto__add_commitfilechange__add_unique_commitfilechange_commit_filenam
sentry:0278_auto__add_releaseproject__add_unique_releaseproject_project_release__a
sentry:0279_populate_release_orgs_and_projects
sentry:0280_auto__add_field_releasecommit_organization_id
sentry:0281_populate_release_commit_organization_id
sentry:0282_auto__add_field_releasefile_organization__add_field_releaseenvironment
sentry:0283_populate_release_environment_and_release_file_organization
sentry:0284_auto__del_field_release_project__add_field_release_project_id__chg_fie
sentry:0285_auto__chg_field_release_project_id__chg_field_releasefile_project_id
sentry:0286_drop_project_fk_release_release_file
sentry:0287_auto__add_field_releaseproject_new_groups
sentry:0288_set_release_project_new_groups_to_zero
sentry:0289_auto__add_organizationavatar
sentry:0290_populate_release_project_new_groups
sentry:0291_merge_legacy_releases
sentry:0292_auto__add_unique_release_organization_version
sentry:0293_auto__del_unique_release_project_id_version
sentry:0294_auto__add_groupcommitresolution__add_unique_groupcommitresolution_grou
sentry:0295_auto__add_environmentproject__add_unique_environmentproject_project_en
sentry:0296_populate_environment_organization_and_projects
sentry:0297_auto__add_field_project_flags
sentry:0298_backfill_project_has_releases
sentry:0299_auto__chg_field_environment_organization_id
sentry:0300_auto__add_processingissue__add_unique_processingissue_project_checksum
sentry:0301_auto__chg_field_environment_project_id__chg_field_releaseenvironment_p
sentry:0302_merge_environments
sentry:0303_fix_release_new_group_counts
sentry:0304_auto__add_deploy
sentry:0305_auto__chg_field_authidentity_data__chg_field_useroption_value__chg_fie
sentry:0306_auto__add_apigrant__add_apiauthorization__add_unique_apiauthorization_
sentry:0307_auto__add_field_apigrant_scope_list__add_field_apitoken_scope_list__ad
sentry:0308_auto__add_versiondsymfile__add_unique_versiondsymfile_dsym_file_versio
sentry:0308_backfill_scopes_list
sentry:0309_fix_application_state
sentry:0310_auto__add_field_savedsearch_owner
sentry:0311_auto__add_releaseheadcommit__add_unique_releaseheadcommit_repository_i
sentry:0312_create_missing_emails
sentry:0313_auto__add_field_commitauthor_external_id__add_unique_commitauthor_orga
sentry:0314_auto__add_distribution__add_unique_distribution_release_name__add_fiel
sentry:0315_auto__add_field_useroption_organization__add_unique_useroption_user_or
sentry:0316_auto__del_field_grouptagvalue_project__del_field_grouptagvalue_group__
sentry:0317_drop_grouptagvalue_constraints
sentry:0318_auto__add_field_deploy_notified
sentry:0319_auto__add_index_deploy_notified
sentry:0320_auto__add_index_eventtag_date_added
sentry:0321_auto__add_field_projectkey_rate_limit_count__add_field_projectkey_rate
sentry:0321_auto__add_unique_environment_organization_id_name
sentry:0322_merge_0321_migrations
sentry:0323_auto__add_unique_releaseenvironment_organization_id_release_id_environ
sentry:0324_auto__add_field_eventuser_name__add_field_userreport_event_user_id
sentry:0325_auto__add_scheduleddeletion__add_unique_scheduleddeletion_app_label_mo
sentry:0326_auto__add_field_groupsnooze_count__add_field_groupsnooze_window__add_f
sentry:0327_auto__add_field_release_commit_count__add_field_release_last_commit_id
sentry:0328_backfill_release_stats
sentry:0329_auto__del_dsymsymbol__del_unique_dsymsymbol_object_address__del_global
sentry:0330_auto__add_field_grouphash_state
sentry:0331_auto__del_index_releasecommit_project_id__del_index_releaseenvironment
sentry:0332_auto__add_featureadoption__add_unique_featureadoption_organization_fea
sentry:0333_auto__add_field_groupresolution_type__add_field_groupresolution_actor_
sentry:0334_auto__add_field_project_platform
sentry:0334_auto__add_scheduledjob
sentry:0335_auto__add_field_groupsnooze_actor_id
sentry:0336_auto__add_field_user_last_active
sentry:0337_fix_out_of_order_migrations
sentry:0338_fix_null_user_last_active
sentry:0339_backfill_first_project_feature
sentry:0340_auto__add_grouptombstone__add_field_grouphash_group_tombstone_id
sentry:0341_auto__add_organizationintegration__add_unique_organizationintegration_
sentry:0342_projectplatform
sentry:0343_auto__add_index_groupcommitresolution_commit_id
sentry:0344_add_index_ProjectPlatform_last_seen
sentry:0345_add_citext
FATAL ERROR - The following SQL query failed: CREATE EXTENSION IF NOT EXISTS citext
The error was: ProgrammingError('permission denied to create extension "citext"nHINT: Must be superuser to create this extension.n',)
SQL: CREATE EXTENSION IF NOT EXISTS citext
Error in migration: sentry:0345_add_citext
Created internal Sentry project (slug=internal, id=1)

Would you like to create a user account now? [Y/n]: y
Email: [email protected]
Password:
Repeat for confirmation:
Should this user be a superuser? [y/N]: y
Traceback (most recent call last):
File "/home/sentry/bin/sentry", line 11, in
sys.exit(main())
File "/home/sentry/local/lib/python2.7/site-packages/sentry/runner/__init__.py", line 160, in main
cli(prog_name=get_prog(), obj={}, max_content_width=100)
File "/home/sentry/local/lib/python2.7/site-packages/click/core.py", line 722, in __call__
return self.main(args, kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/click/core.py", line 697, in main
rv = self.invoke(ctx)
File "/home/sentry/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/sentry/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke
return ctx.invoke(self.callback, *ctx.params)
File "/home/sentry/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke
return callback(args, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func
return f(get_current_context(), args, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/sentry/runner/decorators.py", line 36, in inner
return ctx.invoke(f, args, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke
return callback(args, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func
return f(get_current_context(), args, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/sentry/runner/commands/upgrade.py", line 67, in upgrade
_upgrade(not noinput, traceback, verbosity, not no_repair)
File "/home/sentry/local/lib/python2.7/site-packages/sentry/runner/commands/upgrade.py", line 29, in _upgrade
verbosity=verbosity,
File "/home/sentry/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 159, in call_command
return klass.execute(args, *defaults)
File "/home/sentry/local/lib/python2.7/site-packages/django/core/management/base.py", line 285, in execute
output = self.handle(args, *options)
File "/home/sentry/local/lib/python2.7/site-packages/south/management/commands/migrate.py", line 115, in handle
ignore_ghosts=ignore_ghosts,
File "/home/sentry/local/lib/python2.7/site-packages/south/migration/__init__.py", line 234, in migrate_app
success = migrator.migrate_many(target, workplan, database)
File "/home/sentry/local/lib/python2.7/site-packages/south/migration/migrators.py", line 255, in migrate_many
result = migrator.__class__.migrate_many(migrator, target, migrations, database)
File "/home/sentry/local/lib/python2.7/site-packages/south/migration/migrators.py", line 336, in migrate_many
interactive=self.interactive)
File "/home/sentry/local/lib/python2.7/site-packages/south/db/generic.py", line 1067, in send_pending_create_signals
interactive=interactive)
File "/home/sentry/local/lib/python2.7/site-packages/south/db/generic.py", line 1113, in really_send_create_signal
db=self.db_alias,
File "/home/sentry/local/lib/python2.7/site-packages/django/dispatch/dispatcher.py", line 185, in send
response = receiver(signal=self, sender=sender, *named)
File "/home/sentry/local/lib/python2.7/site-packages/sentry/receivers/users.py", line 28, in create_first_user
call_command('sentry.runner.commands.createuser.createuser')
File "/home/sentry/local/lib/python2.7/site-packages/sentry/runner/__init__.py", line 154, in call_command
command.invoke(ctx)
File "/home/sentry/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke
return ctx.invoke(self.callback, *ctx.params)
File "/home/sentry/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke
return callback(args, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func
return f(get_current_context(), args, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/sentry/runner/decorators.py", line 36, in inner
return ctx.invoke(f, args, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke
return callback(args, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/sentry/runner/commands/createuser.py", line 87, in createuser
user.save()
File "/home/sentry/local/lib/python2.7/site-packages/sentry/models/user.py", line 110, in save
return super(User, self).save(args, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/base.py", line 545, in save
force_update=force_update, update_fields=update_fields)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/base.py", line 582, in save_base
update_fields=update_fields, raw=raw, using=using)
File "/home/sentry/local/lib/python2.7/site-packages/django/dispatch/dispatcher.py", line 185, in send
response = receiver(signal=self, sender=sender, *named)
File "/home/sentry/local/lib/python2.7/site-packages/sentry/receivers/useremail.py", line 14, in create_user_email
UserEmail.objects.create(email=instance.email, user=instance)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/manager.py", line 157, in create
return self.get_queryset().create(kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/query.py", line 322, in create
obj.save(force_insert=True, using=self.db)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/base.py", line 545, in save
force_update=force_update, update_fields=update_fields)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/base.py", line 582, in save_base
update_fields=update_fields, raw=raw, using=using)
File "/home/sentry/local/lib/python2.7/site-packages/django/dispatch/dispatcher.py", line 185, in send
response = receiver(signal=self, sender=sender, named)
File "/home/sentry/local/lib/python2.7/site-packages/sentry/receivers/email.py", line 13, in create_email
Email.objects.create(email=instance.email)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/manager.py", line 157, in create
return self.get_queryset().create(kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/query.py", line 322, in create
obj.save(force_insert=True, using=self.db)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/base.py", line 545, in save
force_update=force_update, update_fields=update_fields)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/base.py", line 573, in save_base
updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/base.py", line 654, in _save_table
result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/base.py", line 687, in _do_insert
using=using, raw=raw)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/manager.py", line 232, in _insert
return insert_query(self.model, objs, fields, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/query.py", line 1514, in insert_query
return query.get_compiler(using=using).execute_sql(return_id)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 903, in execute_sql
cursor.execute(sql, params)
File "/home/sentry/local/lib/python2.7/site-packages/raven/contrib/django/client.py", line 112, in execute
return real_execute(self, sql, params)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/backends/util.py", line 53, in execute
return self.cursor.execute(sql, params)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/utils.py", line 99, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/home/sentry/local/lib/python2.7/site-packages/django/db/backends/util.py", line 53, in execute
return self.cursor.execute(sql, params)
File "/home/sentry/local/lib/python2.7/site-packages/sentry/db/postgres/decorators.py", line 80, in inner
raise_the_exception(self.db, e)
File "/home/sentry/local/lib/python2.7/site-packages/sentry/db/postgres/decorators.py", line 78, in inner
return func(self, args, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/sentry/db/postgres/decorators.py", line 22, in inner
return func(self, args, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/sentry/db/postgres/decorators.py", line 101, in inner
six.reraise(exc_info[0], exc_info0, exc_info[2])
File "/home/sentry/local/lib/python2.7/site-packages/sentry/db/postgres/decorators.py", line 94, in inner
return func(self, sql, args, *kwargs)
File "/home/sentry/local/lib/python2.7/site-packages/sentry/db/postgres/base.py", line 39, in execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: ProgrammingError('relation "sentry_email" does not existnLINE 1: INSERT INTO "sentry_email" ("email", "date_added") VALUES ('...n ^n',)
SQL: INSERT INTO "sentry_email" ("email", "date_added") VALUES (%s, %s) RETURNING "sentry_email"."id"
(sentry) sentry@server:~$

Many thanks and best regards,
Michael

[mattrobenolt]

There’s another postgresql package that you need on Ubuntu. It’d be named something like postgresql-contrib, depending on the PPA you use.

[maefinho]

Hi mattrobenolt,

I found the issue where this error is also described. I don't know why I did not find it earlier when I already searched the issues for this type of error.

Anyways thank you for your help.

For others looking up this error and get to this page => work around with granting temporarily superuser access for sentry users worked in my case:

https://github.com/getsentry/sentry/issues/6098

Best,
Michael

[Kentzo]

@mattrobenolt Note that error is not that extension cannot be found, the error is "permission denied".

The documentation for installation does not mention that DATABASE's user must be a superuser.