I’m having issues with restoring from a sqlite backup.
I’m setting up the newest stable version exactly as dictated by the documentations, then running the setup for the sqlite3 db.
Then I ran these commands:
sudo apt update
sudo apt install -y sqlite3
sudo rm -rf backup-gitea
sudo unzip backup-gitea.zip -d backup-gitea
cd backup-gitea
sudo mv app.ini /etc/gitea/app.ini
sudo rm -rf /var/lib/gitea/data/
sudo rm -rf /var/lib/gitea/log/
sudo rm -rf /var/lib/gitea/data/gitea-repositories
sudo mkdir /var/lib/gitea/data/
sudo mkdir /var/lib/gitea/log/
sudo mkdir /var/lib/gitea/data/gitea-repositories
sudo mv data/* /var/lib/gitea/data/
sudo mv log/* /var/lib/gitea/log/
sudo mv repos/* /var/lib/gitea/data/gitea-repositories
sudo chown ansible:ansible /var/lib/gitea/data/gitea.db
sudo su -c "sqlite3 /var/lib/gitea/data/gitea.db < gitea-db.sql"
I tried running the last step with just sudo, but I got a -bash: gitea-db.sql: Permission denied error.
Even after running from the root user, I get this long string of errors:
Error: near line 4: in prepare, index IDX_oauth2_application_uid already exists (1)
Error: near line 5: in prepare, index UQE_oauth2_application_client_id already exists (1)
Error: near line 6: in prepare, index IDX_oauth2_application_created_unix already exists (1)
Error: near line 7: in prepare, index IDX_oauth2_application_updated_unix already exists (1)
Error: near line 8: stepping, UNIQUE constraint failed: oauth2_application.id (19)
Error: near line 9: stepping, UNIQUE constraint failed: oauth2_application.id (19)
Error: near line 12: in prepare, index UQE_oauth2_authorization_code_code already exists (1)
Error: near line 13: in prepare, index IDX_oauth2_authorization_code_valid_until already exists (1)
Error: near line 16: in prepare, index IDX_oauth2_grant_application_id already exists (1)
Error: near line 17: in prepare, index UQE_oauth2_grant_user_application already exists (1)
Error: near line 18: in prepare, index IDX_oauth2_grant_user_id already exists (1)
Error: near line 23: in prepare, index UQE_login_source_name already exists (1)
Error: near line 24: in prepare, index IDX_login_source_is_active already exists (1)
Error: near line 25: in prepare, index IDX_login_source_is_sync_enabled already exists (1)
Error: near line 26: in prepare, index IDX_login_source_created_unix already exists (1)
Error: near line 27: in prepare, index IDX_login_source_updated_unix already exists (1)
Error: near line 30: in prepare, index IDX_access_token_token_last_eight already exists (1)
Error: near line 31: in prepare, index IDX_access_token_created_unix already exists (1)
Error: near line 32: in prepare, index IDX_access_token_updated_unix already exists (1)
Error: near line 33: in prepare, index IDX_access_token_uid already exists (1)
Error: near line 34: in prepare, index UQE_access_token_token_hash already exists (1)
Error: near line 37: in prepare, index UQE_two_factor_uid already exists (1)
Error: near line 38: in prepare, index IDX_two_factor_created_unix already exists (1)
Error: near line 39: in prepare, index IDX_two_factor_updated_unix already exists (1)
Error: near line 42: in prepare, index UQE_webauthn_credential_s already exists (1)
Error: near line 43: in prepare, index IDX_webauthn_credential_user_id already exists (1)
Error: near line 44: in prepare, index IDX_webauthn_credential_credential_id already exists (1)
Error: near line 45: in prepare, index IDX_webauthn_credential_created_unix already exists (1)
Error: near line 46: in prepare, index IDX_webauthn_credential_updated_unix already exists (1)
Error: near line 49: in prepare, index UQE_email_hash_email already exists (1)
Error: near line 50: stepping, UNIQUE constraint failed: email_hash.email (19)
Error: near line 53: in prepare, index UQE_dbfs_meta_full_path already exists (1)
Error: near line 56: in prepare, index IDX_dbfs_data_meta_offset already exists (1)
Error: near line 59: in prepare, index UQE_secret_owner_repo_name already exists (1)
Error: near line 60: in prepare, index IDX_secret_owner_id already exists (1)
Error: near line 61: in prepare, index IDX_secret_repo_id already exists (1)
Error: near line 64: stepping, UNIQUE constraint failed: app_state.id (19)
Error: near line 67: in prepare, index IDX_notice_created_unix already exists (1)
Error: near line 70: in prepare, index UQE_system_setting_setting_key already exists (1)
Error: near line 71: stepping, UNIQUE constraint failed: system_setting.id (19)
Error: near line 72: stepping, UNIQUE constraint failed: system_setting.id (19)
Error: near line 73: stepping, UNIQUE constraint failed: system_setting.id (19)
Error: near line 78: in prepare, index IDX_user_badge_user_id already exists (1)
Error: near line 81: in prepare, index IDX_email_address_uid already exists (1)
Error: near line 82: in prepare, index UQE_email_address_email already exists (1)
Error: near line 83: in prepare, index UQE_email_address_lower_email already exists (1)
Error: near line 84: stepping, UNIQUE constraint failed: email_address.id (19)
Error: near line 87: in prepare, index IDX_external_login_user_user_id already exists (1)
Error: near line 88: in prepare, index IDX_external_login_user_provider already exists (1)
Error: near line 91: in prepare, index IDX_follow_created_unix already exists (1)
Error: near line 92: in prepare, index UQE_follow_follow already exists (1)
Error: near line 95: in prepare, index IDX_user_open_id_uid already exists (1)
Error: near line 96: in prepare, index UQE_user_open_id_uri already exists (1)
Error: near line 99: in prepare, index UQE_user_redirect_s already exists (1)
Error: near line 100: in prepare, index IDX_user_redirect_lower_name already exists (1)
Error: near line 103: in prepare, index UQE_user_setting_key_userid already exists (1)
Error: near line 104: in prepare, index IDX_user_setting_user_id already exists (1)
Error: near line 105: in prepare, index IDX_user_setting_setting_key already exists (1)
Error: near line 108: in prepare, index IDX_user_updated_unix already exists (1)
Error: near line 109: in prepare, index IDX_user_last_login_unix already exists (1)
Error: near line 110: in prepare, index IDX_user_is_active already exists (1)
Error: near line 111: in prepare, index UQE_user_lower_name already exists (1)
Error: near line 112: in prepare, index UQE_user_name already exists (1)
Error: near line 113: in prepare, index IDX_user_created_unix already exists (1)
Error: near line 114: stepping, UNIQUE constraint failed: user.id (19)
Error: near line 117: in prepare, index UQE_repo_archiver_s already exists (1)
Error: near line 118: in prepare, index IDX_repo_archiver_repo_id already exists (1)
Error: near line 119: in prepare, index IDX_repo_archiver_created_unix already exists (1)
Error: near line 122: in prepare, index UQE_attachment_uuid already exists (1)
Error: near line 123: in prepare, index IDX_attachment_repo_id already exists (1)
Error: near line 124: in prepare, index IDX_attachment_issue_id already exists (1)
Error: near line 125: in prepare, index IDX_attachment_release_id already exists (1)
Error: near line 126: in prepare, index IDX_attachment_uploader_id already exists (1)
Error: near line 129: in prepare, index IDX_collaboration_repo_id already exists (1)
Error: near line 130: in prepare, index IDX_collaboration_user_id already exists (1)
Error: near line 131: in prepare, index IDX_collaboration_created_unix already exists (1)
Error: near line 132: in prepare, index IDX_collaboration_updated_unix already exists (1)
Error: near line 133: in prepare, index UQE_collaboration_s already exists (1)
Error: near line 136: in prepare, index UQE_language_stat_s already exists (1)
Error: near line 137: in prepare, index IDX_language_stat_repo_id already exists (1)
Error: near line 138: in prepare, index IDX_language_stat_language already exists (1)
Error: near line 139: in prepare, index IDX_language_stat_created_unix already exists (1)
Error: near line 142: in prepare, index IDX_mirror_repo_id already exists (1)
Error: near line 143: in prepare, index IDX_mirror_updated_unix already exists (1)
Error: near line 144: in prepare, index IDX_mirror_next_update_unix already exists (1)
Error: near line 147: in prepare, index IDX_push_mirror_repo_id already exists (1)
Error: near line 148: in prepare, index IDX_push_mirror_last_update already exists (1)
Error: near line 151: in prepare, index UQE_repo_redirect_s already exists (1)
Error: near line 152: in prepare, index IDX_repo_redirect_lower_name already exists (1)
Error: near line 155: in prepare, index IDX_release_publisher_id already exists (1)
Error: near line 156: in prepare, index IDX_release_tag_name already exists (1)
Error: near line 157: in prepare, index IDX_release_original_author_id already exists (1)
Error: near line 158: in prepare, index IDX_release_created_unix already exists (1)
Error: near line 159: in prepare, index UQE_release_n already exists (1)
Error: near line 160: in prepare, index IDX_release_repo_id already exists (1)
Error: near line 163: in prepare, index IDX_repository_is_mirror already exists (1)
Error: near line 164: in prepare, index IDX_repository_lower_name already exists (1)
Error: near line 165: in prepare, index IDX_repository_is_private already exists (1)
Error: near line 166: in prepare, index IDX_repository_created_unix already exists (1)
Error: near line 167: in prepare, index UQE_repository_s already exists (1)
Error: near line 168: in prepare, index IDX_repository_name already exists (1)
Error: near line 169: in prepare, index IDX_repository_is_archived already exists (1)
Error: near line 170: in prepare, index IDX_repository_is_fork already exists (1)
Error: near line 171: in prepare, index IDX_repository_fork_id already exists (1)
Error: near line 172: in prepare, index IDX_repository_is_template already exists (1)
Error: near line 173: in prepare, index IDX_repository_owner_id already exists (1)
Error: near line 174: in prepare, index IDX_repository_is_empty already exists (1)
Error: near line 175: in prepare, index IDX_repository_template_id already exists (1)
Error: near line 176: in prepare, index IDX_repository_updated_unix already exists (1)
Error: near line 177: in prepare, index IDX_repository_original_service_type already exists (1)
Error: near line 178: stepping, UNIQUE constraint failed: repository.id (19)
Error: near line 181: in prepare, index IDX_repo_indexer_status_s already exists (1)
Error: near line 184: in prepare, index IDX_repo_unit_s already exists (1)
Error: near line 185: in prepare, index IDX_repo_unit_created_unix already exists (1)
Error: near line 186: stepping, UNIQUE constraint failed: repo_unit.id (19)
Error: near line 187: stepping, UNIQUE constraint failed: repo_unit.id (19)
Error: near line 188: stepping, UNIQUE constraint failed: repo_unit.id (19)
Error: near line 189: stepping, UNIQUE constraint failed: repo_unit.id (19)
Error: near line 190: stepping, UNIQUE constraint failed: repo_unit.id (19)
Error: near line 191: stepping, UNIQUE constraint failed: repo_unit.id (19)
Error: near line 192: stepping, UNIQUE constraint failed: repo_unit.id (19)
Error: near line 195: in prepare, index UQE_star_s already exists (1)
Error: near line 196: in prepare, index IDX_star_created_unix already exists (1)
Error: near line 199: in prepare, index UQE_topic_name already exists (1)
Error: near line 200: in prepare, index IDX_topic_created_unix already exists (1)
Error: near line 201: in prepare, index IDX_topic_updated_unix already exists (1)
Error: near line 206: in prepare, index UQE_upload_uuid already exists (1)
Error: near line 209: in prepare, index IDX_watch_created_unix already exists (1)
Error: near line 210: in prepare, index IDX_watch_updated_unix already exists (1)
Error: near line 211: in prepare, index UQE_watch_watch already exists (1)
Error: near line 212: stepping, UNIQUE constraint failed: watch.id (19)
Error: near line 215: in prepare, index IDX_action_artifact_status already exists (1)
Error: near line 216: in prepare, index IDX_action_artifact_updated_unix already exists (1)
Error: near line 217: in prepare, index IDX_action_artifact_expired_unix already exists (1)
Error: near line 218: in prepare, index UQE_action_artifact_runid_name_path already exists (1)
Error: near line 219: in prepare, index IDX_action_artifact_run_id already exists (1)
Error: near line 220: in prepare, index IDX_action_artifact_repo_id already exists (1)
Error: near line 221: in prepare, index IDX_action_artifact_artifact_path already exists (1)
Error: near line 222: in prepare, index IDX_action_artifact_artifact_name already exists (1)
Error: near line 225: in prepare, index IDX_action_run_owner_id already exists (1)
Error: near line 226: in prepare, index IDX_action_run_workflow_id already exists (1)
Error: near line 227: in prepare, index IDX_action_run_trigger_user_id already exists (1)
Error: near line 228: in prepare, index IDX_action_run_approved_by already exists (1)
Error: near line 229: in prepare, index IDX_action_run_status already exists (1)
Error: near line 230: in prepare, index IDX_action_run_repo_id already exists (1)
Error: near line 231: in prepare, index UQE_action_run_repo_index already exists (1)
Error: near line 232: in prepare, index IDX_action_run_index already exists (1)
Error: near line 233: in prepare, index IDX_action_run_ref already exists (1)
Error: near line 236: in prepare, index IDX_action_run_index_max_index already exists (1)
Error: near line 239: in prepare, index IDX_action_run_job_owner_id already exists (1)
Error: near line 240: in prepare, index IDX_action_run_job_commit_sha already exists (1)
Error: near line 241: in prepare, index IDX_action_run_job_status already exists (1)
Error: near line 242: in prepare, index IDX_action_run_job_updated already exists (1)
Error: near line 243: in prepare, index IDX_action_run_job_run_id already exists (1)
Error: near line 244: in prepare, index IDX_action_run_job_repo_id already exists (1)
Error: near line 247: in prepare, index IDX_action_runner_last_active already exists (1)
Error: near line 248: in prepare, index UQE_action_runner_uuid already exists (1)
Error: near line 249: in prepare, index IDX_action_runner_owner_id already exists (1)
Error: near line 250: in prepare, index IDX_action_runner_repo_id already exists (1)
Error: near line 251: in prepare, index UQE_action_runner_token_hash already exists (1)
Error: near line 252: in prepare, index IDX_action_runner_last_online already exists (1)
Error: near line 255: in prepare, index UQE_action_runner_token_token already exists (1)
Error: near line 256: in prepare, index IDX_action_runner_token_owner_id already exists (1)
Error: near line 257: in prepare, index IDX_action_runner_token_repo_id already exists (1)
Error: near line 260: in prepare, index IDX_action_schedule_repo_id already exists (1)
Error: near line 261: in prepare, index IDX_action_schedule_owner_id already exists (1)
Error: near line 264: in prepare, index IDX_action_schedule_spec_repo_id already exists (1)
Error: near line 265: in prepare, index IDX_action_schedule_spec_schedule_id already exists (1)
Error: near line 266: in prepare, index IDX_action_schedule_spec_next already exists (1)
Error: near line 269: in prepare, index UQE_action_task_token_hash already exists (1)
Error: near line 270: in prepare, index IDX_action_task_token_last_eight already exists (1)
Error: near line 271: in prepare, index IDX_action_task_started already exists (1)
Error: near line 272: in prepare, index IDX_action_task_owner_id already exists (1)
Error: near line 273: in prepare, index IDX_action_task_repo_id already exists (1)
Error: near line 274: in prepare, index IDX_action_task_commit_sha already exists (1)
Error: near line 275: in prepare, index IDX_action_task_updated already exists (1)
Error: near line 276: in prepare, index IDX_action_task_runner_id already exists (1)
Error: near line 277: in prepare, index IDX_action_task_status already exists (1)
Error: near line 280: in prepare, index UQE_action_task_output_task_id_output_key already exists (1)
Error: near line 281: in prepare, index IDX_action_task_output_task_id already exists (1)
Error: near line 284: in prepare, index UQE_action_task_step_task_index already exists (1)
Error: near line 285: in prepare, index IDX_action_task_step_task_id already exists (1)
Error: near line 286: in prepare, index IDX_action_task_step_index already exists (1)
Error: near line 287: in prepare, index IDX_action_task_step_repo_id already exists (1)
Error: near line 288: in prepare, index IDX_action_task_step_status already exists (1)
Error: near line 291: in prepare, index UQE_action_tasks_version_owner_repo already exists (1)
Error: near line 292: in prepare, index IDX_action_tasks_version_repo_id already exists (1)
Error: near line 295: in prepare, index UQE_action_variable_owner_repo_name already exists (1)
Error: near line 296: in prepare, index IDX_action_variable_repo_id already exists (1)
Error: near line 299: in prepare, index IDX_task_repo_id already exists (1)
Error: near line 300: in prepare, index IDX_task_status already exists (1)
Error: near line 301: in prepare, index IDX_task_doer_id already exists (1)
Error: near line 302: in prepare, index IDX_task_owner_id already exists (1)
Error: near line 305: in prepare, index IDX_gpg_key_owner_id already exists (1)
Error: near line 306: in prepare, index IDX_gpg_key_key_id already exists (1)
Error: near line 311: in prepare, index IDX_public_key_owner_id already exists (1)
Error: near line 312: in prepare, index IDX_public_key_fingerprint already exists (1)
Error: near line 315: in prepare, index IDX_deploy_key_key_id already exists (1)
Error: near line 316: in prepare, index IDX_deploy_key_repo_id already exists (1)
Error: near line 317: in prepare, index UQE_deploy_key_s already exists (1)
Error: near line 320: in prepare, index UQE_org_user_s already exists (1)
Error: near line 321: in prepare, index IDX_org_user_uid already exists (1)
Error: near line 322: in prepare, index IDX_org_user_org_id already exists (1)
Error: near line 323: in prepare, index IDX_org_user_is_public already exists (1)
Error: near line 326: in prepare, index IDX_team_org_id already exists (1)
Error: near line 329: in prepare, index UQE_team_user_s already exists (1)
Error: near line 330: in prepare, index IDX_team_user_org_id already exists (1)
Error: near line 333: in prepare, index IDX_team_repo_org_id already exists (1)
Error: near line 334: in prepare, index UQE_team_repo_s already exists (1)
Error: near line 337: in prepare, index IDX_team_unit_org_id already exists (1)
Error: near line 338: in prepare, index UQE_team_unit_s already exists (1)
Error: near line 341: in prepare, index IDX_team_invite_org_id already exists (1)
Error: near line 342: in prepare, index UQE_team_invite_team_mail already exists (1)
Error: near line 343: in prepare, index IDX_team_invite_team_id already exists (1)
Error: near line 344: in prepare, index IDX_team_invite_created_unix already exists (1)
Error: near line 345: in prepare, index IDX_team_invite_updated_unix already exists (1)
Error: near line 346: in prepare, index IDX_team_invite_token already exists (1)
Error: near line 349: in prepare, index IDX_package_repo_id already exists (1)
Error: near line 350: in prepare, index IDX_package_type already exists (1)
Error: near line 351: in prepare, index IDX_package_lower_name already exists (1)
Error: near line 352: in prepare, index UQE_package_s already exists (1)
Error: near line 353: in prepare, index IDX_package_owner_id already exists (1)
Error: near line 356: in prepare, index UQE_package_blob_md5 already exists (1)
Error: near line 357: in prepare, index IDX_package_blob_hash_sha256 already exists (1)
Error: near line 358: in prepare, index IDX_package_blob_hash_sha512 already exists (1)
Error: near line 359: in prepare, index UQE_package_blob_sha512 already exists (1)
Error: near line 360: in prepare, index IDX_package_blob_created_unix already exists (1)
Error: near line 361: in prepare, index IDX_package_blob_hash_md5 already exists (1)
Error: near line 362: in prepare, index UQE_package_blob_sha1 already exists (1)
Error: near line 363: in prepare, index IDX_package_blob_hash_sha1 already exists (1)
Error: near line 364: in prepare, index UQE_package_blob_sha256 already exists (1)
Error: near line 367: in prepare, index IDX_package_blob_upload_updated_unix already exists (1)
Error: near line 370: in prepare, index IDX_package_cleanup_rule_enabled already exists (1)
Error: near line 371: in prepare, index UQE_package_cleanup_rule_s already exists (1)
Error: near line 372: in prepare, index IDX_package_cleanup_rule_owner_id already exists (1)
Error: near line 373: in prepare, index IDX_package_cleanup_rule_type already exists (1)
Error: near line 376: in prepare, index IDX_package_file_lower_name already exists (1)
Error: near line 377: in prepare, index IDX_package_file_composite_key already exists (1)
Error: near line 378: in prepare, index IDX_package_file_created_unix already exists (1)
Error: near line 379: in prepare, index IDX_package_file_version_id already exists (1)
Error: near line 380: in prepare, index UQE_package_file_s already exists (1)
Error: near line 381: in prepare, index IDX_package_file_blob_id already exists (1)
Error: near line 384: in prepare, index IDX_package_property_ref_type already exists (1)
Error: near line 385: in prepare, index IDX_package_property_ref_id already exists (1)
Error: near line 386: in prepare, index IDX_package_property_name already exists (1)
Error: near line 389: in prepare, index IDX_package_version_created_unix already exists (1)
Error: near line 390: in prepare, index IDX_package_version_is_internal already exists (1)
Error: near line 391: in prepare, index UQE_package_version_s already exists (1)
Error: near line 392: in prepare, index IDX_package_version_package_id already exists (1)
Error: near line 393: in prepare, index IDX_package_version_lower_version already exists (1)
Error: near line 396: in prepare, index UQE_access_s already exists (1)
Error: near line 399: in prepare, index UQE_branch_s already exists (1)
Error: near line 400: in prepare, index IDX_branch_is_deleted already exists (1)
Error: near line 401: in prepare, index IDX_branch_deleted_unix already exists (1)
Error: near line 404: in prepare, index IDX_renamed_branch_repo_id already exists (1)
Error: near line 407: in prepare, index UQE_commit_status_repo_sha_index already exists (1)
Error: near line 408: in prepare, index IDX_commit_status_index already exists (1)
Error: near line 409: in prepare, index IDX_commit_status_repo_id already exists (1)
Error: near line 410: in prepare, index IDX_commit_status_sha already exists (1)
Error: near line 411: in prepare, index IDX_commit_status_context_hash already exists (1)
Error: near line 412: in prepare, index IDX_commit_status_created_unix already exists (1)
Error: near line 413: in prepare, index IDX_commit_status_updated_unix already exists (1)
Error: near line 416: in prepare, index UQE_commit_status_index_repo_sha already exists (1)
Error: near line 417: in prepare, index IDX_commit_status_index_max_index already exists (1)
Error: near line 420: in prepare, index UQE_lfs_meta_object_s already exists (1)
Error: near line 421: in prepare, index IDX_lfs_meta_object_oid already exists (1)
Error: near line 422: in prepare, index IDX_lfs_meta_object_repository_id already exists (1)
Error: near line 423: in prepare, index IDX_lfs_meta_object_updated_unix already exists (1)
Error: near line 426: in prepare, index IDX_lfs_lock_repo_id already exists (1)
Error: near line 427: in prepare, index IDX_lfs_lock_owner_id already exists (1)
Error: near line 430: in prepare, index UQE_protected_branch_s already exists (1)
Error: near line 435: in prepare, index IDX_project_board_project_id already exists (1)
Error: near line 436: in prepare, index IDX_project_board_created_unix already exists (1)
Error: near line 437: in prepare, index IDX_project_board_updated_unix already exists (1)
Error: near line 440: in prepare, index IDX_project_issue_issue_id already exists (1)
Error: near line 441: in prepare, index IDX_project_issue_project_id already exists (1)
Error: near line 442: in prepare, index IDX_project_issue_project_board_id already exists (1)
Error: near line 445: in prepare, index IDX_project_updated_unix already exists (1)
Error: near line 446: in prepare, index IDX_project_title already exists (1)
Error: near line 447: in prepare, index IDX_project_owner_id already exists (1)
Error: near line 448: in prepare, index IDX_project_repo_id already exists (1)
Error: near line 449: in prepare, index IDX_project_is_closed already exists (1)
Error: near line 450: in prepare, index IDX_project_created_unix already exists (1)
Error: near line 453: in prepare, index UQE_pull_auto_merge_pull_id already exists (1)
Error: near line 456: in prepare, index UQE_review_state_pull_commit_user already exists (1)
Error: near line 457: in prepare, index IDX_review_state_pull_id already exists (1)
Error: near line 460: in prepare, index IDX_issue_assignees_assignee_id already exists (1)
Error: near line 461: in prepare, index IDX_issue_assignees_issue_id already exists (1)
Error: near line 464: in prepare, index IDX_comment_updated_unix already exists (1)
Error: near line 465: in prepare, index IDX_comment_ref_comment_id already exists (1)
Error: near line 466: in prepare, index IDX_comment_poster_id already exists (1)
Error: near line 467: in prepare, index IDX_comment_created_unix already exists (1)
Error: near line 468: in prepare, index IDX_comment_dependent_issue_id already exists (1)
Error: near line 469: in prepare, index IDX_comment_review_id already exists (1)
Error: near line 470: in prepare, index IDX_comment_ref_repo_id already exists (1)
Error: near line 471: in prepare, index IDX_comment_ref_issue_id already exists (1)
Error: near line 472: in prepare, index IDX_comment_type already exists (1)
Error: near line 473: in prepare, index IDX_comment_issue_id already exists (1)
Error: near line 476: in prepare, index IDX_issue_content_history_issue_id already exists (1)
Error: near line 477: in prepare, index IDX_issue_content_history_comment_id already exists (1)
Error: near line 478: in prepare, index IDX_issue_content_history_edited_unix already exists (1)
Error: near line 481: in prepare, index UQE_issue_dependency_issue_dependency already exists (1)
Error: near line 484: in prepare, index UQE_issue_repo_index already exists (1)
Error: near line 485: in prepare, index IDX_issue_deadline_unix already exists (1)
Error: near line 486: in prepare, index IDX_issue_created_unix already exists (1)
Error: near line 487: in prepare, index IDX_issue_closed_unix already exists (1)
Error: near line 488: in prepare, index IDX_issue_updated_unix already exists (1)
Error: near line 489: in prepare, index IDX_issue_repo_id already exists (1)
Error: near line 490: in prepare, index IDX_issue_poster_id already exists (1)
Error: near line 491: in prepare, index IDX_issue_original_author_id already exists (1)
Error: near line 492: in prepare, index IDX_issue_milestone_id already exists (1)
Error: near line 493: in prepare, index IDX_issue_is_closed already exists (1)
Error: near line 494: in prepare, index IDX_issue_is_pull already exists (1)
Error: near line 497: in prepare, index IDX_issue_index_max_index already exists (1)
Error: near line 500: in prepare, index IDX_issue_user_uid already exists (1)
Error: near line 501: in prepare, index IDX_issue_user_issue_id already exists (1)
Error: near line 504: in prepare, index UQE_issue_watch_watch already exists (1)
Error: near line 507: in prepare, index IDX_label_repo_id already exists (1)
Error: near line 508: in prepare, index IDX_label_org_id already exists (1)
Error: near line 509: in prepare, index IDX_label_created_unix already exists (1)
Error: near line 510: in prepare, index IDX_label_updated_unix already exists (1)
Error: near line 513: in prepare, index UQE_issue_label_s already exists (1)
Error: near line 516: in prepare, index IDX_milestone_repo_id already exists (1)
Error: near line 517: in prepare, index IDX_milestone_created_unix already exists (1)
Error: near line 518: in prepare, index IDX_milestone_updated_unix already exists (1)
Error: near line 521: in prepare, index IDX_pull_request_head_repo_id already exists (1)
Error: near line 522: in prepare, index IDX_pull_request_base_repo_id already exists (1)
Error: near line 523: in prepare, index IDX_pull_request_has_merged already exists (1)
Error: near line 524: in prepare, index IDX_pull_request_merger_id already exists (1)
Error: near line 525: in prepare, index IDX_pull_request_merged_unix already exists (1)
Error: near line 526: in prepare, index IDX_pull_request_issue_id already exists (1)
Error: near line 529: in prepare, index IDX_reaction_original_author already exists (1)
Error: near line 530: in prepare, index IDX_reaction_created_unix already exists (1)
Error: near line 531: in prepare, index UQE_reaction_s already exists (1)
Error: near line 532: in prepare, index IDX_reaction_type already exists (1)
Error: near line 533: in prepare, index IDX_reaction_issue_id already exists (1)
Error: near line 534: in prepare, index IDX_reaction_comment_id already exists (1)
Error: near line 535: in prepare, index IDX_reaction_user_id already exists (1)
Error: near line 536: in prepare, index IDX_reaction_original_author_id already exists (1)
Error: near line 539: in prepare, index IDX_review_reviewer_id already exists (1)
Error: near line 540: in prepare, index IDX_review_issue_id already exists (1)
Error: near line 541: in prepare, index IDX_review_created_unix already exists (1)
Error: near line 542: in prepare, index IDX_review_updated_unix already exists (1)
Error: near line 545: in prepare, index IDX_stopwatch_user_id already exists (1)
Error: near line 546: in prepare, index IDX_stopwatch_issue_id already exists (1)
Error: near line 549: in prepare, index IDX_tracked_time_issue_id already exists (1)
Error: near line 550: in prepare, index IDX_tracked_time_user_id already exists (1)
Error: near line 553: in prepare, index IDX_repo_transfer_created_unix already exists (1)
Error: near line 554: in prepare, index IDX_repo_transfer_updated_unix already exists (1)
Error: near line 557: in prepare, index IDX_hook_task_hook_id already exists (1)
Error: near line 558: in prepare, index UQE_hook_task_uuid already exists (1)
Error: near line 561: in prepare, index IDX_webhook_is_active already exists (1)
Error: near line 562: in prepare, index IDX_webhook_created_unix already exists (1)
Error: near line 563: in prepare, index IDX_webhook_updated_unix already exists (1)
Error: near line 564: in prepare, index IDX_webhook_repo_id already exists (1)
Error: near line 565: in prepare, index IDX_webhook_owner_id already exists (1)
Error: near line 568: in prepare, index IDX_action_user_id already exists (1)
Error: near line 569: in prepare, index IDX_action_comment_id already exists (1)
Error: near line 570: in prepare, index IDX_action_au_r_c_u_d already exists (1)
Error: near line 571: in prepare, index IDX_action_r_u_d already exists (1)
Error: near line 572: in prepare, index IDX_action_c_u_d already exists (1)
Error: near line 573: stepping, UNIQUE constraint failed: action.id (19)
Any idea how to solve this issue with restoring? I’ve had to truncate the error message to stay under the character limit.