Quicker way to wipe MySQL music database
#1
I'm using a MySQL database and was trying to update my music library but it kept hanging at a particular artist judging by the OSD.

From the logs I can see a lot of "Failed to open" errors and I have rearranged a lot of the folders recently

Code:
11:16:30 T:6724   ERROR: Failed to open(//Music/Music (Tagged)/Hip Hop/Young MC - Stone Cold Rhymin' (1989)/) opendir call failed with "NFS: Lookup of //Music failed with NFS3ERR_NOENT(-2)"
11:16:30 T:6724   ERROR: XFILE::CDirectory::GetDirectory - Error getting nfs://192.168.1.69/Media/Music/Music (Tagged)/Hip Hop/Young MC - Stone Cold Rhymin' (1989)/
11:16:30 T:6008 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
11:17:31 T:5204 WARNING: Previous line repeats 1700338 times.

so I thought I'd just remove the source and re-add it, which would probably be quicker than cleaning it but since doing that, XBMC has been greyed out and says "Not Responding" and Mysqld.exe has been pegged at 22-25%. Perhaps it will complete soon but it's been going for about 5mins already and I wouldn't think it should take that long to remove a source (if I was using normal XBMC databases I would have just deleted the file, which would have taken seconds), so I'm just wondering if there's a quicker way to clear a source from a Mysql database?
Reply
#2
Quickest way is to drop the database using a MySQL management tool.
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Reply
#3
OK, that will obviously lose the Movies and TV Shows as well though.

I've currently gone back to a normal XBMC database and am scanning the music into a clean database but it seems to be having some problems with that as well.

There were a number (maybe 20) of these "Could not find" errors but they dont' seem to be an issue. Strangely, whenever XBMC seems to have got stuck, as it has at the moment, it's showing it's got to Sinead O' Connor (Well I can only see Sinea but I don't think I have anything else it could be!)

Quote:12:04:02 T:4072 ERROR: Could not find 'nfs://192.168.1.69/Media/Music/Music (Tagged)/Prodigy - Music For The Jilted Generation/08 Poison.wav' referenced in cue, case sensitivity issue?
12:07:03 T:6208 NOTICE: Thread FileCache start, auto delete: false
12:07:03 T:4072 WARNING: WAVCodec::Init - Wave has corrupt data length of 2361384 when it can't be longer then 0
12:07:03 T:4072 WARNING: WAVCodec::Init - Empty data chunk, will look for another
12:07:03 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:10:07 T:3596 WARNING: Previous line repeats 5598879 times.
12:10:07 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:10:07 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:13:11 T:3596 WARNING: Previous line repeats 6955887 times.
12:13:11 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:13:11 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:16:16 T:3596 WARNING: Previous line repeats 6750185 times.
12:16:16 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:16:16 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:19:20 T:3596 WARNING: Previous line repeats 7214399 times.
12:19:20 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:19:20 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:22:24 T:3596 WARNING: Previous line repeats 7890077 times.
12:22:24 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:22:24 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:25:28 T:3596 WARNING: Previous line repeats 7769283 times.
12:25:28 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:25:28 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:27:24 T:3428 WARNING: Previous line repeats 4882380 times.
12:27:24 T:3428 NOTICE: Thread JobWorker start, auto delete: true
12:27:24 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:28:32 T:3596 WARNING: Previous line repeats 2812159 times.
12:28:32 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:28:32 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:31:36 T:3596 WARNING: Previous line repeats 7762668 times.
12:31:36 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:31:36 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:34:40 T:3596 WARNING: Previous line repeats 7484915 times.
12:34:40 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:34:40 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:37:44 T:3596 WARNING: Previous line repeats 7550441 times.
12:37:44 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:37:44 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:40:48 T:3596 WARNING: Previous line repeats 7673921 times.
12:40:48 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:40:48 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:43:53 T:3596 WARNING: Previous line repeats 7562538 times.
12:43:53 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:43:53 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:46:57 T:3596 WARNING: Previous line repeats 7736853 times.
12:46:57 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:46:57 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:50:01 T:3596 WARNING: Previous line repeats 7630007 times.
12:50:01 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:50:01 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:53:05 T:3596 WARNING: Previous line repeats 7529932 times.
12:53:05 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:53:05 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
12:56:09 T:3596 WARNING: Previous line repeats 6426283 times.
12:56:09 T:3596 NOTICE: NFS: sending keep alive after 180 s.
12:56:09 T:4072 WARNING: XFILE::CFileCache::Seek - failed to get remaining data
Reply
#4
You have two databases, MyMusic and MyVideo so in your case you'd just drop the music database and leave your video database alone.

Just looking at your logs, that's some pretty insane rate limiting you've got going on there... just wondering if your NFS connection isn't getting hosed, is it any better with an OS mount?
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Reply
#5
(2013-08-15, 14:03)MilhouseVH Wrote: You have two databases, MyMusic and MyVideo so in your case you'd just drop the music database and leave your video database alone.

Ah I see, thanks.

Quote:Just looking at your logs, that's some pretty insane rate limiting you've got going on there... just wondering if your NFS connection isn't getting hosed, is it any better with an OS mount?

This is with XBMC running on the same PC as the NFS server (Hanewin) so I could point directly to the folder, or share it as an SMB but I need to use NFS for the XBMC so that's what I need to concentrate on getting working reliably.
Reply
#6
(2013-08-15, 14:39)doveman2 Wrote: This is with XBMC running on the same PC as the NFS server (Hanewin) so I could point directly to the folder, or share it as an SMB but I need to use NFS for the XBMC so that's what I need to concentrate on getting working reliably.

In that case it certainly looks like NFS isn't working too well... I know nothing about Hanewin so can't give any advice there.
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Reply
#7
OK, it's something for another thread anyway.
Reply

Logout Mark Read Team Forum Stats Members Help
Quicker way to wipe MySQL music database0