[aerogear-dev] UPS : Errors in Category Insertion

[Lukas Fryc]

+1 exactly what I was thinking about :-)

On Fri, Jan 22, 2016 at 8:53 AM, Matthias Wessendorf <matzew at apache.org>
wrote:

> It would be good if the model/jpa folder has a test case for that :)
>
> On Fri, Jan 22, 2016 at 8:18 AM, Vivek Pandey <vivek.pandey at pinelabs.com>
> wrote:
>
>> Thanks Lukas, I have logged a bug for this issue
>> https://issues.jboss.org/browse/AGPUSH-1568
>>
>>
>>
>> *From:* Lukas Fryc [mailto:lfryc at redhat.com]
>> *Sent:* Thursday, January 21, 2016 7:14 PM
>> *To:* vivek.pandey at pinelabs.com; AeroGear Developer Mailing List
>> *Subject:* Re: [aerogear-dev] UPS : Errors in Category Insertion
>>
>>
>>
>> Hi Vivek,
>>
>>
>>
>> This certainly seems like a bug and is worth to report, and we should
>> look into it in 1.1.1.
>>
>>
>>
>> I know Sebastien did some work around categories optimizations that is
>> likely related.
>>
>>
>>
>> On Thu, Jan 21, 2016 at 8:11 AM, Vivek Pandey <vivek.pandey at pinelabs.com>
>> wrote:
>>
>> We have been able to narrow down the issue to following scenario.
>>
>> Suppose we insert an installation with following payload
>>
>> {"deviceToken":"q1wS", "alias":"1 at xyz", "categories":["offer"]}
>>
>>
>>
>> Later, when the installation is updated
>>
>> {"deviceToken":"q1wS", "alias":"2 at xyz", "categories":["offer"]}
>>
>>
>>
>> We are seeing the exception mentioned below. This happens in 1.0.3 and
>> 1.1.0 Final as well.
>>
>>
>>
>> *From:* aerogear-dev-bounces at lists.jboss.org [mailto:
>> aerogear-dev-bounces at lists.jboss.org] *On Behalf Of *Vivek Pandey
>> *Sent:* Wednesday, January 20, 2016 5:07 PM
>> *To:* 'AeroGear Developer Mailing List'
>> *Subject:* [aerogear-dev] UPS : Errors in Category Insertion
>>
>>
>>
>> Hello UPS Team,
>>
>>
>>
>> I am noticing a strange problem in UPS 1.0.3. The primary key of the
>> table “category” is out of sync with the sequence “category_seq”.
>>
>> The id column contains negative values too. We are seeing error messages
>> like
>>
>>
>>
>>         ... 76 more
>>
>> Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value
>> violates unique constraint "category_pkey"
>>
>>   Detail: Key (id)=(192524) already exists.
>>
>>         at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
>>
>>
>>
>> I have attached the complete log for reference.
>>
>>
>>
>> We are using Postgres 9.3 and wildfly 8.1.0.
>>
>>
>>
>> Is it a known issue which is fixed in 1.1.0 Final?
>>
>>
>>
>> I am working to find the root cause and will communicate as soon as I
>> have one.
>>
>>
>>
>> Vivek
>>
>>
>> ------------------------------
>>
>> This message may contain privileged and confidential information and is
>> solely for the use of intended recipient. The views expressed in this email
>> are those of the sender and not of Pine Labs. The recipient should check
>> this email and attachments for the presence of viruses / malwares etc. Pine
>> Labs accepts no liability for any damage caused by any virus transmitted by
>> this email. Pine Labs may monitor and record all emails.
>> ------------------------------
>>
>>
>> ------------------------------
>>
>> This message may contain privileged and confidential information and is
>> solely for the use of intended recipient. The views expressed in this email
>> are those of the sender and not of Pine Labs. The recipient should check
>> this email and attachments for the presence of viruses / malwares etc. Pine
>> Labs accepts no liability for any damage caused by any virus transmitted by
>> this email. Pine Labs may monitor and record all emails.
>> ------------------------------
>>
>>
>>
>>
>>
>>
>> ------------------------------
>>
>> This message may contain privileged and confidential information and is
>> solely for the use of intended recipient. The views expressed in this email
>> are those of the sender and not of Pine Labs. The recipient should check
>> this email and attachments for the presence of viruses / malwares etc. Pine
>> Labs accepts no liability for any damage caused by any virus transmitted by
>> this email. Pine Labs may monitor and record all emails.
>> ------------------------------
>>
>>
>>
>>
>> _______________________________________________
>> aerogear-dev mailing list
>> aerogear-dev at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>>
>>
>>
>>
>>
>> --
>>
>> Lukáš Fryč
>>
>> Software Engineer
>>
>> Red Hat Mobile | AeroGear.org, FeedHenry.org
>>
>> ------------------------------
>> This message may contain privileged and confidential information and is
>> solely for the use of intended recipient. The views expressed in this email
>> are those of the sender and not of Pine Labs. The recipient should check
>> this email and attachments for the presence of viruses / malwares etc. Pine
>> Labs accepts no liability for any damage caused by any virus transmitted by
>> this email. Pine Labs may monitor and record all emails.
>> ------------------------------
>>
>>
>> _______________________________________________
>> aerogear-dev mailing list
>> aerogear-dev at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>>
>
>
>
> --
> Matthias Wessendorf
>
> blog: http://matthiaswessendorf.wordpress.com/
> sessions: http://www.slideshare.net/mwessendorf
> twitter: http://twitter.com/mwessendorf
>



-- 
Lukáš Fryč
Software Engineer
Red Hat Mobile | AeroGear.org, FeedHenry.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-dev/attachments/20160122/4ed79c4c/attachment-0001.html