[Koha] Batch check outs timing out after upgrade and migration

[Katrin Fischer]

Hi Matthew,

is there anything on the "About Koha" page that might give a clue?

* Is Memcached running?
* Is Plack configured and running?
* Is there any error or warning displayed on the System information tab?

Hope this helps,

Katrin

On 10.09.21 06:03, Matthew Lindfield Seager wrote:
> Hi All,
>
> I'm a Koha newbie so I hope this is the appropriate forum for this
> question, please let me know if not!
>
> I'm the ICT Manager in a small school in Phnom Penh that had a working Koha
> installation. One of our physical servers died and, rather than replace it
> to get back up to full redundancy, we decided to move our on-prem servers
> to an IaaS provider (Linode).
>
> In the process of restoring Koha onto the new server I discovered we were
> running Koha 20.05 on the old server and 21.05 on the new server. I then
> made the fateful mistake of proceeding with both changes at once (despite
> knowing better 😔). I upgraded the old server to 21.05 and then backed up
> and restored onto the new server (both Ubuntu 20.04 LTS). I also added TLS
> using Let's Encrypt at the same time.
>
> It all seemed to go smoothly but we're now experiencing slow performance
> when checking out and looking up patrons and we're getting gateway timeouts
> when we try to use Batch Check Out.
>
> Does anyone have any tips on how to troubleshoot this? So far I've:
>
>     - checked specs (new server is a "dedicated" 4GB VM with specs
>     equivalent to or better than the old server)
>     - tried to find any configuration differences between the old server and
>     the new server
>     - looked through the wiki pages on performance
>     <https://wiki.koha-community.org/wiki/Performance>  and tuning
>     <https://wiki.koha-community.org/wiki/Koha_Tuning_Guide>  to see if
>     there's anything we'd done on the old server but not on the new
>
> In the process I discovered that the old server was running on
> MariaDB 10.3.31 whereas I installed MySQL 8.0.26 on the new server. Could
> that be the source of all our issues or is that a red herring?
>
> To rule out MariaDB as the issue I've tried backing up the new server and
> restoring it on to an even newer server with MariaDB installed but so far
> I've not been successful in getting Koha running on MariaDB, despite
> successfully running the restore (after adjusting the SQL dump to change
> from MySQL's `utf8mb4_0900_ai_ci` collation to MariaDB's
> `utf8mb4_general_ci `).
>
> Has anyone got any nuggets of wisdom? I fear our next best option might be
> to create a new (MariaDB) server from the original back ups and manually
> re-enter the past 4 days worth of borrowing and returns 😔
>
> Regards,
> Matt
> _______________________________________________
>
> Koha mailing listhttp://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha