Support #292

Missing race data

Added by Walter Pate almost 6 years ago. Updated almost 6 years ago.

Status:NewStart date:07/10/2016
Priority:NormalDue date:
Assignee:Jamie Pate% Done:

0%

Category:databaseSpent time:7.00 h
Target version:1.3.36

Description

It has been observed that race data can go missing at times

History

#1 Updated by Walter Pate almost 6 years ago

During the LQMA points race 4 there was an issue with the lineups moscore generated in the last 4 races.
The tower staff made a backup of the database during the break between race 5 and 6.)see below)then started to investigate
Race 6 then started while the tower staff was investigating race setups on the background computer.This brought an SQL error (Missing Child) and locked up the scoring computer.
After everything was restarted it was found that the first 5 races in the mains lost their race data
I did a backup of the finish of the race day, and LQMA Tower staff will be emailing me the unhandled exception debuglog

Backup of July 9 LQMA points race 4 with first 5 races complete.
https://drive.google.com/file/d/0BwPAMMft-rVwelBzM0k2SUEyWlk/view?usp=sharing
Backup of race finish with first 5 races missing
https://drive.google.com/file/d/0BwPAMMft-rVwV09lZE5BSXdJclU/view?usp=sharing

#2 Updated by Walter Pate almost 6 years ago

I just remmebered when the SQL error code happened an what made the error pop up.
In Race 6 (second database) lap 17 there was a yellow flag
(That is when the background computer staff was making changes)
The race computer operator showed me the error that popped up (missing Child) as she tried to mark a car with a charged yellow
I tried it and when you clicked on the yellow flag beside any car number this error popped up

#3 Updated by Walter Pate almost 6 years ago

  • Tracker changed from Bug to Support

changed tracker label from Bug to Support

Also available in: Atom PDF