Grouper Users - Open Discussion List

[John Schrader <>]

Yes patch 101 did the trick. Thank you!

fwiw we are running AWS  Aurora PostgreSQL 9.6.3 with this test instance.

-John

On Mon, Apr 9, 2018 at 8:38 PM, Hyzer, Chris <> wrote:

Can you please install api patch 2.3, 101, and it should work. 

 

https://bugs.internet2.edu/jira/browse/GRP-1729

 

Btw, I tried Grouper on postgres v10 and it didn’t work, but v9 did work.  Has anyone else had this experience?

 

I get pooling errors:

 

Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.

 

Thanks

Chris

 

From: [mailto:] On Behalf Of John Schrader
Sent: Saturday, April 07, 2018 11:38 AM
To:
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

--

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