Hi Ricardo,
(I'm copying back in dspace-tech, as we ask that all questions be kept
on the mailing list. It helps others also learn from the answers, or
help with their own experience/answers. Thanks.)
First off, I will mention that we do have plans to remove support for
the database indexing. So, if there are issues with Solr that you've
encountered, it might be good to report them to us. As of DSpace 6, we
plan to only support Solr for search/browse.
As for the index-db-browse command: Yes, this is the command that
controls the creation/deletion of those "bi_*" tables for the
database-based browse functionality. Since it sounds like at least some
of your "bi_*" tables don't exist, you probably need to run "./dspace
index-db-browse -r" (which will completely rebuild those indexes,
destroying any old ones that may exist). More documentation on the
"index-db-browse" command and its options is at:
https://wiki.duraspace.org/display/DSDOC5x/Legacy+methods+for+re-indexing+content#Legacymethodsforre-indexingcontent-CreatingtheBrowse&SearchIndexes
- Tim
On 7/9/2015 8:54 AM, RICARDO EITO BRUN wrote:
Thanks Tim,
yes, I am using dspace 4.x, and I moved to postgresql browse method
due to some issues with Solr. So, your suggestion - if I cannot switch
to Solr - is to run index-db-browse, isn't it? Which params are needed?
As there is a extrange note in the documentation telling something
like "take care if you run that command...", I prefered to ask the
question in the foro ;-)
thanks in advance,
Ricardo
2015-07-09 15:37 GMT+02:00 Tim Donohue <tdono...@duraspace.org
<mailto:tdono...@duraspace.org>>:
Hi Ricardo,
It sounds like you are using an older version of DSpace with the
Database-based browse system (which used bi_* tables)? That
system has since been deprecated in recent releases, in favor of
using Discovery / Solr for all search/browse activities.
So, if you are using an older version of DSpace, then you will
need to run "index-db-browse" in order to ensure those "bi_*"
tables are created and populated. But, if you are using a newer
version (DSpace 4 or 5), you might consider just using the new
Discovery / Solr search/browse engine as that will be the new
default setting going forward:
https://wiki.duraspace.org/display/DSDOC5x/Discovery
- Tim
On 7/9/2015 3:25 AM, RICARDO EITO BRUN wrote:
Dear colleagues,
after importing / migrating the database (Postgresql 9.1),
everything is working fine but I am getting an error message when:
a) trying to removing items,
b) creating relations between items.
The error message I get is: "org.postgresql.util.PSQLException
ERROR: relation "bi_private" does not exist Position: 13"
bi_private is not in fact in the database.
I suppose this is an indexing issue that can be solved by
re-indexing the databases using dspace commands. My concern is
whether it is enough to run the index-lucene-init or whether it
is needed to run index-db-browse.
wbr,
Ricardo
--
RICARDO EITO BRUN
Universidad Carlos III de Madrid
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
<mailto:DSpace-tech@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List
Etiquette:https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
--
RICARDO EITO BRUN
Universidad Carlos III de Madrid
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette