[horde] db schema update internal server error

[Michael J Rubinsky]

Quoting Anton Köstlbacher <horde3 at dingsbums.org>:

> Am 06.12.2016 um 13:59 schrieb Michael J Rubinsky:
>>
>> Quoting Anton Köstlbacher <horde3 at dingsbums.org>:
>>
>>> Am 21.11.2016 um 14:04 schrieb Jan Schneider:
>>>>
>>>> Zitat von Anton Köstlbacher <horde3 at dingsbums.org>:
>>>>
>>>>> Hi everybody,
>>>>>
>>>>> uptodate Horde Webmail 5.2.16. Tried to update DB-schema for
>>>>> Horde_Service_Weather web based using admin/config/
>>>>>
>>>>> Produces internal server error on Debian 7.11, PHP version:
>>>>> 5.4.45-0+deb7u5, Apache version: 2.2.22-13+deb7u7 running php via
>>>>> mod_fcgi.
>>>>>
>>>>> Anyone has the same issues? Any hints? Thanks.
>>>>>
>>>>> Regards,
>>>>> Anton
>>>>
>>>> See the logs
>>>>
>>> Hi Jan,
>>>
>>> the logs show timeout of the fcgi-process after 10 Minutes
>>>
>>> mod_fcgid: read data timeout in 600 seconds, referer:
>>> https://www.domian.tld/webmail/admin/config/
>>>
>>> [Tue Dec 06 13:26:23 2016] [error] [client 89.15.xxx.xxx] Premature
>>> end of script headers: index.php, referer:
>>> https://www.domain.tld/webmail/admin/config/
>>>
>>> Any ideas on this?
>>
>>
>> This script can take a good bit of time. If you have a higher timeout on
>> cli scripts you can run the horde-db-migrate script directly.
>
> It now already takes over two hours, never encountered something  
> like this with horde db upgrades on this machine.


The migration adds upwards of 40k rows into a table. I've sped it up a  
little bit locally, and it runs in less than a minute on my  
development box which uses an SSD for storage, but it still takes  
quite a bit of time on my machine that has the database on a   
traditional HDD.

Any ideas for speeding it up are welcome.

If it becomes a big issue, we could investigate making it a standalone  
script that could optionally be run if the install is to support  
METAR/TAF weather data.


>
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org



-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2007 bytes
Desc: S/MIME Signature
URL: <https://lists.horde.org/archives/horde/attachments/20161206/7db0432f/attachment.bin>