Re: 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