Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-471

log the nextException in the DB layer (e.g. for postgres)

    XMLWordPrintable

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 1.6.1
    • 1.6.1
    • API
    • None

    Description

      Log the next exception to help in stacks like this:

      2010-07-15 14:58:08,105: [main] ERROR ByObject.delete(116) - Exception in delete: edu.internet2.middleware.grouper.Membership, edu.internet2.middleware.grouper.hibernate.ByObject@39ca7b
      edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW
      at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:420)
      at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:506)
      at edu.internet2.middleware.grouper.hibernate.ByObjectStatic.save(ByObjectStatic.java:435)
      at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3ChangeLogEntryDAO.save(Hib3ChangeLogEntryDAO.java:29)
      at edu.internet2.middleware.grouper.changeLog.ChangeLogEntry.save(ChangeLogEntry.java:290)
      at edu.internet2.middleware.grouper.Membership.addMembershipDeleteChangeLog(Membership.java:2711)
      at edu.internet2.middleware.grouper.Membership.onPostDelete(Membership.java:1851)
      at edu.internet2.middleware.grouper.hibernate.ByObject.delete(ByObject.java:107)
      at edu.internet2.middleware.grouper.hibernate.ByObjectStatic$10.callback(ByObjectStatic.java:614)
      at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:496)
      at edu.internet2.middleware.grouper.hibernate.ByObjectStatic.delete(ByObjectStatic.java:601)
      at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.delete(Hib3MembershipDAO.java:1490)
      at edu.internet2.middleware.grouper.Membership$2.callback(Membership.java:496)
      at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:496)
      at edu.internet2.middleware.grouper.Membership.delete(Membership.java:484)
      at edu.internet2.middleware.grouper.Membership$3.callback(Membership.java:1333)
      at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:496)
      at edu.internet2.middleware.grouper.Membership.internal_deleteAllField(Membership.java:1312)
      at edu.internet2.middleware.grouper.Membership.internal_deleteAllFieldType(Membership.java:1419)
      at edu.internet2.middleware.grouper.Group$4.callback(Group.java:1182)
      at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:496)
      at edu.internet2.middleware.grouper.Group.delete(Group.java:1153)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at bsh.Reflect.invokeMethod(Unknown Source)
      at bsh.Reflect.invokeObjectMethod(Unknown Source)
      at bsh.Name.invokeMethod(Unknown Source)
      at bsh.BSHMethodInvocation.eval(Unknown Source)
      at bsh.BSHPrimaryExpression.eval(Unknown Source)
      at bsh.BSHPrimaryExpression.eval(Unknown Source)
      at bsh.Interpreter.eval(Unknown Source)
      at bsh.Interpreter.eval(Unknown Source)
      at bsh.Interpreter.eval(Unknown Source)
      at edu.internet2.middleware.grouper.app.gsh.ShellHelper.eval(ShellHelper.java:48)
      at edu.internet2.middleware.grouper.app.gsh.GrouperShell.run(GrouperShell.java:404)
      at edu.internet2.middleware.grouper.app.gsh.GrouperShell.grouperShellHelper(GrouperShell.java:216)
      at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:146)
      at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)
      Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
      at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
      at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
      at edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:197)
      at edu.internet2.middleware.grouper.hibernate.ByObjectStatic$7.callback(ByObjectStatic.java:448)
      at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:496)
      ... 38 more
      Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into grouper_change_log_entry_temp (change_log_type_id, context_id, created_on, string01, string02, string03, string04, string05, string06, string07, string08, string09, string10, string11, string12, id) values (3ca8c1057b3b488ea45d36f8f0bc1196, f36f7a998b24459fac7faf74552b4bf4, 1279231087816000, , members, dc4da54a21d011d4abd00004ac494ffe, uwpds, immediate, fca63bc260d7475b96e7297255620307, u:astratst:findesktop:safi:inquiry, 6f90e4d25e604b96b8de2736c632d10e, 84d1052331854cf397a96374ea933866, , , , e7454a0e07e842668d0983de79182eb9) was aborted. Call getNextException to see the cause.
      at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2537)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1328)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:351)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2674)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
      at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
      ... 46 more

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist