[OPEN-ILS-GENERAL] Problem with upgrade script 2.12.6-3.0.0 on line 6839

[Václav Jansa]

Hello Evergreeners,
we are just trying to update our last production Evergreen installation 
(from 2.12 to 3.1), two are done without any issues, but with last one 
we encountered following error during first update step (2.12.6-3.0.0)

psql:version-upgrade/2.12.6-3.0.0-upgrade-db.sql:6839: ERROR:  runtime error: file unknown-55cee649a7a0 element attribute
xsl:attribute: Cannot add attributes to an element if children have been already added to the element.
  at line 31.
CONTEXT:  PL/Perl function "oils_xslt_process"
PL/pgSQL function authority.extract_headings(text,integer[]) line 36 at assignment
PL/pgSQL function authority.simple_heading_set(text) line 77 at FOR over SELECT rows
PL/pgSQL function authority.indexing_ingest_or_delete() line 46 at FOR over SELECT rows
psql:version-upgrade/2.12.6-3.0.0-upgrade-db.sql:6841: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.12.6-3.0.0-upgrade-db.sql:6842: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.12.6-3.0.0-upgrade-db.sql:6843: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.12.6-3.0.0-upgrade-db.sql:6844: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.12.6-3.0.0-upgrade-db.sql:6850: ERROR:  current transaction is aborted, commands ignored until end of transaction block



I already try to check authority related scripts, but from my point of 
view, error is somewhere in our authority data in DB.

Anybody else having the same experience? Do you have any idea how to 
find out what is causing the error?

Do you have any tip, how to ad some debugging code into standard code, 
what will help us with finding probably failed data?


Thanks for help and all recommendations

Best regards

Vaclav Jansa

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4492 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20180817/f86882d2/attachment.bin>