AndrewKvalheim
commented
2 years ago This rollback failed due to a bug in the migration script; I accidentally populated its temporary file with the contents of another migration that we’re also bringing down. I’ve rolled it back manually now:
This wasn’t touched during the automated migration but we no longer use it. I’ve rolled it back manually as well:
These were superseded by 20220312000831_convert_proposal_questions_to_surveys and can’t be reverted:
- [ ]
20170613224853_add_diversity_to_events.rb - [ ]
20170614025428_add_first_time_to_events.rb - [ ]
20200710065434_add_pnw_to_events.rb
I’m not sure if there’s a way to clean them from the migration log, but I don’t think it causes any problem to leave them.
Logs from the switchover:
``` + cat + cat + cat + rake db:migrate:status jobs:clear data:drop_all_ahoy_events data:set_conference_in_versions I, [2022-06-17T02:10:32.692077 #205] INFO -- : [SKYLIGHT] [5.1.1] Unable to start, see the Skylight logs for more details database: osem Status Migration ID Migration Name -------------------------------------------------- up 20121223110942 Devise create users up 20121223115038 Create conferences table up 20121223115106 Create people table up 20121223115117 Create rooms table up 20121223115125 Create tracks table up 20121223115135 Create events table up 20121223120413 Create event types up 20121223122307 Create event people table up 20121223122842 Create venue table up 20121223135240 Create roles table up 20121223135447 User roles table up 20121224144728 Create cfp table up 20130103134212 Create registrations table up 20130104142209 Create comments up 20130104142839 Acts as commentable upgrade migration up 20130105115603 Create event attachments table up 20130107112833 Add registration dates to conferences table up 20130107113653 Remove cfp and reg booleans from conferences up 20130107114930 Create versions up 20130113105652 Create email table up 20130113132225 Add subjects to email settings up 20130117130949 Add logo to conferences table up 20130120104029 Change arrival registrations date to datetime up 20130131100257 Add minimum and maximum abstract lengths to event types up 20130202091022 Add dietary choice to conferences up 20130202091051 Create dietary choices table up 20130202091229 Add dietary choice to registration up 20130202093137 Add dietary text to registration up 20130202102024 Add handicapped access to registrations up 20130202130737 Create supporter level table up 20130202130923 Create table supporter registrations up 20130202131932 Add use supporter levels to conferences up 20130206192339 Rename attending social events with partner up 20130211170728 Add irc nick to people table up 20130216070725 Create social events table up 20130216120112 Create registrations social events table up 20130216122155 Set registration defaults to false up 20130216122417 Add special needs field to registrations up 20130515125823 Change attachment default up 20130515131420 Change venue types up 20130626095459 Add video id to events up 20130705055128 Add revision to conference up 20130711043459 Create events registrations table up 20130711044247 Add require registration to events up 20130712072609 Add attended to registrations up 20130728055450 Add schedule changes to call for papers up 20130815085420 Create votes up 20130815201317 Add rating to call for papers up 20130815201511 Add rating desc to call for papers up 20130821094246 Add volunteer to registrations up 20130821102003 Add volunteer experience to registrations up 20130821102047 Add tshirt to people up 20130821102108 Add mobile to people up 20130821102404 Add languages to people up 20130821102543 Add use vpositions to conferences up 20130821102618 Add use vdays to conferences up 20130821133651 Create vpositions up 20130821133850 Create vdays up 20131022131450 Add created at to supporter registrations up 20131228132353 Change default rating in call for papers up 20131228214532 Create vchoices up 20131229072532 Registrations vchoices up 20140109190643 Create questions up 20140109190844 Create question types up 20140109191042 Create answers up 20140109191145 Create qanswers up 20140109191321 Create conferences questions up 20140112192801 Create qanswers registrations up 20140212172244 Create difficulty levels up 20140212175251 Add use difficulty levels to conference up 20140213122424 Add difficulty level id to events up 20140304192527 Add use volunteers to conference up 20140305102505 Use vdays vpositions defaults up 20140319143547 Rename video to media on events up 20140401094729 Add schedule public to call for papers up 20140414131028 Add video to conferences up 20140514140013 Remove rating desc from cfp up 20140528072939 Add color to conference up 20140528084706 Add description to conference up 20140528115842 Add registration description to conference up 20140529133052 Add ticket description to conference up 20140529133228 Add description to supporter level up 20140529133339 Add ticket price to supporter level up 20140530082708 Remove color defaults up 20140603092041 Create openids up 20140604061951 Create lodgings up 20140604142949 Remove hard deadline from call for papers up 20140605055802 Create sponsorship levels up 20140605115251 Create sponsors up 20140605125153 Update event states up 20140606102331 Add sponsor description to conference up 20140606102358 Add sponsor email to conference up 20140609172219 Add person attributes to user up 20140610064046 Create photos up 20140610163947 Create event users up 20140610165551 Migrate data person to user up 20140610173021 Change person id to user id in registrations up 20140611123926 Change person id to user id in votes up 20140612141123 Add color to event type up 20140612181230 Add social urls to conference up 20140613083115 Add photo to venue up 20140614171853 Add lodging description to conference up 20140614174354 Add website link to lodging up 20140616131731 Add make conference public to conference up 20140616132153 Create targets up 20140616132456 Create campaigns up 20140617140018 Add checkboxes for splash components to conference up 20140617141918 Add include cfp in splash to call for papers up 20140617145048 Add venue checkboxes to venue up 20140620130306 Add banner photo to conference up 20140620134535 Add include banner in splash to conference up 20140623100942 Create visits up 20140623101032 Create ahoy events up 20140623150541 Drop person and event person tables up 20140625112608 Add week to event up 20140625114813 Add week to registration up 20140627165718 Add instagram url to conference up 20140701123203 Add events per week to conference up 20140707120158 Add conference dates updates to email settings up 20140710130608 Add conference registration dates updates to email settings up 20140711072651 Add description and resource to roles up 20140711113037 Add venue update to email settings up 20140714141156 Add volunteer fields to user up 20140716115448 Add default value to email settings up 20140718103856 Add is admin to users up 20140719160903 Create delayed jobs up 20140724113107 Add call for papers updates to email settings up 20140724153520 Create subscriptions up 20140730104658 Migrate roles for cancancan up 20140731153332 Create contacts up 20140731165107 Move conference contact details to contact up 20140801103645 Create commercials up 20140801164901 Move conference media to commercial up 20140801170430 Move event media to commercial up 20140804185823 Create registration periods up 20140812065531 Move conference registration data to registration periods up 20140819124315 Rename supporter level to ticket up 20140820093735 Migrating supporter registrations to ticket users up 20140820123503 Assign users to events up 20140820124117 Undo wrong migration20140801080705 add users to events up 20140821103643 Split ticket price in price and currency up 20140825091222 Create splashpages up 20140825093132 Move splashpage attributes from conference to splashpage up 20140930092923 Move sponsor email to contact up 20141031225545 Add require handicapped access to questions up 20141031225606 Add attending with partner to questions up 20141031225620 Add staying at suggested hotel to questions up 20141031225635 Add attending social events to questions up 20141103132913 Add username to users up 20141104131625 Generate username up 20141106141750 Add is disabled flag to user up 20141109172204 Set room public default to false up 20141113134103 Add position to sponsorship level up 20141117214230 Move banner description to conference up 20141117222919 Drop splash descriptions and photo up 20141118143700 Add address fields to venue up 20141118150427 Cleanup venue up 20141118153918 Change venue conference association up 20141118162030 Change lodging association to conference up 20141120205757 Remove public from room up 20141121102656 Remove description from call for paper up 20141127161313 Add is highlight in events up 20141128073306 Migrate data remove column include cfp in splash add column include cfp up 20141130182139 Drop table event attachments up 20150304135935 Add created atto qanswer up 20150415121038 Add description to event type up 20150417050953 Add url to commercial up 20150929142405 Change postalcode format in venues up 20151005161518 Rename templates in email settings up 20151018152439 Create programs table up 20151018154513 Rename conference id to program id in events tracks difficulty levels up 20151021113015 Rename email settings with cfp and program up 20151031092713 Change conference id to venue id in rooms up 20160201221411 Add registration limit to conferences up 20160226133808 Rename roles users to users roles up 20160309182642 Remove social events table up 20160309182655 Remove dietary choices table up 20160309183052 Remove html export path from conferences up 20160320220630 Add languages to program up 20160323154504 Add max attendees to events up 20160326075326 Add attended to events registrations up 20160403214841 Add id and created at to events registrations up 20160427101444 Remove photos up 20160427104236 Add pictures up 20160427104237 Add blind voting to programs up 20160427104238 Add voting dates to program up 20160501201606 Add show by default to splashpage up 20160508201501 Add banner to splashpage up 20160512035046 Add banner attribution to splashpage up 20160524050538 Add conference id to versions up 20160524104006 Remove unused logo columns and use difficulty levels from conferences up 20160524104501 Remove unused logo columns from sponsors up 20160524104805 Remove logo and progress and time slots from events up 20160606040848 Create payments up 20160610073948 Add payment id to ticket purchases up 20160614145614 Add id to users roles up 20160624151257 Remove unused photo columns from venues down 20160627122446 Create surveys down 20160628093634 Create survey questions down 20160629145954 Add target to surveys down 20160630094850 Create survey replies down 20160630130731 Create survey submissions up 20160704091928 Create schedules up 20160704092023 Create event schedules up 20160815094215 Add times to conferences up 20160815140302 Add index to event schedule down 20161229080315 Add comments count to events down 20170108053041 Add default to revision in conference up 20170129075434 Create resources table down 20170212145523 Add enabled to event schedules up 20170213145807 Change email public from users up 20170302145716 Add schedule interval to programs up 20170419132148 Add week to ticket purchases down 20170516190048 Create booths up 20170529215453 Create organizations down 20170530072155 Add type to cfps down 20170530112510 Create booth requests up 20170531094819 Move conferences to organizations down 20170603095900 Create physical tickets up 20170613224853 ********** NO FILE ********** up 20170614025428 ********** NO FILE ********** down 20170629162450 Add short name to tracks down 20170629232817 Add ticket layout to conferences down 20170705075039 Add state cfp active and submitter reference to tracks down 20170711102511 Create ticket scannings down 20170712120556 Add room and dates to tracks down 20170715131706 Make track state not null and add default value down 20170720134353 Make track cfp active not null down 20170721001700 Add index to physical tickets down 20170721184810 Add custom domain to conferences down 20170726065629 Add relevance to tracks down 20170727081731 Add include booths to splashpages down 20170728182033 Add booth limit to conferences down 20170731161207 Add booths to email settings down 20170807092805 Add registration ticket to tickets down 20170809120927 Add track reference to schedule down 20170814174637 Add selected schedule to tracks down 20170905110034 Add description to cfps down 20170924190528 Add amount paid to ticket purchases down 20171118113113 Change visit id type of ahoy events to integer down 20171130172334 Rebuild conference pictures down 20171201163628 Add mastodon to contact down 20180226032958 Add created at and updated at to event types down 20180312100045 Create ahoy visits and events down 20180313012253 Add timestamps to tickets down 20180316185150 Add code of conduct to organization down 20180316220446 Add accepted code of conduct to registrations up 20180522011758 ********** NO FILE ********** down 20180822125509 Add submitted proposal attributes in email settings down 20180924221715 User email public defaults to false down 20181009000259 Drop ahoy events down 20181017183243 Add allow reservations on cfps down 20181113195810 Add youtube and blog to contacts down 20181229233811 Remove arrival departure from registrations down 20200331214534 Add organization to versions down 20200525194219 Use organization up 20200710065434 ********** NO FILE ********** down 20220312000831 Convert proposal questions to surveys down 20220401000955 Add send on event comment to email settings Not updating versions of deleted event... Not updating versions of deleted event... Not updating versions of deleted event... Not updating versions of deleted event... Not updating versions of deleted event... Not updating versions of deleted event... Not updating versions of deleted event... Not updating versions of deleted event... All done! + rake db:migrate:down VERSION=20160512035046 I, [2022-06-17T02:10:59.467305 #209] INFO -- : [SKYLIGHT] [5.1.1] Unable to start, see the Skylight logs for more details I, [2022-06-17T02:11:00.239580 #209] INFO -- : Migrating to AddBannerAttributionToSplashpage (20160512035046) rake aborted! NameError: uninitialized constant AddBannerAttributionToSplashpage Object.const_get(camel_cased_word) ^^^^^^^^^^ /app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.1/lib/active_support/inflector/methods.rb:280:in `constantize' /app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.1/lib/active_support/core_ext/string/inflections.rb:74:in `constantize' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/migration.rb:1056:in `load_migration' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/migration.rb:1049:in `migration' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/migration.rb:1045:in `disable_ddl_transaction' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/migration.rb:1417:in `use_transaction?' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/migration.rb:1364:in `rescue in execute_migration_in_transaction' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/migration.rb:1352:in `execute_migration_in_transaction' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/migration.rb:1320:in `run_without_lock' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/migration.rb:1273:in `block in run' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/migration.rb:1431:in `block in with_advisory_lock' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:215:in `with_connection' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/migration.rb:1446:in `with_advisory_lock_connection' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/migration.rb:1427:in `with_advisory_lock' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/migration.rb:1273:in `run' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/migration.rb:1130:in `run' /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.1/lib/active_record/railties/databases.rake:229:in `block (3 levels) in$ dokku run osem bin/postdeploy