PDA

View Full Version : DB corruption again



Christian Pernegger
2005-03-18, 05:29
The DB code and / or the search code are in dire need of an audit.

I ripped a new album today, copied it to my music folder and hit rescan.
Some time later I actually want to listen to some stuff, but upon entering
'elton' in search music=>search artists via the remote I don't get Elton
John, I get Alanis Morissette, who is allegedly the artist for most of my
anime soundtracks and a few Elton John tracks. Same results with live search
on the web interface - the associations between artists, albums and songs
seem nearly randomized.

This is on a nightly from a few days ago
(SlimServer_v2005-03-16.no-cpan-tar), can't tell you the exact version
because the web interface does not show a revision anymore, just a lonely 0
a line _below_ the 'SlimServer Version: 6.0b1' The slimserver worked fine
yesterday evening and I haven't touched it or the server machine since then.

Basically I have been having problems with every rescan - I just default to
deleting the db now when I add something. Seeing as I don't have a version
number anymore, something's corrupting more than the db.

C.

Steven Moore
2005-03-18, 07:50
Maybe the db is at fault for my particular problem of not showing all
the songs in a particular album or search.
By not showing I mean it displays (1 of 15) of an album but when you
press down on the remote to see the next track the track name is blank.
The next one may display and the next one may be blank. Still happening
on 17th nightly. Rescan stops now after 50 mins which is long but an
improvement but I am still seeing 70% cpu usage under normal
conditions.

imac 10.3.8. 512mb, 800mhz

Steven Moore

On 18 Mar 2005, at 12:29 pm, Christian Pernegger wrote:

> The DB code and / or the search code are in dire need of an audit.
>
> I ripped a new album today, copied it to my music folder and hit
> rescan. Some time later I actually want to listen to some stuff, but
> upon entering 'elton' in search music=>search artists via the remote I
> don't get Elton John, I get Alanis Morissette, who is allegedly the
> artist for most of my anime soundtracks and a few Elton John tracks.
> Same results with live search on the web interface - the associations
> between artists, albums and songs seem nearly randomized.
>
> This is on a nightly from a few days ago
> (SlimServer_v2005-03-16.no-cpan-tar), can't tell you the exact version
> because the web interface does not show a revision anymore, just a
> lonely 0 a line _below_ the 'SlimServer Version: 6.0b1' The slimserver
> worked fine yesterday evening and I haven't touched it or the server
> machine since then.
>
> Basically I have been having problems with every rescan - I just
> default to deleting the db now when I add something. Seeing as I don't
> have a version number anymore, something's corrupting more than the
> db.
>
> C.
>
>
>

Dan Sully
2005-03-18, 09:55
* Christian Pernegger shaped the electrons to say...

>On another note, who's in favor of scrapping live search? With recent
>nightlies it works 2 times out of 3 for me, but only if I don't type too
>fast or use backspace because I mis-typed. Most of the time I have to hit
>the button, which then returns empty results. (I might get an artist with
>no albums or an album with no songs - count is correct, though) This is on
>Firefox 1.01.
>
>I think a web interface is just not a very 'live' medium. I'm fine with
>having to hit enter and getting a results page.

Christian - the live and the button press search should return the exact same results.

Could you please send me your messed up slimserversql.db file?

Thanks.

-D
--
<nil> It sucks to discover that you are the foremost authority on some set of things when you've got a problem.

Dan Sully
2005-03-18, 13:28
* Christian Pernegger shaped the electrons to say...

>Sometimes they do, sometimes they don't. When the live search does not
>trigger, i. e. I click on 'Search Music' and type into the box but it does
>nothing, clicking on the button will return the strange results.

--d_sql would be useful there.

>>Could you please send me your messed up slimserversql.db file?
>
>Ah, sorry... I didn't think to keep it - deleting it helped, as always.
>
>Will get back to you when it goes bonkers again - in 2 days, most likely.
>
>Any debug options I should turn on or anything I should do next time either problem happens?

Again --d_sql

Thanks.

-D
--
<iNoah> all your base class are belong to us

Dan Sully
2005-03-18, 15:14
* Christian Pernegger shaped the electrons to say...

>Because of my DB problems I tried switching to the MySQL backend, which is
>already supported enough that it took me all of 15 minutes, including
>installing the server, with no previous experience in the area. Since then
>I've bombarded the live search with test searches, no probem, let's see if
>it stays that way.
>
>The strange thing: with MySQL backend my song count is up by about 100. It
>was a pleasant surprise to find that slimserver now recognizes and plays
>the odd .ape albums that I've not yet transcoded to .flac. With the SQLite
>backend there'd be a 'could not create track' error in the log for each
>.ape track.

Could you get me the error message?

Thanks.

-D
--
"It has become appallingly obvious that our technology has exceeded our humanity." - Albert Einstein