[Koha] Continued koha-common Upgrade Challenges

[Jonathan Druart]

Hello Javier,

The recommended way to install Koha is using the debian packages.

The docker image provided by the community is meant to be used by
developers and our CI (and it is using the debian packages underneath
anyway).

Regards,
Jonathan

Le mer. 28 avr. 2021 à 18:18, Javi Legido <javi at legido.com> a écrit :
>
> Hi there.
>
> Not sure if in your scenario there's the option, but I would strongly
> recommend start using docker instead of installing packages.
>
> If you agree with this approach let me know, I can give you some hints.
>
> Cheers.
>
> Javier
>
> On Wed, 28 Apr 2021 at 17:55, <skaman.tx at gmail.com> wrote:
>
> > Our koha installation is on Debian 10.  I have previously engaged the list
> > for upgrade challenges specifically related to the outcome of the Debian
> > package koha-common upgrade scripts. We are stuck at koha-common version
> > 20.05.xx at this point.  My latest attempt to upgrade to 20.11.04-1
> > resulted in the following three error messages.  Is there any way to
> > manually alter the correct table(s) to fix the database issues? I'm not
> > sure what the "Failed to enable unit" message means.
> >
> > ----------------------------
> > Setting up koha-common (20.11.04-1) ...
> > Installing new version of config file /etc/cron.daily/koha-common ...
> > Installing new version of config file /etc/init.d/koha-common ...
> > Installing new version of config file /etc/koha/SIPconfig.xml ...
> > Installing new version of config file
> > /etc/koha/apache-shared-intranet-plack.conf ...
> > Installing new version of config file
> > /etc/koha/apache-shared-intranet.conf ...
> > Installing new version of config file /etc/koha/apache-shared-opac.conf ...
> > Installing new version of config file /etc/koha/koha-conf-site.xml.in ...
> > Installing new version of config file /etc/koha/log4perl-site.conf.in ...
> > Installing new version of config file /etc/koha/plack.psgi ...
> > Installing new version of config file
> > /etc/koha/zebradb/etc/phrases-icu.xml ...
> > Installing new version of config file
> > /etc/koha/zebradb/etc/word-phrase-utf.chr ...
> > Upgrading database schema for [database]
> > .......
> > Upgrade to 20.06.00.031 done [10:19:38]: Bug 22789 - Add non_priority
> > column on reserves and old_reserves tables
> > 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 `items` ADD COLUMN
> > `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER
> > `new_status`"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/
> > updatedatabase.pl line 22709.
> >
> > 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 `deleteditems` ADD COLUMN
> > `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER
> > new_status`"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/
> > updatedatabase.pl line 22715.
> > ......
> > Failed to enable unit: Unit
> > /run/systemd/generator.late/koha-common.service is transient or generated.
> >
> > ----------------------------
> >
> > NOTE: When I then run "/usr/share/koha/bin/migration_tools/
> > rebuild_zebra.pl -b -a -z" in this post-upgrade state I get the following
> > error for each biblio record:
> >
> >
> > DBD::mysql::st execute failed: Unknown column
> > 'me.exclude_from_local_holds_priority' in 'field list' [for Statement
> > "SELECT `me`.`itemnumber`, `me`.`biblionumber`, `me`.`biblioitemnumber`,
> > `me`.`barcode`, `me`.`dateaccessioned`, `me`.`booksellerid`,
> > `me`.`homebranch`, `me`.`price`, `me`.`replacementprice`,
> > `me`.`replacementpricedate`, `me`.`datelastborrowed`, `me`.`datelastseen`,
> > `me`.`stack`, `me`.`notforloan`, `me`.`damaged`, `me`.`damaged_on`,
> > `me`.`itemlost`, `me`.`itemlost_on`, `me`.`withdrawn`, `me`.`withdrawn_on`,
> > `me`.`itemcallnumber`, `me`.`coded_location_qualifier`, `me`.`issues`,
> > `me`.`renewals`, `me`.`reserves`, `me`.`restricted`, `me`.`itemnotes`,
> > `me`.`itemnotes_nonpublic`, `me`.`holdingbranch`, `me`.`timestamp`,
> > `me`.`location`, `me`.`permanent_location`, `me`.`onloan`,
> > `me`.`cn_source`, `me`.`cn_sort`, `me`.`ccode`, `me`.`materials`,
> > `me`.`uri`, `me`.`itype`, `me`.`more_subfields_xml`, `me`.`enumchron`,
> > `me`.`copynumber`, `me`.`stocknumber`, `me`.`new_status`,
> > `me`.`exclude_from_local_holds_priority` FROM `items` `me` WHERE (
> > `me`.`itemnumber` = ? )" with ParamValues: 0=1] at
> > /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.
> > error retrieving biblio 1 at /usr/share/koha/bin/migration_tools/
> > rebuild_zebra.pl line 686.
> >
> > Any help would be greatly appreciated.  I fear we are getting farther and
> > farther behind on koha-common versions since we cannot seem to get past the
> > database schema upgrade errors.
> >
> > Scott Leafe
> > Scriptel Ministries
> > Houston, Texas
> >
> > _______________________________________________
> >
> > 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