Bug 37714 - koha batch process are failing (import MARC-records, batch items modification, batch record deletion...)
Summary: koha batch process are failing (import MARC-records, batch items modification...
Status: RESOLVED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Tools (show other bugs)
Version: 23.05
Hardware: All Linux
: P2 critical
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-08-23 10:18 UTC by Yuriy Kotsyuk
Modified: 2024-08-24 14:00 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Yuriy Kotsyuk 2024-08-23 10:18:11 UTC
Hello!
I have a problem with all batch process, which is sending to the job queue.
After starting of modification process, I have a message:

The job has been enqueued! It will be processed as soon as possible.
View detail of the enqueued job | New batch record deletion.

When I go to detail, I have:
Details of job #3936

Job ID:3936
Status:Failed
Progress:0 / 1
Type:Batch item record modification
Queued:23/08/2024 12:45Started:
Ended:

Report
No items modified. New batch item modification.
Comment 1 Katrin Fischer 2024-08-23 10:38:31 UTC
Hi Yuriy,

you have filed this under "Koha infrastructure" "Koha Website". Please pick "Koha" for any bug reports or enhancement requests for the Koha software.

Also, this reads more like a support request, better suited for the mailing list or our Mattermost chat. In general the job processing should be working ok in the various versions. Make sure you always include the Koha version you are using with all the number (all 3 parts, like 22.11.20).

For a first idea: Try restarting koha-common, as this should also restart the processes needed for processing the background jobs.
Comment 2 Yuriy Kotsyuk 2024-08-23 18:35:15 UTC
Koha version:	23.05.06.000
OS version ('uname -a'):	Linux ubuntu 5.4.0-193-generic #213-Ubuntu SMP Fri Aug 2 19:14:16 UTC 2024 x86_64
Perl interpreter:	/usr/bin/perl
Perl version:	5.030000
Perl @INC:	/usr/share/koha/lib
/etc/perl
/usr/local/lib/x86_64-linux-gnu/perl/5.30.0
/usr/local/share/perl/5.30.0
/usr/lib/x86_64-linux-gnu/perl5/5.30
/usr/share/perl5
/usr/lib/x86_64-linux-gnu/perl/5.30
/usr/share/perl/5.30
/usr/local/lib/site_perl
/usr/lib/x86_64-linux-gnu/perl-base
/var/lib/koha/library/plugins
MySQL version:	5.5.5-10.3.39-MariaDB-0ubuntu0.20.04.2
Apache version:	Server version: Apache/2.4.41 (Ubuntu)
Memcached:	Servers: 127.0.0.1:11211 | Namespace: koha_library | Status: running. | Config read from: koha-conf.xml
Zebra version:	Zebra 2.1.4 (C) 1994-2017, Index Data Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: 45c729bb18ecdd3e0455f47765700b1c9754b1ce Using ICU
Zebra status:	Running
Message broker:	Using RabbitMQ
Date and time:	23/08/2024 13:07
Time zone:	Used: Europe/Kiev | Config: Europe/Kiev | Environment (TZ): Undefined
Comment 3 Yuriy Kotsyuk 2024-08-23 18:53:30 UTC
(In reply to Katrin Fischer from comment #1)
> Hi Yuriy,
> 
> you have filed this under "Koha infrastructure" "Koha Website". Please pick
> "Koha" for any bug reports or enhancement requests for the Koha software.
> 
> Also, this reads more like a support request, better suited for the mailing
> list or our Mattermost chat. In general the job processing should be working
> ok in the various versions. Make sure you always include the Koha version
> you are using with all the number (all 3 parts, like 22.11.20).
> 
> For a first idea: Try restarting koha-common, as this should also restart
> the processes needed for processing the background jobs.

I'm sorry for the mistake with positioning… Maybe you will give me a link where I can find support with my problem?

Issue appears after update to 23.05.06 version.
Restart koha-common give nothing, background jobs are in processes and take all CPU using time.
At the same time, worker-output.log file is enlarging catastrophic (15GB and more…)
Comment 4 Katrin Fischer 2024-08-24 09:40:52 UTC
Try https://chat.koha-community.org or our mailing lists: https://koha-community.org/support/community-support/

Maybe also have a look at bug 37545
Comment 5 Yuriy Kotsyuk 2024-08-24 13:59:08 UTC
(In reply to Katrin Fischer from comment #4)
> Try https://chat.koha-community.org or our mailing lists:
> https://koha-community.org/support/community-support/
> 
> Maybe also have a look at bug 37545

Thank You wery mutch! Advice to have a look at bug 37545 was helpful!
Problem is solved!!
I gues, problem was with corrupted vhost. Reseting "Rabbit nod" resolved error.