Query log entries getting wrong time stamp

Help
1

UPDATE: I fixed this using info found in another post.

I renamed the /etc/pihole/pihole-FTL.db file then did a pihole -r and chose the repair option.

Please follow the below template, it will help us to help you!

Expected Behaviour:

[log entries should be stamped with current system date and time]

Actual Behaviour:

[log entries are getting stamped with 2018-12-31 on every entry]

Debug Token:

_[rzocfd7t39]

2

Additional info that may help:

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Mon Mar 19 10:18:53 2018 from 10.0.0.105
pi@pi-hole:~ $ uname -a
Linux pi-hole 4.9.35+ #1014 Fri Jun 30 14:34:49 BST 2017 armv6l GNU/Linux
pi@pi-hole:~ $ pihole -v
Pi-hole version is v3.3 (Latest: v3.3)
AdminLTE version is v3.3 (Latest: v3.3)
FTL version is v3.0 (Latest: v3.0)
pi@pi-hole:~ $ date
Mon Mar 19 22:34:27 EDT 2018
pi@pi-hole:~ $ cat /etc/os-release
PRETTY_NAME="Raspbian GNU/Linux 8 (jessie)"
NAME="Raspbian GNU/Linux"
VERSION_ID="8"
VERSION="8 (jessie)"
ID=raspbian
ID_LIKE=debian
HOME_URL="http://www.raspbian.org/"
SUPPORT_URL="RaspbianForums - Raspbian"
BUG_REPORT_URL="RaspbianBugs - Raspbian"
pi@pi-hole:~ $

3

Are 100% of the queries getting shown as the wrong date? In your log I see that the date is correct in the dnsmasq log and everywhere there is a date.

4

Yes, they all range from 2018-12-31 00:00 to 2018-12-31 23:59. As new entries are added they seem to have the correct time but have a 2018-12-31 date.

5

Solution from @MikeK

6

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.