Koha 20.05, Ubuntu 18.04 and MariaDB
Hi. I don't want to shred Michael Kuhn's question, but I have a similar one: I am using Koha 20.05 on Ubuntu 18.04, and I updated MariaDB to versión 10.3. This is working. But I am curious to know, if it would work with MariaDB 10.4 or 10.5 as well. Thanks Isabel Pineda
I’ve been running 20.05 on MariaDB 10.5 in testing since 20.05 was released. No issues to report yet On Mon, Jul 27, 2020 at 9:36 AM Isabel Pineda <isabel.pineda@ds.edu.sv> wrote:
Hi. I don't want to shred Michael Kuhn's question, but I have a similar one: I am using Koha 20.05 on Ubuntu 18.04, and I updated MariaDB to versión 10.3. This is working. But I am curious to know, if it would work with MariaDB 10.4 or 10.5 as well.
Thanks Isabel Pineda _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- *R. Christian McDonald * M: (616) 856-9291 E: rcmcdonald91@gmail.com
Hi Christian. Thank you very much. Are you running it on Ubuntu 18.04 too? Thanks Isabel Pineda De: Christian McDonald [mailto:rcmcdonald91@gmail.com] Enviado el: lunes, 27 de julio de 2020 07:46 a.m. Para: Isabel Pineda <isabel.pineda@ds.edu.sv> CC: Koha <koha@lists.katipo.co.nz> Asunto: Re: [Koha] Koha 20.05, Ubuntu 18.04 and MariaDB I’ve been running 20.05 on MariaDB 10.5 in testing since 20.05 was released. No issues to report yet On Mon, Jul 27, 2020 at 9:36 AM Isabel Pineda <isabel.pineda@ds.edu.sv<mailto:isabel.pineda@ds.edu.sv>> wrote: Hi. I don't want to shred Michael Kuhn's question, but I have a similar one: I am using Koha 20.05 on Ubuntu 18.04, and I updated MariaDB to versión 10.3. This is working. But I am curious to know, if it would work with MariaDB 10.4 or 10.5 as well. Thanks Isabel Pineda _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha -- R. Christian McDonald M: (616) 856-9291 E: rcmcdonald91@gmail.com<mailto:rcmcdonald91@gmail.com>
It's known to work with MariaDB 10.1 and 10.3, not the latest MariaDB (10.5.4) https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26042 This is the versions our CI are running, I cannot tell for 10.4 Le lun. 27 juil. 2020 à 15:35, Isabel Pineda <isabel.pineda@ds.edu.sv> a écrit :
Hi. I don't want to shred Michael Kuhn's question, but I have a similar one: I am using Koha 20.05 on Ubuntu 18.04, and I updated MariaDB to versión 10.3. This is working. But I am curious to know, if it would work with MariaDB 10.4 or 10.5 as well.
Thanks Isabel Pineda _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
10.4 is the default mariadb version you get with an up-to-date Debian 9 or Ubuntu 18. It works. Philippe Blouin, Directeur de la technologie Tél. : (833) 465-4276, poste 230 philippe.blouin@inLibro.com <mailto:philippe.blouin@inLibro.com> inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com> On 2020-07-27 10:07 a.m., Jonathan Druart wrote:
It's known to work with MariaDB 10.1 and 10.3, not the latest MariaDB (10.5.4) https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26042 This is the versions our CI are running, I cannot tell for 10.4
Le lun. 27 juil. 2020 à 15:35, Isabel Pineda <isabel.pineda@ds.edu.sv> a écrit :
Hi. I don't want to shred Michael Kuhn's question, but I have a similar one: I am using Koha 20.05 on Ubuntu 18.04, and I updated MariaDB to versión 10.3. This is working. But I am curious to know, if it would work with MariaDB 10.4 or 10.5 as well.
Thanks Isabel Pineda _______________________________________________
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
Not sure about that Philippe, Debian 9 is shipped with 10.1.45 Debian 10 and 11 have 10.3.22 and 10.3.23 https://packages.debian.org/bullseye/mariadb-server Le lun. 27 juil. 2020 à 16:32, Philippe Blouin <philippe.blouin@inlibro.com> a écrit :
10.4 is the default mariadb version you get with an up-to-date Debian 9 or Ubuntu 18.
It works.
Philippe Blouin, Directeur de la technologie
Tél. : (833) 465-4276, poste 230 philippe.blouin@inLibro.com
inLibro | pour esprit libre | www.inLibro.com On 2020-07-27 10:07 a.m., Jonathan Druart wrote:
It's known to work with MariaDB 10.1 and 10.3, not the latest MariaDB (10.5.4) https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26042 This is the versions our CI are running, I cannot tell for 10.4
Le lun. 27 juil. 2020 à 15:35, Isabel Pineda <isabel.pineda@ds.edu.sv> a écrit :
Hi. I don't want to shred Michael Kuhn's question, but I have a similar one: I am using Koha 20.05 on Ubuntu 18.04, and I updated MariaDB to versión 10.3. This is working. But I am curious to know, if it would work with MariaDB 10.4 or 10.5 as well.
Thanks Isabel Pineda _______________________________________________
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
Hi Philippe Am 27.07.20 um 16:32 schrieb Philippe Blouin:
10.4 is the default mariadb version you get with an up-to-date Debian 9 or Ubuntu 18.
It works.
I just updated another Installation of Debian GNU/Linux 9.12 to 9.13. But it only updated to MariaDB 10.1.45, not 10.4.x So my question is still open, if Koha 18.11 on Debian 9 will work with Koha 10.3 Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
I only dared to write that affirmatively because I was just in the process of updating another machine (from 9.9 to 9.13), and it was installing MariaDB 10.4.13. It was right in front of me, on my screen. But after your answers I dug a bit and yeah, the source.list.d specifies 10.4 for mariadb. So my initial answer is mostly wrong. The only correct part is that we do have multiple production systems running 10.4 without glitch, but that is not proof of anything. My apologies for the misleading answer. Philippe Blouin, Directeur de la technologie Tél. : (833) 465-4276, poste 230 philippe.blouin@inLibro.com <mailto:philippe.blouin@inLibro.com> inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com> On 2020-07-27 10:56 a.m., Michael Kuhn wrote:
Hi Philippe
Am 27.07.20 um 16:32 schrieb Philippe Blouin:
10.4 is the default mariadb version you get with an up-to-date Debian 9 or Ubuntu 18.
It works.
I just updated another Installation of Debian GNU/Linux 9.12 to 9.13. But it only updated to MariaDB 10.1.45, not 10.4.x
So my question is still open, if Koha 18.11 on Debian 9 will work with Koha 10.3
Best wishes: Michael
I've been running 19.11.05 for several months now with MariaDB 10.4.13 with no issues AFAIK. I upgraded a test server to 20.05 and got some errors from updatedatabase.pl like this: 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 [for Statement "ALTER TABLE branches DROP COLUMN branchprinter"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 21074. After some investigating I found that our database (imported from 3.22 in April) had a row_format of "Compact" on all tables and newer versions of the database have a row_format of "Dynamic". I expect this is cruft from our database that has been imported into new versions of Koha several times, since we've been using Koha for 10+ years. Anyway, on my test server I changed ours to Dynamic and it was able to update without any errors after that, but I haven't yet upgraded our production server to it. Probably no one else will run into this, but I thought I'd just put it out into the ether in case anyone else runs into this issue. Cindy ----------------------------------------------------------- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org On Mon, Jul 27, 2020 at 11:24 AM Philippe Blouin < philippe.blouin@inlibro.com> wrote:
I only dared to write that affirmatively because I was just in the process of updating another machine (from 9.9 to 9.13), and it was installing MariaDB 10.4.13.
It was right in front of me, on my screen.
But after your answers I dug a bit and yeah, the source.list.d specifies 10.4 for mariadb.
So my initial answer is mostly wrong. The only correct part is that we do have multiple production systems running 10.4 without glitch, but that is not proof of anything.
My apologies for the misleading answer.
Philippe Blouin, Directeur de la technologie
Tél. : (833) 465-4276, poste 230 philippe.blouin@inLibro.com <mailto:philippe.blouin@inLibro.com>
inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com> On 2020-07-27 10:56 a.m., Michael Kuhn wrote:
Hi Philippe
Am 27.07.20 um 16:32 schrieb Philippe Blouin:
10.4 is the default mariadb version you get with an up-to-date Debian 9 or Ubuntu 18.
It works.
I just updated another Installation of Debian GNU/Linux 9.12 to 9.13. But it only updated to MariaDB 10.1.45, not 10.4.x
So my question is still open, if Koha 18.11 on Debian 9 will work with Koha 10.3
Best wishes: Michael
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hello Cindy, We faced this error for the table borrowers (bug 24986). I am quite surprised you got it for the branches table, especially for a "DROP COLUMN" statement. Do you have a ton of entries in this table? Regards, Jonathan Le mer. 29 juil. 2020 à 19:05, Cindy Murdock Ames <cmurdock@ccfls.org> a écrit :
I've been running 19.11.05 for several months now with MariaDB 10.4.13 with no issues AFAIK. I upgraded a test server to 20.05 and got some errors from updatedatabase.pl like this:
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 [for Statement "ALTER TABLE branches DROP COLUMN branchprinter"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 21074.
After some investigating I found that our database (imported from 3.22 in April) had a row_format of "Compact" on all tables and newer versions of the database have a row_format of "Dynamic". I expect this is cruft from our database that has been imported into new versions of Koha several times, since we've been using Koha for 10+ years. Anyway, on my test server I changed ours to Dynamic and it was able to update without any errors after that, but I haven't yet upgraded our production server to it. Probably no one else will run into this, but I thought I'd just put it out into the ether in case anyone else runs into this issue.
Cindy
----------------------------------------------------------- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org
On Mon, Jul 27, 2020 at 11:24 AM Philippe Blouin < philippe.blouin@inlibro.com> wrote:
I only dared to write that affirmatively because I was just in the process of updating another machine (from 9.9 to 9.13), and it was installing MariaDB 10.4.13.
It was right in front of me, on my screen.
But after your answers I dug a bit and yeah, the source.list.d specifies 10.4 for mariadb.
So my initial answer is mostly wrong. The only correct part is that we do have multiple production systems running 10.4 without glitch, but that is not proof of anything.
My apologies for the misleading answer.
Philippe Blouin, Directeur de la technologie
Tél. : (833) 465-4276, poste 230 philippe.blouin@inLibro.com <mailto:philippe.blouin@inLibro.com>
inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com> On 2020-07-27 10:56 a.m., Michael Kuhn wrote:
Hi Philippe
Am 27.07.20 um 16:32 schrieb Philippe Blouin:
10.4 is the default mariadb version you get with an up-to-date Debian 9 or Ubuntu 18.
It works.
I just updated another Installation of Debian GNU/Linux 9.12 to 9.13. But it only updated to MariaDB 10.1.45, not 10.4.x
So my question is still open, if Koha 18.11 on Debian 9 will work with Koha 10.3
Best wishes: Michael
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
Hi Jonathan, No, we only have 9 libraries so there should only be 11 entries in that table (we have two rotating collections we treat as "branches" as well). Cindy ----------------------------------------------------------- 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 Thu, Jul 30, 2020 at 3:29 AM Jonathan Druart < jonathan.druart@bugs.koha-community.org> wrote:
Hello Cindy, We faced this error for the table borrowers (bug 24986). I am quite surprised you got it for the branches table, especially for a "DROP COLUMN" statement. Do you have a ton of entries in this table? Regards, Jonathan
Le mer. 29 juil. 2020 à 19:05, Cindy Murdock Ames <cmurdock@ccfls.org> a écrit :
I've been running 19.11.05 for several months now with MariaDB 10.4.13
no issues AFAIK. I upgraded a test server to 20.05 and got some errors from updatedatabase.pl like this:
DBD::mysql::db do failed: Row size too large. The maximum row size for
with 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 [for Statement "ALTER TABLE branches DROP COLUMN branchprinter"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 21074.
After some investigating I found that our database (imported from 3.22 in April) had a row_format of "Compact" on all tables and newer versions of the database have a row_format of "Dynamic". I expect this is cruft from our database that has been imported into new versions of Koha several times, since we've been using Koha for 10+ years. Anyway, on my test server I changed ours to Dynamic and it was able to update without any errors after that, but I haven't yet upgraded our production server to it. Probably no one else will run into this, but I thought I'd just put it out into the ether in case anyone else runs into this issue.
Cindy
----------------------------------------------------------- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org
On Mon, Jul 27, 2020 at 11:24 AM Philippe Blouin < philippe.blouin@inlibro.com> wrote:
I only dared to write that affirmatively because I was just in the process of updating another machine (from 9.9 to 9.13), and it was installing MariaDB 10.4.13.
It was right in front of me, on my screen.
But after your answers I dug a bit and yeah, the source.list.d specifies 10.4 for mariadb.
So my initial answer is mostly wrong. The only correct part is that we do have multiple production systems running 10.4 without glitch, but that is not proof of anything.
My apologies for the misleading answer.
Philippe Blouin, Directeur de la technologie
Tél. : (833) 465-4276, poste 230 philippe.blouin@inLibro.com <mailto:philippe.blouin@inLibro.com>
inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com> On 2020-07-27 10:56 a.m., Michael Kuhn wrote:
Hi Philippe
Am 27.07.20 um 16:32 schrieb Philippe Blouin:
10.4 is the default mariadb version you get with an up-to-date Debian 9 or Ubuntu 18.
It works.
I just updated another Installation of Debian GNU/Linux 9.12 to 9.13. But it only updated to MariaDB 10.1.45, not 10.4.x
So my question is still open, if Koha 18.11 on Debian 9 will work with Koha 10.3
Best wishes: Michael
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
On 20-07-27 17:22, Philippe Blouin wrote:
So my initial answer is mostly wrong. The only correct part is that we do have multiple production systems running 10.4 without glitch, but that is not proof of anything.
That is actually very important to maybe start advertising a 10.4 support as experimental (at least) depending on the number of positive feedbacks. Which version of Koha are you using with MariaDB 10.4? Cheers, -- Victor Grousset/tuxayo
participants (7)
-
Christian McDonald -
Cindy Murdock Ames -
Isabel Pineda -
Jonathan Druart -
Michael Kuhn -
Philippe Blouin -
Victor Grousset/tuxayo