Bug 138682

Summary: losing all indexes in sqlite collection db
Product: [Applications] amarok Reporter: justus <justus>
Component: generalAssignee: Amarok Developers <amarok-bugs-dist>
Status: RESOLVED DUPLICATE    
Severity: normal    
Priority: NOR    
Version: 1.4-SVN   
Target Milestone: ---   
Platform: Debian testing   
OS: Linux   
Latest Commit: Version Fixed In:

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 ***