Re: [Koha] Help needed with zombie background_jobs processes
A few other things I've noticed: - Sometimes the zombie processes will go away on their own, sometimes it seems when you retry the MARC import or whatever it was that failed. This one is really weird to me as in all my years as a sysadmin I thought it was not possible for zombie processes to go away without a reboot. But maybe that's changed and now zombies can rise from the dead. Lol. - In looking at the jobs list in Koha, it seems that Holds queue updates are especially prone to getting stuck at a progress of null/1. - If you reattempt a job that is stuck (ie, reattempting a MARC file upload or what not) it will often succeed. The original failed job remains with a progress of null. c. --- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org Please report tech support issues in Mantis: https://mantis.ccfls.org On Tue, Apr 18, 2023 at 3:55 PM Cindy Murdock Ames wrote: > Yes, it's 22.11.04, package version. > > --- > Cindy Murdock Ames > IT Services Director > Meadville Public Library | CCFLS > https://meadvillelibrary.org | https://ccfls.org > > > > > On Tue, Apr 18, 2023 at 2:59 PM Jonathan Druart < > jonathan.dru...@bugs.koha-community.org> wrote: > >> Hi Cindy, >> Which exact version of Koha 22.11.xx? It should be the latest one. >> Regards, >> Jonathan >> >> Le mar. 18 avr. 2023 à 19:13, Cindy Murdock Ames a >> écrit : >> > >> > Hi all, >> > >> > A couple weekends ago I upgraded our Koha instance from 22.05 to 22.11, >> and >> > I'm having trouble with the background_jobs processes becoming zombies >> > after a very short amount of time, necessitating a reboot. I suspect >> it's >> > a misconfiguration on my part, so if someone can shed some light I'd >> really >> > appreciate it! >> > >> > The first symptom was our MARC imports getting stuck at "import queued", >> > and after some digging (and thanks to the thread in this list with the >> > subject of "Background job / Staging MARC import stuck at 0%" I found I >> was >> > entirely missing the section in our config, so I added >> > this: >> > >> > >> >localhost >> >61613 >> >guest >> >guest >> > >> > >> > >> > Which seemed to resolve it, but now I find that the background_jobs >> > processes are going zombie after processing only a few jobs. Here's >> some >> > info from the rabbitmq log after restarting the server: >> > >> > =INFO REPORT 18-Apr-2023::12:23:46 === >> > node : rabbit@ccflskoha >> > home dir : /var/lib/rabbitmq >> > config file(s) : /etc/rabbitmq/rabbitmq.config (not found) >> > cookie hash: ojvkUE6eUtku7kHlx3uiFg== >> > log: /var/log/rabbitmq/rab...@ccflskoha.log >> > sasl log : /var/log/rabbitmq/rab...@ccflskoha-sasl.log >> > database dir : /var/lib/rabbitmq/mnesia/rabbit@ccflskoha >> > >> > Is it problematic that /etc/rabbitmq/rabbitmq.config is missing? >> Anything >> > else I should be looking at? We're running on Ubuntu SE 18.04 if that >> is >> > helpful. >> > >> > Thanks much! >> > Cindy >> > >> > >> > --- >> > Cindy Murdock Ames >> > IT Services Director >> > Meadville Public Library | CCFLS >> > https://meadvillelibrary.org | https://ccfls.org >> > ___ >> > >> > Koha mailing list http://koha-community.org >> > Koha@lists.katipo.co.nz >> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Help needed with zombie background_jobs processes
Yes, it's 22.11.04, package version. --- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org On Tue, Apr 18, 2023 at 2:59 PM Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > Hi Cindy, > Which exact version of Koha 22.11.xx? It should be the latest one. > Regards, > Jonathan > > Le mar. 18 avr. 2023 à 19:13, Cindy Murdock Ames a > écrit : > > > > Hi all, > > > > A couple weekends ago I upgraded our Koha instance from 22.05 to 22.11, > and > > I'm having trouble with the background_jobs processes becoming zombies > > after a very short amount of time, necessitating a reboot. I suspect > it's > > a misconfiguration on my part, so if someone can shed some light I'd > really > > appreciate it! > > > > The first symptom was our MARC imports getting stuck at "import queued", > > and after some digging (and thanks to the thread in this list with the > > subject of "Background job / Staging MARC import stuck at 0%" I found I > was > > entirely missing the section in our config, so I added > > this: > > > > > >localhost > >61613 > >guest > >guest > > > > > > > > Which seemed to resolve it, but now I find that the background_jobs > > processes are going zombie after processing only a few jobs. Here's some > > info from the rabbitmq log after restarting the server: > > > > =INFO REPORT 18-Apr-2023::12:23:46 === > > node : rabbit@ccflskoha > > home dir : /var/lib/rabbitmq > > config file(s) : /etc/rabbitmq/rabbitmq.config (not found) > > cookie hash: ojvkUE6eUtku7kHlx3uiFg== > > log: /var/log/rabbitmq/rab...@ccflskoha.log > > sasl log : /var/log/rabbitmq/rab...@ccflskoha-sasl.log > > database dir : /var/lib/rabbitmq/mnesia/rabbit@ccflskoha > > > > Is it problematic that /etc/rabbitmq/rabbitmq.config is missing? > Anything > > else I should be looking at? We're running on Ubuntu SE 18.04 if that is > > helpful. > > > > Thanks much! > > Cindy > > > > > > --- > > Cindy Murdock Ames > > IT Services Director > > Meadville Public Library | CCFLS > > https://meadvillelibrary.org | https://ccfls.org > > ___ > > > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Help needed with zombie background_jobs processes
Hi Cindy, Which exact version of Koha 22.11.xx? It should be the latest one. Regards, Jonathan Le mar. 18 avr. 2023 à 19:13, Cindy Murdock Ames a écrit : > > Hi all, > > A couple weekends ago I upgraded our Koha instance from 22.05 to 22.11, and > I'm having trouble with the background_jobs processes becoming zombies > after a very short amount of time, necessitating a reboot. I suspect it's > a misconfiguration on my part, so if someone can shed some light I'd really > appreciate it! > > The first symptom was our MARC imports getting stuck at "import queued", > and after some digging (and thanks to the thread in this list with the > subject of "Background job / Staging MARC import stuck at 0%" I found I was > entirely missing the section in our config, so I added > this: > > >localhost >61613 >guest >guest > > > > Which seemed to resolve it, but now I find that the background_jobs > processes are going zombie after processing only a few jobs. Here's some > info from the rabbitmq log after restarting the server: > > =INFO REPORT 18-Apr-2023::12:23:46 === > node : rabbit@ccflskoha > home dir : /var/lib/rabbitmq > config file(s) : /etc/rabbitmq/rabbitmq.config (not found) > cookie hash: ojvkUE6eUtku7kHlx3uiFg== > log: /var/log/rabbitmq/rab...@ccflskoha.log > sasl log : /var/log/rabbitmq/rab...@ccflskoha-sasl.log > database dir : /var/lib/rabbitmq/mnesia/rabbit@ccflskoha > > Is it problematic that /etc/rabbitmq/rabbitmq.config is missing? Anything > else I should be looking at? We're running on Ubuntu SE 18.04 if that is > helpful. > > Thanks much! > Cindy > > > --- > Cindy Murdock Ames > IT Services Director > Meadville Public Library | CCFLS > https://meadvillelibrary.org | https://ccfls.org > ___ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] OPAC Search results - 500 Error
Hello all, I'm having trouble getting detail for books in the OPAC. If I search for something in the catalog I'm presented with ta list of books. If I click the title of a book I get a 500 error. I think it must something to do with "DBIC result _type isn't of the _type Branch" seen in the plack error log. Relevant logs are below. Any help is much appreciated. Thank you. ==> /var/log/koha/library/plack-opac-error.log <== [2023/04/18 11:06:04] [WARN] Use of uninitialized value in hash element at /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl line 680. ==> /var/log/koha/library/plack-error.log <== DBIC result _type isn't of the _type Branch at /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl line 680. ==> /var/log/koha/library/plack.log <== 192.168.101.254 - - [18/Apr/2023:11:06:04 -0600] "GET /opac/opac-detail.pl?biblionumber=631_desc=kw%2Cwrdl%3A%20deep%20work HTTP/1.1" 500 20863 "https://library.ncat.org/cgi-bin/koha/opac-search.pl?idx=kw=deep%20work_by=relevance_dsc=20=holdingbranch:MT; "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0" ==> /var/log/koha/library/opac-access.log <== 192.168.101.254 - - [18/Apr/2023:11:06:04 -0600] "GET /cgi-bin/koha/opac-detail.pl?biblionumber=631_desc=kw%2Cwrdl%3A%20deep%20work HTTP/1.1" 500 20863 JOHN J. ENGLISH ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Barcode not found - Show matching titles
Thank you Katrin, that worked a treat. I added a new column called barcode (952$p) to my import and searching works great now. John E. -Original Message- From: Koha On Behalf Of Katrin Fischer Sent: Friday, April 14, 2023 3:13 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Barcode not found - Show matching titles [You don't often get email from katrin.fischer...@web.de. Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ] Hi John, itemBarcodeFallbackSearch allows you to checkout items without knowing their barcode, but you still need to assign a barcode to the items as Koha can't check the items out internally without one. You could consider using the AutoBarcode for new items and update the existing items with a unique value. If your barcodes are not long and unique you could use them or maybe the itemnumber assigned by Koha. That would be doable with an SQL update if there are a lot of items without barcode. But maybe try to add a barcode to the item you are testing with and see if the process works for you then first :) Hope this helps, Katrin On 14.04.23 03:12, John J. English wrote: > Hello, I'm trying configure my Koha instance so that can process a checkout > on books that do not have barcodes associated with them. > > I've tried enabling but it isn't working. > When I click "Show matching titles" I get an empty model that says: Barcode > not found. The following items were found by searching: > There's nothing in the model, even though I know the book is in the catalog. > I've tried reindexing Zebra, but it didn't help. > Any advice is very much appreciated. Thank you. > > JOHN J. ENGLISH ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Help needed with zombie background_jobs processes
Hi all, A couple weekends ago I upgraded our Koha instance from 22.05 to 22.11, and I'm having trouble with the background_jobs processes becoming zombies after a very short amount of time, necessitating a reboot. I suspect it's a misconfiguration on my part, so if someone can shed some light I'd really appreciate it! The first symptom was our MARC imports getting stuck at "import queued", and after some digging (and thanks to the thread in this list with the subject of "Background job / Staging MARC import stuck at 0%" I found I was entirely missing the section in our config, so I added this: localhost 61613 guest guest Which seemed to resolve it, but now I find that the background_jobs processes are going zombie after processing only a few jobs. Here's some info from the rabbitmq log after restarting the server: =INFO REPORT 18-Apr-2023::12:23:46 === node : rabbit@ccflskoha home dir : /var/lib/rabbitmq config file(s) : /etc/rabbitmq/rabbitmq.config (not found) cookie hash: ojvkUE6eUtku7kHlx3uiFg== log: /var/log/rabbitmq/rab...@ccflskoha.log sasl log : /var/log/rabbitmq/rab...@ccflskoha-sasl.log database dir : /var/lib/rabbitmq/mnesia/rabbit@ccflskoha Is it problematic that /etc/rabbitmq/rabbitmq.config is missing? Anything else I should be looking at? We're running on Ubuntu SE 18.04 if that is helpful. Thanks much! Cindy --- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Can't connect to local MySQL server through socket
Hello, yes, without any error.
Am 18.04.23, 07:12 schrieb "Mason James" mailto:m...@kohaaloha.com>>:
hi Eugen
you probably have a config problem with your 'koha' instance
does the following command succeed?
$ sudo koha-mysql koha
On 17/04/23 7:25 pm, DHIM IT wrote:
> Dear Collogues,
>
> for two weeks I get an every 2-5 minute error from the cron below. I can run
> the commands from the cron without a problem. Also, I can connect to my
> database without a problem. Any ideas?
>
>
> Best regards,
> Eugen Bastron
>
>
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI
> connect('database=koha_koha;host=localhost;port=3306','koha_koha',...)
> failed: Can't connect to local MySQL server through socket
> '/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/Koha/Database.pm line
> 91. at /usr/share/koha/lib/Koha/Database.pm line 139
> koha: 111 status returned by
> "/usr/share/koha/bin/cronjobs/process_message_queue.pl"
>
> /etc/cron.hourly/koha-common:
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI
> connect('database=koha_koha;host=localhost;port=3306','koha_koha',...)
> failed: Can't connect to local MySQL server through socket
> '/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/Koha/Database.pm line
> 91. at /usr/share/koha/lib/Koha/Database.pm line 139
> koha: 111 status returned by
> "/usr/share/koha/bin/cronjobs/holds/build_holds_queue.pl"
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI
> connect('database=koha_koha;host=localhost;port=3306','koha_koha',...)
> failed: Can't connect to local MySQL server through socket
> '/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/Koha/Database.pm line
> 91. at /usr/share/koha/lib/Koha/Database.pm line 139
> koha: 111 status returned by
> "/usr/share/koha/bin/cronjobs/automatic_checkin.pl"
>
>
>
> ___
>
> Koha mailing list http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
