Egregoros

Signal feed

Timeline

Post

Remote status

Context

16

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;

@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.

curl -H "Accept: application/activity+json" "https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93" | jq .voters
@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.

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!
@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?
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 21:02:14 [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
@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.

Replies

5