Ask Your Question
0

agent update time different from system time

asked 2013-12-03 06:36:40 -0500

tsjsdbd gravatar image

system time is:

root@controlH:/etc/init.d# date
Tue Dec  3 20:32:57 EST 2013

so it is 2013-12-03 20:32:57 now.

but the agent update time is:

+---------------------+---------------------+------------+----+------------+------------------+
| created_at          | updated_at          | deleted_at | id | host       | binary           |
+---------------------+---------------------+------------+----+------------+------------------+
| 2013-11-28 14:32:49 | 2013-12-04 01:33:56 | NULL       |  1 | controlH   | nova-cert        |
| 2013-11-28 14:32:50 | 2013-12-04 01:33:56 | NULL       |  2 | controlH   | nova-conductor   |
| 2013-11-28 14:32:50 | 2013-12-04 01:33:56 | NULL       |  3 | controlH   | nova-consoleauth |
| 2013-11-28 14:32:50 | 2013-12-04 01:33:56 | NULL       |  4 | controlH   | nova-scheduler   |
+---------------------+---------------------+------------+----+------------+------------------+

you will find it updated at 5 hours later... and here is some info about mysql:

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2013-12-03 20:33:26 |
+---------------------+
1 row in set (0.00 sec)

so the mysql's time should be right.

mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | EST    |
| time_zone        | SYSTEM |
+------------------+--------+
2 rows in set (0.00 sec)

any idea? what can i do?

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

answered 2013-12-04 00:38:58 -0500

unmesh-gurjar gravatar image

AFAIR, the created_at and deleted_at fields are UTC time (and not your locale time zone), so the difference.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2013-12-03 06:36:40 -0500

Seen: 71 times

Last updated: Dec 04 '13