Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: Banshee crashes

  1. #1
    Join Date
    Jan 2005
    Beans
    438

    Banshee crashes

    I can't use Banshee after upgrading to Intrepid on my TiBook G4. Evertime I try to run it I get an error:
    Code:
    banshee An unhandled exception was thrown: SQL logic error or missing database
    And a whole lot more. I've googled and i get suggestions to delete the banshe files in ~/.config and ~/.gconf as the symptom is of a corrupted sqlite database. this doesn't work as the files get recreated and the same error happens.

    The full error:
    Code:
    An unhandled exception was thrown: SQL logic error or missing database
    
      at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt, System.Int32& cols, System.IntPtr& pazValue, System.IntPtr& pazColName) [0x00000] 
    Banshee.Core (1.2.1.19110)
    Banshee.Services (1.2.1.19112)
    Banshee.ThickClient (1.2.1.19117)
    Nereid (1.2.1.19119)
    mscorlib (2.0.0.0)
    
    Platform Information: Linux 2.6.25-2-powerpc ppc unknown GNU/Linux
    
    Disribution Information:
    
    [/etc/lsb-release]
    DISTRIB_ID=Ubuntu
    DISTRIB_RELEASE=8.10
    DISTRIB_CODENAME=intrepid
    DISTRIB_DESCRIPTION="Ubuntu 8.10"
      at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt) [0x00000] 
      at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior, Boolean want_results, System.Int32& rows_affected) [0x00000] 
      at Mono.Data.SqliteClient.SqliteCommand.ExecuteNonQuery () [0x00000] 
      at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute (Hyena.Data.Sqlite.HyenaSqliteConnection hconnection, Mono.Data.SqliteClient.SqliteConnection connection) [0x00000] 
    Exception has been thrown by the target of an invocation.
    
      at System.Reflection.MonoCMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] 
      at System.Reflection.MonoCMethod.Invoke (BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] 
      at System.Reflection.ConstructorInfo.Invoke (System.Object[] parameters) [0x00000] 
      at System.Activator.CreateInstance (System.Type type, Boolean nonPublic) [0x00000] 
      at System.Activator.CreateInstance (System.Type type) [0x00000] 
      at Banshee.Gui.GtkBaseClient.Startup () [0x00000] 
    at Hyena.Gui.CleanRoomStartup.Startup (Hyena.Gui.StartupInvocationHandler startup) [0x00000] 
    
    .NET Version: 2.0.50727.42
    OS Version: Unix 2.6.25.2
    
    Assembly Version Information:
    
    Migo (1.2.1.19106)
    Banshee.Podcasting (1.2.1.19134)
    Lastfm (1.2.1.19109)
    Banshee.Lastfm (1.2.1.19129)
    notify-sharp (0.4.0.0)
    Banshee.NotificationArea (1.2.1.19132)
    Banshee.CoverArt (1.2.1.19125)
    Banshee.Bookmarks (1.2.1.19124)
    Banshee.MultimediaKeys (1.2.1.19131)
    Banshee.Daap (1.2.1.19126)
    Banshee.AudioCd (1.2.1.19123)
    pango-sharp (2.12.0.0)
    Mono.Cairo (2.0.0.0)
    Banshee.Widgets (1.2.1.19114)
    Banshee.Dap.Ipod (1.2.1.19120)
    Banshee.Dap (1.2.1.19120)
    Banshee.Hal (1.2.1.19135)
    Banshee.Unix (1.2.1.19137)
    Banshee.GStreamer (1.2.1.19137)
    gconf-sharp (2.20.0.0)
    Banshee.Gnome (1.2.1.19136)
    Banshee.NowPlaying (1.2.1.19133)
    System.Transactions (2.0.0.0)
    System.Xml (2.0.0.0)
    System.Data (2.0.0.0)
    Mono.Data.SqliteClient (2.0.0.0)
    Mono.Addins (0.3.0.0)
    atk-sharp (2.12.0.0)
    Hyena.Gui (1.2.1.19104)
    NDesk.DBus.Proxies (0.0.0.0)
    Mono.Posix (2.0.0.0)
    NDesk.DBus.GLib (1.0.0.0)
    NDesk.DBus (1.0.0.0)
    gtk-sharp (2.12.0.0)
    Hyena (1.2.1.19102)
    System (2.0.0.0)
    glib-sharp (2.12.0.0)
    gdk-sharp (2.12.0.0)
    Banshee.Core (1.2.1.19110)
    Banshee.Services (1.2.1.19112)
    Banshee.ThickClient (1.2.1.19117)
    Nereid (1.2.1.19119)
    mscorlib (2.0.0.0)
    
    Platform Information: Linux 2.6.25-2-powerpc ppc unknown GNU/Linux
    
    Disribution Information:
    
    [/etc/lsb-release]
    DISTRIB_ID=Ubuntu
    DISTRIB_RELEASE=8.10
    DISTRIB_CODENAME=intrepid
    DISTRIB_DESCRIPTION="Ubuntu 8.10"
    [/etc/debian_version]
    lenny/sid
    Any suggestions?

  2. #2
    Join Date
    Jan 2005
    Beans
    438

    Re: Banshee crashes

    I also ran banshee in a terminal:
    Code:
    :~$ banshee -dbg
    [Info  15:43:16.767] Running Banshee 1.2.1
    [Info  15:43:22.334] All services are started 5.018567s
    Exception has been thrown by the target of an invocation.
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Mono.Data.SqliteClient.SqliteExecutionException: SQL logic error or missing database
      at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt, System.Int32& cols, System.IntPtr& pazValue, System.IntPtr& pazColName) [0x00000] 
      at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt) [0x00000] 
      at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior, Boolean want_results, System.Int32& rows_affected) [0x00000] 
      at Mono.Data.SqliteClient.SqliteCommand.ExecuteNonQuery () [0x00000] 
      at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute (Hyena.Data.Sqlite.HyenaSqliteConnection hconnection, Mono.Data.SqliteClient.SqliteConnection connection) [0x00000] --- End of inner exception stack trace ---
    
      at System.Reflection.MonoCMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] 
      at System.Reflection.MonoCMethod.Invoke (BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] 
      at System.Reflection.ConstructorInfo.Invoke (System.Object[] parameters) [0x00000] 
      at System.Activator.CreateInstance (System.Type type, Boolean nonPublic) [0x00000] 
      at System.Activator.CreateInstance (System.Type type) [0x00000] 
      at Banshee.Gui.GtkBaseClient.Startup () [0x00000] 
      at Hyena.Gui.CleanRoomStartup.Startup (Hyena.Gui.StartupInvocationHandler startup) [0x00000]
    Maybe a Mono issue?

  3. #3
    Join Date
    Mar 2009
    Beans
    1

    Re: Banshee crashes

    I was having this problem myself. To fix this problem, I did the following:

    > mv ~/.config/banshee-1 ~/.config/banshee-1.bak
    > rm -rf ~/.cache/.banshee-1

    Deleting .cache/banshee-1 just by itself doesn't appear to do much of anything at all. I just did it because I figured (just a guess) that it wouldn't hurt.

    The real part of the fix is renaming .config/banshee-1.

    The problem with this fix is that all of your settings and library definitions will go away. This means you'll have to re-import everything back into Banshee (including artwork).

  4. #4
    Join Date
    Jan 2005
    Beans
    438

    Re: Banshee crashes

    That works-thanks!

  5. #5
    Join Date
    Mar 2009
    Beans
    14

    Re: Banshee crashes

    carl@carl-laptop:~$ > mv ~/.config/banshee-1 ~/.config/banshee-1.bak
    bash: /home/carl/.config/banshee-1: is a directory
    carl@carl-laptop:~$ > rm -rf ~/.cache/.banshee-1
    bash: -rf: command not found
    what am I doing wrong?

  6. #6
    Join Date
    Mar 2008
    Location
    The Bahamas
    Beans
    129
    Distro
    Ubuntu 9.04 Jaunty Jackalope

    Re: Banshee crashes

    Quote Originally Posted by carlf View Post
    carl@carl-laptop:~$ > mv ~/.config/banshee-1 ~/.config/banshee-1.bak
    bash: /home/carl/.config/banshee-1: is a directory
    carl@carl-laptop:~$ > rm -rf ~/.cache/.banshee-1
    bash: -rf: command not found
    what am I doing wrong?
    I had the same problem so I did

    cp ~/.config/banshee-1 ~/.config/banshee-1.bak

    then
    rm -rf ~/.config/banshee-1 ~/.config/banshee-1.bak

    It's the same thing (basically) but with two commands
    Registered Linux User #487144 | Registered Ubuntu User #26606

  7. #7
    Join Date
    Nov 2007
    Location
    Scandinavia
    Beans
    Hidden!
    Distro
    Ubuntu

    Re: Banshee crashes

    Quote Originally Posted by matrixblue View Post
    I had the same problem so I did

    cp ~/.config/banshee-1 ~/.config/banshee-1.bak

    then
    rm -rf ~/.config/banshee-1 ~/.config/banshee-1.bak

    It's the same thing (basically) but with two commands
    Thanks, this did the trick.

  8. #8
    Join Date
    Oct 2006
    Location
    /dev/null
    Beans
    1,574
    Distro
    Ubuntu 10.04 Lucid Lynx

    Re: Banshee crashes

    Quote Originally Posted by Machiavelli View Post
    Thanks, this did the trick.
    ... why back up the config, then immediately delete the backup?
    Understanding is a three-edged sword: Your side, their side, and the truth

  9. #9
    Join Date
    Mar 2008
    Location
    The Bahamas
    Beans
    129
    Distro
    Ubuntu 9.04 Jaunty Jackalope

    Re: Banshee crashes

    Quote Originally Posted by directhex View Post
    ... why back up the config, then immediately delete the backup?
    That's a typo. The second command should read

    rm -rf ~/.config/banshee-1
    Registered Linux User #487144 | Registered Ubuntu User #26606

  10. #10
    Join Date
    Apr 2006
    Location
    Murray, Utah
    Beans
    26
    Distro
    Ubuntu

    Re: Banshee crashes

    you could just:

    Code:
    cd ~/.config/banshee-1
    sqlite3 banshee.db ".dump" > dump
    mv banshee.db banshee.db.backup
    cat dump | sqlite3 banshee.db
    That will attempt to rebuild your DB. But then again that is just my $.02 for what it is worth.
    Last edited by heartsbane; August 31st, 2009 at 10:39 PM.

Page 1 of 2 12 LastLast

Tags for this Thread

Bookmarks

Posting Permissions

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