Home of the Squeezebox™ & Transporter® network music players.
Results 1 to 5 of 5
  1. #1
    Christian Pernegger
    Guest

    DB corruption again

    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.

  2. #2
    Steven Moore
    Guest

    DB corruption again

    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.
    >
    >
    >

  3. #3
    Perl Commando Dan Sully's Avatar
    Join Date
    Apr 2005
    Location
    Daly City, CA
    Posts
    2,865

    DB corruption again

    * 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.

  4. #4
    Perl Commando Dan Sully's Avatar
    Join Date
    Apr 2005
    Location
    Daly City, CA
    Posts
    2,865

    Re: DB corruption again

    * 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

  5. #5
    Perl Commando Dan Sully's Avatar
    Join Date
    Apr 2005
    Location
    Daly City, CA
    Posts
    2,865

    MySQL, Monkey's Audio and strange coincidences

    * 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •