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.blo...@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.blo...@inlibro.com <mailto:philippe.blo...@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
