[Dspace-tech] Lots of browse errors
I'm getting lots of browse errors. (Like 200 within 14 minutes) I don't see but two index tables showing up in my postgresql. Also, the default browse config has been implemented (nothing fancy!) (Yeah, I know its a google-bot). Here's a sample: Date: 1/27/11 10:04 AM Session ID: 9FB39CC6A53C23EC1A80EDCA2E76E847 User: Anonymous IP address: 66.249.71.110 -- URL Was: http://digital.maag.ysu.edu:8080/jspui/browse?type=titleorder=ASCrpp=20value=Sigma+Gamma+clean-up+project. -- Method: GET -- Parameters were: -- value: Sigma Gamma clean-up project. -- rpp: 20 -- type: title -- order: ASC Exception: javax.servlet.ServletException: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:371) at org.dspace.app.webui.servlet.BrowserServlet.doDSGet(BrowserServlet.java:112) 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:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:735) Caused by: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:196) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:791) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:751) at org.dspace.browse.BrowseEngine.browseByItem(BrowseEngine.java:296) at org.dspace.browse.BrowseEngine.browse(BrowseEngine.java:132) at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:342) ... 20 more Caused by: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:291) at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:181) ... 25 more Jeffrey Trimble System LIbrarian William F. Maag Library Youngstown State University 330.941.2483 (Office) jatrim...@ysu.edu http://www.maag.ysu.edu http://digital.maag.ysu.edu For he is the Kwisatz Haderach... -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev.
Re: [Dspace-tech] Lots of browse errors
Hi Jeffrey, did you run index-init, when setting up this instance? Hope that helps Claudia Jürgen Am 27.01.2011 16:07, schrieb Jeffrey Trimble: I'm getting lots of browse errors. (Like 200 within 14 minutes) I don't see but two index tables showing up in my postgresql. Also, the default browse config has been implemented (nothing fancy!) (Yeah, I know its a google-bot). Here's a sample: Date: 1/27/11 10:04 AM Session ID: 9FB39CC6A53C23EC1A80EDCA2E76E847 User: Anonymous IP address: 66.249.71.110 -- URL Was: http://digital.maag.ysu.edu:8080/jspui/browse?type=titleorder=ASCrpp=20value=Sigma+Gamma+clean-up+project. -- Method: GET -- Parameters were: -- value: Sigma Gamma clean-up project. -- rpp: 20 -- type: title -- order: ASC Exception: javax.servlet.ServletException: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:371) at org.dspace.app.webui.servlet.BrowserServlet.doDSGet(BrowserServlet.java:112) 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:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:735) Caused by: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:196) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:791) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:751) at org.dspace.browse.BrowseEngine.browseByItem(BrowseEngine.java:296) at org.dspace.browse.BrowseEngine.browse(BrowseEngine.java:132) at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:342) ... 20 more Caused by: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:291) at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:181) ... 25 more Jeffrey Trimble System LIbrarian William F. Maag Library Youngstown State University 330.941.2483 (Office) jatrim...@ysu.edu http://www.maag.ysu.edu http://digital.maag.ysu.edu For he is the Kwisatz Haderach... -- Special
Re: [Dspace-tech] Lots of browse errors
I did run it...and actually did it a second time--this morning. Nothing, zilch. Quite yucky if you ask me. Thanks, On Jan 27, 2011, at 10:21 AM, Claudia Jürgen wrote: Hi Jeffrey, did you run index-init, when setting up this instance? Hope that helps Claudia Jürgen Am 27.01.2011 16:07, schrieb Jeffrey Trimble: I'm getting lots of browse errors. (Like 200 within 14 minutes) I don't see but two index tables showing up in my postgresql. Also, the default browse config has been implemented (nothing fancy!) (Yeah, I know its a google-bot). Here's a sample: Date: 1/27/11 10:04 AM Session ID: 9FB39CC6A53C23EC1A80EDCA2E76E847 User: Anonymous IP address: 66.249.71.110 -- URL Was: http://digital.maag.ysu.edu:8080/jspui/browse?type=titleorder=ASCrpp=20value=Sigma+Gamma+clean-up+project. -- Method: GET -- Parameters were: -- value: Sigma Gamma clean-up project. -- rpp: 20 -- type: title -- order: ASC Exception: javax.servlet.ServletException: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:371) at org.dspace.app.webui.servlet.BrowserServlet.doDSGet(BrowserServlet.java:112) 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:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:735) Caused by: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:196) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:791) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:751) at org.dspace.browse.BrowseEngine.browseByItem(BrowseEngine.java:296) at org.dspace.browse.BrowseEngine.browse(BrowseEngine.java:132) at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:342) ... 20 more Caused by: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:291) at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:181) ... 25 more Jeffrey Trimble System LIbrarian William F. Maag Library Youngstown State University 330.941.2483 (Office) jatrim...@ysu.edu http://www.maag.ysu.edu
Re: [Dspace-tech] Lots of browse errors
Hi Jeffrey, should have taken a close look, http://digital.maag.ysu.edu:8080/jspui/browse?type=titleorder=ASCrpp=20value=Sigma+Gamma+clean-up+project. value is only used for metadata browse indices not item indices, they got an offset for paging. Title is usually an item index, seems as if you changed it to metadata, so it is not a default browse setting? Hope that helps Claudia Jürgen Am 27.01.2011 16:30, schrieb Jeffrey Trimble: I did run it...and actually did it a second time--this morning. Nothing, zilch. Quite yucky if you ask me. Thanks, On Jan 27, 2011, at 10:21 AM, Claudia Jürgen wrote: Hi Jeffrey, did you run index-init, when setting up this instance? Hope that helps Claudia Jürgen Am 27.01.2011 16:07, schrieb Jeffrey Trimble: I'm getting lots of browse errors. (Like 200 within 14 minutes) I don't see but two index tables showing up in my postgresql. Also, the default browse config has been implemented (nothing fancy!) (Yeah, I know its a google-bot). Here's a sample: Date: 1/27/11 10:04 AM Session ID: 9FB39CC6A53C23EC1A80EDCA2E76E847 User: Anonymous IP address: 66.249.71.110 -- URL Was: http://digital.maag.ysu.edu:8080/jspui/browse?type=titleorder=ASCrpp=20value=Sigma+Gamma+clean-up+project. -- Method: GET -- Parameters were: -- value: Sigma Gamma clean-up project. -- rpp: 20 -- type: title -- order: ASC Exception: javax.servlet.ServletException: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:371) at org.dspace.app.webui.servlet.BrowserServlet.doDSGet(BrowserServlet.java:112) 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:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:735) Caused by: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:196) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:791) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:751) at org.dspace.browse.BrowseEngine.browseByItem(BrowseEngine.java:296) at org.dspace.browse.BrowseEngine.browse(BrowseEngine.java:132) at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:342) ... 20 more Caused by: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at
Re: [Dspace-tech] Lots of browse errors
Claudia, The default is what came with dspace.cfg : webui.browse.index.1 = dateissued:item:dateissued webui.browse.index.2 = author:metadata:dc.contributor.*,dc.creator:text webui.browse.index.3 = title:item:title webui.browse.index.4 = subject:metadata:dc.subject.*:text Something is just wacked if you ask me. On Jan 27, 2011, at 10:46 AM, Claudia Jürgen wrote: Hi Jeffrey, should have taken a close look, http://digital.maag.ysu.edu:8080/jspui/browse?type=titleorder=ASCrpp=20value=Sigma+Gamma+clean-up+project. value is only used for metadata browse indices not item indices, they got an offset for paging. Title is usually an item index, seems as if you changed it to metadata, so it is not a default browse setting? Hope that helps Claudia Jürgen Am 27.01.2011 16:30, schrieb Jeffrey Trimble: I did run it...and actually did it a second time--this morning. Nothing, zilch. Quite yucky if you ask me. Thanks, On Jan 27, 2011, at 10:21 AM, Claudia Jürgen wrote: Hi Jeffrey, did you run index-init, when setting up this instance? Hope that helps Claudia Jürgen Am 27.01.2011 16:07, schrieb Jeffrey Trimble: I'm getting lots of browse errors. (Like 200 within 14 minutes) I don't see but two index tables showing up in my postgresql. Also, the default browse config has been implemented (nothing fancy!) (Yeah, I know its a google-bot). Here's a sample: Date: 1/27/11 10:04 AM Session ID: 9FB39CC6A53C23EC1A80EDCA2E76E847 User: Anonymous IP address: 66.249.71.110 -- URL Was: http://digital.maag.ysu.edu:8080/jspui/browse?type=titleorder=ASCrpp=20value=Sigma+Gamma+clean-up+project. -- Method: GET -- Parameters were: -- value: Sigma Gamma clean-up project. -- rpp: 20 -- type: title -- order: ASC Exception: javax.servlet.ServletException: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:371) at org.dspace.app.webui.servlet.BrowserServlet.doDSGet(BrowserServlet.java:112) 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:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:735) Caused by: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:196) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:791) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:751) at org.dspace.browse.BrowseEngine.browseByItem(BrowseEngine.java:296) at org.dspace.browse.BrowseEngine.browse(BrowseEngine.java:132) at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:342) ... 20 more Caused by: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at
Re: [Dspace-tech] Lots of browse errors
Hello Jeffrey, did you experiment with the title before and google got old stuff indexed? Your title index atm seems ok. Claudia Claudia, The default is what came with dspace.cfg : webui.browse.index.1 = dateissued:item:dateissued webui.browse.index.2 = author:metadata:dc.contributor.*,dc.creator:text webui.browse.index.3 = title:item:title webui.browse.index.4 = subject:metadata:dc.subject.*:text Something is just wacked if you ask me. On Jan 27, 2011, at 10:46 AM, Claudia Jürgen wrote: Hi Jeffrey, should have taken a close look, http://digital.maag.ysu.edu:8080/jspui/browse?type=titleorder=ASCrpp=20value=Sigma+Gamma+clean-up+project. value is only used for metadata browse indices not item indices, they got an offset for paging. Title is usually an item index, seems as if you changed it to metadata, so it is not a default browse setting? Hope that helps Claudia Jürgen Am 27.01.2011 16:30, schrieb Jeffrey Trimble: I did run it...and actually did it a second time--this morning. Nothing, zilch. Quite yucky if you ask me. Thanks, On Jan 27, 2011, at 10:21 AM, Claudia Jürgen wrote: Hi Jeffrey, did you run index-init, when setting up this instance? Hope that helps Claudia Jürgen Am 27.01.2011 16:07, schrieb Jeffrey Trimble: I'm getting lots of browse errors. (Like 200 within 14 minutes) I don't see but two index tables showing up in my postgresql. Also, the default browse config has been implemented (nothing fancy!) (Yeah, I know its a google-bot). Here's a sample: Date: 1/27/11 10:04 AM Session ID: 9FB39CC6A53C23EC1A80EDCA2E76E847 User: Anonymous IP address: 66.249.71.110 -- URL Was: http://digital.maag.ysu.edu:8080/jspui/browse?type=titleorder=ASCrpp=20value=Sigma+Gamma+clean-up+project. -- Method: GET -- Parameters were: -- value: Sigma Gamma clean-up project. -- rpp: 20 -- type: title -- order: ASC Exception: javax.servlet.ServletException: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:371) at org.dspace.app.webui.servlet.BrowserServlet.doDSGet(BrowserServlet.java:112) 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:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:735) Caused by: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:196) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:791) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:751) at org.dspace.browse.BrowseEngine.browseByItem(BrowseEngine.java:296) at org.dspace.browse.BrowseEngine.browse(BrowseEngine.java:132) at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:342) ... 20 more Caused by: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at
Re: [Dspace-tech] Lots of browse errors
Jeffrey, I agree with Claudia that the request itself looks odd. I would want to look at / find out what was generating that link in the first place. But at the same time, the code ought to be able to handle with this more gracefully (ie. know that it's an item index and ignore the value parameter). Please log as a bug - you can assign it to me if you like. G On 27 January 2011 17:19, Claudia Juergen claudia.juer...@ub.tu-dortmund.de wrote: Hello Jeffrey, did you experiment with the title before and google got old stuff indexed? Your title index atm seems ok. Claudia Claudia, The default is what came with dspace.cfg : webui.browse.index.1 = dateissued:item:dateissued webui.browse.index.2 = author:metadata:dc.contributor.*,dc.creator:text webui.browse.index.3 = title:item:title webui.browse.index.4 = subject:metadata:dc.subject.*:text Something is just wacked if you ask me. On Jan 27, 2011, at 10:46 AM, Claudia Jürgen wrote: Hi Jeffrey, should have taken a close look, http://digital.maag.ysu.edu:8080/jspui/browse?type=titleorder=ASCrpp=20value=Sigma+Gamma+clean-up+project . value is only used for metadata browse indices not item indices, they got an offset for paging. Title is usually an item index, seems as if you changed it to metadata, so it is not a default browse setting? Hope that helps Claudia Jürgen Am 27.01.2011 16:30, schrieb Jeffrey Trimble: I did run it...and actually did it a second time--this morning. Nothing, zilch. Quite yucky if you ask me. Thanks, On Jan 27, 2011, at 10:21 AM, Claudia Jürgen wrote: Hi Jeffrey, did you run index-init, when setting up this instance? Hope that helps Claudia Jürgen Am 27.01.2011 16:07, schrieb Jeffrey Trimble: I'm getting lots of browse errors. (Like 200 within 14 minutes) I don't see but two index tables showing up in my postgresql. Also, the default browse config has been implemented (nothing fancy!) (Yeah, I know its a google-bot). Here's a sample: Date: 1/27/11 10:04 AM Session ID: 9FB39CC6A53C23EC1A80EDCA2E76E847 User: Anonymous IP address: 66.249.71.110 -- URL Was: http://digital.maag.ysu.edu:8080/jspui/browse?type=titleorder=ASCrpp=20value=Sigma+Gamma+clean-up+project . -- Method: GET -- Parameters were: -- value: Sigma Gamma clean-up project. -- rpp: 20 -- type: title -- order: ASC Exception: javax.servlet.ServletException: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:371) at org.dspace.app.webui.servlet.BrowserServlet.doDSGet(BrowserServlet.java:112) 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:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:735) Caused by: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation bi_3_dmap does not exist Position: 79 at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:196) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:791) at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:751) at org.dspace.browse.BrowseEngine.browseByItem(BrowseEngine.java:296) at
