On Mon, 11 Jul 2011 13:45:39 +0200 Mateusz Neumann <[email protected]> wrote:
> After few days after (re)starting Tomcat with DSpace running I get > errors similar to the attached report. The error occurs during browse > (http://depot.ceon.pl/browse?type=title, > http://depot.ceon.pl/browse?value=Ito%2C+Akio&type=author), so the > part concerning browsing in dspace.cfg is: > > event.dispatcher.default.consumers = search, browse, discovery, > eperson, harvester event.consumer.browse.class = > org.dspace.browse.BrowseConsumer event.consumer.browse.filters = > Community|Collection|Item|Bundle+Add|Create|Modify|Modify_Metadata|Delete|Remove > webui.browse.thumbnail.show = false webui.browse.index.1 = > dateissued:item:dateissued webui.browse.index.2 = > author:metadata:dc.contributor.author,dc.creator:text > webui.browse.index.3 = title:item:title webui.browse.index.4 = > subject:metadata:dc.subject.*:text webui.browse.index.5 = > affiliation:metadata:dc.contributor.organization:text > webui.browse.link.1 = author:dc.contributor.author > > The errors found in PostgreSQL log file are similar to those lines: > > 2011-07-11 11:18:29 UTC ERROR: relation "bi_1" does not exist at > character 15 2011-07-11 11:18:29 UTC STATEMENT: SELECT * FROM bi_1 > LIMIT 1; > > 2011-07-11 11:18:43 UTC ERROR: cached plan must not change result > type 2011-07-11 11:18:43 UTC STATEMENT: SELECT bi_item.* FROM > bi_item, (SELECT DISTINCT bi_2_dmap.item_id FROM bi_2_dmap, bi_2_dis > WHERE bi_2_dmap.distinct_id=bi_2_dis.id AND bi_2_dis.authority IS > NULL AND bi_2_dis.value=$1 ) mappings WHERE > bi_item.item_id=mappings.item_id ORDER BY sort_1 ASC LIMIT $2 > 2011-07-11 11:18:43 UTC ERROR: current transaction is aborted, > commands ignored until end of transaction block 2011-07-11 11:18:43 > UTC STATEMENT: SELECT COUNT(*) AS num FROM bi_item, (SELECT > DISTINCT bi_2_dmap.item_id FROM bi_2_dmap, bi_2_dis WHERE > bi_2_dmap.distinct_id=bi_2_dis.id AND bi_2_dis.authority IS NULL AND > bi_2_dis.value=$1 ) mappings WHERE bi_item.item_id=mappings.item_id > > 2011-07-11 11:18:56 UTC ERROR: cached plan must not change result > type 2011-07-11 11:18:56 UTC STATEMENT: SELECT bi_item.* FROM > bi_item ORDER BY sort_1 ASC LIMIT $1 2011-07-11 11:18:56 UTC ERROR: > current transaction is aborted, commands ignored until end of > transaction block 2011-07-11 11:18:56 UTC STATEMENT: SELECT COUNT(*) > AS num FROM bi_item > > Software I use: > > DSpace-1.7.1 > tomcat-6.0.28-9+squeeze1 > postgresql-8.4.7-0squeeze2 > > Have you got any ideas? > FYI db.statementpool = false in `dspace.cfg` seems to make the problem solved. -- Mateusz ------------------------------------------------------------------------------ AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev _______________________________________________ Dspace-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-devel
