You are here: Home » Topic » 1696 db corruption?

1696 db corruption?

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #2516
    ghedo
    Participant

    every 10 days or so.. someting goes wrong:
    I need to erase db and make a full rescan…

    mt-die and i i try to restart i got:

    2008-06-19 17:53:11 (b7d54aa0): Firefly Version svn-1696: Starting with debuglevel 2
    2008-06-19 17:53:11 (b7d54aa0): Plugin loaded: daap/svn-1696
    2008-06-19 17:53:11 (b7d54aa0): Plugin loaded: ssc-script/svn-1696
    2008-06-19 17:53:11 (b7d54aa0): Plugin loaded: rsp/svn-1696
    2008-06-19 17:53:11 (b7d54aa0): Starting rendezvous daemon
    2008-06-19 17:53:11 (b7d54aa0): Starting signal handler
    2008-06-19 17:53:11 (b7d54aa0): Initializing database
    2008-06-19 17:53:11 (b7d54aa0): Error: enum_fetch failed (error 1): ?
    2008-06-19 17:53:11 (b7d54aa0): Full reload…
    2008-06-19 17:53:11 (b7d54aa0): Error: enum_begin failed (error 1): Misc SQL Error: database disk image is malformed
    2008-06-19 17:53:11 (b7d54aa0): Error getting song count: Misc SQL Error: database disk image is malformed
    2008-06-19 17:53:11: Aborting
    2008-06-19 17:53:11 (b7d54aa0): Rendezvous socket closed (daap server crashed?) Aborting.
    2008-06-19 17:53:11: Aborting

    #17246
    w1ll14m
    Participant

    Do you have some log files of the moment mt-daapd / firefly crashes ?
    What kind of platform do you use ?

    How did you installed the package ?

    #17247
    stretch
    Participant

    svn-1696 is known to have db problems when using an sqlite2 database

    #17248
    ghedo
    Participant

    i’m using debian 4.0 kernel 2.6.18-5-686 #1 SMP

    i copiled the mt on my own
    ./configure –enable-sqlite3 –prefix=/air/daap/mt-daap/1696

    here the logs
    2008-06-18 17:27:44 (b7d1baa0): Rescanning database
    2008-06-18 17:28:08 (b2af7bb0): Write error: Broken pipe
    2008-06-18 17:28:10 (b7d1baa0): Starting playlist scan
    2008-06-18 17:28:12 (b7d1baa0): Updating playlists
    2008-06-18 17:28:13 (b7d1baa0): Scanned 26345 songs (was 26345) in 29 seconds
    2008-06-18 17:34:56 (b7d1baa0): Rescanning database
    2008-06-18 17:35:59 (b7d1baa0): Starting playlist scan
    2008-06-18 17:36:02 (b7d1baa0): Updating playlists
    2008-06-18 17:36:03 (b7d1baa0): Scanned 26345 songs (was 26345) in 67 seconds
    2008-06-18 17:41:22 (b2af7bb0): Session 0: Streaming file ’14 – Money.mp3′ from folder ‘/air/daap/contrib/alessio/PinkFloyd/1987 – Prism/14 – Money.mp3’ to 137.204.58.138 (offset 0)
    2008-06-18 17:41:30 (b2af7bb0): Write error: Broken pipe
    2008-06-18 17:42:47 (b7d1baa0): Rescanning database
    2008-06-18 17:43:48 (b7d1baa0): Starting playlist scan
    2008-06-18 17:43:50 (b7d1baa0): Updating playlists
    2008-06-18 17:43:50 (b7d1baa0): Scanned 26345 songs (was 26345) in 63 seconds
    2008-06-18 17:50:34 (b7d1baa0): Rescanning database
    2008-06-18 17:50:36 (b7d1baa0): Error reading: Invalid argument
    2008-06-18 17:50:36 (b7d1baa0): Skipping /air/daap/contrib/fra/The Album Leaf/In a Safe Place/01 Window.mp3 – scan failed
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:37 (b7d1baa0): opendir: Permission denied
    2008-06-18 17:50:39 (b7d1baa0): Error: enum_fetch failed (error 1): ?
    2008-06-18 17:50:39 (b7d1baa0): Query: UPDATE songs SET title=’02 – No Such As What I Want’,artist=’Bonnie “Prince” Billy’,album=’Singles’,genre=”,comment=”,type=’mp3′,composer=”,o
    rchestra=”,conductor=”,grouping=”,url=”,bitrate=192,samplerate=44100,song_length=211706,file_size=5081181,year=1998,track=2,total_tracks=0,disc=0,total_discs=0,time_modified=12073
    91272,db_timestamp=1213804239,bpm=0,disabled=0,compilation=0,rating=0,sample_count=0,codectype=’mpeg’,album_artist=” WHERE path=’/air/daap/contrib/fra/Bonni Prince Billy/Singles/02 0
    2 – No Such As What I Want.mp3′ and idx=0
    2008-06-18 17:50:39 (b7d1baa0): Error: database disk image is malformed
    2008-06-18 17:50:39 (b7d1baa0): Error updating file: 02 02 – No Such As What I Want.mp3
    2008-06-18 17:50:39: Aborting
    2008-06-18 17:50:40 (b7d1baa0): Rendezvous socket closed (daap server crashed?) Aborting.
    2008-06-18 17:50:40: Aborting

    #17249
    ghedo
    Participant

    mt crash again, im using sqlite 3.
    Any hints?

    2008-07-06 01:10:17 (b50ffbb0): Write error: Broken pipe
    2008-07-06 01:10:17 (b7d18aa0): Query: UPDATE songs SET title=’Die Eier Von Satan’,artist=’Tool’,album=’Ænima’,genre=”,comment=’ea12230f’,type=’mp3′,composer=
    ”,orchestra=”,conductor=”,grouping=”,url=”,bitrate=120,samplerate=44100,song_length=137221,file_size=2185968,year=1996,track=10,total_tracks=0,disc=0,tota
    l_discs=0,time_modified=1045502215,db_timestamp=1215299417,bpm=0,disabled=0,compilation=0,rating=0,sample_count=0,codectype=’mpeg’,album_artist=” WHERE path=’
    /air/daap/gbox/emy/Tool/nima/10-Die_Eier_Von_Satan.mp3′ and idx=0
    2008-07-06 01:10:17 (b7d18aa0): Error: database disk image is malformed
    2008-07-06 01:10:17 (b7d18aa0): Error updating file: 10-Die_Eier_Von_Satan.mp3
    2008-07-06 01:10:17: Aborting
    2008-07-06 01:10:17 (b7d18aa0): Rendezvous socket closed (daap server crashed?) Aborting.
    2008-07-06 01:10:17: Aborting

    #17250
    Anonymous
    Inactive

    Don’t know that !

Viewing 6 posts - 1 through 6 (of 6 total)
  • The forum ‘Nightlies Feedback’ is closed to new topics and replies.