SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Negative Run Duration


Negative Run Duration

Author
Message
Brian Munier
Brian Munier
Right there with Babe
Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)

Group: General Forum Members
Points: 773 Visits: 80
the t-log job normally takes about 3:16 to run so it is not that long.

The other job normally takes about 1 minute, but on the time it failed, a second report line reported it having a 0 duration.
Brian Munier
Brian Munier
Right there with Babe
Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)

Group: General Forum Members
Points: 773 Visits: 80
Another interesting note: the other node in the cluster is about 5 minutes slower than the node with issues. In fact the node with issues is 5 minutes fast.
george sibbald
george sibbald
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25058 Visits: 13698
Brian, sorry, nothing is jumpimg out at me. As I say I have only seen this when the job ran at the same time as the clocks going back and if memory serves me on very long running jobs which were eventually cancelled or failed.

Interesting the nodes are out, got to be worth getting them in synch. Not sure quite how this would affect it because I would have thought the job would fail if there was a failover whilst the job was running.

---------------------------------------------------------------------
Steve Jones
Steve Jones
SSC Guru
SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)

Group: Administrators
Points: 148330 Visits: 19444
I'm with George. Nothing jumps out. The clocks shouldn't cause this, though you probably want them to get in synch. Could possibly be something there, but I'd think the job would be dependent only on the active node.

If you've got a case to open with MS, this would be interesting to track down, though probably not terribly useful as anything other than trivia.

One last thing, are the jobs running ok, meaning getting the work done? If so, I'd wait for the next reboot, hope it goes away.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Brian Munier
Brian Munier
Right there with Babe
Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)

Group: General Forum Members
Points: 773 Visits: 80
Steve Jones - Editor (12/4/2007)
I'm with George. Nothing jumps out. The clocks shouldn't cause this, though you probably want them to get in synch. Could possibly be something there, but I'd think the job would be dependent only on the active node.

If you've got a case to open with MS, this would be interesting to track down, though probably not terribly useful as anything other than trivia.

One last thing, are the jobs running ok, meaning getting the work done? If so, I'd wait for the next reboot, hope it goes away.

I am not going to open a case with MS. The jobs appear to complete correctly. I will work to get the nodes synched.

Ironically enough, I first noticed the issue after I inadvertently rebooted the node. Oh well we will see.

thanks for your thoughts.
Brian Munier
Brian Munier
Right there with Babe
Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)

Group: General Forum Members
Points: 773 Visits: 80
Well we do have automatic time synching as my problematic node just synched time, so my guess is time has been changing and leading to end times before start times.

Annoying. Of course the real question is how does time synch become so bad?
george sibbald
george sibbald
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25058 Visits: 13698
sounds like a good guess, certainly would fit the scenario.

clocks getting out of synch? over to an intel bod.....

---------------------------------------------------------------------
Steve Jones
Steve Jones
SSC Guru
SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)

Group: Administrators
Points: 148330 Visits: 19444
Clocks get out of synch because the crystal drifts. The internal physical hardware just isn't precise.

That's why you want a "time server" that you sycnh all servers to. They'll correct their individual drifts every hour, day, whatever. You can synch your time server to the US atomic clocks for official time, but more you want all your internal servers to synch.

Alternatively, I used to set an Outlook reminder 2x a month to just manually check a few servers that I knew drifted a lot, and resynch them.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Brian Munier
Brian Munier
Right there with Babe
Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)Right there with Babe (773 reputation)

Group: General Forum Members
Points: 773 Visits: 80
Steve, thanks for the info it is nice to actually know that.

Ironically we do have two time sources to synch from, and they do (hence the problem), and they are supposed to do it regularly like every 15 minutes, so I wonder how they get to 5 minutes out. I hear network issues can cause problems, etc. Five minutes just boggles my mind.

Oh well.

Thanks again for the info and the help.
george sibbald
george sibbald
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25058 Visits: 13698
Steve Jones - Editor (12/4/2007)
Clocks get out of synch because the crystal drifts. The internal physical hardware just isn't precise.



crystal drifts? is that like crystal meths?

---------------------------------------------------------------------
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search