Re: ERROR [syncserver] Could not set items

[Ladar Levison]

>On 25/01/12 18:27, Toby Elliott wrote:
>> Hi, Claudius,
>>
>> Are you using a special client? The line below makes me think you're
running into https://bugzilla.mozilla.org/show_bug.cgi?id=691409 , but I
didn't think the normal Mozilla client could trigger that.
>
>I'm mostly using www-client/firefox-9.0 from gentoo portage, but I get
>the same error using firefox 9.0.1 on windows 7.
>
>I did some testing and think there is a problem with my firefox profile.
>
>If I use a fresh profile and synchronize with my server to get my data
>back, everything works as expected, no errors.
>
>Is there a way to analyze a profile to get the root cause of this error?
>I think the easy way of solving this, is to unlink all my devices and
>start over with fresh profiles.
>Is any data deleted if there is no device linked to a sync account?
>
>--
>Claudius
>- hide quoted text -
>
>> Regards,
>> Toby Elliott
>>
>> On Jan 20, 2012, at 2:08 PM, Claudius Herder wrote:
>>
>>> Hi all,
>>>
>>> I get lots of following errors:
>>>
>>> 2012-01-20 22:57:23,697 ERROR [syncserver] Could not set items
>>> 2012-01-20 22:57:23,698 ERROR [syncserver] (IntegrityError) duplicate
>>> key value violates unique constraint "wbo_pkey"
>>> DETAIL: Key (id, username, collection)=(kwyOey4DTXicKPIN, 1, 3)
already
>>> exists.
>>> 'INSERT INTO wbo (id, username, collection, modified, payload,
>>> payload_size, ttl) VALUES (%(id)s, %(username)s, %(collection)s,
>>> %(modified)s, %(payload)s, %(payload_size)s, %(ttl)s)' {'username': 1,
>>> 'payload_size': 211, 'modified': 132709664292, 'collection': 3, 'id':
>>> 'kwyOey4DTXicKPIN', 'ttl': 1332280643, 'payload':
>>>
>'{"ciphertext":"BJmsZ09Aj2x2qRmEEXWi9ETeMLirV9fQakY7xCeQRgrdKJ7kV6mwi3ljldslOlmrqNzxT9TPZimIizIYKMI6pw==","IV":"CdBBF+G5uwTziGHUSR8O5Q==","hmac":"71b8f50a07b4cb2a9d3d7894d7d117eda921104789c1537f7412bad5a408ca23"}'}
>>>
>>> is this a client or server problem? and any ideas/hints how to debug or
>>> fix it?
>>>
>>> --
>>> Claudius

I'm seeing this error as well. I believe its because both computers in
the sync group have identical URLs in their history. The records only
differ in time. That's causing the errors/collision.

_______________________________________________
Services-dev mailing list
Servic...@mozilla.org
https://mail.mozilla.org/listinfo/services-dev