Thanks Brian. Yes, I did the index-init instead of the index-update.
-Ron On Jul 27, 2011, at 10:36 AM, Brian Freels-Stendel wrote: > Good morning, > > It looks like that relation (view) shouldn't be in 1.5, see > http://www.mail-archive.com/[email protected]/msg09668.html. > Just to be sure, did you run index-init instead of index-update? > > B-- > >>>> On 7/26/2011 at 7:26 PM, in message > <[email protected]>, Ron Kelley > <[email protected]> wrote: >> Greetings all, >> >> I to upgrade our dSpace environment from 1.4.2 to 1.5.0. I ran thru the >> upgrade procedures exactly as prescribed here: >> http://www.dspace.org/1_7_0Documentation/Upgrading%20a%20DSpace%20Installatio >> >> n.html#UpgradingaDSpaceInstallation-UpgradingFrom1.4.2to1.5 >> >> >> The upgrade process went without a hitch and I was able to build the new >> dspace binaries (including reindexing the DB). However, upon accessing our >> dspace page, I saw a "System Error: Malformed request" as well as an >> "Internal System Error" message. Looking at the dspace.log file, I saw this: >> >> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ >> 2011-07-26 15:51:42,588 WARN org.dspace.app.webui.servlet.DSpaceServlet @ >> anonymous:session_id=4AB698522C957BBAD2A78EAE9EDC9D2D:ip_addr=192.168.1.5:dat >> abase_error:org.postgresql.util.PSQLException: ERROR: relation >> "collectionitemsbydateaccession" does not exist >> org.postgresql.util.PSQLException: ERROR: relation >> "collectionitemsbydateaccession" does not exist >> at >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorIm >> pl.java:1512) >> at >> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.jav >> a:1297) >> at >> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.ja >> va:437) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Sta >> tement.java:353) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Stateme >> nt.java:257) >> at >> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPr >> eparedStatement.java:92) >> at >> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPr >> eparedStatement.java:92) >> at >> org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:259) >> at >> org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:270) >> at org.dspace.browse.Browse.getLastSubmitted(Browse.java:326) >> at >> org.dspace.app.webui.servlet.HandleServlet.collectionHome(HandleServlet.java: >> 470) >> at >> org.dspace.app.webui.servlet.HandleServlet.doDSGet(HandleServlet.java:197) >> 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:690) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationF >> ilterChain.java:269) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCha >> in.java:188) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.jav >> a:210) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.jav >> a:172) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: >> 108) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) >> at >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) >> at >> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processCo >> nnection(Http11BaseProtocol.java:665) >> at >> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java >> :528) >> at >> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWor >> kerThread.java:81) >> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ >> >> I searched all the Postgres SQL files in the upgrade directory (even as far >> as 1.7.2) and could not find anything named >> "collectionitemsbydateaccession". >> >> >> For what its worth, I am running Postgresql 8.1.23 on CentOS 5.6 with >> tomcat5 v5.2.23 and apache 2.2.23-45. >> >> >> Can someone shed some light here? >> >> >> >> Thanks, >> >> ----------------------------- >> Ron Kelley >> [email protected] >> >> >> >> >> ------------------------------------------------------------------------------ >> Got Input? Slashdot Needs You. >> Take our quick survey online. Come on, we don't ask for help often. >> Plus, you'll get a chance to win $100 to spend on ThinkGeek. >> http://p.sf.net/sfu/slashdot-survey >> _______________________________________________ >> Dspace-general mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/dspace-general ------------------------------------------------------------------------------ Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey _______________________________________________ Dspace-general mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-general
