Summary
Starting October 8th, warnings about unexpected inserts in the securepoll_voters table started to pop up in the logs.
Technical notes
Logs here: https://logstash.wikimedia.org/goto/05d3b01bcdc9a3b22b6ebbe8fac54e21
Queries triggering the error are like these:
INSERT INTO `securepoll_voters` (voter_election,voter_name,voter_type,voter_domain,voter_url,voter_properties) VALUES
('123','--REDACTED--','local','www.wikidata.org','https://www.wikidata.org/wiki/User:--REDACTED--', 'a:14:--REDACTED--')and also
SELECT * FROM `securepoll_voters`
WHERE voter_name = '--REDACTED--'
AND voter_election = '123'
AND voter_domain = 'www.wikidata.org'
AND voter_url = 'https://www.wikidata.org/wiki/User:--REDACTED--'
LIMIT 1
FOR UPDATEAcceptance criteria
- The unexpected writes are removed and/or the expectation changed to not produce warning