With p5-DBIx-Class-0.8123_1 squeezeboxserver fails to scan my music library correctly. The scanner stops after one song and /var/log/squeezeboxserver/scanner.log has this error: Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::db be gin_work failed: Already in a transaction Backing out to p5-DBIx-Class-0.08120 fixes the issue.
Responsible Changed From-To: freebsd-ports-bugs->brooks Fix synopsis and assign.
SqueezeBox Server turns off auto commit in the scanner to speed up scan times. The problem appears to be that turning off auto commit after connecting confuses the transaction nesting logic in DBIx::Class. The reason that it only affects 0.08121 and greater is that, according the the changelog "Cascading delete/update are now wrapped in a transaction for atomicity". I think that this is technically a bug in DBIx::Class, although whether its a documentation or implementation bug (i.e. whether changing AutoCommit is prohibited or not) I don't know. The attached patch solves the problem by specifying AutoCommit when connecting to the database.
brooks 2010-07-07 23:22:25 UTC FreeBSD ports repository Modified files: audio/squeezeboxserver Makefile Added files: audio/squeezeboxserver/files patch-dbix-class-bug.diff Log: Another attempt to fixing interactions with p5-DBIx-Class. A few people report that this works. PR: 148318 Feature safe: yes Submitted by: Mark Knight Revision Changes Path 1.76 +1 -1 ports/audio/squeezeboxserver/Makefile 1.1 +37 -0 ports/audio/squeezeboxserver/files/patch-dbix-class-bug.diff (new) _______________________________________________ cvs-all@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/cvs-all To unsubscribe, send any mail to "cvs-all-unsubscribe@freebsd.org"
This works a treat, thank you. Please feel free to close this bug. -- Mark A. R. Knightmarkk@knigma.org Tel: +44 7880 556751http://www.knigma.org/
State Changed From-To: open->closed Committed and reported to work.