https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37775
Bug ID: 37775
Summary: update_totalissues.pl uses $dbh->commit but does not
use transactions
Change sponsored?: ---
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: P5 - low
Component: Command-line Utilities
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
The script disables AutoCommit and calls commit on the dbh directly. As this
dbh is shared I believe it closes all current transactions. We have seen in the
logs a warning when the cron is running during library operating hours:
DBIx::Class::Storage::DBI::mysql::_exec_svp_release(): DBI Exception:
DBD::mysql::db do failed: SAVEPOINT savepoint_3 does not exist at
/usr/share/koha/lib/Koha/Object.pm line 170
I believe if we resolve bug 36474, effectively reducing the scope fo the job
from "all records in the DB" to "only updated records" - we can remove the need
for delayed commits here.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
