[Koha-bugs] [Bug 35819] New: "No job found" error for BatchUpdateBiblioHoldsQueue (race condition)

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35819

            Bug ID: 35819
           Summary: "No job found" error for BatchUpdateBiblioHoldsQueue
                    (race condition)
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: critical
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: jonathan.druart+koha at gmail.com
        QA Contact: testopia at bugs.koha-community.org
        Depends on: 29346

A BatchUpdateBiblioHoldsQueue job is triggered from AddRenewal if
RealTimeHoldsQueue is set.

It is executed inside a transaction and the worker can receive the job to
process before the transaction has been committed (and so before the job exists
in the DB).

The call stack is:
opac-renew: AddRenewal
In C4::Circulation::AddRenewal
3234     $schema->txn_do(sub{
3302         $item_object->store({ log_action => 0, skip_record_index => 1 }); 

In Koha::Item->store
 223     Koha::BackgroundJob::BatchUpdateBiblioHoldsQueue->new->enqueue(
 224         {
 225             biblio_ids => [ $self->biblionumber ]
 226         }   
 227     ) unless $params->{skip_holds_queue} or
!C4::Context->preference('RealTimeHoldsQueue');

To recreate:
Turn on RealTimeHoldsQueue
Check an item in to a patron
At the OPAC, renew the checkout

=> Job 109 not found, or has wrong status main::
/kohadevbox/koha/misc/workers/background_jobs_worker.pl


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29346
[Bug 29346] Real-time holds queue update
-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.