Re: [Dspace-tech] Database Question
On 16/09/2009, at 7:20 AM, Greg Johnson wrote: The question I have is this: If we were to take a do-over and recreate DSpace from scratch, having copied our Postgres database prior the rebuild, would not the communities and collections that we currently have be transferrable to the new version? From my understanding, the assetstore has all the resource objects, such as pdf files, and the database has all the tracking objects, such as metadata and access control and in there are the ideas of communities and collections. Look for the file db-schema.gif in the DSpace source distribution for a layout of the database contents. If you don't have a root cause explanation for the unexpected behaviour, the `do-over' and recreate may carry the problem over. Another way would be to clone the broken system, experiment and address the fault there and then fix the actual system. Best wishes, Van Ly vly at usyd dot edu dot au -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Database Question
We are having issues with our current installation of DSpace (1.5.1) that we have been troubleshooting and can't seem to solve. One option as a solution would be to download and recreate DSpace from scratch. The question I have is this: If we were to take a do-over and recreate DSpace from scratch, having copied our Postgres database prior the rebuild, would not the communities and collections that we currently have be transferrable to the new version? Thanks for any help you can offer... Greg -- Gregory Johnson Digital Initiatives and Distance Learning Librarian Government Documents Librarian, Manager, Digital Library Services Department Governors State University University Park, IL, 60484-0975 g-johns...@govst.edu 708-235-7516 -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Database question
Hello Mika, this error says, you have duplicated values in a column with unique index. For DSpace 1.4 you can check all unique index as follow: select name, count(*) from epersongroup group by name having count(*)1; select short_description, count(*) from BitstreamFormatRegistry group by short_description having count(*)1; select email, count(*) from eperson group by email having count(*)1; select namespace, count(*) from MetadataSchemaRegistry group by namespace having count(*)1; select short_id, count(*) from MetadataSchemaRegistry group by short_id having count(*)1; select handle, count(*) from Handle group by handle having count(*)1; select item_id, count(*) from WorkflowItem group by item_id having count(*)1; select email, count(*) from RegistrationData group by email having count(*)1; select checksum, count(*) from History group by checksum having count(*)1; You result for the queries should be always 0 rows. But NULL Values are not equal, so you can have multiple rows for a unique index with NULL values. For example in our Database we have 6 rows in table History with checksum NULL. select checksum, count(*) from History group by checksum having count(*)1; checksum | count --+--- | 6 (1 row) select * from history where checksum is null; history_id | creation_date | checksum +---+-- 467492 | | 467493 | | 467494 | | 467500 | | 467501 | | 467502 | | (6 rows) Maybe that helps Bernadette Mika Stenberg schrieb: While reindexing Dspace database I get following error. Wonder whats causing this and how could I fix this? reindexdb: reindexing of database dspace failed: ERROR: could not create unique index DETAIL: Table contains duplicated values. -Mika - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech