It was discovered today that the elections application has a bug that can allow for double submission of ballots on rare occassions. Since this was something that needed to be fixed prior to announcing for voter confidence, I made the db schema change that will throw an error in this case. I'd like to get two after-the-fact +1's for the change.
On db01, change the schema for the elections database, votes table:
alter table votes add constraint election_id_voter_candidate_id unique (election_id, voter, candidate_id);
Two notes: * We generally don't consider modifying data in the db to be a break of freeze. Since this is modifying the schema I figured it should still get a freeze break. * This will prevent duplicate submissions but the user may get a confusing 500 error from the web application if this case is hit. I'll have to look at it in the current and next voting app code to see if that needs modifying to handle the case better. Since there's no elections before freeze is up, I probably won't request a freeze break to fix the ui.
-Toshio
+1 As I would prefer to not have a lot of double votes.
On 26 June 2013 13:34, Kevin Fenzi kevin@scrye.com wrote:
+1
infrastructure mailing list infrastructure@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/infrastructure
Something else you might want to change is automatuically embargoing results. I don't know if it was a setup error or a limitation of the current system, but I happened to check the results about an hour after the election closed and the results were not embargoed at that time.
On Wed, Jun 26, 2013 at 03:07:27PM -0500, Bruno Wolff III wrote:
Something else you might want to change is automatuically embargoing results. I don't know if it was a setup error or a limitation of the current system, but I happened to check the results about an hour after the election closed and the results were not embargoed at that time.
Yeah, it was a setup error. In the past, people who set up the election checked the box to embargo the results. This time that wasn't done so the results were visible the moment the election was over.
-Toshio
infrastructure@lists.fedoraproject.org