<2022-02-05T05:54:35.000Z> graf: im so sorry man, I meant to do it this morning but we received an email from our DNS provider that we had to pay them 200$/mo starting in 2 weeks because we provided DNS service to someone else on fedi so I've been moving all our shit today. I will do this first thing in the AM
<2022-02-05T06:07:44.000Z> graf: i will keep u updated, and i will keep this chat open on my desktop so i remember
<2022-02-05T06:07:46.000Z> graf: thank you for understanding
<2022-02-05T06:08:02.000Z> graf: the tradeoff for me not having to do moderation was i have to do everything else so
<2022-02-05T06:08:02.000Z> graf: lol
<2022-02-05T19:42:41.000Z> graf: so the reason it's not working is because we have poast configured to block all TOR traffic to prevents sites like archive.is (if you search poa.st, for the past several weeks its just the error page) i will have to figure out another way to go about routing traffic from the onion to poast, perhaps rewriting links
<2022-02-05T19:44:36.000Z> graf: I will work at this over the next couple hours and hopefully have a resolution 
<2022-03-02T05:20:48.000Z> DEngineer: > our database is stuck processing something for several hours... suboptimal query?
<2022-03-02T05:50:21.000Z> DEngineer: what are your database issues?  I may have some insights for you (possibly not insights you haven't already had for yourself, but I do actually do this for a living)
<2022-03-02T05:51:18.000Z> graf: our issue is automated database maintenance tasks removing notes attached to objects in our database. it leaves the object intact, so when the backend server tries to find that note attached to that object to deliver to a user as a notification it cant, so it throws errors constantly and is causing database to thrash
<2022-03-02T05:52:16.000Z> DEngineer: ... should the objects be removed?  if so, then ON CASCADE DELETE would be your friend, I should think
<2022-03-02T05:52:28.000Z> DEngineer: (or equivalent)
<2022-03-02T05:52:36.000Z> DEngineer: you're on Postgres, right?
<2022-03-02T05:52:37.000Z> DEngineer: I think I recall seeing that somewhere
<2022-03-02T05:52:48.000Z> graf: yeah but the issue is tracking down every offending object and removing them
<2022-03-02T05:53:01.000Z> graf: its much easier to implement in pleroma to check if `isNull`
<2022-03-02T05:53:53.000Z> graf: https://www.toptal.com/developers/hastebin/menuxewufo.yaml\
<2022-03-02T05:53:56.000Z> graf: toptal.com/developers/hastebin/menuxewufo.yaml *
<2022-03-02T05:54:02.000Z> graf: thousands of instances of that ^
<2022-03-02T05:54:07.000Z> graf: every second
<2022-03-02T05:54:12.000Z> graf: for multiple objects, for multiple users
<2022-03-02T05:54:15.000Z> DEngineer: also, you might explore the use of COALESCE, if you want to return values from something that may be NULL, but for which you don't want a NULL result if it will cause problems
<2022-03-02T05:56:19.000Z> DEngineer: (I've used this in conjunction with LEFT JOIN for problematic cases like that, where the query may return a NULL that the application is not prepared to deal with)
<2022-03-02T05:57:16.000Z> graf: I was working with another admin on it because it's actually a bug in pleroma that needs to be addressed ASAP so we will address it in the server software, then I may touch base with you on the database issues later tomorrow
<2022-03-02T05:57:18.000Z> graf: thanks for the suggestions
<2022-03-02T05:59:17.000Z> DEngineer: sure, no worries :D
<2022-03-02T05:59:50.000Z> DEngineer: (sorry for the delays, for whatever reason it's not updating this very smoothly for me via the Tor gateway, so I'm having to refresh the page to see your responses)
<2022-03-15T21:13:24.000Z> DEngineer: ty fren for fixing the tors
<2022-08-16T20:40:07.000Z> DEngineer: is it possible to change handles?
<2022-08-16T20:40:16.000Z> DEngineer: like @handle1 to @handle2?
<2022-09-08T00:16:19.000Z> DEngineer: okay, I'm gay - I want to try and add another account since I can't change handles; if you come up for air after this whole KiwiFarms thing, could I get you to clear the address for "VaxxSabbath", since apparently the email provider I use doesn't support plus addressing?  if possible, that isty good sir