pieceofsummer / Hangfire.Console

Job console extension for Hangfire
MIT License
436 stars 80 forks source link

Console lines not ordered correctly on completed jobs #82

Open mortenbock opened 5 years ago

mortenbock commented 5 years ago

We have some jobs with quite a few console l entries. But when I open a completed job, the lines seem to be more or less randomly mingled together, and not be in cronological order.

We use the Sql storage, and it seems that the order we see comes from the GetRangeFromSet query, which has no ordering specified. If I run that sql manually, I get the same random ordering, probably based on however the Sql server decided to store the rows.

Is it possible to sort the lines before outputting them to the dashboard?

mortenbock commented 5 years ago

We're running Hangfire.SqlServer 1.6.24, and it looks like they have changed that query in the later versions to sort correctly, so I will look into if we can upgrade.

Still, it might be useful to sort explicitly, if the GetRangeFromSet contract does not ensure sorting.