SecurePoll display discrepancy in number of voters
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	jrbs
	Feb 13 2023, 7:04 PM

Description

Odd issue: SecurePoll shows the number of votes as 3,104 on votewiki but the actual number of current votes is 3,097.

wikiadmin2023@10.64.132.14(votewiki)> SELECT COUNT(*) FROM securepoll_votes WHERE vote_current = 1 AND vote_struck = 0 AND vote_election = 1414;
+----------+
| COUNT(*) |
+----------+
|     3097 |
+----------+
1 row in set (0.017 sec)

wikiadmin2023@10.64.132.14(votewiki)> SELECT COUNT(*) FROM securepoll_votes WHERE vote_current = 1 AND vote_election = 1414;
+----------+
| COUNT(*) |
+----------+
|     3104 |
+----------+
1 row in set (0.009 sec)

Details

Subject	Repo	Branch	Lines +/-
SecurePoll: Fixing query used to display vote total	mediawiki/extensions/SecurePoll	REL1_42	+2 -1
SecurePoll: Fixing query used to display vote total	mediawiki/extensions/SecurePoll	REL1_39	+2 -1
SecurePoll: Fixing query used to display vote total	mediawiki/extensions/SecurePoll	REL1_41	+2 -1
SecurePoll: Fixing query used to display vote total	mediawiki/extensions/SecurePoll	REL1_40	+2 -1
SecurePoll: Fixing query used to display vote total	mediawiki/extensions/SecurePoll	master	+2 -1

Customize query in gerrit

Event Timeline

jrbs created this task.Feb 13 2023, 7:04 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 13 2023, 7:04 PM

This is also the case for the recent U4C election, which has 1444 - 144 - 6 = 1294 votes listed, but the table shows there are actually 1295 unique usernames (from accounts whose votes were not struck).

Johannnes89 subscribed.Aug 7 2024, 3:46 PM

Once again this has happened with the most-recent Board election; the database says 6,000 exactly, while votewiki says 6,001.

Might try some digging here to see which user is "missing".

Change #1073905 had a related patch set uploaded (by Foks; author: Foks):

[mediawiki/extensions/SecurePoll@master] SecurePoll: Fixing query used to display vote total

https://gerrit.wikimedia.org/r/1073905

gerritbot added a project: Patch-For-Review.Sep 18 2024, 9:02 PM

Change #1073905 merged by jenkins-bot:

[mediawiki/extensions/SecurePoll@master] SecurePoll: Fixing query used to display vote total

https://gerrit.wikimedia.org/r/1073905

Change #1073914 had a related patch set uploaded (by Reedy; author: Foks):

[mediawiki/extensions/SecurePoll@REL1_42] SecurePoll: Fixing query used to display vote total

https://gerrit.wikimedia.org/r/1073914

Change #1073915 had a related patch set uploaded (by Reedy; author: Foks):

[mediawiki/extensions/SecurePoll@REL1_41] SecurePoll: Fixing query used to display vote total

https://gerrit.wikimedia.org/r/1073915

Change #1073916 had a related patch set uploaded (by Reedy; author: Foks):

[mediawiki/extensions/SecurePoll@REL1_39] SecurePoll: Fixing query used to display vote total

https://gerrit.wikimedia.org/r/1073916

Change #1073917 had a related patch set uploaded (by Reedy; author: Foks):

[mediawiki/extensions/SecurePoll@REL1_40] SecurePoll: Fixing query used to display vote total

https://gerrit.wikimedia.org/r/1073917

Change #1073917 abandoned by Reedy:

[mediawiki/extensions/SecurePoll@REL1_40] SecurePoll: Fixing query used to display vote total

Reason:

EOL

https://gerrit.wikimedia.org/r/1073917

Change #1073915 merged by jenkins-bot:

[mediawiki/extensions/SecurePoll@REL1_41] SecurePoll: Fixing query used to display vote total

https://gerrit.wikimedia.org/r/1073915

Change #1073916 merged by jenkins-bot:

[mediawiki/extensions/SecurePoll@REL1_39] SecurePoll: Fixing query used to display vote total

https://gerrit.wikimedia.org/r/1073916

Change #1073914 merged by jenkins-bot:

[mediawiki/extensions/SecurePoll@REL1_42] SecurePoll: Fixing query used to display vote total

https://gerrit.wikimedia.org/r/1073914

Reedy closed this task as Resolved.Sep 19 2024, 1:43 AM

Reedy assigned this task to jrbs.

Reedy removed a project: Patch-For-Review.

ReleaseTaggerBot added a project: MW-1.43-notes (1.43.0-wmf.24; 2024-09-24).Sep 19 2024, 2:00 AM

SecurePoll display discrepancy in number of votersClosed, ResolvedPublicActions

Description

Details

Event Timeline

SecurePoll display discrepancy in number of voters
Closed, ResolvedPublic
Actions