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

[Marcel de Rooy]

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 list  https://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