Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] column "value_integer" is of type bigint but expression is of type character varying

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] column "value_integer" is of type bigint but expression is of type character varying


Chronological Thread 
  • From: John Schrader <>
  • To: "Hyzer, Chris" <>
  • Cc: "" <>
  • Subject: Re: [grouper-users] column "value_integer" is of type bigint but expression is of type character varying
  • Date: Tue, 10 Apr 2018 09:06:34 -0400
  • Ironport-phdr: 9a23:vh4EWhwpbSenQU3XCy+O+j09IxM/srCxBDY+r6Qd2ukXIJqq85mqBkHD//Il1AaPAd2Araocw8Pt8InYEVQa5piAtH1QOLdtbDQizfssogo7HcSeAlf6JvO5JwYzHcBFSUM3tyrjaRsdF8nxfUDdrWOv5jAOBBr/KRB1JuPoEYLOksi7ze+/94HdbglSmDaxfa55IQmrownWqsQYm5ZpJLwryhvOrHtIeuBWyn1tKFmOgRvy5dq+8YB6/ShItP0v68BPUaPhf6QlVrNYFygpM3o05MLwqxbOSxaE62YGXWUXlhpIBBXF7A3/U5zsvCb2qvZx1S+HNsDwULs6Wymt771zRRDqhicJNzA3/mLKhMJukK1WuwiuqwBlzoPOfI2ZKPhzc6XAdt0aX2pBWcNRWjRFDIO7b4sPCfcKM/tEoIn9vVsBtwaxChe2BOjyzTJGgnj23a080+g7DA/JwAwgH8gUv3vJstr1LrwfUeaow6XS0zrMcu5W1C775YPVfB4hpvSMUqhxccrX0UQvGBnFjlKNqYz9ITyVzP4BvHKD7+p4Te6vimgnqx1vrTi1wMcjlJXJipwPxl/a6Cp53Z45JcG4SE5hf9GrCoZfuzuAN4trRMMuW25ouDw9yr0boZ60YjIKx4g9yB7bb/yIaZOH4hb9W+qLPTh3nnZleLanixa87Eig1vD8VtOq31ZWtCVFidrMumoX1xzO7MiKTOZ28ES52TuXyQze6/1ILEIxmKrVKJMu2aI8m58cvEjfAiP6hUD7g7OKekgl/+Wl7vrrb7vpq5KaKoR6kBvxMr40lcy6Gek4MhYBX2yc+emk0b3s50z5QLFTgv03lanVrInWJMsFqqO3DAJZyIkj6xG4Dzep1NQXg2MLI05CeBKCl4TpOlfOL+7kDfqnnVihkStnyvLDM73vAZjCNWTPnbLucLph90JQ1Q8+wsxD659VD7wMJez/V0H+udDACx82KQ20w+LpCNVn0YMeXHqCAq2CMKzOsV+I/PggLPSDaYIOvjbyNuIp6ODzgn8kgVMdZ7Wm3YMLaHCkGfRrO0qZYWDrgtccCWcFoBA+QPX3iF2ZTzFTfW2yUrk45jE6E4KmEZzDSp63jLyA2ie7AoNZZnpACl+SDXfkaZ+IVOkRZyKPcYddlWlOdamzRpVlnTqurg7hgfIzK+HU6z8Vr7riz9Mz+vXekxd0+DBpWZezyWaIGkNznmVAfDQ2xqlzrFY1nnWE0a4+uPdYD9Vf6ulhVAt8OJLBmb8pQ+vuUx7MK4/aAG2tRc+rVGk8

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



Archive powered by MHonArc 2.6.19.

Top of Page