Device failure and recovery dates can be misleading

[bmfmancini]

I have seen cases where the status_fail_date in the host table is showing before the status_rec_date which would make it appear the devices failed in the future

MariaDB [cacti]> select status_fail_date,status_rec_date   from host where description = 'host' \G;  
*************************** 1. row ***************************
status_fail_date: 2023-01-16 05:16:10
 status_rec_date: 2023-01-16 05:11:06

MariaDB [cacti]> SELECT @@system_time_zone as tz;
+------+
| tz   |
+------+
| EDT  |
+------+

Timezone is correct on the system and the DB

[bmfmancini]

MariaDB [cacti]>  SELECT host_template_id,poller_id,status_fail_date,status_rec_date FROM host
    -> WHERE status_fail_date > status_rec_date AND DATE(status_fail_date) = CURDATE() AND DATE(status_rec_date) = CURDATE();
+------------------+-----------+---------------------+---------------------+
| host_template_id | poller_id | status_fail_date    | status_rec_date     |
+------------------+-----------+---------------------+---------------------+
|                1 |         1 | 2023-01-16 09:49:08 | 2023-01-16 08:42:07 |
|                1 |         1 | 2023-01-16 05:16:10 | 2023-01-16 05:11:06 |
|                1 |         1 | 2023-01-16 09:56:06 | 2023-01-16 09:22:04 |
|                1 |         1 | 2023-01-16 05:16:10 | 2023-01-16 05:11:04 |
|                1 |         1 | 2023-01-16 05:15:11 | 2023-01-16 05:11:05 |
|                1 |         1 | 2023-01-16 05:16:11 | 2023-01-16 05:11:05 |
|                6 |         7 | 2023-01-16 06:18:08 | 2023-01-16 05:42:04 |
|                1 |         1 | 2023-01-16 05:15:08 | 2023-01-16 05:12:03 |
|                1 |         1 | 2023-01-16 05:16:10 | 2023-01-16 05:11:03 |
|                1 |         1 | 2023-01-16 05:15:08 | 2023-01-16 05:12:03 |
+------------------+-----------+---------------------+---------------------+

[TheWitness]

Report back once you have this all tested.

[bmfmancini]

will do

[TheWitness]

Any feedback yet?

[TheWitness]

@bmfmancini, that was for you.

[bmfmancini]

Yes all good

[TheWitness]

Need to keep open until I've ported the changes.

[TheWitness]

Porting complete