Bug 743291 - [abrt] gpodder-2.19-1.fc14: dbsqlite.py:250:_remove_orphaned_episodes:OperationalError: database is locked
Summary: [abrt] gpodder-2.19-1.fc14: dbsqlite.py:250:_remove_orphaned_episodes:Operati...
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: Fedora
Classification: Fedora
Component: gpodder
Version: 14
Hardware: i686
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Jef Spaleta
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard: abrt_hash:0550e720
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-10-04 14:21 UTC by Hawkins Dale
Modified: 2012-08-16 13:41 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-08-16 13:41:03 UTC
Type: ---


Attachments (Terms of Use)
File: backtrace (1.85 KB, text/plain)
2011-10-04 14:21 UTC, Hawkins Dale
no flags Details

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


Note You need to log in before you can comment on or make changes to this bug.