Loomio Community - Installing Loomio

Wed 12 Jul 2023 8:51PM

Loomio site crashed after ~3 years of up time after domain name expired.

Ethan Rooney Public Seen by 61

I recently let a domain name expire. I would like to migrate my loomio instance to a new domain name. I have tried to update the env file with the new domain name, and updating loomio to the current version. Unfortunately I am still getting a 502 error for bad gateway.

The results of my attemt to upgrade are seen below.

Pulling nginx ... done

Pulling letsencrypt ... done

Pulling worker ... done

Pulling db ... done

Pulling app ... done

Pulling redis ... done

Pulling mailin ... done

Stopping loomio-letsencrypt ... done

Stopping loomio-app ... done

Stopping loomio-worker ... done

Stopping loomio-mailin ... done

Stopping loomio-redis ... done

Stopping loomio-nginx ... done

Stopping loomio-db ... done

Removing loomio-letsencrypt ... done

Removing loomio-app ... done

Removing loomio-worker ... done

Removing loomio-mailin ... done

Removing loomio-redis ... done

Removing loomio-nginx ... done

Removing loomio-db ... done

Removing network loomio-deploy_main

Creating network "loomio-deploy_main" with the default driver

Creating loomio-db ... done

I, [2023-07-12T20:44:57.795619 #1] INFO -- : Migrating to NullUserIdsOnGuestMemberships (20200418053923)

20200418053923 NullUserIdsOnGuestMemberships: migrating ==================

-- execute("CREATE TEMP TABLE guest_memberships (id INT, user_id INT)")

-> 0.0150s

-- execute("INSERT INTO guest_memberships (id, user_id) SELECT memberships.id, memberships.user_id FROM memberships LEFT OUTER JOIN groups on groups.id = memberships.group_id WHERE groups.id IS NULL")

-> 0.0153s

-- execute("UPDATE memberships SET user_id = null WHERE id IN (SELECT id FROM guest_memberships)")

-> 0.0019s

20200418053923 NullUserIdsOnGuestMemberships: migrated (0.0367s) =========

I, [2023-07-12T20:44:57.847342 #1] INFO -- : Migrating to CopyInviterIdsToDiscussionReaders (20200418054222)

20200418054222 CopyInviterIdsToDiscussionReaders: migrating ==============

-- execute("DELETE FROM memberships WHERE user_id IS NULL")

-> 0.0009s

-- execute("CREATE TEMP TABLE membership_event_ids (id INT)")

-> 0.0009s

-- execute("INSERT INTO membership_event_ids (id) select events.id from events LEFT OUTER JOIN memberships ON events.eventable_id = memberships.id where eventable_type='Membership' and memberships.id is null")

-> 0.0154s

-- execute("DELETE FROM events where id in (SELECT id from membership_event_ids)")

-> 0.0014s

-- execute("CREATE TEMP TABLE notification_ids (id INT)")

-> 0.0029s

-- execute("INSERT INTO notification_ids (id) SELECT notifications.id FROM notifications LEFT OUTER JOIN events on notifications.event_id = events.id WHERE events.id is null")

-> 0.0165s

-- execute("DELETE FROM notifications WHERE id IN (select id from notification_ids)")

-> 0.0007s

20200418054222 CopyInviterIdsToDiscussionReaders: migrated (0.0483s) =====

I, [2023-07-12T20:44:57.903790 #1] INFO -- : Migrating to AllowNullStanceParticipant (20200521082353)

20200521082353 AllowNullStanceParticipant: migrating =====================

-- change_column(:stances, :participant_id, :integer, {:null=>true})

-> 0.0071s

20200521082353 AllowNullStanceParticipant: migrated (0.0083s) ============

I, [2023-07-12T20:44:57.918783 #1] INFO -- : Migrating to DropUserFromAnonymousStancesAndEvents (20200521231650)

20200521231650 DropUserFromAnonymousStancesAndEvents: migrating ==========

20200521231650 DropUserFromAnonymousStancesAndEvents: migrated (0.0986s) =

I, [2023-07-12T20:44:58.027003 #1] INFO -- : Migrating to AddHideResultsUntilClosedToPolls (20200522034042)

20200522034042 AddHideResultsUntilClosedToPolls: migrating ===============

-- add_column(:polls, :hide_results_until_closed, :boolean, {:default=>false, :null=>false})

-> 0.0038s

20200522034042 AddHideResultsUntilClosedToPolls: migrated (0.0049s) ======

I, [2023-07-12T20:44:58.037498 #1] INFO -- : Migrating to AddStancesInDiscussionToPolls (20200602220450)

20200602220450 AddStancesInDiscussionToPolls: migrating ==================

-- add_column(:polls, :stances_in_discussion, :boolean, {:default=>true, :null=>false})

-> 0.0023s

20200602220450 AddStancesInDiscussionToPolls: migrated (0.0034s) =========

I, [2023-07-12T20:44:58.046175 #1] INFO -- : Migrating to AdminsCanEditUserContentToGroups (20200612025415)

20200612025415 AdminsCanEditUserContentToGroups: migrating ===============

-- add_column(:groups, :admins_can_edit_user_content, :boolean, {:null=>false, :default=>false})

-> 0.0026s

20200612025415 AdminsCanEditUserContentToGroups: migrated (0.0039s) ======

I, [2023-07-12T20:44:58.055769 #1] INFO -- : Migrating to AddDiscardedAtToPolls (20200615225435)

20200615225435 AddDiscardedAtToPolls: migrating ==========================

-- add_column(:polls, :discarded_at, :timestamp, {:precision=>nil})

-> 0.0010s

-- add_column(:polls, :discarded_by, :integer)

-> 0.0005s

20200615225435 AddDiscardedAtToPolls: migrated (0.0037s) =================

I, [2023-07-12T20:44:58.064410 #1] INFO -- : Migrating to UnpinnDiscardedComments (20200617030449)

20200617030449 UnpinnDiscardedComments: migrating ========================

20200617030449 UnpinnDiscardedComments: migrated (0.0319s) ===============

I, [2023-07-12T20:44:58.102982 #1] INFO -- : Migrating to AddDesiredFeatureToGroupSurveys (20200630233309)

20200630233309 AddDesiredFeatureToGroupSurveys: migrating ================

-- add_column(:group_surveys, :desired_feature, :string)

-> 0.0009s

20200630233309 AddDesiredFeatureToGroupSurveys: migrated (0.0020s) =======

I, [2023-07-12T20:44:58.109895 #1] INFO -- : Migrating to UpdateUserTitles (20200703033800)

20200703033800 UpdateUserTitles: migrating ===============================

rake aborted!

StandardError: An error has occurred, this and all later migrations canceled:

undefined local variable or method `bot' for #<User unsubscribe_token: "Cscf4ELDTX8UXgetXPsr", email_api_key: "4ff6c1c08687ee04a5b4afdc874737df", email: "[email protected]", id: 5, created_at: "2020-06-30 21:28:55.257496000 +0000", updated_at: "2023-02-01 23:43:23.951074000 +0000", name: "Shana Oppenheim", deactivated_at: nil, is_admin: false, avatar_kind: "initials", uploaded_avatar_file_name: nil, uploaded_avatar_content_type: nil, uploaded_avatar_file_size: nil, uploaded_avatar_updated_at: nil, avatar_initials: "SO", username: "XXXX", email_when_proposal_closing_soon: false, authentication_token: nil, memberships_count: 18, uses_markdown: false, selected_locale: nil, time_zone: "America/New_York", key: "3MSWNFP2", detected_locale: "en", email_catch_up: false, email_when_mentioned: true, email_on_participation: false, default_membership_volume: "normal", country: "United States", region: nil, city: nil, experiences: {"sidebar"=>true, "changePicture"=>true, "closingThread"=>true, "dismissThread"=>true, "pinningThread"=>true, "score_tool_tip"=>true, "proposal_tool_tip"=>true, "dismissProgressCard"=>true, "html-editor.expanded"=>true, "titles"=>{1=>"Millie did it"}}, facebook_community_id: nil, slack_community_id: nil, short_bio: "", email_verified: true, location: "", last_seen_at: "2023-02-01 23:43:23.940903000 +0000", legal_accepted_at: nil, email_newsletter: false, short_bio_format: "md", attachments: []>

/usr/local/bundle/gems/activemodel-7.0.4.2/lib/active_model/attribute_methods.rb:458:in `method_missing'

/loomio/app/models/user.rb:46:in `block in <class:User>'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/callbacks.rb:445:in `instance_exec'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/callbacks.rb:445:in `block in make_lambda'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/callbacks.rb:179:in `block (2 levels) in halting_and_conditional'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/callbacks.rb:179:in `all?'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/callbacks.rb:179:in `block in halting_and_conditional'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/callbacks.rb:595:in `block in invoke_before'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/callbacks.rb:595:in `each'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/callbacks.rb:595:in `invoke_before'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/callbacks.rb:106:in `run_callbacks'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/callbacks.rb:929:in `_run_validate_callbacks'

/usr/local/bundle/gems/activemodel-7.0.4.2/lib/active_model/validations.rb:406:in `run_validations!'

/usr/local/bundle/gems/activemodel-7.0.4.2/lib/active_model/validations/callbacks.rb:117:in `block in run_validations!'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/callbacks.rb:107:in `run_callbacks'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/callbacks.rb:929:in `_run_validation_callbacks'

/usr/local/bundle/gems/activemodel-7.0.4.2/lib/active_model/validations/callbacks.rb:117:in `run_validations!'

/usr/local/bundle/gems/activemodel-7.0.4.2/lib/active_model/validations.rb:337:in `valid?'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/validations.rb:68:in `valid?'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/validations.rb:84:in `perform_validations'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/validations.rb:53:in `save!'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/transactions.rb:302:in `block in save!'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/transactions.rb:354:in `block in with_transaction_returning_status'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/database_statements.rb:314:in `transaction'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/transactions.rb:350:in `with_transaction_returning_status'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/transactions.rb:302:in `save!'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/suppressor.rb:54:in `save!'

/loomio/app/services/membership_service.rb:73:in `update_user_titles_and_broadcast'

/loomio/db/migrate/20200703033800_update_user_titles.rb:4:in `block in change'

/loomio/db/migrate/20200703033800_update_user_titles.rb:3:in `each'

/loomio/db/migrate/20200703033800_update_user_titles.rb:3:in `change'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:870:in `exec_migration'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:854:in `block (2 levels) in migrate'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:853:in `block in migrate'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:215:in `with_connection'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:852:in `migrate'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1046:in `migrate'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1360:in `block in execute_migration_in_transaction'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'

/usr/local/bundle/gems/activesupport-7.0.4.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/transactions.rb:209:in `transaction'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1411:in `ddl_transaction'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1359:in `execute_migration_in_transaction'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1333:in `each'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1333:in `migrate_without_lock'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1282:in `block in migrate'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1432:in `block in with_advisory_lock'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:215:in `with_connection'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1447:in `with_advisory_lock_connection'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1428:in `with_advisory_lock'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1282:in `migrate'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1117:in `up'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1092:in `migrate'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/tasks/database_tasks.rb:262:in `migrate'

/usr/local/bundle/gems/activerecord-7.0.4.2/lib/active_record/railties/databases.rake:92:in `block (2 levels) in <main>'

/usr/local/bundle/gems/sentry-ruby-5.9.0/lib/sentry/rake.rb:26:in `execute'

Caused by:

NameError: undefined local variable or method `bot' for #<User unsubscribe_token: "Cscf4ELDTX8UXgetXPsr", email_api_key: "4ff6c1c08687ee04a5b4afdc874737df", email: "[email protected]", id: 5, created_at: "2020-06-30 21:28:55.257496000 +0000", updated_at: "2023-02-01 23:43:23.951074000 +0000", name: "Shana Oppenheim", deactivated_at: nil, is_admin: false, avatar_kind: "initials", uploaded_avatar_file_name: nil, uploaded_avatar_content_type: nil, uploaded_avatar_file_size: nil, uploaded_avatar_updated_at: nil, avatar_initials: "SO", username: "XXXX", email_when_proposal_closing_soon: false, authentication_token: nil, memberships_count: 18, uses_markdown: false, selected_locale: nil, time_zone: "America/New_York", key: "3MSWNFP2", detected_locale: "en", email_catch_up: false, email_when_mentioned: true, email_on_participation: false, default_membership_volume: "normal", country: "United States", region: nil, city: nil, experiences: {"sidebar"=>true, "changePicture"=>true, "closingThread"=>true, "dismissThread"=>true, "pinningThread"=>true, "score_tool_tip"=>true, "proposal_tool_tip"=>true, "dismissProgressCard"=>true, "html-editor.expanded"=>true, "titles"=>{1=>"Millie did it"}}, facebook_community_id: nil, slack_community_id: nil, short_bio: "", email_verified: true, location: "", last_seen_at: "2023-02-01 23:43:23.940903000 +0000", legal_accepted_at: nil, email_newsletter: false, short_bio_format: "md", attachments: []>