Database locked even when UI says "Finished!"

I watched my Live log in “Profiling” mode during the end of a backup run and it did appear that some of the entries below happened AFTER the status bar had changed to “Finished”.

It might just be due to a delay in getting the live log contents into the web browser, but if not then I could see where this could be confusing. Note that in my case the continued log entries after the “Finished” message showed only lasted 10 seconds or so.

Oct 8, 2017 7:05 AM: Email sent successfully using server: smtp://myServer:12345
Oct 8, 2017 7:05 AM: Whole SMTP communication: Connected to smtp://myServer:12345/?starttls=when-available
Oct 8, 2017 7:05 AM: Running Backup took 00:28:15.570
Oct 8, 2017 7:05 AM: ExecuteNonQuery: DELETE FROM "RemoteOperation" WHERE "Timestamp" < ? took 00:00:00.655
Oct 8, 2017 7:05 AM: Starting - ExecuteNonQuery: DELETE FROM "RemoteOperation" WHERE "Timestamp" < ?
Oct 8, 2017 7:05 AM: ExecuteNonQuery: DELETE FROM "LogData" WHERE "Timestamp" < ? took 00:00:00.891
Oct 8, 2017 7:05 AM: Starting - ExecuteNonQuery: DELETE FROM "LogData" WHERE "Timestamp" < ?
Oct 8, 2017 7:05 AM: ExecuteNonQuery: UPDATE "RemoteVolume" SET "VerificationCount" = MAX(1, CASE WHEN "VerificationCount" <= 0 THEN (SELECT MAX("VerificationCount") FROM "RemoteVolume") ELSE "VerificationCount" + 1 END) WHERE "Name" = ?
1 Like