RT: https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93
Post
Remote status
Context
1RT: https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93
Yes, I vooted
Replies
25how many votes does NCD show for the OP poll on the normal front end (or pleromaFE)
select distinct data->>'actor' as actor_id, data->>'name' as vote from objects where data->>'inReplyTo' = 'https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93' and data->>'type' = 'Answer' order by vote asc;
11 votes total. 5 no, 6 yes.
okay thank you so much
Of course! Let me know if thereβs anything else I can do.
I'm wondering if I can deliver votes over our relay
A relay could be used, but that isn't universal. When you look at the Object as returned by netzsphaere.xyz, it already has a "voters" array with all the voters, but it is incorrect. I'm not in it for example. So this is processing issue, rather than a federation issue probably. Pleroma should also use the array to get the accurate number of voters, which it seemingly currently does not.
curl -H "Accept: application/activity+json" "https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93" | jq .voters
cc @snacks Could you do a DB query for the answers to the test poll? You should have all the Answer Objects.
select distinct data->>'actor' as actor_id, data->>'name' as vote from objects where data->>'inReplyTo' = 'https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93' and data->>'type' = 'Answer' order by vote asc;
@phnt @georgia @matty @graf i assume no one has any issues with me just dumping who voted what in a test poll
actor_id | vote
----------------------------------------------------+------
https://decayable.ink/users/Folklore | no.
https://detroitriotcity.com/users/Spooke | no.
https://gameliberty.club/users/Mr_NutterButter | no.
https://jollyville.net/users/not_br549 | no.
https://noauthority.social/users/Vo | no.
https://shitposter.world/users/shibao | no.
https://snug.moe/users/97re3zgzsp | no.
https://brain.worm.pink/users/technicallydifficult | yes!
https://detroitriotcity.com/users/TrueMasterCole | yes!
https://fsebugoutzone.org/users/npc | yes!
https://mai.waifuism.life/users/9otxaeemjqy70001 | yes!
https://mrhands.horse/users/shitpisscum | yes!
https://netzsphaere.xyz/users/snacks | yes!
https://pisskey.io/users/963omd7apj | yes!
https://pleroma.soykaf.com/users/kaia | yes!
https://poa.st/users/cute | yes!
https://shigusegubu.club/users/hj | yes!
https://shitposter.world/users/sun | yes!
https://social.linux.pizza/users/trogluur | yes!
https://spinster.xyz/users/Flick | yes!
https://stereophonic.space/users/echo | yes!
https://stereophonic.space/users/genmaicha | yes!
https://stereophonic.space/users/scathach | yes!
Do logs show anything useful?
Apr 11 17:32:19 [error] Publisher failed to inbox https://netzsphaere.xyz/users/georgia/inbox with status 500
Apr 11 17:32:52 [error] Publisher failed to inbox https://netzsphaere.xyz/users/georgia/inbox {:error, :checkout_timeout}
Apr 11 17:34:06 [error] Publisher failed to inbox https://netzsphaere.xyz/users/georgia/inbox with status 500
Apr 11 17:38:46 [error] Publisher failed to inbox https://netzsphaere.xyz/users/georgia/inbox with status 500
Apr 11 17:56:10 [error] Publisher failed to inbox https://netzsphaere.xyz/users/georgia/inbox with status 500
Apr 11 18:50:16 [error] Publisher failed to inbox https://netzsphaere.xyz/users/georgia/inbox with status 500
Apr 11 2114 [error] Publisher failed to inbox https://netzsphaere.xyz/users/georgia/inbox with status 500
Apr 12 01:44:36 [error] Publisher failed to inbox https://netzsphaere.xyz/users/georgia/inbox with status 500
Apr 12 10:53:41 [error] Publisher failed to inbox https://netzsphaere.xyz/users/georgia/inbox with status 500
Apr 13 03:20:22 [error] Publisher failed to inbox https://netzsphaere.xyz/users/georgia/inbox with status 500
If there are any Phoenix logs with POST to /users/georgia/inbox, those can be the issue and those are multiple-entry syslogs, so a grep makes them unusable. Anything that has https://fluffytail.org/users/phnt around those times can be useful, especially if it mentions Ecto.Changeset or :transmogrifier.
Anyways, I'll be gone for a few hours, so take your time.
@snacks @georgia @matty @graf Yeah, that is fine. You don't want to use --grep as that removes some context on certain logs.
But if something blows up when processing the inbox, Phoenix should complain that a process crashes with an error log. Or there should be complains that something didn't pass validators or something.
The only poast user is cute despite us having 86 in our database. thats wild