Bug 743291

Summary: [abrt] gpodder-2.19-1.fc14: dbsqlite.py:250:_remove_orphaned_episodes:OperationalError: database is locked
Product: [Fedora] Fedora Reporter: Hawkins Dale <hawkins>
Component: gpodderAssignee: Jef Spaleta <jspaleta>
Status: CLOSED WONTFIX QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 14CC: jspaleta, vpvainio
Target Milestone: ---   
Target Release: ---   
Hardware: i686   
OS: Unspecified   
Whiteboard: abrt_hash:0550e720
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-08-16 13:41:03 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
File: backtrace none

Description Hawkins Dale 2011-10-04 14:21:54 UTC
abrt version: 1.1.18
architecture: i686
cmdline: /usr/bin/python /usr/bin/gpodder
component: gpodder
executable: /usr/bin/gpodder
kernel: 2.6.35.14-96.fc14.i686
package: gpodder-2.19-1.fc14
reason: dbsqlite.py:250:_remove_orphaned_episodes:OperationalError: database is locked
release: Fedora release 14 (Laughlin)
time: 1317737401
uid: 500

backtrace
-----
dbsqlite.py:250:_remove_orphaned_episodes:OperationalError: database is locked

Traceback (most recent call last):
  File "/usr/bin/gpodder", line 215, in <module>
    gui.main(options)
  File "/usr/lib/python2.7/site-packages/gpodder/gui.py", line 4248, in main
    gp = gPodder(bus_name, config)
  File "/usr/lib/python2.7/site-packages/gpodder/gui.py", line 179, in __init__
    BuilderWidget.__init__(self, None)
  File "/usr/lib/python2.7/site-packages/gpodder/gtkui/interface/common.py", line 56, in __init__
    GtkBuilderWidget.__init__(self, gpodder.ui_folders, gpodder.textdomain, **kwargs)
  File "/usr/lib/python2.7/site-packages/gpodder/gtkui/base.py", line 70, in __init__
    self.new()
  File "/usr/lib/python2.7/site-packages/gpodder/gui.py", line 468, in new
    self.channels = PodcastChannel.load_from_db(self.db, self.config.download_dir)
  File "/usr/lib/python2.7/site-packages/gpodder/model.py", line 129, in load_from_db
    return db.load_channels(factory=cls.build_factory(download_dir))
  File "/usr/lib/python2.7/site-packages/gpodder/dbsqlite.py", line 343, in load_channels
    cur = self.cursor(lock=True)
  File "/usr/lib/python2.7/site-packages/gpodder/dbsqlite.py", line 199, in cursor
    return self.db.cursor()
  File "/usr/lib/python2.7/site-packages/gpodder/dbsqlite.py", line 193, in db
    self.__check_schema()
  File "/usr/lib/python2.7/site-packages/gpodder/dbsqlite.py", line 271, in __check_schema
    self._remove_orphaned_episodes()
  File "/usr/lib/python2.7/site-packages/gpodder/dbsqlite.py", line 250, in _remove_orphaned_episodes
    cur.execute(sql % (self.TABLE_EPISODES, self.TABLE_CHANNELS,))
OperationalError: database is locked

Local variables in innermost frame:
self: <gpodder.dbsqlite.Database object at 0x8a22f4c>
cur: <sqlite3.Cursor object at 0x8a211a0>
sql: 'DELETE FROM %s WHERE channel_id NOT IN (SELECT DISTINCT id FROM %s)'

How to reproduce
-----
1. opened the tool.
2. crash!

Comment 1 Hawkins Dale 2011-10-04 14:21:59 UTC
Created attachment 526252 [details]
File: backtrace

Comment 2 Fedora End Of Life 2012-08-16 13:41:05 UTC
This message is a notice that Fedora 14 is now at end of life. Fedora 
has stopped maintaining and issuing updates for Fedora 14. It is 
Fedora's policy to close all bug reports from releases that are no 
longer maintained.  At this time, all open bugs with a Fedora 'version'
of '14' have been closed as WONTFIX.

(Please note: Our normal process is to give advanced warning of this 
occurring, but we forgot to do that. A thousand apologies.)

Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, feel free to reopen 
this bug and simply change the 'version' to a later Fedora version.

Bug Reporter: Thank you for reporting this issue and we are sorry that 
we were unable to fix it before Fedora 14 reached end of life. If you 
would still like to see this bug fixed and are able to reproduce it 
against a later version of Fedora, you are encouraged to click on 
"Clone This Bug" (top right of this page) and open it against that 
version of Fedora.

Although we aim to fix as many bugs as possible during every release's 
lifetime, sometimes those efforts are overtaken by events.  Often a 
more recent Fedora release includes newer upstream software that fixes 
bugs or makes them obsolete.

The process we are following is described here: 
http://fedoraproject.org/wiki/BugZappers/HouseKeeping