[Davical-general] Problems retrieving a calendar .ics

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[Davical-general] Problems retrieving a calendar .ics

Johan Vromans
Hi,

Recently I moved my davical and dabase servers to other hardware. Since
that time I have a problem retrieving one of my calendar .ics files.

The client retrieves
http://jv:******@davical.squirrel.nl/caldav.php/jv/default.ics and gets a
500 Internal Server Error

I have several calendars, and only this calendar gives problems.
I must admit it is by far the largest of them all.

The only information I can get from the httpd server (error) log is:

[Mon Aug 31 03:44:08.557558 2015] [:error] [pid 12394] [client 192.168.1.251:56492] davical: LOG: GET: Query: Possible slow query: SQ in '/var/www/davical/inc/caldav-GET-functions.php' on line 64

[Mon Aug 31 03:44:08.557912 2015] [:error] [pid 12394] [client
192.168.1.251:56492] davical: LOG: GET: Query: SQ: Took: 0.881866 for
SELECT caldav_data, class, caldav_type, calendar_item.user_no, logged_user
FROM collection INNER JOIN caldav_data USING(collection_id) INNER JOIN
calendar_item USING ( dav_id ) WHERE caldav_data.collection_id = :collectio

[Mon Aug 31 03:44:08.558068 2015] [:error] [pid 12394] [client 192.168.1.251:56492] davical: LOG: GET: Query: SQ: n_id

The operation seems to time out after 30 seconds.

Is there some timeout setting in DAViCal that controls this?

-- Johan

------------------------------------------------------------------------------
_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general
Reply | Threaded
Open this post in threaded view
|

Re: Problems retrieving a calendar .ics

Vincent Van Houtte
Johan Vromans schreef op 2015-08-31 08:22:

[SNIP]

> The client retrieves
> http://jv:******@davical.squirrel.nl/caldav.php/jv/default.ics and gets
> a
> 500 Internal Server Error
>
> I have several calendars, and only this calendar gives problems.
> I must admit it is by far the largest of them all.
>
> The only information I can get from the httpd server (error) log is:

[SNIP]

> The operation seems to time out after 30 seconds.
>
> Is there some timeout setting in DAViCal that controls this?

No, I don't think so - but both PHP and your webserver implement timeout
values. 30s is the default for Apache (IIRC), so you might try and
change that (it can be changed in your VirtualHost declaration, so you
don't need to alter any DAViCal files).

The first answer tells you more:
http://stackoverflow.com/questions/9629566/how-to-increase-apache-timeout-directive-in-htaccess

Kr,
Vincent
--
Vincent Van Houtte
Advocaat
Advocatenkantoor Suy, Van Baeveghem & Van Houtte
Brusselsestraat 108
9200 Dendermonde
T 052 52 06 05
T 052 77 90 05
F 052 52 06 46
W http://synergylaw.be

------------------------------------------------------------------------------
_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general
Reply | Threaded
Open this post in threaded view
|

Re: Problems retrieving a calendar .ics

Ján Máté-2
In reply to this post by Johan Vromans
Hi Johan,

you must tune up your PHP configuration (/etc/php5/apache2/php.ini), at least the
following parameters:

max_execution_time
memory_limit
date.timezone

also check your PostgreSQL configuration (/etc/postgresql/9.4/main/postgresql.conf),
at least the following parameter (you must reserve enough connections for all
clients /see you Apache config for you current web server limits/):

max_connections


JM


On 31 Aug 2015, at 08:22, Johan Vromans <[hidden email]> wrote:

Hi,

Recently I moved my davical and dabase servers to other hardware. Since
that time I have a problem retrieving one of my calendar .ics files.

The client retrieves
http://jv:******@davical.squirrel.nl/caldav.php/jv/default.ics and gets a
500 Internal Server Error

I have several calendars, and only this calendar gives problems.
I must admit it is by far the largest of them all.

The only information I can get from the httpd server (error) log is:

[Mon Aug 31 03:44:08.557558 2015] [:error] [pid 12394] [client 192.168.1.251:56492] davical: LOG: GET: Query: Possible slow query: SQ in '/var/www/davical/inc/caldav-GET-functions.php' on line 64

[Mon Aug 31 03:44:08.557912 2015] [:error] [pid 12394] [client
192.168.1.251:56492] davical: LOG: GET: Query: SQ: Took: 0.881866 for
SELECT caldav_data, class, caldav_type, calendar_item.user_no, logged_user
FROM collection INNER JOIN caldav_data USING(collection_id) INNER JOIN
calendar_item USING ( dav_id ) WHERE caldav_data.collection_id = :collectio

[Mon Aug 31 03:44:08.558068 2015] [:error] [pid 12394] [client 192.168.1.251:56492] davical: LOG: GET: Query: SQ: n_id

The operation seems to time out after 30 seconds.

Is there some timeout setting in DAViCal that controls this?

-- Johan

------------------------------------------------------------------------------
_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general


------------------------------------------------------------------------------

_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general

smime.p7s (5K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Problems retrieving a calendar .ics

Johan Vromans
In reply to this post by Vincent Van Houtte
On Mon, 31 Aug 2015 10:10:46 +0200
Vincent Van Houtte <[hidden email]> wrote:

> No, I don't think so - but both PHP and your webserver implement timeout
> values. 30s is the default for Apache (IIRC), so you might try and
> change that (it can be changed in your VirtualHost declaration, so you
> don't need to alter any DAViCal files).

Thanks for the suggestion. Changing the time-out in Apache doesn't solve
the problem.

See also my reply to Ján.

-- Johan

------------------------------------------------------------------------------
_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general
Reply | Threaded
Open this post in threaded view
|

Re: Problems retrieving a calendar .ics

Johan Vromans
In reply to this post by Ján Máté-2
On Mon, 31 Aug 2015 10:17:39 +0200
Ján Máté <[hidden email]> wrote:

> you must tune up your PHP configuration (/etc/php5/apache2/php.ini), at
> least the following parameters:
>
> max_execution_time

Incrementing this value solved the problem.
Retrieving this particular calender appears to take 105 seconds.

Thanks,
        Johan

------------------------------------------------------------------------------
_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general