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