[Koha] Database upgrade problems from KOHA 19.05 to KOHA 21.11

[Mason James]

hi Harald

try the following commands...

$ sudo /etc/init.d/memcached restart
$ sudo koha-upgrade-schema myinstance

if it fails, it should show some errors


On 31/03/22 11:15 pm, Harald Schaefer wrote:
> Dear all,
>
> now I am promoted from a plain KOHA user to the system administrator of the computer hosting a KOHA installation of a railway museum in Germany.
>
> My first task was to upgrade the system from Ubuntu 16.04 to 20.04 and upgrading the KOHA system. I have tried this first twice on some local copies. In the test runs the database upgrade works fine.
>
> In the update run of the production system it stops at this point:
>
> Upgrade to 20.12.00.049  [19:01:13]: Bug 28108 - Move action logs 'SERIAL CLAIM' and 'ACQUISITION CLAIM' to a new 'CLAIMS' module
> Upgrade to 20.12.00.050  [19:01:13]: Bug 28108 - Add new systempreference OpacHiddenItemsHidesRecord
> Upgrade to 21.05.00.000  [19:01:13]: Koha 21.05.00 release
>
> Log started: 2022-03-29  19:04:34 # some other program
>
> In thetest runs it continues
>
> Upgrade to 21.05.00.000  [17:49:33]: Koha 21.05.00 release
> Upgrade to 21.06.00.000  [17:49:33]: Increase DBRev for 21.06
>         Run, rabbit run. 
>        Dig that hole, forget the sun,
>        And when at last the work is done
>        Don't sit down it's time to dig another one.
>
> Is there any way to continue the database upgrade? I have other applications running on the system and I do not want to start the complete upgrade process again.
>
> It seems that the not executed scripts are in /usr/share/koha/intranet/cgi-bin/installer/data/mysql/db_revs
>
> Basically the upgraded KOHA is running.
>
> Best regards Harald