Conversation
anime graf mays 🛰️🪐
graf@poa.st
if you guys are OFF of poast and on any other instance other than netzsphaere.xyz AND YOU VOTED IN THIS POLL can you please reply in this quote thread, not the original thread, in the thread I am typing right now.
RT: https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93
RT: https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93
14
2
1
0
0
0
Witch Hunter Siegfried
Witch_Hunter_Siegfried@tsundere.love
0
0
0
TrueMasterCole
TrueMasterCole@detroitriotcity.com
0
0
0
anime graf mays 🛰️🪐
graf@poa.sthow 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;
1
0
0
anime graf mays 🛰️🪐
graf@poa.st
I assume yours is just one vote in your database recorded as no?
1
0
0
Phantasm
phnt@fluffytail.org
@graf Yep.
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)
0
0
0
0
0
0
anime graf mays 🛰️🪐
graf@poa.st
@phnt I know this is a really fucking dirty way to do it, but if we had a master relay we could distribute this. these are all all local votes
1
0
1
Phantasm
phnt@fluffytail.org
@graf @georgia @matty I haven't looked, but it is likely that the votes (Answer objects) only federate to the instance where the poll originated by design, instead of to the followers of the users voting on the poll like a post would do.
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.
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
1
0
0
@graf @georgia @matty
cc @snacks Could you do a DB query for the answers to the test poll? You should have all the Answer Objects.
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;
2
0
0
Snacks
snacks@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!
Phantasm
phnt@fluffytail.org
@snacks @georgia @matty @graf So there's an issue where Akkoma and possibly Pleroma aren't processing the votes right. My account should be in there, but isn't.
Do logs show anything useful?
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
2
0
0
anime graf mays 🛰️🪐
graf@poa.st
The only poast user is cute despite us having 86 in our database. thats wild
0
0
0
0
0
0
Phantasm
phnt@fluffytail.org
@snacks @georgia @matty @graf That wouldn't return HTTP 500 and I have Squid set to prefer v4 for obvious reason. There should be a log somewhere that complains about something resulting in HTTP 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.
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.
1
0
0
Phantasm
phnt@fluffytail.org@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.
1
0
0
🐴 SuperUmaFriend 🐴
SuperSnekFriend@tsundere.love
0
0
0
