Conversation

Notices

1. Embed this notice
    (mint@ryona.agency)'s status on Saturday, 06-Jul-2024 23:16:33 JST 

   • Cocoa Hoto in real life
   @Cocoa Migrating to upstream shouldn't be too hard, just need to make a DB backup, revert some migrations (./bin/pleroma_ctl database rollback should do the trick, though I haven't tried it), possibly drop settings from DB config (which you shouldn't use anyway on singleuser instances), then clone the new repo and set it up as usual barring the config.exs changes.
   • ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     Cocoa Hoto in real life (cocoa@nekosat.work)'s status on Saturday, 06-Jul-2024 23:29:47 JST Cocoa Hoto in real life

     in reply to
     @mint sounds easy compared to what I had to go through trying to migrate Foundkey to Misskey. Thank you friend
      likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Saturday, 06-Jul-2024 23:31:04 JST 

     in reply to

     • Cocoa Hoto in real life
     @Cocoa https://ryona.agency/objects/9cef1607-e812-4c01-bbe1-6b9a2c231309
     Here's the diff, migrations that start with the minus are those from Rebased. You should start from the last one.
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Sunday, 07-Jul-2024 00:21:58 JST pistolero

     in reply to

     • Cocoa Hoto in real life
     @mint @Cocoa
     
     > just need to make a DB backup, revert some migrations (./bin/pleroma_ctl database rollback should do the trick,
     
     It is extremely important to note that you have to roll back using the old codebase.
      and ✙ dcc :pedomustdie: :phear_slackware: like this.
   • Embed this notice
      (mint@ryona.agency)'s status on Sunday, 07-Jul-2024 00:22:40 JST 

     in reply to

     • Cocoa Hoto in real life
     • pistolero
     @p @Cocoa Yeah, I said "then clone the new repo" after reverting migrations.
   • Embed this notice
      (mint@ryona.agency)'s status on Sunday, 07-Jul-2024 00:25:47 JST 

     in reply to

     • Cocoa Hoto in real life
     • pistolero
     @p @Cocoa I might make a more detailed instruction a little later.
     Fish of Rage likes this.
     ✙ dcc :pedomustdie: :phear_slackware: repeated this.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Sunday, 07-Jul-2024 00:52:15 JST pistolero

     in reply to

     • Cocoa Hoto in real life
     @mint @Cocoa This would be cool, definitely.
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Sunday, 07-Jul-2024 01:13:06 JST 

     in reply to

     • m0xEE
     • Cocoa Hoto in real life
     @m0xee @Cocoa Buggy and adds unnecessary complexity. I don't even use it on multiuser instances, but some might want to avoid those 15 seconds of downtime to not inconvenience other users.
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     m0xEE (m0xee@social.librem.one)'s status on Sunday, 07-Jul-2024 01:13:07 JST m0xEE

     in reply to

     • Cocoa Hoto in real life

     @mint
     > which you shouldn't use anyway on singleuser instances
     Why?

     @Cocoa

   • Embed this notice
      (mint@ryona.agency)'s status on Sunday, 07-Jul-2024 01:17:45 JST 

     in reply to

     • m0xEE
     • pomstan
     • Cocoa Hoto in real life
     @pomstan @Cocoa @m0xee I don't have the strongest hardware out there, so it is what it is. Fromsourcekeks might wait longer, though, since it's doing a bunch of dependency checks before launching; I've been rolling my own OTP releases since I first started agency.
   • Embed this notice
     pomstan (pomstan@xn--p1abe3d.xn--80asehdb)'s status on Sunday, 07-Jul-2024 01:17:46 JST pomstan

     in reply to

     • m0xEE
     • Cocoa Hoto in real life

     @mint @Cocoa @m0xee

     15 seconds of downtime

     lolwhat

     is it really that bad

   • Embed this notice
     ✙ dcc :pedomustdie: :phear_slackware: (dcc@annihilation.social)'s status on Sunday, 07-Jul-2024 01:19:06 JST ✙ dcc :pedomustdie: :phear_slackware:

     in reply to

     • m0xEE
     • pomstan
     • Cocoa Hoto in real life
     @pomstan @Cocoa @mint @m0xee Well start up always take at least 10 second
   • Embed this notice
     Phantasm (phnt@fluffytail.org)'s status on Sunday, 07-Jul-2024 01:33:43 JST Phantasm

     in reply to

     • m0xEE
     • Cocoa Hoto in real life
     @mint @Cocoa @m0xee That reminds me. I need to find the API call AdminFE does so I can reload the config from IEx.
      likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Sunday, 07-Jul-2024 01:41:59 JST 

     in reply to

     • Cocoa Hoto in real life
     • pistolero
     @p @Cocoa And here's the first hurdle, a non-recoverable migration. Thankfully it's trivial (only adds a single column), so it can be reversed manually after being done with all other migrations.
     Screenshot_20240706_193831.png
   • Embed this notice
     Fish of Rage (sun@shitposter.world)'s status on Sunday, 07-Jul-2024 01:59:27 JST Fish of Rage

     in reply to

     • Cocoa Hoto in real life
     • pistolero
     @p @Cocoa @mint if you do manual sql ddl or data operation, the change isn't reversible
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Sunday, 07-Jul-2024 01:59:28 JST pistolero

     in reply to

     • Cocoa Hoto in real life
     @Cocoa @mint That's fuckin' rough. But a migration like that should be trivial to write a `down` for; maybe a patch would be better, but you wonder, like, why would there not be a `down`?
   • Embed this notice
      (mint@ryona.agency)'s status on Sunday, 07-Jul-2024 02:03:12 JST 

     in reply to

     • Cocoa Hoto in real life
     • pistolero
     @p @Cocoa There's the exact same kind of migration except with more arguments that got successfully reverted without down.
     https://gitlab.com/soapbox-pub/rebased/-/blob/main/priv/repo/migrations/20210612185407_add_email_list_field_to_users.exs?ref_type=heads
     https://gitlab.com/soapbox-pub/rebased/-/blob/main/priv/repo/migrations/20220314220000_add_location_to_users.exs?ref_type=heads
     Probably some Elixir fuckery. Regardless, getting rid of the other column takes a single command as well.
   • Embed this notice
      (mint@ryona.agency)'s status on Sunday, 07-Jul-2024 02:07:49 JST 

     in reply to

     • Cocoa Hoto in real life
     • pistolero
     @Cocoa @p Alright, tested the process out on a VM with rebased that has like one user and three posts. I'm gonna assume you followed instructions on https://soapbox.pub/install/ during initial installation (which for whatever reason make you use some third-party package manager for Erlang/Elixir, which I think should work with base Pleroma). If not, you should already know whether something should be adjusted.
     1. Stop pleromer (`systemctl stop pleroma` or whatever other init system you use)
     2. Log in as pleroma user (`sudo -Hu pleroma bash`) and enter /opt/pleroma
     3. Rollback vegan-specific migrations by executing following commands in that order:
     MIX_ENV=prod mix pleroma.database rollback 20221207235104
     MIX_ENV=prod mix pleroma.database rollback 20221029171353
     MIX_ENV=prod mix pleroma.database rollback 20220927220033
     MIX_ENV=prod mix pleroma.database rollback 20220819171321
     MIX_ENV=prod mix pleroma.database rollback 20220624104914
     MIX_ENV=prod mix pleroma.database rollback 20220225164000
     MIX_ENV=prod mix pleroma.database rollback 20210612185407
     4. Exit pleroma user (`exit`) and drop the column that can't be rolled back with mix: `sudo -Hu postgres psql pleroma -c "alter table users drop column location;"`
     5. Go back to /opt, rename /opt/pleroma into something else (e.g. `mv /opt/pleroma /opt/glussy`), then clone upstream repo (`git clone https://git.pleroma.social/pleroma/pleroma`)
     6. Copy config/prod.secret.exs from old directory to new.
     7. Log back in as pleroma user, go to /opt/pleroma and run the following to compile the new version and migrate the DB
     mix local.hex --force
     mix local.rebar --force
     mix deps.get
     MIX_ENV=prod mix compile
     MIX_ENV=prod mix ecto.migrate
     8. After all that's done, log out and restart pleromer (`systemctl start pleroma`). If there are no invalid config entries, it should work out of box. If not, stop pleromer and try running it manually (`sudo -Hu pleroma MIX_ENV=prod mix phx.server`) then tell me what the error is. Worst case scenario, you'd have to remove DB configs (`TRUNCATE TABLE config`) and reconfigure it manually.
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Sunday, 07-Jul-2024 02:10:04 JST 

     in reply to

     • Cocoa Hoto in real life
     • pistolero
     @Cocoa @p Switch to OTP if desired can be done with official instructions after following steps 1-4 from mine.
     https://docs.pleroma.social/backend/installation/migrating_from_source_otp_en/
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Sunday, 07-Jul-2024 02:29:11 JST pistolero

     in reply to

     • Cocoa Hoto in real life
     • Fish of Rage
     @sun @Cocoa @mint Yeah, this one just uses their migration DSL and adds a column; it should be trivially reversible.
     Fish of Rage likes this.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Sunday, 07-Jul-2024 02:34:38 JST pistolero

     in reply to

     • Cocoa Hoto in real life
     @mint @Cocoa It'd be something Ecto does. So just setting `default: false` makes it reversible? That's fuckin' weird.
      likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Sunday, 07-Jul-2024 02:50:37 JST 

     in reply to

     • m0xEE
     • Cocoa Hoto in real life
     • pistolero

     @m0xee @p @Cocoa Compared to ackoma, it is fairly minor, with most changes being either adding fields that no one would use or making some index for certain activity type.

     $ diff -uar <(ls -1 ackoma/priv/repo/migrations) <(ls -1 pleroma/priv/repo/migrations) --- /proc/self/fd/11 2024-07-06 20:48:25.221400761 +0300 +++ /proc/self/fd/12 2024-07-06 20:48:25.221400761 +0300 @@ -272,6 +272,7 @@ 20210222183840_remove_hashtags_objects_duplicate_index.exs 20210222184616_change_hashtags_name_to_text.exs 20210401143153_user_notification_settings_fix.exs +20210416051708_remove_mastofe_settings_from_users.exs 20210420204354_delete_hashtags_objects_cascade.exs 20210717000000_add_poll_to_notifications_enum.exs 20210818023112_add_user_id_to_apps.exs @@ -281,32 +282,36 @@ 20211222165256_add_last_status_at_to_users.exs 20211225154802_add_is_discoverable_index_to_users.exs 20211229075801_user_relationships_target_id_relationship_type_index.exs -20220108213213_add_mastofe_settings.exs +20220116183110_add_birthday_to_users.exs +20220125104429_add_birthday_month_day_index_to_users.exs +20220203224011_create_rules.exs 20220220135625_upload_filter_exiftool_to_exiftool_strip_location.exs 20220302013920_add_language_to_users.exs 20220308012601_create_announcements.exs +20220319000000_add_status_to_notifications_enum.exs 20220506175506_add_index_hotspots.exs 20220509180452_change_thread_visibility_to_be_local_only_aware.exs +20220527134341_add_quote_url_index_to_objects.exs +20220602052233_change_report_notes_content_to_text.exs 20220605185734_add_update_to_notifications_enum.exs -20220718102634_upgrade_oban_to_v11.exs -20220805123645_remove_remote_cancelled_follow_requests.exs -20220831170605_remove_local_cancelled_follows.exs +20220616163503_add_expires_at_to_user_relationships.exs +20220711182322_add_associated_object_id_function.exs +20220711192750_switch_to_associated_object_id_index.exs +20220807125023_data_migration_delete_context_objects.exs +20220821004840_change_thread_visibility_to_use_new_object_id_index.exs 20220905011454_generate_unset_user_keys.exs -20220911195347_add_user_frontend_profiles.exs -20220916115149_ensure_mastofe_settings.exs -20221020135943_add_nodeinfo.exs -20221123221956_add_has_request_signatures.exs -20221128103145_add_per_user_post_expiry.exs -20221129105331_add_notification_activity_id_index.exs -20221129110627_add_bookmarks_activity_id_index.exs -20221129110727_add_report_notes_activity_id_index.exs -20221129112022_add_cascade_to_report_notes_on_activity_delete.exs -20221203232118_add_user_follows_hashtag.exs -20221211234352_remove_unused_indices.exs -20230127143303_rename_index_users_ap_id_coalesce_follower_address_index.exs -20230522213837_add_unfollowed_dm_restrictions.exs +20221103014611_create_oban_peers.exs +20221103014728_swap_primary_oban_indexes.exs +20221111164213_deprecate_quack.exs +20221216052127_add_state_to_backups.exs +20230306112859_instances_add_metadata.exs +20230422154018_drop_unused_indexes.exs +20230504173400_remove_user_ap_enabled.exs +20231107200724_consolidate_email_queues.exs 20240207035927_create_rich_media_card.exs -20240210000000_drop_chat_tables.exs -20240213120000_add_permit_followback.exs -20240425120000_upload_filter_exiftool_to_exiftool_strip_location_real.exs -20240501190000_drop_unused_indexes.exs +20240223165000_create_bookmark_folders.exs +20240406000000_add_hint_to_rules.exs +20240527144418_oban_queues_refactor.exs +20240530011739_add_missing_foreign_keys.exs +20240608003957_upgrade_oban_jobs_to_v12.exs +20240619141319_deprecate_config_db_logger.exs
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     m0xEE (m0xee@social.librem.one)'s status on Sunday, 07-Jul-2024 02:50:38 JST m0xEE

     in reply to

     • Cocoa Hoto in real life
     • pistolero

     @mint @p @Cocoa @mint
     Wow, that is an impressive number of rollbacks! Were there so many breaking changes to the data structures in Rebased? 🤔
     I was always thinking that it should be pretty minor and that most changes were on the frontend side 😆

     ✙ dcc :pedomustdie: :phear_slackware: repeated this.
   • Embed this notice
     m0xEE (m0xee@social.librem.one)'s status on Sunday, 07-Jul-2024 02:56:21 JST m0xEE

     in reply to

     • Cocoa Hoto in real life
     • pistolero

     @mint @p @Cocoa
     Adding an index for bookmarks looks like a good idea though.
     Maybe few use them, but I do and I can clearly hear cogs turning with audible screeches in my Pelonmer when I switch to that tab 😂

      likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Sunday, 07-Jul-2024 02:56:56 JST 

     in reply to

     • m0xEE
     • Cocoa Hoto in real life
     • pistolero
     @m0xee @p @Cocoa Same. Backporting it might be a good idea, yeah.
   • Embed this notice
     J上校👮🇺🇦🏳️‍⚧️ (colonelj@bae.st)'s status on Sunday, 07-Jul-2024 02:59:47 JST J上校👮🇺🇦🏳️‍⚧️

     in reply to

     • m0xEE
     • Pawlicker
     • Cocoa Hoto in real life
     • pistolero
     @PurpCat @p @Cocoa @mint @m0xee gleason is on the flight logs
      likes this.
   • Embed this notice
     Pawlicker (purpcat@clubcyberia.co)'s status on Sunday, 07-Jul-2024 02:59:48 JST Pawlicker

     in reply to

     • m0xEE
     • Cocoa Hoto in real life
     • pistolero
     @p @Cocoa @mint @m0xee "don't trust this man"
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Sunday, 07-Jul-2024 02:59:49 JST pistolero

     in reply to

     • m0xEE
     • Cocoa Hoto in real life
     @m0xee @mint @Cocoa They wanted stuff like birthdays, mailing lists, locations. You know, because Twitter has those fields.
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
     ✙ dcc :pedomustdie: :phear_slackware: repeated this.
   • Embed this notice
     ✙ dcc :pedomustdie: :phear_slackware: (dcc@annihilation.social)'s status on Sunday, 07-Jul-2024 05:36:52 JST ✙ dcc :pedomustdie: :phear_slackware:

     in reply to

     • m0xEE
     • Cocoa Hoto in real life
     • pistolero
     @mint @p @Cocoa @m0xee "ackoma is no different than pleroma"
     .....
   • Embed this notice
     feld (feld@bikeshed.party)'s status on Tuesday, 30-Jul-2024 08:28:19 JST feld

     in reply to

     • Cocoa Hoto in real life
     • pistolero
     @mint @p @Cocoa you can also use a mix command to clear the DB config or write it to a file that you could use going forward
     
     https://docs-develop.pleroma.social/backend/administration/CLI_tasks/config/
      likes this.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Tuesday, 30-Jul-2024 08:33:03 JST pistolero

     in reply to

     • feld
     • Cocoa Hoto in real life
     @feld @mint @Cocoa This is about the difference in schema between soybox and real Pleroma.
      likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 30-Jul-2024 08:34:18 JST 

     in reply to

     • feld
     • Cocoa Hoto in real life
     • pistolero
     @p @feld @Cocoa Yeah, but Cocoa also reported about having to wipe DB configs at one point when migrating. Pleroma is pretty frail when it comes to that.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Tuesday, 30-Jul-2024 08:36:19 JST pistolero

     in reply to

     • feld
     • Cocoa Hoto in real life
     @mint @Cocoa @feld I don't know of a real-world application that can stand conflicting schema versions very well, but there have been some things that were senselessly renamed.
      likes this.