Could you also check to see what errors are reported in your DSpace log
files? Those files should be located at:
[dspace.dir]/log/dspace.log.[date]
Where "dspace.dir" is configured in your dspace.cfg file.
Based on what you've reported, it definitely looks like the database
migration process has gotten "confused". If it was halted unexpectedly
due to a harddrive crash, it's possible that part of a migration was not
completely successfully. But, the underlying errors (in the logs)
should give us more information.
Another question: Do you have a backup of your database from before you
ran *any* migrations? According to your "dspace database info" command,
it looks like the "my-dspace-backup.sql" file already included several
migrations that were run on "2015-02-06 00:23:17" (specifically a 1.7
and 1.8 migration). Do you have a backup from prior to Feb 6, 2015
which had no migrations run on it yet? It might be worth trying the
migration again from an older backup (if it is available).
- Tim
On 2/16/2015 5:58 AM, इन्दु भूषण Indu Bhushan wrote:
>
>
> Apache Maven *3.0.5* , *Java version: 1.8.0_31, Apache Ant(TM) version
> 1.8.2*, postgres (PostgreSQL) 9.0.3, Linux RHEL 5
> Dear Sir
> After sucessfully installing dspace when i restored backup. dspace url
> showing "HTTP Status 404 - /jspui" I am unable to update database
> schema. I restored backup as a postgres user(psql dspace <
> my-dspace-backup.sql) and updated database schema as dspace user)
> Errors are attached below. Thanks in advance.
> Please reply.
> * [postgres*@sircdl root]$ psql -U dspace -f
> /opt/dspace-5.0-src-release/dspace/etc/postgres/update-sequences.sql(as
> postgres user)
> psql:/opt/dspace-5.0-src-release/dspace/etc/postgres/update-sequences.sql:87:
> ERROR: relation "webapp" does not exist
> LINE 1: SELECT setval('webapp_seq', max(webapp_id)) FROM webapp;
> ^
> psql:/opt/dspace-5.0-src-release/dspace/etc/postgres/update-sequences.sql:88:
> ERROR: relation "requestitem" does not exist
> LINE 1: ...tval('requestitem_seq', max(requestitem_id)) FROM requestite...
> [dspace@sircdl ~]$ /opt/dspace/bin/dspace database migrate
>
> Database URL: jdbc:postgresql://localhost:5432/dspace
> Migrating database to latest version... (Check logs for details)
> Done.
> [dspace@sircdl ~]$ /opt/dspace/bin/dspace database info
>
> Database URL: jdbc:postgresql://localhost:5432/dspace
> Database Schema: public
> Database Software: PostgreSQL version 9.0.3
> Database Driver: PostgreSQL Native Driver version PostgreSQL 9.1 JDBC4
> (build 901)
>
> +----------------+----------------------------+---------------------+---------+
> | Version | Description | Installed on |
> State |
> +----------------+----------------------------+---------------------+---------+
> | 1.1 | Initial DSpace 1.1 databas | |
> PreInit |
> | 1.2 | Upgrade to DSpace 1.2 sche | |
> PreInit |
> | 1.3 | Upgrade to DSpace 1.3 sche | |
> PreInit |
> | 1.3.9 | Drop constraint for DSpace | |
> PreInit |
> | 1.4 | Upgrade to DSpace 1.4 sche | |
> PreInit |
> | 1.5 | Upgrade to DSpace 1.5 sche | |
> PreInit |
> | 1.5.9 | Drop constraint for DSpace | |
> PreInit |
> | 1.6 | Upgrade to DSpace 1.6 sche | |
> PreInit |
> | 1.7 | Initializing from DSpace 1 | 2015-02-06 00:23:17 |
> Success |
> | 1.8 | Upgrade to DSpace 1.8 sche | 2015-02-06 00:23:17 |
> Success |
> | 3.0 | Upgrade to DSpace 3.x sche | |
> Pending |
> | 4.0 | Upgrade to DSpace 4.x sche | |
> Pending |
> | 5.0.2014.08.08 | DS-1945 Helpdesk Request a | |
> Pending |
> | 5.0.2014.09.25 | DS 1582 Metadata For All O | |
> Pending |
> | 5.0.2014.09.26 | DS-1582 Metadata For All O | |
> Pending |
> +----------------+----------------------------+---------------------+---------+
>
> +----------------+----------------------------+---------------------+---------+
>
> [dspace@sircdl ~]$ /opt/dspace/bin/dspace database migrate
>
> Database URL: jdbc:postgresql://localhost:5432/dspace
> Migrating database to latest version... (Check logs for details)
> ERROR: null value in column "bitstream_format_id" violates not-null
> constraint
> STATEMENT: INSERT INTO bitstreamformatregistry (
> short_description,internal,description,bitstream_format_id,mimetype,support_level)
> VALUES ( $1,$2,$3,$4,$5,$6) RETURNING null
> ERROR: there is no unique constraint matching given keys for referenced
> table "item"
> STATEMENT: CREATE TABLE versionitem
> (
> versionitem_id INTEGER NOT NULL PRIMARY KEY,
> item_id INTEGER REFERENCES Item(item_id),
> version_number INTEGER,
> eperson_id INTEGER REFERENCES EPerson(eperson_id),
> version_date TIMESTAMP,
> version_summary VARCHAR(255),
> versionhistory_id INTEGER REFERENCES
> VersionHistory(versionhistory_id)
> )
> Done.
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
> [dspace@sircdl ~]$ LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
>
>
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
> http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
