tfoltyn said:

• whenever I try to create a new sdlxliff file for translation (it pretty much makes no difference whether it's through 'Open Document' or 'New Project'), I receive the following error "An error has occurred whilst using the translation provider XXXX: The translation memory data file engine returned an error: The database file is locked / database is locked." error. What's more, it takes around 10 minutes for the 'error window' to actually appear, and I can do nothing but wait. Then the only thing I can do is add the respective TMs manually via Project Settings and hope that the error window won't re-appear. This works only at times and more often than not the error window does re-appear and I have to start from scratch again and do nothing but hope again. 

Hi Tomas,

I'll take these one at a time.  So the error noted above first. This is one I have come across once or twice, and so far has always been linked to a non-Studio activity.  But there’s always a first time ;-)

 It may be that there are new search requests coming in while previous ones haven’t yet finished.  SQLite will obtain full database locks sometimes, and if another write request comes in (such as with a confirm) while the DB is still locked from the previous write request, this error will be thrown.

 However as we haven’t found this occurring without a good explanation it's worth checking these things first;

• Do you have you TM stored on a network, NAS, or other slow device (such as encrypted volumes/TrueCrypt volumes)?
• Are you using multiple TMs updated at the same time, or many TMs in the cascade (and more than one updated)?
• Do you have any project settings applied (i.e. filter values which are updated on existing TUs during confirm)?
• Are you using very large TMs, or TMs with a large number of annotated context values (for CMs), or a large number of field values (particularly in conjunction with Project Settings)?
• Is the TM open in the TM Maintenance view as well?
• Are there any background jobs/batch tasks running against the TM?
• Are you using any OX plug-ins “doing something” with the TM?
• Do you have any defrag software running
• I have seen people running software that continuously defrags the drive as they work and this can cause problems too

So any additional information like this that you can provide would be very helpful and may allow you to resolve the issue yourself.  For example I came across a user recently who found he had a synchronous backup application running that he didn’t even know about.  Apparently it installed itself when he configured the backup program for his NAS drive, which he installed around same time as he upgraded Studio.  So every time the memory was updated, the synchronous backup would write it to the NAS (all 500+ MB of it), with an exclusive lock until it finished.

Regards

Paul

tfoltyn said:

• whenever I try to create a new sdlxliff file for translation (it pretty much makes no difference whether it's through 'Open Document' or 'New Project'), I receive the following error "An error has occurred whilst using the translation provider XXXX: The translation memory data file engine returned an error: The database file is locked / database is locked." error. What's more, it takes around 10 minutes for the 'error window' to actually appear, and I can do nothing but wait. Then the only thing I can do is add the respective TMs manually via Project Settings and hope that the error window won't re-appear. This works only at times and more often than not the error window does re-appear and I have to start from scratch again and do nothing but hope again. 

Hi Tomas,

I'll take these one at a time.  So the error noted above first. This is one I have come across once or twice, and so far has always been linked to a non-Studio activity.  But there’s always a first time ;-)

 It may be that there are new search requests coming in while previous ones haven’t yet finished.  SQLite will obtain full database locks sometimes, and if another write request comes in (such as with a confirm) while the DB is still locked from the previous write request, this error will be thrown.

 However as we haven’t found this occurring without a good explanation it's worth checking these things first;

• Do you have you TM stored on a network, NAS, or other slow device (such as encrypted volumes/TrueCrypt volumes)?
• Are you using multiple TMs updated at the same time, or many TMs in the cascade (and more than one updated)?
• Do you have any project settings applied (i.e. filter values which are updated on existing TUs during confirm)?
• Are you using very large TMs, or TMs with a large number of annotated context values (for CMs), or a large number of field values (particularly in conjunction with Project Settings)?
• Is the TM open in the TM Maintenance view as well?
• Are there any background jobs/batch tasks running against the TM?
• Are you using any OX plug-ins “doing something” with the TM?
• Do you have any defrag software running
• I have seen people running software that continuously defrags the drive as they work and this can cause problems too

So any additional information like this that you can provide would be very helpful and may allow you to resolve the issue yourself.  For example I came across a user recently who found he had a synchronous backup application running that he didn’t even know about.  Apparently it installed itself when he configured the backup program for his NAS drive, which he installed around same time as he upgraded Studio.  So every time the memory was updated, the synchronous backup would write it to the NAS (all 500+ MB of it), with an exclusive lock until it finished.

Regards

Paul

Dear Paul,

thank you for your reply. I'll go on to answer your questions straghtaway so as not to complicate things any further. :-)

• Do you have you TM stored on a network, NAS, or other slow device (such as encrypted volumes/TrueCrypt volumes)?

Nope. I don't use any NAS, external hard drives or anything like that.

In fact, since I use my desktop almost  exclusively for work, I also try to keep things simple when it comes to software. I have just a handful of programmes installed on the desktop (pretty much only things such MS Office 2007, Chrome and Firefox, Adobe Reader and tiny software such CC Clean, IrfanView.... you get an idea I think). None of that (except for an internet browser) is running while I use Studio. I even shut down Google Chrome once to see if there may possible be some interference, but to no avail.

• Are you using multiple TMs updated at the same time, or many TMs in the cascade (and more than one updated)?

Nope. I stick to oft-repeated advice that only one TM should be updated at a time. I update only my own (the so-called 'master TM', I believe), all other TMs I use are merely for consulting purposes. No TMs in the cascade. 

• Do you have any project settings applied (i.e. filter values which are updated on existing TUs during confirm?

No, I haven't applied any filters or this kind of advanced settings other than those that are set as default. To be honest, I don't really feel up to using any advanced settings of this sort.