Re: [aerogear-dev] UPS : Errors in Category Insertion

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(a)pinelabs.com&gt; wrote: > Thanks Lukas, I have logged a bug for this issue > https://issues.jboss.org/browse/AGPUSH-1568 > > > > *From:* Lukas Fryc [mailto:lfryc@redhat.com] > *Sent:* Thursday, January 21, 2016 7:14 PM > *To:* vivek.pandey(a)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(a)pinelabs.com&gt; > 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@xyz", "categories":["offer"]} > > > > Later, when the installation is updated > > {"deviceToken":"q1wS", "alias":"2@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(a)lists.jboss.org [mailto: > aerogear-dev-bounces(a)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(a)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(a)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