[aerogear-dev] UPS : Errors in Category Insertion

[Lukas Fryc]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-dev/attachments/20160121/3b640f66/attachment.html