[Koha] Error DBI Exception, maximum row size is 8126 during upgrade to Koha 21.11.01

Mike Lake mikel at speleonics.com.au
Sun Dec 26 00:09:40 NZDT 2021


Hi all

Just upgraded tonight koha-common 21.11.01-1 to 21.11.00-1
This is on a Debian 10.11 (deb http://debian.koha-community.org/koha 
stable main). I got this error:

ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too 
large. The maximum row size for the used table type, not counting BLOBs, 
is 8126. You have to change some columns to TEXT or BLOBs at 
/usr/share/koha/lib/C4/Installer.pm line 738

That's a bit worrying. Though our Koha instance seems to be OK.

Full transcript of the upgrade is below.

Also why does the upgrade at one stage say "Upgrade to 21.06.00.007" 
when its upgrading from 21.11.01-1 over 21.11.00-1 ? Has the database 
got its own version?

Full transcript of the upgrade"

koha-common
Unpacking koha-common (21.11.01-1) over (21.11.00-1) ...
Setting up koha-common (21.11.01-1) ...
Upgrading database schema for library
Upgrade to 21.06.00.007  [21:45:46]: Bug 11879 - Add a new field to 
patron record: main contact method
ERROR - {UNKNOWN}: DBI Exception: 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 at 
/usr/share/koha/lib/C4/Installer.pm line 738
Upgrading database schema for libtest2
Upgrade to 21.11.00.001  [21:45:49]: Bug 29586 - Add Hold Reminder 
messaging preference if missing
Upgrade to 21.11.01.000  [21:45:49]: Koha 21.11.01 release
Upgrading database schema for opac
Upgrade to 21.11.00.001  [21:45:51]: Bug 29586 - Add Hold Reminder 
messaging preference if missing
Upgrade to 21.11.01.000  [21:45:51]: Koha 21.11.01 release
The following plugins have been configured:
   rabbitmq_stomp
Applying plugin configuration to rabbit at asf3...
Plugin configuration unchanged.
Failed to enable unit: Unit 
/run/systemd/generator.late/koha-common.service is transient or 
generated.
Processing triggers for man-db (2.8.5-2) ...
Processing triggers for systemd (241-7~deb10u8) ...

-- 
Mike


More information about the Koha mailing list