[Koha] Koha 20.05, Ubuntu 18.04 and MariaDB

[Jonathan Druart]

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 at 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 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
> >
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha