GNOME Bugzilla – Bug 649298
System.Exception: Can't start a recursive transaction
Last modified: 2012-04-30 08:20:25 UTC
Hi. I'm currently in the process of porting banshee to OpenBSD. So far so good, the application starts except that when I try to import music, I get the following error (when running with --debug). Google shows a reference to that same issue from 2 years ago but that's it. [6 Debug 15:32:51.144] Full import exception: System.Exception: Can't start a recursive transaction at Hyena.Data.Sqlite.HyenaSqliteConnection.BeginTransaction () [0x0009e] in /usr/obj/ports/banshee-2.0.0/banshee-2.0.0/src/Hyena/Hyena.Data.Sqlite/Hyena.Data.Sqlite/HyenaSqliteConnection.cs:267 at Banshee.Collection.Database.DatabaseImportManager.ImportTrack (Hyena.SafeUri uri) [0x00027] in /usr/obj/ports/banshee-2.0.0/banshee-2.0.0/src/Core/Banshee.Services/Banshee.Collection.Database/DatabaseImportManager.cs:175 at Banshee.Collection.Database.DatabaseImportManager.ImportTrack (System.String path) [0x00000] in /usr/obj/ports/banshee-2.0.0/banshee-2.0.0/src/Core/Banshee.Services/Banshee.Collection.Database/DatabaseImportManager.cs:156 at Banshee.Collection.Database.DatabaseImportManager.OnImportRequested (System.String path) [0x00000] in /usr/obj/ports/banshee-2.0.0/banshee-2.0.0/src/Core/Banshee.Services/Banshee.Collection.Database/DatabaseImportManager.cs:130 [6 Error 15:32:51.303] /home/ajacoutot/Music/the_very_best_of/04 - Tired Of Being Alone.mp3 - Can't start a recursive transaction Package versions: sqlite3-3.7.5 banshee-2.0.0 mono-2.10.1 If you need any other information, don't hesitate. Thanks!
Created attachment 189848 [details] banshee terminal start errors
The attachment sohow the eroor during start up benshee under ubuntu lucid 34 bits. First start up went ok but hang when indexing 3700 songs about halfway. After that banshee only starts but hangs within seconds with the attached errros.
Created attachment 194324 [details] [review] transaction patch in import process Can someone with the bug test this patch ?
Just tried it and I still encounter the same issue.
Adding Olivier in CC because just attaching a patch to a bug doesn't automatically add you to the CC list :)
Review of attachment 194324 [details] [review]: Marking the patch as needs-work as per previous comment.
Created attachment 194445 [details] [review] transaction fix you must face a bug elsewhere which do not close transaction. So here is a patch to close all other transaction. But can you post the "full" log with banshee --debug > log 2>1&
> you must face a bug elsewhere which do not close transaction. > So here is a patch to close all other transaction. > > But can you post the "full" log with > banshee --debug > log 2>1& Ok, debug log attached (version 2.0.1, running with your patch). This doesn't seem to make any difference. Sorry for not providing much info but I'm really not familiar enough with mono.
Created attachment 194558 [details] debug log
the error come from sqllite. so not know why but you database not reachable ;( Sqlite error 778: disk I/O error. So check the right of you db file and banshee. If you have run banshee as root a day it could have create db as root...
else delete it banshee will create it again.
(In reply to comment #11) > else delete it banshee will create it again. Sorry I forgot to mention, but I obviously removed all banshee config and files before trying, that included the db and as you can see in the output log, that didn't help :-/
Closing. This was most probably a thread related issue but now OpenBSD comes with kernel threads which seemed to have fixed the issue. Version 2.4.0 runs smoothly.