jdporter helpfully sent me a note that last hour of cb was out of whack. I don't really know what the problem was (other than a lack of logging! I'll have to add that in as I find time), though the Windows-standard solution worked (restart the daemon, not the whole machine). Then I found this interesting tidbit. The time stamp associated with CB messages is in the future of what my clock says the current time is, by over 2 minutes. Corion pointed out the Tick Tock nodelet, and I noticed that the CB message time stamp is in the future of what PM says the current time is as well.

Maybe there's a server involved somewhere here where the ntp daemon isn't running/working, keeping the timestamps in sync?

Corion also seemed to suggest that the Tick Tock nodelet maybe should use select NOW() from dual instead of the localtime, but I'm not sure what type of extra hit the db would take on something like that. A working ntp daemon seems more prudent to me :-)

Note that the only effect this has on last hour of cb that I can be sure of is that anything from the future gets excluded in my SQL: "STAMP > ? AND STAMP <= ?" (so that messages that come in while I'm processing all this don't get included later).

While writing this, Athanasius also suggested in the CB that "Someone just posted a node “-3 seconds ago” !" - so the aesthetic effect is a bit bigger than just what I noticed. :-)

In reply to Timestamp issues by Tanktalus

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.