Thanks, Mark: This hibernate stuff is a mystery to me, but I will continue digging to try and fix my problem. George Kozak Cornell University
On Mon, Jan 7, 2019 at 12:07 PM Mark H. Wood <mwoodiu...@gmail.com> wrote: > I see that this is caused by a connection reset. Is PostgreSQL logging > anything interesting around the time that this happens? > > Remember that the DSpace connection limit should be a bit *lower* than the > Pg connection limit, because Pg reserves a few connections for > administration. > > I found > https://stackoverflow.com/questions/23951796/hibernate-could-not-extract-resultset-exception > which talks about a connection pool which times out connections but is not > set to test-on-borrow, so that the client can borrow a closed connection > and gets an error. > > On Friday, January 4, 2019 at 5:06:28 PM UTC-5, George Kozak wrote: >> >> Tim: >> I checked the max connections in postgres and dspace, and there was a >> discrepancy, but after fixing that, I am still having the same problem. I >> double checked the hibernate configs, and they are the defaults. So, I >> have attached the error trace from my oai indexing job. Perhaps, that will >> reveal something. >> George Kozak >> Cornell University >> >> On Fri, Jan 4, 2019 at 1:50 PM Tim Donohue <tdono...@duraspace.org> >> wrote: >> >>> Hi George, >>> >>> That is an odd error. It almost sounds like Hibernate is losing access >>> to the database (maybe a connection timeout or something?). >>> >>> Could you check your logs to see if there's more information around >>> *when* and *how* this error occurs. You said it's occurring at different >>> "intervals", but I'm wondering if there's any more information that can be >>> gathered from the logs (or from the full stacktrace of the error, assuming >>> one exists). >>> >>> For what it's worth, I've not seen this error before. It's hard to say >>> right now if this is a configuration error or a bug. I think we'd need more >>> information to narrow things down. It's *possible* there's something from >>> your upgrade that resulted in a misconfiguration. You may want to double >>> check that your Hibernate truly are the defaults, and that your Database >>> connection settings & pooling info looks good. You also should double >>> check that PostgreSQL (or Oracle) is configured to allow *at least* the >>> number of connections that "db.maxconnections" allows -- if you increased >>> the DSpace setting, it may be expecting more connections than your database >>> is willing to provide. >>> >>> Just a few thoughts there. >>> >>> - Tim >>> >>> On Fri, Jan 4, 2019 at 12:02 PM George Kozak <gkoz...@gmail.com> wrote: >>> >>>> Hi, Terry: >>>> I am using jdk1.8.0_74 so java 7 is not the problem. We did upgrade a >>>> few months ago, and ran into trouble immediately with the OAI >>>> index. Emilio Lorenzo and Adan Roman gave me a patch to >>>> org.dspace.xoai.app.XOAI.java to print out records being indexed in verbose >>>> mode, and that helped me locate a "bad" record that was causing our OAI >>>> index to fail. I eliminated that record, and restarted our OAI process, >>>> and then encountered the "org.hibernate.exception.JDBCConnectionException: >>>> could not extract ResultSet". It doesn't appear to be a specific record >>>> that is causing this because the crash occurs at different intervals during >>>> the index. >>>> I never adjusted the hibernate configuration (using defaults). Do you >>>> think that may be the issue? >>>> >>>> George Kozak >>>> Cornell University >>>> >>>> On Thu, Jan 3, 2019 at 4:36 PM Terry Brady <terry.br...@georgetown.edu> >>>> wrote: >>>> >>>>> George, >>>>> >>>>> I am not seeing this error. >>>>> >>>>> Is there any chance that you are using an older version of java (such >>>>> as Java 7) when you run the dspace command? >>>>> >>>>> Did you upgrade recently? >>>>> >>>>> On Thu, Jan 3, 2019 at 11:02 AM George Kozak <gkoz...@gmail.com> >>>>> wrote: >>>>> >>>>>> Hi, >>>>>> We are using DSpace 6.3 and we are seeing an error when running the >>>>>> dspace oai import -c. The Import fails with >>>>>> "org.hibernate.exception.JDBCConnectionException: could not extract >>>>>> ResultSet". Has anyone else encountered this problem? >>>>>> >>>>>> -- >>>>>> *************************** >>>>>> George Kozak >>>>>> Digital Library Specialist >>>>>> Cornell University Library - IT >>>>>> 218 Olin Library >>>>>> Cornell University >>>>>> Ithaca, NY 14853 >>>>>> 607-255-8924 >>>>>> g...@cornell.edu >>>>>> >>>>>> -- >>>>>> 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. >>>>>> >>>>> >>>>> >>>>> -- >>>>> Terry Brady >>>>> Applications Programmer Analyst >>>>> Georgetown University Library Information Technology >>>>> https://github.com/terrywbrady/info >>>>> 425-298-5498 (Seattle, WA) >>>>> >>>>> -- >>>>> 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. >>>>> >>>> >>>> >>>> -- >>>> *************************** >>>> George Kozak >>>> Digital Library Specialist >>>> Cornell University Library - IT >>>> 218 Olin Library >>>> Cornell University >>>> Ithaca, NY 14853 >>>> 607-255-8924 >>>> g...@cornell.edu >>>> >>>> -- >>>> 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. >>>> >>> -- >>> Tim Donohue >>> Technical Lead for DSpace & DSpaceDirect >>> DuraSpace.org | DSpace.org | DSpaceDirect.org >>> >> >> >> -- >> *************************** >> George Kozak >> Digital Library Specialist >> Cornell University Library - IT >> 218 Olin Library >> Cornell University >> Ithaca, NY 14853 >> 607-255-8924 >> g...@cornell.edu >> > -- > 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. > -- *************************** George Kozak Digital Library Specialist Cornell University Library - IT 218 Olin Library Cornell University Ithaca, NY 14853 607-255-8924 g...@cornell.edu -- 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.
