Re: duplicate key violates unique constraint ERROR
Bojana Lalic <[email protected]> Thu, 19 Jun 2008 10:59:11 +0930
| Newsgroups | gmane.comp.cms.jahia.devel |
|---|---|
| Message-ID | <[email protected]> |
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 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
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