Hi Andrew, Apologies for not getting back to this. I'm not always able to answer questions on this list quickly, but I see no one else has gotten to this one.
The "More than one result found" error appears to be saying that somehow you have *two* WorkspaceItem objects that link to the same Item. In other words, somehow you have two entries in the "workspaceitem" table which have the *same value* in the "item_id" column. That's not supposed to be possible in DSpace, as every workspace Item should be linked to a different Item. You should be able to find the duplicate entry by running something like this: select item_id, COUNT(item_id) from workspaceitem group by item_id having count(item_id)>1; That should return duplicate "item_id" values. Then, for each, you'd have to find the duplicate rows: select * from workspaceitem where item_id=[value]; It's unclear to me why you have duplicates, but there should not be two rows with the same "item_id". So, you should delete one of them. It's difficult to answer your other question about the "psql" role. It might be possible to ignore if that role is no longer necessary in your new setup. But, if you notice odd permissions errors, then it's possible that role is needed. Tim On Friday, October 6, 2023 at 3:02:06 PM UTC-5 Andrew K wrote: > I probably should have mentioned that I run > *sudo /dspace/bin/dspace index-discovery -b* > on the new server first and it went OK. > After that I did > *sudo /dspace/bin/dspace filter-media* > and then > *sudo /dspace/bin/dspace index-discovery* > throws the error *java.lang.IllegalArgumentException: More than one > result found* > > Another question. > I moved the database and assetstore to the new server. > Then I did > *sudo /dspace/bin/dspace filter-media* > It took more than a day to complete (12+K items). > Now I try > *sudo /dspace/bin/dspace index-discovery* > but it fails: > > > > > *The script has startedUpdating Indexjava.lang.IllegalArgumentException: > More than one result found at > org.dspace.core.AbstractHibernateDAO.uniqueResult(AbstractHibernateDAO.java:242) > > at > org.dspace.content.dao.impl.WorkspaceItemDAOImpl.findByItem(WorkspaceItemDAOImpl.java:81)* > > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/c7a57e8f-ff10-4701-9f9e-98def6cf7c2dn%40googlegroups.com.
