svn-1441 crash on full (re-)scan

[Ted Harper]

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.

[rpedde]

@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?

[Ted Harper]

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.

[Author]

Posts