Results 1 to 3 of 3

Thread: IGL database lock error

  1. #1
    Join Date
    Sep 2008
    Location
    United States
    Posts
    285

    IGL database lock error

    So, I occasionally end up with a run of IGL where there is an error at the end of "database is locked". The files get renamed, but the database doesn't get updated for the new name. It doesn't really bother me that the database doesn't get updated, since I don't watch the recordings made through NPVR, but I make use of the new name that is returned to do some other post-processing.

    So, how do I avoid this, or how should I proceed when this happens? I just experimented and tried running it again, but I guess since the files were already renamed, nothing happened and it doesn't return the name.

    I've attached the IGL log for one such lock situation. Thanks.
    Attached Files Attached Files
    Tim

  2. #2
    Join Date
    May 2006
    Location
    Canada
    Posts
    25,560
    Quote Originally Posted by ttfitz View Post
    So, I occasionally end up with a run of IGL where there is an error at the end of "database is locked". The files get renamed, but the database doesn't get updated for the new name. It doesn't really bother me that the database doesn't get updated, since I don't watch the recordings made through NPVR, but I make use of the new name that is returned to do some other post-processing.

    So, how do I avoid this, or how should I proceed when this happens? I just experimented and tried running it again, but I guess since the files were already renamed, nothing happened and it doesn't return the name.

    I've attached the IGL log for one such lock situation. Thanks.
    I'd like to see all the NextPVR logs, the lock would likely come from elsewhere. Before I start the renaming operations I do start a database transaction which should lock the database too. Going from the time 22:08 I see you run some longish jobs before iGL maybe CPU is being hogged slowing down the rename operation.

    To fix it manually rename just the .ts file back to original show in the log or NRecord, This Is Us_20170314_21002201.ts and rerun the same command shown in the log --oid 201124 --rename --zap2it --nfo --extra

    Martin

  3. #3
    Join Date
    Jan 2005
    Location
    London
    Posts
    3,156
    or UpdateEPG during liveTV is ticked in the config which typically used to cause database locking issues.
    “If this is the way Queen Victoria treats her prisoners, she doesn't deserve to have any.”

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •