Nestor Oviedo created DS-1324:
---------------------------------
Summary: BrowseEngine tries to use a non existent bi_*_dmap and
bi_*_dis
Key: DS-1324
URL: https://jira.duraspace.org/browse/DS-1324
Project: DSpace
Issue Type: Bug
Components: DSpace API
Affects Versions: 1.8.2, 3.0
Reporter: Nestor Oviedo
When you make a request for "/browse?type={some_index}", where {some_index} is
configured as of type "item", e.g.:
"webui.browse.index.1 = dateissued:item:dateissued",
and you also specifify the "value" (or "authority") parameter, the following
exception is raised:
"org.dspace.app.xmlui.utils.UIException: Unable to process browse".
with the following Root exception:
"org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
commands ignored until end of transaction block"
You can reproduce this error in the demo site:
http://demo.dspace.org/xmlui/browse?type=dateissued&value=some
We have found that the problem seems to be in the method
"org.dspace.browse.BrowseEngine.browseByItem()". It test if there is some
filter value and then adds the "bi_x_dmap" and "bi_x_dis" as the filter mapping
tables, without considering this browse index doesn't creates those tables.
The Postgre log shows the following lines:
ERROR: relation "bi_1_dmap" does not exist at character 95
STATEMENT: SELECT COUNT(*) AS num FROM bi_item, (SELECT
communities2item.item_id FROM communities2item, bi_1_dmap, bi_1_dis WHERE
bi_1_dmap.distinct_id=bi_1_dis.id AND bi_1_dis.authority=$1 AND
bi_1_dmap.item_id=communities2item.item_id AND communities2item.community_id=$2
) mappings WHERE bi_item.item_id=mappings.item_id
--
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
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
