On Thu, Feb 02, 2006 at 09:28:36AM +0100, Sebastien Guilbaud wrote:
I always have a difference of one hour in my database
between these columns :
stamp_inserted stamp_updated
2006-02-02 10:10:00 2006-02-02 09:16:26
Are you using the newly released 0.10.0rc1 version ? If yes, do you
remember of having seen such behaviour before ? Which of the two times
is the right one ? Do you see stamp_inserted values rolling regularly
(i mean: 2006-02-02 10:10:00, 2006-02-02 10:20:00, 2006-02-02 10:30:00,
etc.) ? I'm still trying to figure out why it behaves this way; however
the problem should lie within pmacct as it gives the values to both
fields. Stay tuned.
Thanks for your quick handling of my little issue :)
I've tried with the latest version, but i've seen this behaviour
in the 0.9 series.
The right time is in stamp_updated, stamp_inserted always stays
one hour ahead of stamp_updated, modulo my sql_history value (5 mn) :
here are my latest values :
2006-02-02 10:21:00 2006-02-02 11:15:00
2006-02-02 10:25:00 2006-02-02 11:20:00
2006-02-02 10:26:00 2006-02-02 11:20:00
2006-02-02 10:30:00 2006-02-02 11:25:00
2006-02-02 10:30:00 2006-02-02 11:25:00
2006-02-02 10:35:00 2006-02-02 11:30:00
2006-02-02 10:36:00 2006-02-02 11:30:00
2006-02-02 10:40:00 2006-02-02 11:35:00
2006-02-02 10:41:00 2006-02-02 11:35:00
2006-02-02 10:45:00 2006-02-02 11:40:00
2006-02-02 10:45:00 2006-02-02 11:40:00
have a nice day
--
Sébastien Guilbaud - Oceanet Technology
