← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:23 | tuxayo | As part of the hackathon of KohaLa (french Koha users association): |
| 00:23 | 2 people trained on patch testing. Results for attendants: 7 tickets out of the Needs Signoff queue: 4 signoffs and 3 failed QA. | |
| 00:23 | That's a nice result and we still have two days of hackathon :) | |
| 00:23 | cait[m] | very nice :) |
| 00:24 | tuxayo | It being a more formal and wider event than the usual random sessions didn't make more people come but it made them free their entire day and that make a big difference ^o^ |
| 00:30 | davidnind | great! |
| 06:25 | thibaud_g joined #koha | |
| 06:36 | irfa joined #koha | |
| 07:30 | magnuse__ joined #koha | |
| 07:35 | reiveune joined #koha | |
| 07:36 | reiveune | hello |
| 07:52 | alex_ joined #koha | |
| 07:52 | alex_ | Bonjour |
| 08:07 | cait joined #koha | |
| 08:08 | cait | good morning #koha |
| 08:19 | ashimema | Morning |
| 08:29 | tuxayo | hi #koha :) |
| 08:41 | @later tell Joubu: is the ERM sandbox still needed? It's still on 22.06 code. | |
| 08:41 | huginn | tuxayo: The operation succeeded. |
| 08:42 | Joubu | yes still needed |
| 08:45 | tuxayo | ok 👍️ |
| 08:45 | Something weird, I think yesterday at some point the biblibre sandboxes started blocking creation at 5 sandboxes max instead of 6 at the beginning of the day. | |
| 08:46 | Maybe one failed to close and is unlisted but still there or something | |
| 08:56 | Joubu | tuxayo: fixed now |
| 08:56 | something weird happened with "testi" on 2022-12-30 | |
| 08:59 | tuxayo | Thanks :) |
| 10:14 | To help as much a possible people to test patches via sandboxes in autonomy, one big thing is to assess if the patches are testable via sandboxes. | |
| 10:14 | I tried to list the things that are not possible to test and the things that are actually possible. | |
| 10:14 | Here is a draft if someone wants to take a look https://wiki.koha-community.or[…]_testable_tickets | |
| 10:14 | There are so many things to be able to cover most test plans 🤯 | |
| 10:18 | cait | Joubu: can you tell why the refresh schema didn't work for bug 11844 on the sandboxes? |
| 10:18 | huginn | 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=11844 new feature, P5 - low, ---, julian.maurice, Needs Signoff , Additional fields for order lines |
| 10:19 | cait | there is a spun up sandbox witht he bug for biblibre and ptfs, both don't work |
| 10:21 | Joubu | "don't work"? |
| 10:21 | ha | |
| 10:22 | "refresh schema" will return dbic | |
| 10:22 | I tested it, and the schema file is updated | |
| 10:22 | however you need to "restart services" as well, did you do that? | |
| 10:23 | cait | i did |
| 10:23 | it still doesn't work | |
| 10:23 | Joubu | please define does not work |
| 10:23 | cait | refresh schema - restart services |
| 10:23 | hwen you tr to add a new additional field for the order line it gives an erorr "already exists" | |
| 10:23 | Julian said it works for him after refreshing dbic | |
| 10:24 | oh, it does work now... | |
| 10:24 | that#s odd. I am sure I restarted the services multiple times on the ptfs sandbox | |
| 10:25 | Joubu | Koha/Schema/Result/AdditionalField.pm was not modified 10min ago, I run dbic from the UI and the file got modified as expected |
| 10:26 | cait | hm I did run it from the button "Refresh Schema" too |
| 10:26 | did you refresh services first? | |
| 10:26 | or ... I did | |
| 10:26 | maybe we had the sequence wrong? | |
| 10:26 | Joubu | yes, "dbic from the UI" == "Refresh schema" |
| 10:27 | cait | could it be you need to restart services - refresh schema - restart services? |
| 10:27 | Joubu | no |
| 10:27 | refresh schema then restart services | |
| 10:27 | cait | then I am not sure why it suddenly works |
| 10:27 | http://sandboxes.ptfs-europe.co.uk/ here is my sandbox | |
| 10:27 | and I am sure I did both there | |
| 10:28 | ... it works tehre today, but didn't yesterday | |
| 10:28 | ok. I'll just accept it | |
| 10:28 | Joubu | I've noticed weird things on sandboxes with untracked files |
| 10:28 | maybe things go wrong when a new sandbox is created | |
| 10:29 | untracked files or not commited | |
| 10:30 | cait | hard to tell from the outside, the git log looked ok, but you don't see that there |
| 10:30 | maybe it's demo effect, as soon as thy see you, they all behave :) | |
| 10:34 | tuxayo | You need a joubu-scarecrow to keep the sandboxes on check |
| 11:17 | oleonard | Hi #koha |
| 12:29 | alex_ joined #koha | |
| 12:30 | ashimema | anyone any good with our API's? |
| 12:30 | I'm baffled as to how it's working out what biblio fields to return from an item request when I embed biblio | |
| 12:31 | Joubu | if you pass 'embed: biblio' it will return the whole biblio object |
| 12:33 | ashimema | that's what I thought |
| 12:33 | except.. it's not for me.. | |
| 12:33 | not on the public side at least | |
| 12:33 | it's missing some fields.. but I can't fathom why.. | |
| 12:33 | like 'title' and 'callnumber' | |
| 12:34 | cait | visibility settings... but I guess that's unlikely? |
| 12:34 | marcelr joined #koha | |
| 12:34 | marcelr | o/ |
| 12:35 | Joubu | ashimema: which route? |
| 12:35 | hi marcelr | |
| 12:36 | marcelr | hi Joubu |
| 12:36 | wahanui | hi Joubu are you around? |
| 12:36 | oleonard | wahanui: forget hi Joubu |
| 12:36 | wahanui | oleonard: I forgot hi joubu |
| 12:36 | cait | wahanui botsnack cookie |
| 12:36 | wahanui | :) |
| 12:36 | cait | I feel guilty for all the memory loss we cause |
| 12:37 | marcelr | lets forget that |
| 12:40 | oleonard | Considering how bad my memory is these days I think it's only fair. |
| 13:36 | emlam joined #koha | |
| 13:51 | caroline_catlady joined #koha | |
| 13:53 | marie-luce joined #koha | |
| 13:59 | ashimema | public/items Joubu |
| 14:00 | ho.. something very funky is going on in retrospect | |
| 14:00 | I was looking at x-koha-embed for the intranet route | |
| 14:00 | the public one doesn't have any x-koha-embed option in the spec | |
| 14:00 | yet it does return some fields. | |
| 14:01 | Joubu | yes, "/public/biblios/{biblio_id}/items" does not allow any embed i seems |
| 14:01 | it seems* | |
| 14:01 | ashimema | i would have expected a clearer failure |
| 14:01 | the fact it embed anything seems wrong | |
| 14:01 | bugger.. I hate uncovering deeper issues | |
| 14:01 | Joubu | yes |
| 14:02 | it usually says "no allowed" or something | |
| 14:02 | ashimema | indeed |
| 14:03 | Joubu | ashimema: it actually embed biblioitem |
| 14:04 | ashimema | ah.. I think you're right |
| 14:04 | but I also think there's other bugs lurking in this spec... | |
| 14:05 | x-koha-embed mobed to proper header params.. but in this file they still appear to be at their own level in the spec | |
| 14:05 | grr | |
| 14:07 | Joubu | I think it's not exploding because Koha::Item->biblio exists |
| 14:07 | but it does not explain why biblioitem is embeded | |
| 14:08 | ashimema | I believe it should explode really after checking x-koha-embed and not even try to call ->biblio |
| 14:08 | so strange | |
| 14:13 | Dyrcona joined #koha | |
| 14:14 | ashimema | it doesn't seem to pay any attention whatsoever as to whether there's an x-koha-embed header or not in the spec now |
| 14:14 | if you pass one now it'll try to embed regardless | |
| 14:15 | that's wrong I believe | |
| 14:18 | caroline_catlady | Hi all! I need a TT expert... Is it possible to add a "sort" to the issue slip so that it's sorted by date_due? |
| 14:18 | As I understand it now, it's sorted by timestamp | |
| 14:24 | magnuse_ joined #koha | |
| 14:39 | Joubu | marcelr: bug 32709 |
| 14:39 | huginn | 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=32709 major, P5 - low, ---, jonathan.druart+koha, In Discussion , Background job UI and REST API routes explode if JSON is incorrect |
| 14:39 | Joubu | opened this morning |
| 14:40 | marcelr | ah yeah i meant that one |
| 14:41 | magnuse__ joined #koha | |
| 14:53 | piotrmaj[m] joined #koha | |
| 14:55 | piotrmaj[m] | Hi, I maintain a small Koha instance for Polish Saturday School in Santa Clara and have the following problem: |
| 14:55 | Upgrade to 22.06.00.077 [06:52:01]: | |
| 14:55 | ERROR - {UNKNOWN}: Can't use an undefined value as a subroutine reference at /usr/share/koha/lib/C4/Installer.pm line 737. at /usr/share/koha/lib/C4/Installer.pm line 739 | |
| 14:56 | this happened when I tried to upgrade using Debian packages. | |
| 14:56 | does anyone know what could go wrong - the instance is in maintenance mode and I'm pretty much stuck | |
| 14:59 | right before this error the following messages appear:... (full message at <https://matrix.org/_matrix/med[…]BfMMSUbYoESDwTouA>) | |
| 15:00 | Joubu | using debian? which version? |
| 15:00 | piotrmaj[m] | 9.13 |
| 15:01 | Joubu | version of perl? |
| 15:01 | piotrmaj[m] | This is perl 5, version 24, subversion 1 (v5.24.1) built for x86_64-linux-gnu-thread-multi |
| 15:01 | Joubu | I don't think we are still supporting debian 9 |
| 15:02 | piotrmaj[m] | ok, I'll try to upgrade |
| 15:02 | thank you | |
| 15:03 | which version do you recommend? | |
| 15:04 | Joubu | the current debian stable is 11 (bullseye) |
| 15:04 | piotrmaj[m] | ok, I'll try to upgrade today |
| 15:04 | Joubu | but, to be honest, you error is about a deprecation, not sure it will fix to upgrade |
| 15:04 | your* | |
| 15:08 | piotrmaj[m]: I confirm that it seems to work on D11 with perl 5.32, I don't see the warning/error | |
| 15:10 | piotrmaj[m] | I'll give it a shot - upgrade is long overdue anyway |
| 15:28 | lukeg joined #koha | |
| 15:44 | piotrmaj[m] | updated to buster (one up) and some updated succeeded but now I get: |
| 15:44 | ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs at /usr/share/koha/lib/C4/Installer.pm line 739 | |
| 15:46 | Joubu | see bug 28635 |
| 15:46 | huginn | 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=28635 enhancement, P5 - low, ---, koha-bugs, RESOLVED DUPLICATE, upgrade from Koha 20.05.06.000 to latest version failing with Row size too large |
| 15:47 | Joubu | hum sorry, it's bug 28267 |
| 15:47 | huginn | 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=28267 critical, P1 - high, ---, koha-bugs, Failed QA , Older databases fail to upgrade due to having a row format other than "DYNAMIC" |
| 15:48 | piotrmaj[m] | thank you! You are golden! I need to go to work now - will continue in the afternoon |
| 15:49 | Joubu | comment 15 specifically, there is an example that needs to be adjusted, depending on the table that causes the error |
| 15:54 | oleonard joined #koha | |
| 16:15 | reiveune | bye |
| 16:15 | reiveune left #koha | |
| 16:27 | lukeg joined #koha | |
| 18:02 | lukeg joined #koha | |
| 18:04 | lukeg joined #koha | |
| 18:35 | lukeg joined #koha | |
| 18:49 | bag joined #koha | |
| 19:57 | lukeg joined #koha | |
| 21:55 | kohalogbot joined #koha | |
| 22:04 | pastebot joined #koha | |
| 22:28 | JBoyer joined #koha | |
| 23:27 | magnuse | huh, my upgrade from 20.11.06 to 22.05.08 has been stuck at "Upgrade to 21.05.00.000 [23:39:23]: Koha 21.05.00 release" for 45 minutes now. the version in the database is "21.0600000" |
| 23:28 | rangi[m] | what does show processlist in mysql tell you? |
| 23:31 | magnuse | copy to tmp table | ALTER TABLE sessions MODIFY a_session LONGBLOB NOT NULL |
| 23:31 | rangi[m] | ahh |
| 23:31 | if you have a big sessions table, that will take a while | |
| 23:32 | magnuse | yeah, looks like it is huge... |
| 23:32 | rangi[m] | it should tell how long that query has been running too |
| 23:33 | its generally fine to truncate the sessions (logs everyone out of course) but too late now :) | |
| 23:33 | magnuse | Time = 1874 |
| 23:33 | yeah... | |
| 23:34 | looks like the db_rev does a "DELETE FROM sessions": https://git.koha-community.org[…]revs/210600001.pl | |
| 23:35 | rangi[m] | ahhh |
| 23:36 | which musta failed i guess? | |
| 23:36 | or not deleted anything if you still have rows in teh sessions table | |
| 23:36 | magnuse | dunno. "select count(*) from sessions;" takes forever too |
| 23:37 | rangi[m] | its probably locked cos of the alter |
| 23:37 | magnuse | ah, ok |
| 23:38 | could it be something to do with transactions? deleting everything and changing the table in the same transaction or something? | |
| 23:51 | rangi[m] | ah probably yeah |
| 23:52 | magnuse | woohoo, the processlist is showing something else now, and the version in the database is up to 21.0600015 |
| 23:52 | rangi[m] | yay! |
| 23:53 | magnuse | thanks for the tip about the processlist! i would have assumed it was "stuck" and resorted to Ctrl+C by now, i think... |
| 23:54 | got an error after "21.06.00.016" though: ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: FUNCTION koha_mykoha.REGEXP_REPLACE does not exist at /usr/share/koha/lib/C4/Installer.pm line 739 |
← Previous day | Today | Next day → | Search | Index