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

[Václav Jansa]

Hello Evergreeners,



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










Thanks for help and all recommendations

Best regards

Vaclav Jansa

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) 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?

smime.p7s
Description: S/MIME Cryptographic Signature