Bug 827851

Summary: [abrt] zeitgeist-0.8.2-3.fc17: sql.py:76:execute:OperationalError: unable to open database file
Product: [Fedora] Fedora Reporter: Daniel Brooks <db48x>
Component: zeitgeistAssignee: Deji Akingunola <dakingun>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 17CC: dakingun, just_another_coder, maxx
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Unspecified   
Whiteboard: abrt_hash:93565345c6afee0d08de433c4fdc9e3e558073cf
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-12-20 15:26:08 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
File: smolt_data none

Description Daniel Brooks 2012-06-03 10:05:15 UTC
libreport version: 2.0.10
abrt_version:   2.0.10
cmdline:        /usr/bin/python /usr/bin/zeitgeist-daemon
comment:        happens during KDE startup
executable:     /usr/bin/zeitgeist-daemon
kernel:         3.3.7-1.fc16.x86_64
time:           Sat 02 Jun 2012 09:51:34 PM PDT
uid:            500
username:       db48x

smolt_data:     Text file, 6147 bytes

backtrace:
:sql.py:76:execute:OperationalError: unable to open database file
:
:Traceback (most recent call last):
:  File "/usr/bin/zeitgeist-daemon", line 198, in <module>
:    main()
:  File "/usr/bin/zeitgeist-daemon", line 176, in main
:    mainloop, interface = setup_interface()
:  File "/usr/bin/zeitgeist-daemon", line 103, in setup_interface
:    return mainloop, RemoteInterface(mainloop = mainloop)
:  File "/usr/share/zeitgeist/_zeitgeist/engine/remote.py", line 71, in __init__
:    self._engine = get_engine()
:  File "/usr/share/zeitgeist/_zeitgeist/engine/__init__.py", line 42, in get_engine
:    _engine = main.ZeitgeistEngine()
:  File "/usr/share/zeitgeist/_zeitgeist/engine/main.py", line 99, in __init__
:    self._cursor = cursor = get_default_cursor()
:  File "/usr/share/zeitgeist/_zeitgeist/engine/sql.py", line 494, in get_default_cursor
:    _cursor = create_db(dbfile)
:  File "/usr/share/zeitgeist/_zeitgeist/engine/sql.py", line 212, in create_db
:    cursor.execute("PRAGMA journal_mode = DELETE")
:  File "/usr/share/zeitgeist/_zeitgeist/engine/sql.py", line 76, in execute
:    return super(UnicodeCursor, self).execute(statement, parameters)
:OperationalError: unable to open database file
:
:Local variables in innermost frame:
:self: <_zeitgeist.engine.sql.UnicodeCursor object at 0x14eb0e8>
:statement: 'PRAGMA journal_mode = DELETE'
:parameters: []

Comment 1 Daniel Brooks 2012-06-03 10:05:19 UTC
Created attachment 588821 [details]
File: smolt_data

Comment 2 jo 2012-06-07 20:15:50 UTC
Same problem on a 32 bit install

Backtrace:
sql.py:76:execute:OperationalError: database is locked

Traceback (most recent call last):
  File "/usr/bin/zeitgeist-daemon", line 198, in <module>
    main()
  File "/usr/bin/zeitgeist-daemon", line 176, in main
    mainloop, interface = setup_interface()
  File "/usr/bin/zeitgeist-daemon", line 103, in setup_interface
    return mainloop, RemoteInterface(mainloop = mainloop)
  File "/usr/share/zeitgeist/_zeitgeist/engine/remote.py", line 71, in __init__
    self._engine = get_engine()
  File "/usr/share/zeitgeist/_zeitgeist/engine/__init__.py", line 42, in get_engine
    _engine = main.ZeitgeistEngine()
  File "/usr/share/zeitgeist/_zeitgeist/engine/main.py", line 99, in __init__
    self._cursor = cursor = get_default_cursor()
  File "/usr/share/zeitgeist/_zeitgeist/engine/sql.py", line 494, in get_default_cursor
    _cursor = create_db(dbfile)
  File "/usr/share/zeitgeist/_zeitgeist/engine/sql.py", line 212, in create_db
    cursor.execute("PRAGMA journal_mode = DELETE")
  File "/usr/share/zeitgeist/_zeitgeist/engine/sql.py", line 76, in execute
    return super(UnicodeCursor, self).execute(statement, parameters)
OperationalError: database is locked

Local variables in innermost frame:
self: <_zeitgeist.engine.sql.UnicodeCursor object at 0x9ded43c>
statement: 'PRAGMA journal_mode = DELETE'
parameters: []

Comment 3 Fedora Update System 2012-09-24 23:05:20 UTC
zeitgeist-datahub-0.9.5-1.fc17,zeitgeist-0.9.5-1.fc17 has been submitted as an update for Fedora 17.
https://admin.fedoraproject.org/updates/zeitgeist-datahub-0.9.5-1.fc17,zeitgeist-0.9.5-1.fc17

Comment 4 Fedora Update System 2012-09-26 09:04:23 UTC
Package zeitgeist-datahub-0.9.5-1.fc17, zeitgeist-0.9.5-1.fc17:
* should fix your issue,
* was pushed to the Fedora 17 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing zeitgeist-datahub-0.9.5-1.fc17 zeitgeist-0.9.5-1.fc17'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/FEDORA-2012-14788/zeitgeist-datahub-0.9.5-1.fc17,zeitgeist-0.9.5-1.fc17
then log in and leave karma (feedback).

Comment 5 Fedora Update System 2012-12-20 15:26:10 UTC
zeitgeist-datahub-0.9.5-1.fc17, zeitgeist-0.9.5-1.fc17 has been pushed to the Fedora 17 stable repository.  If problems still persist, please make note of it in this bug report.