RT: https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93
Post
Remote status
RT: https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93
Replies
31RT: https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93
how 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
I assume yours is just one vote in your database recorded as no?
Of course! Let me know if thereโs anything else I can do.
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;
actor_id | vote
-----------------------------------+------
https ://fluffytail.org/users/phnt | no.
(1 row)
select data from objects where data->>'id' = 'https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93';
{"cc": ["..."], "id": "https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93", "to": ["..."], "bcc": [], "bto": [], "tag": [], "type": "Question", "actor": "https://netzsphaere.xyz/users/georgia", "anyOf": [], "emoji": {}, "likes": [], "oneOf": [{"name": "yes!", "type": "Note", "replies": {"type": "Collection", "totalItems": 15}}, {"name": "no.", "type": "Note", "replies": {"type": "Collection", "totalItems": 7}}], "closed": "2026-05-01T13:11:42.972718Z", "voters": ["https://fluffytail.org/users/phnt"], "content": "test poll", "context": "https://netzsphaere.xyz/contexts/4f83c49a-4104-478e-a45b-38116e48a00f", "published": "2026-04-11T13:11:42.981613Z", "sensitive": false, "attachment": [], "contentMap": {"en": "test poll"}, "like_count": 0, "quotesCount": 2, "attributedTo": "https://netzsphaere.xyz/users/georgia", "quotes_count": 0, "repliesCount": 5, "announcements": ["https://poa.st/users/graf"], "replies_count": 0, "announcement_count": 1}
(1 row)
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;
jeff, please this is a serious matter
@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
The only poast user is cute despite us having 86 in our database. thats wild
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.