Problems connecting to Music DB
#1
Hello...

Everytime XBMC tries to connect to DB, have this error:

Code:
ERROR: SQLite: SQL error or missing database

Complete log:
http://pastebin.com/f374ba663

(while scanning)
Code:
feanor@FEANORTV:~/.xboxmediacenter/userdata/Database$ ll
total 1,8M
drwxr-xr-x 3 feanor feanor  121 2008-04-13 12:34 .
drwxr-xr-x 7 feanor feanor 4,0K 2008-04-10 23:55 ..
drwxr-xr-x 2 feanor feanor    6 2008-04-10 21:55 CDDB
-rw-r--r-- 1 feanor feanor 192K 2008-04-13 12:34 MyMusic7.db
-rw-r--r-- 1 feanor feanor 1,0K 2008-04-13 12:34 MyMusic7.db-journal
....

When I stop scanning (due to it is not working too much and it is having long time), XBMC suddenly crash and go.... landing at gnome...

Code:
11:37:33 T:3062282080 M: 90243072   DEBUG: Update - NEW at 1458806:000000037ff07bdc 00 Back mceusb
11:37:33 T:3062282080 M: 90243072   DEBUG: OnKey: 216 pressed, action is 9
11:37:33 T:3062282080 M: 90243072   DEBUG: CGUIMediaWindow::GetDirectory ()
11:37:33 T:3062282080 M: 90243072   DEBUG:   ParentPath = []
11:37:33 T:3012549520 M: 90243072   DEBUG: Running thread 3012549520
11:37:33 T:3012549520 M: 90243072   DEBUG: thread start, auto delete: 0
11:37:33 T:3012549520 M: 90243072   DEBUG: Loading fileitems []
11:37:33 T:3012549520 M: 90243072   DEBUG:   -- items: 2, directory:  sort method: 0, ascending: false
11:37:33 T:3012549520 M: 90243072   ERROR: SQLite: SQL error or missing database
                             Query: select * from songview where strPath like '/'
11:37:33 T:3012549520 M: 90243072   ERROR: GetSongsByPath(/) failed
11:37:33 T:3012549520 M: 90243072   DEBUG: Saving fileitems []
11:37:33 T:3012549520 M: 90243072   DEBUG:   -- items: 2, sort method: 0, ascending: false
11:37:33 T:3012549520 M: 90243072   DEBUG: staticThread, deleting thread graphic context
11:37:33 T:3062282080 M: 90243072   DEBUG: RetrieveMusicInfo() took 6 msec
11:37:33 T:3062282080 M: 90243072   DEBUG: Sort, sorting took 0 millis
11:37:33 T:3012549520 M: 90243072   DEBUG: Thread 3012549520 terminating
11:37:33 T:3062282080 M: 90243072   DEBUG: Load DefaultAddSource.png: 2.3ms (bundled)
11:37:33 T:2967813008 M: 90243072   DEBUG: Running thread 2967813008
11:37:33 T:2967813008 M: 90243072   DEBUG: thread start, auto delete: 0
11:37:33 T:2967813008 M: 90243072   DEBUG: staticThread, deleting thread graphic context
11:37:33 T:2967813008 M: 90243072   DEBUG: Thread 2967813008 terminating
11:37:33 T:3062282080 M: 90243072   DEBUG: Load folder-focus.png: 0.5ms (bundled)
11:37:33 T:3062282080 M: 90243072   DEBUG: Load defaultHardDiskBig.png: 2.4ms (bundled)
11:37:34 T:2774780816 M: 90202112   DEBUG: Recv, timeout on recv.
11:37:34 T:2774780816 M: 90202112   ERROR: Recv failed in ReadData(4): 115
(and crashed)

Then I go into Database folder and the MyMusic7.db-journal file has dissapeared, but MyMusic7.db is still taking 192Kb.

If I try finally to "clean music database" from settings menu, also have error:

Code:
11:42:02 T:3061897056 M: 59322368   DEBUG: Load progress_back2.png: 0.3ms (bundled)
11:42:02 T:3061897056 M: 59322368   DEBUG: Load progress_over.png: 2.3ms (bundled)
11:42:02 T:3061897056 M: 59322368   DEBUG: Load keyboard-btn-backspace-focus.png: 1.2ms (bundled)
11:42:02 T:3061897056 M: 59322368   DEBUG: Load keyboard-btn-backspace.png: 0.2ms (bundled)
11:42:02 T:3061897056 M: 59322368   DEBUG: Alloc resources: 4.87ms (0.02 ms skin load, 0.20 ms preload)
11:42:02 T:3061897056 M: 59322368   DEBUG: Load dialog-panel.png: 2.1ms (bundled)
11:42:02 T:3061897056 M: 59322368   DEBUG: Checking songs from song ID list: (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72)
11:42:02 T:3061897056 M: 59281408   ERROR: SQLite: SQL error or missing database
                             Query: delete from exartistsong where idSong in ()
11:42:02 T:3061897056 M: 59281408   ERROR: Exception in CMusicDatabase::CleanupSongsFromPaths()
11:42:02 T:3061897056 M: 59281408    INFO: Loading skin file: DialogOK.xml
11:42:02 T:3061897056 M: 59281408   DEBUG: Load DialogOK.xml: 4.11ms (2.08 ms xml load)
11:42:02 T:3061897056 M: 59281408   DEBUG: ------------------- GUI_MSG_WINDOW_INIT

I do not have much idea what could I do now to make it working... it is such new compilation from 3 days' SVN build.
Reply
#2
Strange. I presume you've deleted the db and started from scratch and it still happens?

Cheers,
Jonathan
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#3
jmarshall Wrote:Strange. I presume you've deleted the db and started from scratch and it still happens?

Cheers,
Jonathan

Well.. that´s the fix.. remove the MyMusic7.db and restart XBMC. New one would be created and now it is managing database correctly...

Thanks and sorry.. I should try it before posting, but I didn't know if xbmc re-creates the database if it does not exists. Next time I will test making backups before wasting your time... sincerelly...

Wink
Reply

Logout Mark Read Team Forum Stats Members Help
Problems connecting to Music DB0