<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body>
    <p>Hi Guntis,</p>
    <p>So to confirm, are you trying to run &quot;epadmin upgrade&quot; against a
      database running on MySQL 4.1.22 or is the database now running on
      a more up to date version of MySQL or MariaDB?&nbsp; If not I would
      export and reimport to a more recent version of MySQL before
      trying the upgrade, as I suspect that version of MySQL may not
      support the upgrade operations that EPrints 3.3.16 needs to
      perform.</p>
    <p>The &quot;Upgrading rindex and grep tables for subject&quot; is still down
      to a foreign key constraint which I am surprised to see once you
      have set the flag as I suggested.&nbsp; One thing you could do to get a
      better idea of what is going wrong in to temporarily turn on MySQL
      debug that will log all the queries being run.&nbsp; This can be done
      by editing line 112 of perl_lib/EPrints/Database.pm to:</p>
    <p>my $DEBUG_SQL = 1;<br>
    </p>
    <p>Where previous the value would have been set to 0.&nbsp; This will
      create a lot of noise when you run &quot;epadmin upgrade&quot; but it should
      allow you to spot the specific query that has an issue (i.e. the
      last one before the script fails).&nbsp; It may be worth trying to run
      the failed last SQL query again from the MySQL command to get out
      a specific error message, as it looks like this gets masked by the
      epadmin script.</p>
    <p>If you are planning on upgrading to EPrints 3.4.2.&nbsp; I would
      recommend getting a completely default install of this working
      first, then add your old archive into the archives directory and
      follow the instructions for upgrading to 3.4.x at:</p>
    <p><a class="moz-txt-link-freetext" href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.eprints.org%2Fw%2FUpgrading_3.3.12%252B_to_3.4&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623321356%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=7Gc4L8UzHqBZdmKGKaQXwlI4FR5Vii9bk3lswkoLOnI%3D&amp;reserved=0" originalSrc="https://wiki.eprints.org/w/Upgrading_3.3.12%2B_to_3.4" shash="FAcvBQ249suVeMC3qR12wAJh51zIVqKax26t5WGuUc+A4UaLw3q+szDOxLJ7BoZOlIiFDfkGzTOt0XytWZHmS3w84HjIsAdsgjuXDPTPovQ4N2D2IS0QuOYglwUBcmPRxCvUpPlbcDFABm4V/tSbygRWEqDHo2+Cu6C/mpStXQ4=">https://wiki.eprints.org/w/Upgrading_3.3.12%2B_to_3.4</a></p>
    <p>and possible also upgrade instructions for 3.1 to 3.2 and 3.2 to
      3.3 at:</p>
    <a class="moz-txt-link-freetext" href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.eprints.org%2Fw%2FUpgrading_from_3.1&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623331314%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=A7ub7Clk2PE6NCe8avADf0li4kcbcd4Y3fYhBU1VP0I%3D&amp;reserved=0" originalSrc="https://wiki.eprints.org/w/Upgrading_from_3.1" shash="plStbD+LjAwSW1e2+zhh/ipJ0GmL/gYAHzSzzgCF5v1ros04nGTNHtncwDGv4XstFYB4pPiyTmzmpYAT6kMfKUdjP40oEDVqQVBOjR3wD21gBXByQWXlvduxEixc3/LMOKC1ceMwdrsubOIwEyHUbw5kGpRA6R85VHw0tJRYFw4=">https://wiki.eprints.org/w/Upgrading_from_3.1</a><br>
    <a class="moz-txt-link-freetext" href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.eprints.org%2Fw%2FUpgrading_from_3.2&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623331314%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=FyrNTw535El0%2FJhBx6Qy%2BHBQ3Ex9xDovIFap42nUJ5g%3D&amp;reserved=0" originalSrc="https://wiki.eprints.org/w/Upgrading_from_3.2" shash="esOAImQNftYbAtJTbxIy1cg9J1XxYaQHbMDrRMIeI5ZEWeVz4Em0yKNUIWBKD8oHq/otd+7QlqDWwAcQY6ELvTW4PjF3L2KmNLtx3fLdVR4SI1sAYrBmRenf53WKN332QAgSJGutqS2MJrKFYU2OTNox9CAH/rVRyUtQyBvEtzY=">https://wiki.eprints.org/w/Upgrading_from_3.2</a><br>
    <p>I would advise getting your archive's configuration working so
      you can create a new empty EPrints database rather than
      immediately trying to get it working with your old database and
      upgrading it.&nbsp; By creating a new database and checking the your
      repository works OK in a web browsers you can be failry confident
      this part is correct.&nbsp; Then you can import your old database
      update the database.pl configuration to point at it an drun
      &quot;epadmin upgrade&quot; knowing that if there are issues it is due to
      the database rather than your EPrints configuration.</p>
    <p>Regards</p>
    <p>David Newman<br>
    </p>
    <p><br>
    </p>
    <div class="moz-cite-prefix">On 17/01/2021 15:38, Guntis Zelvis via
      Eprints-tech wrote:<br>
    </div>
    <blockquote type="cite" cite="mid:EMEW3|10b3b33a9542bb485cbee2cb96473217x0GFdf14eprints-tech-bounces|ecs.soton.ac.uk|CAEBFXm7mT7XCuyZZdqW=qYJf3Rb4RdrnLq2BQ5XXcV43T+dc6A@mail.gmail.com">
      
      <div style="padding-bottom: 10px; padding-top: 5px;">
        <div style="padding:12px; border:1px solid #8D3970;
          background-color:#F7F9FA; color:#8D3970; font-size:14px;
          line-height:22px; font-family: Calibri, Arial, Helvetica,
          sans-serif;">
          <strong>CAUTION:</strong> This e-mail originated outside the
          University of Southampton.
        </div>
      </div>
      <div>
        <div dir="ltr">David, thanks for advice. This removed most
          errors related to foreign key constraints. Just one remained:
          <div><br>
          </div>
          <div>Upgrading rindex and grep tables for subject<br>
            DBD::mysql::db do failed: Error on rename of
            './scireldiaprints/#sql-10710_48' to
            './scireldiaprints/subject__rindex' (errno: 150) at
            /usr/share/eprints/bin/../perl_lib/EPrints/Database.pm line
            3052, &lt;STDIN&gt; line 1.<br>
            SQL ERROR (do): ALTER IGNORE TABLE subject__rindex MODIFY
            field VARCHAR(64) CHARACTER SET UTF8, MODIFY word
            VARCHAR(128) CHARACTER SET UTF8, DEFAULT CHARACTER SET UTF8,
            DROP PRIMARY KEY, ADD PRIMARY KEY(field,word,`subjectid`),
            DROP KEY `subject__rindex_subjectid_2`<br>
            SQL ERROR (do): Error on rename of
            './scireldiaprints/#sql-10710_48' to
            './scireldiaprints/subject__rindex' (errno: 150) (#1025)<br>
          </div>
          <div><br>
          </div>
          <div>However, the main problem that stops upgrade script
            remains:</div>
          <div><br>
          </div>
          <div>Upgrading dataset metafield<br>
            <br>
------------------------------------------------------------------<br>
            ---------------- EPrints System Error
            ----------------------------<br>
------------------------------------------------------------------<br>
            An unexpected error occurred while attempting to convert
            tables to UTF-8.<br>
            <br>
------------------------------------------------------------------<br>
            EPrints System Error inducing stack dump<br>
            &nbsp;at /usr/share/eprints/bin/../perl_lib/EPrints.pm line 147,
            &lt;STDIN&gt; line 1.<br>
            &nbsp; &nbsp; &nbsp; &nbsp; EPrints::abort() called at
            /usr/share/eprints/bin/epadmin line 2753<br>
            &nbsp; &nbsp; &nbsp; &nbsp;
            main::upgrade_mysql_charset('EPrints::Repository=HASH(0x13dec90)',
            'EPrints::Database::mysql=HASH(0x408a3b8)') called at
            /usr/share/eprints/bin/epadmin line 3008<br>
            &nbsp; &nbsp; &nbsp; &nbsp;
            main::upgrade_3_1_2_to_3_2_0('EPrints::Repository=HASH(0x13dec90)',
            'EPrints::Database::mysql=HASH(0x408a3b8)') called at
            /usr/share/eprints/bin/epadmin line 2887<br>
            &nbsp; &nbsp; &nbsp; &nbsp; main::upgrade('scireldiaprints') called at
            /usr/share/eprints/bin/epadmin line 320<br>
          </div>
          <div><br>
          </div>
          <div>And, yes. This is very old version of ePrints (3.1.3) as
            well as underlaying MySQL version (4.1.22). Now I am
            researching upgrade path to ePrints 3.4.2 on MariaDB 5.5.68.</div>
          <div><br>
          </div>
          <div>Guntis</div>
          <div><br>
          </div>
        </div>
        <br>
        <div class="gmail_quote">
          <div dir="ltr" class="gmail_attr">On Sat, Jan 16, 2021 at 8:37
            PM David R Newman &lt;<a href="mailto:drn@ecs.soton.ac.uk" moz-do-not-send="true">drn@ecs.soton.ac.uk</a>&gt; wrote:<br>
          </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px
            0.8ex;border-left:1px solid
            rgb(204,204,204);padding-left:1ex">
            <div>
              <p>Hi Guntis,</p>
              <p>This looks to be down to foreign key constraints.&nbsp; As
                you are trying to upgrade from a version of EPrints that
                is over 12 years ago, I cannot know whether this was a
                known issue at the time or just some quirk of running an
                very old EPrints database schema in what may be a rather
                more recent version of MySQL.&nbsp; <br>
              </p>
              <p>Assuming that you have suitables backups of the
                database so you can roll back if things go wrong, I
                would recommend temporarily adding the following line to
                perl_lib/EPrints/Database/<a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmysql.pm%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623331314%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=W3m4QIumkW7DqyjtyZynMtHyCWtap2ekbvG3N3Qlsvo%3D&amp;reserved=0" originalSrc="http://mysql.pm/" shash="vi2G6DEbPmfBxUPVv93NI2T5UMN91RzwebQ4UmLNXSxzIxm6Nw66uTG+E1LN4CqVwz3S/9qtI0pCgSVPHbiWp3gJz7L8eVlpnELdF/391IdksiSMyXUhh6uL9ojUiKWqvCgqat+QssPRmYWiRHB2cGKAGbJn4SYGVSqAb2wNUqU=" originalsrc="http://mysql.pm/" shash="txR38MUhCshGyuoIUfcTGlPy1VATelYvzHJ0Aohps1FWycYc5JkZ9GUgaVT1O9zVDC/cJumVHKmdoPQ8qtKYXYDhqMX+/F+npHRLOq76ZAF6Qrel78jNC4Zn3ljjK9iBl01Y27/XiqGWYaGr0i6RlbhBmM8LG1BU2tAA2Q9PlBk=" target="_blank" moz-do-not-send="true">mysql.pm</a>
                (for EPrints 3.3.16) after line 243:</p>
              <pre><code><span>                $self-&gt;do('SET</span> foreign_key_checks = <span>0</span>;');
</code></pre>
              <div>This should allow you to run the upgrade script
                without getting any errors like you previously
                reported.&nbsp; However, once you have hopefully run epadmin
                upgrade successfully you should immediately remove this
                line from
                <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmysql.pm%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623341270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=QnVh0dzEPLMU81pqKvOH8GMYwvVbqPkqqHI97mPGQYo%3D&amp;reserved=0" originalSrc="http://mysql.pm/" shash="gEFpECaCrLLP1/MZf1Lx06U97myt4NuJ4Vx/AcodaJYDxG8ZGm4FA3axkyxAHpB/psI6Mfs6GPAzmJCYk8Os7INwStmr3l2wJhUbjZehgIeXDfjGWVDM9Oooz4sTD/nvpa2ZGM/j62AVdY8lzv484PVcR3WUFj4Pn10AEe7lF6g=" originalsrc="http://mysql.pm/" shash="hZR49NJuPdXGuZG+164TtuILijbVoXTKmgkz0OjGj8JEA5U0E4ZINmaN3KUXlGblHkrLBu+34h58d0ClE0n/AgLcHg1o3aPr9cZGvyCsLwmvp/TkB1KgbDSm5OLHnKjWYjLY/t2wFsu8PbROBZTrn7i/+Z4L25DjoUlAi23SReY=" target="_blank" moz-do-not-send="true">mysql.pm</a>.&nbsp;
                This temporary change should allow the upgrade script to
                tinker with the database schema without having to worry
                about foreign keys constraints being temporarily
                broken.&nbsp; Hopefully, by the time it finishes the database
                schema will be fully upgraded but there will not be any
                foreign key constraint issues still present.<br>
              </div>
              <div><br>
              </div>
              <div>I am not sure whether the issues you had from you
                first run of &quot;epadmin upgrade&quot; will have left the
                database in an inconsistent state, so it may be worth
                restoring the database from a backup be re-running
                &quot;epadmin upgrade&quot; with the change I have suggested to <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmysql.pm%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623341270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=QnVh0dzEPLMU81pqKvOH8GMYwvVbqPkqqHI97mPGQYo%3D&amp;reserved=0" originalSrc="http://mysql.pm/" shash="gEFpECaCrLLP1/MZf1Lx06U97myt4NuJ4Vx/AcodaJYDxG8ZGm4FA3axkyxAHpB/psI6Mfs6GPAzmJCYk8Os7INwStmr3l2wJhUbjZehgIeXDfjGWVDM9Oooz4sTD/nvpa2ZGM/j62AVdY8lzv484PVcR3WUFj4Pn10AEe7lF6g=" originalsrc="http://mysql.pm/" shash="hZR49NJuPdXGuZG+164TtuILijbVoXTKmgkz0OjGj8JEA5U0E4ZINmaN3KUXlGblHkrLBu+34h58d0ClE0n/AgLcHg1o3aPr9cZGvyCsLwmvp/TkB1KgbDSm5OLHnKjWYjLY/t2wFsu8PbROBZTrn7i/+Z4L25DjoUlAi23SReY=" target="_blank" moz-do-not-send="true">mysql.pm</a>.</div>
              <div><br>
              </div>
              <div>Let me know how it goes.&nbsp; I may be able to help if
                you still have problems but I have really much worked
                with EPrints prior to 3.2.&nbsp; There may be some veterans
                on the list that may know more about known issues
                upgrading from 3.1.x to 3.3.</div>
              <div><br>
              </div>
              <div>Regards</div>
              <div><br>
              </div>
              <div>David Newman<br>
              </div>
              <div><br>
              </div>
              <div>On 16/01/2021 18:01, Guntis Zelvis via Eprints-tech
                wrote:<br>
              </div>
              <blockquote type="cite">
                <pre>CAUTION: This e-mail originated outside the University of Southampton.

Hello! I am trying to migrate EPrints v3.1.2 to the latest version. As
I understand it is impossible to migrate straight to v3.4.2, so first
I try to install v3.3.16 and upgrade repository to this version, but
there is few errors in output of 'epadmin upgrade REPOID'

Added dataset upload_progress
DBD::mysql::db do failed: Can't create table 'REPOID.#sql-10710_38'
(errno: 150) at /usr/share/eprints/bin/../perl_lib/EPrints/Database.pm
line 3052, &lt;STDIN&gt; line 1.
SQL ERROR (do): ALTER TABLE `subject_name_sortvalue` ADD CONSTRAINT
`subject_name_sortvalue_fk` FOREIGN KEY(`subjectid`) REFERENCES
`subject`(`subjectid`) ON DELETE CASCADE
SQL ERROR (do): Can't create table 'REPOID.#sql-10710_38' (errno: 150) (#1005)

Later there is:

Upgrading dataset file
Upgrading `file` by insertion
DBD::mysql::db do failed: Cannot delete or update a parent row: a
foreign key constraint fails at
/usr/share/eprints/bin/../perl_lib/EPrints/Database.pm line 3052,
&lt;STDIN&gt; line 1.
SQL ERROR (do): DROP TABLE IF EXISTS `old_file`
SQL ERROR (do): Cannot delete or update a parent row: a foreign key
constraint fails (#1217)

Upgrading dataset upload_progress
Upgrading `upload_progress` by insertion
DBD::mysql::db do failed: Cannot delete or update a parent row: a
foreign key constraint fails at
/usr/share/eprints/bin/../perl_lib/EPrints/Database.pm line 3052,
&lt;STDIN&gt; line 1.
SQL ERROR (do): DROP TABLE IF EXISTS `old_upload_progress`
SQL ERROR (do): Cannot delete or update a parent row: a foreign key
constraint fails (#1217)

Upgrading rindex and grep tables for subject
DBD::mysql::st execute failed: Table 'REPOID.subject__rindex' doesn't
exist at /usr/share/eprints/perl_lib/EPrints/Database/<a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmysql.pm%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623351226%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=Mg02jEaF4%2BJ7TykSynCQyXijy%2Fy8VP12nWukNP2Iuo0%3D&amp;reserved=0" originalSrc="http://mysql.pm/" shash="seYTWbQKT34kJAxNK1T+2qzdi3vC0SAtQbE52byVYi249T9bYi3X3diPmD3AqHE/gBKXdqk7TbQ/z7pOpX7j2CFWebMvlfqveCHDaayJwEIWRhl0Mv3GguFIiEAz7A4MTyMZ5Y8prSi5wuf/anyFnDvlX1m+9y7zfaJmPeGVQiQ=" originalsrc="http://mysql.pm/" shash="celWlXvO7DGwh6IHBET59C94P6nQDgQTCAwRuXAZ57DTWJQWDbpXcbJmxunKa3EzWXEBYmc28X+pJEzPrt7skkfOGVlVxa+D31JvGQVoe/hGpCp2tw7HRzFjxCDUDyKorIxOJRBgQpbcPwErg8Noz5a7UB0P2/F3kvZiEuLWjew=" target="_blank" moz-do-not-send="true">mysql.pm</a> line
423, &lt;STDIN&gt; line 1.
DBD::mysql::st fetch failed: fetch() without execute() at
/usr/share/eprints/perl_lib/EPrints/Database/<a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmysql.pm%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623351226%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=Mg02jEaF4%2BJ7TykSynCQyXijy%2Fy8VP12nWukNP2Iuo0%3D&amp;reserved=0" originalSrc="http://mysql.pm/" shash="seYTWbQKT34kJAxNK1T+2qzdi3vC0SAtQbE52byVYi249T9bYi3X3diPmD3AqHE/gBKXdqk7TbQ/z7pOpX7j2CFWebMvlfqveCHDaayJwEIWRhl0Mv3GguFIiEAz7A4MTyMZ5Y8prSi5wuf/anyFnDvlX1m+9y7zfaJmPeGVQiQ=" originalsrc="http://mysql.pm/" shash="Wsd/4QXE0UhXF5MCwuNVxtllOqpX7GgmG6VG3Lroi+RuuAkz0/dn+2ObEStorwoeleNdxS+PCxYuVYJa28MeGrUmosBLxEgl3hwXrSCRaFDcAOrvyToPKY+U6T0cahq8NURvt03inIKFvhR9D6H8JnPjsWv4T9YCzo6p4NOXkjE=" target="_blank" moz-do-not-send="true">mysql.pm</a> line 426,
&lt;STDIN&gt; line 1.
DBD::mysql::st execute failed: Table 'REPOID.subject__rindex' doesn't
exist at /usr/share/eprints/bin/epadmin line 2769, &lt;STDIN&gt; line 1.
DBD::mysql::st fetch failed: fetch() without execute() at
/usr/share/eprints/bin/epadmin line 2770, &lt;STDIN&gt; line 1.
DBD::mysql::db do failed: Table 'REPOID.subject__rindex' doesn't exist
at /usr/share/eprints/bin/../perl_lib/EPrints/Database.pm line 3052,
&lt;STDIN&gt; line 1.
SQL ERROR (do): ALTER IGNORE TABLE subject__rindex MODIFY field
VARCHAR(64) CHARACTER SET UTF8, MODIFY word VARCHAR(128) CHARACTER SET
UTF8, DEFAULT CHARACTER SET UTF8, ADD PRIMARY
KEY(field,word,`subjectid`)
SQL ERROR (do): Table 'REPOID.subject__rindex' doesn't exist (#1146)

And everything stops here:
Upgrading dataset metafield

------------------------------------------------------------------
---------------- EPrints System Error ----------------------------
------------------------------------------------------------------
An unexpected error occurred while attempting to convert tables to UTF-8.

------------------------------------------------------------------
EPrints System Error inducing stack dump
 at /usr/share/eprints/bin/../perl_lib/EPrints.pm line 147, &lt;STDIN&gt; line 1.
        EPrints::abort() called at /usr/share/eprints/bin/epadmin line 2753
        main::upgrade_mysql_charset('EPrints::Repository=HASH(0xb9fc80)',
'EPrints::Database::mysql=HASH(0x384b458)') called at
/usr/share/eprints/bin/epadmin line 3008
        main::upgrade_3_1_2_to_3_2_0('EPrints::Repository=HASH(0xb9fc80)',
'EPrints::Database::mysql=HASH(0x384b458)') called at
/usr/share/eprints/bin/epadmin line 2887
        main::upgrade('REPOID') called at
/usr/share/eprints/bin/epadmin line 320

How to fix these errors and complete repository upgrade?

*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" target="_blank" moz-do-not-send="true">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623351226%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=KcqzNJWFO%2B%2BcAx05LtSaznhMy7Iv62k8NkyR%2F%2FmELXc%3D&amp;reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="Cc76RZsbQSf2ToJikeW6UyYv/V2mut8eOJ/NW/7adUA0NicktUvfigsDGSpweklyfUmp5aWl9qa4Sxa2rj7/WE1YYTU3QCn2I3FdrSajkpExkpW3aRR1NfgaiMYYkWOuA1P7QmkVe72X28b045J1IWNZlB/g+PcXEGCZaka+xic=" originalsrc="http://www.eprints.org/tech.php/" shash="gU2mMQZZ5THc6cCKi4m3VI0xfFXhSw4hQzPJqyMEJRORqFO9cJZE6RSU26tFB7ra1q4HtV5IxVIEd0eemurJbZhzBWop+u4Is2OAbAJxn7SvnX3Y4VBCA1J2T//EYzObMQ6FnNpqTiNzx1cvmsmFctpJQMcftGfAB+hX0fBIxig=" target="_blank" moz-do-not-send="true">https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;amp;data=04%7C01%7Cdrn%40ecs.soton.ac.uk%7C80641a7b0bb64e32af1808d8ba494561%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464171151379183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;amp;sdata=HhJbYby71iR6yf1Dz2kJu5kBgLpM%2BSxmur8JA5VV75Q%3D&amp;amp;reserved=0</a>
*** EPrints community wiki: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623361182%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=wGNddyWkrAzp%2BPgkjDhVbg1obzn1N9Zn5cBxNYMT488%3D&amp;reserved=0" originalSrc="http://wiki.eprints.org/" shash="VnqgcjNXirbInz+IULYK+DQ4n2/xNlUxkfxXZrPWwVXAKP9rd0m5DTRSfdysBBYuirUCeWROeQSc2i36R2CiNaKnyiHu4vhbLzvk1XW7pTI/8+ydOYfme8YGFrTM19I1CENYrm6OTv5BaVbMuJu6mskpa9lAD3/gtePFj1QaCTE=" originalsrc="http://wiki.eprints.org/" shash="BzMLBlMF6pHgR6VbHEAvR19alFB5YVxzl3OckL4DTEoI2JQs5N7dsrHljHbk9fUFL0AcPIdnKzPa2qGDEkVgalEVURGpL45qfRy/ULug6ASAOZwxQz2SQhFSly4tNyHDgql5ibejC3TbRAQCV1og8dijlMW2cUdwYxP38CKg4a0=" target="_blank" moz-do-not-send="true">https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;amp;data=04%7C01%7Cdrn%40ecs.soton.ac.uk%7C80641a7b0bb64e32af1808d8ba494561%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464171151379183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;amp;sdata=RrZj2YwOClqbT8Q8Act3TtVAUim5cof4MzIVMxtHyLo%3D&amp;amp;reserved=0</a>
</pre>
              </blockquote>
              <div id="gmail-m_-6312468162313403187DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
                <table style="border-top:1px solid rgb(211,212,222)">
                  <tbody>
                    <tr>
                      <td style="width:55px;padding-top:13px"><a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.avg.com%2Femail-signature%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623361182%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=dfvdZfm1cXQXJVgll2vaybdU9ODMW%2BApwmgIG8eiNEA%3D&amp;reserved=0" originalSrc="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" shash="yhC7D29mlP47s8smYGO/7bxts/Cu1dYfvmOqKePybSRrdRYt0KLQS+FxwbnPfqI2xEnrWAujP0biuPW9+wQC59zX11ycDNFj/F0gziB3RBbt4Kf1hYNNlRUckuKKqb9puR2uNpjBpO42IDq3Pi+ofnYHkoRtlKfrvvmt84dWcY0=" originalsrc="http://www.avg.com/email-signature?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=emailclient" shash="HHW1HIKJqTScvVmfKx1s4jNdJJMtxUxUG8HOabysKgFSXweFUXF+jt5x3UcXqMFZ6CyKt/4xyxA2Mz/1v3354ATFN8thib5Ia5X2JJlh4SXuEG8p+dcH1hIzCVbADMieh7CCE44q8tTTHitb4r+10CxC72TG8inWc6MKIMAqqSM=" target="_blank" moz-do-not-send="true"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" alt="" style="width: 46px; height: 29px;" moz-do-not-send="true" width="46" height="29"></a></td>
                      <td style="width:470px;padding-top:12px;color:rgb(65,66,78);font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free.
                        <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.avg.com%2Femail-signature%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623371129%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=7fVCCKyxJZTAwikgql%2BhAwcsEKGEiduCaxV8TEOdzmQ%3D&amp;reserved=0" originalSrc="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" shash="zFzSWJ+Dv5xjE5I3+oWzs1MOb4X0zyzleSaDIskkdFAzDpjD1PR1mj+YIaRMt5PcxOtCdR3reACh7qQR76VqYBIQPqkrKQwJfK8UM+snyHqIESbANkLCv+crFK8CB+cC4Be/1faW/n0i3jgrBCcFWHpr3Z1nbQZLkvAc0JpOe9A=" originalsrc="http://www.avg.com/email-signature?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=emailclient" shash="jRqQPIvl/BQlLtYwNn0nne78aOx+mciqoB2S3zWdESOSQjlcHeq1jTnxCqQnaAXhnQdNq6jrmHOVnmIladC4cQLYjiLqiqW8u62/QAkXVAbd/rwcJRa2oV+69n1ZV2KxAWVApttoRL6mC1RFdIqU31ZhQNBJ8cfatldgayax+Fo=" style="color:rgb(68,83,234)" target="_blank" moz-do-not-send="true">
                          www.avg.com</a> </td>
                    </tr>
                  </tbody>
                </table>
              </div>
            </div>
          </blockquote>
        </div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">*** Options: <a class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a class="moz-txt-link-freetext" href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623371129%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=EfaQFeIA3eXlORAIxWbglxgKs0vqk%2FT7Uh%2FRFYusnI4%3D&amp;reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="Fin3IWFFa/lfnhChF+N/uX6HoVx6ui6wsgLR39gAPtXLBpMX+OLQcHrxZ/i29KR01XnMzDlVLlmtg2fpfXgFxTnDek45fuWgQ/TJWka/Ni69Jv41xYpyYGnUXutGZ2uuUwUjJvUjZkvivRC5V3bX42JX7rWTqYWrQBNkxbBSLOk=">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a class="moz-txt-link-freetext" href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C5efd399318d1471dedbf08d8bb02eea9%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464968623381094%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=Z6hGIDR17gXk9qG3K3uLHfBaPFl4Q2rc6RhJwFfPuC8%3D&amp;reserved=0" originalSrc="http://wiki.eprints.org/" shash="XkYW9oxiljDoD/pTahTc3V3MUtpvL8hBtwtE5jw0JhvfYE7u2buEdq0bxS1y3ympZsyYkONDrHEKc3wUEjaaxktVUxKNRt6qZ8gh3At5wqi+budwNnpyaKvHgxWi7r05p7Esz31Fk1St0azyPVTMytED/bgg5nePPn5Ad5k2f4o=">http://wiki.eprints.org/</a></pre>
    </blockquote>
  </body>
</html>