Mailing List Archive

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