Bug 138682 - losing all indexes in sqlite collection db
Summary: losing all indexes in sqlite collection db
Status: RESOLVED DUPLICATE of bug 138913
Alias: None
Product: amarok
Classification: Applications
Component: general (show other bugs)
Version: 1.4-SVN
Platform: Debian testing Linux
: NOR normal
Target Milestone: ---
Assignee: Amarok Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-12-11 18:15 UTC by justus
Modified: 2006-12-19 00:12 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description justus 2006-12-11 18:15:58 UTC 
Version:           1.4-SVN (using KDE KDE 3.5.5)
Installed from:    Debian testing/unstable Packages
Compiler:          g++ (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21) 
OS:                Linux

with current svn build amarok kills shortly after startup the indexes in the sqlite db. (revision 612499)
after that queries are that slow, that amarok becomes unusable. 

what information could i provide to track this down? an old backup of my database has still oll the indices and will lose them shortly after startup. i once readded them by hand and they all got deleted after starting amarok again. 

eg. before starting amarok:
sqlite> .indices images
images_album
images_artist
images_url

after startup
sqlite> .indices images
sqlite>  


all gone. thx for help
Comment 1 Alexandre Oliveira 2006-12-19 00:12:25 UTC 

*** This bug has been marked as a duplicate of 138913 ***