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 Apr 23 03:31:15 2016  
 
Category: corePriority: 7 - High
Severity: 5 - NormalStatus: Need Info
Privacy: PublicPercent Complete: 0%
Assigned to: NoneOpen/Closed: Open
Planned Release: None

Thu Feb 23 21:02:31 2017, comment #1:

We need the steps to reproduce here. Please find.

Svetlana Tkachenko <svetlana>
Project Administrator
Sat Apr 23 03:31:15 2016, 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 Feb 23 21:02:31 2017svetlanaStatusNone=>Need Info
    Tue Jul 5 04:07:07 2016svetlanaPriority5 - Normal=>7 - High
    Show feedback again

    Back to the top


    Powered by Savane 3.1-cleanup+gray