• Discovering and recovering from PostgreSQL corruption on Matrix.org

    From LWN.net@1337:1/100 to All on Wed Jul 23 19:00:08 2025
    Discovering and recovering from PostgreSQL corruption on Matrix.org

    Date:
    Wed, 23 Jul 2025 17:46:28 +0000

    Description:
    Richard van der Hoff, a member of the team that runs the Matrix.org
    homeserver ,
    has written a detailed blog post about diagnosing and fixing a problem where Matrix rooms
    would simply stop working : We know that there are plenty of users out there who will have been
    affected by the problem, and found themselves unable to communicate as
    a result. We very much share your frustration, and we'd like to
    apologise for the disruption to service. With that said, we're glad that we were able to get to the bottom
    of most of the problem, and get the lost data restored within a
    relatively short time. If nothing else, hopefully this blog post will
    be of use to future generations faced with Postgres index
    corruption!

    ======================================================================
    Link to news story:
    https://lwn.net/Articles/1031148/


    --- Mystic BBS v1.12 A47 (Linux/64)
    * Origin: tqwNet UK HUB @ hub.uk.erb.pw (1337:1/100)