Migration Problem 3.0.0b to 3.4d 'Duplicate entry'

olafprecht — Tue, 31 May 2011 10:24:20 GMT

We have trouble with the alfresco migration by one of our customersWe updated from 3.0.0b to 3.4dDue to the automatic migration-process while the first start of the tomcat with the new version, we get following log-output. the alfresco didn't start, and is not reachable over the web-frontend.It seem

Re: Migration Problem 3.0.0b to 3.4d 'Duplicate entry'

olafprecht — Tue, 31 May 2011 14:54:44 GMT

The Problem was in the Update-Script.

The INSERT-Statement beginning in Line 254 runs more than once, depending of the amount of data-rows (that was the reason, the error occured only at one customer)

The where-Clause has an "OR"-Part and it wasn't put in parentheses.

Accordng to the svn, there was already a fix from "davew" on 11.04.2011, which wasn't part of our Installation

New Code:


INSERT INTO t_alf_node_aspects
   (
      node_id, qname_id
   )
   SELECT
      na.node_id,
      qname_id
   FROM
      alf_node_aspects na
      JOIN alf_qname qn ON (na.qname_id = qn.id)
      JOIN alf_namespace ns ON (qn.ns_id = ns.id)
   WHERE
      (ns.uri != 'http://www.alfresco.org/model/system/1.0' OR
      qn.local_name != 'referenceable')
      AND na.node_id >= ${LOWERBOUND} AND na.node_id <= ${UPPERBOUND}
;
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

topic Migration Problem 3.0.0b to 3.4d 'Duplicate entry' in Alfresco Archive

Migration Problem 3.0.0b to 3.4d 'Duplicate entry'

Re: Migration Problem 3.0.0b to 3.4d 'Duplicate entry'