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

[Katrin Fischer]

Hi,

I am not sure why it stopped if the installed version is 21.11.03. Maybe
someone else has an idea?

Katrin

On 31.03.22 20:48, Harald Schaefer wrote:
> Thanks for the answer.
>
> I omitted same parts of the test run, it ends with
>
> Upgrade to 21.11.02.004  [17:49:53]: Bug 29943 - Fix typo in
> NOTIFY_MANAGER notice
> Upgrade to 21.11.03.000  [17:49:53]: Koha 21.11.03 release
>
> KOHA 21.11.03 is the release I want to upgrade to
>
> My question is:
>
> Is it save to run
>
>     sudo perl
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
>
> to add the missing database steps from 21.05 to 21.11.
>
> Regards Harald
>
> Am 31.03.22 um 20:34 schrieb Katrin Fischer:
>> Hi,
>>
>> actually the test run is the one that looks a little odd:
>>
>> 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 the first database change after the release of 21.05 and it marks the
>> begin of the development cycle.
>>
>> Upgrade to 21.05.00.000  [19:01:13]: Koha 21.05.00 release
>>
>> Is correct as the last update step for 21.05, a stable release.
>>
>> Hope this helps
>>
>> Katrin
>>
>> I am not sure what might have happened, maybe a difference in how
>>
>> On 31.03.22 12:15, 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.
>>>
>>> The rabbitmq log show these entries for the time
>>>
>>> 2022-03-29 19:00:36.018 [info] <0.595.0> started TCP listener on
>>> [::]:5672
>>> 2022-03-29 19:00:36.018 [info] <0.266.0> Running boot step
>>> cluster_name defined by app rabbit
>>> 2022-03-29 19:00:36.018 [info] <0.266.0> Running boot step
>>> direct_client defined by app rabbit
>>> 2022-03-29 19:00:36.158 [notice] <0.103.0> Changed loghwm of
>>> /var/log/rabbitmq/rabbit at tools.log to 50
>>> 2022-03-29 19:00:36.496 [info] <0.8.0> Server startup complete; 0
>>> plugins started.
>>> 2022-03-29 19:03:25.195 [info] <0.777.0> rabbit_stomp: default user
>>> 'guest' enabled
>>> 2022-03-29 19:03:25.281 [info] <0.793.0> started STOMP TCP listener on
>>> [::]:61613
>>> 2022-03-29 19:03:25.329 [info] <0.765.0> Plugins changed; enabled
>>> [amqp_client,rabbitmq_stomp]
>>> 2022-03-29 19:03:27.678 [info] <0.800.0> RabbitMQ is asked to stop...
>>>
>>> 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
>>>
>>>
>>>
>>> _______________________________________________
>>>
>>> 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
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha