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

[bugzilla-daemon]

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: address@hidden
        ReportedBy: address@hidden
         QAContact: address@hidden


Cindy Murdock said:
> I get almost the same thing when running bulkmarcimport:
> 
> DBD::mysql::db do failed: Access denied for user: 'address@hidden'
> to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line
> 333.
> DBD::mysql::db do failed: Access denied for user: 'address@hidden'
> 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.