You are here: Home » Topic » svn-1441 crash on full (re-)scan

svn-1441 crash on full (re-)scan

This topic contains 2 replies, has 2 voices, and was last updated by  Ted Harper 10 years, 8 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #838

    Ted Harper
    Participant

    I just did a full rescan on svn-1441 on my NSLU2 (which has previously been running fine) and it crashed as follows very early on the rescan (logged with -d 2):

    2006-12-01 08:24:43 (00000400): Rescanning database
    2006-12-01 08:24:54 (00000400): Query: UPDATE songs SET title=’Beautiful People’,artist=’Australian Crawl’,album=’Crawl File’,genre=’Pop’,comment=”,type=’mp3′,
    composer=’James Reyne’,orchestra=”,conductor=”,grouping=”,url=”,bitrate=192,
    samplerate=44100,song_length=177058,file_size=4271220,year=1979,
    track=1,total_tracks=14,disc=1,total_discs=1,
    time_modified=1162599111,db_timestamp=1164921894,bpm=0,
    disabled=0,compilation=0,rating=0,sample_count=0,
    codectype=’mpeg’,album_artist=”
    WHERE path=’/share/flash/data/public/Music/Australian Crawl/Crawl File/01 Beautiful People.mp3′ and idx=0
    2006-12-01 08:24:54 (00000400): Error: no such column: album_artist
    2006-12-01 08:24:54 (00000400): Error updating file: 01 Beautiful People.mp3
    2006-12-01 08:24:54: Aborting
    2006-12-01 08:24:54 (00000400): Rendezvous socket closed (daap server crashed?) Aborting.
    2006-12-01 08:24:54: Aborting

    Is this a problem with the database schema update code in 1441 which has failed to alter the table (I might have missed one or two nightlies over the last month or so, but generally try to keep up)?

    I have now physically erased the database and have just restarted Firefly to let it recreate the database then populate it from nothing.

    ted.h.

    #7624

    rpedde
    Participant

    @Ted Harper wrote:

    Is this a problem with the database schema update code in 1441 which has failed to alter the table (I might have missed one or two nightlies over the last month or so, but generally try to keep up)?

    Yeah, it should have done the upgrade on startup.

    What version did you upgrade from?

    #7625

    Ted Harper
    Participant

    Hi Ron:

    Not sure what the previous nightly was that I would have been on, but it seems the crash only occurred after I added a new CD and rescanned. That is, it was running fine on that nightly, only when it went to update the database that it failed.

    At a guess the only nightly I wouldn’t have updated to recently would be svn-1433 (ie I think I went from svn-1417 straight to svn-1441).

    Stopping Firefly, deleting the songs.db and restarting caused the database+schema recreation and scanning of everything to work fine (and seemed quite a bit quicker than last time I did that on the NSLU2 too!), so not a big problem by any stretch of the imagination.

    ted.h.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.