Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-91582

Hibernate exceptions from Segments when interacting with the search page

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Duplicate
    • Affects Version/s: Master
    • Fix Version/s: None
    • Component/s: Segments Editor
    • Labels:
      None
    • Fix Priority:
      4

      Description

      Steps to reproduce:

      1. Start up a fresh bundle
      2. Search for "test"

      Result: Exception gets thrown when searching and exception page is shown

           [exec] com.liferay.poshi.runner.PoshiRunner > test[LocalFile.Search#SearchXSSAsset] STANDARD_OUT
           [exec]     Checking to see if TCat is enabled...
           [exec] 19:36:03,985 ERROR [http-nio-8080-exec-9][JDBCExceptionReporter:234] Duplicate entry '38441-20003-38692-38706' for key 'IX_EC7B704E'
           [exec] 19:36:03,994 ERROR [http-nio-8080-exec-9][MainServlet:1140] com.liferay.portal.kernel.events.ActionException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
           [exec] com.liferay.portal.kernel.events.ActionException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
           [exec] 	at com.liferay.segments.internal.events.SegmentsServicePreAction.run(SegmentsServicePreAction.java:71)
           [exec] 	at com.liferay.portal.kernel.events.Action.processLifecycleEvent(Action.java:34)
           [exec] 	at com.liferay.portal.events.EventsProcessorUtil.process(EventsProcessorUtil.java:98)
           [exec] 	at com.liferay.portal.events.EventsProcessorUtil.process(EventsProcessorUtil.java:60)
           [exec] 	at com.liferay.portal.internal.servlet.MainServlet._processServicePre(MainServlet.java:1119)
           [exec] 	at com.liferay.portal.internal.servlet.MainServlet.service(MainServlet.java:582)
           [exec] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
           [exec] 	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:119)
           [exec] 	at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:58)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:340)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:178)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:101)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
           [exec] 	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712)
           [exec] 	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459)
           [exec] 	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384)
           [exec] 	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
           [exec] 	at com.liferay.friendly.url.internal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:372)
           [exec] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
           [exec] 	at com.liferay.portal.servlet.ServletAdapter.service(ServletAdapter.java:98)
           [exec] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
           [exec] 	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:119)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:340)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.i18n.I18nFilter.processFilter(I18nFilter.java:358)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:58)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:340)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:88)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:260)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:88)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:263)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:178)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:188)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:188)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
           [exec] 	at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
           [exec] 	at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
           [exec] 	at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
           [exec] 	at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389)
           [exec] 	at com.liferay.portal.servlet.filters.urlrewrite.UrlRewriteFilter.processFilter(UrlRewriteFilter.java:65)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:168)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:168)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:188)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:101)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
           [exec] 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
           [exec] 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
           [exec] 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491)
           [exec] 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
           [exec] 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
           [exec] 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
           [exec] 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
           [exec] 	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
           [exec] 	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
           [exec] 	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:764)
           [exec] 	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1388)
           [exec] 	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
           [exec] 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
           [exec] 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
           [exec] 	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
           [exec] 	at java.lang.Thread.run(Thread.java:745)
           [exec] Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
           [exec] 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
           [exec] 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
           [exec] 	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
           [exec] 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
           [exec] 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
           [exec] 	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
           [exec] 	at com.liferay.portal.dao.orm.hibernate.event.NestableFlushEventListener.onFlush(NestableFlushEventListener.java:61)
           [exec] 	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
           [exec] 	at com.liferay.portal.spring.hibernate.PortletTransactionManager$TransactionStatusWrapper.reset(PortletTransactionManager.java:260)
           [exec] 	at com.liferay.portal.spring.hibernate.PortletTransactionManager.commit(PortletTransactionManager.java:63)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._commit(DefaultTransactionExecutor.java:89)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:136)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
           [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:59)
           [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:51)
           [exec] 	at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:46)
           [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:51)
           [exec] 	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:44)
           [exec] 	at com.sun.proxy.$Proxy842.addSegmentsExperience(Unknown Source)
           [exec] 	at com.liferay.segments.service.impl.SegmentsExperienceLocalServiceImpl._addDefaultExperience(SegmentsExperienceLocalServiceImpl.java:310)
           [exec] 	at com.liferay.segments.service.impl.SegmentsExperienceLocalServiceImpl.fetchDefaultSegmentsExperience(SegmentsExperienceLocalServiceImpl.java:169)
           [exec] 	at sun.reflect.GeneratedMethodAccessor457.invoke(Unknown Source)
           [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
           [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:44)
           [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.lambda$invoke$0(TransactionInterceptor.java:61)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
           [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:59)
           [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:51)
           [exec] 	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:44)
           [exec] 	at com.sun.proxy.$Proxy842.fetchDefaultSegmentsExperience(Unknown Source)
           [exec] 	at com.liferay.segments.service.impl.SegmentsExperienceLocalServiceImpl.getSegmentsExperiences(SegmentsExperienceLocalServiceImpl.java:227)
           [exec] 	at sun.reflect.GeneratedMethodAccessor534.invoke(Unknown Source)
           [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
           [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:44)
           [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.lambda$invoke$0(TransactionInterceptor.java:61)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
           [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:59)
           [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:51)
           [exec] 	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:44)
           [exec] 	at com.sun.proxy.$Proxy842.getSegmentsExperiences(Unknown Source)
           [exec] 	at com.liferay.segments.internal.events.SegmentsServicePreAction._getSegmentsExperienceIds(SegmentsServicePreAction.java:149)
           [exec] 	at com.liferay.segments.internal.events.SegmentsServicePreAction.doRun(SegmentsServicePreAction.java:106)
           [exec] 	at com.liferay.segments.internal.events.SegmentsServicePreAction.run(SegmentsServicePreAction.java:68)
           [exec] 	... 124 more
           [exec] Caused by: java.sql.BatchUpdateException: Duplicate entry '38441-20003-38692-38706' for key 'IX_EC7B704E'
           [exec] 	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054)
           [exec] 	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
           [exec] 	at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125)
           [exec] 	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
           [exec] 	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
           [exec] 	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
           [exec] 	... 168 more
           [exec] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '38441-20003-38692-38706' for key 'IX_EC7B704E'
           [exec] 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
           [exec] 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
           [exec] 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
           [exec] 	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
           [exec] 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
           [exec] 	at com.mysql.jdbc.Util.getInstance(Util.java:386)
           [exec] 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
           [exec] 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
           [exec] 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
           [exec] 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
           [exec] 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
           [exec] 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
           [exec] 	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
           [exec] 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
           [exec] 	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)
           [exec] 	... 173 more
           [exec] 19:36:04,010 ERROR [http-nio-8080-exec-9][error_jsp:?] User ID 38457
           [exec] 19:36:04,011 ERROR [http-nio-8080-exec-9][error_jsp:?] Current URL /web/guest/search?q=Liferay%20Alert
           [exec] 19:36:04,012 ERROR [http-nio-8080-exec-9][error_jsp:?] Referer http://cloud-10-0-16-186.lax.liferay.com:8080/web/guest/message-boards-page/-/message_boards/message/39123
           [exec] 19:36:04,012 ERROR [http-nio-8080-exec-9][error_jsp:?] Remote address 127.0.0.1
           [exec] 19:36:04,013 ERROR [http-nio-8080-exec-9][error_jsp:?] com.liferay.portal.kernel.events.ActionException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
           [exec] com.liferay.portal.kernel.events.ActionException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
           [exec] 	at com.liferay.segments.internal.events.SegmentsServicePreAction.run(SegmentsServicePreAction.java:71)
           [exec] 	at com.liferay.portal.kernel.events.Action.processLifecycleEvent(Action.java:34)
           [exec] 	at com.liferay.portal.events.EventsProcessorUtil.process(EventsProcessorUtil.java:98)
           [exec] 	at com.liferay.portal.events.EventsProcessorUtil.process(EventsProcessorUtil.java:60)
           [exec] 	at com.liferay.portal.internal.servlet.MainServlet._processServicePre(MainServlet.java:1119)
           [exec] 	at com.liferay.portal.internal.servlet.MainServlet.service(MainServlet.java:582)
           [exec] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
           [exec] 	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:119)
           [exec] 	at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:58)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:340)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:178)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:101)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
           [exec] 	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712)
           [exec] 	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459)
           [exec] 	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384)
           [exec] 	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
           [exec] 	at com.liferay.friendly.url.internal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:372)
           [exec] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
           [exec] 	at com.liferay.portal.servlet.ServletAdapter.service(ServletAdapter.java:98)
           [exec] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
           [exec] 	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:119)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:340)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.i18n.I18nFilter.processFilter(I18nFilter.java:358)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:58)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:340)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:88)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:260)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:88)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:263)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)
           [exec] 	at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:178)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:188)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:188)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
           [exec] 	at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
           [exec] 	at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
           [exec] 	at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
           [exec] 	at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389)
           [exec] 	at com.liferay.portal.servlet.filters.urlrewrite.UrlRewriteFilter.processFilter(UrlRewriteFilter.java:65)
           [exec] 	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:112)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:168)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:168)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:188)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
           [exec] 	at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:101)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
           [exec] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
           [exec] 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
           [exec] 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
           [exec] 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491)
           [exec] 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
           [exec] 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
           [exec] 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
           [exec] 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
           [exec] 	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
           [exec] 	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
           [exec] 	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:764)
           [exec] 	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1388)
           [exec] 	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
           [exec] 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
           [exec] 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
           [exec] 	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
           [exec] 	at java.lang.Thread.run(Thread.java:745)
           [exec] Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
           [exec] 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
           [exec] 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
           [exec] 	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
           [exec] 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
           [exec] 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
           [exec] 	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
           [exec] 	at com.liferay.portal.dao.orm.hibernate.event.NestableFlushEventListener.onFlush(NestableFlushEventListener.java:61)
           [exec] 	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
           [exec] 	at com.liferay.portal.spring.hibernate.PortletTransactionManager$TransactionStatusWrapper.reset(PortletTransactionManager.java:260)
           [exec] 	at com.liferay.portal.spring.hibernate.PortletTransactionManager.commit(PortletTransactionManager.java:63)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._commit(DefaultTransactionExecutor.java:89)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:136)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
           [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:59)
           [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:51)
           [exec] 	at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:46)
           [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:51)
           [exec] 	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:44)
           [exec] 	at com.sun.proxy.$Proxy842.addSegmentsExperience(Unknown Source)
           [exec] 	at com.liferay.segments.service.impl.SegmentsExperienceLocalServiceImpl._addDefaultExperience(SegmentsExperienceLocalServiceImpl.java:310)
           [exec] 	at com.liferay.segments.service.impl.SegmentsExperienceLocalServiceImpl.fetchDefaultSegmentsExperience(SegmentsExperienceLocalServiceImpl.java:169)
           [exec] 	at sun.reflect.GeneratedMethodAccessor457.invoke(Unknown Source)
           [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
           [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:44)
           [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.lambda$invoke$0(TransactionInterceptor.java:61)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
           [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:59)
           [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:51)
           [exec] 	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:44)
           [exec] 	at com.sun.proxy.$Proxy842.fetchDefaultSegmentsExperience(Unknown Source)
           [exec] 	at com.liferay.segments.service.impl.SegmentsExperienceLocalServiceImpl.getSegmentsExperiences(SegmentsExperienceLocalServiceImpl.java:227)
           [exec] 	at sun.reflect.GeneratedMethodAccessor534.invoke(Unknown Source)
           [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
           [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:44)
           [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.lambda$invoke$0(TransactionInterceptor.java:61)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)
           [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
           [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:59)
           [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:51)
           [exec] 	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:44)
           [exec] 	at com.sun.proxy.$Proxy842.getSegmentsExperiences(Unknown Source)
           [exec] 	at com.liferay.segments.internal.events.SegmentsServicePreAction._getSegmentsExperienceIds(SegmentsServicePreAction.java:149)
           [exec] 	at com.liferay.segments.internal.events.SegmentsServicePreAction.doRun(SegmentsServicePreAction.java:106)
           [exec] 	at com.liferay.segments.internal.events.SegmentsServicePreAction.run(SegmentsServicePreAction.java:68)
           [exec] 	... 124 more
           [exec] Caused by: java.sql.BatchUpdateException: Duplicate entry '38441-20003-38692-38706' for key 'IX_EC7B704E'
           [exec] 	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054)
           [exec] 	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
           [exec] 	at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125)
           [exec] 	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
           [exec] 	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
           [exec] 	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
           [exec] 	... 168 more
           [exec] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '38441-20003-38692-38706' for key 'IX_EC7B704E'
           [exec] 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
           [exec] 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
           [exec] 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
           [exec] 	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
           [exec] 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
           [exec] 	at com.mysql.jdbc.Util.getInstance(Util.java:386)
           [exec] 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
           [exec] 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
           [exec] 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
           [exec] 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
           [exec] 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
           [exec] 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
           [exec] 	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
           [exec] 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
           [exec] 	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)
           [exec] 	... 173 more
           [exec]     LIFERAY_ERROR: Duplicate entry '38441-20003-38692-38706' for key 'IX_EC7B704E'
           [exec]     LIFERAY_ERROR: com.liferay.portal.kernel.events.ActionException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
           [exec]     LIFERAY_ERROR: User ID 38457
           [exec]     LIFERAY_ERROR: Current URL /web/guest/search?q=Liferay%20Alert
           [exec]     LIFERAY_ERROR: Referer http://cloud-10-0-16-186.lax.liferay.com:8080/web/guest/message-boards-page/-/message_boards/message/39123
           [exec]     LIFERAY_ERROR: com.liferay.portal.kernel.events.ActionException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
           [exec] 
           [exec]     BUILD FAILED: Element is not present at "//li[@data-qa-id='row' and contains(.,'Thread Subject')]//h6[contains(.,'Message Boards Message')]/..//a"
           [exec]     /opt/dev/projects/github/liferay-portal/portal-web/test/functional/com/liferay/portalweb/macros/SearchResultPortlet.macro[viewSearchResults]:54
           [exec]     /opt/dev/projects/github/liferay-portal/portal-web/test/functional/com/liferay/portalweb/tests/coreinfrastructure/search/searchportlet/Search.testcase[SearchXSSAsset]:1432
           [exec] 
           [exec] 
           [exec] com.liferay.poshi.runner.PoshiRunner > test[LocalFile.Search#SearchXSSAsset] STANDARD_ERROR
           [exec]     java.lang.Exception: Element is not present at "//li[@data-qa-id='row' and contains(.,'Thread Subject')]//h6[contains(.,'Message Boards Message')]/..//a"
           [exec]     	at com.liferay.poshi.runner.PoshiRunnerExecutor.runSeleniumElement(PoshiRunnerExecutor.java:1045)
           [exec]     	at com.liferay.poshi.runner.PoshiRunnerExecutor.parseElement(PoshiRunnerExecutor.java:190)
           [exec]     	at com.liferay.poshi.runner.PoshiRunnerExecutor.runFunctionCommandElement(PoshiRunnerExecutor.java:417)
           [exec]     	at com.liferay.poshi.runner.PoshiRunnerExecutor.runFunctionExecuteElement(PoshiRunnerExecutor.java:541)
           [exec]     	at com.liferay.poshi.runner.PoshiRunnerExecutor.parseElement(PoshiRunnerExecutor.java:169)
           [exec]     	at com.liferay.poshi.runner.PoshiRunnerExecutor.runMacroCommandElement(PoshiRunnerExecutor.java:737)
           [exec]     	at com.liferay.poshi.runner.PoshiRunnerExecutor.runMacroExecuteElement(PoshiRunnerExecutor.java:772)
           [exec]     	at com.liferay.poshi.runner.PoshiRunnerExecutor.parseElement(PoshiRunnerExecutor.java:175)
           [exec]     	at com.liferay.poshi.runner.PoshiRunnerExecutor.runTestCaseCommandElement(PoshiRunnerExecutor.java:1093)
           [exec]     	at com.liferay.poshi.runner.PoshiRunner._runNamespacedClassCommandName(PoshiRunner.java:246)
           [exec]     	at com.liferay.poshi.runner.PoshiRunner._runCommand(PoshiRunner.java:221)
           [exec]     	at com.liferay.poshi.runner.PoshiRunner.test(PoshiRunner.java:181)
           [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
           [exec]     	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           [exec]     	at java.lang.reflect.Method.invoke(Method.java:498)
           [exec]     	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
           [exec]     	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
           [exec]     	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
           [exec]     	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
           [exec]     	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
           [exec]     	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
           [exec]     	at com.liferay.poshi.runner.PoshiRunner$RetryTestRule$RetryStatement.evaluate(PoshiRunner.java:294)
           [exec]     	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
           [exec]     	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
           [exec]     	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
           [exec]     	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
           [exec]     	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
           [exec]     	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
           [exec]     	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
           [exec]     	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
           [exec]     	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
           [exec]     	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
           [exec]     	at org.junit.runners.Suite.runChild(Suite.java:128)
           [exec]     	at org.junit.runners.Suite.runChild(Suite.java:27)
           [exec]     	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
           [exec]     	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
           [exec]     	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
           [exec]     	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
           [exec]     	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
           [exec]     	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
           [exec]     	at org.gradle.api.internal.tasks.testing.junit.JUnitTestClassExecutor.runTestClass(JUnitTestClassExecutor.java:106)
           [exec]     	at org.gradle.api.internal.tasks.testing.junit.JUnitTestClassExecutor.execute(JUnitTestClassExecutor.java:58)
           [exec]     	at org.gradle.api.internal.tasks.testing.junit.JUnitTestClassExecutor.execute(JUnitTestClassExecutor.java:38)
           [exec]     	at org.gradle.api.internal.tasks.testing.junit.AbstractJUnitTestClassProcessor.processTestClass(AbstractJUnitTestClassProcessor.java:66)
           [exec]     	at org.gradle.api.internal.tasks.testing.SuiteTestClassProcessor.processTestClass(SuiteTestClassProcessor.java:51)
           [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
           [exec]     	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           [exec]     	at java.lang.reflect.Method.invoke(Method.java:498)
           [exec]     	at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:35)
           [exec]     	at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24)
           [exec]     	at org.gradle.internal.dispatch.ContextClassLoaderDispatch.dispatch(ContextClassLoaderDispatch.java:32)
           [exec]     	at org.gradle.internal.dispatch.ProxyDispatchAdapter$DispatchingInvocationHandler.invoke(ProxyDispatchAdapter.java:93)
           [exec]     	at com.sun.proxy.$Proxy2.processTestClass(Unknown Source)
           [exec]     	at org.gradle.api.internal.tasks.testing.worker.TestWorker.processTestClass(TestWorker.java:117)
           [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
           [exec]     	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           [exec]     	at java.lang.reflect.Method.invoke(Method.java:498)
           [exec]     	at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:35)
           [exec]     	at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24)
           [exec]     	at org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:155)
           [exec]     	at org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:137)
           [exec]     	at org.gradle.internal.remote.internal.hub.MessageHub$Handler.run(MessageHub.java:404)
           [exec]     	at org.gradle.internal.concurrent.ExecutorPolicy$CatchAndRecordFailures.onExecute(ExecutorPolicy.java:63)
           [exec]     	at org.gradle.internal.concurrent.ManagedExecutorImpl$1.run(ManagedExecutorImpl.java:46)
           [exec]     	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
           [exec]     	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
           [exec]     	at org.gradle.internal.concurrent.ThreadFactoryImpl$ManagedThreadRunnable.run(ThreadFactoryImpl.java:55)
           [exec]     	at java.lang.Thread.run(Thread.java:745)
           [exec]     Caused by: java.lang.reflect.InvocationTargetException
           [exec]     	at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
           [exec]     	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           [exec]     	at java.lang.reflect.Method.invoke(Method.java:498)
           [exec]     	at com.liferay.poshi.runner.PoshiRunnerExecutor.runSeleniumElement(PoshiRunnerExecutor.java:1015)
           [exec]     	... 70 more
           [exec]     Caused by: java.lang.Exception: Element is not present at "//li[@data-qa-id='row' and contains(.,'Thread Subject')]//h6[contains(.,'Message Boards Message')]/..//a"
           [exec]     	at com.liferay.poshi.runner.selenium.BaseWebDriverImpl.assertElementPresent(BaseWebDriverImpl.java:353)
           [exec]     	at com.liferay.poshi.runner.selenium.BaseWebDriverImpl.assertVisible(BaseWebDriverImpl.java:765)
           [exec]     	at com.liferay.poshi.runner.selenium.BaseWebDriverImpl.waitForVisible(BaseWebDriverImpl.java:3591)
           [exec]     	... 74 more
           [exec] 
           [exec] com.liferay.poshi.runner.PoshiRunner > test[LocalFile.Search#SearchXSSAsset] FAILED
           [exec]     java.lang.Exception at PoshiRunner.java:246
           [exec]         Caused by: java.lang.reflect.InvocationTargetException at PoshiRunner.java:246
           [exec]             Caused by: java.lang.Exception at PoshiRunner.java:246
           [exec] 

      Reproduced on:
      Tomcat 8.0.32 + MySQL 5.7.25
      Portal Master Git SHA: aa299a2f5bcb55378b45a626e987d0ce735087f3

      Reproducible with this PR bundle:
      https://drive.google.com/file/d/1WelreYoMU_f3DnVHf73XKMQThHmVcT5a/view?usp=sharing

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                brian.lee Brian Lee
                Reporter:
                brian.lee Brian Lee
                Participants of an Issue:
                Recent user:
                André Ricardo Barreto de Oliveira
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  1 year, 29 weeks, 4 days ago

                  Packages

                  Version Package