Missing Data

Question

Is there a problem with historic_races, I am only seeing data up until the 19th June?

Answer 1

Think I see the problem, my updater runs on a schedule and is crashing at daily_betfair_mappings so historic tables not updating, I have not noticed this due to it being scheduled.....

Fetching data from: https://www.betwise.co.uk/smartform_data/XXXX/XXXXXXXXXXXX/NNNNNNNNNN/advance_racecards_beta.sql
Fetching data from: https://www.betwise.co.uk/smartform_data/XXXX/XXXXXXXXXXXX/NNNNNNNNNN/daily_updates.sql
Fetching data from: https://www.betwise.co.uk/smartform_data/XXXX/XXXXXXXXXXXX/NNNNNNNNNN/daily_updates_beta.sql
Fetching data from: https://www.betwise.co.uk/smartform_data/XXXX/XXXXXXXXXXXX/NNNNNNNNNN/daily_betfair_mappings.sql
could not execute SQL statement:
Error 1062 (23000): Duplicate entry '1235344-2524093' for key 'daily_betfair_mappings.PRIMARY'

Answer 2

Looks like you've spotted the problem below.   It's due to the daily_betffair_mappings being fixed ffor Royal Ascot after data had already been updated on the master server.   To fix it, run:

delete from daily_betfair_mappings where date>"2023-06-19";

The updater for all feeds should work fine after that, and also fill in the missing days on daily_betfair_mappings.