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.
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
Another attempt to fixing interactions with p5-DBIx-Class. A few people
report that this works.
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)
email@example.com mailing list
To unsubscribe, send any mail to "firstname.lastname@example.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/
Committed and reported to work.