-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Low
-
None
-
Affects Version/s: None
-
Component/s: Jira - Site Import - From Server
-
None
-
Minor
Summary
Site Import on Jira is failing after the Cloud Database Maintenance
https://jira-software.status.atlassian.com/incidents/w6n74b64dwlm
Environment
Server -> Cloud
Cloud -> Cloud
Steps to Reproduce
- Create a backup from a Server or Cloud instance.
- Perform the Site Import for Jira
Expected Result
Import is completed successfully
Actual Result
Import fails immediately with the below error:
Caused by: org.postgresql.util.PSQLException: ERROR: operator class "numeric_ops" does not accept data type bigint Where: SQL statement " ALTER TABLE addoncloudexport ALTER COLUMN id TYPE BIGINT; ALTER TABLE app_user ALTER COLUMN id TYPE BIGINT; ALTER TABLE avatar ALTER COLUMN id TYPE BIGINT, ALTER COLUMN systemavatar TYPE INT; ALTER TABLE board ALTER COLUMN id TYPE BIGINT; ALTER TABLE boardproject ALTER COLUMN board_id TYPE BIGINT, ALTER COLUMN project_id TYPE BIGINT; ALTER TABLE clusteredjob ALTER COLUMN interval_millis TYPE BIGINT, ALTER COLUMN first_run TYPE BIGINT, ALTER COLUMN next_run TYPE BIGINT, ALTER COLUMN version TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE clusterlockstatus ALTER COLUMN update_time TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE clustermessage ALTER COLUMN id TYPE BIGINT; ALTER TABLE clusternode ALTER COLUMN "timestamp" TYPE BIGINT, ALTER COLUMN cache_listener_port TYPE BIGINT; ALTER TABLE clusternodeheartbeat ALTER COLUMN heartbeat_time TYPE BIGINT, ALTER COLUMN database_time TYPE BIGINT; ALTER TABLE columnlayout ALTER COLUMN searchrequest TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE component ALTER COLUMN project TYPE BIGINT, ALTER COLUMN assigneetype TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE configurationcontext ALTER COLUMN projectcategory TYPE BIGINT, ALTER COLUMN project TYPE BIGINT, ALTER COLUMN fieldconfigscheme TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE customfield ALTER COLUMN fieldtype TYPE BIGINT, ALTER COLUMN project TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE customfieldoption ALTER COLUMN customfield TYPE BIGINT, ALTER COLUMN customfieldconfig TYPE BIGINT, ALTER COLUMN parentoptionid TYPE BIGINT, ALTER COLUMN sequence TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE cwd_application ALTER COLUMN id TYPE BIGINT, ALTER COLUMN active TYPE INT; ALTER TABLE cwd_application_address ALTER COLUMN application_id TYPE BIGINT, ALTER COLUMN remote_address_mask TYPE INT; ALTER TABLE cwd_directory ALTER COLUMN active TYPE INT, ALTER COLUMN directory_position TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE cwd_directory_attribute ALTER COLUMN directory_id TYPE BIGINT; ALTER TABLE cwd_directory_operation ALTER COLUMN directory_id TYPE BIGINT; ALTER TABLE cwd_group ALTER COLUMN directory_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT, ALTER COLUMN active TYPE INT, ALTER COLUMN local TYPE INT; ALTER TABLE cwd_group_attributes ALTER COLUMN group_id TYPE BIGINT, ALTER COLUMN directory_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE deadletter ALTER COLUMN last_seen TYPE BIGINT, ALTER COLUMN mail_server_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE draftworkflowscheme ALTER COLUMN workflow_scheme_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE draftworkflowschemeentity ALTER COLUMN scheme TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE entity_property_index_document ALTER COLUMN id TYPE BIGINT; ALTER TABLE entity_translation ALTER COLUMN entity_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE external_entities ALTER COLUMN id TYPE BIGINT; ALTER TABLE externalgadget ALTER COLUMN id TYPE BIGINT; ALTER TABLE favouriteassociations ALTER COLUMN entityid TYPE BIGINT, ALTER COLUMN sequence TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE feature ALTER COLUMN id TYPE BIGINT; ALTER TABLE fieldconfigscheme ALTER COLUMN customfield TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE fieldconfigschemeissuetype ALTER COLUMN fieldconfigscheme TYPE BIGINT, ALTER COLUMN fieldconfiguration TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE fieldconfiguration ALTER COLUMN customfield TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE fieldlayout ALTER COLUMN layoutscheme TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE fieldlayoutscheme ALTER COLUMN id TYPE BIGINT; ALTER TABLE fieldlayoutschemeassociation ALTER COLUMN project TYPE BIGINT, ALTER COLUMN fieldlayoutscheme TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE fieldlayoutschemeentity ALTER COLUMN scheme TYPE BIGINT, ALTER COLUMN fieldlayout TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE fieldscreen ALTER COLUMN id TYPE BIGINT; ALTER TABLE fieldscreenscheme ALTER COLUMN id TYPE BIGINT; ALTER TABLE fieldscreenschemeitem ALTER COLUMN operation TYPE BIGINT, ALTER COLUMN fieldscreen TYPE BIGINT, ALTER COLUMN fieldscreenscheme TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE fieldscreentab ALTER COLUMN sequence TYPE BIGINT, ALTER COLUMN fieldscreen TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE filtersubscription ALTER COLUMN filter_i_d TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE genericconfiguration ALTER COLUMN id TYPE BIGINT; ALTER TABLE globalpermissionentry ALTER COLUMN id TYPE BIGINT; ALTER TABLE groupbase ALTER COLUMN id TYPE BIGINT; ALTER TABLE issue_field_option ALTER COLUMN option_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE issue_field_option_attr ALTER COLUMN scope_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE issue_field_option_scope ALTER COLUMN option_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE issuelinktype ALTER COLUMN id TYPE BIGINT; ALTER TABLE issuesecurityscheme ALTER COLUMN defaultlevel TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE issuestatus ALTER COLUMN sequence TYPE BIGINT, ALTER COLUMN statuscategory TYPE BIGINT; ALTER TABLE issuetype ALTER COLUMN sequence TYPE BIGINT, ALTER COLUMN avatar TYPE BIGINT; ALTER TABLE issuetypescreenscheme ALTER COLUMN id TYPE BIGINT; ALTER TABLE issuetypescreenschemeentity ALTER COLUMN scheme TYPE BIGINT, ALTER COLUMN fieldscreenscheme TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE jiradraftworkflows ALTER COLUMN id TYPE BIGINT; ALTER TABLE jiraeventtype ALTER COLUMN template_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE jiraissuetokens ALTER COLUMN issueid TYPE BIGINT; ALTER TABLE jiraperms ALTER COLUMN permtype TYPE BIGINT, ALTER COLUMN projectid TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE jiraworkflows ALTER COLUMN id TYPE BIGINT; ALTER TABLE jiraworkflowstatuses ALTER COLUMN id TYPE BIGINT; ALTER TABLE jquartz_fired_triggers ALTER COLUMN fired_time TYPE BIGINT, ALTER COLUMN sched_time TYPE BIGINT, ALTER COLUMN priority TYPE INT; ALTER TABLE jquartz_scheduler_state ALTER COLUMN last_checkin_time TYPE BIGINT, ALTER COLUMN checkin_interval TYPE BIGINT; ALTER TABLE jquartz_simple_triggers ALTER COLUMN repeat_count TYPE BIGINT, ALTER COLUMN repeat_interval TYPE BIGINT, ALTER COLUMN times_triggered TYPE BIGINT; ALTER TABLE jquartz_simprop_triggers ALTER COLUMN int_prop_1 TYPE INT, ALTER COLUMN int_prop_2 TYPE INT, ALTER COLUMN long_prop_1 TYPE BIGINT, ALTER COLUMN long_prop_2 TYPE BIGINT; ALTER TABLE jquartz_triggers ALTER COLUMN next_fire_time TYPE BIGINT, ALTER COLUMN prev_fire_time TYPE BIGINT, ALTER COLUMN start_time TYPE BIGINT, ALTER COLUMN end_time TYPE BIGINT, ALTER COLUMN priority TYPE INT; ALTER TABLE legacy_store_attachment_status ALTER COLUMN attachment TYPE BIGINT, ALTER COLUMN not_present_in_store TYPE INT; ALTER TABLE legacy_store_avatar_status ALTER COLUMN avatar TYPE BIGINT, ALTER COLUMN not_present_in_store TYPE INT; ALTER TABLE licenserolesdefault ALTER COLUMN id TYPE BIGINT; ALTER TABLE licenserolesgroup ALTER COLUMN id TYPE BIGINT; ALTER TABLE listenerconfig ALTER COLUMN id TYPE BIGINT; ALTER TABLE mailserver ALTER COLUMN timeout TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE managedconfigurationitem ALTER COLUMN id TYPE BIGINT; ALTER TABLE media_api_credentials ALTER COLUMN id TYPE BIGINT; ALTER TABLE media_store_avatars ALTER COLUMN avatar TYPE BIGINT; ALTER TABLE membershipbase ALTER COLUMN id TYPE BIGINT; ALTER TABLE nodeindexcounter ALTER COLUMN index_operation_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE notification ALTER COLUMN scheme TYPE BIGINT, ALTER COLUMN event_type_id TYPE BIGINT, ALTER COLUMN template_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE notificationinstance ALTER COLUMN source TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE notificationscheme ALTER COLUMN id TYPE BIGINT; ALTER TABLE oauthconsumer ALTER COLUMN id TYPE BIGINT; ALTER TABLE oauthconsumertoken ALTER COLUMN id TYPE BIGINT; ALTER TABLE oauthspconsumer ALTER COLUMN id TYPE BIGINT; ALTER TABLE oauthsptoken ALTER COLUMN ttl TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE optionconfiguration ALTER COLUMN fieldconfig TYPE BIGINT, ALTER COLUMN sequence TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE permissionscheme ALTER COLUMN id TYPE BIGINT; ALTER TABLE pluginversion ALTER COLUMN id TYPE BIGINT; ALTER TABLE portalpage ALTER COLUMN sequence TYPE BIGINT, ALTER COLUMN fav_count TYPE BIGINT, ALTER COLUMN ppversion TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE portletconfiguration ALTER COLUMN portalpage TYPE BIGINT, ALTER COLUMN id TYPE BIGINT, ALTER COLUMN column_number TYPE INT, ALTER COLUMN positionseq TYPE INT; ALTER TABLE priority ALTER COLUMN sequence TYPE BIGINT; ALTER TABLE productlicense ALTER COLUMN id TYPE BIGINT; ALTER TABLE project ALTER COLUMN pcounter TYPE BIGINT, ALTER COLUMN assigneetype TYPE BIGINT, ALTER COLUMN avatar TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE project_key ALTER COLUMN project_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE projectcategory ALTER COLUMN id TYPE BIGINT; ALTER TABLE projectchangedtime ALTER COLUMN project_id TYPE BIGINT; ALTER TABLE projectrole ALTER COLUMN id TYPE BIGINT; ALTER TABLE projectversion ALTER COLUMN project TYPE BIGINT, ALTER COLUMN sequence TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE propertydata ALTER COLUMN id TYPE BIGINT; ALTER TABLE propertydate ALTER COLUMN id TYPE BIGINT; ALTER TABLE propertydecimal ALTER COLUMN id TYPE BIGINT; ALTER TABLE qrtz_calendars ALTER COLUMN id TYPE BIGINT; ALTER TABLE qrtz_cron_triggers ALTER COLUMN trigger_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE qrtz_fired_triggers ALTER COLUMN id TYPE BIGINT, ALTER COLUMN trigger_id TYPE BIGINT; ALTER TABLE qrtz_job_details ALTER COLUMN id TYPE BIGINT; ALTER TABLE qrtz_job_listeners ALTER COLUMN job TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE qrtz_simple_triggers ALTER COLUMN trigger_id TYPE BIGINT, ALTER COLUMN repeat_interval TYPE BIGINT, ALTER COLUMN id TYPE BIGINT, ALTER COLUMN repeat_count TYPE INT, ALTER COLUMN times_triggered TYPE INT; ALTER TABLE qrtz_trigger_listeners ALTER COLUMN trigger_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE qrtz_triggers ALTER COLUMN job TYPE BIGINT, ALTER COLUMN id TYPE BIGINT, ALTER COLUMN misfire_instr TYPE INT; ALTER TABLE reindex_component ALTER COLUMN request_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE reindex_request ALTER COLUMN id TYPE BIGINT; ALTER TABLE remembermetoken ALTER COLUMN id TYPE BIGINT; ALTER TABLE replicatedindexoperation ALTER COLUMN id TYPE BIGINT; ALTER TABLE resolution ALTER COLUMN sequence TYPE BIGINT; ALTER TABLE savedfiltermigrationbackup ALTER COLUMN saved_filter_id TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE schemeissuesecurities ALTER COLUMN scheme TYPE BIGINT, ALTER COLUMN security TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE schemeissuesecuritylevels ALTER COLUMN scheme TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE schemepermissions ALTER COLUMN scheme TYPE BIGINT, ALTER COLUMN permission TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE searchrequest ALTER COLUMN projectid TYPE BIGINT, ALTER COLUMN fav_count TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE sequence_value_item ALTER COLUMN seq_id TYPE BIGINT; ALTER TABLE serviceconfig ALTER COLUMN delaytime TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE sharepermissions ALTER COLUMN entityid TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE tempattachmentsmonitor ALTER COLUMN file_size TYPE BIGINT, ALTER COLUMN created_time TYPE BIGINT; ALTER TABLE tenant_properties ALTER COLUMN id TYPE BIGINT; ALTER TABLE trackback_ping ALTER COLUMN issue TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE trustedapp ALTER COLUMN timeout TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE upgradehistory ALTER COLUMN id TYPE BIGINT; ALTER TABLE upgradetaskhistory ALTER COLUMN id TYPE BIGINT, ALTER COLUMN build_number TYPE INT; ALTER TABLE upgradetaskhistoryauditlog ALTER COLUMN id TYPE BIGINT, ALTER COLUMN build_number TYPE INT; ALTER TABLE upgradeversionhistory ALTER COLUMN id TYPE BIGINT; ALTER TABLE userbase ALTER COLUMN id TYPE BIGINT; ALTER TABLE userpickerfilter ALTER COLUMN customfield TYPE BIGINT, ALTER COLUMN customfieldconfig TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE userpickerfiltergroup ALTER COLUMN userpickerfilter TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE userpickerfilterrole ALTER COLUMN userpickerfilter TYPE BIGINT, ALTER COLUMN projectroleid TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE versioncontrol ALTER COLUMN id TYPE BIGINT; ALTER TABLE votehistory ALTER COLUMN issueid TYPE BIGINT, ALTER COLUMN votes TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE workflowscheme ALTER COLUMN id TYPE BIGINT; ALTER TABLE workflowschemeentity ALTER COLUMN scheme TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; ALTER TABLE worklog ALTER COLUMN issueid TYPE BIGINT, ALTER COLUMN rolelevel TYPE BIGINT, ALTER COLUMN timeworked TYPE BIGINT, ALTER COLUMN id TYPE BIGINT; " PL/pgSQL function migration_change_ids(text) line 25
Workaround
Currently, there is no known workaround for this behaviour. A workaround will be added here when available.