Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-72639

Duplicate entry error is thrown when going to Account Settings

    Description

    Steps to reproduce:

    1. Start a clean bundle
    2. Go to My Account > Account Settings

    Actual result:
    Duplicate entry error is thrown(only occurs on the first time):

    05:21:00,848 ERROR [http-nio-8080-exec-5][JDBCExceptionReporter:234] Duplicate entry '20156-general' for key 'IX_BA4413D5'
    05:21:00,863 ERROR [http-nio-8080-exec-5][BaseJSPFormNavigatorEntry:54] Unable to include JSP /user/announcements.jsp
    org.apache.jasper.JasperException: org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into AnnouncementsDelivery (companyId, userId, type_, email, sms, website, deliveryId) values (?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
    	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:440)
    	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:473)
    	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:377)
    ...
    ...
    05:21:03,536 ERROR [http-nio-8080-exec-5][IncludeTag:128] Current URL /group/control_panel/manage?p_p_id=com_liferay_my_account_web_portlet_MyAccountPortlet&p_p_lifecycle=0&p_p_state=maximized&p_p_auth=a4qNaWKo generates exception: An exception occurred processing JSP page /html/taglib/ui/form_navigator/lexicon/sections.jspf at line 37____34: 			<aui:fieldset id="<%= _getSectionId(formNavigatorEntry.getKey()) %>">__35: __36: 				<%__37: 				PortalIncludeUtil.include(__38: 					pageContext,__39: 					new PortalIncludeUtil.HTMLRenderer() {__40: ______Stacktrace: [Sanitized]
    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '20156-general' for key 'IX_BA4413D5'
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    	at com.mysql.jdbc.Util.getInstance(Util.java:386)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
    ...
    

    Expected result:
    No error is thrown on the console.

      Attachments

        Issue Links

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 41 weeks, 2 days ago

                Packages

                Version Package