Hi Vivek,We’ve fixed that https://github.com/aerogear/aerogear-unifiedpush-server/commit/1357c9e834286a9227a90e9ab618226aa54bbbf3 the collection is now lazy. But I’m sure other query optimisations can be made.
Cheers,Erik JanOn 26 May,2014, at 12:27 , Vivek Pandey <vivek.pandey@pinelabs.com> wrote:<threadstack.txt>_______________________________________________Hi Matthias,It is good to know that activity in java-apns is picking up and also that you are looking at pushy.I did a few tests which added installations to UPS with a concurrency of 4-8 threads. I was using Postgres 9.3 and UPS 0.10.3 warI noticed that response slowed down considerably after some time with high CPU usage and continued to get worse. After doing some profiling, I found that bulk of CPU cycles are being taken by org.postgresql.core.VisibleBufferedInputStream.readMore. The entire thread stack is attached. Also postgres continuously flaggedselect installati0_.variantID as variant10_0_0_, installati0_.id as id1_3_0_, installati0_.id as id1_3_1_, installati0_.alias as alias2_3_1_, installati0_.deviceToken as deviceTo3_3_1_, installati0_.deviceType as deviceTy4_3_1_, installati0_.enabled as enabled5_3_1_, installati0_.operatingSystem as operatin6_3_1_, installati0_.osVersion as osVersio7_3_1_, installati0_.platform as platform8_3_1_, installati0_.simplePushEndpoint as simplePu9_3_1_ from InstallationImpl installati0_ where installati0_.variantID=$1as the slow query. I am pretty sure that eager collection AbstractVariant.installations is the root cause of the problem.Please let me know if you need any more information.ThanksVivekFrom: mwessendorf@gmail.com [mailto:mwessendorf@gmail.com] On Behalf Of Matthias Wessendorf
Sent: Wednesday, May 21, 2014 5:55 PM
To: vivek.pandey@pinelabs.com; AeroGear Developer Mailing List
Subject: Re: [aerogear-dev] UPS Production worthinessHello Vivek!
On Wed, May 21, 2014 at 2:07 PM, Vivek Pandey <vivek.pandey@pinelabs.com> wrote:Hi Jay,Thanks for your reply.While we have not faced any issues in using UPS in our limited testing, I often see info stacktraces in ups logs2014-05-16 10:19:20,032 INFO [com.notnoop.apns.internal.ApnsConnectionImpl] (Thread-118) Exception while waiting for error code: java.net.SocketException: Socket closedat java.net.SocketInputStream.socketRead0(Native Method) [rt.jar:1.7.0_51]at java.net.SocketInputStream.read(SocketInputStream.java:152) [rt.jar:1.7.0_51]at java.net.SocketInputStream.read(SocketInputStream.java:122) [rt.jar:1.7.0_51]……………at com.notnoop.apns.internal.ApnsConnectionImpl$1MonitoringThread.run(ApnsConnectionImpl.java:114) [apns-0.2.3.jar:]These stacktraces coupled with low dev activity of noop/java-apns project are disconcerting to me.the stack-trace is no harm - it's only happening w/ doing a monitoring of the thread (that's what we currently do, when setting up ApnsService - I thought about explicitly disable that)The activity of the underlying java-apns is very low, yes! However @froh42 is getting back:There will be a new release in the near future; @froh42 asked me if I could help with pushing the bits to maven centralThat said, I recently started looking at pushy:I also sent a PR that would allow us to feed pushy w/ our certificate from the database:Hope that helps-MatthiasI am currently using UPS 0.10.2 war.Thanks,VivekFrom: Jay Balunas [mailto:jbalunas@redhat.com]
Sent: Tuesday, May 20, 2014 11:36 PM
To: vivek.pandey@pinelabs.com; AeroGear Developer Mailing List
Cc: Jay Balunas
Subject: Re: [aerogear-dev] UPS Production worthinessHi Vivek,It's awesome to hear that you have integrated the UPS into your backend systems and some of your mobile apps!We have a lot of confidence around the UPS, its functionality, and performance. Our team has been working hard on improvements and stability including our QE team. Also, as you may have seen we're planning a 1.0 release of the UPS this summer.However at this time we don't have specific references or success stories outside of what you can see in the community mailing lists - other users using it ;-) We're also about to kick off some performance and scale testing in the next couple of months.Have you run into any issues that drove these questions about production worthiness? If so please let us know and we'll certainly take a look.Hope this helps!Thanks,Jay BalunasOn May 20, 2014, at 8:09 AM, Vivek Pandey <vivek.pandey@pinelabs.com> wrote:
Hello Aerogear dev team,We integrated UPS into our backend server which is serving various mobile apps. While the development and testing phase went well, my manager is questioning me about production worthiness about Aerogear. It would be great help if you could point me to references/success stories where UPS is being used in production environments and scaling well in medium to high loads.Thanks,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.
_______________________________________________
aerogear-dev mailing list
aerogear-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-devThis 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@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
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@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev
_______________________________________________
aerogear-dev mailing list
aerogear-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev