[horde] db schema update internal server error

[Anton Köstlbacher]

Am 06.12.2016 um 19:05 schrieb 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.

I now ran it directly, as it did not finish at all using the web 
interface. On cli it took about 25min.

[  INFO  ] Current Horde_Service_Weather schema version: 1
Migrating to HordeServiceWeatherAirportsChange (2)
== 2 HordeServiceWeatherAirportsChange: migrating 
=============================
-- tables()
    -> 0.0010s
-- dropTable('horde_metar_airports')
    -> 0.1367s
-- beginDbTransaction()
    -> 0.0002s
-- createTable('horde_metar_airports', array('autoincrementKey' => array (
   0 => 'id',
)))
    -> 0.0166s
== 2 HordeServiceWeatherAirportsChange: Added 40033 airport identifiers 
to the database.
-- commitDbTransaction()
    -> 0.0001s
== 2 HordeServiceWeatherAirportsChange: migrated (1550.6511s) 
=================