GNU social JP
  • FAQ
  • Login
GNU social JPは日本のGNU socialサーバーです。
Usage/ToS/admin/test/Pleroma FE

  • Public

    • Public
    • Network
    • Groups
    • Featured
    • Popular
    • People

Notices by Иоанн Павел Грипс (grips@eientei.org)

  1. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Saturday, 26-Apr-2025 01:10:13 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Phantasm
    @phnt
    >Not sure about the "I just restored all the DB files from a backup I made at the start of the maintenance" part, since if it was a simple tar/whatever based backup, all the bloat in the files is still there.
    yeah I just rsync it to a directory on the slab. there might be a lot of cruft :013_thumbs_up:

    >If you don't have enough disk space for a full vacuum of the database (in your case probably around 1.7x of the current size of the DB),
    I already worked around this in the past. move everything to the slab and vacuum the tables one by one

    >If the number of activities is still the same, it probably didn't even resolve the ones to delete yet.
    I'm afraid that is the case and I've waited for naught. the reads and writes, incl. slab, have probably misled me

    >I just use \l+ in psql for size of databases and \dt+ and \di+ for table and index sizes respectively since it's a quick and dirty command.
    cool, I didn't know. thanks! :013_thumbs_up:
    In conversation about 2 days ago from eientei.org permalink

    Attachments


    1. https://eientei.org/media/08/6a/4f/086a4feda2e2862da337c66df87acd63c7e9b82f177d287541c2e323da25167d.png?name=image.png
  2. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Friday, 25-Apr-2025 22:49:22 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Phantasm
    • Иоанн Павел Грипс

    @phnt part 2 because greentexts and Markdown don't mix

    as for the sizes, this is what I run for checks. afaik it doesn't include indexes and a lot of other stuff, that would reqiure a deep dive in itself. but it is possible that some of it is residuals from failed vacuums, as you suggest

    pleroma=# select table_name, pg_relation_size(quote_ident(table_name)), pg_size_pretty(pg_relation_size(quote_ident(table_name))) from information_schema.tables where table_schema = 'public' order by 2; table_name | pg_relation_size | pg_size_pretty --------------------------------------------+------------------+---------------- [HEAVILY TRUNCATED] oban_jobs | 16965632 | 16 MB hashtags | 41992192 | 40 MB notifications | 150986752 | 144 MB rich_media_card | 267968512 | 256 MB hashtags_objects | 375283712 | 358 MB oauth_authorizations | 417202176 | 398 MB oauth_tokens | 478543872 | 456 MB apps | 546037760 | 521 MB counter_cache | 631070720 | 602 MB users | 1308614656 | 1248 MB deliveries | 1825726464 | 1741 MB objects | 71694196736 | 67 GB activities | 91074977792 | 85 GB (47 rows)
    In conversation about 2 days ago from eientei.org permalink
  3. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Friday, 25-Apr-2025 22:05:25 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Phantasm
    @phnt you're awakening my graphomania right now. my inner @p. I'm loving it

    > I'm a bit surprised cawfee didn't fall over often because of it.
    not everything was on the slab, I deliberately keep about 5-10 of the last 1GB files from both objects and activities on the main drive at all times. there were noticeable slowdowns when querying older data, and of course occasional errors were always there, but in the grand scheme of things shit just ran

    > Just out of curiosity, did Postgres crash when it ran out of disk space,
    yes, there was about 2GB free and that quickly filled up. even after moving most of the DB to the slab and running the prune again, it quickly ate a lot of space and then rebounded (fig. 1)
    >A crash would make it not reclaim the disk space lost by the failed vacuum full on crash recovery. You can't get rid of those files without doing a pg_dump, dropping the full database(s) and restoring it from scratch.
    yeah, when this happened, I just restored all the DB files from a backup I made at the start of the maintenance. they're not retained, at least from this failure. but it might have happened earlier

    > You can't get rid of those files without doing a pg_dump, dropping the full database(s) and restoring it from scratch.
    the last time I used pg_restore was in 2021 and it took three days (https://info.cawfee.club/soti-2021-09.html)

    > I don't know if cancelling the query is a good option, since it has the potential to cause the infamous pruned DB meme.
    yeah, I don't think killing the query would be wise - but what to do? at the moment, what seems like the best approach to me is just `systemctl restart postgres-12`, which would cancel the query without wrecking the WAL and other things. am I mistaken?

    funnily enough the mix process is dead but the query keeps running. I expected it to finish over the maintenance weekend and forgot to run it in tmux, and when it was time to go to work on Monday, I tried to disown the process and reattach it to tmux, which failed (multithreaded process or something, maybe I just fucked it up) but the query keeps running, as pg_stat_activity and disk graphs show. I'm not entirely certain about what's actually happening, as `SELECT count(*) FROM public.activities;` keeps giving me 105514556, same as when I first tried running it hours ago
    In conversation about 2 days ago from eientei.org permalink

    Attachments


    1. https://eientei.org/media/79/40/8a/79408ac28ce42d197db4b7547161c06742f97a860978078ebf964bb5cd487b13.png?name=image.png
    2. Domain not in remote thumbnail source whitelist: info.cawfee.club
      State of the Instance (September 2021)
  4. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Friday, 25-Apr-2025 21:03:25 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Phantasm
    @phnt the IOPS cap is news to me. it explains a lot

    >How big is the DB?
    right now, before vacuum/repack, the entire folder weighs 267GB. I did not help myself by offloading 251GB of that to the slab, the first pruning attempt ran out of disk space so I freed up as much as I could. at least for vacuuming it will be nice to have that free space
    (objects are 67GB, activities 85GB)
    In conversation about 2 days ago from eientei.org permalink
  5. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Friday, 25-Apr-2025 19:32:44 JST Иоанн Павел Грипс Иоанн Павел Грипс

    starting to feel like a fucking failure

    I think I'll try to safely terminate the query. I'm not a database expert but that triple left join looks inefficient as hell, especially when

    pleroma=# SELECT count(*) FROM public.activities; count ----------- 105514556 (1 row)

    I hope it was actually deleting rows all along and not just calculating what to delete. that would mean 13 wasted days

    In conversation about 2 days ago from eientei.org permalink

    Attachments


    1. https://eientei.org/media/05/48/8c/05488ccdda689d4b5b3a2a85b59ec9607131cbe1d3ebfc33e40fc03ae71fe5bf.png?name=image.png
  6. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Wednesday, 23-Apr-2025 07:37:00 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Phantasm
    @phnt >tranubis
    :niggablobthumbsup:
    In conversation about 5 days ago from eientei.org permalink
  7. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Tuesday, 22-Apr-2025 19:43:03 JST Иоанн Павел Грипс Иоанн Павел Грипс
    achievement unlocked: 100 hours of CPU time on a process
    In conversation about 5 days ago from eientei.org permalink

    Attachments


    1. https://eientei.org/media/bf/9e/bc/bf9ebc615e5541be5726eec0dc3c9a272eacce060a7c99c832f4aa0787da50c5.png?name=image.png
  8. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Tuesday, 22-Apr-2025 18:42:32 JST Иоанн Павел Грипс Иоанн Павел Грипс
    >After Menachem Begin became Prime Minister in 1977 the preparations intensified; Begin authorized the building of a full-scale model of the Iraqi reactor which Israeli pilots could practice bombing. Three Israeli pilots died in accidents while training for the mission.
    In conversation about 5 days ago from eientei.org permalink
  9. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Tuesday, 22-Apr-2025 06:03:34 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Lina Inver?e
    • ur angle, or ur devil.....
    • Richard Carroll
    @Cheshire_Ocelot @lina @ligma_male that's smart
    In conversation about 6 days ago from eientei.org permalink
  10. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Tuesday, 22-Apr-2025 06:03:32 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Lina Inver?e
    • ur angle, or ur devil.....
    • Richard Carroll
    @Cheshire_Ocelot @lina @ligma_male >implying
    In conversation about 6 days ago from eientei.org permalink
  11. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Monday, 21-Apr-2025 20:34:51 JST Иоанн Павел Грипс Иоанн Павел Грипс
    it's funny, all of my server maintenance knowledge comes from tard wrangling Cawfee but if I ever list the skills in my CV, I can't say where I got them
    maybe I could get away by saying it's confidential or behind an NDA
    In conversation about 6 days ago from eientei.org permalink
  12. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Monday, 21-Apr-2025 20:17:20 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • ur angle, or ur devil.....
    @ligma_male okay, new meta: Cawfee will be back before we have a pope
    In conversation about 6 days ago from eientei.org permalink
  13. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Monday, 21-Apr-2025 20:17:17 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • ur angle, or ur devil.....
    @ligma_male if it doesn't take a month?
    In conversation about 6 days ago from eientei.org permalink
  14. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Monday, 21-Apr-2025 15:35:12 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Phantasm
    @phnt jeden husk dva husky
    In conversation about 6 days ago from eientei.org permalink
  15. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Monday, 21-Apr-2025 13:04:26 JST Иоанн Павел Грипс Иоанн Павел Грипс
    ONE LIKE AND I NUKE CAWFEE
    In conversation about 6 days ago from eientei.org permalink
  16. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Monday, 21-Apr-2025 13:04:25 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Иоанн Павел Грипс
    WOW NIGGA THAT'S NUTS
    In conversation about 6 days ago from eientei.org permalink

    Attachments


    1. https://eientei.org/media/00/3a/95/003a95711164da5e74495d8f93968f77111dc3f549a99801c4982b77932f38e1.png?name=image.png
  17. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Saturday, 19-Apr-2025 22:03:58 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • waifu
    @waifu
    In conversation about 8 days ago from eientei.org permalink

    Attachments


    1. https://eientei.org/media/49/86/31/49863122f7bb92fb880529d2372b8c81524c26ac071e31040ad53e3704856355.png?name=image.png
  18. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Saturday, 19-Apr-2025 08:55:20 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • ur angle, or ur devil.....
    @ligma_male
    In conversation about 9 days ago from eientei.org permalink

    Attachments


  19. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Wednesday, 16-Apr-2025 16:48:16 JST Иоанн Павел Грипс Иоанн Павел Грипс
    HE'S JUST LIKE ME FR
    In conversation about 11 days ago from eientei.org permalink

    Attachments


    1. https://eientei.org/media/91/c2/81/91c28174ab136a053110eaa0ae7d4b3d7fa2ec3ab13c4937d84f7dacae338eec.jpg?name=mpv-shot0003.jpg
  20. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Tuesday, 21-Jan-2025 07:26:11 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Lina Inver?e
    @lina https://ru.wikipedia.org/wiki/Корпус_текстов
    In conversation about 3 months ago from eientei.org permalink

    Attachments

    1. Domain not in remote thumbnail source whitelist: upload.wikimedia.org
      Корпус текстов
      В лингвистике ко́рпус (множественное число — ко́рпусы) — подобранная и обработанная по определённым правилам совокупность текстов, используемых в качестве базы для исследования языка. Они используются для статистического анализа и проверки статистических гипотез, подтверждения лингвистических правил в данном языке. Корпус текстов является предметом исследования корпусной лингвистики. Основные свойства корпуса Среди множества определений корпуса можно выделить его главные свойства: электронный — в современном понимании корпус должен быть в электронном виде репрезентативный — должен хорошо «представлять» объект, который моделирует размеченный — главное отличие корпуса от коллекции текстов прагматически ориентированный — должен быть создан под определённую задачу...
  • Before

User actions

    Иоанн Павел Грипс

    Иоанн Павел Грипс

    привет! я @grips@cawfee.club

    Tags
    • (None)

    Following 0

      Followers 0

        Groups 0

          Statistics

          User ID
          179734
          Member since
          27 Sep 2023
          Notices
          62
          Daily average
          0

          Feeds

          • Atom
          • Help
          • About
          • FAQ
          • TOS
          • Privacy
          • Source
          • Version
          • Contact

          GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.

          Creative Commons Attribution 3.0 All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.