[
https://jira.duraspace.org/browse/DS-812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20976#action_20976
]
Tim Donohue commented on DS-812:
--------------------------------
Discussion from DSpace Devel Meeting on May 25:
[20:10] <tdonohue> next up DS-812
[20:10] <kompewter> [ https://jira.duraspace.org/browse/DS-812 ] - [#DS-812]
Postgres errors - DuraSpace JIRA
[20:10] <tdonohue> grahamtriggs -- looks like you are assigned here. Anything
needing review right now?
[20:11] <tdonohue> or grahamtriggs1 (not sure which is the real graham)
[20:11] * bradmc
(~bra...@207-172-69-79.c3-0.smr-ubr3.sbo-smr.ma.static.cable.rcn.com) Quit
(Read error: Connection reset by peer)
[20:11] <richardrodgers> none of us are
[20:12] * bradmc
(~bra...@207-172-69-79.c3-0.smr-ubr3.sbo-smr.ma.static.cable.rcn.com) has
joined #duraspace
[20:12] <robint> looks like neither of them !
[20:12] <tdonohue> yep, sounds like graham isn't here. I'm assuming there *is*
an issue here, since he claimed it. We'll check with grahamtriggs for updates
[20:12] <mhwood> Looks like another "run index-init". I wonder if we can
conveniently detect that from the exception and tell the user what is really
wrong.
[20:13] <robint> I also see this error
[20:13] <grahamtriggs1> Not sure if anything can be said without the browse.*
config from dspace.cfg
[20:13] * mdiggory ([email protected]) has joined
#duraspace
[20:13] <tdonohue> Ds-812 summary: need more info from graham & others who see
this issue -- need proposal for how best to resolve?
> Postgres errors
> ---------------
>
> Key: DS-812
> URL: https://jira.duraspace.org/browse/DS-812
> Project: DSpace
> Issue Type: Bug
> Components: DSpace API
> Affects Versions: 1.6.2
> Environment: Postgresql 9.0.2, O/S= AIX 5.3, Tomcat 6
> Reporter: Jeffrey Trimble
> Assignee: Graham Triggs
>
> Certain types of searches arrive to the server from the outside world cause a
> java servlet error as if there is an indexing bug. See Example:
> An internal server error occurred on http://digital.maag.ysu.edu:8080/xmlui:
> Date: 1/27/11 3:25 PM
> Session ID: 9CCB2524370765356AEBFC84030B3493
> User: Anonymous
> IP address: 66.249.71.110
> -- URL Was:
> http://digital.maag.ysu.edu:8080/jspui/browse?type=title&order=ASC&rpp=20&value=Nationally-renowned+educator+named+accounting+chair
> -- Method: GET
> -- Parameters were:
> -- value: "Nationally-renowned educator named accounting chair"
> -- 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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.duraspace.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
