http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1039 Summary: bulkmarcimport won't perform table locks Product: Koha Version: 2.2.0 Platform: PC Status: NEW Severity: normal Priority: P2 Component: Database AssignedTo: chris@katipo.co.nz ReportedBy: shedges@athenscounty.lib.oh.us QAContact: koha-bugs@nongnu.org Cindy Murdock said:

I get almost the same thing when running bulkmarcimport:

DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 333. DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 382.

This is with 2.2.4.

Well, I have a partial answer to this problem, but am not smart enough to figure it all out. The lines that are throwing the error perform a "lock" on the MySQL tables so bulkmarcimport can have exclusive access while loading the records. Apparently, the username that gets passed from the script to the module does not have lock priviliges. The result is that MySQL throws an error that get's reported (as above), the records get loaded anyway, and if you have exclusive access to the Koha server, there won't be any MySQL conflicts with other users. I'll submit this to kohabugs (possibly related to bug 1002). ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.