I have a problem when I try to enter jukebox mode. I think it is a data issue with some of my Artist tags (missing, bad characters, etc).

My trio log file has:

Aug 22, 2004 10:10:59 AM trio.player.TRioPlayerJukeboxDlg <init>
INFO: *** start of TRioPlayerJukeboxDlg
Aug 22, 2004 10:11:01 AM trio.player.TRioPlayerJRecServer listArtists
WARNING: Exception listing Artists
Message: xmlrpc-problem invoking method [Menus.getArtistMenuRecs]
Root cause: org.apache.xmlrpc.XmlRpcException: jreceiver.common.rpc.RpcException: bus-problem getting artist menu recs
at org.apache.xmlrpc.XmlRpcClient$Worker.execute(Unknown Source)

etc...

So, my question is, can anybody recommend an easy way to find the problem items? Using the trio server? Jreceiver? A MySQl query? Or do I need to flush my music & DB, and add it back in groups, hoping to discover the problem item?

I don't want to re-tag all of my MP3s


Bryan: tRio 0.1.5, Jreceiver 0.2.5 running Debian Sarge AMD-K6 300mhz 128mb mem, only 5k mp3s using 15gb, 2 Dell, 2 rebadged SonicBlue DARs

Bryan,

This is a JReceiver problem and so you should be able to find more details in the JReceiver logs. I don't know how much detail it'll go into, but with any luck it'll give you the SQL query text.

Let me know what you find.

Cheers
Paul

Yes, I understand. I can see the artist list coming from Jreceiver (using http://site:8080/query?artist= and they are all there, no problems.

I must confess I have not been able to get Jreceiver's logging to do exactly what I want, but I don't see any messages during the Jukebox startup that suggest a problem. I'm working more on this.

I suspect a bad character of some type, and if you know of stuff that tRiot would gag on, let me know.

I also have been able to isolate the problem to a group of only about 50 songs, so it won't be hard to track down, just a very manual process. I'll let you know what I find.

Bryan: tRio 0.1.5, Jreceiver 0.2.5 running Debian Sarge AMD-K6 300mhz 128mb mem, only 5k mp3s using 15gb, 2 Dell, 2 rebadged SonicBlue DARs

Bryan,

I'm not sure that you'll be able to get any more detail from the tRio-side. All it gets is the error response that you see in the logs.

And I'll leave you to your "manual process".

Cheers
Paul

I found it. It was a song with a non-standard Genre.

I must confess I don't know exactly who is failing (Jreceiver or Trio) but here is what I do know. Jreceiver seems to be able to catalog and serve up the song. But when Trio is updating the Jukebox Artist list a SQL query like this is generated:

SELECT artist.name,COUNT(*)
FROM artist
LEFT JOIN tune ON tune.artist_id=artist.id
LEFT JOIN source ON source.id=tune.src_id
LEFT JOIN source_genre ON tune.src_id=source_genre.src_id
LEFT JOIN genre ON source_genre.genre_id=genre.id
WHERE genre.name REGEXP '' AND mime_id & 13
GROUP BY artist.name

This query fails on the REGEXP '' when it hits the bogus Genre.


Bryan: tRio 0.1.5, Jreceiver 0.2.5 running Debian Sarge AMD-K6 300mhz 128mb mem, only 5k mp3s using 15gb, 2 Dell, 2 rebadged SonicBlue DARs

So what exactly did this non-standard genre contain?