[Koha-bugs] [Bug 8437] Large database backups and large exports from export.pl fail under plack

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8437

--- Comment #45 from David Cook <dcook at 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.