Advanced
Mailing List Archive

Mailing List Archive

  1. Home >
  2. DAViCal>
  3. General
Problems retrieving a calendar .ics
jvromans at squirrel
Aug 30, 2015, 11:22 PM
Post #1 of 5 (1650 views)
Permalink
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
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general
Re: Problems retrieving a calendar .ics [ In reply to ]
vvh at synergylaw
Aug 31, 2015, 1:10 AM
Post #2 of 5 (1637 views)
Permalink
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
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general
Re: Problems retrieving a calendar .ics [ In reply to ]
jan.mate at inf-it
Aug 31, 2015, 1:17 AM
Post #3 of 5 (1643 views)
Permalink
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 <jvromans@squirrel.nl> 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
> Davical-general@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/davical-general

Attached Files:

Re: Problems retrieving a calendar .ics [ In reply to ]
jvromans at squirrel
Aug 31, 2015, 5:21 AM
Post #4 of 5 (1631 views)
Permalink
On Mon, 31 Aug 2015 10:10:46 +0200
Vincent Van Houtte <vvh@synergylaw.be> 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
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general
Re: Problems retrieving a calendar .ics [ In reply to ]
jvromans at squirrel
Aug 31, 2015, 5:53 AM
Post #5 of 5 (1630 views)
Permalink
On Mon, 31 Aug 2015 10:17:39 +0200
Ján Máté <jan.mate@inf-it.com> 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
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general

©2024 GT.net. A Gossamer Threads company.
5th Floor, 455 Granville St., Vancouver, BC V6C 1T1, Canada | Legal