[Koha] DB errors during upgrade from 3.18.09 to 3.20.04

[Bortel, Gary]

I, too, am seeing these two MySQL errors (1060 & 1062) thrown when trying to update from 3.18.11 --> 3.18.12. There never seemed to be a resolution posted to this issue. Is it benign as Doug suggested or something about which concern should be raised?

The installation here is Ubuntu 14.04.3 with a package install of Koha.

.
.
.
.
Upgrading database schema for abc
Upgrade to 3.18.11.001
Done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences)
Upgrade to 3.18.12.000
Done (3.18.12.000 release)
DEV atomic update: hourlyloans.sql
C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/hourlyloans.sql:
ERROR 1060 (42S21) at line 1: Duplicate column name 'lengthunit'
DEV atomic update: oai_sets.sql
C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/oai_sets.sql:
ERROR 1062 (23000) at line 35: Duplicate entry 'OAI-PMH:AutoUpdateSets' for key 'PRIMARY'
Upgrading database schema for xyz
Upgrade to 3.18.11.001
Done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences)
Upgrade to 3.18.12.000
Done (3.18.12.000 release)
DEV atomic update: hourlyloans.sql
C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/hourlyloans.sql:
ERROR 1060 (42S21) at line 1: Duplicate column name 'lengthunit'
DEV atomic update: oai_sets.sql
C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/oai_sets.sql:
ERROR 1062 (23000) at line 35: Duplicate entry 'OAI-PMH:AutoUpdateSets' for key 'PRIMARY'
.
.
.
.


Thanks
gcb


> While doing a upgrade on our test koha instance (based on a copy of
> production), I received the following errors.:
>
>    - [Sat Oct 24 23:52:23 2015] updatedatabase.pl: C4::Installer::load_sql
>    returned the following errors while attempting to load
>    /home/koha/koha-test/intranet/cgi-bin/installer/data/mysql/atomicupdate/hourlyloans.sql:
>    - [Sat Oct 24 23:52:23 2015] updatedatabase.pl: ERROR 1060 (42S21) at
>    line 1: Duplicate column name 'lengthunit'
>    - [Sat Oct 24 23:52:23 2015] updatedatabase.pl: C4::Installer::load_sql
>    returned the following errors while attempting to load
>    /home/koha/koha-test/intranet/cgi-bin/installer/data/mysql/atomicupdate/oai_sets.sql:
>    - [Sat Oct 24 23:52:23 2015] updatedatabase.pl: ERROR 1062 (23000) at
>    line 35: Duplicate entry 'OAI-PMH:AutoUpdateSets' for key 'PRIMARY'
>
> I know from previous experience that these kinds of error are sometimes
> benign, but I would like some feedback on whether I need to take any kind
> of action in this particular case.
>
> Thanks,
>   -Doug-