Conversation

Notices

1. Embed this notice
   Alex Gleason (alex@gleasonator.com)'s status on Thursday, 08-Sep-2022 01:06:12 JST Alex Gleason

   in reply to

   • Your New Marijuana Injecting Waifu :weed:
   • Haelwenn /элвэн/ :triskell:
   • anime graf mays ?️?
   • ew
   • 
   • Alex Gleason
   • sjw
   I found the source of the problem, now just figuring out how to fix: https://gitlab.com/soapbox-pub/rebased/-/merge_requests/178#note_1091475363
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Thursday, 08-Sep-2022 01:06:13 JST Alex Gleason

     in reply to

     • Your New Marijuana Injecting Waifu :weed:
     • Haelwenn /элвэн/ :triskell:
     • anime graf mays ?️?
     • ew
     • 
     • sjw
     You don't think there's anything wrong with this migration itself? https://git.pleroma.social/pleroma/pleroma/-/merge_requests/3692/diffs Because I think the fix is to revert it. Did you also upgrade your server to this?
   • Embed this notice
     ew (e@masochi.st)'s status on Thursday, 08-Sep-2022 01:06:18 JST ew

     • Your New Marijuana Injecting Waifu :weed:
     • Haelwenn /элвэн/ :triskell:
     • anime graf mays ?️?
     • 
     • sjw
     @mint @sjw @alex @graf @sjw @lanodan what I believe is happening, at least in Alex's situation, is that they used a new index signature for a very common query, but that index isn't complete but it's still being used, so it has to do a full table scan without an index each time instead of using the old index, and that full table scan is blocking the index from being built.