Dear all
I installed Dspace 1.6.2 in our new server and i tried to restore data of
Dspace 1.4.2, i got following problem. It is showing communties and
collection but when i click over author or title it show internal system
error.
[postg...@library data]$ pg_dump dspace > dspace.sql *BACKUP from Postgres
7.4.19 and Dspace 1.4.2*
[postg...@localhost root]$ psql -f dspace.sql dspace *RESTORE in
Postgres 8.4.4 and Dspace 1.6.2
*
[postg...@localhost root]$ psql -U dspace -f
/diglib/dspace/dspace/etc/postgres/database_schema_14-15.sql dspace
[postg...@localhost root]$ psql -U dspace -f
/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql dspace *THIS
STEP SHOWS ERROR*
ERROR: column "admin" of relation "community" already exists
STATEMENT: ALTER TABLE community ADD admin INTEGER REFERENCES epersongroup
( eperson_group_id );
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:49: ERROR:
column "admin" of relation "community" already exists
ERROR: relation "community_admin_fk_idx" already exists
STATEMENT: CREATE INDEX community_admin_fk_idx ON Community(admin);
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:50: ERROR:
relation "community_admin_fk_idx" already exists
ERROR: column "authority" of relation "metadatavalue" already exists
STATEMENT: ALTER TABLE MetadataValue ADD authority VARCHAR(100);
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:55: ERROR:
column "authority" of relation "metadatavalue" already exists
ERROR: column "confidence" of relation "metadatavalue" already exists
STATEMENT: ALTER TABLE MetadataValue ADD confidence INTEGER DEFAULT -1;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:56: ERROR:
column "confidence" of relation "metadatavalue" already exists
ERROR: relation "harvested_collection_seq" already exists
STATEMENT: CREATE SEQUENCE harvested_collection_seq;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:61: ERROR:
relation "harvested_collection_seq" already exists
ERROR: relation "harvested_item_seq" already exists
STATEMENT: CREATE SEQUENCE harvested_item_seq;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:62: ERROR:
relation "harvested_item_seq" already exists
ERROR: relation "harvested_collection" already exists
STATEMENT: CREATE TABLE harvested_collection
(
collection_id INTEGER REFERENCES collection(collection_id) ON
DELETE CASCADE,
harvest_type INTEGER,
oai_source VARCHAR,
oai_set_id VARCHAR,
harvest_message VARCHAR,
metadata_config_id VARCHAR,
harvest_status INTEGER,
harvest_start_time TIMESTAMP WITH TIME ZONE,
last_harvested TIMESTAMP WITH TIME ZONE,
id INTEGER PRIMARY KEY
);
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:82: ERROR:
relation "harvested_collection" already exists
ERROR: relation "harvested_collection_fk_idx" already exists
STATEMENT: CREATE INDEX harvested_collection_fk_idx ON
harvested_collection(collection_id);
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:84: ERROR:
relation "harvested_collection_fk_idx" already exists
ERROR: relation "harvested_item" already exists
STATEMENT: CREATE TABLE harvested_item
(
item_id INTEGER REFERENCES item(item_id) ON DELETE CASCADE,
last_harvested TIMESTAMP WITH TIME ZONE,
oai_id VARCHAR,
id INTEGER PRIMARY KEY
);
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:93: ERROR:
relation "harvested_item" already exists
ERROR: relation "harvested_item_fk_idx" already exists
STATEMENT: CREATE INDEX harvested_item_fk_idx ON harvested_item(item_id);
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:95: ERROR:
relation "harvested_item_fk_idx" already exists
UPDATE 3
ERROR: constraint "community2collection_collection_id_fkey" of relation
"community2collection" does not exist
STATEMENT: ALTER TABLE community2collection DROP CONSTRAINT
community2collection_collection_id_fkey;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:105:
ERROR: constraint "community2collection_collection_id_fkey" of relation
"community2collection" does not exist
ERROR: constraint "comm2coll_collection_fk" for relation
"community2collection" already exists
STATEMENT: ALTER TABLE community2collection ADD CONSTRAINT
comm2coll_collection_fk FOREIGN KEY (collection_id) REFERENCES collection
DEFERRABLE;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:106:
ERROR: constraint "comm2coll_collection_fk" for relation
"community2collection" already exists
ERROR: constraint "community2community_child_comm_id_fkey" of relation
"community2community" does not exist
STATEMENT: ALTER TABLE community2community DROP CONSTRAINT
community2community_child_comm_id_fkey;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:108:
ERROR: constraint "community2community_child_comm_id_fkey" of relation
"community2community" does not exist
ERROR: constraint "com2com_child_fk" for relation "community2community"
already exists
STATEMENT: ALTER TABLE community2community ADD CONSTRAINT com2com_child_fk
FOREIGN KEY (child_comm_id) REFERENCES community DEFERRABLE;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:109:
ERROR: constraint "com2com_child_fk" for relation "community2community"
already exists
ERROR: constraint "collection2item_item_id_fkey" of relation
"collection2item" does not exist
STATEMENT: ALTER TABLE collection2item DROP CONSTRAINT
collection2item_item_id_fkey;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:111:
ERROR: constraint "collection2item_item_id_fkey" of relation
"collection2item" does not exist
ERROR: constraint "coll2item_item_fk" for relation "collection2item"
already exists
STATEMENT: ALTER TABLE collection2item ADD CONSTRAINT coll2item_item_fk
FOREIGN KEY (item_id) REFERENCES item DEFERRABLE;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:112:
ERROR: constraint "coll2item_item_fk" for relation "collection2item"
already exists
UPDATE 0
UPDATE 0
=========================================================================================
[r...@localhost ~]# su dspace
[dsp...@localhost root]$ /diglib/tomcat/bin/startup.sh
Using CATALINA_BASE: /diglib/tomcat
Using CATALINA_HOME: /diglib/tomcat
Using CATALINA_TMPDIR: /diglib/tomcat/temp
Using JRE_HOME: /usr/local/jdk
Using CLASSPATH: /diglib/tomcat/bin/bootstrap.jar
[dsp...@localhost root]$ ERROR: relation "bi_item" does not exist at
character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT communities2item.item_id
FROM communities2item WHERE communities2item.community_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 30
STATEMENT: SELECT COUNT(*) AS num FROM bi_item
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
Please help me and reply soon
With Regards
Indu Bhushan
Library, RRCAT, Indore
------------------------------------------------------------------------------
Centralized Desktop Delivery: Dell and VMware Reference Architecture
Simplifying enterprise desktop deployment and management using
Dell EqualLogic storage and VMware View: A highly scalable, end-to-end
client virtualization framework. Read more!
http://p.sf.net/sfu/dell-eql-dev2dev
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
