Hello Tim,
Thank you! I don't know how but the database was not imported. The problem
solved.
Another problem: on the old server I run
root@dspace:/www/dspace/bin # ./dspace *solr-export-statistics*
Exception: Expected mime type application/octet-stream but got text/html.
<!DOCTYPE html><html><head><title>Apache Tomcat/8.0.28 - Error
report</title><style type="text/css">H1
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;}
H2
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;}
H3
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;}
BODY
{font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;}
P
{font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A
{color : black;}A.name {color : black;}.line {height: 1px;
background-color: #525D76; border: none;}</style> </head><body><h1>HTTP
Status 500 - {msg=SolrCore 'statistics' is not available due to init
failure: Error opening new
searcher,trace=org.apache.solr.common.SolrException: SolrCore 'statistics'
is not available due to init failure: Error opening new searcher
at
org.apache.solr.core.CoreContainer.getCore(CoreContainer.java:745)
at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:299)
at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:207)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.dspace.solr.filters.LocalHostRestrictionFilter.doFilter(LocalHostRestrictionFilter.java:50)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
and so on, very long error message.
The old server is running.
What is the problem, how can I move the solr data to the new server?
середа, 4 жовтня 2023 р. о 19:42:10 UTC+3 DSpace Technical Support пише:
> Hi Andrew,
>
> Based on the information you shared, it appears (to me) that you ran the
> "dspace database migrate ignored" command on an **empty** database. If you
> look, the "info" command reported that the "Installed On" date for every
> single migration was Sept 30, 2023. That implies that the database had no
> prior content or database tables.
>
> I suspect you may have forgotten to migrate your database over from 5.x to
> 7.x? If it's helpful, we have a migration guide which can walk through
> those steps here:
> https://wiki.lyrasis.org/display/DSDOC7x/Migrating+DSpace+to+a+new+server
>
> It is also possible to simply follow the Upgrading guide, but it tends to
> "assume" your database data is already in place:
> https://wiki.lyrasis.org/display/DSDOC7x/Upgrading+DSpace
>
> Tim
>
> On Saturday, September 30, 2023 at 10:03:24 AM UTC-5 Andrew K wrote:
>
>> Hello!
>>
>> I am trying to upgrade from 5.4 to the latest 7.6 version.
>> I installed the new server and copied the assetstore and database.
>> Then did
>> sudo /dspace/bin/dspace database migrate ignored
>>
>> sudo /dspace/bin/dspace database info
>>
>> Database Type: postgres
>> Database URL: jdbc:postgresql://localhost:5432/dspace
>> Database Schema: public
>> Database Username: dspace
>> Database Software: PostgreSQL version 12.16 (Ubuntu
>> 12.16-0ubuntu0.20.04.1)
>> Database Driver: PostgreSQL JDBC Driver version 42.6.0
>> 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 Baseline >>
>> | BASELINE | 2023-09-30 17:31:15 | Baseline |
>> | Versioned | 1.1 | Initial DSpace 1.1 database schema
>> | SQL | 2023-09-30 17:31:15 | Success |
>> | Versioned | 1.2 | Upgrade to DSpace 1.2 schema
>> | SQL | 2023-09-30 17:31:15 | Success |
>> | Versioned | 1.3 | Upgrade to DSpace 1.3 schema
>> | SQL | 2023-09-30 17:31:15 | Success |
>> | Versioned | 1.3.9 | Drop constraint for DSpace 1 4 schema
>> | JDBC | 2023-09-30 17:31:16 | Success |
>> | Versioned | 1.4 | Upgrade to DSpace 1.4 schema
>> | SQL | 2023-09-30 17:31:16 | Success |
>> | Versioned | 1.5 | Upgrade to DSpace 1.5 schema
>> | SQL | 2023-09-30 17:31:16 | Success |
>> | Versioned | 1.5.9 | Drop constraint for DSpace 1 6 schema
>> | JDBC | 2023-09-30 17:31:16 | Success |
>> | Versioned | 1.6 | Upgrade to DSpace 1.6 schema
>> | SQL | 2023-09-30 17:31:16 | Success |
>> | Versioned | 1.7 | Upgrade to DSpace 1.7 schema
>> | SQL | 2023-09-30 17:31:16 | Success |
>> | Versioned | 1.8 | Upgrade to DSpace 1.8 schema
>> | SQL | 2023-09-30 17:31:16 | Success |
>> | Versioned | 3.0 | Upgrade to DSpace 3.x schema
>> | SQL | 2023-09-30 17:31:16 | Success |
>> | Versioned | 4.0 | Upgrade to DSpace 4.x schema
>> | SQL | 2023-09-30 17:31:16 | Success |
>> | Versioned | 4.9.2015.10.26 | DS-2818 registry update
>> | SQL | 2023-09-30 17:31:16 | Success |
>> | Versioned | 5.0.2014.08.08 | DS-1945 Helpdesk Request a Copy
>> | SQL | 2023-09-30 17:31:16 | Success |
>> | Versioned | 5.0.2014.09.25 | DS 1582 Metadata For All Objects drop
>> constraint | JDBC | 2023-09-30 17:31:16 | Success |
>> | Versioned | 5.0.2014.09.26 | DS-1582 Metadata For All Objects
>> | SQL | 2023-09-30 17:31:16 | Success |
>> | Versioned | 5.0.2014.11.04 | Enable XMLWorkflow Migration
>> | JDBC | 2023-09-30 17:31:16 | Success |
>> | Versioned | 5.6.2016.08.23 | DS-3097
>> | SQL | 2023-09-30 17:31:17 | Success |
>> | Versioned | 5.7.2017.04.11 | DS-3563 Index metadatavalue resource type
>> id column | SQL | 2023-09-30 17:31:17 | Success |
>> | Versioned | 5.7.2017.05.05 | DS 3431 Add Policies for BasicWorkflow
>> | JDBC | 2023-09-30 17:31:17 | Success |
>> | Versioned | 6.0.2015.03.06 | DS 2701 Dso Uuid Migration
>> | JDBC | 2023-09-30 17:31:17 | Success |
>> | Versioned | 6.0.2015.03.07 | DS-2701 Hibernate migration
>> | SQL | 2023-09-30 17:31:17 | Success |
>> | Versioned | 6.0.2015.08.31 | DS 2701 Hibernate Workflow Migration
>> | JDBC | 2023-09-30 17:31:18 | Success |
>> | Versioned | 6.0.2015.09.01 | DS 2701 Enable XMLWorkflow Migration
>> | JDBC | 2023-09-30 17:31:18 | Success |
>> | Versioned | 6.0.2016.01.03 | DS-3024
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 6.0.2016.01.26 | DS 2188 Remove DBMS Browse Tables
>> | JDBC | 2023-09-30 17:31:18 | Success |
>> | Versioned | 6.0.2016.02.25 | DS-3004-slow-searching-as-admin
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 6.0.2016.04.01 | DS-1955 Increase embargo reason
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 6.0.2016.04.04 | DS-3086-OAI-Performance-fix
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 6.0.2016.04.14 | DS-3125-fix-bundle-bitstream-delete-rights
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 6.0.2016.05.10 | DS-3168-fix-requestitem item id column
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 6.0.2016.07.21 | DS-2775
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 6.0.2016.07.26 | DS-3277 fix handle assignment
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 6.0.2016.08.23 | DS-3097
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 6.1.2017.01.03 | DS 3431 Add Policies for BasicWorkflow
>> | JDBC | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2017.10.12 | DS-3542-stateless-sessions
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2018.04.03 | Upgrade Workflow Policy
>> | JDBC | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2018.04.16 | dspace-entities
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2018.06.07 | DS-3851-permission
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2019.05.02 | DS-4239-workflow-xml-migration
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2019.06.14 | scripts-and-process
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2019.07.31 | Retrieval of name variant
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2019.11.13 | relationship type copy left right
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2020.01.08 | DS-626-statistics-tracker
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2020.10.31 | CollectionCommunity Metadata Handle
>> | JDBC | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2021.01.22 | Remove basic workflow
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2021.02.08 | tilted rels
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2021.03.18 | Move entity type to dspace schema
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2021.09.24 | Move entity type from item template to
>> collection | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.0.2021.10.04 | alter collection table drop workflow stem
>> columns | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.1.2021.10.18 | Fix MDV place after migrating from DSpace
>> 5 | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.3.2022.04.29 | orcid queue and history
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.3.2022.05.16 | Orcid token table
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.3.2022.06.16 | process to group
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.3.2022.06.20 | add last version status column to
>> relationship table | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.5.2022.12.01 | add table subscriptionparamter change
>> columns subscription table | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.5.2022.12.06 | index action resource policy
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.5.2022.12.09 | Supervision Orders table
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.5.2022.12.15 | system wide alerts
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.6.2023.03.17 | Remove unused sequence
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.6.2023.03.24 | Update PNG in bitstream format registry
>> | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.6.2023.03.29 | orcid queue and history descriptions to
>> text type | SQL | 2023-09-30 17:31:18 | Success |
>> | Versioned | 7.6.2023.04.19 | process parameters to text type
>> | SQL | 2023-09-30 17:31:18 | Success |
>>
>> +-----------+----------------+------------------------------------------------------------------+----------+---------------------+----------+
>>
>> Everything looks OK.
>> Then I do
>>
>> sudo /dspace/bin/dspace index-discovery -b
>> The script has started
>> (Re)building index from scratch.
>> Done with indexing
>> The script has completed
>>
>> sudo /dspace/bin/dspace filter-media
>> The script has started
>> The script has completed
>>
>> But both scripts run very fast and the server shows no content (the
>> interface is available).
>> What can be wrong?
>>
>> Thanks,
>> Andrew
>>
>>
>>
--
All messages to this mailing list should adhere to the Code of Conduct:
https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
You received this message because you are subscribed to the Google Groups
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/dspace-tech/9eaf712b-bf0f-4aa8-99a5-ebc014bcd0e6n%40googlegroups.com.
