Iwas watching the rompr log and aI see these, not sure if they are bad or not. I do not know much about Sql stuff so sorry for being verbose about this stuff.
thanks
02:25:10 : 24653 : MYSQL Tidying Metadata [3/1888]
02:25:10 : 24653 : MYSQL Updating Track Stats
02:25:10 : 24653 : USERRATING ---------------------------END----------------------
02:26:25 : 30081 : SQL_QUERY Command Failed : DELETE FROM Albumtable WHERE Albumindex NOT IN (SELECT DISTINCT Albumindex FROM Tracktable WHERE Albumindex IS NOT NULL)
02:26:25 : 30081 : MYSQL MYSQL Error: : 1213 : Deadlock found when trying to get lock; try restarting transaction
02:26:25 : 30081 : MYSQL Removing orphaned artists
02:26:51 : 30081 : SQL_QUERY Command Failed : CREATE TEMPORARY TABLE Croft(Artistindex INT UNSIGNED NOT NULL UNIQUE, PRIMARY KEY(Artistindex)) AS SELECT Artistindex FROM Trackta
ble UNION SELECT AlbumArtistindex FROM Albumtable
02:26:51 : 30081 : MYSQL MYSQL Error: : 1213 : Deadlock found when trying to get lock; try restarting transaction
02:26:51 : 30081 : SQL_QUERY Command Failed : CREATE TEMPORARY TABLE Cruft(Artistindex INT UNSIGNED NOT NULL UNIQUE, PRIMARY KEY(Artistindex)) AS SELECT Artistindex FROM Artistt
able WHERE Artistindex NOT IN (SELECT Artistindex FROM Croft)
02:26:51 : 30081 : MYSQL MYSQL Error: : 1146 : Table 'romprdb.Croft' doesn't exist
02:26:51 : 30081 : SQL_QUERY Command Failed : DELETE Artisttable FROM Artisttable INNER JOIN Cruft ON Artisttable.Artistindex = Cruft.Artistindex
02:26:51 : 30081 : MYSQL MYSQL Error: : 1146 : Table 'romprdb.Cruft' doesn't exist
02:26:51 : 30081 : MYSQL Tidying Metadata
02:27:11 : 30081 : MYSQL Updating Track Stats
02:27:11 : 30081 : TIMINGS Cruft Removal Took 02:31
02:27:11 : 30081 : TIMINGS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
02:27:11 : 30081 : DUMPALBUMS Generating artist aartistroot from database
02:27:11 : 30081 : TIMTINGS == Time Spent Reading Socket Data : 0
02:27:11 : 30081 : TIMTINGS == Time Spent Parsing Socket Data : 0
02:27:11 : 30081 : TIMTINGS == Time Spent Checking/Writing to Database : 0
02:27:11 : 30081 : TIMTINGS == Time Spent Putting Stuff into Collection Structures : 0
02:27:11 : 30081 : TIMTINGS == Time Spent Sorting Collection Structures : 9.5367431640625E-7
02:27:11 : 30081 : TIMINGS == Collection Update And Send took 06:42
02:27:11 : 30081 : COLLECTION Peak Memory Used Was 4,195,240 bytes - meaning we used 3,801,600 bytes.
02:27:11 : 30081 : TIMINGS ======================================================================
02:27:43 : 2143 : DIRBROWSER Browsing Beets library