Postgres constraint violation causes CMS create to blank portlet ---------------------------------------------------------------- Key: JBPORTAL-740 URL: http://jira.jboss.com/jira/browse/JBPORTAL-740 Project: JBoss Portal Issue Type: Bug Security Level: Public(Everyone can see) Components: Portal CMS Affects Versions: 2.4 Final Environment: Mac OS X 10.4.5, PostgreqQL 8.1 Reporter: Leonard Sitongia Assigned To: Roy Russo Fix For: 2.4.1 Final I'm trying the portal code in CVS today. It looks like a constraint violation triggers a series of exceptions which result in the CMSAdmin portlet disappearing. I'm using the WCK editor to create a new web page under default. When I click to save it, the page is refreshed but the CMSAdmin portlet is gone, no longer in the page. I see these errors: 2006-03-10 13:25:05,126 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not insert: [org.jboss.portal.cms.h ibernate.state.WSPProp] [insert into jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values (?, ?, ?)] org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "jbp_cms_wsp_prop_pkey" 2006-03-10 13:25:05,131 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: duplicate key violates unique cons traint "jbp_cms_wsp_prop_pkey" 2006-03-10 13:25:05,131 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize databa se state with session org.hibernate.exception.ConstraintViolationException: could not insert: [org.jboss.portal.cms.hibernate.state.WSPP rop] 2006-03-10 13:25:05,179 ERROR [org.apache.jackrabbit.core.state.XAItemStateManager] org.apache.jackrabbit.core.sta te.ItemStateException: failed to write property state: 90af15f1-c5d7-47ba-9cee-c73f38861627/{http://www.jcp.org/jc r/1.0}primaryType: could not insert: [org.jboss.portal.cms.hibernate.state.WSPProp] 2006-03-10 13:25:05,181 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchroni zation 2006-03-10 13:25:06,177 ERROR [org.jboss.portal.core.portlet.cms.admin.CMSAdminPortlet] The portlet threw an excep tion java.lang.NullPointerException at org.jboss.portal.core.portlet.cms.admin.CMSAdminPortlet.doView(CMSAdminPortlet.java:148)