Sentry: `sentry upgrade` errors, relation "sentry_option" does not exist at character 114, operator does not exist: json = json at character 19
(py27) [whopper:~/dev/sentry] $ sentry upgrade
ERROR: relation "sentry_option" does not exist at character 114
STATEMENT: SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'system.url-prefix'
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
> south
> sudo
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 0274_auto__add_index_commit_repository_id_date_added.
> 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
ERROR: operator does not exist: json = json at character 19
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT '{}'::json = '{}'::json;
> sentry:0162_auto__chg_field_authidentity_data
ERROR: operator does not exist: json = json at character 19
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT '{}'::json = '{}'::json;
> sentry:0163_auto__add_field_authidentity_last_synced
> sentry:0164_auto__add_releasefile__add_unique_releasefile_release_ident__add_field
ERROR: operator does not exist: json = json at character 19
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT '{}'::json = '{}'::json;
ERROR: operator does not exist: json = json at character 19
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT '{}'::json = '{}'::json;
ERROR: operator does not exist: json = json at character 19
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT '{}'::json = '{}'::json;
ERROR: operator does not exist: json = json at character 19
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT '{}'::json = '{}'::json;
> 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_
ERROR: operator does not exist: json = json at character 19
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT '{}'::json = '{}'::json;
ERROR: operator does not exist: json = json at character 19
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT '{}'::json = '{}'::json;
ERROR: operator does not exist: json = json at character 19
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT '{}'::json = '{}'::json;
> 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
ERROR: operator does not exist: json = json at character 19
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT '{}'::json = '{}'::json;
ERROR: operator does not exist: json = json at character 19
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT '{}'::json = '{}'::json;
> 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
ERROR: operator does not exist: json = json at character 19
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT '{}'::json = '{}'::json;
ERROR: operator does not exist: json = json at character 19
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT '{}'::json = '{}'::json;
> 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
Created internal Sentry project (slug=internal, id=1)
Would you like to create a user account now? [Y/n]: y
Email: <redacted>
Password:
Repeat for confirmation:
Should this user be a superuser? [y/N]: Y
User created: <redacted>
Added to organization: sentry
- Loading initial data for sentry.
Installed 0 object(s) from 0 fixture(s)
Running migrations for nodestore:
- Migrating forwards to 0001_initial.
> nodestore:0001_initial
- Loading initial data for nodestore.
Installed 0 object(s) from 0 fixture(s)
Running migrations for search:
- Migrating forwards to 0002_auto__del_searchtoken__del_unique_searchtoken_document_field_token__de.
> search:0001_initial
> search:0002_auto__del_searchtoken__del_unique_searchtoken_document_field_token__de
- Loading initial data for search.
Installed 0 object(s) from 0 fixture(s)
Running migrations for social_auth:
- Migrating forwards to 0002_auto__add_unique_nonce_timestamp_salt_server_url__add_unique_associati.
> social_auth:0001_initial
> social_auth:0002_auto__add_unique_nonce_timestamp_salt_server_url__add_unique_associati
- Loading initial data for social_auth.
Installed 0 object(s) from 0 fixture(s)
Creating missing DSNs
Correcting Group.num_comments counter
sentry upgrade 45.49s user 2.39s system 48% cpu 1:37.85 total
Exits with exit code 0, so seems to work, but those errors are a bit worrying.
torarnv
>All comments
This was due to running pg_ctl -D /usr/local/var/postgres start, as per the instructions on https://docs.sentry.io/internal/environment/, in the same shell as I was then doing Sentry stuff. So postgres was dumping errors to the foreground, errors which are not real errors from the point-of-view of Sentry, so they can be ignored.
torarnv
on 19 Oct 2016
👎6
Was this page helpful?
0 / 5 - 0 ratings
Related issues
mattrobenolt
路
3Comments
codekitchen
路
3Comments
Leroygirl
路
3Comments
campbellita
路
3Comments
dcramer
路
4Comments