Noticed some queries with a date 7 years in the future, from the year 2032, in the FTL database after upgrading from v5 to v6

[armujahid]

I use dockerized pihole that I upgraded to v6 and my FTL DB was also migrated. everything seems to be working flawlessly except that on Query log page, I was seeing 13 to 14 pages of queries from the year 2032 (e.g. with timestamp 1966402048) after the upgrade that was basically breaking query log page (because it keeps showing recent queries from 2032 and I had to scroll 13-14 pages to see queries from 2025).

Solution:

0. Stop container (Although I didn't do that lol.)
1. Delete those problematic queries using
   sqlite3 "etc-pihole/pihole-FTL.db" "DELETE FROM query_storage WHERE timestamp > 1792597994"
2. Restart container

Posting this here because I thought this might be useful.

Note that I use custom image GitHub - jacklul/pihole-updatelists: Update Pi-hole's lists from remote sources easily although I am 95% sure that this issue was not because of that.