Hello!
I have a 7.5 server updated from 5.4.
The database update process finished OK.
But the index-discovery fails.
2023-03-20 09:24:03.611 INFO index-discovery - 4 @ The script has started
2023-03-20 09:24:03.611 INFO index-discovery - 4 @ Updating Index
2023-03-20 09:24:43.049 ERROR index-discovery - 4 @ null
2023-03-20 09:24:43.050 ERROR index-discovery - 4 @ java.lang.IllegalArgumentException: More than one result found
at org.dspace.core.AbstractHibernateDAO.uniqueResult(AbstractHibernateDAO.java:242)
at org.dspace.content.dao.impl.WorkspaceItemDAOImpl.findByItem(WorkspaceItemDAOImpl.java:81)
at org.dspace.content.WorkspaceItemServiceImpl.findByItem(WorkspaceItemServiceImpl.java:243)
at org.dspace.content.ItemServiceImpl.getParentObject(ItemServiceImpl.java:1408)
at org.dspace.content.ItemServiceImpl.getParentObject(ItemServiceImpl.java:92)
at org.dspace.discovery.SolrServiceResourceRestrictionPlugin.additionalIndex(SolrServiceResourceRestrictionPlugin.java:129)
at org.dspace.discovery.indexobject.IndexFactoryImpl.buildDocument(IndexFactoryImpl.java:67)
at org.dspace.discovery.indexobject.InprogressSubmissionIndexFactoryImpl.buildDocument(InprogressSubmissionIndexFactoryImpl.java:51)
at org.dspace.discovery.indexobject.WorkspaceItemIndexFactoryImpl.buildDocument(WorkspaceItemIndexFactoryImpl.java:63)
at org.dspace.discovery.indexobject.WorkspaceItemIndexFactoryImpl.buildDocument(WorkspaceItemIndexFactoryImpl.java:30)
at org.dspace.discovery.SolrServiceImpl.update(SolrServiceImpl.java:169)
at org.dspace.discovery.SolrServiceImpl.indexContent(SolrServiceImpl.java:159)
at org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:344)
at org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:331)
at org.dspace.discovery.IndexClient.internalRun(IndexClient.java:130)
at org.dspace.scripts.DSpaceRunnable.run(DSpaceRunnable.java:104)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)The database info
Database Type: postgres
Database URL: jdbc:postgresql://localhost:5432/dspace
Database Schema: public
Database Username: dspace
Database Software: PostgreSQL version 14.7 (Ubuntu 14.7-0ubuntu0.22.04.1)
Database Driver: PostgreSQL JDBC Driver version 42.4.3
PostgreSQL 'pgcrypto' extension installed/up-to-date? true (version=1.3)
FlywayDB Version: 8.4.4
+-----------+----------------+------------------------------------------------------------------+----------+---------------------+--------------+
| Category | Version | Description | Type | Installed On | State |
+-----------+----------------+------------------------------------------------------------------+----------+---------------------+--------------+
| | 1 | << Flyway Init >> | BASELINE | 2016-02-15 00:03:53 | Baseline |
| Versioned | 1.1 | Initial DSpace 1.1 database schema | SQL | 2016-02-15 00:03:53 | Success |
| Versioned | 1.2 | Upgrade to DSpace 1.2 schema | SQL | 2016-02-15 00:03:54 | Success |
| Versioned | 1.3 | Upgrade to DSpace 1.3 schema | SQL | 2016-02-15 00:03:54 | Success |
| Versioned | 1.3.9 | Drop constraint for DSpace 1 4 schema | JDBC | 2016-02-15 00:03:54 | Success |
| Versioned | 1.4 | Upgrade to DSpace 1.4 schema | SQL | 2016-02-15 00:03:54 | Success |
| Versioned | 1.5 | Upgrade to DSpace 1.5 schema | SQL | 2016-02-15 00:03:54 | Success |
| Versioned | 1.5.9 | Drop constraint for DSpace 1 6 schema | JDBC | 2016-02-15 00:03:54 | Success |
| Versioned | 1.6 | Upgrade to DSpace 1.6 schema | SQL | 2016-02-15 00:03:54 | Success |
| Versioned | 1.7 | Upgrade to DSpace 1.7 schema | SQL | 2016-02-15 00:03:54 | Success |
| Versioned | 1.8 | Upgrade to DSpace 1.8 schema | SQL | 2016-02-15 00:03:54 | Success |
| Versioned | 3.0 | Upgrade to DSpace 3.x schema | SQL | 2016-02-15 00:03:54 | Success |
| Versioned | 4.0 | Upgrade to DSpace 4.x schema | SQL | 2016-02-15 00:03:54 | Success |
| Versioned | 5.0.2014.08.08 | DS-1945 Helpdesk Request a Copy | SQL | 2016-02-15 00:03:54 | Success |
| Versioned | 5.0.2014.09.25 | DS 1582 Metadata For All Objects drop constraint | JDBC | 2016-02-15 00:03:54 | Success |
| Versioned | 5.0.2014.09.26 | DS-1582 Metadata For All Objects | SQL | 2016-02-15 00:03:54 | Success |
| Versioned | 5.0.2014.11.04 | Enable XMLWorkflow Migration | JDBC | 2023-03-17 21:06:14 | Success |
| Versioned | 5.6.2016.08.23 | DS-3097 | SQL | 2023-03-17 21:06:14 | Success |
| Versioned | 5.7.2017.04.11 | DS-3563 Index metadatavalue resource type id column | SQL | 2023-03-17 21:06:14 | Success |
| Versioned | 5.7.2017.05.05 | DS 3431 Add Policies for BasicWorkflow | JDBC | 2023-03-17 21:06:15 | Success |
| Versioned | 6.0.2015.03.06 | DS 2701 Dso Uuid Migration | JDBC | 2023-03-17 21:06:15 | Success |
| Versioned | 6.0.2015.03.07 | DS-2701 Hibernate migration | SQL | 2023-03-17 21:06:15 | Success |
| Versioned | 6.0.2015.08.31 | DS 2701 Hibernate Workflow Migration | JDBC | 2023-03-17 21:07:19 | Success |
| Versioned | 6.0.2015.09.01 | DS 2701 Enable XMLWorkflow Migration | JDBC | 2023-03-17 21:07:19 | Success |
| Versioned | 6.0.2016.01.03 | DS-3024 | SQL | 2023-03-17 21:07:19 | Success |
| Versioned | 6.0.2016.01.26 | DS 2188 Remove DBMS Browse Tables | JDBC | 2023-03-17 21:07:19 | Success |
| Versioned | 6.0.2016.02.25 | DS-3004-slow-searching-as-admin | SQL | 2023-03-17 21:07:19 | Success |
| Versioned | 6.0.2016.04.01 | DS-1955 Increase embargo reason | SQL | 2023-03-17 21:07:19 | Success |
| Versioned | 6.0.2016.04.04 | DS-3086-OAI-Performance-fix | SQL | 2023-03-17 21:07:19 | Success |
| Versioned | 6.0.2016.04.14 | DS-3125-fix-bundle-bitstream-delete-rights | SQL | 2023-03-17 21:07:20 | Success |
| Versioned | 6.0.2016.05.10 | DS-3168-fix-requestitem item id column | SQL | 2023-03-17 21:07:20 | Success |
| Versioned | 6.0.2016.07.21 | DS-2775 | SQL | 2023-03-17 21:07:20 | Success |
| Versioned | 6.0.2016.07.26 | DS-3277 fix handle assignment | SQL | 2023-03-17 21:07:20 | Success |
| Versioned | 6.0.2016.08.23 | DS-3097 | SQL | 2023-03-17 21:07:20 | Success |
| Versioned | 6.1.2017.01.03 | DS 3431 Add Policies for BasicWorkflow | JDBC | 2023-03-17 21:07:21 | Success |
| Versioned | 7.0.2017.10.12 | DS-3542-stateless-sessions | SQL | 2023-03-17 21:07:21 | Success |
| Versioned | 7.0.2018.04.03 | Upgrade Workflow Policy | JDBC | 2023-03-17 21:07:21 | Success |
| Versioned | 7.0.2018.04.16 | dspace-entities | SQL | 2023-03-17 21:07:21 | Success |
| Versioned | 7.0.2018.06.07 | DS-3851-permission | SQL | 2023-03-17 21:07:21 | Success |
| Versioned | 7.0.2019.05.02 | DS-4239-workflow-xml-migration | SQL | 2023-03-17 21:07:21 | Success |
| Versioned | 7.0.2019.06.14 | scripts-and-process | SQL | 2023-03-17 21:07:21 | Success |
| Versioned | 7.0.2019.07.31 | Retrieval of name variant | SQL | 2023-03-17 21:07:21 | Success |
| Versioned | 7.0.2019.11.13 | relationship type copy left right | SQL | 2023-03-17 21:07:22 | Success |
| Versioned | 7.0.2020.01.08 | DS-626-statistics-tracker | SQL | 2023-03-17 21:07:22 | Success |
| Versioned | 7.0.2020.10.31 | CollectionCommunity Metadata Handle | JDBC | 2023-03-17 21:07:22 | Success |
| Versioned | 7.0.2021.01.22 | Remove basic workflow | SQL | 2023-03-17 21:07:23 | Success |
| Versioned | 7.0.2021.02.08 | tilted rels | SQL | 2023-03-17 21:07:23 | Success |
| Versioned | 7.0.2021.03.18 | Move entity type to dspace schema | SQL | 2023-03-17 21:07:23 | Success |
| Versioned | 7.0.2021.09.24 | Move entity type from item template to collection | SQL | 2023-03-17 21:07:23 | Success |
| Versioned | 7.0.2021.10.04 | alter collection table drop workflow stem columns | SQL | 2023-03-17 21:07:23 | Success |
| Versioned | 7.1.2021.10.18 | Fix MDV place after migrating from DSpace 5 | SQL | 2023-03-17 21:07:23 | Success |
| Versioned | 7.3.2022.04.29 | orcid queue and history | SQL | 2023-03-17 21:07:44 | Success |
| Versioned | 7.3.2022.05.16 | Orcid token table | SQL | 2023-03-17 21:07:44 | Success |
| Versioned | 7.3.2022.06.16 | process to group | SQL | 2023-03-17 21:07:44 | Success |
| Versioned | 7.3.2022.06.20 | add last version status column to relationship table | SQL | 2023-03-17 21:07:44 | Success |
| Versioned | 7.5.2022.12.01 | add table subscriptionparamter change columns subscription table | SQL | 2023-03-17 21:07:44 | Success |
| Versioned | 7.5.2022.12.06 | index action resource policy | SQL | 2023-03-17 21:07:44 | Success |
| Versioned | 7.5.2022.12.09 | Supervision Orders table | SQL | 2023-03-17 21:07:44 | Success |
| Versioned | 7.5.2022.12.15 | system wide alerts | SQL | 2023-03-17 21:07:44 | Success |
| Versioned | 4.9.2015.10.26 | DS-2818 registry update | SQL | 2023-03-17 21:09:09 | Out of Order |
+-----------+----------------+------------------------------------------------------------------+----------+---------------------+--------------+