[Archivesspace_Users_Group] Database migration error for 3.3.1 to 3.4.0 during database-setup script run

[Kirk Manegold]

Hello.

I ran through our typical update process from 3.3.1 to 3.4.0 and hit a snag with the setup-database.sh script.  I keep getting an duplicate entry  error:

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    !!                                                                                                !!
    !!                                      Database migration error.                                 !!
    !!                                  Your upgrade has encountered a problem.                       !!
    !!                  You must resolve these issues before the database migration can complete.     !!
    !!                                                                                                !!
    !!                                                                                                !!
    !!                                                Error:                                          !!
    !! Java::JavaSql::SQLIntegrityConstraintViolationException: Duplicate entry '1-Interviewer' for key 'enumeration_value.enumeration_value_uniq'
    !!                                                                                                !!
    !!                                                                                                !!
    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I dug through the enumeration_value table and updated the values with 'Interviewer' with unique values (e.g. I added an increment number to them) for the enumeration_id of '1'.  However, I can't get past this error.  Any ideas?

-Kirk



Kirk Manegold
System Architect
ASU Library | Technology Services | Systems & Security

Arizona State University
Mail Code: 1006
Charles T. Hayden Library
Tempe, AZ 85287-1006

p: 480-965-6230<tel:480-965-6230>
email: manegold at asu.edu<mailto:manegold at asu.edu>
web: https://lib.asu.edu/systems/help

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230808/77a0c063/attachment.html>