Hi
Thanks Fridolin for the link to bug 29728.
All of my tables in our Koha instances "opac" and "libtest2" are
DYNAMIC.
# mysql -e "SELECT table_name,row_format FROM information_schema.tables
WHERE table_schema='koha_opac' and row_format='Dynamic';" mysql
However you picked up that the error was for Koha instance "library".
That was an old instance that had not been updated for some time. The
instances opac and libtest2 upgraded OK. A few nights ago I purged
"library" as it was not needed. (Unfortunately before I learn about
row_format as I could have checked what it was.)
So I think all is OK with our production and test and now I have learnt
a bit about the row_format and how to check that setting. It's default
setting in MariaDB is DYNAMIC.
The version is indeed stored in database to compare with sources.
Excellent. Where is this stored? I had a quick glance through the schema
dump but did not see it. In mine I should see 21.11.01.000 stored or
something like that.
Thanks
Mike
On 2021-12-30 7:03 pm, Fridolin SOMERS wrote:
Hi,
Looks like your database "library" has some issues.
The version is indeed stored in database to compare with sources.
Looks like "library" version is 21.06.00.006, so previous database
upgrade failed also ?
This problem may be described in :
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29728
Best regards,
Le 25/12/2021 à 01:09, Mike Lake a écrit :
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@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
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
