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

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