Post ASC5hUzbfTJrpG1YsC by roboneko@masochi.st
(DIR) More posts by roboneko@masochi.st
(DIR) Post #AS8evKg9WxZXeiPucq by redneonglow@bae.st
2023-01-29T14:57:48.782753Z
2 likes, 0 repeats
@sjwI went to export my follows to CSV last night and it's still processing the next morning. Can you take a look when you get a chance? It's never taken this long.
(DIR) Post #AS8hCT1zvi8wOJvuTo by redneonglow@bae.st
2023-01-29T15:23:20.523577Z
2 likes, 0 repeats
@sjw Had to reboot, tried again, it's still taking its time.
(DIR) Post #ASAwHDXcprLhQWMyFU by sjw@bae.st
2023-01-30T17:21:41.626765Z
1 likes, 1 repeats
@redneonglow yee I'm not sure. I've been having similar issues. I'm not sure if it's related to the migration or not.
(DIR) Post #ASAwKdYgYqACzCUoKm by redneonglow@bae.st
2023-01-30T17:22:19.596959Z
2 likes, 0 repeats
@sjw I've tried several times to export follows and it hasnt been working at all.
(DIR) Post #ASAwnZzIupQ4JGkOtU by sjw@bae.st
2023-01-30T17:27:31.731925Z
1 likes, 0 repeats
@redneonglow yee not sure if bug or migration issuecc @p any ideas why the migration might cause this?
(DIR) Post #ASAxgd4d8ycno8ULXU by p@freespeechextremist.com
2023-01-30T17:37:31.361130Z
1 likes, 0 repeats
@sjw @redneonglow Maybe 10k is enough that it starts timing out.
(DIR) Post #ASAz3HpCPe94WIddjM by sjw@bae.st
2023-01-30T17:52:47.169346Z
1 likes, 0 repeats
@p @redneonglow huh yeah, I'm just not sure if it's a pleroma bug or something caused from the migration
(DIR) Post #ASAzKXEgMsi7EtmaMi by p@freespeechextremist.com
2023-01-30T17:55:56.378013Z
1 likes, 0 repeats
@sjw @redneonglow I think it's just the DB connection timing out.
(DIR) Post #ASB7Iq1YLH7SZ2LLGq by sjw@bae.st
2023-01-30T19:25:14.171041Z
1 likes, 0 repeats
@p @redneonglow I wish I could adjust the connection timeout for specific tasks without it being globalI'll try bumping up the timeout to 30 seconds or something and see how that goes.
(DIR) Post #ASB7bsKTzlOfDSH7bM by sjw@bae.st
2023-01-30T19:28:40.731394Z
1 likes, 0 repeats
@p @redneonglow Alright, connection timeout is now 40 seconds. Give it a try again @redneonglow
(DIR) Post #ASB9zikHTmJGLmq9NA by sjw@bae.st
2023-01-30T19:55:23.806272Z
2 likes, 0 repeats
@p @redneonglow Well it still doesn't work for me but even back on neckbeard I remember having to try it maybe 8 times in a row with a 60 second or so break in-between before enough of the query was cashed that it would finally go through.
(DIR) Post #ASBAhvvNqCqRxy7Diy by mint@ryona.agency
2023-01-30T20:02:24.181327Z
2 likes, 0 repeats
@sjw @redneonglow @p Alternatively, one could get/write a script that iterates through AP endpoint pages and rebuilds the list out of results, I think Stinky Pete had such a script on hand.https://bae.st/users/redneonglow/following?page=1
(DIR) Post #ASBBLdKeO2L5szreHQ by mint@ryona.agency
2023-01-30T20:09:30.965859Z
2 likes, 0 repeats
@sjw @p @redneonglow And a third variant for those who have godmode.for i in $(sudo --user=postgres psql -d pleroma -At -c "select nickname from users where id in (select following_id from following_relationships where follower_id = (select id from users where nickname = 'redneonglow' and state = 2);"); do echo $i; doneNo idea what the fuck is pleromer doing that it couldn’t export the list when it’s such a trivial query.
(DIR) Post #ASBBlY6MSKlDC2XQcC by mint@ryona.agency
2023-01-30T20:14:16.440428Z
2 likes, 0 repeats
@p @redneonglow @sjw Forgot the parenthesis when replacing the name, and since one of the servers in convo still doesn’t support edits, have a command that doesn’t have unneccessary shell iteration (used it to copypaste list of all members on arbitrary server for ez hellthreads, then blindly copypasted it).psql -d pleroma -At -c "select nickname from users where id in (select following_id from following_relationships where follower_id = (select id from users where nickname = 'redneonglow') and state = 2);" > list.csv
(DIR) Post #ASBBzjbySXKmwd5aQS by mint@ryona.agency
2023-01-30T20:16:51.884752Z
1 likes, 0 repeats
@p @redneonglow @sjw >used it to copypaste [...] then blindly copypasted itFucking brainworms. Used the crude `for i in $(command); do echo -n "@$i "; done` to have easily copy-able list of members in one line, not like it matter for this issue.
(DIR) Post #ASBC2oq5Tn721iA3RQ by mint@ryona.agency
2023-01-30T20:17:29.951657Z
2 likes, 0 repeats
@p @redneonglow @sjw Found the other script, btw.https://freespeechextremist.com/media/a75d45fb-3be9-41c9-a907-3c7678152d66/follower-scrape
(DIR) Post #ASBOWgssoqE1UaTm5o by redneonglow@bae.st
2023-01-30T22:38:14.497271Z
1 likes, 0 repeats
@sjw @p Nope, just tried it, still doesn't work.
(DIR) Post #ASBpVz8CBnLKYbWtEm by p@freespeechextremist.com
2023-01-31T03:40:40.207160Z
2 likes, 0 repeats
@sjw @redneonglow See how long `select nickname from users where id in (select following_id from following_relationships where follower_id in (select id from users where nickname = 'redneonglow' limit 1));` takes just as a sanity check.
(DIR) Post #ASBpfQO2Dubrh8RIe0 by p@freespeechextremist.com
2023-01-31T03:42:22.566569Z
1 likes, 1 repeats
@mint @sjw @redneonglow Yeah, that's a reasonable idea. Usually takes less time to just go through the API.
(DIR) Post #ASBpwdZGTAaLUwtpmi by p@freespeechextremist.com
2023-01-31T03:45:29.212770Z
2 likes, 0 repeats
@mint @redneonglow @sjw > one of the servers in convo still doesn’t support PURE DEGENERACY:alexjonesdemons:
(DIR) Post #ASBvsEjvRA7t3uAf5M by sjw@bae.st
2023-01-31T04:51:52.212886Z
2 likes, 0 repeats
@p @redneonglow pretty much instantly. It might have been cached tho.When I ran a similar (if not the same) command earlier it was less than 5 seconds. Even the results for @glow_in_the_dark_cia_agent were less than 8 seconds.
(DIR) Post #ASC3X5kaSmyyjZuP3I by p@freespeechextremist.com
2023-01-31T06:17:44.424417Z
2 likes, 0 repeats
@sjw @glow_in_the_dark_cia_agent @redneonglow You could try seeing what it's actually asking Postgres when the job kicks off.Actually, checking the errors in the job queue might be an even better plan.
(DIR) Post #ASC3fbVGI6S5WwncTA by sjw@bae.st
2023-01-31T06:19:15.436298Z
2 likes, 0 repeats
@p @glow_in_the_dark_cia_agent @redneonglow I'll do that later. I'm drunk and sleepy and just finished eating 6 large medium boiled eggs for dinner.
(DIR) Post #ASC4SqPTemrdx6Zboe by p@freespeechextremist.com
2023-01-31T06:28:10.659602Z
1 likes, 0 repeats
@sjw @glow_in_the_dark_cia_agent @redneonglow What'd you put on them?
(DIR) Post #ASC4oyRiSXsDFMAlmq by sjw@bae.st
2023-01-31T06:32:09.302667Z
2 likes, 0 repeats
@p @glow_in_the_dark_cia_agent @redneonglow salt and fresh ground black peppercorns
(DIR) Post #ASC5KY67xO0unP8AyW by p@freespeechextremist.com
2023-01-31T06:37:53.020957Z
2 likes, 1 repeats
@sjw @glow_in_the_dark_cia_agent @redneonglow Gotta master the fundamentals.
(DIR) Post #ASC5hUzbfTJrpG1YsC by roboneko@masochi.st
2023-01-31T06:42:01.425813Z
2 likes, 0 repeats
@sjw @redneonglow @p 6 (SIX!) eggsnothing but salt and pepper:gigachad:
(DIR) Post #ASC5r4MTXKxk7uHhLc by sjw@bae.st
2023-01-31T06:43:43.889907Z
2 likes, 0 repeats
@roboneko @redneonglow @pScreenshot_20230131-004323.png