Re: [dspace-tech] More hibernate problems
Thank you, Tim: It actually turned out to be my fault. I wrote a script a few weeks ago to eliminate idle postgres processes. I turned out that this script was causing my problem with both the OAI indexing and the other database related issues. This script turned out to be more aggressive than I had intended and was interfering with the normal process of the database. I appreciate your help (and the help of and suggestions of everyone else). George Kozak Cornell University On Tue, Jan 8, 2019 at 12:45 PM Tim Donohue wrote: > Hi George, > > The error that jumped out to me was the database one... "SQL Error: 0, > SQLState: 08006", as usually such error codes mean something very specific > with the database itself (Postgres). Googling that brings me to this > StackOverflow question/answer: > https://stackoverflow.com/questions/21925083/sql-error-0-sqlstate-08006 > > In StackOverflow, they note this error code 08006 is PostgreSQL returning > a Connection Failure: > https://www.postgresql.org/docs/9.2/errcodes-appendix.html > > There's some recommendations in this answer that seem reasonable: > https://stackoverflow.com/a/21925336/3750035 > > You also may want to try and connection to the database via something that > is *not* DSpace? (E.g. Are those local perl scripts using DSpace's API, or > are they connecting to Postgres directly?) It's possible that > DSpace/Hibernate isn't to blame here and that PostgreSQL is throwing errors > (check its logs) that result in connection issues or closed connections. > If PostgreSQL is *not* throwing errors and is accepting connections from > other tools, then I'd recommend looking closer at your DSpace database > configurations -- make sure all the connection info there is correct. If > DSpace & Postgres are on separate servers, you also may want to double > check that a firewall isn't getting in the way (and perhaps blocking some > requests to Postgres). > > Hopefully that gives a few ideas of what to look at to gather more info. > > Tim > > > On Tue, Jan 8, 2019 at 10:35 AM George Kozak wrote: > >> Hi... >> We are using DSpace 6.3 (XMLUI, modified Mirage2 theme). >> I reported a problem with indexing OAI recently. I get an >> error "org.hibernate.exception.JDBCConnectionException: could not extract >> ResultSet". The database logs says things like: >> "org.hibernate.TransactionException: commit failed" and "SQL Error: 0, >> SQLState: 08006" and "An I/O error occurred while sending to the backend." >> Now, I am seeing an error when we run filter-media. This has been >> working fine for a long time, and now, it is failing with: >> Exception: rollback failed >> org.hibernate.TransactionException: rollback failed at >> org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:215) >> (large stack trace afterwards) >> >> Also, I saw problems running some of my local perl scripts that gather >> data from postgres. I have scripts that build reports about submission and >> downloads, and occasionally they are failing with similar hibernate errors. >> >> I have a feeling that this is all connected, but not being a DB Guru, I >> don't know what could be happening here. I would appreciate any >> suggestions from the community. >> >> -- >> *** >> George Kozak >> Digital Library Specialist >> Cornell University Library - IT >> 218 Olin Library >> Cornell University >> Ithaca, NY 14853 >> 607-255-8924 <(607)%20255-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.
Re: [dspace-tech] More hibernate problems
Hi George, The error that jumped out to me was the database one... "SQL Error: 0, SQLState: 08006", as usually such error codes mean something very specific with the database itself (Postgres). Googling that brings me to this StackOverflow question/answer: https://stackoverflow.com/questions/21925083/sql-error-0-sqlstate-08006 In StackOverflow, they note this error code 08006 is PostgreSQL returning a Connection Failure: https://www.postgresql.org/docs/9.2/errcodes-appendix.html There's some recommendations in this answer that seem reasonable: https://stackoverflow.com/a/21925336/3750035 You also may want to try and connection to the database via something that is *not* DSpace? (E.g. Are those local perl scripts using DSpace's API, or are they connecting to Postgres directly?) It's possible that DSpace/Hibernate isn't to blame here and that PostgreSQL is throwing errors (check its logs) that result in connection issues or closed connections. If PostgreSQL is *not* throwing errors and is accepting connections from other tools, then I'd recommend looking closer at your DSpace database configurations -- make sure all the connection info there is correct. If DSpace & Postgres are on separate servers, you also may want to double check that a firewall isn't getting in the way (and perhaps blocking some requests to Postgres). Hopefully that gives a few ideas of what to look at to gather more info. Tim On Tue, Jan 8, 2019 at 10:35 AM George Kozak wrote: > Hi... > We are using DSpace 6.3 (XMLUI, modified Mirage2 theme). > I reported a problem with indexing OAI recently. I get an > error "org.hibernate.exception.JDBCConnectionException: could not extract > ResultSet". The database logs says things like: > "org.hibernate.TransactionException: commit failed" and "SQL Error: 0, > SQLState: 08006" and "An I/O error occurred while sending to the backend." > Now, I am seeing an error when we run filter-media. This has been working > fine for a long time, and now, it is failing with: > Exception: rollback failed > org.hibernate.TransactionException: rollback failed at > org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:215) > (large stack trace afterwards) > > Also, I saw problems running some of my local perl scripts that gather > data from postgres. I have scripts that build reports about submission and > downloads, and occasionally they are failing with similar hibernate errors. > > I have a feeling that this is all connected, but not being a DB Guru, I > don't know what could be happening here. I would appreciate any > suggestions from the community. > > -- > *** > George Kozak > Digital Library Specialist > Cornell University Library - IT > 218 Olin Library > Cornell University > Ithaca, NY 14853 > 607-255-8924 <(607)%20255-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 -- 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.
[dspace-tech] More hibernate problems
Hi... We are using DSpace 6.3 (XMLUI, modified Mirage2 theme). I reported a problem with indexing OAI recently. I get an error "org.hibernate.exception.JDBCConnectionException: could not extract ResultSet". The database logs says things like: "org.hibernate.TransactionException: commit failed" and "SQL Error: 0, SQLState: 08006" and "An I/O error occurred while sending to the backend." Now, I am seeing an error when we run filter-media. This has been working fine for a long time, and now, it is failing with: Exception: rollback failed org.hibernate.TransactionException: rollback failed at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:215) (large stack trace afterwards) Also, I saw problems running some of my local perl scripts that gather data from postgres. I have scripts that build reports about submission and downloads, and occasionally they are failing with similar hibernate errors. I have a feeling that this is all connected, but not being a DB Guru, I don't know what could be happening here. I would appreciate any suggestions from the community. -- *** 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.