[Koha] Koha 20.05, Ubuntu 18.04 and MariaDB

[Cindy Murdock Ames]

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 at 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 at inLibro.com <mailto:philippe.blouin at 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 at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>