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 Team,
Now i have tried with old backup and error are less.
Please advice to solve database error menationed below.
LOG: unexpected EOF on client connection
ERROR: constraint "metadatavalue_item_id_fkey" of
relation "metadatavalue" does not exist
STATEMENT: ALTER TABLE metadatavalue DROP CONSTRAINT
metadatavalue_item_id_fkey
With Regardds
Indu Bhushan
SIRC, RRCAT
Indore MP
Folowing error in the middle of database import
process.
-----------
ERROR: canceling autovacuum task
CONTEXT: automatic analyze of table
"dspace.public.checksum_history"
-----------------------
[dspace@sircdl bin]$ /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-03-02 02:42:13 | Success |
| 1.8 | Upgrade to DSpace 1.8 sche |
2015-03-02 02:42:13 | Success |
| 3.0 | Upgrade to DSpace 3.x sche |
2015-03-02 02:42:14 | Success |
| 4.0 | Upgrade to DSpace 4.x sche |
2015-03-02 02:42:15 | Success |
| 5.0.2014.08.08 | DS-1945 Helpdesk Request a |
2015-03-02 02:42:16 | Success |
| 5.0.2014.09.25 | DS 1582 Metadata For All O
| | Pending |
| 5.0.2014.09.26 | DS-1582 Metadata For All O
| | Pending |
+----------------+----------------------------+---------------------+---------+
Following error on postgres screen.
LOG: unexpected EOF on client connection
ERROR: constraint "metadatavalue_item_id_fkey" of
relation "metadatavalue" does not exist
STATEMENT: ALTER TABLE metadatavalue DROP CONSTRAINT
metadatavalue_item_id_fkey
ERROR: constraint "metadatavalue_item_id_fkey" of
relation "metadatavalue" does not exist
STATEMENT: ALTER TABLE metadatavalue DROP CONSTRAINT
metadatavalue_item_id_fkey
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection