10 second autocommit doesn't trigger unless you first also have 50 files

Bug #289968 reported by Michael Terry
2
Affects Status Importance Assigned to Milestone
Moovida
Fix Released
High
Benjamin Kampmann
moovida (Ubuntu)
Fix Released
Undecided
Unassigned

Bug Description

Because of a missing initial call to _reset_autocommit_delay in database_parser.py, the commit-every-10-seconds loop is never initiated unless the parser first finds 50 files and commits. This means that media libraries less than 50 files never get committed.

Steps to reproduce:
1) Backup and delete your database (~/.elisa-0.5/elisa.db)
2) Make sure all the entries of the [directories] section in your configuration file are empty lists except for one, say music, that should contain a directory that contains less than 50 audio files in total.
3) Start elisa, notice that shortly after the main UI shows up the media scanner reports scanning your music directory
4) Wait for more than 10 sec.
5) Run the following select query on the DB with sqlite:
    $ sqlite3 elisa.db 'select * from music_tracks;'

Expected result: all the audio files contained in the folder are listed, they are indexed in the DB.

Current result: nothing is listed, the indexed files are not committed to the DB.

Tags: oem-services

Related branches

Revision history for this message
Michael Terry (mterry) wrote :
Changed in elisa:
importance: Undecided → High
milestone: none → 0.5.18
status: New → Confirmed
Olivier Tilloy (osomon)
Changed in elisa:
assignee: nobody → lightyear
status: Confirmed → In Progress
Revision history for this message
Olivier Tilloy (osomon) wrote :

There is no real end-user impact as a commit is performed when exiting elisa, and while running, storm caches the contents of the DB.

Olivier Tilloy (osomon)
description: updated
Olivier Tilloy (osomon)
Changed in elisa:
status: In Progress → Fix Committed
Olivier Tilloy (osomon)
Changed in elisa:
status: Fix Committed → Fix Released
Revision history for this message
Shrirangv (shrirangv) wrote :

[Cybage QA - Shrirang 20-Nov-08]
Tested On: 0.5.18
OS: Win32
Executing the query given above in sqlite doesn't return any records though the media files are detected & displayed in music section by default.Is this valid test?

Also provide the path of elisa.db in ubuntu.

Revision history for this message
Olivier Tilloy (osomon) wrote :

I think the steps to reproduce and the expected results are clear enough. They are quite specific, that's due to the nature of the bug. The path to the elisa.db file is given at step 1.

Revision history for this message
Shrirangv (shrirangv) wrote :

[Cybage QA - Shrirang 20-Nov-08]
As per comments above, the bug fix is failed on Win32. Updated tag as Fix-failed.

Michael Terry (mterry)
Changed in moovida (Ubuntu):
status: New → Fix Released
tags: added: oem-services
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.