Free Republic
Browse · Search
General/Chat
Topics · Post Article

To: Gene Eric
I think the biggest problems come from transaction reconciliation or log shipping and/or replicaton on very fast databases. However, your transaction logs and such should be aware that both a 59 and 61 second minute is possible.

I can't think of many systems that would crater over a 61-second minute, then again, nothing I support these days considers time that critical. I have worked on systems where it would have mattered though. It was a really kick-ass fault tolerant unix box (Stratus) that processed and cut call detail records. Billing could easily have been impacted by something like that, but we had programmers who knew that, and actual test systems that we could test with.

This was back when Y2K was a thing, and we actually tested the Y2038 issue as well, when the unix 'time' counter rolls over. That had interesting results.

Speaking of which 2028 is coming.... glad I'll be retired by then.

35 posted on 07/26/2022 3:04:44 PM PDT by zeugma (Stop deluding yourself that America is still a free country.)
[ Post Reply | Private Reply | To 32 | View Replies ]


To: zeugma

The article mentions 23:59:60 implying the correction happens at the end of the day, but I imagine a correction would be less disturbing by sitting on 12:00:00 AM for the extra second given the disturbance can be washed over the following minutes. But the question, which time zone? Perhaps UTC -12:00

The article doesn’t correctly explain “32-bit” Unix issue. A 32-bit number can easily take us into the next millennium (0..4,294,967,295). The issue concerns the signed 32-bit number which we know is limited to the max value of 2147483647 (-2147483648..2147483647)

Good points regarding replication and minute granularity. Another reason why likely better to hold on the initial second of the hour at UTC -12:00.


37 posted on 07/26/2022 4:59:51 PM PDT by Gene Eric (Don't be a statist!)
[ Post Reply | Private Reply | To 35 | View Replies ]

Free Republic
Browse · Search
General/Chat
Topics · Post Article


FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson