[
https://jira.duraspace.org/browse/DS-1480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bram Luyten (@mire) updated DS-1480:
------------------------------------
Status: Volunteer Needed (was: Received)
> [dspace]/bin/dspace clean_database doesn't do anything
> ------------------------------------------------------
>
> Key: DS-1480
> URL: https://jira.duraspace.org/browse/DS-1480
> Project: DSpace
> Issue Type: Bug
> Components: DSpace API
> Affects Versions: 3.1, 4.0
> Environment: Postgresql
> Reporter: Pascal-Nicolas Becker
>
> If you run [dspace]/bin/dspace it offers a command clean_database. If you run
> the command nothing happens. It only adds one new entry in the logfile:
> 2013-02-08 12:33:05,126 WARN org.dspace.storage.rdbms.InitializeDatabase @
> Schema file not specified
> The main method of the class that gets started
> (org.dspace.storage.rdbms.InitializeDatabase) expects one parameter but it
> does not get one. If you run [dspace]/bin/dspace clean_database
> ../etc/clean_database.sql it produces lots of SQL-Errors like the follwoing
> one:
> 2013-02-08 12:50:31,798 WARN org.dspace.storage.rdbms.DatabaseManager @ Got
> SQL Exception: org.postgresql.util.PSQLException: ERROR: cannot drop table
> item because other objects depend on it
> Detail: constraint bi_item_item_id_fkey on table bi_item depends on table
> item
> constraint bi_withdrawn_item_id_fkey on table bi_withdrawn depends on table
> item
> constraint bi_private_item_id_fkey on table bi_private depends on table item
> constraint bi_2_dmap_item_id_fkey on table bi_2_dmap depends on table item
> constraint bi_4_dmap_item_id_fkey on table bi_4_dmap depends on table item
> Hint: Use DROP ... CASCADE to drop the dependent objects too.
> As ant also offers a target clean_database that works without any problems,
> it could be considered to remove clean_database from command line tool
> completely.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
