We added a new browse index for series (DC. relation.ispartofseries).
The reindexing looked good and
so does the postgresql database.
But, when attempting to go to any Collection OR Community's web page,
the following error is sent to me from
the server: (Thank goodness this is test and not production),
Any guesses at this one? I'll buy dinner/beer for the person who
answers correctly at OR2009 in Atlanta.
Exception:
org.dspace.plugin.PluginException:
org.dspace.app.webui.components.RecentSubmissionsException:
org.dspace.browse.BrowseException: problem with query: SELECT
bi_item.* FROM bi_item, (SELECT collection2item.item_id FROM
collection2item WHERE collection2item.collection_id=? ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT ?
at
org
.dspace
.app
.webui
.components
.RecentCollectionSubmissions.process(RecentCollectionSubmissions.java:
86)
at
org
.dspace
.app
.webui
.servlet.HandleServlet.preProcessCollectionHome(HandleServlet.java:592)
at
org
.dspace
.app.webui.servlet.HandleServlet.collectionHome(HandleServlet.java:520)
at
org.dspace.app.webui.servlet.HandleServlet.doDSGet(HandleServlet.java:
215)
at
org
.dspace
.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:151)
at
org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:99)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org
.apache
.catalina
.core
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
252)
at
org
.apache
.catalina
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org
.apache
.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
213)
at
org
.apache
.catalina.core.StandardContextValve.invoke(StandardContextValve.java:
178)
at
org
.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
126)
at
org
.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
105)
at
org
.apache
.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
869)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org
.apache
.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org
.apache
.tomcat
.util
.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:
80)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.dspace.app.webui.components.RecentSubmissionsException:
org.dspace.browse.BrowseException: problem with query: SELECT
bi_item.* FROM bi_item, (SELECT collection2item.item_id FROM
collection2item WHERE collection2item.collection_id=? ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT ?
at
org
.dspace
.app
.webui
.components
.RecentSubmissionsManager
.getRecentSubmissions(RecentSubmissionsManager.java:132)
at
org
.dspace
.app
.webui
.components
.RecentCollectionSubmissions.process(RecentCollectionSubmissions.java:
81)
... 21 more
Caused by: org.dspace.browse.BrowseException: problem with query:
SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id FROM
collection2item WHERE collection2item.collection_id=? ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT ?
at org.dspace.browse.BrowseDAOPostgres.doQuery(BrowseDAOPostgres.java:
400)
at org.dspace.browse.BrowseEngine.browseMini(BrowseEngine.java:198)
at
org
.dspace
.app
.webui
.components
.RecentSubmissionsManager
.getRecentSubmissions(RecentSubmissionsManager.java:116)
... 22 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation with OID
72652 does not exist
at
org
.postgresql
.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:
1512)
at
org
.postgresql
.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at
org
.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
188)
at
org
.postgresql
.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
at
org
.postgresql
.jdbc2
.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:
346)
at
org
.postgresql
.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:
250)
at
org
.apache
.commons
.dbcp
.DelegatingPreparedStatement
.executeQuery(DelegatingPreparedStatement.java:92)
at
org
.apache
.commons
.dbcp
.DelegatingPreparedStatement
.executeQuery(DelegatingPreparedStatement.java:92)
at
org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:209)
at org.dspace.browse.BrowseDAOPostgres.doQuery(BrowseDAOPostgres.java:
382)
... 24 more
Jeffrey Trimble
System LIbrarian
William F. Maag Library
Youngstown State University
330.941.2483 (Office)
[email protected]
http://www.maag.ysu.edu
http://digital.maag.ysu.edu
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
