Time Nick Message 02:19 wajasu i've got my new debian11 with 22.0503000 in the db syspref and Koha.pm 02:20 wajasu the opac always disconnects the connection at the first search. the staff interface works. 02:21 wajasu i've also just install that same db with KOHA_IMAGE=22.05 kul , koha-upgrade-schema, koha-rebuild-zebra 02:23 wajasu that docker environment has 22.05.02.000 in the db syspref and Koha.pm 02:26 wajasu both the opac and staff succeed in the search in the docker ktd environment. 02:27 wajasu now i want to see if its the specific version 22.0503000 that is broken, or if its my debian11 install. 02:31 wajasu i guess i can try to change my koha git tag to v22.05.02, then KOHA_IMAGE=22.05 kul 02:34 wajasu then the kul docker environment would be as close to my failing installation. if it succeeds, then 22.0503000 is broken. 02:35 wajasu if it fails, its something else. i'll have to debug opac-search.pl. maybe use debugger, and step through. 02:36 wajasu or look to see if the database will log a statement for a query ... 02:36 wajasu tmrw morning. 02:37 wajasu at least i know my database in the ktd/kul works at 22.05.02.000 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.org/job/Koha_21.11_D12/103/ 07:14 cait1 Frido, jajm ^ 11:25 tcohen hola #koha 11:31 cait1 hola tcohen 11:36 tcohen bye koha-jenkins 11:44 tcohen hi all, anyone willing to check on the jenkins build notifications, can join the #koha-ci channel 11:44 tcohen 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 tcohen Recibiendo objetos: 44% (3853/8692), 55.82 MiB | 56.00 KiB/s 11:55 tcohen 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/gitweb/?p=koha.git;a=commitdiff;h=d33f8729652d47857dd83586a5a282e2d19627a8> 12:14 huginn` News from kohagit: Bug 30650: Add missing koha_object[s]_class methods <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=bba4bc93ebd2b5991723bf10d62c99a23b9629bc> 12:14 huginn` News from kohagit: Bug 30499: Move the include for catalogue-search-box.inc in circ-search.inc to correc... <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=94191e5bfe681dca021bb133c9593bc5bc7e2193> 12:14 huginn` News from kohagit: Bug 31251: Use jQuery val() to clear_entry <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=a3198f647496d87e19036432f1be9f87dac4614d> 12:14 huginn` News from kohagit: Bug 31223: Regression tests <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=28896d9c302ad41fce463fd8d80ea02283a7d55b> 12:14 huginn` News from kohagit: Bug 31223: Do not explode if plugins disabled <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7867106d430dd9ab3f673185945467931a10082e> 12:14 huginn` News from kohagit: Bug 30965: Add patron autocomplete search to curbside pickups <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=accc73e1279b753c18bdf21be3cbeab174f8cec3> 12:14 huginn` News from kohagit: Bug 30028: Fix patron message delete confirmation to be translatable <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=622137294a4f1eca66ff794e1a91a75c08fe30c8> 12:14 huginn` News from kohagit: Bug 28707: Translate RECEIPT notice <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=160d96e176331f8ac8eef4942bcc0af1868017c5> 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/gitweb/?p=koha.git;a=commitdiff;h=8bba933d488fe98cbc379552a332f328cad515e7> 12:32 huginn` News from kohagit: Bug 30468: Restore 'set -e' and remove echos <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=4a00658e349fb21a9a334f0ab880d81b8f51d2e3> 12:32 huginn` News from kohagit: Bug 31269: Define sDefaultContent for DataTables <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=573db0fca181cb36063462ed566adc5bac7f293d> 12:32 huginn` News from kohagit: Bug 30984: (QA follow-up) Switch from mediumtext to varchar(255) <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=526606901626082831ab501609cf05e360551ce1> 12:32 huginn` News from kohagit: Bug 30984: (QA follow-up) Ternary formatting style <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b3a0d75a40cfeec8e14d7092b4cf23763363b45a> 12:32 huginn` News from kohagit: Bug 30984: Action logs should log the cronjob script name that generated the given log <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=18fd0c89cf7f288ad5ff4527484d9e989ed3e5f7> 12:32 huginn` News from kohagit: Bug 30658: (bug 29496 follow-up) CheckMandatorySubfields don't work properly with... <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=4f6164d1940f4d666d2efb0e3e8d76bea3108125> 12:32 huginn` News from kohagit: Bug 30468: koha-mysql does not honor Koha's timezone setting <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e97b099d58e73be44354d2343c0f45077871b398> 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 tcohen i.e. version mismatch 12:35 tcohen it is working for me 12:35 tcohen same version 12:35 tcohen was about to upgrade to 4.11 on friday 12:35 tcohen 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 tcohen it uses a VM and restarting it fixed things in the past 12:39 tcohen this is not Linux 12:39 tcohen and I agree: you need to believeeeeee 12:53 cait1 tcohen: did you see my note on your holds bug? I can no longer set holds to waiting :( 13:02 tcohen cait1: saw it, working on that after the push I'm doing 13:02 tcohen thanks for the reminder! 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/gitweb/?p=koha.git;a=commitdiff;h=83b7f1a74d6c9089e7ddf4c9435436e51b519ff1> 13:04 huginn` News from kohagit: Bug 30612: Rename other occurrences <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=6a3262de99ba05a49e63ee45e823d9bda87f1efc> 13:04 huginn` News from kohagit: Bug 30612: (QA follow-up) Rename accountlines method to account_lines <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=5b7ec36b7f91b0b6a7b77bc910f334871231ab0a> 13:04 huginn` News from kohagit: Bug 27849: (follow-up) Add test <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ad0aa754ee2a3e8e438594a54b2375b994753951> 13:04 huginn` News from kohagit: Bug 30964: (QA follow-up) Add classes to allow for additional styling <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=945339b757e6fdc2c216b405c0afd3bfb42a3de0> 13:04 huginn` News from kohagit: Bug 30964: Add 'restricted' and 'has overdues' on curbside pickup <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3960ccb4de0b2308919d9428cb19bb5ef438cc3b> 13:04 huginn` News from kohagit: Bug 30612: Update schema files <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=396402aa6850ce1f57106d9820d9081f10256df8> 13:04 huginn` News from kohagit: Bug 30612: Add accountlines method to Koha::Checkout and Koha::Old::Checkout <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=58dfeff13a2ade61a6a3eda2a4339b4b1cf02637> 13:04 huginn` News from kohagit: Bug 28864: Have patron card creator use PatronsPerPage <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=5ca665f6aaf750fa507875343da0adb423ad7bd8> 13:04 huginn` News from kohagit: Bug 27849: Koha::Token may access undefined C4::Context->userenv <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8c45fe1aaa54fd9d6ff84617df0bb94b4cfbbb12> 14:02 cait1 zero emails on koha-bugsfor some time now :( 14:20 lukeg hi 14:20 wahanui privet, lukeg 14:25 wajasu i believe 14:25 * cait1 waves 14:39 tundunf hi everyone 14:44 oleonard Hi tundunf 14:48 reiveune bye 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 tundunf 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 cait1 that creates some warning on checkout 15:01 cait1 and checkin 15:01 tundunf ah thank you 15:02 tundunf 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.org/bugzilla3/show_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 cait1 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 cait1 it could make a nice enh 15:06 tundunf will do! 15:06 tundunf 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 cait1 FlorianB: but a lot of people are using koha-testing-docker these days, so not sure when ti comes to fixes etc 17:15 huginn` News from kohagit: Bug 30077: DBRev 22.06.00.028 <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=35e03400495924088081e825349261a3c2b54ac8> 17:15 huginn` News from kohagit: Bug 30077: Compiled CSS <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=67cc0f8de2566f861c8cfd7185cf57cb92d9cf49> 17:15 huginn` News from kohagit: Bug 23919: DBRev 22.06.00.027 <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d990595d846cd087f67a59a13ee492ef68e27a47> 17:15 huginn` News from kohagit: Bug 23919: (QA follow-up) Tidy query build code <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=fa5f643000ebffda464fef611a0bf788900c369d> 17:15 huginn` News from kohagit: Bug 23919: Add tests for Items search by ISBN and ISSN with variations <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=cdcccc9cbe4c458ba7a1b57aa29e1d24463c5bd7> 17:15 huginn` News from kohagit: Bug 23919: Add tests for biblioItems search by ISBN and ISSN with <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d5850d8ba44e1de41e8ba2c40604d299db445c8a> 17:15 huginn` News from kohagit: Bug 23919: Items search by ISBN variations and ISSN variations <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=678bc58bb99f9c057a48a21f941670a49ec06925> 17:15 huginn` News from kohagit: Bug 23919: Zebra search by ISSN variations <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=a18da2b21f3960ed344f8afb5caa9c99bb30331e> 17:15 huginn` News from kohagit: Bug 23919: Add new system preference SearchWithISSNVariations <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b789571ff57630818ee977212b5bcca0246777f1> 17:15 huginn` News from kohagit: Bug 30077: (follow-up) Set max width for library drapdown <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c1ba39c8c9195a4789608209d907ebcb44bfa06a> 17:15 huginn` News from kohagit: Bug 30077: (follow-up) retain branch selection <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=593614456c1c25ddb5ebd34d511a126cf659bc49> 17:15 huginn` News from kohagit: Bug 30077: Add system preference IntranetAddMastheadLibraryPulldown <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=53e9309772206ac947d94eefd85a3e1fdf0cfdef> 17:39 huginn` News from kohagit: Bug 30392: DBRev 22.06.00.029 <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1c924bbcf4913da1659a7aab6a3ea7cd720584c1> 17:39 huginn` News from kohagit: Bug 30392: DBIC update <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ba404f2ba93a4c79c55ea9977848bb889d5c97b7> 17:39 huginn` News from kohagit: Bug 30392: (QA follow-up) Correct COMMENT <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=bc1e0d04fca13adb1553cdba32e33c7a4ce24fc1> 17:39 huginn` News from kohagit: Bug 29579: (QA follow-up) Fix up t/db_dependent/Koha/Reports.t <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=12f42a5aafea277c2e8456d658e3cd8bb48930bf> 17:39 huginn` News from kohagit: Bug 30392: Set deleted_on when an item is (marked as) deleted <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=36d1f18bd57796c0200ca0de0495a6720d2bbfcc> 17:39 huginn` News from kohagit: Bug 30392: DB changes <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=959fe662ed9f236061eac41b57698acae5d0827d> 17:39 huginn` News from kohagit: Bug 29579: Show saved SQL report ID in database query <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f0ba2a8484759d178c5c037f901e2d63a6c97192> 17:49 huginn` News from kohagit: Bug 30077: (QA follow-up) Avoid warning <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=cdf34ce15603edfee5453ce7b232d2ceb0aa61e7> 17:53 wajasu i need some help. i need a hint as where to look for my problem. 17:53 wajasu fresh koha 22.05.02.000 debian 11 install, but with my legacy database brought in. 17:54 tcohen go on 17:54 tcohen we are all reading 17:54 tcohen :-D 17:55 wajasu the database has 22.0502000 version in sys prefs 17:55 wajasu my problem is when i do a search in OPAC, i get connection timeout in browser 17:55 wajasu 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 tcohen maybe NS, etc 17:59 wajasu i just did a bunch of apt update upgrade stuff. 18:00 wajasu it works now. let me reboot the server 18:00 wajasu when i reboot, does zebra always rebuild? 18:03 wajasu i reboot. now the opac comes up, i search and i get dropped connection. when i search 18:05 wajasu its workingnow. 18:07 wajasu 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 tcohen which is handled by koha-indexer 18:08 wajasu no updateing. just plain search out the box. 18:08 wajasu not this is on a 4GB linode shared VPS. 18:09 wajasu not sure if other users can influence performance on my kvm 18:10 wajasu rebooting again 18:17 wajasu well if i change my search criteria, i saw the result pae come up, but maybe cover resource lookup are delayed. 18:22 wajasu 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 wajasu plack 18:24 wajasu i'm the only user 18:24 wajasu its standard out of the box deployment. 18:25 wajasu just IP config for apache 18:25 wajasu localhost 18:25 wahanui somebody said localhost was literally "localhost" or I should sub that for something else? 18:26 tcohen so 18:26 tcohen if you restart things does it work? 18:26 tcohen 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 wajasu 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 wajasu maybe i need branch_limit configured because it may be dooing some work based on that and timing out 18:34 wajasu line 491 mentions building cache_key 18:34 tcohen you did a fresh install, right? 18:34 tcohen and just carried your /var/lib/koha/<instance> stuff 18:34 tcohen and hte DB 18:34 tcohen right? 18:35 wajasu i did a few this weekend. with same results. things work with same database in ktd. 18:36 wajasu 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 wajasu then did koha-upgrade-schema <instance> 18:37 wajasu then koha-rebuild -f -v <instance> 18:37 wajasu then startup koha-common and apache 18:38 wajasu staf interface works, but opac had the problem. 18:41 tcohen is PLack enabled for both OPAC and staff? 18:41 tcohen thinking of deployment issues 18:42 tcohen koha-plack --enable <instance> 18:42 tcohen 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 wajasu do you think that branch-limit undef warning in the paste above could be an issue? staff search doesn't show that 18:52 wajasu 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 tcohen did you change searchengine? 18:53 tcohen 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 wajasu restarting memcached didn't help 18:55 wajasu i left searach engine alone. remember my 3.10 db wasnt using memcached 18:56 wajasu sysprefs shows session storage in mysql 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 tcohen it is configured by default in koha-conf.xml 18:58 tcohen and used by Koha::Cache 18:58 tcohen 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 wajasu it works there. 19:00 wajasu ok/2Gps in network) 19:00 wajasu 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 wajasu top shows no cpu or much load, swap 512M but not being used 19:11 tcohen I'm clueless right now 19:11 tcohen what I'd do is adding some warn "" 19:11 tcohen 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.org/wiki/User:Victor_Grousset_-_tuxayo/Debugging#print_a_stack_backtrace 19:13 wajasu i might see about how linode does NS and see if thats an issue. 19:13 wajasu thx for the debug info. 19:14 wajasu at least you gave me some ideas to follow 19:15 wajasu 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 wajasu at least i have a working ktd to compare settings to. 19:19 wajasu 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 wajasu thx for the effort tcohen. i'll investigate some more. 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 cait i had to add the minutes manually to the last meeting too 21:05 cait 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 tcohen 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 cait 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 cait davidnind++ 21:06 cait time to sleep here... it just started raining :) 21:06 tuxayo > which generated the next one 21:06 tuxayo 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 tuxayo 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:16 wajasu tcohen: i think i found the problem. 21:19 wajasu 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 fridolin 1 will be a big bottle-neck 21:21 fridolin 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 wajasu but my 1CPU VPS crashes with 2 workers. 21:22 wajasu maybe the second worker freezes and it times out or whatever. 21:23 wajasu now my staff interface works with the 2 workers. but not opac. 21:30 wajasu i'm wondering if there is a plack/psgi/starman config i can use to increase whatever timeout for requests 21:30 wajasu just to see if the increased queries in the opac bump it over. 21:31 wajasu i logged mysql queries and see they run for up to 10sec. 21:31 wajasu both on the opac and staff 21:33 wajasu i have this deployed on home box with ktd, and its behaving fine. 21:34 wajasu 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 fridolin did you change innodb_buffer_pool_size ? 21:36 fridolin see http://mysqltuner.com 21:36 wajasu yes. i see all those queries. :) 21:36 wajasu maybe som n-selects problems. with joins ... session update. 21:37 fridolin oups wrong link https://mysqltuner.pl 21:37 fridolin what is the hard drive ? 21:37 fridolin SSD ? 21:37 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:47 wajasu tried innodb_buffer_pool_size=900M still crashes. let me look into tuning. 22:01 wajasu Joins performed without indexes: 81 22:02 wajasu maybe i am missing some indexes. i'll try to compare this db to a fresh 22.05 install 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 wajasu https://wiki.koha-community.org/wiki/Plack Deploying with starman suggests one worker per cpu. 22:22 wajasu 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 wajasu time for a break. thx for ideas. 22:23 wajasu i assume koha these days can't run without plack. 22:24 wajasu time for a break 23:41 tuxayo wajasu: I think it can run without plack 23:42 tuxayo 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 tcohen bug 13791 23:45 huginn` Bug https://bugs.koha-community.org/bugzilla3/show_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 tcohen 'crashes' 23:49 tcohen needs more details