Dear list, This issue with blank XMLUI item pages still happens every few days and I haven't been able to find the cause. Whenever the issue occurs I notice an drastically increased number of errors from org.apache.cocoon.components.xslt.TraxErrorListener in the Cocoon log:
2019-03-22 21:21:34,378 WARN org.apache.cocoon.components.xslt.TraxErrorListener - Can not load requested doc: unknown protocol: cocoon at jndi:/localhost/themes/CIAT/xsl/../../0_CGIAR/xsl//aspect/artifactbrowser/common.xsl:141:90 The DSpace log shows the following SQL errors a few milliseconds *before* that: 2019-03-22 21:21:34,356 ERROR org.dspace.storage.rdbms.DatabaseManager @ SQL QueryTable Error - org.postgresql.util.PSQLException: This statement has been closed. at org.postgresql.jdbc.PgStatement.checkClosed(PgStatement.java:694) at org.postgresql.jdbc.PgStatement.getMaxRows(PgStatement.java:501) at org.postgresql.jdbc.PgStatement.createResultSet(PgStatement.java:153) at org.postgresql.jdbc.PgStatement$StatementResultHandler.handleResultRows(PgStatement.java:204) ... 2019-03-22 21:21:34,381 ERROR org.dspace.storage.rdbms.DatabaseManager @ SQL query singleTable Error - org.postgresql.util.PSQLException: This statement has been closed. at org.postgresql.jdbc.PgStatement.checkClosed(PgStatement.java:694) at org.postgresql.jdbc.PgStatement.getMaxRows(PgStatement.java:501) at org.postgresql.jdbc.PgStatement.createResultSet(PgStatement.java:153) ... 2019-03-22 21:21:34,386 ERROR org.dspace.storage.rdbms.DatabaseManager @ SQL findByUnique Error - org.postgresql.util.PSQLException: This statement has been closed. at org.postgresql.jdbc.PgStatement.checkClosed(PgStatement.java:694) at org.postgresql.jdbc.PgStatement.getMaxRows(PgStatement.java:501) at org.postgresql.jdbc.PgStatement.createResultSet(PgStatement.java:153) ... 2019-03-22 21:21:34,395 ERROR org.dspace.storage.rdbms.DatabaseManager @ SQL find Error - org.postgresql.util.PSQLException: This statement has been closed. at org.postgresql.jdbc.PgStatement.checkClosed(PgStatement.java:694) at org.postgresql.jdbc.PgStatement.getMaxRows(PgStatement.java:501) at org.postgresql.jdbc.PgStatement.createResultSet(PgStatement.java:153) at org.postgresql.jdbc.PgStatement$StatementResultHandler.handleResultRows(PgStatement.java:204) So it seems that the error does not actually come from Cocoon, but rather something with retrieving item metadata from the database. For reference, we are using DSpace 5.8 with a vanilla Tomcat 7.0.93 and its native JDBC connection pool. I am wondering if this is related to JDBC connection re-use. I have logAbandoned='true' enabled, though I don't see anything in Tomcat's logs regarding this (though I suspect I need to check my logging setup). I would be interested to hear if other users with this "blank page" issue are using connection pooling as well. Regards, P.S. my observation about the REST API also showing no metadata in my last message was incorrect because I had forgotten that the /items endpoint hides most metadata by default unless you select it with "?expand=metadata". :) On Sat, Mar 9, 2019 at 3:41 PM Alan Orth <alan.o...@gmail.com> wrote: > For what it's worth we saw this issue on our DSpace 5.8 instance with > Tomcat 7 yesterday. Browsing the XMLUI appears to work normally, but item > pages are missing all their metadata. On a hunch, I checked the REST API > for a few items and to my surprise the only metadata available there was > the title, id, and owning collection. Very strange! > > I didn't see any errors in the Tomcat log, and no stack traces in the web > interface that might help track down the error. We restarted Tomcat and the > problem went away. Hmmm. > > Regards, > > On Sat, Nov 3, 2018 at 1:58 AM <wlrutherf...@alaska.edu> wrote: > >> After reconfiguring our statistics and restarting DSpace I'm seeing the >> same sort of error as Susan Borda in the cocoon log: >> 2018-11-02 00:01:15,820 >> WARN org.apache.cocoon.components.xslt.TraxErrorListener - Can not load >> requested doc: unknown protocol: cocoon at >> file:///dspace/webapps/ROOT/themes/Mirage/lib/xsl/core/page-structure.xsl:547:130 >> >> Most of the messages are just informational and seem to be due to the >> system catching up on statistics. To be safe I'll disable >> our cron scripts which run every night to update stats until whatever the >> system is doing is complete. >> >> The other errors we're seeing look like this: >> 2018-11-02 00:05:25,935 WARN cocoon.access - >> org.apache.cocoon.ConnectionResetException: Connection reset by peer >> >> Has anyone else seen these errors and, more importantly, fixed the >> problem? >> >> Thank you, >> >> Walter R. >> >> >> On Monday, February 15, 2016 at 10:11:02 PM UTC-9, Germán Biozzoli wrote: >>> >>> Hi people >>> >>> I'm about to resurrect this message from Susan. >>> >>> We're exactly at the same point, but in our case seems to occur some >>> obscure problem relative to the authorization of the items. The "blank" >>> items were public and now the collection is restricted to a group of users. >>> Using the advanced authorization tool, we defined READ rights for the >>> group/item/collection and DEFAULT BITSTREAM READ for >>> group/bistream/collection. After that, no posibility to view the items, >>> neither administrator or some e-person from the group. Adding ADMIN, WRITE >>> and other rights does not make any effect, the only way to continue viewing >>> metadata is deleting all policies over the items. >>> >>> The error message is the same and restating Tomcat neither produces any >>> effect. >>> >>> It happens in a dev instance using 6.0-SNAPSHOT. >>> >>> Any ideas where to look for the error? >>> >>> Regards >>> Germán >>> >>> >>> >>> >>> >>> >>> 2015-12-15 18:30 GMT-03:00 Borda, Susan <susan...@montana.edu>: >>> >>>> Hi All- >>>> We never received a response to this question and unfortunately it >>>> continues to happen, again this morning for instance and once again a >>>> restart of Tomcat resolved the issue. >>>> >>>> Has anyone else had this problem? >>>> >>>> We are now running DSpace 5.4. >>>> >>>> Any advice would be great. >>>> >>>> Thank you! >>>> susan >>>> >>>> ‹ >>>> Susan Borda >>>> Digital Technologies Development Librarian >>>> Montana State University Library >>>> 406-994-1873 >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> On 11/5/15, 2:51 PM, "dspac...@googlegroups.com on behalf of Erik Guss" >>>> <dspac...@googlegroups.com on behalf of eg...@auth.lib.montana.edu> >>>> wrote: >>>> >>>> >Dear Community: >>>> > >>>> >particulars: CentOS6.7, tomcat7, dspace5.3, mirage2 xmlui, <10,000 >>>> items >>>> > >>>> >Today our DSpace was displaying an intermittent error. All >>>> functionality >>>> >worked except the View item. In other words, you could browse around, >>>> >search, and see hitlists. But when clicking on a handle's item view, >>>> the >>>> >menus would appear, but no item content. This condition was fixed by >>>> >restarting tomcat. I've included log snippets from cocoon and >>>> dspace.log >>>> >below, first from the unsuccessful item view at 12:19 PM, then from the >>>> >successful item view after restarting tomcat at 12:49 PM. The problem >>>> >seems to have something to do with the cache. At the time of the >>>> >problem, there were no postgresql errors, or catalina.out errors, and >>>> >top showed normal resource usage. >>>> > >>>> >**cocoon.log** >>>> >** item information is blank on the screen during this time frame >>>> 12:19 ** >>>> >2015-11-05 12:19:22,468 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache HIT for >>>> >>>> >PK_G-aspect-cocoon://DRI/12/handle/1/9083?pipelinehash=-398319662474980475 >>>> >5 >>>> >2015-11-05 12:19:22,468 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/11/handle/1/9083_T-Navigation-8967015258021785944 >>>> >_T-ItemViewer--1872229765608651772 >>>> >2015-11-05 12:19:22,468 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/10/handle/1/9083_T-Navigation-8967015258021785944 >>>> >2015-11-05 12:19:22,468 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/9/handle/1/9083_T-Navigation-8967015258021785944 >>>> >2015-11-05 12:19:22,468 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/8/handle/1/9083_T-Include-file:///usr/local/dspac >>>> >e/config/MSU-sidebar-menu.xml >>>> >2015-11-05 12:19:22,468 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/7/handle/1/9083_T-SystemwideAlerts-1_T-Navigation >>>> >--5367372201529954577 >>>> >2015-11-05 12:19:22,469 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/6/handle/1/9083_T-Navigation-5799876941772906259 >>>> >2015-11-05 12:19:22,469 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for PK_G-aspect-cocoon://DRI/5/handle/1/9083 >>>> >2015-11-05 12:19:22,469 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for PK_G-aspect-cocoon://DRI/4/handle/1/9083 >>>> >2015-11-05 12:19:22,469 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for PK_G-aspect-cocoon://DRI/3/handle/1/9083 >>>> >2015-11-05 12:19:22,469 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for PK_G-aspect-cocoon://DRI/2/handle/1/9083 >>>> >2015-11-05 12:19:22,469 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/1/handle/1/9083_T-PageNotFound-580360549544510925 >>>> >0 >>>> >2015-11-05 12:19:22,511 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-file-cocoon://DRI/handle/1/9083_T-xslt-jndi:/localhost/xmlui/themes/M >>>> >>>> >irage2/xsl/preprocess.xsl_T-IncludePageMeta--2183294294163301955_T-xslt-jn >>>> >>>> >di:/localhost/xmlui/themes/Mirage2/xsl/theme.xsl_T-i18n-context://i18n/?en >>>> >_US__T-strip-namespaces-1_S-html-no-doctype-;encoding=UTF-8;indent=yes >>>> >2015-11-05 12:19:22,597 WARN >>>> >org.apache.cocoon.components.xslt.TraxErrorListener - Can not load >>>> >requested doc: unknown protocol: cocoon at >>>> >>>> >jndi:/localhost/xmlui/themes/Mirage2/xsl/aspect/artifactbrowser/common.xsl >>>> >:141:90 >>>> >2015-11-05 12:19:22,634 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache HIT for >>>> >PK_R-resource-jndi:/localhost/xmlui/themes/Mirage2/scripts-dist.xml >>>> >2015-11-05 12:19:22,642 INFO cocoon.access - 'handle/1/9083' >>>> Processed >>>> >by Apache Cocoon in 236 milliseconds. >>>> > >>>> >** no screen errors for this time frame 12:49 ** >>>> >2015-11-05 12:49:40,860 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/12/handle/1/9083?pipelinehash=-398319662474980475 >>>> >5_T-Navigation-1249862855913320984 >>>> >2015-11-05 12:49:40,878 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/11/handle/1/9083_T-Navigation-8967015258021785944 >>>> >_T-ItemViewer--1872229765608651772 >>>> >2015-11-05 12:49:40,878 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/10/handle/1/9083_T-Navigation-8967015258021785944 >>>> >2015-11-05 12:49:40,878 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/9/handle/1/9083_T-Navigation-8967015258021785944 >>>> >2015-11-05 12:49:40,879 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/8/handle/1/9083_T-Include-file:///usr/local/dspac >>>> >e/config/MSU-sidebar-menu.xml >>>> >2015-11-05 12:49:40,879 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/7/handle/1/9083_T-SystemwideAlerts-1_T-Navigation >>>> >-1508943862940002015 >>>> >2015-11-05 12:49:40,879 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/6/handle/1/9083_T-Navigation--1858632025743576998 >>>> >2015-11-05 12:49:40,880 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for PK_G-aspect-cocoon://DRI/5/handle/1/9083_T-Navigation-1 >>>> >2015-11-05 12:49:40,880 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for PK_G-aspect-cocoon://DRI/4/handle/1/9083 >>>> >2015-11-05 12:49:40,880 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for PK_G-aspect-cocoon://DRI/3/handle/1/9083 >>>> >2015-11-05 12:49:40,880 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for PK_G-aspect-cocoon://DRI/2/handle/1/9083 >>>> >2015-11-05 12:49:40,880 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-aspect-cocoon://DRI/1/handle/1/9083_T-PageNotFound-580360549544510925 >>>> >0 >>>> >2015-11-05 12:49:40,921 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache MISS for >>>> >>>> >PK_G-file-cocoon://DRI/handle/1/9083_T-xslt-jndi:/localhost/xmlui/themes/M >>>> >>>> >irage2/xsl/preprocess.xsl_T-IncludePageMeta--2183294294163301955_T-xslt-jn >>>> >>>> >di:/localhost/xmlui/themes/Mirage2/xsl/theme.xsl_T-i18n-context://i18n/?en >>>> >_US__T-strip-namespaces-1_S-html-no-doctype-;encoding=UTF-8;indent=yes >>>> >2015-11-05 12:49:41,125 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Cache HIT for >>>> >PK_R-resource-jndi:/localhost/xmlui/themes/Mirage2/scripts-dist.xml >>>> >2015-11-05 12:49:41,130 INFO >>>> org.apache.cocoon.caching.impl.CacheImpl - >>>> >Caching new response for >>>> >>>> >PK_G-aspect-cocoon://DRI/12/handle/1/9083?pipelinehash=-398319662474980475 >>>> >5_T-Navigation-1249862855913320984 >>>> >2015-11-05 12:49:41,134 INFO cocoon.access - 'handle/1/9083' >>>> Processed >>>> >by Apache Cocoon in 351 milliseconds. >>>> > >>>> > >>>> >**dspace.log snippets** >>>> > >>>> >2015-11-05 12:19:22,022 INFO >>>> org.dspace.usage.LoggerUsageEventListener @ >>>> >>>> >anonymous:session_id=4A21BFE1137B0913574932FF09063C8B:ip_addr=45.55.168.40 >>>> >:view_item:handle=1/3810 >>>> >2015-11-05 12:19:22,123 INFO >>>> >org.dspace.app.xmlui.aspect.artifactbrowser.ItemViewer @ Unhandled >>>> >identifier URI http://scholarworks.montana.edu/xmlui/handle/1/3810 >>>> >2015-11-05 12:19:22,151 WARN org.dspace.core.PluginManager @ Cannot >>>> find >>>> >named plugin for >>>> >interface=org.dspace.content.crosswalk.DisseminationCrosswalk, >>>> >name="METSRIGHTS" >>>> >2015-11-05 12:19:22,447 INFO >>>> org.dspace.usage.LoggerUsageEventListener @ >>>> >>>> >anonymous:session_id=3B4B9E19349D8D0C486E3A7F340F1EBA:ip_addr=153.90.170.1 >>>> >0:view_item:handle=1/9083 >>>> >2015-11-05 12:19:22,564 INFO >>>> >org.dspace.app.xmlui.aspect.artifactbrowser.ItemViewer @ Unhandled >>>> >identifier URI http://scholarworks.montana.edu/xmlui/handle/1/9083 >>>> >2015-11-05 12:19:22,593 WARN org.dspace.core.PluginManager @ Cannot >>>> find >>>> >named plugin for >>>> >interface=org.dspace.content.crosswalk.DisseminationCrosswalk, >>>> >name="METSRIGHTS" >>>> >2015-11-05 12:19:26,752 INFO >>>> org.dspace.usage.LoggerUsageEventListener @ >>>> >>>> >anonymous:session_id=D0A5925E368DF26F38DE51D81F868AC3:ip_addr=45.55.168.40 >>>> >:view_item:handle=1/8369 >>>> > >>>> >2015-11-05 12:49:37,545 INFO >>>> org.dspace.usage.LoggerUsageEventListener @ >>>> >>>> >anonymous:session_id=38EBB2CB3A773C0D67A9D07CD8149755:ip_addr=45.55.168.40 >>>> >:view_item:handle=1/1061 >>>> >2015-11-05 12:49:37,693 INFO >>>> >org.dspace.app.xmlui.aspect.artifactbrowser.ItemViewer @ Unhandled >>>> >identifier URI http://scholarworks.montana.edu/xmlui/handle/1/1061 >>>> >2015-11-05 12:49:40,835 INFO >>>> org.dspace.usage.LoggerUsageEventListener @ >>>> >logge...@xxxana.edu: >>>> session_id=3B4B9E19349D8D0C486E3A7F340F1EBA:ip_addr=15 >>>> >3.90.170.10:view_item:handle=1/9083 >>>> >2015-11-05 12:49:40,969 INFO >>>> >org.dspace.app.xmlui.aspect.artifactbrowser.ItemViewer @ Unhandled >>>> >identifier URI http://scholarworks.montana.edu/xmlui/handle/1/9083 >>>> >2015-11-05 12:49:42,156 INFO >>>> org.dspace.usage.LoggerUsageEventListener @ >>>> >>>> >anonymous:session_id=CF2CE8D5C5F6DA475B3FA1615FFFC13F:ip_addr=45.55.168.40 >>>> >:view_item:handle=1/5763 >>>> >2015-11-05 12:49:42,299 INFO >>>> >org.dspace.app.xmlui.aspect.artifactbrowser.ItemViewer @ Unhandled >>>> >identifier URI http://scholarworks.montana.edu/xmlui/handle/1/5763 >>>> >2015-11-05 12:49:45,516 INFO >>>> org.dspace.usage.LoggerUsageEventListener @ >>>> >>>> >anonymous:session_id=C70C325443657E126C8D0932DF255B2F:ip_addr=66.249.79.69 >>>> >:view_bitstream:bitstream_id=10540 >>>> >2015-11-05 12:49:46,173 INFO >>>> org.dspace.usage.LoggerUsageEventListener @ >>>> >>>> >anonymous:session_id=179E33DF409EEF11E2C83A8DBE4B40F0:ip_addr=180.76.15.24 >>>> >:view_bitstream:bitstream_id=6266 >>>> >2015-11-05 12:49:46,979 ERROR org.dspace.statistics.SolrLogger @ Failed >>>> >DNS Lookup for IP:180.76.15.24 >>>> > >>>> >Further investigation reveals the "WARN >>>> >org.apache.cocoon.components.xslt.TraxErrorListener" warning happens >>>> >quite frequently, hundreds of times/day, going back at least a few >>>> weeks. >>>> > >>>> >Any help would be appreciated. >>>> >Erik Guss >>>> >IT Systems Integration >>>> >Montana State University Library >>>> > >>>> > >>>> > >>>> >-- >>>> >You received this message because you are subscribed to the Google >>>> Groups >>>> >"DSpace Technical Support" group. >>>> >To unsubscribe from this group and stop receiving emails from it, send >>>> an >>>> >email to dspace-tech...@googlegroups.com. >>>> >To post to this group, send email to dspac...@googlegroups.com. >>>> >Visit this group at http://groups.google.com/group/dspace-tech. >>>> >For more options, visit https://groups.google.com/d/optout. >>>> > >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "DSpace Technical Support" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to dspace-tech...@googlegroups.com. >>>> To post to this group, send email to dspac...@googlegroups.com. >>>> Visit this group at https://groups.google.com/group/dspace-tech. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> All messages to this mailing list should adhere to the DuraSpace Code of >> Conduct: https://duraspace.org/about/policies/code-of-conduct/ >> --- >> You received this message because you are subscribed to the Google Groups >> "DSpace Technical Support" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to dspace-tech+unsubscr...@googlegroups.com. >> To post to this group, send email to dspace-tech@googlegroups.com. >> Visit this group at https://groups.google.com/group/dspace-tech. >> For more options, visit https://groups.google.com/d/optout. >> > > > -- > Alan Orth > alan.o...@gmail.com > https://picturingjordan.com > https://englishbulgaria.net > https://mjanja.ch > "In heaven all the interesting people are missing." ―Friedrich Nietzsche > -- Alan Orth alan.o...@gmail.com https://picturingjordan.com https://englishbulgaria.net https://mjanja.ch "In heaven all the interesting people are missing." ―Friedrich Nietzsche -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.