Hi,
I'm trying to copy a DSpace PostgreSql database from one server to another
to create a separate testing/dev environment. Dumping (pg_dump database >
db.sql) and reloading (psql database <db.sql) the SQL to the second server
seems to work fine. However when I try to access the DSpace XMLUI using the
db copy I get the following error:
org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
commands ignored until end of transaction block
I have logging set on debug and the offending(?) SQL query says:
2009-11-11 12:27:51,635 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "SELECT * FROM community WHERE NOT community_id IN (SELECT
child_comm_id FROM community2community) ORDER BY name" with parameters:
Both servers are RHEL5 with psql (PostgreSQL) 8.1.18. DSpace is version
1.5.2 with the delegated admins patch applied. Vacuuming and reindexing does
not seem to help.
Anyone have ideas on how to fix this?
T
--
--
Timo Aalto
Planning Officer
University of Helsinki Library
timo dot j dot aalto at helsinki dot fi
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
