Bug 743472

Summary: [abrt] zeitgeist-0.8.1-1.fc15: sql.py:76:execute:OperationalError: database is locked
Product: [Fedora] Fedora Reporter: Stefan A Keel <sak.102010>
Component: zeitgeistAssignee: Deji Akingunola <dakingun>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 15CC: dakingun, elad, maxx, sergmerkelov
Target Milestone: ---   
Target Release: ---   
Hardware: i686   
OS: Unspecified   
Whiteboard: abrt_hash:7ea450567b51f7613b866f4fcf8a6200c8859d5d
Fixed In Version: zeitgeist-0.8.2-2.fc15 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-11-10 17:26:01 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:

Description Stefan A Keel 2011-10-05 02:27:57 UTC
abrt version: 2.0.3
architecture:   i686
cmdline:        
comment:        crash occured during login, no other action took place
component:      zeitgeist
executable:     /usr/bin/zeitgeist-daemon
kernel:         2.6.40.4-5.fc15.i686
os_release:     Fedora release 15 (Lovelock)
package:        zeitgeist-0.8.1-1.fc15
reason:         sql.py:76:execute:OperationalError: database is locked
time:           Tue Oct  4 19:26:37 2011
uid:            500
username:       sak

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 105, 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 0x87164dc>
:statement: 'PRAGMA journal_mode = DELETE'
:parameters: []

Comment 1 Fedora Update System 2011-10-21 02:33:11 UTC
zeitgeist-0.8.2-1.fc15 has been submitted as an update for Fedora 15.
https://admin.fedoraproject.org/updates/zeitgeist-0.8.2-1.fc15

Comment 2 Fedora Update System 2011-10-22 08:27:29 UTC
Package zeitgeist-0.8.2-1.fc15:
* should fix your issue,
* was pushed to the Fedora 15 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing zeitgeist-0.8.2-1.fc15'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/FEDORA-2011-14748
then log in and leave karma (feedback).

Comment 3 Fedora Update System 2011-10-24 23:01:47 UTC
Package zeitgeist-0.8.2-2.fc15:
* should fix your issue,
* was pushed to the Fedora 15 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing zeitgeist-0.8.2-2.fc15'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/FEDORA-2011-14748
then log in and leave karma (feedback).

Comment 4 Elad Alfassa 2011-10-28 13:47:07 UTC
Package: zeitgeist-0.8.2-2.fc16
Architecture: x86_64
OS Release: Fedora release 16 (Verne)

Comment
-----
I just logged in

Comment 5 Fedora Update System 2011-11-10 17:26:01 UTC
zeitgeist-0.8.2-2.fc15 has been pushed to the Fedora 15 stable repository.  If problems still persist, please make note of it in this bug report.

Comment 6 Serg Merkelov 2012-06-02 19:59:37 UTC
Since upgrade to fedora 17, I cannot use xrdp anymore. zeitgeist crashes at login time through xrdp and session closes.

Comment 7 Serg Merkelov 2012-06-02 20:01:52 UTC
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 0x7f3da42cb0e8>
statement: 'PRAGMA journal_mode = DELETE'
parameters: []