[Koha-bugs] [Bug 1039] New: bulkmarcimport won't perform table locks

bugzilla-daemon at wilbur.katipo.co.nz bugzilla-daemon at wilbur.katipo.co.nz
Sat Jan 7 13:46:48 CET 2006


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 at katipo.co.nz
        ReportedBy: shedges at athenscounty.lib.oh.us
         QAContact: koha-bugs at nongnu.org


Cindy Murdock said:
> I get almost the same thing when running bulkmarcimport:
> 
> DBD::mysql::db do failed: Access denied for user: 'kohaadmin at 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 at 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.





More information about the Koha-bugs mailing list