Bug Reports

If you identify any API bugs or errors in the data please record them here.

212 Responses to “Bug Reports”

  1. Admin says:

    Thanks to work by Miguel Bento the lap times for the Belgian and Italian Grand Prix are now available.

  2. Toby says:

    Hi Chris
    In case you’re not already aware but there seems to be an issue with the lap times data again after Singapore.
    Cheers
    Toby

  3. Admin says:

    Hi Toby,
    Yes, there’s an ongoing problem with the import of the lap times so they’re likely to be late. Try now.
    Chris

  4. Toby says:

    Hi Chris
    It seems as though the COTA lap times are available through the API but not yet updated on the disk image (which says last updated yesterday). Is this as expected?
    Cheers
    Toby

  5. Admin says:

    Hi Toby,
    That’s odd. As it’s easier than checking, I’ve created a new dump and updated the date. Let me know if the problem remains.
    Thanks,
    Chris

  6. Bob Phillips says:

    there are results for 111 drivers that are not in the drivers table. For example drivers 800 to 816 are some of the driverIDs in the results table that are not in the drivers table. Also, team 201 is missing. Also, there are some drivers that have 2 results for a race. For example driver 624 for race 788 has two results. What is the meaning of the two results? Is this an error did he take over a team mates car after a wreck?

  7. Bob Phillips says:

    Sorry, missing drivers is error on my part. Still remains the question about why some drivers have two results for the same race. Thanks.

  8. Admin says:

    Hi Bob,
    Drivers sharing or swapping cars was an interesting feature of early races – difficult to imagine nowadays!
    Chris

  9. TK says:

    Hi Awesome Ergast Admin(s),

    Just noticed Jacques’s laptimes for the 2004 Chinese GP are linked to Trulli instead.

    2004’s the season where Trulli drove for Renault for rounds 1 to 15, skipped 16 (China), and jumped over to Toyota for rounds 17 and 18. Villeneuve took over Trulli’s seat at Renault for rounds 16, 17, and 18.

    https://en.wikipedia.org/wiki/Renault_in_Formula_One#2004_season

    https://en.wikipedia.org/wiki/2004_FIA_Formula_One_World_Championship#Drivers.27_Championship

    Anyway, here are the IDs and some verification queries.

    # 2004 China :: raceId = 105
    # Trulli :: driverId = 15
    # Villineuve :: driverId = 35

    # Jacques’s and Trulli’s records in drivers
    select *
    from drivers
    where driverId in (15,35); # 15 is trulli, 35 is Jacques

    # raceId for 2004 China
    select *
    from races
    where raceId = 105;

    # query showing Jacques’s laptimes for 2004 China are all associated with Trulli
    select *
    from laptimes as l
    join drivers as d on d.driverId = l.driverId
    where l.raceId = 105 AND d.driverId in (15,35); # 15 is trulli, 35 is Jacques

    AFAICT, the records in the results table are fine. Villeneuve has results for rounds 16 to 18. Trulli has results for rounds 1 to 15, 17, and 18.

    select driverRef, c.name, races.*
    from races
    join results on races.raceId = results.raceId
    join drivers d on d.driverId = results.driverId
    join constructors c on c.constructorId = results.constructorId
    where year = 2004
    AND d.driverId in (15,35)
    order by round;

    Thanks for maintaining a fantastic project!!!

    TK

    # temp fix?
    update laptimes
    set driverId = 35 # Jacques
    where raceId = 105 # China
    AND driverId = 15; # Trulli

  10. Admin says:

    Thanks TK,
    I’ve reviewed and applied your fix.
    Chris

  11. TK says:

    Hi Chris,

    Found a few other items for laptimes.

    The first one appears to just require relinking the laptimes to the correct driver.

    – 2014 Brazilian GP (raceId=917)
    — Kevin Magnussen’s times (driverId=825) are linked to the “original” Magnussen (driverId=76). The laptimes and positions match up with other published records I found.

    I wasn’t able to find laptimes and positions for the next ones, but they might just be linked to the wrong driver.

    – 1997 European GP (raceId=223)
    — Fontana’s times (driverId=82) are missing and might be linked to Morbidelli (driverId=81). Morbidelli had an injury (or injuries) and retired before the season ended. Fontana subbed for Morbidelli for this race.

    – 1999 San Marino GP (raceId=177) and Spanish GP (raceId=179)
    — Salo’s times (driverId=63) are missing and might be linked to Ricardo Zonta (driverId=41). Zonta was injured during practice in Brazil (round 2) and was subbed by Salo for the next three races (these two, plus Monaco).

    – 2001 Italian GP (raceId=155)
    — Alesi’s times (driverId=55) are missing and might be linked to Trulli (driverId=15). Trulli retired in the first lap, but has laptimes linked for this race.

    The next two might be missing records and just need to have them re-ingested.

    – 1999 Monaco (raceId=178)
    — Salo (driverId=63) doesn’t have laptimes, but the results table and wiki say he completed 36 laps. However, there don’t appear to be any incorrectly linked laptime records for this race.

    – 1999 Brazilian GP (raceId=176)
    — Sarrazin (driverId=72) doesn’t have laptimes, but the results table and wiki say he completed 31 laps. However, like the instance above, there don’t appear to be any incorrectly linked laptime records for this race.

    This last one might be tricky (or maybe not).

    – 2009 Italian GP (raceId=13)
    — Alguersuari (driverId=153) completed 19 laps in this race, but doesn’t have any laptime records. Webber (driverId=17) actually retired in the first lap, but has 52 laptime records associated to him. But that’s too many records to match Alguersuari’s lap count for this race (19 vs 52). However, Buemi (raceId=67) completed 52 laps, but only has 19 records; which matches Alguersuari’s number. So, maybe Webber has Buemi’s records, while Buemi has Alguersari’s. Might be easier to just drop all the laptime records for that race and just reimport the data.

    Later,

    TK

  12. Admin says:

    Thanks TK – I’ll work on these when the season closes.
    Chris

Add a Comment: