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), page 2

  1. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Wednesday, 07-May-2025 02:01:28 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Иоанн Павел Грипс
    who really cares nigga
    In conversation about a year ago from eientei.org permalink
  2. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Wednesday, 07-May-2025 02:01:26 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Иоанн Павел Грипс
    give me a drink bartender
    In conversation about a year ago from eientei.org permalink
  3. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Tuesday, 06-May-2025 18:09:52 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • 御園はくい
    • ロミンちゃん
    @hakui @romin this is disinformation. I didn't update
    In conversation about a year ago from eientei.org permalink
  4. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Monday, 05-May-2025 22:29:41 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Phantasm
    @phnt I like tabs for indentation, spaces for alignment - but you have to make sure that they're displayed, and be fascist around contributions
    In conversation about a year ago from eientei.org permalink
  5. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Monday, 05-May-2025 22:07:03 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • NEETzsche
    • Edward Sneeden
    • Stallmon
    • Maltheus
    @NEETzsche @Maltheus @sneeden @stallmon good riddance :013_thumbs_up:
    In conversation about a year ago from eientei.org permalink
  6. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Monday, 05-May-2025 20:01:26 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • :blank:
    • Phantasm
    @phnt @i real
    In conversation about a year ago from eientei.org permalink
  7. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Saturday, 03-May-2025 00:46:13 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Zero :zt_think: :artix:
    • gray
    @gray @zero it's like talking to an AI. you know what to expect, but some of the dumb shit can still surprise you
    In conversation about a year ago from eientei.org permalink
  8. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Friday, 02-May-2025 21:15:39 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Phantasm
    @phnt the 🇨🇿 kills it
    In conversation about a year ago from eientei.org permalink
  9. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Tuesday, 29-Apr-2025 06:22:45 JST Иоанн Павел Грипс Иоанн Павел Грипс

    Cawfee Club is NOT FUCKING DEAD. I'm going to fleece my employer a bit and work on it at work this week.

    This is the most comprehensive update you'll get from me before it's up. Don't ask me anything, just read the fucking thing.

    https://cawfee.club

    In conversation about a year ago from eientei.org permalink
  10. Embed this notice
    Иоанн Павел Грипс (grips@eientei.org)'s status on Monday, 28-Apr-2025 20:11:57 JST Иоанн Павел Грипс Иоанн Павел Грипс
    in reply to
    • Phantasm
    @phnt @kura isn't Rocky just Alma?
    In conversation about a year ago from eientei.org permalink
  11. 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 a year ago from eientei.org permalink

    Attachments


    1. https://eientei.org/media/08/6a/4f/086a4feda2e2862da337c66df87acd63c7e9b82f177d287541c2e323da25167d.png?name=image.png
  12. 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 a year ago from eientei.org permalink
  13. 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 a year 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)
  14. 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 a year ago from eientei.org permalink
  15. 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 a year ago from eientei.org permalink

    Attachments


    1. https://eientei.org/media/05/48/8c/05488ccdda689d4b5b3a2a85b59ec9607131cbe1d3ebfc33e40fc03ae71fe5bf.png?name=image.png
  16. 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 a year ago from eientei.org permalink
  17. 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 a year ago from eientei.org permalink

    Attachments


    1. https://eientei.org/media/bf/9e/bc/bf9ebc615e5541be5726eec0dc3c9a272eacce060a7c99c832f4aa0787da50c5.png?name=image.png
  18. 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 a year ago from eientei.org permalink
  19. 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 a year ago from eientei.org permalink
  20. 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 a year ago from eientei.org permalink
  • After
  • Before

User actions

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

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

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

    Tags
    • (None)

    Following 0

      Followers 0

        Groups 0

          Statistics

          User ID
          179734
          Member since
          27 Sep 2023
          Notices
          92
          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.