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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
