On http:caldav-test.ioda.net
I deleted a full resource collection and try to import from sunbird a new bunch set of events.
During the beginning of the import, sunbird indicate it got an error.
On the server I found this error PUT: Query: QF: ERROR: deadlock detected DETAIL:
Is this due to the fact postgresql is 8.1 ?
[26-Jan-2010 07:37:45] davical: LOG: :==========> method =PUT= =http://caldav-test.ioda.net/caldav.php=
=/black/home/97d239fe-4211-4356-9756-e79d7dda1be0.ics= == =/var/www/caldav-test.ioda.net=
[26-jan-2010 07:37:45] davical: LOG: :***************** Request Header ****************
[26-jan-2010 07:37:45] davical: LOG: :PUT /caldav.php/black/home/97d239fe-4211-4356-9756-e79d7dda1be0.ics
[26-jan-2010 07:37:45] davical: LOG: headers:-->Host: caldav-test.ioda.net
[26-jan-2010 07:37:45] davical: LOG: headers:-->User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr-FR; rv:1.9.1.6pre)
Gecko/20091202 Sunbird/1.0b1
[26-jan-2010 07:37:45] davical: LOG: headers:-->Accept: text/xml
[26-jan-2010 07:37:45] davical: LOG: headers:-->Accept-Language: en-us,en;q=0.5
[26-jan-2010 07:37:45] davical: LOG: headers:-->Accept-Encoding: gzip,deflate
[26-jan-2010 07:37:45] davical: LOG: headers:-->Accept-Charset: utf-8,*;q=0.1
[26-jan-2010 07:37:45] davical: LOG: headers:-->Keep-Alive: 300
[26-jan-2010 07:37:45] davical: LOG: headers:-->Connection: keep-alive
[26-jan-2010 07:37:45] davical: LOG: headers:-->Content-Length: 774
[26-jan-2010 07:37:45] davical: LOG: headers:-->Content-Type: text/calendar; charset=utf-8
[26-jan-2010 07:37:45] davical: LOG: headers:-->If-None-Match: *
[26-jan-2010 07:37:45] davical: LOG: headers:-->Authorization: Basic c3VwZXJtYW46aW9kYTA5
[26-jan-2010 07:37:45] davical: LOG: headers:-->Pragma: no-cache
[26-jan-2010 07:37:45] davical: LOG: headers:-->Cache-Control: no-cache
[26-jan-2010 07:37:45] davical: LOG: :******************** Request ********************
[26-jan-2010 07:37:45] davical: LOG: request:-->BEGIN:VCALENDAR
[26-jan-2010 07:37:45] davical: LOG: request:-->PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN
[26-jan-2010 07:37:45] davical: LOG: request:-->VERSION:2.0
[26-jan-2010 07:37:45] davical: LOG: request:-->BEGIN:VTIMEZONE
[26-jan-2010 07:37:45] davical: LOG: request:-->TZID:Europe/Zurich
[26-jan-2010 07:37:45] davical: LOG: request:-->X-LIC-LOCATION:Europe/Zurich
[26-jan-2010 07:37:45] davical: LOG: request:-->BEGIN:DAYLIGHT
[26-jan-2010 07:37:45] davical: LOG: request:-->TZOFFSETFROM:+0100
[26-jan-2010 07:37:45] davical: LOG: request:-->TZOFFSETTO:+0200
[26-jan-2010 07:37:45] davical: LOG: request:-->TZNAME:CEST
[26-jan-2010 07:37:45] davical: LOG: request:-->DTSTART:19700329T020000
[26-jan-2010 07:37:45] davical: LOG: request:-->RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
[26-jan-2010 07:37:45] davical: LOG: request:-->END:DAYLIGHT
[26-jan-2010 07:37:45] davical: LOG: request:-->BEGIN:STANDARD
[26-jan-2010 07:37:45] davical: LOG: request:-->TZOFFSETFROM:+0200
[26-jan-2010 07:37:45] davical: LOG: request:-->TZOFFSETTO:+0100
[26-jan-2010 07:37:45] davical: LOG: request:-->TZNAME:CET
[26-jan-2010 07:37:45] davical: LOG: request:-->DTSTART:19701025T030000
[26-jan-2010 07:37:45] davical: LOG: request:-->RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
[26-jan-2010 07:37:45] davical: LOG: request:-->END:STANDARD
[26-jan-2010 07:37:45] davical: LOG: request:-->END:VTIMEZONE
[26-jan-2010 07:37:45] davical: LOG: request:-->BEGIN:VEVENT
[26-jan-2010 07:37:45] davical: LOG: request:-->CREATED:20090420T093318Z
[26-jan-2010 07:37:45] davical: LOG: request:-->LAST-MODIFIED:20090420T093347Z
[26-jan-2010 07:37:45] davical: LOG: request:-->DTSTAMP:20090420T093347Z
[26-jan-2010 07:37:45] davical: LOG: request:-->UID:97d239fe-4211-4356-9756-e79d7dda1be0
[26-jan-2010 07:37:45] davical: LOG: request:-->SUMMARY:SjTRnz jTwzsznd
[26-jan-2010 07:37:45] davical: LOG: request:-->DTSTART;TZID=Europe/Zurich:20090423T144500
[26-jan-2010 07:37:45] davical: LOG: request:-->DTEND;TZID=Europe/Zurich:20090423T170000
[26-jan-2010 07:37:45] davical: LOG: request:-->TRANSP:OPAQUE
[26-jan-2010 07:37:45] davical: LOG: request:-->X-MOZ-GENERATION:1
[26-jan-2010 07:37:45] davical: LOG: request:-->END:VEVENT
[26-jan-2010 07:37:45] davical: LOG: request:-->END:VCALENDAR
[26-jan-2010 07:37:45] davical: LOG: request:-->
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: BEGIN; INSERT INTO caldav_data ( user_no, dav_name, dav_etag, caldav_data,
caldav_type, logged_user, created, modified, collection_id ) VALUES( E'1004',
E'/black/home/afe103f0-58a2-4c42-b300-9cf46f879efc.ics', E'f465eeace7f302d6c1eadbc1edc8
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: 2e3b', E'BEGIN:VCALENDAR PRODID:-//Mozilla.org/NONSGML Mozilla Calendar
V1.1//EN VERSION:2.0 BEGIN:VTIMEZONE TZID:Europe/Berlin X-LIC-LOCATION:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100
TZOFFSETTO:+0200 TZNAME:CEST DTSTART:19700329T020
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: 000 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3 END:DAYLIGHT BEGIN:STANDARD
TZOFFSETFROM:+0200 TZOFFSETTO:+0100 TZNAME:CET DTSTART:19701025T030000 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10 END:STANDARD
END:VTIMEZONE BEGIN:VEVENT CREATED:20080911T0
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: 84359Z LAST-MODIFIED:20080911T084439Z DTSTAMP:20080911T084439Z
UID:afe103f0-58a2-4c42-b300-9cf46f879efc SUMMARY:SzRlzr LRxQ????lz Lzs. Twstwn Kwrsztt RS/dw
DTSTART;TZID=Europe/Berlin:20080917T140000 DTEND;TZID=Europe/Berlin:20080917T150000
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: TRANSP:OPAQUE X-MOZ-GENERATION:1 END:VEVENT END:VCALENDAR ', E'VEVENT',
E'1012', current_timestamp, current_timestamp, E'1' )
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: ERROR: deadlock detected DETAIL: Process 15438 waits for ShareLock on
transaction 3727660; blocked by process 15440. Process 15440 waits for ExclusiveLock on tuple (32,19) of relation 43561 of
database 43460; blocked by process 15438. CONTE
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: XT: SQL statement "UPDATE collection SET modified = current_timestamp,
dav_etag = md5( $1 ) WHERE collection_id = $2 " PL/pgSQL function "caldav_data_modified" line 15 at SQL statement
[26-jan-2010 07:37:46] davical: LOG: :***************** Response Header ****************
--
Bruno Friedmann
I deleted a full resource collection and try to import from sunbird a new bunch set of events.
During the beginning of the import, sunbird indicate it got an error.
On the server I found this error PUT: Query: QF: ERROR: deadlock detected DETAIL:
Is this due to the fact postgresql is 8.1 ?
[26-Jan-2010 07:37:45] davical: LOG: :==========> method =PUT= =http://caldav-test.ioda.net/caldav.php=
=/black/home/97d239fe-4211-4356-9756-e79d7dda1be0.ics= == =/var/www/caldav-test.ioda.net=
[26-jan-2010 07:37:45] davical: LOG: :***************** Request Header ****************
[26-jan-2010 07:37:45] davical: LOG: :PUT /caldav.php/black/home/97d239fe-4211-4356-9756-e79d7dda1be0.ics
[26-jan-2010 07:37:45] davical: LOG: headers:-->Host: caldav-test.ioda.net
[26-jan-2010 07:37:45] davical: LOG: headers:-->User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr-FR; rv:1.9.1.6pre)
Gecko/20091202 Sunbird/1.0b1
[26-jan-2010 07:37:45] davical: LOG: headers:-->Accept: text/xml
[26-jan-2010 07:37:45] davical: LOG: headers:-->Accept-Language: en-us,en;q=0.5
[26-jan-2010 07:37:45] davical: LOG: headers:-->Accept-Encoding: gzip,deflate
[26-jan-2010 07:37:45] davical: LOG: headers:-->Accept-Charset: utf-8,*;q=0.1
[26-jan-2010 07:37:45] davical: LOG: headers:-->Keep-Alive: 300
[26-jan-2010 07:37:45] davical: LOG: headers:-->Connection: keep-alive
[26-jan-2010 07:37:45] davical: LOG: headers:-->Content-Length: 774
[26-jan-2010 07:37:45] davical: LOG: headers:-->Content-Type: text/calendar; charset=utf-8
[26-jan-2010 07:37:45] davical: LOG: headers:-->If-None-Match: *
[26-jan-2010 07:37:45] davical: LOG: headers:-->Authorization: Basic c3VwZXJtYW46aW9kYTA5
[26-jan-2010 07:37:45] davical: LOG: headers:-->Pragma: no-cache
[26-jan-2010 07:37:45] davical: LOG: headers:-->Cache-Control: no-cache
[26-jan-2010 07:37:45] davical: LOG: :******************** Request ********************
[26-jan-2010 07:37:45] davical: LOG: request:-->BEGIN:VCALENDAR
[26-jan-2010 07:37:45] davical: LOG: request:-->PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN
[26-jan-2010 07:37:45] davical: LOG: request:-->VERSION:2.0
[26-jan-2010 07:37:45] davical: LOG: request:-->BEGIN:VTIMEZONE
[26-jan-2010 07:37:45] davical: LOG: request:-->TZID:Europe/Zurich
[26-jan-2010 07:37:45] davical: LOG: request:-->X-LIC-LOCATION:Europe/Zurich
[26-jan-2010 07:37:45] davical: LOG: request:-->BEGIN:DAYLIGHT
[26-jan-2010 07:37:45] davical: LOG: request:-->TZOFFSETFROM:+0100
[26-jan-2010 07:37:45] davical: LOG: request:-->TZOFFSETTO:+0200
[26-jan-2010 07:37:45] davical: LOG: request:-->TZNAME:CEST
[26-jan-2010 07:37:45] davical: LOG: request:-->DTSTART:19700329T020000
[26-jan-2010 07:37:45] davical: LOG: request:-->RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
[26-jan-2010 07:37:45] davical: LOG: request:-->END:DAYLIGHT
[26-jan-2010 07:37:45] davical: LOG: request:-->BEGIN:STANDARD
[26-jan-2010 07:37:45] davical: LOG: request:-->TZOFFSETFROM:+0200
[26-jan-2010 07:37:45] davical: LOG: request:-->TZOFFSETTO:+0100
[26-jan-2010 07:37:45] davical: LOG: request:-->TZNAME:CET
[26-jan-2010 07:37:45] davical: LOG: request:-->DTSTART:19701025T030000
[26-jan-2010 07:37:45] davical: LOG: request:-->RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
[26-jan-2010 07:37:45] davical: LOG: request:-->END:STANDARD
[26-jan-2010 07:37:45] davical: LOG: request:-->END:VTIMEZONE
[26-jan-2010 07:37:45] davical: LOG: request:-->BEGIN:VEVENT
[26-jan-2010 07:37:45] davical: LOG: request:-->CREATED:20090420T093318Z
[26-jan-2010 07:37:45] davical: LOG: request:-->LAST-MODIFIED:20090420T093347Z
[26-jan-2010 07:37:45] davical: LOG: request:-->DTSTAMP:20090420T093347Z
[26-jan-2010 07:37:45] davical: LOG: request:-->UID:97d239fe-4211-4356-9756-e79d7dda1be0
[26-jan-2010 07:37:45] davical: LOG: request:-->SUMMARY:SjTRnz jTwzsznd
[26-jan-2010 07:37:45] davical: LOG: request:-->DTSTART;TZID=Europe/Zurich:20090423T144500
[26-jan-2010 07:37:45] davical: LOG: request:-->DTEND;TZID=Europe/Zurich:20090423T170000
[26-jan-2010 07:37:45] davical: LOG: request:-->TRANSP:OPAQUE
[26-jan-2010 07:37:45] davical: LOG: request:-->X-MOZ-GENERATION:1
[26-jan-2010 07:37:45] davical: LOG: request:-->END:VEVENT
[26-jan-2010 07:37:45] davical: LOG: request:-->END:VCALENDAR
[26-jan-2010 07:37:45] davical: LOG: request:-->
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: BEGIN; INSERT INTO caldav_data ( user_no, dav_name, dav_etag, caldav_data,
caldav_type, logged_user, created, modified, collection_id ) VALUES( E'1004',
E'/black/home/afe103f0-58a2-4c42-b300-9cf46f879efc.ics', E'f465eeace7f302d6c1eadbc1edc8
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: 2e3b', E'BEGIN:VCALENDAR PRODID:-//Mozilla.org/NONSGML Mozilla Calendar
V1.1//EN VERSION:2.0 BEGIN:VTIMEZONE TZID:Europe/Berlin X-LIC-LOCATION:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100
TZOFFSETTO:+0200 TZNAME:CEST DTSTART:19700329T020
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: 000 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3 END:DAYLIGHT BEGIN:STANDARD
TZOFFSETFROM:+0200 TZOFFSETTO:+0100 TZNAME:CET DTSTART:19701025T030000 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10 END:STANDARD
END:VTIMEZONE BEGIN:VEVENT CREATED:20080911T0
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: 84359Z LAST-MODIFIED:20080911T084439Z DTSTAMP:20080911T084439Z
UID:afe103f0-58a2-4c42-b300-9cf46f879efc SUMMARY:SzRlzr LRxQ????lz Lzs. Twstwn Kwrsztt RS/dw
DTSTART;TZID=Europe/Berlin:20080917T140000 DTEND;TZID=Europe/Berlin:20080917T150000
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: TRANSP:OPAQUE X-MOZ-GENERATION:1 END:VEVENT END:VCALENDAR ', E'VEVENT',
E'1012', current_timestamp, current_timestamp, E'1' )
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: ERROR: deadlock detected DETAIL: Process 15438 waits for ShareLock on
transaction 3727660; blocked by process 15440. Process 15440 waits for ExclusiveLock on tuple (32,19) of relation 43561 of
database 43460; blocked by process 15438. CONTE
[26-jan-2010 07:37:46] davical: LOG: PUT: Query: QF: XT: SQL statement "UPDATE collection SET modified = current_timestamp,
dav_etag = md5( $1 ) WHERE collection_id = $2 " PL/pgSQL function "caldav_data_modified" line 15 at SQL statement
[26-jan-2010 07:37:46] davical: LOG: :***************** Response Header ****************
--
Bruno Friedmann