Details

    • Type: Information
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • Affects Version/s: 3.1.2, 3.4
    • Fix Version/s: 3.4
    • Component/s: Upgrades
    • Labels:
      None
    • Environment:
      RHEL, JBoss, PostGreSQL(8.4.4), Alfresco 3.1.2
    • Bug Priority:
      Category 2
    • ACT Numbers:

      28861

      Description

      Customer is getting some data errors when upgrading from 3.1.2 to 3.4 Enterprise:

      11:36:33,741 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply ...
      11:36:33,929 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.zonedAuthorities' (Adds the remodelled cm:authority container to the spaces store).
      11:37:08,374 ERROR [org.alfresco.repo.admin.patch.PatchExecuter] 02300067 org.alfresco.error.AlfrescoRuntimeException: 02300066 Bootstrap failed
      at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:361)

      ......

      Caused by: org.springframework.dao.DuplicateKeyException: SqlMapClient operation; SQL [];
      — The error occurred while applyi
      11:55:51,600 INFO [STDOUT] ng a parameter map.
      — Check the alfresco.node.insert_Node-InlineParameterMap.
      — Check the statement (update failed).
      — Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "alf_node_pkey"; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
      — The error occurred while applying a parameter map.
      — Check the alfresco.node.insert_Node-InlineParameterMap.
      — Check the statement (update failed).
      — Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "alf_node_pkey"
      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)
      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
      at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)
      at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:364)
      at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.insertNode(NodeDAOImpl.java:278)
      at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.newNodeImpl(AbstractNodeDAOImpl.java:966)
      ... 164 more
      Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
      — The error occurred while applying a parameter map.
      — Check the alfresco.node.insert_Node-InlineParameterMap.
      — Check the statement (update failed).
      — Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "alf_node_pkey"
      at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)
      at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:393)
      at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
      at org.springframework.orm.ibatis.SqlMapClientTemplate$8.doInSqlMapClient(SqlMapClientTemplate.java:366)
      at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)
      ... 167 more
      Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "alf_node_pkey"
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

      After speaking with Jose Portillo he informed me that this was the same customer that had migrated from mySQL to PostgreSQL while on 3.1.1 (ALF-7896)

      Could this be rooted in a bad migration?

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs
                  Reporter:
                  stanley.arnold Stanley Arnold (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel