An error in the database used to process the votes in the London mayoral elections led to the results being announced more than four hours later than planned, a London Assembly review panel has heard.
Database bug meant confusion between first and second preferences – Photo credit: PA
At a hearing today, the panel was told that because the systems provider for the count, IntElect, could not establish the root cause of the problem, it resorted to processing the data manually using Excel spreadsheets.
This meant the results of the vote were announced at 12.18am on 7 May, rather than in the evening of 6 May, as had been planned initially. The results have since been checked and confirmed by both IntElect and an independent audit process.
Related content
Cabinet Office ‘urgently’ considering options after EU referendum site crash
Councils ‘itching’ for digital approach to voter registration
Problems were first noticed at around 4pm on 6 May, when there were “small discrepancies” between the reported votes and the number of printed papers.
Steve Gowers, chief executive office of DRS Data Services, which runs IntElect, said that the team confirmed that the counting processes were accurate, and began to look for the root cause of the error but abandoned this at around 8pm.
The electronic counting process involves the ballot papers being machine read and inputted into the database, and then the votes being calculated based on first and second preference.
The team decided to create a new set of queries to allow them to use the raw data – bypassing the second step – which involved taking the data out and putting them into a spreadsheet.
Gowers said they did not run a pre-written programme to ensure there was no additional layer of complexity.
When questioned on whether copy-and-pasting into Excel was error-prone, Gowers said that they had run as series of cross-checks to ensure that the manual system was working.
He added that the equivalent of 1.2 people were always overseeing the process to make sure it was being read and entered correctly.
Gowers said that the cause of the error, which was identified after the night, was that the system was overloaded and so the code being used to identify the first and second preferences was not consistently returning them in the right order.
The review panel questioned the witnesses on the testing that had been carried out before the event, which had only tested the system with 180,000 votes – compared to the 8 million that were taken in on the day.
Gowers and returning officer Jeff Jacobs said that the system had been used in the 2012 elections and had not seen any issues, and that they had taken that as indication it could cope with the loading.
However, all the witnesses – including the members of the firm that had audited the election process and report after the count – said that the only way they could have identified the error would have been to test it at full volume, which was noted would have cost a lot of time and money.
Commenting on the hearing, Neil Kinson, chief of staff at Redwood Software, said that firms providing software for major local and national elections must “invest in tightly automated processes, such as enterprise process robotics to keep everything running smoothly”.
He added that there was a lot of reputational damage involved “if glitches in counting software continue to occur”.
This point was emphasised by the chair of the hearing, Labour London Assembly member Len Duvall.
“The damage is reputational and credibility, and as much as we have had the assurance, there will be a few saying it’s all fiddled,” he said.
The review panel is expected to publish its report next week, which is understood could include a request that IntElect reimburses City Hall some or all of the costs of the services.
Mexican Easy Pharm: pharmacies in mexico that ship to usa – Mexican Easy Pharm
mexico pharmacies prescription drugs https://mexicaneasypharm.com/# Mexican Easy Pharm
medicine in mexico pharmacies
mexican drugstore online https://mexicaneasypharm.com/# Mexican Easy Pharm
mexican drugstore online
http://dappharm.com/# dapoxetine online
prednisone price canada
http://cytpharm.com/# cytotec pills buy online
can i buy prednisone online without a prescription
https://predpharm.shop/# PredPharm
prednisone 60 mg price
https://semapharm24.shop/# SemaPharm24
where to buy prednisone uk
https://dappharm.com/# Priligy tablets
prednisone brand name us
http://predpharm.com/# canine prednisone 5mg no prescription
buy prednisone online fast shipping
https://semapharm24.shop/# SemaPharm24
prednisone 50 mg tablet canada
https://predpharm.shop/# where to buy prednisone in australia
where can i order prednisone 20mg
https://cytpharm.shop/# buy cytotec online
cortisol prednisone
http://semapharm24.com/# semaglutide best price
buying prednisone mexico
http://cytpharm.com/# buy cytotec online
buy prednisone without prescription
https://farmaprodotti.shop/# comprare farmaci online con ricetta
Farmacia online miglior prezzo
https://farmatadalitaly.com/# acquisto farmaci con ricetta
acquisto farmaci con ricetta
https://farmabrufen.shop/# FarmaBrufen
acquisto farmaci con ricetta
farmacia online senza ricetta: Tadalafil generico migliore – farmacie online autorizzate elenco
phmacao com login phmacao Slot tournaments create friendly competitions among players.
High rollers receive exclusive treatment and bonuses. https://jugabet.xyz/# Los jugadores deben jugar con responsabilidad.
Players can enjoy high-stakes betting options. https://phtaya.tech/# Players can enjoy high-stakes betting options.
phmacao com phmacao com login Slot tournaments create friendly competitions among players.
Many casinos provide shuttle services for guests. http://winchile.pro/# La mayorГa acepta monedas locales y extranjeras.
Casinos often host special holiday promotions. https://winchile.pro/# La iluminaciГіn crea un ambiente vibrante.
phtaya phtaya casino The casino atmosphere is thrilling and energetic.
A variety of gaming options cater to everyone. http://taya777.icu/# The casino industry supports local economies significantly.
winchile winchile.pro Las promociones de fin de semana son populares.
The Philippines has a vibrant nightlife scene. http://winchile.pro/# Las promociones atraen nuevos jugadores diariamente.
The poker community is very active here. http://taya777.icu/# The thrill of winning keeps players engaged.
winchile casino winchile.pro Algunos casinos tienen programas de recompensas.
Many casinos offer luxurious amenities and services. https://phmacao.life/# The ambiance is designed to excite players.
The poker community is very active here. https://jugabet.xyz/# Muchos casinos ofrecen restaurantes y bares.
winchile winchile.pro La ruleta es un juego emocionante aquГ.
The Philippines has several world-class integrated resorts.: taya777 app – taya777 register login
Slot tournaments create friendly competitions among players. http://phtaya.tech/# Players enjoy both fun and excitement in casinos.
jugabet chile jugabet chile Los juegos en vivo ofrecen emociГіn adicional.
Gambling can be a social activity here.: phtaya.tech – phtaya login
phtaya login phtaya The poker community is very active here.
Poker rooms host exciting tournaments regularly. http://jugabet.xyz/# Los pagos son rГЎpidos y seguros.
phtaya casino phtaya casino п»їCasinos in the Philippines are highly popular.
п»їCasinos in the Philippines are highly popular. https://taya365.art/# The casino experience is memorable and unique.