[Bug 8437] Large database backups and large exports from export.pl fail under plack
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8437 --- Comment #45 from David Cook <dcook@prosentient.com.au> --- (In reply to David Cook from comment #44)
(In reply to Nick Clemens from comment #30)
Created attachment 109632 [details] [review] [review] Bug 8437: Exclude export.pl from plack
When attempting to download large files from Koha plack can timeout
Excluding the script from plack is a simple fix until we have a more permanent fix for this issue.
To test: 1 - Try to export your entire DB from Tools->Export 2 - If big enough, it fails 3 - Apply patch, copy changes to /etc/koha/apache-shared-intranet-plack.conf 4 - Restart all the things 5 - Repeat export, it succeeds
My test plan: 0. Using koha-testing-docker 1. cp debian/templates/apache-shared-intranet-plack.conf /etc/koha/apache-shared-intranet-plack.conf 2. enable "backup_db_via_tools" in /etc/koha/sites/kohadev/koha-conf.xml 3. echo 'flush_all' | nc -q 1 memcached 11211 4. service apache2 restart 5. koha-plack --restart kohadev 6. Go to http://localhost:8081/cgi-bin/koha/tools/export.pl 7. Note "Unfortunately, no backups are available."
So that's not going to work... but I have another idea.
My test plan: 0. Using koha-testing-docker 1. cp debian/templates/apache-shared-intranet-plack.conf /etc/koha/apache-shared-intranet-plack.conf 2. Point koha-testing-docker at a database with a large number of biblios (e.g. 40,000 biblios) 3. echo 'flush_all' | nc -q 1 memcached 11211 4. restart_all 5. Go to http://localhost:8081/cgi-bin/koha/tools/export.pl 6. Click "Don't export items" 7. Click "Export bibliographic records" 8. Note after about 5 seconds that a download for koha.mrc starts. Perfect. Cheers, Nick. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org