IRC log for #koha, 2022-08-01

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
02:19 wajasu i've got my new debian11 with 22.0503000 in the db syspref and Koha.pm
02:20 the opac always disconnects the connection at the first search.  the staff interface works.
02:21 i've also just install that same db with KOHA_IMAGE=22.05 kul , koha-upgrade-schema, koha-rebuild-zebra
02:23 that docker environment has 22.05.02.000 in the db syspref and Koha.pm
02:26 both the opac and staff succeed in the search in the docker ktd environment.
02:27 now i want to see if its the specific version 22.0503000 that is broken, or if its my debian11 install.
02:31 i guess i can try to change my koha git tag to v22.05.02, then KOHA_IMAGE=22.05 kul
02:34 then the kul docker environment would be as close to my failing installation.  if it succeeds, then 22.0503000 is broken.
02:35 if it fails, its something else.  i'll have to debug opac-search.pl.  maybe use debugger, and step through.
02:36 or look to see if the database will log a statement for a query ...
02:36 tmrw morning.
02:37 at least i know my database in the ktd/kul works at 22.05.02.000
03:55 alohabot joined #koha
05:29 dpk joined #koha
06:20 dpk joined #koha
06:21 reiveune joined #koha
07:01 cait joined #koha
07:05 cait1 joined #koha
07:07 cait1 hm not a lot of ops again
07:07 paulderscheid[m] Morning #koha
07:11 cait1 it looks like mails going through the mailing list can take a few hours at the moment, in one case an email from koha-bugs took almost 24-hours. We've ruled out bugzilla and I also saw a bigger delay on koha-devel with an email I sent - someone from Biblibre around who could check on the mailing list server?
07:13 koha-jenkins Project Koha_21.11_D12 build #103: ABORTED in 39 sec: https://jenkins.koha-community[…]ha_21.11_D12/103/
07:14 cait1 Frido, jajm ^
07:55 cait joined #koha
08:03 alohabot joined #koha
08:08 alohabot joined #koha
09:44 ib_iel joined #koha
10:10 cait joined #koha
10:17 oleonard joined #koha
10:39 oleonard joined #koha
11:25 tcohen hola #koha
11:31 cait1 hola tcohen
11:36 tcohen bye koha-jenkins
11:44 hi all, anyone willing to check on the jenkins build notifications, can join the #koha-ci channel
11:44 as decided on some past dev meeting, koha-jenkins will no longer report here
11:51 tuxayo tcohen++
11:51 oleonard Thanks tcohen!
11:54 tcohen remote: Compressing objects: 100% (1287/1287), done.
11:54 Recibiendo objetos:  44% (3853/8692), 55.82 MiB | 56.00 KiB/s
11:55 Work will be slow today it seems
12:14 huginn` News from kohagit: Bug 30965: Add a 'x' to go back to the patron search <https://git.koha-community.org[…]6a5a282e2d19627a8>
12:14 News from kohagit: Bug 30650: Add missing koha_object[s]_class methods <https://git.koha-community.org[…]0d62c99a23b9629bc>
12:14 News from kohagit: Bug 30499: Move the include for catalogue-search-box.inc in circ-search.inc to correc... <https://git.koha-community.org[…]3c9593bc5bc7e2193>
12:14 News from kohagit: Bug 31251: Use jQuery val() to clear_entry <https://git.koha-community.org[…]2f1be9f87dac4614d>
12:14 News from kohagit: Bug 31223: Regression tests <https://git.koha-community.org[…]8d80ea02283a7d55b>
12:14 News from kohagit: Bug 31223: Do not explode if plugins disabled <https://git.koha-community.org[…]5945467931a10082e>
12:14 News from kohagit: Bug 30965: Add patron autocomplete search to curbside pickups <https://git.koha-community.org[…]be3cbeab174f8cec3>
12:14 News from kohagit: Bug 30028: Fix patron message delete confirmation to be translatable <https://git.koha-community.org[…]e1a91a75c08fe30c8>
12:14 News from kohagit: Bug 28707: Translate RECEIPT notice <https://git.koha-community.org[…]42bcc0af1868017c5>
12:18 tcohen lukeg++ # fixing stuffs all over the place
12:32 huginn` News from kohagit: Bug 30984: DBRev 22.06.00.026 <https://git.koha-community.org[…]2a332f328cad515e7>
12:32 News from kohagit: Bug 30468: Restore 'set -e' and remove echos <https://git.koha-community.org[…]ab880d81b8f51d2e3>
12:32 News from kohagit: Bug 31269: Define sDefaultContent for DataTables <https://git.koha-community.org[…]d566adc5bac7f293d>
12:32 News from kohagit: Bug 30984: (QA follow-up) Switch from mediumtext to varchar(255) <https://git.koha-community.org[…]609cf05e360551ce1>
12:32 News from kohagit: Bug 30984: (QA follow-up) Ternary formatting style <https://git.koha-community.org[…]2b4cf23763363b45a>
12:32 News from kohagit: Bug 30984: Action logs should log the cronjob script name that generated the given log <https://git.koha-community.org[…]7484d9e989ed3e5f7>
12:32 News from kohagit: Bug 30658: (bug 29496 follow-up) CheckMandatorySubfields don't work properly with... <https://git.koha-community.org[…]e3e8d76bea3108125>
12:32 News from kohagit: Bug 30468: koha-mysql does not honor Koha's timezone setting <https://git.koha-community.org[…]43c0f45077871b398>
12:32 oleonard Anyone know why I'm getting "Cannot connect to the Docker daemon at unix:///var/run/docker.sock" today when I try to start KTD? macOS, Docker Desktop v4.10.1
12:33 Joubu is docker running?
12:33 oleonard Yes,
12:34 Joubu Try a restart maybe: `service docker restart`
12:35 tcohen oleonard: maybe you have Docker Desktop AND some manually installed tools from homebrew?
12:35 i.e. version mismatch
12:35 it is working for me
12:35 same version
12:35 caroline joined #koha
12:35 tcohen was about to upgrade to 4.11 on friday
12:35 I suggest you restart it
12:36 oleonard Restarting a third time was what I needed I guess :|
12:37 Joubu you need to restart it and feel it will fix the problem. If you just restart it without faith, it cannot work
12:38 tcohen Joubu: the Docker Desktop thing... is a bit fragile.
12:39 it uses a VM and restarting it fixed things in the past
12:39 this is not Linux
12:39 and I agree: you need to believeeeeee
12:47 caroline joined #koha
12:53 cait1 tcohen: did you see my note on your holds bug? I can no longer set holds to waiting :(
12:55 caroline joined #koha
13:02 tcohen cait1: saw it, working on that after the push I'm doing
13:02 thanks for the reminder!
13:02 cait joined #koha
13:02 tcohen it must have been a bad rebase
13:04 huginn` News from kohagit: Bug 30984: DBIC update <https://git.koha-community.org[…]9435436e51b519ff1>
13:04 News from kohagit: Bug 30612: Rename other occurrences <https://git.koha-community.org[…]5e823d9bda87f1efc>
13:04 News from kohagit: Bug 30612: (QA follow-up) Rename accountlines method to account_lines <https://git.koha-community.org[…]910f334871231ab0a>
13:04 News from kohagit: Bug 27849: (follow-up) Add test <https://git.koha-community.org[…]54b2375b994753951>
13:04 News from kohagit: Bug 30964: (QA follow-up) Add classes to allow for additional styling <https://git.koha-community.org[…]5c0afd3bfb42a3de0>
13:04 News from kohagit: Bug 30964: Add 'restricted' and 'has overdues' on curbside pickup <https://git.koha-community.org[…]8cb19bb5ef438cc3b>
13:04 News from kohagit: Bug 30612: Update schema files <https://git.koha-community.org[…]820d9081f10256df8>
13:04 News from kohagit: Bug 30612: Add accountlines method to Koha::Checkout and Koha::Old::Checkout <https://git.koha-community.org[…]2a4339b4b1cf02637>
13:04 News from kohagit: Bug 28864: Have patron card creator use PatronsPerPage <https://git.koha-community.org[…]43da0adb423ad7bd8>
13:04 News from kohagit: Bug 27849: Koha::Token may access undefined C4::Context->userenv <https://git.koha-community.org[…]7df0bb94b4cfbbb12>
13:19 Dyrcona joined #koha
13:36 FlorianB joined #koha
13:47 kidclamp joined #koha
14:02 cait1 zero emails on koha-bugsfor some time now :(
14:20 lukeg joined #koha
14:20 lukeg hi
14:20 wahanui privet, lukeg
14:25 wajasu i believe
14:25 * cait1 waves
14:39 tundunf joined #koha
14:39 tundunf hi everyone
14:44 oleonard Hi tundunf
14:48 reiveune bye
14:48 reiveune left #koha
14:50 lukeg joined #koha
14:55 tundunf I can find instructions for adding item checkin alerts, but does anyone know if it's possible to add item checkout alerts?
14:57 Joubu like sending a notification by email?
14:58 tundunf More like an alert for staff issuing the item to borrowers
14:58 For example, we have a restricted loan collection that doesn't auto-renew, and we wanted to see if we could have an alert pop-up when it's being issued to remind circulation staff to tell borrowers that the item is non-renewable
15:01 cait1 tundunf: have a look at $3 materials
15:01 that creates some warning on checkout
15:01 and checkin
15:01 tundunf ah thank you
15:02 I'm assuming there's no way to apply this to an entire item type?
15:02 Joubu bug 25261
15:02 huginn` Bug https://bugs.koha-community.or[…]_bug.cgi?id=25261 enhancement, P5 - low, ---, martin.renvoize, CLOSED FIXED, Multiple parts handling - confirmation alert
15:04 cait1 Joubu: that bug makes it a confirm yep - showed before that too
15:05 tundunf: maybe it would be a good idea to file a bug to have something like the checkin note also for checkouts (by itemtype)
15:05 it could make a nice enh
15:06 tundunf will do!
15:06 thanks for your help all ~
15:06 FlorianB I'm having some issues with the kohadevbox, can I ask for help here as well?
15:17 cait1 FlorianB: you can
15:18 FlorianB: but a lot of people are using koha-testing-docker these days, so not sure when ti comes to fixes etc
16:16 cait1 left #koha
16:18 cait joined #koha
16:23 m23 joined #koha
16:36 buckleshoe joined #koha
16:50 m23 joined #koha
17:15 huginn` News from kohagit: Bug 30077: DBRev 22.06.00.028 <https://git.koha-community.org[…]5349261a3c2b54ac8>
17:15 News from kohagit: Bug 30077: Compiled CSS <https://git.koha-community.org[…]185cf57cb92d9cf49>
17:15 News from kohagit: Bug 23919: DBRev 22.06.00.027 <https://git.koha-community.org[…]13ee492ef68e27a47>
17:15 News from kohagit: Bug 23919: (QA follow-up) Tidy query build code <https://git.koha-community.org[…]11a0bf788900c369d>
17:15 News from kohagit: Bug 23919: Add tests for Items search by ISBN and ISSN with variations <https://git.koha-community.org[…]aa29e1d24463c5bd7>
17:15 News from kohagit: Bug 23919: Add tests for biblioItems search by ISBN and ISSN with <https://git.koha-community.org[…]40604d299db445c8a>
17:15 News from kohagit: Bug 23919: Items search by ISBN variations and ISSN variations <https://git.koha-community.org[…]f941670a49ec06925>
17:15 News from kohagit: Bug 23919: Zebra search by ISSN variations <https://git.koha-community.org[…]b5caa9c99bb30331e>
17:15 News from kohagit: Bug 23919: Add new system preference SearchWithISSNVariations <https://git.koha-community.org[…]12b5bcca0246777f1>
17:15 News from kohagit: Bug 30077: (follow-up) Set max width for library drapdown <https://git.koha-community.org[…]9d907ebcb44bfa06a>
17:15 News from kohagit: Bug 30077: (follow-up) retain branch selection <https://git.koha-community.org[…]d511a126cf659bc49>
17:15 News from kohagit: Bug 30077: Add system preference IntranetAddMastheadLibraryPulldown <https://git.koha-community.org[…]fd85a3e1fdf0cfdef>
17:39 News from kohagit: Bug 30392: DBRev 22.06.00.029 <https://git.koha-community.org[…]b6a3ea7cd720584c1>
17:39 News from kohagit: Bug 30392: DBIC update <https://git.koha-community.org[…]77848bb889d5c97b7>
17:39 News from kohagit: Bug 30392: (QA follow-up) Correct COMMENT <https://git.koha-community.org[…]a32e33c7a4ce24fc1>
17:39 News from kohagit: Bug 29579: (QA follow-up) Fix up t/db_dependent/Koha/Reports.t <https://git.koha-community.org[…]658e3cd8bb48930bf>
17:39 News from kohagit: Bug 30392: Set deleted_on when an item is (marked as) deleted <https://git.koha-community.org[…]e0495a6720d2bbfcc>
17:39 News from kohagit: Bug 30392: DB changes <https://git.koha-community.org[…]b57698acae5d0827d>
17:39 News from kohagit: Bug 29579: Show saved SQL report ID in database query <https://git.koha-community.org[…]f901e2d63a6c97192>
17:49 News from kohagit: Bug 30077: (QA follow-up) Avoid warning <https://git.koha-community.org[…]7b232d2ceb0aa61e7>
17:53 wajasu i need some help. i need a hint as where to look for my problem.
17:53 fresh koha 22.05.02.000 debian 11 install, but with my legacy database brought in.
17:54 tcohen go on
17:54 we are all reading
17:54 :-D
17:55 wajasu the database has 22.0502000 version in sys prefs
17:55 my problem is when i do a search in OPAC, i get connection timeout in browser
17:55 staff interface works.
17:56 tcohen is the request reaching Apache?
17:56 wajasu i did load that same database into ktd kul docker env at version 22.0503000 and it works
17:56 tcohen (i.e. in the logs)
17:56 wajasu letme check
17:56 tcohen it feels like a deployment issue
17:56 maybe NS, etc
17:59 wajasu i just did a bunch of apt update upgrade stuff.
18:00 it works now.  let me reboot the server
18:00 when i reboot, does zebra always rebuild?
18:03 i reboot.  now the opac comes up, i search and i get dropped connection. when i search
18:05 its workingnow.
18:07 my staff interface always works with search.  let me reboot and see if some backend services weren't up yet.
18:07 tcohen zebra doesn't rebuild on its own
18:08 wajasu but i was usually waiting for an hour...
18:08 tcohen unless you're talking about the real-time updating that takes place on changes
18:08 which is handled by koha-indexer
18:08 wajasu no updateing.  just plain search out the box.
18:08 not this is on a 4GB linode shared VPS.
18:09 not sure if other users can influence performance on my kvm
18:10 rebooting again
18:17 well if i change my search criteria, i saw the result pae come up, but maybe cover resource lookup are delayed.
18:22 ok.  if i search for author.  i get connection timed out.  then in the browser i resubmit, it works.
18:23 tcohen how many workers are you running?
18:24 wajasu 2
18:24 plack
18:24 i'm the only user
18:24 its standard out of the box deployment.
18:25 just IP config for apache
18:25 localhost
18:25 wahanui somebody said localhost was literally "localhost" or I should sub that for something else?
18:26 tcohen so
18:26 if you restart things does it work?
18:26 koha-zebra --stop $(koha-list --enabled) ; koha-zebra --start $(koha-list --enabled)
18:27 wajasu when is searcj, i see tail -f /var/log/apache/other_vhosts_access.log shows  access lines
18:27 ok. i'll try
18:27 tcohen tail -f /var/logs/koha/<instance>/*.log
18:31 pastebot "wajasu" at 127.0.0.1 pasted "tail -f /var/logs/koha/<instance>/*.log" (7 lines) at https://paste.koha-community.org/11950
18:32 wajasu remember its my old 3.10 koha brought to 22.05
18:33 maybe i need branch_limit configured because it may be dooing some work based on that and timing out
18:34 line 491 mentions building cache_key
18:34 tcohen you did a fresh install, right?
18:34 and just carried your /var/lib/koha/<instance> stuff
18:34 and hte DB
18:34 right?
18:35 wajasu i did a few this weekend. with same results. things work with same database in ktd.
18:36 yes. just fresh install.  takes 20 min with my placker script, and then copied the db backup sql to the box. then shutdown koha-common and apache. then dropped db. then streamed db backup into new db.
18:37 then did koha-upgrade-schema <instance>
18:37 then koha-rebuild -f -v <instance>
18:37 then startup koha-common  and apache
18:38 staf interface works, but opac had the problem.
18:41 tcohen is PLack enabled for both OPAC and staff?
18:41 thinking of deployment issues
18:42 koha-plack --enable <instance>
18:42 if you tweaked the files manually you might have broken koha-plack --enable
18:42 * tcohen has been there
18:44 wajasu they both show enabled, and i disabled and reeneabled. plus i check the apache <instance>.conf to see if uncommented
18:44 tcohen great
18:45 wajasu restarted koha-common and apache still has problem.
18:47 do you think that branch-limit undef warning in the paste above could be an issue?  staff search doesn't show that
18:52 i guess i can try to turn on db logging to see the a query that might be slow.  maybe i don't have an index.
18:53 tcohen do the zebra logs show anything?
18:53 did you change searchengine?
18:53 did you happen to restart memcached as well? (it caches koha-conf.xml and some stuffs like MARC frameworks)
18:54 wajasu nothing logged in zebra-error.log or zerba-output.log for that instance
18:55 restarting memcached didn't help
18:55 i left searach engine alone.  remember my 3.10 db wasnt using memcached
18:56 sysprefs shows session storage in mysql
18:56 fridolin joined #koha
18:57 fridolin yellow
18:57 wajasu maybe changing it the memcached will help
18:57 tcohen no no
18:57 wajasu ok
18:57 tcohen memcached is not used for sessions only
18:57 it is configured by default in koha-conf.xml
18:58 and used by Koha::Cache
18:58 which is used all over the place to speed up things
18:58 wajasu remember i installed this same db in place of koha_kohadev on a parallel running KOHA_IMAGE=22.05 kul
18:58 it works there.
18:59 lukeg joined #koha
19:00 wajasu ok/2Gps in network)
19:00 i'm just trying on this linode VPS.  which was a 1M 1CPU VPS, and now I'm on a 2M ram, 1 CPU (5GBdisk, 40Gbps out
19:01 top shows no cpu or much load, swap 512M but not being used
19:11 tcohen I'm clueless right now
19:11 what I'd do is adding some warn ""
19:11 in the relevant places
19:12 wajasu ok. heading there now.  just turned on mysqld query log to see if anything hanging.
19:12 tuxayo wajasu: if you need a backtrace: https://wiki.koha-community.or[…]a_stack_backtrace
19:13 wajasu i might see about how linode does NS and see if thats an issue.
19:13 thx for the debug info.
19:14 at least you gave me some ideas to follow
19:15 i wonder if plack has a rquest timeout setting.  and how long it is. then i can bump it up to see.  then search for the slow work being done.
19:16 at least i have a working ktd to compare settings to.
19:19 i was trying to get the apt update to pickup 22.05.03.000 to make things more like mt kul environment.  but do i need staging in apt sources.list.d/koha.list to pick that up?
19:28 thx for the effort tcohen. i'll investigate some more.
20:39 m23 joined #koha
21:01 tuxayo tcohen: are you the right the person to report to that the next meeting is missing on the calendar?
21:03 tcohen I never managed to make it work :-(
21:03 cait i think it was not added automatically
21:03 i had to add the minutes manually to the last meeting too
21:05 maybe something to look into or someone else maybe could run? not sure if ashimema can
21:05 tcohen I ran the koha-meetings script
21:05 which generated the next one
21:05 cait yeah, but it didn't edit the old one
21:05 tcohen But I am missing the google auth link
21:05 cait to add link to next and minutes
21:05 tcohen and I have no idea about the minutes
21:05 cait and didn't update the calendar, so something is wrong
21:06 it does all that usually
21:06 tuxayo davidnind++ thanks for adding in the calendar
21:06 cait possibly it gets the last meeting date from the calendar and failed therefore?
21:06 davidnind++
21:06 time to sleep here... it just started raining :)
21:06 tuxayo > which generated the next one
21:06 tcohen thanks, it already existed (the wiki page) so I don't know what that did
21:06 cait bye
21:08 tuxayo cait++ thanks for adding the minutes to the last one
21:09 tcohen: so in the future for the calendar I can bother David N and for creating the next's wikipage it's you, is it?
21:13 cait joined #koha
21:16 wajasu tcohen: i think i found the problem.
21:19 i changed the number of plack workers to 1.  because this is a VPS with 1 cpu.  now the opac-search doesn't crash.
21:20 fridolin wajasu: we experianced one can set 2 workers per CPU, should be OK
21:20 1 will be a big bottle-neck
21:21 note that each worker uses RAM thats another limit
21:21 wajasu i moved to a 2GB VPS so ram is not an issue.  not swapping now.
21:22 but my 1CPU VPS crashes with 2 workers.
21:22 maybe the second worker freezes and it times out or whatever.
21:23 now my staff interface works with the 2 workers.  but not opac.
21:30 i'm wondering if there is a plack/psgi/starman config i can use to increase whatever timeout for requests
21:30 just to see if the increased queries in the opac bump it over.
21:31 i logged mysql queries and see they run for up to 10sec.
21:31 both on the opac and staff
21:33 i have this deployed on home box with ktd, and its behaving fine.
21:34 maybe i should try a shared linode with 2CPU.  just to see if that CPU cap is the issue.
21:35 fridolin database performance seems to be the bootle-neck
21:36 did you change innodb_buffer_pool_size ?
21:36 see http://mysqltuner.com
21:36 wajasu yes. i see all those queries. :)
21:36 maybe som n-selects problems.  with joins ...   session update.
21:37 fridolin oups wrong link https://mysqltuner.pl
21:37 what is the hard drive ?
21:37 SSD ?
21:38 wajasu spinning
21:38 fridolin ich, database server dont like that
21:38 wajasu i move this 3.10version of koha that had been running a a box inthe corner since 2010/2012ish
21:38 fridolin do you have innodb_buffer_pool_size >= database size ?
21:39 wajasu after 10 years the disk died. at least i did backup to a second drive :)
21:39 fridolin great life ;)
21:39 wajasu let me check
21:39 fridolin that whould have been said by mysqltuner
21:42 lari_ joined #koha
21:42 kivilahtio_ joined #koha
21:44 claw23 joined #koha
21:44 irc joined #koha
21:47 wajasu tried innodb_buffer_pool_size=900M  still crashes.  let me look into tuning.
21:48 paxed joined #koha
21:50 fridolin1 joined #koha
22:01 wajasu Joins performed without indexes: 81
22:02 maybe i am missing some indexes.  i'll try to compare this db to a fresh 22.05 install
22:05 bag joined #koha
22:08 dpk joined #koha
22:13 fridolin1 wajasu: i bet some queries without indexes  cant be avoided
22:20 wajasu yes. but i could be missing an isbn index or something added since 2012.
22:22 https://wiki.koha-community.org/wiki/Plack  Deploying with starman  suggests one worker per cpu.
22:22 i might configure my ktd or local kvm on my box with 1 cpu and see if i'm in the same boat
22:23 time for a break. thx for ideas.
22:23 i assume koha these days can't run without plack.
22:24 time for a break
22:55 davidnind[m] joined #koha
23:41 tuxayo wajasu: I think it can run without plack
23:42 Wasn't that tcohen that wasn't using plack in production at some point?
23:45 tcohen I submitted koha-plack in 2015 and have been using it ever since :-D
23:45 bug 13791
23:45 huginn` Bug https://bugs.koha-community.or[…]_bug.cgi?id=13791 new feature, P5 - low, ---, tomascohen, CLOSED FIXED, Plack - Out of the box support on packages
23:47 tcohen I think ashimema has a dev environment they use for identifying patches that introduce slowliness
23:49 'crashes'
23:49 needs more details

← Previous day | Today | Next day → | Search | Index

koha1