Error during import from sunbird-1.0pre-b2 / davical 0.9.8

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Error during import from sunbird-1.0pre-b2 / davical 0.9.8

Bruno Friedmann-2
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

------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
rscds-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/rscds-general
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [DAViCal-general] Error during import from sunbird-1.0pre-b2 / davical 0.9.8

Bruno Friedmann-2
One precision, I've forced in the admin interface the fact that this schedule have
"Europe/Zurich" as TimeZone.

The bad things is you can believe the import success, as after a restart sunbird show you events.
but inside the database I've 827 events, inside the ics file 877.


--

     Bruno Friedmann


------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
rscds-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/rscds-general
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [DAViCal-general] Error during import from sunbird-1.0pre-b2 / davical 0.9.8

Andrew McMillan
On Tue, 2010-01-26 at 07:57 +0100, Bruno Friedmann wrote:
> One precision, I've forced in the admin interface the fact that this schedule have
> "Europe/Zurich" as TimeZone.
>
> The bad things is you can believe the import success, as after a restart sunbird show you events.
> but inside the database I've 827 events, inside the ics file 877.

That may not be wrong, depending on how you count events.  An individual
'event' may have several 'VEVENT' in it, due to meeting instance
modifications.

Cheers,
                                        Andrew.

------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com                            +64(272)DEBIAN
       You will be recognized and honored as a community leader.
------------------------------------------------------------------------


------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
rscds-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/rscds-general

signature.asc (205 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [DAViCal-general] Error during import from sunbird-1.0pre-b2 / davical 0.9.8

Bruno Friedmann-2
On 01/26/2010 12:41 PM, Andrew McMillan wrote:

> On Tue, 2010-01-26 at 07:57 +0100, Bruno Friedmann wrote:
>> One precision, I've forced in the admin interface the fact that this schedule have
>> "Europe/Zurich" as TimeZone.
>>
>> The bad things is you can believe the import success, as after a restart sunbird show you events.
>> but inside the database I've 827 events, inside the ics file 877.
>
> That may not be wrong, depending on how you count events.  An individual
> 'event' may have several 'VEVENT' in it, due to meeting instance
> modifications.
>
> Cheers,
> Andrew.
>
Oh thanks for the precision, I'have counted the number of line contanining a SUMMARY: from the ics file.
and compared it to a select count(*) from caldendar_item where user_no = ...


--

     Bruno Friedmann


------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
rscds-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/rscds-general
Loading...