crash when clearing large number of files from the library

[Richard Harding]

Binary package hint: banshee

I'm using Ubuntu Gutsy and banshee package: 0.13.0+dfsg-1

I have several thousand files in my library and I'm trying to clear the library. When I attempt to clear them it starts and then dies with the dump below. I can remove small numbers of files at a time so it just seems to be due to the number of files in the library I want to remove.

Exception in Gtk# callback delegate
  Note: Applications can use GLib.ExceptionManager.UnhandledException to handle the exception.
Mono.Data.SqliteClient.SqliteSyntaxException: Expression tree is too large (maximum depth 1000)
  at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (IntPtr pzStart, System.IntPtr& pzTail, System.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 Banshee.Database.QueuedSqliteCommand.Execute () [0x00000]

   at GLib.ExceptionManager.RaiseUnhandledException ()
   at GLib.Signal.voidObjectCallback ()
   at GLib.Signal.voidObjectCallback ()
   at Gtk.Application.gtk_main ()
   at Gtk.Application.gtk_main ()
   at Gtk.Application.Run ()
   at Gnome.Program.Run ()
   at Banshee.BansheeEntry.Startup ()
   at System.MulticastDelegate.invoke_void_string[] ()
   at Banshee.Gui.CleanRoomStartup.Startup ()
   at Banshee.BansheeEntry.Main ()

[Pedro Villavicencio (pedro)]

Thanks for your report, is this still an issue with banshee from Gutsy?

[Richard Harding (rharding)]

I just tried it again and got this, total tracks 2955 in the library.

Debug: [10/11/2007 5:20:57 PM] (Enabled multimedia keys support) - Using org.gnome.SettingsDaemon
Exception in Gtk# callback delegate
  Note: Applications can use GLib.ExceptionManager.UnhandledException to handle the exception.
Mono.Data.SqliteClient.SqliteSyntaxException: Expression tree is too large (maximum depth 1000)
  at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (IntPtr pzStart, System.IntPtr& pzTail, System.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 Banshee.Database.QueuedSqliteCommand.Execute () [0x00056] in /build/buildd/banshee-0.13.1+dfsg/src/Core/Banshee.Base/QueuedSqliteDatabase.cs:214

   at GLib.ExceptionManager.RaiseUnhandledException ()
   at GLib.Signal.voidObjectCallback ()
   at GLib.Signal.voidObjectCallback ()
   at Gtk.Application.gtk_main ()
   at Gtk.Application.gtk_main ()
   at Gtk.Application.Run ()
   at Gnome.Program.Run ()
   at Banshee.BansheeEntry.Startup () in /build/buildd/banshee-0.13.1+dfsg/src/Core/Banshee/Main.cs:line 118
   at System.MulticastDelegate.invoke_void_string[] ()
   at Banshee.Gui.CleanRoomStartup.Startup () in /build/buildd/banshee-0.13.1+dfsg/src/Core/Banshee.Base/Gui/CleanRoomStartup.cs:line 54
   at Banshee.BansheeEntry.Main () in /build/buildd/banshee-0.13.1+dfsg/src/Core/Banshee/Main.cs:line 43

[Richard Harding (rharding)]

Sorry, forgot to include that this is not up to version:
0.13.1+dfsg-3

[boast (magshell)]

Ubuntu Gutsy 2.6.22-14-generic
Banshee 0.13.1

Exception in Gtk# callback delegate
  Note: Applications can use GLib.ExceptionManager.UnhandledException to handle the exception.
Mono.Data.SqliteClient.SqliteSyntaxException: Expression tree is too large (maximum depth 1000)
  at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (IntPtr pzStart, System.IntPtr& pzTail, System.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 Banshee.Database.QueuedSqliteCommand.Execute () [0x00000]

   at GLib.ExceptionManager.RaiseUnhandledException ()
   at GLib.Signal.voidObjectCallback ()
   at GLib.Signal.voidObjectCallback ()
   at Gtk.Application.gtk_main ()
   at Gtk.Application.gtk_main ()
   at Gtk.Application.Run ()
   at Gnome.Program.Run ()
   at Banshee.BansheeEntry.Startup ()
   at System.MulticastDelegate.invoke_void_string[] ()
   at Banshee.Gui.CleanRoomStartup.Startup ()
   at Banshee.BansheeEntry.Main ()

[CatKiller (catkiller)]

For me, the cut off between a successful operation and a crash is around 1000 songs. Hopefully this will be a useful data point.

Oh, in Gutsy, with 1 GB of RAM.

[balak (balak)]

confirming this observation.

I tried clearing up my library of ~2500 songs and it crashed. However, I am able to delete upto 400-500 songs from it at a time w/o the crash.

[balak (balak)]

confirming this observation.

I tried clearing up my library of ~2500 songs and it crashed. However, I am able to delete upto 400-500 songs from it at a time w/o the crash.

This is on ubuntu gutsy with banshee 0.13.1

[TerryG (tgalati4)]

Current work around: keep your deletions under 1,000 songs: --> Expression tree is too large (maximum depth 1000)

Anyone want to verify 999 song deletions?

[Andrew Conkling (andrewski)]

There's a patch upstream: http://bugzilla.gnome.org/show_bug.cgi?id=469393#c12. Perhaps it could be merged into Debian/Ubuntu's package.

[DSHR (s-heuer)]

Still occurs with Hardy 0.13.2+dfsg-9 ...

[Pedro Villavicencio (pedro)]

fixed upstream already.

[Greg A (etulfetulf)]

According to upstream this should be fixed in the Intrepid version. Please can someone confirm if this is the case?

[Andrew Conkling (andrewski)]

Yes, the fix has been released.