[jboss-jira] [JBoss JIRA] Resolved: (JBPORTAL-740) Postgres constraint violation causes CMS create to blank portlet

[Roy Russo (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBPORTAL-740?page=all ]

Roy Russo resolved JBPORTAL-740.
--------------------------------

    Fix Version/s: 2.4.1 Final
       Resolution: Won't Fix
         Assignee: Roy Russo

> 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)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira