[MySQL] Help With Library
#1
Hello!

This past weekend I've finally made the move from Eden to Frodo, however across all my installs I'm experiencing issues with my library.

I can go in and start an episode (either after booting or just starting an episode following a period of time away from the screen), however upon finishing the episode or even stopping and then trying to start another episode (navigation and selection are fine), XBMC seems to freeze, and then 45 seconds up to 2 minutes later it will start the new episode. I also noticed that the previous episode is not set as watched immediately.

My system is setup as follows:

XBMCbuntu on an ASRock ION 330HT - connected via ethernet
XBMC on OS X, connected via wifi
XBMC on Win 7 Desktop, connected via wifi
XBMC on Win 7 Laptop, connected via wifi
Synology NAS running MySQL and sharing everything via NFS, connected via ethernet

All systems are using path substitution (carried over from Eden install)

I've never had a problem like this with Eden, does anyone have an idea as to why this is happening? I've attached a debug log from my OS X laptop below:
http://xbmclogs.com/show.php?id=42423

It's not a deal-breaker, however it is insanely annoying...

I should also note that when I enque another episode to start up following the current one with XBMC Commander on my phone, the file starts immediately, it seems to only be an issue with navigating through the library itself...

Thank you!
Reply
#2
I remember something like this when first setting it up a while ago and it was SQL related. What do the logs say?
Reply
#3
Not sure if it's the same but this user had Synology/MySql problems that he fixed http://forum.xbmc.org/showthread.php?tid=162603&page=9
If I have been of help, please add to my reputation as a way of saying thanks, it's free.
Reply
#4
Thanks all for the help, reading that other tread gave me some ideas and I found this:

ALTER TABLE writerlinkmovie ENGINE=InnoDB;
ALTER TABLE writerlinkepisode ENGINE=InnoDB;
ALTER TABLE version ENGINE=InnoDB;
ALTER TABLE tvshowlinkpath ENGINE=InnoDB;
ALTER TABLE tvshow ENGINE=InnoDB;
ALTER TABLE taglinks ENGINE=InnoDB;
ALTER TABLE tag ENGINE=InnoDB;
ALTER TABLE studiolinktvshow ENGINE=InnoDB;
ALTER TABLE studiolinkmusicvideo ENGINE=InnoDB;
ALTER TABLE studiolinkmovie ENGINE=InnoDB;
ALTER TABLE studio ENGINE=InnoDB;
ALTER TABLE streamdetails ENGINE=InnoDB;
ALTER TABLE stacktimes ENGINE=InnoDB;
ALTER TABLE settings ENGINE=InnoDB;
ALTER TABLE sets ENGINE=InnoDB;
ALTER TABLE seasons ENGINE=InnoDB;
ALTER TABLE path ENGINE=InnoDB;
ALTER TABLE musicvideo ENGINE=InnoDB;
ALTER TABLE movielinktvshow ENGINE=InnoDB;
ALTER TABLE movie ENGINE=InnoDB;
ALTER TABLE genrelinktvshow ENGINE=InnoDB;
ALTER TABLE genrelinkmusicvideo ENGINE=InnoDB;
ALTER TABLE genrelinkmovie ENGINE=InnoDB;
ALTER TABLE genre ENGINE=InnoDB;
ALTER TABLE files ENGINE=InnoDB;
ALTER TABLE episode ENGINE=InnoDB;
ALTER TABLE directorlinktvshow ENGINE=InnoDB;
ALTER TABLE directorlinkmusicvideo ENGINE=InnoDB;
ALTER TABLE directorlinkmovie ENGINE=InnoDB;
ALTER TABLE directorlinkepisode ENGINE=InnoDB;
ALTER TABLE countrylinkmovie ENGINE=InnoDB;
ALTER TABLE country ENGINE=InnoDB;
ALTER TABLE bookmark ENGINE=InnoDB;
ALTER TABLE artistlinkmusicvideo ENGINE=InnoDB;
ALTER TABLE art ENGINE=InnoDB;
ALTER TABLE actors ENGINE=InnoDB;
ALTER TABLE actorlinktvshow ENGINE=InnoDB;
ALTER TABLE actorlinkmovie ENGINE=InnoDB;
ALTER TABLE actorlinkepisode ENGINE=InnoDB;

Seems to be working super fast now Smile
Reply

Logout Mark Read Team Forum Stats Members Help
[MySQL] Help With Library0