Aerogear UPS 1.1.0.Final max. number of aliases in push notification request

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Aerogear UPS 1.1.0.Final max. number of aliases in push notification request

gklein
Hi!

When we send a push message with a very big list of aliases to Aerogear-1.1.0 (25k aliases), we can see a strack trace in the server logs, indicating a low level postgres db exception ('ERROR: value too long for type character varying(4500)'). So obviously the calling client seems having to take care of proper validation and e.g. breaking the request up into smaller batches. Right? So, whats the actual number of aliases, that can be specified in one push notification batch request? Also: Wouldn't a proper validation check on the server side make sense, before persisting to the db?

Regards, Gunther


--- stack trace ---
2015-12-01 18:08:44,239 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-12) SQL Error: 0, SQLState: 22001
2015-12-01 18:08:44,239 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-12) ERROR: value too long for type character varying(4500)
2015-12-01 18:08:44,239 INFO  [org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl] (default task-12) HHH000010: On release of batch it still contained JDBC statements
2015-12-01 18:08:44,240 ERROR [org.jboss.as.ejb3] (default task-12) javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.DataException: could not execute statement
2015-12-01 18:08:44,240 ERROR [org.jboss.as.ejb3.invocation] (default task-12) JBAS014134: EJB Invocation failed on component PushMessageMetricsService for method public org.jboss.aerogear.unifiedpush.api.PushMessageInformation org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService.storeNewRequestFrom(java.lang.String,java.lang.String,java.lang.String,java.lang.String,int): javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.DataException: could not execute statement
        at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleInCallerTx(CMTTxInterceptor.java:163) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:253) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:342) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:439)
        at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
        at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
        at org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService$$$view8.storeNewRequestFrom(Unknown Source) [unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor359.invoke(Unknown Source) [:1.8.0_45]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:414) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:65) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService$Proxy$_$$_Weld$EnterpriseProxy$.storeNewRequestFrom(Unknown Source) [unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at org.jboss.aerogear.unifiedpush.message.NotificationRouter.submit(NotificationRouter.java:101) [unifiedpush-push-sender-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor358.invoke(Unknown Source) [:1.8.0_45]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82) [wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93) [wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) [wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45) [wildfly-ee-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.interceptors.NonPooledEJBComponentInstanceAssociatingInterceptor.processInvocation(NonPooledEJBComponentInstanceAssociatingInterceptor.java:59) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:273) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:340) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:448)
        at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
        at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
        at org.jboss.aerogear.unifiedpush.message.NotificationRouter$$$view20.submit(Unknown Source) [unifiedpush-push-sender-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor358.invoke(Unknown Source) [:1.8.0_45]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:414) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:65) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.aerogear.unifiedpush.message.NotificationRouter$Proxy$_$$_Weld$EnterpriseProxy$.submit(Unknown Source) [unifiedpush-push-sender-1.1.0.Final.jar:1.1.0.Final]
        at org.jboss.aerogear.unifiedpush.rest.sender.PushNotificationSenderEndpoint.send(PushNotificationSenderEndpoint.java:107) [unifiedpush-jaxrs-1.1.0.Final.jar:1.1.0.Final]
        at org.jboss.aerogear.unifiedpush.rest.sender.PushNotificationSenderEndpoint$Proxy$_$$_WeldClientProxy.send(Unknown Source) [unifiedpush-jaxrs-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor385.invoke(Unknown Source) [:1.8.0_45]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137) [resteasy-jaxrs-3.0.10.Final.jar:]
        at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296) [resteasy-jaxrs-3.0.10.Final.jar:]
        at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250) [resteasy-jaxrs-3.0.10.Final.jar:]
        at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:237) [resteasy-jaxrs-3.0.10.Final.jar:]
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356) [resteasy-jaxrs-3.0.10.Final.jar:]
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179) [resteasy-jaxrs-3.0.10.Final.jar:]
        at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220) [resteasy-jaxrs-3.0.10.Final.jar:]
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56) [resteasy-jaxrs-3.0.10.Final.jar:]
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51) [resteasy-jaxrs-3.0.10.Final.jar:]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
        at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at org.jboss.aerogear.unifiedpush.service.filter.HttpContextFilter.doFilter(HttpContextFilter.java:55) [unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at org.jboss.aerogear.unifiedpush.rest.util.VersionFilter.doFilter(VersionFilter.java:65) [unifiedpush-jaxrs-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
        at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at org.keycloak.adapters.undertow.UndertowAuthenticatedActionsHandler.handleRequest(UndertowAuthenticatedActionsHandler.java:66) [keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at org.keycloak.adapters.undertow.UndertowAuthenticatedActionsHandler.handleRequest(UndertowAuthenticatedActionsHandler.java:66) [keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:63) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
        at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69) [keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69) [keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:247) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:76) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:166) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.server.Connectors.executeRootHandler(Connectors.java:197) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:759) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_45]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_45]
        at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_45]
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not execute statement
        at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763) [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677) [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1683) [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1338) [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at org.jboss.as.jpa.container.AbstractEntityManager.flush(AbstractEntityManager.java:457) [wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
        at sun.reflect.GeneratedMethodAccessor339.invoke(Unknown Source) [:1.8.0_45]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:414) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.weld.bean.builtin.CallableMethodHandler.invoke(CallableMethodHandler.java:42) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.weldx.persistence.EntityManager$1602193877$Proxy$_$$_Weld$Proxy$.flush(Unknown Source) [hibernate-jpa-2.1-api-1.0.0.Final.jar:]
        at org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPABaseDao.flushAndClear(JPABaseDao.java:102) [unifiedpush-model-jpa-1.1.0.Final.jar:1.1.0.Final]
        at org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService.storeNewRequestFrom(PushMessageMetricsService.java:70) [unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor359.invoke(Unknown Source) [:1.8.0_45]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82) [wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93) [wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) [wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45) [wildfly-ee-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.component.interceptors.NonPooledEJBComponentInstanceAssociatingInterceptor.processInvocation(NonPooledEJBComponentInstanceAssociatingInterceptor.java:59) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:251) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        ... 174 more
Caused by: org.hibernate.exception.DataException: could not execute statement
        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1335) [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        ... 219 more
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4500)
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366)
        at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        ... 229 more
Reply | Threaded
Open this post in threaded view
|

Re: [Aerogear-users] Aerogear UPS 1.1.0.Final max. number of aliases in push notification request

Matthias Wessendorf
Hi Günther,

thanks for reaching out ob this. I agree its a pretty lame bug!

Will look into it tomorrow. Sorry for the inconvenience 

On Tuesday, 1 December 2015, gklein <[hidden email]> wrote:
Hi!

When we send a push message with a very big list of aliases to
Aerogear-1.1.0 (25k aliases), we can see a strack trace in the server logs,
indicating a low level postgres db exception ('ERROR: value too long for
type character varying(4500)'). So obviously the calling client seems having
to take care of proper validation and e.g. breaking the request up into
smaller batches. Right? So, whats the actual number of aliases, that can be
specified in one push notification batch request? Also: Wouldn't a proper
validation check on the server side make sense, before persisting to the db?

Regards, Gunther


--- stack trace ---
2015-12-01 18:08:44,239 WARN
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-12) SQL
Error: 0, SQLState: 22001
2015-12-01 18:08:44,239 ERROR
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-12) ERROR:
value too long for type character varying(4500)
2015-12-01 18:08:44,239 INFO
[org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl] (default
task-12) HHH000010: On release of batch it still contained JDBC statements
2015-12-01 18:08:44,240 ERROR [org.jboss.as.ejb3] (default task-12)
javax.ejb.EJBTransactionRolledbackException:
org.hibernate.exception.DataException: could not execute statement
2015-12-01 18:08:44,240 ERROR [org.jboss.as.ejb3.invocation] (default
task-12) JBAS014134: EJB Invocation failed on component
PushMessageMetricsService for method public
org.jboss.aerogear.unifiedpush.api.PushMessageInformation
org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService.storeNewRequestFrom(java.lang.String,java.lang.String,java.lang.String,java.lang.String,int):
javax.ejb.EJBTransactionRolledbackException:
org.hibernate.exception.DataException: could not execute statement
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.handleInCallerTx(CMTTxInterceptor.java:163)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:253)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:342)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at
org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:439)
        at
org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at
org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
        at
org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at
org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
        at
org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService$$$view8.storeNewRequestFrom(Unknown
Source) [unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor359.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:414)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:65)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService$Proxy$_$$_Weld$EnterpriseProxy$.storeNewRequestFrom(Unknown
Source) [unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.message.NotificationRouter.submit(NotificationRouter.java:101)
[unifiedpush-push-sender-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor358.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
[wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at
org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
[wildfly-ee-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at
org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.NonPooledEJBComponentInstanceAssociatingInterceptor.processInvocation(NonPooledEJBComponentInstanceAssociatingInterceptor.java:59)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:273)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:340)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at
org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:448)
        at
org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at
org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
        at
org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at
org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
        at
org.jboss.aerogear.unifiedpush.message.NotificationRouter$$$view20.submit(Unknown
Source) [unifiedpush-push-sender-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor358.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:414)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:65)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.aerogear.unifiedpush.message.NotificationRouter$Proxy$_$$_Weld$EnterpriseProxy$.submit(Unknown
Source) [unifiedpush-push-sender-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.rest.sender.PushNotificationSenderEndpoint.send(PushNotificationSenderEndpoint.java:107)
[unifiedpush-jaxrs-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.rest.sender.PushNotificationSenderEndpoint$Proxy$_$$_WeldClientProxy.send(Unknown
Source) [unifiedpush-jaxrs-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor385.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:237)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
[jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
        at
io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.service.filter.HttpContextFilter.doFilter(HttpContextFilter.java:55)
[unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.rest.util.VersionFilter.doFilter(VersionFilter.java:65)
[unifiedpush-jaxrs-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
org.keycloak.adapters.undertow.UndertowAuthenticatedActionsHandler.handleRequest(UndertowAuthenticatedActionsHandler.java:66)
[keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at
org.keycloak.adapters.undertow.UndertowAuthenticatedActionsHandler.handleRequest(UndertowAuthenticatedActionsHandler.java:66)
[keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at
io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:63)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69)
[keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at
org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69)
[keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:247)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:76)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:166)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.server.Connectors.executeRootHandler(Connectors.java:197)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:759)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[rt.jar:1.8.0_45]
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[rt.jar:1.8.0_45]
        at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_45]
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.DataException: could not execute statement
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1683)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1338)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at
org.jboss.as.jpa.container.AbstractEntityManager.flush(AbstractEntityManager.java:457)
[wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
        at sun.reflect.GeneratedMethodAccessor339.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:414)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.builtin.CallableMethodHandler.invoke(CallableMethodHandler.java:42)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weldx.persistence.EntityManager$1602193877$Proxy$_$$_Weld$Proxy$.flush(Unknown
Source) [hibernate-jpa-2.1-api-1.0.0.Final.jar:]
        at
org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPABaseDao.flushAndClear(JPABaseDao.java:102)
[unifiedpush-model-jpa-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService.storeNewRequestFrom(PushMessageMetricsService.java:70)
[unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor359.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
[wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at
org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
[wildfly-ee-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at
org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.NonPooledEJBComponentInstanceAssociatingInterceptor.processInvocation(NonPooledEJBComponentInstanceAssociatingInterceptor.java:59)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:251)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        ... 174 more
Caused by: org.hibernate.exception.DataException: could not execute
statement
        at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1335)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        ... 219 more
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type
character varying(4500)
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366)
        at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
        at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        ... 229 more




--
View this message in context: http://aerogear-users.1116366.n5.nabble.com/Aerogear-UPS-1-1-0-Final-max-number-of-aliases-in-push-notification-request-tp321.html
Sent from the aerogear-users mailing list archive at Nabble.com.
_______________________________________________
Aerogear-users mailing list
<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;Aerogear-users@lists.jboss.org&#39;)">Aerogear-users@...
https://lists.jboss.org/mailman/listinfo/aerogear-users


--
Sent from Gmail Mobile

_______________________________________________
Aerogear-users mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-users
Reply | Threaded
Open this post in threaded view
|

Re: [Aerogear-users] Aerogear UPS 1.1.0.Final max. number of aliases in push notification request

Matthias Wessendorf
I think we won't be storing the raw JSON, and likely remove the alias data

On Tue, Dec 1, 2015 at 8:28 PM, Matthias Wessendorf <[hidden email]> wrote:
Hi Günther,

thanks for reaching out ob this. I agree its a pretty lame bug!

Will look into it tomorrow. Sorry for the inconvenience 

On Tuesday, 1 December 2015, gklein <[hidden email]> wrote:
Hi!

When we send a push message with a very big list of aliases to
Aerogear-1.1.0 (25k aliases), we can see a strack trace in the server logs,
indicating a low level postgres db exception ('ERROR: value too long for
type character varying(4500)'). So obviously the calling client seems having
to take care of proper validation and e.g. breaking the request up into
smaller batches. Right? So, whats the actual number of aliases, that can be
specified in one push notification batch request? Also: Wouldn't a proper
validation check on the server side make sense, before persisting to the db?

Regards, Gunther


--- stack trace ---
2015-12-01 18:08:44,239 WARN
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-12) SQL
Error: 0, SQLState: 22001
2015-12-01 18:08:44,239 ERROR
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-12) ERROR:
value too long for type character varying(4500)
2015-12-01 18:08:44,239 INFO
[org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl] (default
task-12) HHH000010: On release of batch it still contained JDBC statements
2015-12-01 18:08:44,240 ERROR [org.jboss.as.ejb3] (default task-12)
javax.ejb.EJBTransactionRolledbackException:
org.hibernate.exception.DataException: could not execute statement
2015-12-01 18:08:44,240 ERROR [org.jboss.as.ejb3.invocation] (default
task-12) JBAS014134: EJB Invocation failed on component
PushMessageMetricsService for method public
org.jboss.aerogear.unifiedpush.api.PushMessageInformation
org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService.storeNewRequestFrom(java.lang.String,java.lang.String,java.lang.String,java.lang.String,int):
javax.ejb.EJBTransactionRolledbackException:
org.hibernate.exception.DataException: could not execute statement
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.handleInCallerTx(CMTTxInterceptor.java:163)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:253)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:342)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at
org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:439)
        at
org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at
org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
        at
org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at
org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
        at
org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService$$$view8.storeNewRequestFrom(Unknown
Source) [unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor359.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:414)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:65)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService$Proxy$_$$_Weld$EnterpriseProxy$.storeNewRequestFrom(Unknown
Source) [unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.message.NotificationRouter.submit(NotificationRouter.java:101)
[unifiedpush-push-sender-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor358.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
[wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at
org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
[wildfly-ee-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at
org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.NonPooledEJBComponentInstanceAssociatingInterceptor.processInvocation(NonPooledEJBComponentInstanceAssociatingInterceptor.java:59)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:273)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:340)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at
org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:448)
        at
org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at
org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
        at
org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at
org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
        at
org.jboss.aerogear.unifiedpush.message.NotificationRouter$$$view20.submit(Unknown
Source) [unifiedpush-push-sender-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor358.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:414)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:65)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.aerogear.unifiedpush.message.NotificationRouter$Proxy$_$$_Weld$EnterpriseProxy$.submit(Unknown
Source) [unifiedpush-push-sender-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.rest.sender.PushNotificationSenderEndpoint.send(PushNotificationSenderEndpoint.java:107)
[unifiedpush-jaxrs-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.rest.sender.PushNotificationSenderEndpoint$Proxy$_$$_WeldClientProxy.send(Unknown
Source) [unifiedpush-jaxrs-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor385.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:237)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
[jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
        at
io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.service.filter.HttpContextFilter.doFilter(HttpContextFilter.java:55)
[unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.rest.util.VersionFilter.doFilter(VersionFilter.java:65)
[unifiedpush-jaxrs-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
org.keycloak.adapters.undertow.UndertowAuthenticatedActionsHandler.handleRequest(UndertowAuthenticatedActionsHandler.java:66)
[keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at
org.keycloak.adapters.undertow.UndertowAuthenticatedActionsHandler.handleRequest(UndertowAuthenticatedActionsHandler.java:66)
[keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at
io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:63)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69)
[keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at
org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69)
[keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:247)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:76)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:166)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.server.Connectors.executeRootHandler(Connectors.java:197)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:759)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[rt.jar:1.8.0_45]
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[rt.jar:1.8.0_45]
        at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_45]
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.DataException: could not execute statement
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:<a href="tel:1683" value="+491683" target="_blank">1683)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1338)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at
org.jboss.as.jpa.container.AbstractEntityManager.flush(AbstractEntityManager.java:457)
[wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
        at sun.reflect.GeneratedMethodAccessor339.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:414)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.builtin.CallableMethodHandler.invoke(CallableMethodHandler.java:42)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weldx.persistence.EntityManager$1602193877$Proxy$_$$_Weld$Proxy$.flush(Unknown
Source) [hibernate-jpa-2.1-api-1.0.0.Final.jar:]
        at
org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPABaseDao.flushAndClear(JPABaseDao.java:102)
[unifiedpush-model-jpa-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService.storeNewRequestFrom(PushMessageMetricsService.java:70)
[unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor359.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
[wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at
org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
[wildfly-ee-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at
org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.NonPooledEJBComponentInstanceAssociatingInterceptor.processInvocation(NonPooledEJBComponentInstanceAssociatingInterceptor.java:59)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:251)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        ... 174 more
Caused by: org.hibernate.exception.DataException: could not execute
statement
        at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1335)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        ... 219 more
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type
character varying(4500)
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366)
        at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
        at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        ... 229 more




--
View this message in context: http://aerogear-users.1116366.n5.nabble.com/Aerogear-UPS-1-1-0-Final-max-number-of-aliases-in-push-notification-request-tp321.html
Sent from the aerogear-users mailing list archive at Nabble.com.
_______________________________________________
Aerogear-users mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-users


--
Sent from Gmail Mobile



--

_______________________________________________
Aerogear-users mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-users
Reply | Threaded
Open this post in threaded view
|

Re: [Aerogear-users] Aerogear UPS 1.1.0.Final max. number of aliases in push notification request

Matthias Wessendorf

On Tue, Dec 1, 2015 at 9:36 PM, Matthias Wessendorf <[hidden email]> wrote:
I think we won't be storing the raw JSON, and likely remove the alias data

On Tue, Dec 1, 2015 at 8:28 PM, Matthias Wessendorf <[hidden email]> wrote:
Hi Günther,

thanks for reaching out ob this. I agree its a pretty lame bug!

Will look into it tomorrow. Sorry for the inconvenience 

On Tuesday, 1 December 2015, gklein <[hidden email]> wrote:
Hi!

When we send a push message with a very big list of aliases to
Aerogear-1.1.0 (25k aliases), we can see a strack trace in the server logs,
indicating a low level postgres db exception ('ERROR: value too long for
type character varying(4500)'). So obviously the calling client seems having
to take care of proper validation and e.g. breaking the request up into
smaller batches. Right? So, whats the actual number of aliases, that can be
specified in one push notification batch request? Also: Wouldn't a proper
validation check on the server side make sense, before persisting to the db?

Regards, Gunther


--- stack trace ---
2015-12-01 18:08:44,239 WARN
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-12) SQL
Error: 0, SQLState: 22001
2015-12-01 18:08:44,239 ERROR
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-12) ERROR:
value too long for type character varying(4500)
2015-12-01 18:08:44,239 INFO
[org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl] (default
task-12) HHH000010: On release of batch it still contained JDBC statements
2015-12-01 18:08:44,240 ERROR [org.jboss.as.ejb3] (default task-12)
javax.ejb.EJBTransactionRolledbackException:
org.hibernate.exception.DataException: could not execute statement
2015-12-01 18:08:44,240 ERROR [org.jboss.as.ejb3.invocation] (default
task-12) JBAS014134: EJB Invocation failed on component
PushMessageMetricsService for method public
org.jboss.aerogear.unifiedpush.api.PushMessageInformation
org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService.storeNewRequestFrom(java.lang.String,java.lang.String,java.lang.String,java.lang.String,int):
javax.ejb.EJBTransactionRolledbackException:
org.hibernate.exception.DataException: could not execute statement
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.handleInCallerTx(CMTTxInterceptor.java:163)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:253)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:342)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at
org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:439)
        at
org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at
org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
        at
org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at
org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
        at
org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService$$$view8.storeNewRequestFrom(Unknown
Source) [unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor359.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:414)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:65)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService$Proxy$_$$_Weld$EnterpriseProxy$.storeNewRequestFrom(Unknown
Source) [unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.message.NotificationRouter.submit(NotificationRouter.java:101)
[unifiedpush-push-sender-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor358.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
[wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at
org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
[wildfly-ee-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at
org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.NonPooledEJBComponentInstanceAssociatingInterceptor.processInvocation(NonPooledEJBComponentInstanceAssociatingInterceptor.java:59)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:273)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:340)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at
org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:448)
        at
org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
        at
org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
        at
org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at
org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
        at
org.jboss.aerogear.unifiedpush.message.NotificationRouter$$$view20.submit(Unknown
Source) [unifiedpush-push-sender-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor358.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:414)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:65)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.aerogear.unifiedpush.message.NotificationRouter$Proxy$_$$_Weld$EnterpriseProxy$.submit(Unknown
Source) [unifiedpush-push-sender-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.rest.sender.PushNotificationSenderEndpoint.send(PushNotificationSenderEndpoint.java:107)
[unifiedpush-jaxrs-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.rest.sender.PushNotificationSenderEndpoint$Proxy$_$$_WeldClientProxy.send(Unknown
Source) [unifiedpush-jaxrs-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor385.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:237)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
[resteasy-jaxrs-3.0.10.Final.jar:]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
[jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
        at
io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.service.filter.HttpContextFilter.doFilter(HttpContextFilter.java:55)
[unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.rest.util.VersionFilter.doFilter(VersionFilter.java:65)
[unifiedpush-jaxrs-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
org.keycloak.adapters.undertow.UndertowAuthenticatedActionsHandler.handleRequest(UndertowAuthenticatedActionsHandler.java:66)
[keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at
org.keycloak.adapters.undertow.UndertowAuthenticatedActionsHandler.handleRequest(UndertowAuthenticatedActionsHandler.java:66)
[keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at
io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:63)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69)
[keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at
org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69)
[keycloak-undertow-adapter-1.3.1.Final.jar:1.3.1.Final]
        at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:247)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:76)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at
io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:166)
[undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.server.Connectors.executeRootHandler(Connectors.java:197)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:759)
[undertow-core-1.1.0.Final.jar:1.1.0.Final]
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[rt.jar:1.8.0_45]
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[rt.jar:1.8.0_45]
        at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_45]
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.DataException: could not execute statement
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:<a href="tel:1683" value="+491683" target="_blank">1683)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1338)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        at
org.jboss.as.jpa.container.AbstractEntityManager.flush(AbstractEntityManager.java:457)
[wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
        at sun.reflect.GeneratedMethodAccessor339.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:414)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.builtin.CallableMethodHandler.invoke(CallableMethodHandler.java:42)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.weldx.persistence.EntityManager$1602193877$Proxy$_$$_Weld$Proxy$.flush(Unknown
Source) [hibernate-jpa-2.1-api-1.0.0.Final.jar:]
        at
org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPABaseDao.flushAndClear(JPABaseDao.java:102)
[unifiedpush-model-jpa-1.1.0.Final.jar:1.1.0.Final]
        at
org.jboss.aerogear.unifiedpush.service.metrics.PushMessageMetricsService.storeNewRequestFrom(PushMessageMetricsService.java:70)
[unifiedpush-service-1.1.0.Final.jar:1.1.0.Final]
        at sun.reflect.GeneratedMethodAccessor359.invoke(Unknown Source)
[:1.8.0_45]
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_45]
        at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45]
        at
org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
        at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
[wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
        at
org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46)
[weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
        at
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
[wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
[wildfly-ee-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at
org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.component.interceptors.NonPooledEJBComponentInstanceAssociatingInterceptor.processInvocation(NonPooledEJBComponentInstanceAssociatingInterceptor.java:59)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
        at
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:251)
[wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
        ... 174 more
Caused by: org.hibernate.exception.DataException: could not execute
statement
        at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1335)
[hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
        ... 219 more
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type
character varying(4500)
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366)
        at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
        at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
[hibernate-core-4.3.7.Final.jar:4.3.7.Final]
        ... 229 more




--
View this message in context: http://aerogear-users.1116366.n5.nabble.com/Aerogear-UPS-1-1-0-Final-max-number-of-aliases-in-push-notification-request-tp321.html
Sent from the aerogear-users mailing list archive at Nabble.com.
_______________________________________________
Aerogear-users mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-users


--
Sent from Gmail Mobile



--



--

_______________________________________________
Aerogear-users mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-users