[Koha] Background jobs stuck at "New" and can't be kick-started

Mon Oct 17 12:34:30 NZDT 2022

Thanks Marcel and Katrin! That sounds like what I'm looking for :)

Aleisha

On 15/10/22 07:06, Katrin Fischer wrote:
> Hi Aleisha and all,
>
> maybe Marcel and I were thinking about the same bug:
>
> *Bug 31351*
> <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31351> -
> Worker dies on reindex job when operator last name/first name/branch
> name contains non-ASCII chars
>
> It looks like it hasn't been backported to 22.05 yet.
>
> Hope this helps,
>
> Katrin
>
> On 14.10.22 11:16, Marcel de Rooy wrote:
>> There is a bug about json decoding iirc on Bugzilla.
>> Not sure if that got into 22.05 ?
>>
>> ________________________________
>> Van: Koha<koha-bounces at lists.katipo.co.nz>  namens Aleisha 
>> Amohia<aleisha at catalyst.net.nz>
>> Verzonden: donderdag 13 oktober 2022 21:34
>> Aan:koha at lists.katipo.co.nz <koha at lists.katipo.co.nz>
>> Onderwerp: Re: [Koha] Background jobs stuck at "New" and can't be 
>> kick-started
>>
>> Hi Marcel
>>
>> There's a lot of this in worker-output.log:
>>
>> Wide character in subroutine entry at
>> /usr/share/koha/lib/Koha/BackgroundJob.pm line 170.
>>
>> Do you think that could be causing it to crash?
>>
>> Nothing interesting in worker-error.log.
>>
>> Thanks
>> Aleisha
>>
>> On 13/10/22 18:35, Marcel de Rooy wrote:
>>> Hi Aleisha,
>>> What's in your logs? (worker log etc)
>>> Are the jobs started but do they actually crash on something ?
>>>
>>> Marcel
>>>
>>> ________________________________
>>> Van: Koha<koha-bounces at lists.katipo.co.nz>   namens Aleisha 
>>> Amohia<aleisha at catalyst.net.nz>
>>> Verzonden: woensdag 12 oktober 2022 23:23
>>> Aan: Koha<koha at lists.katipo.co.nz>
>>> Onderwerp: [Koha] Background jobs stuck at "New" and can't be 
>>> kick-started
>>>
>>> Hi all,
>>>
>>> We're having some problems with background jobs and hoping we can get
>>> some advice.
>>>
>>> Running Koha 22.05.05, we have 25 background jobs stuck at New. Some 
>>> are
>>> batch item record modifications, some are holds queue updates.
>>>
>>> I've tried restarted rabbit-mq and the koha-worker but it hasn't seemed
>>> to pick up the jobs, using these commands:
>>>
>>> $ sudo koha-worker --stop <sitename>
>>> $ sudo service rabbitmq-server stop
>>> $ sudo koha-worker --start <sitename>
>>>
>>> $ sudo koha-worker --stop <sitename>
>>> $ sudo service rabbitmq-server start
>>> $ sudo koha-worker --start <sitename>
>>>
>>> The biblionumbers and itemnumbers that the jobs are trying to affect 
>>> are
>>> all legitimate records in the database.
>>>
>>> Would appreciate any ideas or suggestions from the community.
>>>
>>> -- 
>>> *Aleisha Amohia (she/her)*
>>> Koha Technical Lead
>>> *Catalyst IT - Expert Open Source Solutions*
>>>
>>> *Catalyst.Net Ltd - a Catalyst IT group company*
>>> Tel: +64 4 499 2267 
>>> |https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.catalyst.net.nz%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C47f4b72b05ef4c37f50a08daad5212d0%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638012865277883202%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=yklaqYnigbj%2Fs%2BJsQ%2F6N5A42EePpsX4cBQvDP0%2F6XXU%3D&reserved=0 
>>> <https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.catalyst.net.nz%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C47f4b72b05ef4c37f50a08daad5212d0%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638012865277883202%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=yklaqYnigbj%2Fs%2BJsQ%2F6N5A42EePpsX4cBQvDP0%2F6XXU%3D&reserved=0> 
>>>
>>>
>>> Catalyst Logo
>>>
>>> CONFIDENTIALITY NOTICE: This email is intended for the named recipients
>>> only. It may contain privileged, confidential or copyright information.
>>> If you are not the named recipient, any use, reliance upon, disclosure
>>> or copying of this email or its attachments is unauthorised. If you 
>>> have
>>> received this email in error, please reply via email or call +64 4 
>>> 499 2267.
>>> _______________________________________________
>>>
>>> Koha mailing 
>>> listhttps://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C47f4b72b05ef4c37f50a08daad5212d0%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638012865277883202%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=rrARZ6tCXh9H4IRf%2BuCHqw2mOGAv1ZFgmnMWZ%2B%2BsgEo%3D&reserved=0
>>> Koha at lists.katipo.co.nz
>>> Unsubscribe:https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C47f4b72b05ef4c37f50a08daad5212d0%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638012865277883202%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=bMRnV4NAG3h0SLqV3L1%2FSOFMXEMRMERtNXzAuKXPT50%3D&reserved=0 
>>>
>>> _______________________________________________
>>>
>>> Koha mailing 
>>> listhttps://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C47f4b72b05ef4c37f50a08daad5212d0%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638012865277883202%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=rrARZ6tCXh9H4IRf%2BuCHqw2mOGAv1ZFgmnMWZ%2B%2BsgEo%3D&reserved=0
>>> Koha at lists.katipo.co.nz
>>> Unsubscribe:https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C47f4b72b05ef4c37f50a08daad5212d0%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638012865277883202%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=bMRnV4NAG3h0SLqV3L1%2FSOFMXEMRMERtNXzAuKXPT50%3D&reserved=0 
>>>
>> -- 
>> *Aleisha Amohia (she/her)*
>> Koha Technical Lead
>> *Catalyst IT - Expert Open Source Solutions*
>>
>> *Catalyst.Net Ltd - a Catalyst IT group company*
>> Tel: +64 4 499 2267 
>> |https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.catalyst.net.nz%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C47f4b72b05ef4c37f50a08daad5212d0%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638012865277883202%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=yklaqYnigbj%2Fs%2BJsQ%2F6N5A42EePpsX4cBQvDP0%2F6XXU%3D&reserved=0 
>> <https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.catalyst.net.nz%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C47f4b72b05ef4c37f50a08daad5212d0%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638012865277883202%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=yklaqYnigbj%2Fs%2BJsQ%2F6N5A42EePpsX4cBQvDP0%2F6XXU%3D&reserved=0> 
>>
>>
>> Catalyst Logo
>>
>> CONFIDENTIALITY NOTICE: This email is intended for the named recipients
>> only. It may contain privileged, confidential or copyright information.
>> If you are not the named recipient, any use, reliance upon, disclosure
>> or copying of this email or its attachments is unauthorised. If you have
>> received this email in error, please reply via email or call +64 4 
>> 499 2267.
>> _______________________________________________
>>
>> Koha mailing 
>> listhttps://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C47f4b72b05ef4c37f50a08daad5212d0%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638012865278039439%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3MuXzLofBXQ2KEFBiPfRuO%2F8SNz8HbeV4ZPNGpy%2Bzms%3D&reserved=0
>> Koha at lists.katipo.co.nz
>> Unsubscribe:https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C47f4b72b05ef4c37f50a08daad5212d0%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638012865278039439%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=riv07wCywaLcS5qn0MEGUmbbiOhaJLaN%2FjRNN6hNHhU%3D&reserved=0 
>>
>> _______________________________________________
>>
>> Koha mailing listhttp://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
>
> Koha mailing list http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- 
*Aleisha Amohia (she/her)*
Koha Technical Lead
*Catalyst IT - Expert Open Source Solutions*

*Catalyst.Net Ltd - a Catalyst IT group company*
Tel: +64 4 499 2267 | www.catalyst.net.nz <http://www.catalyst.net.nz>

Catalyst Logo

CONFIDENTIALITY NOTICE: This email is intended for the named recipients 
only. It may contain privileged, confidential or copyright information. 
If you are not the named recipient, any use, reliance upon, disclosure 
or copying of this email or its attachments is unauthorised. If you have 
received this email in error, please reply via email or call +64 4 499 2267.