<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>@Erik can you make sure that your fix is covered by a unit test as well ?<br><br>Envoyé de mon iPhone</div><div><br>Le 22 janv. 2016 à 11:39, Lukas Fryc <<a href="mailto:lfryc@redhat.com">lfryc@redhat.com</a>> a écrit :<br><br></div><blockquote type="cite"><div><div dir="ltr">+1 exactly what I was thinking about :-)</div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jan 22, 2016 at 8:53 AM, Matthias Wessendorf <span dir="ltr"><<a href="mailto:matzew@apache.org" target="_blank">matzew@apache.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">It would be good if the model/jpa folder has a test case for that :) </div><div class="gmail_extra"><div><div class="h5"><br><div class="gmail_quote">On Fri, Jan 22, 2016 at 8:18 AM, Vivek Pandey <span dir="ltr"><<a href="mailto:vivek.pandey@pinelabs.com" target="_blank">vivek.pandey@pinelabs.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Thanks Lukas, I have logged a bug for this issue <a href="https://issues.jboss.org/browse/AGPUSH-1568" target="_blank">https://issues.jboss.org/browse/AGPUSH-1568</a><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Lukas Fryc [mailto:<a href="mailto:lfryc@redhat.com" target="_blank">lfryc@redhat.com</a>] <br><b>Sent:</b> Thursday, January 21, 2016 7:14 PM<br><b>To:</b> <a href="mailto:vivek.pandey@pinelabs.com" target="_blank">vivek.pandey@pinelabs.com</a>; AeroGear Developer Mailing List<br><b>Subject:</b> Re: [aerogear-dev] UPS : Errors in Category Insertion<u></u><u></u></span></p><div><div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">Hi Vivek,<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">This certainly seems like a bug and is worth to report, and we should look into it in 1.1.1.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">I know Sebastien did some work around categories optimizations that is likely related.<u></u><u></u></p></div></div><div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">On Thu, Jan 21, 2016 at 8:11 AM, Vivek Pandey <<a href="mailto:vivek.pandey@pinelabs.com" target="_blank">vivek.pandey@pinelabs.com</a>> wrote:<u></u><u></u></p><div><div><p class="MsoNormal"><span style="color:#1f497d">We have been able to narrow down the issue to following scenario.</span><u></u><u></u></p><p class="MsoNormal"><span style="color:#1f497d">Suppose we insert an installation with following payload</span><u></u><u></u></p><p class="MsoNormal"><span style="color:#1f497d">{"deviceToken":"q1wS", "alias":"1@xyz", "categories":["offer"]}</span><u></u><u></u></p><p class="MsoNormal"><span style="color:#1f497d"> </span><u></u><u></u></p><p class="MsoNormal"><span style="color:#1f497d">Later, when the installation is updated</span><u></u><u></u></p><p class="MsoNormal"><span style="color:#1f497d">{"deviceToken":"q1wS", "alias":"2@xyz", "categories":["offer"]}</span><u></u><u></u></p><p class="MsoNormal"><span style="color:#1f497d"> </span><u></u><u></u></p><p class="MsoNormal"><span style="color:#1f497d">We are seeing the exception mentioned below. This happens in 1.0.3 and 1.1.0 Final as well.</span><u></u><u></u></p><p class="MsoNormal"><span style="color:#1f497d"> </span><u></u><u></u></p><div><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:aerogear-dev-bounces@lists.jboss.org" target="_blank">aerogear-dev-bounces@lists.jboss.org</a> [mailto:<a href="mailto:aerogear-dev-bounces@lists.jboss.org" target="_blank">aerogear-dev-bounces@lists.jboss.org</a>] <b>On Behalf Of </b>Vivek Pandey<br><b>Sent:</b> Wednesday, January 20, 2016 5:07 PM<br><b>To:</b> 'AeroGear Developer Mailing List'<br><b>Subject:</b> [aerogear-dev] UPS : Errors in Category Insertion</span><u></u><u></u></p></div></div><div><div><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">Hello UPS Team,<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">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”.<u></u><u></u></p><p class="MsoNormal">The id column contains negative values too. We are seeing error messages like <u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal"><span style="font-size:8.0pt"> ... 76 more</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:8.0pt">Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "category_pkey"</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:8.0pt"> Detail: Key (id)=(192524) already exists.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:8.0pt"> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)</span><u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">I have attached the complete log for reference.<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">We are using Postgres 9.3 and wildfly 8.1.0.<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">Is it a known issue which is fixed in 1.1.0 Final? <u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">I am working to find the root cause and will communicate as soon as I have one.<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">Vivek<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><div class="MsoNormal" align="center" style="text-align:center"><hr size="2" width="100%" align="center"></div><p class="MsoNormal">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.<u></u><u></u></p><div class="MsoNormal" align="center" style="text-align:center"><hr size="2" width="100%" align="center"></div><p class="MsoNormal"> <u></u><u></u></p><div class="MsoNormal" align="center" style="text-align:center"><hr size="2" width="100%" align="center"></div><p class="MsoNormal">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.<u></u><u></u></p><div class="MsoNormal" align="center" style="text-align:center"><hr size="2" width="100%" align="center"></div><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p></div></div></div><div><div><p class="MsoNormal"><u></u> <u></u></p><div class="MsoNormal" align="center" style="text-align:center"><hr size="2" width="100%" align="center"></div><p class="MsoNormal">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.<u></u><u></u></p><div class="MsoNormal" align="center" style="text-align:center"><hr size="2" width="100%" align="center"></div><p class="MsoNormal"><u></u> <u></u></p></div></div></div><p class="MsoNormal"><br>_______________________________________________<br>aerogear-dev mailing list<br><a href="mailto:aerogear-dev@lists.jboss.org" target="_blank">aerogear-dev@lists.jboss.org</a><br><a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><u></u><u></u></p></div><p class="MsoNormal"><br><br clear="all"><u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><p class="MsoNormal">-- <u></u><u></u></p><div><div><div><div><div><div><div><div><p class="MsoNormal">Lukáš Fryč<u></u><u></u></p></div><div><p class="MsoNormal">Software Engineer<u></u><u></u></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">Red Hat Mobile | <a href="http://AeroGear.org">AeroGear.org</a>, <a href="http://FeedHenry.org">FeedHenry.org</a></span><u></u><u></u></p></div></div></div></div></div></div></div></div></div></div></div></div><div><div>
<br><hr>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.<hr>
<br></div></div></div><br>_______________________________________________<br>
aerogear-dev mailing list<br>
<a href="mailto:aerogear-dev@lists.jboss.org" target="_blank">aerogear-dev@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" rel="noreferrer" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br></div></div><div>Matthias Wessendorf <br><br>blog: <a href="http://matthiaswessendorf.wordpress.com/" target="_blank">http://matthiaswessendorf.wordpress.com/</a><br>sessions: <a href="http://www.slideshare.net/mwessendorf" target="_blank">http://www.slideshare.net/mwessendorf</a><br>twitter: <a href="http://twitter.com/mwessendorf" target="_blank">http://twitter.com/mwessendorf</a></div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Lukáš Fryč</div><div>Software Engineer</div><div><span style="font-size:12.8000001907349px">Red Hat Mobile | <a href="http://AeroGear.org">AeroGear.org</a>, </span><span style="font-size:12.8000001907349px"><a href="http://FeedHenry.org">FeedHenry.org</a></span></div></div></div></div></div></div></div></div>
</div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>aerogear-dev mailing list</span><br><span><a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a></span><br><span><a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a></span></div></blockquote></body></html>