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/vse0120000070mrt/direct/01/
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> 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/vse0120000070mrt/direct/01/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
