search

microsoft / durabletask-mssql

Microsoft SQL storage provider for Durable Functions and the Durable Task Framework
MIT License
87 stars 32 forks source link

Activity start time appears to be earlier than its orchestration start time #37

Closed scale-tone closed 3 years ago

scale-tone commented 3 years ago

I'm observing this: image

Everything was run on my devbox, aka on the same computing instance, so this cannot be explained as clock difference. Is that normal?

cgillum commented 3 years ago

Just so I'm not making assumptions, where are you getting these values from?

scale-tone commented 3 years ago

That's what DurableOrchestrationStatus.History contains, returned by DurableClient.GetStatusAsync(instanceId, true, true, true).

cgillum commented 3 years ago

Just following up on this - sorry for the long delay. Do you remember if your MSSQL instance was on the same box or a remote box/container/service? That's one potential explanation since in some cases the timestamp comes from the local machine and in other cases it might come from the SQL Server instance. I'm otherwise not sure why you'd see this and would need to do a deeper investigation.

scale-tone commented 3 years ago

Database was (still is) in Azure, the rest was running on my laptop. So yes, this would explain that.