Notices by (mint@eientei.org)
-
(mint@eientei.org)'s status on Saturday, 30-Sep-2023 00:41:48 JST 
:writhing: -
(mint@eientei.org)'s status on Friday, 29-Sep-2023 22:14:11 JST
Every UPS except the last one used only for router and modem bled dry. All is left is suffering. -
(mint@eientei.org)'s status on Tuesday, 13-Jun-2023 02:03:03 JST
@pomstan @pomstan@xn–p1abe3d.xn–80asehdb @mint Classic Scaleway.
$ ping срёт.онлайн PING срёт.онлайн(2001:bc8:1828:50d::1 (2001:bc8:1828:50d::1)) 56 data bytes ^C --- срёт.онлайн ping statistics --- 6 packets transmitted, 0 received, 100% packet loss, time 5111ms $ ping срёт.онлайн -4 PING (51.15.34.68) 56(84) bytes of data. 64 bytes from срёт.онлайн (51.15.34.68): icmp_seq=1 ttl=52 time=78.2 ms 64 bytes from срёт.онлайн (51.15.34.68): icmp_seq=2 ttl=52 time=77.9 ms 64 bytes from срёт.онлайн (51.15.34.68): icmp_seq=3 ttl=52 time=80.7 ms 64 bytes from срёт.онлайн (51.15.34.68): icmp_seq=4 ttl=52 time=77.8 ms 64 bytes from срёт.онлайн (51.15.34.68): icmp_seq=5 ttl=52 time=77.8 ms 64 bytes from срёт.онлайн (51.15.34.68): icmp_seq=6 ttl=52 time=78.2 ms ^C --- ping statistics --- 6 packets transmitted, 6 received, 0% packet loss, time 5006ms rtt min/avg/max/mdev = 77.797/78.425/80.650/1.005 msI’ll make the local resolver ignore IPv6 records for your instance.
-
(mint@eientei.org)'s status on Tuesday, 13-Jun-2023 01:57:56 JST
@pomstan @mint Nope, the post doesn't even get fetched. -
(mint@eientei.org)'s status on Thursday, 16-Feb-2023 08:24:12 JST
Takes quite a while, but at least I can see it's doing COPY and not CREATE INDEX. Feeling rather sleepy right now, might have to finish the job tomorrow. -
(mint@eientei.org)'s status on Thursday, 16-Feb-2023 08:23:45 JST
Forgive me mama, I've used make install. -
(mint@eientei.org)'s status on Thursday, 16-Feb-2023 08:23:43 JST
And I'm not sure if there's enough space on root to keep both the old and new cluster. Will move all the old containers to the terabyte slab. -
(mint@eientei.org)'s status on Thursday, 16-Feb-2023 08:23:42 JST
Forgor 💀 to use pg_tune to speed up the database before going with the dump restore. Hopefully it won't cause any issues. -
(mint@eientei.org)'s status on Thursday, 16-Feb-2023 08:23:41 JST
Looks like the activity index bottleneck is still there. Wasted an hour, so let's interrupt this, recreate the cluster with pgtune settings and dump schema and data separately. -
(mint@eientei.org)'s status on Thursday, 16-Feb-2023 08:23:40 JST
psql:data.sql:2181309: ERROR: function activity_visibility(character varying, character varying[], jsonb) does not exist LINE 1: visibility_new := activity_visibility(NEW.actor, NEW.recipie... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. QUERY: visibility_new := activity_visibility(NEW.actor, NEW.recipients, NEW.data) CONTEXT: PL/pgSQL function public.update_status_visibility_counter_cache() line 15 at assignment COPY activities, line 1: "00000185-47a3-fb00-d73b-6f576a0e0000 {"cc": ["https://artisan.chat/users/Curator", "https://chaos.so..." COPY 0 COPY 81922 COPY 0 COPY 589 COPY 0 psql:data.sql:2263869: ERROR: insert or update on table "bookmarks" violates foreign key constraint "bookmarks_activity_id_fkey" DETAIL: Key (activity_id)=(00000185-e7ca-4951-847f-1d724ce70000) is not present in table "activities". Not a good sign.
-
(mint@eientei.org)'s status on Thursday, 16-Feb-2023 08:23:39 JST
pg_dumpall does not support custom format. What a bummer. -
(mint@eientei.org)'s status on Thursday, 16-Feb-2023 08:23:37 JST
Even with binary format, you need --disable-triggers for it to not sperg out with each copied column. -
(mint@eientei.org)'s status on Friday, 27-Jan-2023 09:23:43 JST
@bikejourno Looks like a great thing to drive when having to take a shortcut through nigger-infested neighborhood.
All ０７６萌ＳＮＳ content and data are available under the