Conversation

Notices

1. Embed this notice
   Pete Zaitcev (zaitcev@shitposter.world)'s status on Thursday, 20-Jun-2024 00:39:56 JST Pete Zaitcev
   My Postgres says
   
   "HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE pleroma REFRESH COLLATION VERSION, or build PostgreSQL with the right library version."
   
   How do I "rebuild all objects in this database"? I have no clue.
   • Embed this notice
     Sick Sun (sun@shitposter.world)'s status on Thursday, 20-Jun-2024 00:39:56 JST Sick Sun

     in reply to
     @zaitcev mine did this recently too, what is going on
   • Embed this notice
     Sick Sun (sun@shitposter.world)'s status on Thursday, 20-Jun-2024 03:20:55 JST Sick Sun

     in reply to
     @zaitcev I knew how to fix it I just don't understand why it changed
   • Embed this notice
     Pete Zaitcev (zaitcev@shitposter.world)'s status on Thursday, 20-Jun-2024 03:20:56 JST Pete Zaitcev

     in reply to

     • Sick Sun
     @sun The docs say:
     "When this happens, all objects depending on the collation should be rebuilt, for example, using REINDEX."
     https://www.postgresql.org/docs/current/sql-altercollation.html#SQL-ALTERCOLLATION-NOTES
     I'm running reindexdb -a right now, to see if anything changes.
   • Embed this notice
     Sick Sun (sun@shitposter.world)'s status on Thursday, 20-Jun-2024 03:38:00 JST Sick Sun

     in reply to

     • feld
     @feld @zaitcev I knew the first time it happened it was because of glibc but I thought it would only do it for major versions, guess not haha
   • Embed this notice
     feld (feld@bikeshed.party)'s status on Thursday, 20-Jun-2024 03:38:01 JST feld

     in reply to

     • Sick Sun
     @sun @zaitcev Linux, lol
     
     Your glibc updated from 2.36 to 2.37
     
     This was probably considered a noop by your distro maintainers but Postgres says HELL THE FUCK NO IT IS NOT
     Sick Sun likes this.
   • Embed this notice
     Sick Sun (sun@shitposter.world)'s status on Thursday, 20-Jun-2024 04:03:20 JST Sick Sun

     in reply to

     • feld
     • prettygood
     @prettygood @feld @zaitcev my server is ubuntu
   • Embed this notice
     prettygood (prettygood@socially.drinkingatmy.computer)'s status on Thursday, 20-Jun-2024 04:03:21 JST prettygood

     in reply to

     • feld
     • Sick Sun
     @feld @sun @zaitcev what distro does this? I run gentoo building glibc from source and I never have this kind of thing happen.