Re: duplicate key violates unique constraint ERROR
Sergiy Shyrkov <[email protected]> Thu, 19 Jun 2008 09:42:10 +0200
| Newsgroups | gmane.comp.cms.jahia.devel |
|---|---|
| Message-ID | <[email protected]> |
Hello Bojana, unfortunately, in the stacktrace you sent there is not too much information about the actual cause of the error. Do you get this error always when you are trying to create a new page? Does it occur after the Jahia server restart? Kind regards Sergiy Bojana Lalic wrote: > Thanks Sergiy > > This has fixed the jahia_qrtz_scheduler_state_pkey error :) however I am still getting other error messages :( > > Any ideas why those would be appearing? > > 329090 [2008-06-19 10:45:43,549] [org.apache.struts.action.RequestProcessor] WARN - Unhandled Exception thrown: class java.lang.Exception > 329091 [2008-06-19 10:45:43,550] [org.jahia.bin.Jahia] ERROR - Throwable Exception caught in Jahia servlet : javax.servlet.ServletException: org.jahia.exceptions.JahiaException: User message=Error while processing request, System message=Exception in processing pipeline, root cause:User message=Could not create page., System message=Could not insert the page info into the database root cause=org.jahia.exceptions.JahiaException: User message=Could not create page., System message=Could not insert the page info into the database > javax.servlet.ServletException: org.jahia.exceptions.JahiaException: User message=Error while processing request, System message=Exception in processing pipeline, root cause:User message=Could not create page., System message=Could not insert the page info into the database root cause=org.jahia.exceptions.JahiaException: User message=Could not create page., System message=Could not insert the page info into the database > at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516) > at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423) > at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) > at org.jahia.bin.JahiaRequestProcessor.process(JahiaRequestProcessor.java:82) > at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) > at org.jahia.bin.Jahia.process(Jahia.java:1654) > at org.jahia.bin.Jahia.service(Jahia.java:855) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:110) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432) > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) > at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) > at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754) > at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684) > at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876) > at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > at java.lang.Thread.run(Thread.java:595) > 329082 [2008-06-19 10:45:43,541] [org.jahia.bin.JahiaErrorDisplay] ERROR - ERROR : Error while processing request, Exception in processing pipeline > org.jahia.exceptions.JahiaException: User message=Could not create page., System message=Could not insert the page info into the database > at org.jahia.services.pages.JahiaPageBaseService.createPage(JahiaPageBaseService.java:319) > at org.jahia.services.pages.JahiaPageBaseService$$FastClassByCGLIB$$e7c6d2f7.invoke(<generated>) > at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) > at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661) > at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) > at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80) > at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) > at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:606) > at org.jahia.services.pages.JahiaPageBaseService$$EnhancerByCGLIB$$1d1a8f86.createPage(<generated>) > at org.jahia.engines.shared.Page_Field.saveData(Page_Field.java:495) > at org.jahia.engines.shared.Page_Field.handleField(Page_Field.java:125) > at org.jahia.engines.EngineToolBox.processFieldTypes(EngineToolBox.java:132) > at org.jahia.engines.addcontainer.AddContainer_Engine.saveFields(AddContainer_Engine.java:870) > at org.jahia.engines.addcontainer.AddContainer_Engine.processCurrentScreen(AddContainer_Engine.java:691) > at org.jahia.engines.addcontainer.AddContainer_Engine.handleActions(AddContainer_Engine.java:277) > at org.jahia.operations.valves.EngineValve.invoke(EngineValve.java:110) > at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208) > at org.jahia.operations.valves.J2ProcessActionValve.invoke(J2ProcessActionValve.java:144) > at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208) > at org.jahia.operations.valves.CacheReadValve.invoke(CacheReadValve.java:65) > at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208) > at org.jahia.operations.valves.PageAccessCheckValve.invoke(PageAccessCheckValve.java:64) > at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208) > at org.jahia.operations.valves.OperationModeCheckValve.invoke(OperationModeCheckValve.java:83) > at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208) > at org.jahia.operations.valves.SiteCheckValve.invoke(SiteCheckValve.java:78) > at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208) > at org.jahia.operations.valves.EsiFragmentCacheReadValve.invoke(EsiFragmentCacheReadValve.java:326) > at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208) > at org.jahia.operations.valves.EsiUrlCookieCheckValve.invoke(EsiUrlCookieCheckValve.java:313) > at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208) > at org.jahia.pipelines.impl.GenericPipeline.invoke(GenericPipeline.java:195) > at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:100) > at org.jahia.bin.JahiaAction.execute(JahiaAction.java:72) > at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) > at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) > at org.jahia.bin.JahiaRequestProcessor.process(JahiaRequestProcessor.java:82) > at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) > at org.jahia.bin.Jahia.process(Jahia.java:1654) > > Regards > > Bojana > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Sergiy Shyrkov > Sent: Tuesday, 10 June 2008 4:03 PM > To: Here you can discuss and comment current and future developments of Jahia > Subject: Re: [dev_list] duplicate key violates unique constraint ERROR > > Hello Bojana, > > as you are using Jahia Community Edition with no clustering, please, > change the value of the following property in the > WEB-INF/etc/config/quartz.properties file to 'false', i.e.: > > org.quartz.jobStore.isClustered = false > > and restart your Jahia server. > > This should resolve the problem. > > Kind regards > Sergiy > > Bojana Lalic wrote: > >> Thanks Sergiy >> >> Yes, you are correct. I get the same stack trace error message when adding a link using a template also... >> >> 341585672 [2008-06-10 09:31:32,740] [org.quartz.impl.jdbcjobstore.JobStoreTX] ERROR - ClusterManager: Error managing cluster: Failure recovering jobs: ERROR: duplicate key violates unique constraint "jahia_qrtz_scheduler_state_pkey" >> org.quartz.JobPersistenceException: Failure recovering jobs: ERROR: duplicate key violates unique constraint "jahia_qrtz_scheduler_state_pkey" [See nested exception: org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "jahia_qrtz_scheduler_state_pkey"] >> at org.quartz.impl.jdbcjobstore.JobStoreSupport.clusterRecover(JobStoreSupport.java:2221) >> at org.quartz.impl.jdbcjobstore.JobStoreTX.doCheckin(JobStoreTX.java:1338) >> at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:2326) >> at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:2357) >> * Nested Exception (Underlying Cause) --------------- >> org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "jahia_qrtz_scheduler_state_pkey" >> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512) >> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297) >> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) >> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430) >> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346) >> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:300) >> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) >> at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.insertSchedulerState(StdJDBCDelegate.java:3632) >> at org.quartz.impl.jdbcjobstore.JobStoreSupport.clusterRecover(JobStoreSupport.java:2215) >> at org.quartz.impl.jdbcjobstore.JobStoreTX.doCheckin(JobStoreTX.java:1338) >> at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:2326) >> at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:2357) >> >> The exception occurs when I click OK in the Add/Update container. >> >> Regards >> >> Bojana >> >> -----Original Message----- >> From: [email protected] [mailto:[email protected]] On Behalf Of Sergiy Shyrkov >> Sent: Friday, 6 June 2008 7:15 PM >> To: Here you can discuss and comment current and future developments of Jahia >> Subject: Re: [dev_list] duplicate key violates unique constraint ERROR >> >> Hello Bojana, >> >> the attached stacktrace is actually related to the Job Scheduler service. >> Do you have another exception when creating links in the 'Links' box or >> this is the only one? When exactly the exception occur? When you click >> 'OK' in the Add/Update container engine? >> >> Kind regards >> Sergiy >> >> Bojana Lalic wrote: >> >> >>> Hi all >>> >>> >>> >>> Re: *Jahia release 5.0.0, Community Edition, Build 16138* >>> >>> >>> >>> I am unable to add links to external sites using the Links portlet. >>> Does anyone have a solution? J >>> >>> >>> >>> Stack trace: >>> >>> >>> >>> org.quartz.JobPersistenceException: Failure recovering jobs: ERROR: >>> duplicate key violates unique constraint >>> "jahia_qrtz_scheduler_state_pkey" [See nested exception: >>> org.postgresql.util.PSQLException: ERROR: duplicate key violates >>> unique constraint "jahia_qrtz_scheduler_state_pkey"] >>> >>> at >>> org.quartz.impl.jdbcjobstore.JobStoreSupport.clusterRecover(JobStoreSupport.java:2221) >>> >>> at >>> org.quartz.impl.jdbcjobstore.JobStoreTX.doCheckin(JobStoreTX.java:1338) >>> >>> at >>> org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:2326) >>> >>> at >>> org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:2357) >>> >>> * Nested Exception (Underlying Cause) --------------- >>> >>> org.postgresql.util.PSQLException: ERROR: duplicate key violates >>> unique constraint "jahia_qrtz_scheduler_state_pkey" >>> >>> at >>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512) >>> >>> at >>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297) >>> >>> at >>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) >>> >>> at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430) >>> >>> at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346) >>> >>> at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:300) >>> >>> at >>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) >>> >>> at >>> org.quartz.impl.jdbcjobstore.StdJDBCDelegate.insertSchedulerState(StdJDBCDelegate.java:3632) >>> >>> at >>> org.quartz.impl.jdbcjobstore.JobStoreSupport.clusterRecover(JobStoreSupport.java:2215) >>> >>> at >>> org.quartz.impl.jdbcjobstore.JobStoreTX.doCheckin(JobStoreTX.java:1338) >>> >>> at >>> org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:2326) >>> >>> at >>> org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:2357) >>> >>> 5537290 [2008-06-06 12:10:44,358] >>> [org.quartz.impl.jdbcjobstore.JobStoreTX] INFO - ClusterManager: >>> detected 3 failed or restarted instances. >>> >>> 5537291 [2008-06-06 12:10:44,359] >>> [org.quartz.impl.jdbcjobstore.JobStoreTX] INFO - ClusterManager: >>> Scanning for instance "devel.eduau.local1208495461263"'s failed >>> in-progress jobs. >>> >>> >>> >>> Regards >>> >>> >>> Bojana >>> >>> >>> >>> >>> ------------------------------------------------------------------------ >>> IMPORTANT: This e-mail, including any attachments, may contain private >>> or confidential information. If you think you may not be the intended >>> recipient, or if you have received this e-mail in error, please >>> contact the sender immediately and delete all copies of this e-mail. >>> If you are not the intended recipient, you must not reproduce any part >>> of this e-mail or disclose its contents to any other party. This email >>> represents the views of the individual sender, which do not >>> necessarily reflect those of education.au limited except where the >>> sender expressly states otherwise. It is your responsibility to scan >>> this email and any files transmitted with it for viruses or any other >>> defects. education.au limited will not be liable for any loss, damage >>> or consequence caused directly or indirectly by this email. >>> ------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> dev_list mailing list >>> [email protected] >>> http://lists.jahia.org/cgi-bin/mailman/listinfo/dev_list >>> >>> >>> >> _______________________________________________ >> dev_list mailing list >> [email protected] >> http://lists.jahia.org/cgi-bin/mailman/listinfo/dev_list >> >> IMPORTANT: This e-mail, including any attachments, may contain private or confidential information. If you think you may not be the intended recipient, or if you have received this e-mail in error, please contact the sender immediately and delete all copies of this e-mail. If you are not the intended recipient, you must not reproduce any part of this e-mail or disclose its contents to any other party. This email represents the views of the individual sender, which do not necessarily reflect those of education.au limited except where the sender expressly states otherwise. It is your responsibility to scan this email and any files transmitted with it for viruses or any other defects. education.au limited will not be liable for any loss, damage or consequence caused directly or indirectly by this email. >> _______________________________________________ >> dev_list mailing list >> [email protected] >> http://lists.jahia.org/cgi-bin/mailman/listinfo/dev_list >> >> > > _______________________________________________ > dev_list mailing list > [email protected] > http://lists.jahia.org/cgi-bin/mailman/listinfo/dev_list > > IMPORTANT: This e-mail, including any attachments, may contain private or confidential information. If you think you may not be the intended recipient, or if you have received this e-mail in error, please contact the sender immediately and delete all copies of this e-mail. If you are not the intended recipient, you must not reproduce any part of this e-mail or disclose its contents to any other party. This email represents the views of the individual sender, which do not necessarily reflect those of education.au limited except where the sender expressly states otherwise. It is your responsibility to scan this email and any files transmitted with it for viruses or any other defects. education.au limited will not be liable for any loss, damage or consequence caused directly or indirectly b y this email. > _______________________________________________ > dev_list mailing list > [email protected] > http://lists.jahia.org/cgi-bin/mailman/listinfo/dev_list > _______________________________________________ dev_list mailing list [email protected] http://lists.jahia.org/cgi-bin/mailman/listinfo/dev_list