Dear SQLIters,

I use datetime('now') to record when a job gets started and stopped. As soon as 
a job stops, new is started. Thus stop of the previous should be within a 
second of the start of the next, as you see in the first few lines. But then 
the clock jumps.

Job 1847 ends at 16:44:11 and job 1852 starts at 18:47:46 (and actually 
subsequently dies as evidenced by its stop being NULL). Next job, 2283, is 
started BEFORE job 1852. RunID is INTEGER PRIMARY KEY and for this purpose is 
auto incrementing. Jobs are also running on other nodes, therefore runID is not 
contiguous for this node.

runID      hostname   start               stop
---------- ---------- ------------------- -------------------
1841       loginnode4 2018-05-14 07:53:42 2018-05-14 10:05:41
1843       loginnode4 2018-05-14 10:05:41 2018-05-14 12:18:05
1845       loginnode4 2018-05-14 12:18:05 2018-05-14 14:30:50
1847       loginnode4 2018-05-14 14:30:50 2018-05-14 16:44:11
1852       loginnode4 2018-05-14 18:47:56
2283       loginnode4 2018-05-15 18:18:59

Could it indicate other issues than the clock itself? It is highly unlikely 
that clock happened to jump forward at the time when 1852 was finishing (at 
16:44:11). Time of start of 2283 looks correct, agrees with my watch, because I 
started this job manually.

sqlite-users mailing list

Reply via email to