topic Hello, in Analyzers

VTune SQLite database is locked

Wadud_M_ — Tue, 13 Feb 2018 14:05:25 GMT

Hi everyone, my desktop machine crashed whilst VTune was open. When I try to open an analysis after the reboot, it says:

The path sqlite-db is locked. Suggestion: verify that you have enough permissions to access the path and make sure your result is not already in another tab or another instance of the project.

Any help will be greatly appreciated.

Wadud.

Similar issue while comparing

Richard_H_1 — Mon, 26 Feb 2018 16:09:02 GMT

Similar issue while comparing two runs I got the message below. ls -Ral <the sqlite path> revealed nothing actionable. I suspect I had the result open in another tab.

I closed VTune and reopened it and things seem to get better.

Intel VTune Amplifier 2018 cannot open the result

Mon 26 Feb 2018 10:57:11 AM EST The path /home/rlh/intel/amplxe/projects/genGarbage/r018ah/sqlite-db is locked. Suggestion: Verify that you have enough permissions to access the path and make sure your result is not already opened in another tab or another instance of the product.

Hello,

Dmitry_P_Intel1 — Fri, 02 Mar 2018 09:04:44 GMT

Hello,

In Wadud's case it might be the case that the result db came to a "bad" state after the machine crash when the result was opened in VTune. You can try to refinalize the result either using UI button on "Analysis target", "Analysis type" or "Collection Log" tabs. In CL the command is the following:

>amplxe-cl -finalize -r <result_path>

Cannot comment much on Richard's case - if one of results to compare was not opened in another tab or in another VTune GUI instance this is unexpected.

BTW general comment - the result directory should have WRITE access for a user so if the collection was done under root by some reason and somebody wants to look at the result under user - they will have the same message about db is locked even if there is read access in the result folder if write permissions are not granted specially. I think we can improve the message on this.

Thanks & Regards, Dmitry