Issue querying with time


#1

I backed up and restored 1.3 influxdb to 1.7 version.
After the restore, I found that an query I was running earlier(returning 13 rows) was not returning results.
Here are the details…
Pre backup 13 results
Query:
select time,app_name from custom_ABCTest where “product_name”=‘First’ and time > now()-7d
time app_name


1552321128186000000 xyzchanges
1552321860375000000 xyzchanges
1552324380889000000 xyzchanges
1552330124695000000 defui
1552331817265000000 defmetrics
1552331821888000000 defprocessor
1552331830809000000 defuiservice
1552332255142000000 xyzchanges
1552332261778000000 defrservice
1552332266204000000 defcservice
1552332270692000000 deffchanges
1552332274689000000 defsearches
1552332280367000000 defcsservice

After restore and on the new 1.7 influxdb, the same query does not return resultsQuery:
select time,app_name from custom_ABCTest where “product_name”=‘First’ and time > now()-7d

But if I change the query to -59 days, it returns the results…
select time,app_name from custom_ABCTest where “product_name”=‘First’ and time > now()-59d
time app_name


1552321128186000000 xyzchanges
1552321860375000000 xyzchanges
1552324380889000000 xyzchanges
1552330124695000000 defui
1552331817265000000 defmetrics
1552331821888000000 defprocessor
1552331830809000000 defuiservice
1552332255142000000 xyzchanges
1552332261778000000 defrservice
1552332266204000000 defcservice
1552332270692000000 deffchanges
1552332274689000000 defsearches
1552332280367000000 defcsservice

Any idea, what caused this to happen?


#2

Hi that is indeed very strange ,
The only thing i can think of is the current system time on your servers but i guess they are correct :slight_smile:


#3

I checked the current system times. Both are same.
Thanks,


#4

Maybe you can try a stop / start of the database ?