Hi,
I had the exact same error while trying to install dspace 1.7.0 on Windows
7. I discovered that that particular error is caused by the PostgreSQL
dspace already having some data, in other words, you had run *ant
fresh_install* before.
The solution that worked for me was to permanently delete the dspace
database and create it again, then run *ant fresh_install
*Hope that helps.
On Sat, Feb 5, 2011 at 8:12 AM, Kiran Kumar V <kiran...@gmail.com> wrote:
> To
> All the Dspace Community
>
> I am trying to install Dspace on Windows. When ant fresh_install
> command used the following message is coming.
> Kindly help me in sorting out the problem
> Thanking you
>
> V.Kiran Kumar
> Librarian
> IIHFW
> Hyderabad.
>
> --------------------------------------------------------------------------------------------
> [java] 2011-02-04 14:47:39,312 WARN
> org.dspace.storage.rdbms.DatabaseManag
> er @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: duplicate
> key
> value violates unique constraint "checksum_results_pkey"
> [java] Detail: Key (result_code)=(BITSTREAM_INFO_NOT_FOUND) already
> exist
> s.
> [java] org.postgresql.util.PSQLException: ERROR: duplicate key value
> violat
> es unique constraint "checksum_results_pkey"
> [java] Detail: Key (result_code)=(BITSTREAM_INFO_NOT_FOUND) already
> exist
> s.
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
> (QueryExecutorImpl.java:1531)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(Query
> ExecutorImpl.java:1313)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecuto
> rImpl.java:188)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:452)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
> AbstractJdbc2Statement.java:340)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:332)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana
> ger.java:981)
> [java] at
> org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa
> tabase.java:68)
> [java] 2011-02-04 14:47:39,375 WARN
> org.dspace.storage.rdbms.DatabaseManag
> er @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: duplicate
> key
> value violates unique constraint "checksum_results_pkey"
> [java] Detail: Key (result_code)=(CHECKSUM_ALGORITHM_INVALID) already
> exi
> sts.
> [java] org.postgresql.util.PSQLException: ERROR: duplicate key value
> violat
> es unique constraint "checksum_results_pkey"
> [java] Detail: Key (result_code)=(CHECKSUM_ALGORITHM_INVALID) already
> exi
> sts.
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
> (QueryExecutorImpl.java:1531)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(Query
> ExecutorImpl.java:1313)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecuto
> rImpl.java:188)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:452)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
> AbstractJdbc2Statement.java:340)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:332)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana
> ger.java:981)
> [java] at
> org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa
> tabase.java:68)
> [java] 2011-02-04 14:47:39,453 WARN
> org.dspace.storage.rdbms.DatabaseManag
> er @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: duplicate
> key
> value violates unique constraint "checksum_results_pkey"
> [java] Detail: Key (result_code)=(BITSTREAM_NOT_PROCESSED) already
> exists
> .
> [java] org.postgresql.util.PSQLException: ERROR: duplicate key value
> violat
> es unique constraint "checksum_results_pkey"
> [java] Detail: Key (result_code)=(BITSTREAM_NOT_PROCESSED) already
> exists
> .
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
> (QueryExecutorImpl.java:1531)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(Query
> ExecutorImpl.java:1313)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecuto
> rImpl.java:188)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:452)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
> AbstractJdbc2Statement.java:340)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:332)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana
> ger.java:981)
> [java] at
> org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa
> tabase.java:68)
> [java] 2011-02-04 14:47:39,531 WARN
> org.dspace.storage.rdbms.DatabaseManag
> er @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: duplicate
> key
> value violates unique constraint "checksum_results_pkey"
> [java] Detail: Key (result_code)=(BITSTREAM_MARKED_DELETED) already
> exist
> s.
> [java] org.postgresql.util.PSQLException: ERROR: duplicate key value
> violat
> es unique constraint "checksum_results_pkey"
> [java] Detail: Key (result_code)=(BITSTREAM_MARKED_DELETED) already
> exist
> s.
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
> (QueryExecutorImpl.java:1531)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(Query
> ExecutorImpl.java:1313)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecuto
> rImpl.java:188)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:452)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
> AbstractJdbc2Statement.java:340)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:332)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana
> ger.java:981)
> [java] at
> org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa
> tabase.java:68)
> [java] 2011-02-04 14:47:39,593 WARN
> org.dspace.storage.rdbms.DatabaseManag
> er @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: relation
> "harv
> ested_collection" already exists
> [java] org.postgresql.util.PSQLException: ERROR: relation
> "harvested_collec
> tion" already exists
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
> (QueryExecutorImpl.java:1531)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(Query
> ExecutorImpl.java:1313)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecuto
> rImpl.java:188)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:452)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
> AbstractJdbc2Statement.java:340)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:332)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana
> ger.java:981)
> [java] at
> org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa
> tabase.java:68)
> [java] 2011-02-04 14:47:39,671 WARN
> org.dspace.storage.rdbms.DatabaseManag
> er @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: relation
> "harv
> ested_collection_fk_idx" already exists
> [java] org.postgresql.util.PSQLException: ERROR: relation
> "harvested_collec
> tion_fk_idx" already exists
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
> (QueryExecutorImpl.java:1531)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(Query
> ExecutorImpl.java:1313)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecuto
> rImpl.java:188)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:452)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
> AbstractJdbc2Statement.java:340)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:332)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana
> ger.java:981)
> [java] at
> org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa
> tabase.java:68)
> [java] 2011-02-04 14:47:39,718 WARN
> org.dspace.storage.rdbms.DatabaseManag
> er @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: relation
> "harv
> ested_item" already exists
> [java] org.postgresql.util.PSQLException: ERROR: relation
> "harvested_item"
> already exists
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
> (QueryExecutorImpl.java:1531)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(Query
> ExecutorImpl.java:1313)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecuto
> rImpl.java:188)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:452)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
> AbstractJdbc2Statement.java:340)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:332)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana
> ger.java:981)
> [java] at
> org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa
> tabase.java:68)
> [java] 2011-02-04 14:47:39,781 WARN
> org.dspace.storage.rdbms.DatabaseManag
> er @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: relation
> "harv
> ested_item_fk_idx" already exists
> [java] org.postgresql.util.PSQLException: ERROR: relation
> "harvested_item_f
> k_idx" already exists
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
> (QueryExecutorImpl.java:1531)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(Query
> ExecutorImpl.java:1313)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecuto
> rImpl.java:188)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:452)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
> AbstractJdbc2Statement.java:340)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:332)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.apache.commons.dbcp.DelegatingStatement.execute(Delegatin
> gStatement.java:264)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana
> ger.java:981)
> [java] at
> org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa
> tabase.java:68)
> [java] 2011-02-04 14:47:43,312 INFO
> org.dspace.core.ConfigurationManager @
> Loading system provided config property (-Ddspace.configuration):
> config/dspace
> .cfg
> [java] 2011-02-04 14:47:43,328 INFO
> org.dspace.core.ConfigurationManager @
> Using default log4j provided log configuration,if unintended, check your
> dspace
> .cfg for (log.init.config)
> [java] Started: 1296811063296
> [java] Ended: 1296811065578
> [java] Elapsed time: 2 secs (2282 msecs)
>
> load_registries:
> [java] 2011-02-04 14:47:46,562 INFO
> org.dspace.core.ConfigurationManager @
> Loading system provided config property (-Ddspace.configuration):
> config/dspace
> .cfg
> [java] 2011-02-04 14:47:46,578 INFO
> org.dspace.core.ConfigurationManager @
> Using default log4j provided log configuration,if unintended, check your
> dspace
> .cfg for (log.init.config)
> [java] 2011-02-04 14:47:48,078 INFO org.dspace.content.BitstreamFormat
> @ a
> nonymous::create_bitstream_format:bitstream_format_id=79
> [java] 2011-02-04 14:47:48,140 INFO org.dspace.content.BitstreamFormat
> @ a
> nonymous::update_bitstream_format:bitstream_format_id=79
> [java] 2011-02-04 14:47:48,140 FATAL
> org.dspace.administer.RegistryLoader @
> anonymous::error_loading_registries:
> [java] org.postgresql.util.PSQLException: ERROR: duplicate key value
> violat
> es unique constraint "bitstreamformatregistry_short_description_key"
> [java] Detail: Key (short_description)=(Unknown) already exists.
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
> (QueryExecutorImpl.java:1531)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(Query
> ExecutorImpl.java:1313)
> [java] at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecuto
> rImpl.java:188)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ
> dbc2Statement.java:452)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
> AbstractJdbc2Statement.java:354)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(Abs
> tractJdbc2Statement.java:308)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUp
> date(DelegatingPreparedStatement.java:105)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUp
> date(DelegatingPreparedStatement.java:105)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUp
> date(DelegatingPreparedStatement.java:105)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.executeUpdate(Databa
> seManager.java:1315)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.update(DatabaseManag
> er.java:729)
> [java] at
> org.dspace.content.BitstreamFormat.update(BitstreamFormat.jav
> a:601)
> [java] at
> org.dspace.administer.RegistryLoader.loadFormat(RegistryLoade
> r.java:183)
> [java] at org.dspace.administer.RegistryLoad
> [java] er.loadBitstreamFormats(RegistryLoader.java:138)
> [java] at
> org.dspace.administer.RegistryLoader.main(RegistryLoader.java
> :75)
> [java] Error:
> [java] - ERROR: duplicate key value violates unique constraint
> "bitstreamformatregistry_short_description_key"
> [java] Detail: Key (short_description)=(Unknown) already exists.
>
> BUILD FAILED
>
> C:\dspace-1.7.0-src-release\dspace\target\dspace-1.7.0-build.dir\build.xml:809:
> Java returned: 1
>
> Total time: 24 seconds
> C:\dspace-1.7.0-src-release\dspace\target\dspace-1.7.0-build.dir>
>
>
> ------------------------------------------------------------------------------
> The modern datacenter depends on network connectivity to access resources
> and provide services. The best practices for maximizing a physical server's
> connectivity to a physical network are well understood - see how these
> rules translate into the virtual world?
> http://p.sf.net/sfu/oracle-sfdevnlfb
> _______________________________________________
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
------------------------------------------------------------------------------
The modern datacenter depends on network connectivity to access resources
and provide services. The best practices for maximizing a physical server's
connectivity to a physical network are well understood - see how these
rules translate into the virtual world?
http://p.sf.net/sfu/oracle-sfdevnlfb
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
