Support #292
Missing race data
Status: | New | Start date: | 07/10/2016 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | % Done: | 0% | ||
Category: | database | Spent 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 over 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 over 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 over 6 years ago
- Tracker changed from Bug to Support
changed tracker label from Bug to Support