Unable to create Trusted Application in Postgres

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: High
    • 1.0.3
    • Affects Version/s: 1.0
    • Component/s: Database Support

      2012-05-04 10:06:38,627 ERROR [http-7990-2] admin 606x1189x1 1gtzeuc 127.0.0.1 /plugins/servlet/applinks/auth/conf/trusted/inbound-ual/95e744f4-482a-3575-9cde-d4548ce745ca o.h.util.JDBCExceptionReporter ERROR: column "public_key" is of type oid but expression is of type
       bytea
        Hint: You will need to rewrite or cast the expression.
        Position: 95
      
      ...
      
      
      Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into trusted_app (application_id, certificate_timeout, public_key, id) values ('jira:9824068', '10000', '<stream of 294 bytes>', '1') was aborted.  Call getNextException to see the cause.
              at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2569) ~[postgresql-8.4-701.jdbc3.jar:na]
              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1796) ~[postgresql-8.4-701.jdbc3.jar:na]
              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407) ~[postgresql-8.4-701.jdbc3.jar:na]
              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2708) ~[postgresql-8.4-701.jdbc3.jar:na]
              at com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:469) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
              at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) ~[hibernate-core-3.5.6-Final.jar:3.5.6-Final]
              at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ~[hibernate-core-3.5.6-Final.jar:3.5.6-Final]
              ... 167 common frames omitted
      
      

              Assignee:
              jhinch (Atlassian)
              Reporter:
              jhinch (Atlassian)
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 0.95h
                  0.95h