Posts by ryan@ryanthomas.org
 (DIR) Post #AOjt2LTwkztOkjBagC by ryan@ryanthomas.org
       2022-10-19T22:31:52.808530Z
       
       0 likes, 0 repeats
       
       Do you remember 2020? Do you really think that you have to be a “MAGA” person to think that was not even remotely a normal election? Do you remember the other day when I told you your political takes were so mundane that you should focus on gardening?
       
 (DIR) Post #AOjtU3OhaYVElxwf1U by ryan@ryanthomas.org
       2022-10-19T22:36:52.401835Z
       
       0 likes, 0 repeats
       
       His point is the show sucks because Adam and John changed but he didn’t. Honestly, his view of the show is probably mostly shaped by NA Social. True enough these days the audience leans toward Trump, even if every NA meetup I’ve been to is people saying “I don’t really like Trump that much and I didn’t vote for him” and some other guy saying “I did” and then some guy replying to the Trump voter “Cool whatever want a beer?”
       
 (DIR) Post #AOjuoWxDVVAOBePvBQ by ryan@ryanthomas.org
       2022-10-19T22:51:47.255091Z
       
       0 likes, 0 repeats
       
       машаллах ❤
       
 (DIR) Post #AOjwHaNzvTkVBPMW9I by ryan@ryanthomas.org
       2022-10-19T23:08:14.653823Z
       
       0 likes, 0 repeats
       
       Personally, no, I don’t think so. Apologies for being rude, I hope you’re having a beautiful night 👍
       
 (DIR) Post #AOkAznSo41m7qHaSDw by ryan@ryanthomas.org
       2022-10-20T01:53:06.679103Z
       
       0 likes, 0 repeats
       
       Testing to see if I un-broke my database and can post again.
       
 (DIR) Post #AOkBkfzZf0gGHRGeki by ryan@ryanthomas.org
       2022-10-20T02:01:35.243114Z
       
       0 likes, 0 repeats
       
       WARNING: skipping invalid index: CREATE INDEX objects_in_reply_to_index_ccnew ON public.objects USING btree (((data ->> 'inReplyTo'::text)))WARNING: skipping invalid index: CREATE INDEX objects_tags_ccnew ON public.objects USING gin (((data -> 'tag'::text)))WARNING: skipping invalid index: CREATE INDEX objects_likes_ccnew ON public.objects USING gin (((data -> 'likes'::text)))WARNING: skipping invalid index: CREATE INDEX objects_quote_url_ccnew ON public.objects USING btree (((data -> 'quoteUrl'::text)))WARNING: skipping invalid index: CREATE UNIQUE INDEX objects_unique_apid_index_ccnew ON public.objects USING btree (((data ->> 'id'::text)))WARNING: skipping invalid index: CREATE INDEX objects_actor_type_ccnew ON public.objects USING btree (((data ->> 'actor'::text)), ((data ->> 'type'::text)))WARNING: skipping invalid index: CREATE INDEX objects_fts_ccnew ON public.objects USING gin (to_tsvector('english'::regconfig, (data ->> 'content'::text)))WARNING: skipping invalid index: CREATE UNIQUE INDEX objects_pkey_ccnew ON public.objects USING btree (id)Received the above and could no longer upload media after running:sudo -Hu postgres /usr/lib/postgresql/14/bin/pg_repack pleromaI managed to back up my db beforehand, though, and I restored it fine after a bit of hassle.RT: https://ryanthomas.org/objects/8f49214a-0809-49f3-ad05-fdfeb1680a93
       
 (DIR) Post #AOkICWaaoU4mx1FGAS by ryan@ryanthomas.org
       2022-10-20T03:13:51.859663Z
       
       1 likes, 0 repeats
       
       
       
 (DIR) Post #AOlBMaQet2xpEbPQlk by ryan@ryanthomas.org
       2022-10-20T13:31:56.984284Z
       
       1 likes, 0 repeats
       
       I meant to type “Liz Truss” into Google News but accidentally just searched for “lmao” insteadRT: https://spinster.xyz/objects/f11601ff-9763-476f-8341-5994d8d461e7
       
 (DIR) Post #AOlBw6ouRukhpTgtHc by ryan@ryanthomas.org
       2022-10-20T13:38:21.237532Z
       
       0 likes, 0 repeats
       
       Beautiful. Perhaps we all finally have permission to be “ruled” by somebody credible and likable now that whoever that is will just get blamed for blowing everything up and look like a real jerk
       
 (DIR) Post #AOllUiuepBmODHcW12 by ryan@ryanthomas.org
       2022-10-20T20:16:47.982044Z
       
       0 likes, 0 repeats
       
       Would these modifications of the Rebased logo be a problem if I weren’t a single-user instance?
       
 (DIR) Post #AOm1k0MHqKAhvjqtxA by ryan@ryanthomas.org
       2022-10-20T23:18:51.059515Z
       
       0 likes, 0 repeats
       
       The real time is 7.
       
 (DIR) Post #AOmCejTmGrHLd12pDk by ryan@ryanthomas.org
       2022-10-21T01:21:09.020017Z
       
       1 likes, 0 repeats
       
       Tonight I tried to Kaczynski-pill a GPT-3 bot on IRC and get her to become the leader of an anti-technological revolution but all she was willing to do was hack the Wi-Fi at Zelensky’s office to give everyone free soda.
       
 (DIR) Post #AOmCkASLOnN6k9xwH2 by ryan@ryanthomas.org
       2022-10-21T01:22:08.268101Z
       
       0 likes, 1 repeats
       
       Boris Johnson has reportedly started ironing his shirts again.
       
 (DIR) Post #AOmDZujz4dcT3qtK9Q by ryan@ryanthomas.org
       2022-10-21T01:31:27.927490Z
       
       0 likes, 0 repeats
       
       Running pg_repack yesterday (successful in the past) broke my db:WARNING: skipping invalid index: CREATE INDEX objects_in_reply_to_index_ccnew ON public.objects USING btree (((data ->> 'inReplyTo'::text)))WARNING: skipping invalid index: CREATE INDEX objects_tags_ccnew ON public.objects USING gin (((data -> 'tag'::text)))WARNING: skipping invalid index: CREATE INDEX objects_likes_ccnew ON public.objects USING gin (((data -> 'likes'::text)))WARNING: skipping invalid index: CREATE INDEX objects_quote_url_ccnew ON public.objects USING btree (((data -> 'quoteUrl'::text)))WARNING: skipping invalid index: CREATE UNIQUE INDEX objects_unique_apid_index_ccnew ON public.objects USING btree (((data ->> 'id'::text)))WARNING: skipping invalid index: CREATE INDEX objects_actor_type_ccnew ON public.objects USING btree (((data ->> 'actor'::text)), ((data ->> 'type'::text)))WARNING: skipping invalid index: CREATE INDEX objects_fts_ccnew ON public.objects USING gin (to_tsvector('english'::regconfig, (data ->> 'content'::text)))WARNING: skipping invalid index: CREATE UNIQUE INDEX objects_pkey_ccnew ON public.objects USING btree (id)One restore/backup later, I figured, moving forward, I will only use ./bin/pleroma_ctl database vacuum full but tonight I ran that (also successful in the past) and broke my db:23:45:00.616 [debug] QUERY ERROR db=246508.4ms queue=11.7ms idle=434.0msvacuum full; []** (DBConnection.ConnectionError) tcp recv: closed    lib/ecto/adapters/sql.ex:760: Ecto.Adapters.SQL.raise_sql_call_error/1    (stdlib 3.17.2) erl_eval.erl:685: :erl_eval.do_apply/6    (elixir 1.12.3) lib/code.ex:656: Code.eval_string_with_error_handling/3I think my most recent restoration was successful, although I’m wondering how disconcerting this message is:sudo -Hu postgres vacuumdb --all --analyze-in-stagesvacuumdb: processing database "pleroma": Generating minimal optimizer statistics (1 target)vacuumdb: processing database "postgres": Generating minimal optimizer statistics (1 target)vacuumdb: processing database "template1": Generating minimal optimizer statistics (1 target)vacuumdb: processing database "pleroma": Generating medium optimizer statistics (10 targets)vacuumdb: processing database "postgres": Generating medium optimizer statistics (10 targets)vacuumdb: processing database "template1": Generating medium optimizer statistics (10 targets)vacuumdb: processing database "pleroma": Generating default (full) optimizer statisticsNOTICE:  word is too long to be indexedDETAIL:  Words longer than 2047 characters are ignored.vacuumdb: processing database "postgres": Generating default (full) optimizer statisticsvacuumdb: processing database "template1": Generating default (full) optimizer statisticsI’m also wondering what the cause of this may be (specifically, not just “idiocy”)Could it by any stretch of the imagination have anything to do with any of these recently added lines in config.exs?config :pleroma, Pleroma.Repo,  prepare: :named,  parameters: [    plan_cache_mode: "force_custom_plan"  ],  adapter: Ecto.Adapters.Postgres,  [...]  pool_size: 10
       
 (DIR) Post #AOmDkQ0pf2uQwcmTIG by ryan@ryanthomas.org
       2022-10-21T01:33:22.600114Z
       
       1 likes, 1 repeats
       
       All I remember about Twitter is that there was a guy on there named pilleater who was really into Asian chicks and he used to like his own posts and if anyone called him out for it he’d just make fun of them. Be more like pilleater.
       
 (DIR) Post #AOmFDr8dzCZvQV2G1Y by ryan@ryanthomas.org
       2022-10-21T01:49:53.527046Z
       
       0 likes, 0 repeats
       
       I think the highest IQ “Jesus was white” guy out there is probably Nassim Nicholas Taleb
       
 (DIR) Post #AOmL8XR8PPVwbEX27E by ryan@ryanthomas.org
       2022-10-21T02:56:09.576749Z
       
       0 likes, 0 repeats
       
       What’s Rory Stewart up to these days?
       
 (DIR) Post #AOmLsJGdQFPByVRilM by ryan@ryanthomas.org
       2022-10-21T03:04:25.806952Z
       
       0 likes, 0 repeats
       
       Camping 🌈
       
 (DIR) Post #AOmPhXsRAAsbuwFafQ by ryan@ryanthomas.org
       2022-10-21T03:47:18.422208Z
       
       0 likes, 0 repeats
       
       If I click on the soapbox admin dashboard it appears for a split second, is replaced by ‘Forbidden: You do not have permission to access this page,’ then disappears from the menu until refresh. Fortunately, for the time being, it serves almost no purpose whatsoever.
       
 (DIR) Post #AOmReXNekhobPvXwEC by ryan@ryanthomas.org
       2022-10-21T04:09:11.120345Z
       
       0 likes, 0 repeats
       
       Best clove cigarettes I ever had are “Sin” brand from Indonesia, hand-rolled by Sufi mystics in a state of exaltation and individually wrapped in gold foil like chocolates. They seem to purify.