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

postgres error: column "value_integer" is of type bigint but expression is of type character varying

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3.1, 2.4.0, 2.3.0.patch
    • Component/s: None
    • Labels:
      None

      Description

      From: grouper-users-request@internet2.edu grouper-users-request@internet2.edu On Behalf Of John Schrader
      Sent: Saturday, April 07, 2018 11:38 AM
      To: grouper-users@internet2.edu
      Subject: [grouper-users] column "value_integer" is of type bigint but expression is of type character varying

      After patching a test install of Grouper I am seeing the following WARN events in the daemon logs.

      Thoughts ?

      Thanks!

      -John

      Daemon:
      api patches installed: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99

      Daemon log:

      2018-04-06 12:16:29,481: [pool-1-thread-5] WARN GrouperLoaderType.updateLoaderMetadataAttributes(3189) - - Non-fatal error updating metadata on group: nd:ref:eds:nd-all-active-enterprise-accounts-gs_systemOfRecord
      java.lang.RuntimeException: Problem with query in bysqlstatic: UPDATE grouper_attribute_assign_value SET hibernate_version_number = ?, context_id = ?, last_updated = ?, value_integer = ?, value_floating = ?, value_string = ?, value_member_id = ? WHERE id = ?,
      Problem in HibernateSession: HibernateSession (3c17a40f): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (4be42902),
      Problem in HibernateSession: HibernateSession (1f71a109): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (791e5c12)
      at edu.internet2.middleware.grouper.hibernate.BySql.executeSql(BySql.java:151)
      at edu.internet2.middleware.grouper.attr.value.AttributeAssignValue$1$1.callback(AttributeAssignValue.java:521)
      at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:701)
      at edu.internet2.middleware.grouper.attr.value.AttributeAssignValue$1.callback(AttributeAssignValue.java:511)
      at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:701)
      at edu.internet2.middleware.grouper.attr.value.AttributeAssignValue.saveOrUpdate(AttributeAssignValue.java:472)
      at edu.internet2.middleware.grouper.attr.value.AttributeAssignValueDelegate.internal_assignValue(AttributeAssignValueDelegate.java:260)
      at edu.internet2.middleware.grouper.attr.value.AttributeAssignValueDelegate.assignValue(AttributeAssignValueDelegate.java:217)
      at edu.internet2.middleware.grouper.attr.value.AttributeAssignValueDelegate.assignValue(AttributeAssignValueDelegate.java:324)
      at edu.internet2.middleware.grouper.attr.value.AttributeValueDelegate.assignValue(AttributeValueDelegate.java:74)
      at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.updateLoaderMetadataAttributes(GrouperLoaderType.java:3171)
      at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.access$500(GrouperLoaderType.java:119)
      at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$14.callLogic(GrouperLoaderType.java:3125)
      at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$14.callLogic(GrouperLoaderType.java:3119)
      at edu.internet2.middleware.grouper.util.GrouperCallable$1.callback(GrouperCallable.java:191)
      at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:974)
      at edu.internet2.middleware.grouper.util.GrouperCallable.callLogicWithSessionIfExists(GrouperCallable.java:188)
      at edu.internet2.middleware.grouper.util.GrouperCallable.call(GrouperCallable.java:154)
      at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      at java.lang.Thread.run(Thread.java:748)
      Caused by: org.postgresql.util.PSQLException: ERROR: column "value_integer" is of type bigint but expression is of type character varying
      Hint: You will need to rewrite or cast the expression.
      Position: 126
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:384)
      at edu.internet2.middleware.grouper.hibernate.BySql.executeSql(BySql.java:146)
      ... 21 more

      Thanks!

      John Schrader
      Identity and Access Management
      Office of Information Technologies
      University of Notre Dame

      EVERYTHING SHOULD BE MADE AS SIMPLE AS POSSIBLE, BUT NOT ANY SIMPLER
      —ALBERT EINSTEIN

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist