Pascal-Nicolas Becker created DS-1480:
-----------------------------------------
Summary: [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
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
