bugguppy - Bugs: bug #287, Fix db lock issues

 
 
Show feedback again

You are not allowed to post comments on this tracker with your current authentification level.

bug #287: Fix db lock issues

Submitted by:  Svetlana Tkachenko <svetlana>
Submitted on:  Sat 23 Apr 2016 06:31:15 AM EEST  
 
Category: corePriority: 7 - High
Severity: 5 - NormalStatus: Need Info
Privacy: PublicPercent Complete: 0%
Assigned to: NoneOpen/Closed: Open
Planned Release: None

Thu 23 Feb 2017 11:02:31 PM EET, comment #1:

We need the steps to reproduce here. Please find.

Svetlana Tkachenko <svetlana>
Project Administrator
Sat 23 Apr 2016 06:31:15 AM EEST, original submission:

RSS and SEEN are completely useless in their current form. The problem with RSS and SEEN is that the whole database handling is not correct. You'd need to run some sqlite commands on every startup, because the db will always be locked on start:

connection.commit() sqlite3.OperationalError: database is locked (Fixing the mentioned line only doesn't work, it'll come up with an error everytime the db is called.)

Now if you open it manually and it works, the db file will be corrupted as soon as there is more than one access at the same time. This might happen when you have assigned different feeds to different channels and the feed selfcheck is executed. I tried to tweak it by adding a timeout to "sqlite.connect(self.db, timeout=10)", it may help, but even this will not work reliably when there are lots of feeds assigned.

Svetlana Tkachenko <svetlana>
Project Administrator

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -unavailable- added by svetlana (Submitted the item)
  •  

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    2 latest changes follow.

    Date Changed By Updated Field Previous Value => Replaced By
    Thu 23 Feb 2017 11:02:31 PM EETsvetlanaStatusNone=>Need Info
    Tue 05 Jul 2016 07:07:07 AM EESTsvetlanaPriority5 - Normal=>7 - High
    Show feedback again

    Back to the top


    Powered by Savane 3.1-cleanup+gray