メインコンテンツへスキップ

⚠️ Please note that this topic or post has been archived. The information contained here may no longer be accurate or up-to-date. ⚠️

SQLite error 5: Database is locked

macarjan2
Hello,

When I start a session on my local server i get the notification:

An error occurred and the session "session name" must close.
An unrecoverable error was encountered while working with the session database.

SQLite error 5 : database is locked

This session will now close.

Wehn I copy the whole session with the capture files to my desktop, there is no problem.

Can some one help me with this problem?

I am using Capture One Pro 9.0.3
OSX 10.11.3 (El Capitan)
0

コメント

12件のコメント

日付 投票
  • Perttis
    Close capture one
    find your catalog "CaptureOne Catalog.cocatalog"
    right click it and select "show package content"
    there should be "writelock" file , delete that file
    start your capture one

    ups..should read more carefully...this help is only for catalogs, not sessions
    0
  • BeO
    Top Commenter
    [quote="Perttis" wrote:

    ups..should read more carefully...this help is only for catalogs, not sessions


    Sure? A session.cosessiondb is almost the same...
    0
  • SFA
    Reboot to see if it clears?

    Possibly a good idea anyway if there is a chance that something messy has happened.


    Grant
    0
  • Permanently deleted user
    Similar is also happening to me, using a Session in Capture One 9.2.1, everything works fine on my/any Mac, but when I start using a C1 Session that's stored on the QNAP NAS/DAS via Thunderbolt, all seems to be working fine, scrolling images, editing images, then after about 10 or so minutes.. bam! the Capture One Session crashes with this error:

    "An error occurred and the session "2016_08_27 - MISC" must close." "An unrecoverable error was encountered while working with the session database. database is locked. The session will now close."
    and:
    "An error occurred and the session "2016_08_27 - MISC" must close." "An unrecoverable error was encountered while working with the session database. cannot start a transaction within a transaction. The session will now close."

    Does anyone have any idea why this is happening?!?!

    Thanks!
    0
  • OddS.
    [quote="RJKP" wrote:
    ...Does anyone have any idea why this is happening?!?!


    I don't. Is your SQLite database file located on a networked disk (NAS)? If yes, subtle file system differences may cause trouble and you should try using a database on a local disk, a disk physically connected to the computer where SQLite program code executes. Accessing, never mind sharing, a SQLite database via a network file system, may not work as hoped.
    0
  • Permanently deleted user
    Thanks for the reply.

    I don't know what that file is or where to find it, all's I know, is that all of the C1 program is installed and running locally on the MacBook Pro, and I copied the whole single session folder over to the NAS to work on it from there. It worked perfectly for a few minutes, but then crashed with above errors.

    Tech support gave a pretty dismal response, basically saying: NAS etc have known issues working with Capture One at the moment, blah, blah, it's best to work from your desktop, blah, blah, we are looking for solutions, blah, but you really need to just work from your computer and back up to the NAS.

    Really disappointing that there wasn't even anything they wanted me to try or test, just 'give up and work on the desktop'.

    Other programs I tested on the NAS worked fine.

    C1 Sessions are supposed to be able to be moved around independently of the main Catalogues etc., and moving them to storage and off my main (limited space) computer was one of the main reasons I wanted to start working with sessions.

    Surely it can't be that hard for them to figure out?
    0
  • OddS.
    [quote="RJKP" wrote:
    ...Other programs I tested on the NAS worked fine.


    I expect those other programs to be multithreaded, run SQLite program code on your computer and access remote SQLite database files on that NAS.

    I do agree then, it may seem a bit arbitrary that you only experience SQLite problems with Capture One while the other programs work fine. On the other hand, the SQLite when-to-use document https://www.sqlite.org/whentouse.html has a "Checklist For Choosing The Right Database Engine". The list has 4 checkpoints, of which only the last one leads to SQLite rather than to a client/server alternative:

    1. Is the data separated from the application by a network? → choose client/server
    2. Many concurrent writers? → choose client/server
    3. Big data? → choose client/server
    4. Otherwise → choose SQLite!

    Phase One obviously answered "No" for items 1-3 and landed on item 4 and SQLite.

    [quote="RJKP" wrote:
    Surely it can't be that hard for them to figure out?


    You apparently wanted Phase One to have answered yes for checklist item 1 and possibly also yes for item 2 and then developed Capture One accordingly, but they didn't. Modifying the current application to combine SQLite with a yes to item 1 and possibly also a yes to item 2, may turn out to be a taller order than one would expect.

    Until the matter is resolved, your best bet may be to just honor recommendations from Phase One.
    0
  • Permanently deleted user
    [quote="RJKP" wrote:
    ..."An error occurred and the session "2016_08_27 - MISC" must close." "An unrecoverable error was encountered while working with the session database. database is locked. The session will now close."
    and:
    "An error occurred and the session "2016_08_27 - MISC" must close." "An unrecoverable error was encountered while working with the session database. cannot start a transaction within a transaction. The session will now close."
    ..


    Some confusion here.. My situation might be slightly different to the OP, we both have "database is locked" though, which I thought was the main point. As I'd quoted above, my errors don't mention "SQLite error 5" at all, and so all this talk of 'SQLite' is not only going right over my head, am not sure it even applies to me?

    As far as 'what I apparently want' Capture One to have developed.. Ah, well, now you mention it, let's just say that:
    • It sounds like they've had this problem for a little while now, it does NOT sound like it's new to version 9..
    • Many, many, more people these days are needing to work from other/shared storage sources than their limited storage capacity laptop/desktops (my test unit had a paltry 120gb SSD, can't store much there after OS/Apps/etc), and this 'work from a NAS/server' functionality should DEFINITELY be a part of how the program works!
    • Version 9 came out not too long ago, and this is a very important part of how people use their software that should have been addressed in their latest release. Sorry, sad but true.

    Bottom line: I'm sure other companies have fixed MASSIVELY more complex issues for all their users to work on servers than this.

    As an aside, I understand there can be issues with the way some files are accessed if someone else already has them open etc. in shared storage, but 1. Adobe has been able to block the 2nd person accessing the file for ages, in my experience anyway, and 2. My experience with Capture One errors on the NAS was from only 1 user connected to the whole machine, myself, same error wether through Thunderbolt or 1GbE Network cable. So the attempted access by someone else doesn't seem to be the problem in my case. But because they don't even want to discuss it or even ask me any more questions about it.. who knows?!?!

    Haha, oh dear, you've just outright confused me on what was supposed to be helpful about this comment, was it just meant to stir me up?: "Until the matter is resolved, your best bet may be to just honor recommendations from Phase One."

    Honour them?? Hahaha, their software won't work the way I/we need it to, they have absolutely NO suggestions/workarounds/etc at all! ..and therefore I don't have ANY choice anyway!! ... I simply CAN'T use it the way I want, it's not a recommendation, it's a brick wall. Hahaha, thanks anyway.
    0
  • OddS.
    [quote="RJKP" wrote:
    ...I understand there can be issues with the way some files are accessed if someone else already has them open etc. in shared storage, but 1. Adobe has been able to block the 2nd person accessing the file for ages


    I wonder if you are mistaking concurrent writer and second user to mean the same thing. Parallel threads/processes within one active instance of one application, with or without a human operator involved, may be concurrent writers.
    From what I read in Adobe forums, Lightroom users face the same challenges as Capture One users do, so do users of quite a few other applications with SQLite. The remedy is to obey by the SQLite requirements and the checklist is the right place to start.

    Many users of Capture One (and Lightroom) apparently believe the application already comes with client/server features. I wonder though, if all those photographers would be up to the task of installing and managing a SQL server product. The ease of end user installation/setup and the "no-maintenance-required" are two well known reasons for choosing SQLite.

    If Phase One finds a workaround for your locking problem, then good for you. In the mean time I think you should just follow their advice and keep database file(s) on a disk local to the running SQLite code.

    If you can not wait for Phase One to conclude nor live without a client/server solution, you could try one of those free DAM systems or buy a first class commercial one (PhotoStation for example, see https://www.fotostation.com/ for a two week trial) and use it with Photoshop or other image editor, mabe even Capture One. Even simpler: Use Lightroom if you trust Adobe ages ago implemented a safe mechanism for SQLite over a network.
    0
  • peter Frings
    Good afternoon OddS,

    [quote="OddS" wrote:
    [quote="RJKP" wrote:
    .
    If you can not wait for Phase One to conclude nor live without a client/server solution, you could try one of those free DAM systems or buy a first class commercial one (PhotoStation for example, see https://www.fotostation.com/ for a two week trial)


    Do you have a particular free DAM system in mind? I tried searching for one (for the mac), but I did found not much. A pointer would be welcome!

    Thanks,
    Peter.
    0
  • OddS.
    [quote="peter.f" wrote:

    Do you have a particular free DAM system in mind? I tried searching for one (for the mac), but I did found not much. A pointer would be welcome!



    There is a list at http://www.opensourcedigitalassetmanage ... ource-dam/ but you have probably investigated it already.

    I think it is important to map out your needs first if you have not done so already. I planned to use a kind of weighted decision matrix because there is hardly any DAM (free or non-free) that will do everything, at least not the way I prefer. May I suggest that you read a two years old blog post "Is there a future for DAM systems? Yes" by the Swedish wine photgrapher Per Karlsson, http://www.bkwinephotography.com/techno ... stems-yes/ and also read the articles linked to in that blogpost.

    My own DAM quest is currently on the backburner and has been there for several years. I am one of those diehard Photo Mechanic users patiently waiting for the PM version with catalog to emerge. It may still take one more year, but life is ok with PM as my front end and back end application to Capture One sessions.
    0
  • peter Frings
    [Sorry for the off-topic posts. I'll stop after this one, promise!]

    Thanks for the pointers! Indeed, I had a look at those before, but found none to my liking. I still hope C1 gets it right some day, although I'm less optimistic now than I was a year ago...

    Cheers,
    Peter.
    0

投稿コメントは受け付けていません。