trinity-devel@lists.pearsoncomputing.net

Message: previous - next
Month: February 2014
Re: [trinity-devel] Amarok: [CollectionDB] [ERROR!] spew upon startup

From: "Darrell Anderson" <darrella@...>
Date: Sat, 15 Feb 2014 21:50:22 -0600

On Fri, 07 Feb 2014 20:39:29 -0600 "Darrell Anderson" 
<darrella@...> wrote:
>Anybody else notice the following output spew when starting 
>Amarok? 
>I traced the introduction of the bug to the first few days of 
>Sept. 2013.
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index url_tag already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE UNIQUE INDEX 
>url_tag ON tags( url, deviceid );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index album_tag already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX album_tag 
>ON 
>tags( album );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index artist_tag already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX artist_tag 
>ON tags( artist );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index composer_tag already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>composer_tag 
>ON tags( composer );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index genre_tag already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX genre_tag 
>ON 
>tags( genre );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index year_tag already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX year_tag ON 
>
>tags( year );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index sampler_tag already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX sampler_tag 
>
>ON tags( sampler );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index images_album already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>images_album 
>ON images( album );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index images_artist already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>images_artist ON images( artist );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index images_url already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX images_url 
>ON images( path, deviceid );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index embed_url already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE UNIQUE INDEX 
>embed_url ON embed( url, deviceid );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index embed_hash already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX embed_hash 
>ON embed( hash );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index directories_dir already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE UNIQUE INDEX 
>directories_dir ON directories( dir, deviceid );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index uniqueid_uniqueid already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>uniqueid_uniqueid ON uniqueid( uniqueid );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index uniqueid_url already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>uniqueid_url 
>ON uniqueid( url, deviceid );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index album_idx already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX album_idx 
>ON 
>album( name );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index artist_idx already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX artist_idx 
>ON artist( name );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index composer_idx already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>composer_idx 
>ON composer( name );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index genre_idx already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX genre_idx 
>ON 
>genre( name );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index year_idx already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX year_idx ON 
>
>year( name );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index tags_artist_index already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>tags_artist_index ON tags( artist );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index tags_album_index already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>tags_album_index ON tags( album );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index tags_deviceid_index already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>tags_deviceid_index ON tags( deviceid ); 
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index tags_url_index already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>tags_url_index ON tags( url ); 
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index embed_deviceid_index already 
>
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>embed_deviceid_index ON embed( deviceid ); 
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index embed_url_index already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>embed_url_index ON embed( url ); 
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index related_artists_artist 
>already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>related_artists_artist ON related_artists( artist );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index lyrics_url already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE UNIQUE INDEX 
>lyrics_url ON lyrics( url, deviceid );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index lyrics_uniqueid already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>lyrics_uniqueid ON lyrics( uniqueid );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index playlist_playlists already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>playlist_playlists ON playlists( playlist );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index url_playlists already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>url_playlists ON playlists( url );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index labels_name already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE UNIQUE INDEX 
>labels_name ON labels( name, type );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index tags_labels_uniqueid already 
>
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>tags_labels_uniqueid ON tags_labels( uniqueid );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index tags_labels_url already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>tags_labels_url ON tags_labels( url, deviceid );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index tags_labels_labelid already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>tags_labels_labelid ON tags_labels( labelid );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index url_stats already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE UNIQUE INDEX 
>url_stats ON statistics( deviceid, url );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index percentage_stats already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>percentage_stats ON statistics( percentage );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index rating_stats already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>rating_stats 
>ON statistics( rating );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index playcounter_stats already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>playcounter_stats ON statistics( playcounter );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index uniqueid_stats already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>uniqueid_stats ON statistics( uniqueid );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index url_podchannel already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>url_podchannel ON podcastchannels( url );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index url_podepisode already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>url_podepisode ON podcastepisodes( url );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index localurl_podepisode already 
>exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>localurl_podepisode ON podcastepisodes( localurl );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] index url_podfolder already exists
>
>amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX 
>url_podfolder ON podcastfolders( id );
>
>amarok: [CollectionDB] [ERROR!] [virtual TQStringList 
>SqliteConnection::query(const TQString&, bool)]  sqlite3_compile 
>error:
>
>amarok: [CollectionDB] [ERROR!] no such table: magnatune_albums
>
>amarok: [CollectionDB] [ERROR!] on query: SELECT DISTINCT genre 
>FROM magnatune_albums ORDER BY genre;


Nobody else sees these error messages?

Darrell
trinity-devel@lists.pearsoncomputing.net

Re: [trinity-devel] Amarok: [CollectionDB] [ERROR!] spew upon startup

powered by ezmlm-www (v1.4.5)
