Bug 1747484

Summary: [abrt] lollypop: set_listened_at(): database_tracks.py:801:set_listened_at:sqlite3.OperationalError: database is locked
Product: [Fedora] Fedora Reporter: pr.safont
Component: lollypopAssignee: MartinKG <mgansser>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 30CC: cedric.bellegarde, mgansser
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Unspecified   
URL: https://retrace.fedoraproject.org/faf/reports/bthash/95f3930105b9a9fc7cc6fe376875dcdf9ce1506f
Whiteboard: abrt_hash:6777a6284b0347ee0a1c4e6bf40266118c1ec92f;VARIANT_ID=workstation;
Fixed In Version: lollypop-1.2.16-1.fc30 lollypop-1.2.16-1.fc31 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2019-11-11 12:19:23 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: backtrace
none
File: cgroup
none
File: cpuinfo
none
File: environ
none
File: mountinfo
none
File: namespaces
none
File: open_fds none

Description pr.safont 2019-08-30 14:31:20 UTC
Description of problem:
Lollypop GUI frezes whenever I click play, it still plays the song, then it stops.

Version-Release number of selected component:
lollypop-1.1.4.14-1.fc30

Additional info:
reporter:       libreport-2.10.1
cmdline:        /usr/bin/python3 /usr/bin/lollypop
crash_function: set_listened_at
exception_type: sqlite3.OperationalError
executable:     /usr/bin/lollypop
interpreter:    python3-3.7.4-1.fc30.x86_64
kernel:         5.2.9-200.fc30.x86_64
runlevel:       N 5
type:           Python3
uid:            1000

Truncated backtrace:
database_tracks.py:801:set_listened_at:sqlite3.OperationalError: database is locked

Traceback (most recent call last):
  File "/usr/lib/python3.7/site-packages/lollypop/player.py", line 574, in _on_stream_start
    BinPlayer._on_stream_start(self, bus, message)
  File "/usr/lib/python3.7/site-packages/lollypop/player_bin.py", line 327, in _on_stream_start
    App().tracks.set_listened_at(self._current_track.id, int(time()))
  File "/usr/lib/python3.7/site-packages/lollypop/database_tracks.py", line 801, in set_listened_at
    (time, track_id))
sqlite3.OperationalError: database is locked

Local variables in innermost frame:
self: <lollypop.database_tracks.TracksDatabase object at 0x7ff0c9d70450>
track_id: 1439
time: 1567160181
sql: <sqlite3.Connection object at 0x7ff0c28c4110>

Comment 1 pr.safont 2019-08-30 14:31:23 UTC
Created attachment 1609906 [details]
File: backtrace

Comment 2 pr.safont 2019-08-30 14:31:24 UTC
Created attachment 1609907 [details]
File: cgroup

Comment 3 pr.safont 2019-08-30 14:31:25 UTC
Created attachment 1609908 [details]
File: cpuinfo

Comment 4 pr.safont 2019-08-30 14:31:26 UTC
Created attachment 1609909 [details]
File: environ

Comment 5 pr.safont 2019-08-30 14:31:27 UTC
Created attachment 1609910 [details]
File: mountinfo

Comment 6 pr.safont 2019-08-30 14:31:29 UTC
Created attachment 1609911 [details]
File: namespaces

Comment 7 pr.safont 2019-08-30 14:31:30 UTC
Created attachment 1609912 [details]
File: open_fds

Comment 8 MartinKG 2019-08-30 19:20:48 UTC
was passiert, wenn du die lollypop datenbank zurücksetzt oder die aktuelle Version 1.1.4.15.

$ sudo dnf update lollypop --enablerepo=updates-testing

Comment 9 MartinKG 2019-08-30 19:23:38 UTC
sorry once again in english.
what happens if you reset the lollypop database or the current version 1.1.4.15.

$ sudo dnf update lollypop --enablerepo=updates-testing

Comment 10 MartinKG 2019-09-02 13:56:34 UTC
upstream ticket: https://gitlab.gnome.org/World/lollypop/issues/1985

Comment 11 Cédric Bellegarde 2019-09-03 05:28:45 UTC
Does the collection scanner run while trying to play the track?

Comment 12 Fedora Update System 2019-10-22 09:23:23 UTC
FEDORA-2019-052707aac2 has been submitted as an update to Fedora 31. https://bodhi.fedoraproject.org/updates/FEDORA-2019-052707aac2

Comment 13 Fedora Update System 2019-10-23 06:46:14 UTC
FEDORA-2019-ce17229b1f has been submitted as an update to Fedora 31. https://bodhi.fedoraproject.org/updates/FEDORA-2019-ce17229b1f

Comment 14 Fedora Update System 2019-10-23 15:45:05 UTC
lollypop-1.2.1-1.fc31 has been pushed to the Fedora 31 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-ce17229b1f

Comment 15 Fedora Update System 2019-10-25 19:33:53 UTC
lollypop-1.2.1-1.fc30 has been pushed to the Fedora 30 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-0c03b3fdc0

Comment 16 Fedora Update System 2019-10-26 11:08:22 UTC
FEDORA-2019-fd35422594 has been submitted as an update to Fedora 30. https://bodhi.fedoraproject.org/updates/FEDORA-2019-fd35422594

Comment 17 Fedora Update System 2019-10-26 11:08:22 UTC
FEDORA-2019-5d0be2cffc has been submitted as an update to Fedora 31. https://bodhi.fedoraproject.org/updates/FEDORA-2019-5d0be2cffc

Comment 18 Fedora Update System 2019-10-27 03:54:33 UTC
lollypop-1.2.2-1.fc30 has been pushed to the Fedora 30 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-fd35422594

Comment 19 Fedora Update System 2019-10-27 04:02:35 UTC
lollypop-1.2.2-1.fc31 has been pushed to the Fedora 31 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-5d0be2cffc

Comment 20 Fedora Update System 2019-10-31 07:35:44 UTC
FEDORA-2019-bbf37c84c9 has been submitted as an update to Fedora 30. https://bodhi.fedoraproject.org/updates/FEDORA-2019-bbf37c84c9

Comment 21 Fedora Update System 2019-11-01 17:20:50 UTC
FEDORA-2019-c19c0bbf9b has been submitted as an update to Fedora 31. https://bodhi.fedoraproject.org/updates/FEDORA-2019-c19c0bbf9b

Comment 22 Fedora Update System 2019-11-02 02:26:51 UTC
lollypop-1.2.4-1.fc30 has been pushed to the Fedora 30 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-a05cb7d625

Comment 23 Fedora Update System 2019-11-03 06:01:47 UTC
lollypop-1.2.4-1.fc31 has been pushed to the Fedora 31 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-c19c0bbf9b

Comment 24 Fedora Update System 2019-11-03 09:43:50 UTC
FEDORA-2019-13ab78bcd9 has been submitted as an update to Fedora 31. https://bodhi.fedoraproject.org/updates/FEDORA-2019-13ab78bcd9

Comment 25 Fedora Update System 2019-11-04 02:09:52 UTC
lollypop-1.2.5-1.fc30 has been pushed to the Fedora 30 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-1b7dbd411b

Comment 26 Fedora Update System 2019-11-04 02:18:41 UTC
lollypop-1.2.5-1.fc31 has been pushed to the Fedora 31 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-13ab78bcd9

Comment 27 Fedora Update System 2019-11-05 11:50:15 UTC
FEDORA-2019-943f3c2424 has been submitted as an update to Fedora 30. https://bodhi.fedoraproject.org/updates/FEDORA-2019-943f3c2424

Comment 28 Fedora Update System 2019-11-05 11:50:27 UTC
FEDORA-2019-0cd434ce6e has been submitted as an update to Fedora 31. https://bodhi.fedoraproject.org/updates/FEDORA-2019-0cd434ce6e

Comment 29 Fedora Update System 2019-11-06 14:03:26 UTC
lollypop-1.2.6-1.fc30 has been pushed to the Fedora 30 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-943f3c2424

Comment 30 Fedora Update System 2019-11-06 14:13:11 UTC
lollypop-1.2.6-1.fc31 has been pushed to the Fedora 31 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-0cd434ce6e

Comment 31 Fedora Update System 2019-11-07 08:24:19 UTC
FEDORA-2019-f9cdb859b9 has been submitted as an update to Fedora 31. https://bodhi.fedoraproject.org/updates/FEDORA-2019-f9cdb859b9

Comment 32 Fedora Update System 2019-11-07 08:24:41 UTC
FEDORA-2019-578aacb367 has been submitted as an update to Fedora 30. https://bodhi.fedoraproject.org/updates/FEDORA-2019-578aacb367

Comment 33 Fedora Update System 2019-11-09 23:20:08 UTC
lollypop-1.2.7-1.fc31 has been pushed to the Fedora 31 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-f9cdb859b9

Comment 34 Fedora Update System 2019-11-10 00:38:45 UTC
lollypop-1.2.7-1.fc30 has been pushed to the Fedora 30 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-578aacb367

Comment 35 Fedora Update System 2019-11-11 09:40:46 UTC
FEDORA-2019-a895d2a366 has been submitted as an update to Fedora 31. https://bodhi.fedoraproject.org/updates/FEDORA-2019-a895d2a366

Comment 36 Fedora Update System 2019-11-11 09:41:09 UTC
FEDORA-2019-3287112a83 has been submitted as an update to Fedora 30. https://bodhi.fedoraproject.org/updates/FEDORA-2019-3287112a83

Comment 37 Fedora Update System 2019-11-12 03:07:29 UTC
lollypop-1.2.11-1.fc30 has been pushed to the Fedora 30 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-3287112a83

Comment 38 Fedora Update System 2019-11-12 07:38:29 UTC
FEDORA-2019-08aa9f8160 has been submitted as an update to Fedora 30. https://bodhi.fedoraproject.org/updates/FEDORA-2019-08aa9f8160

Comment 39 Fedora Update System 2019-11-13 04:55:55 UTC
lollypop-1.2.11-1.fc31 has been pushed to the Fedora 31 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-a895d2a366

Comment 40 Fedora Update System 2019-11-13 10:46:39 UTC
lollypop-1.2.12-1.fc30 has been pushed to the Fedora 30 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-08aa9f8160

Comment 41 Fedora Update System 2019-11-18 02:15:00 UTC
lollypop-1.2.13-1.fc31 has been pushed to the Fedora 31 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-64b025c2c8

Comment 42 Fedora Update System 2019-11-18 03:07:36 UTC
lollypop-1.2.13-1.fc30 has been pushed to the Fedora 30 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-b813a9d13d

Comment 43 Fedora Update System 2019-11-25 02:04:27 UTC
lollypop-1.2.15-1.fc31 has been pushed to the Fedora 31 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-d3ae029410

Comment 44 Fedora Update System 2019-11-25 02:28:13 UTC
lollypop-1.2.15-1.fc30 has been pushed to the Fedora 30 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-5506ee0c32

Comment 45 Fedora Update System 2019-11-27 00:33:17 UTC
lollypop-1.2.16-1.fc31 has been pushed to the Fedora 31 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-7f981a8efa

Comment 46 Fedora Update System 2019-11-27 01:08:14 UTC
lollypop-1.2.16-1.fc30 has been pushed to the Fedora 30 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-787383cea6

Comment 47 Fedora Update System 2019-12-05 01:11:29 UTC
lollypop-1.2.16-1.fc30 has been pushed to the Fedora 30 stable repository. If problems still persist, please make note of it in this bug report.

Comment 48 Fedora Update System 2019-12-05 01:40:36 UTC
lollypop-1.2.16-1.fc31 has been pushed to the Fedora 31 stable repository. If problems still persist, please make note of it in this bug report.