[Koha] Export Data tool fails (only tool that fails)- ver 23.11.06

[Evan Stewart]

Hello,
(I started a similar question on a thread titled "Export page failing to
load and related error". Posting again with additional information and to
bump the message into new views)

*Issue:*
The "Export Data" tool will not load. I go to *More* > *Cataloging* > *Export
catalog data* and the page immediately fails. (server details at the bottom
of the message)

The error message is a standard message: "*Service Unavailable:* The server
is temporarily unable to service your request due to maintenance downtime
or capacity problems. Please try again later."

All other tools in the Koha GUI work. The export is the only one failing.

Does anyone know how to better troubleshoot this issue?

*Troubleshooting Steps Tried:*

   - Upgrade my server to 16GB of RAM. Results: same error
   - With koha-shell, run the command "/usr/share/koha/bin/export_records.pl
   --filename=JVK-manual-export". Results: the shell displays all the records,
   but I cannot find a file that was generated.

*Background:*
My team uses one instance of Koha to build catalogs that will eventually be
sent to remote library locations Africa.  I can access the database
directly and run a count query on the "items" table. It shows we have
*63,426* unique items in the catalog. We have multiple branches to organize
all the items.

The goal is to export the catalog data per branch library and then send the
MARC file to the remote libraries so the librarian can import them into
their local instance of Koha. We've been doing this for a few years, so the
item records continue to grow.

*Koha server details:*
Koha version: 23.11.06.000
Server OS: Debian 11
RAM: 8GB
CPU: 2
Storage: 160 GB
Running on Amazon Lightsail

Sincerely,
Evan Stewart
Africa's Hope, USA