Fisheye Application Links - getting save error

[Deleted user]

adding our local Bitbucket server as an application link on Fisheye side, both links show as Connected,

when saving the link on Fisheye side, getting this error, 




 at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'Bitbucket:7528607748' for key 'uk_oauthcons_key'
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [?:1.8.0_121]
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_121]
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_121]
 at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [?:1.8.0_121]
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) [mysql-connector-java-5.1.38-bin.jar:5.1.38]
 at com.mysql.jdbc.Util.getInstance(Util.java:387) [mysql-connector-java-5.1.38-bin.jar:5.1.38]
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:932) [mysql-connector-java-5.1.38-bin.jar:5.1.38]
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878) [mysql-connector-java-5.1.38-bin.jar:5.1.38]
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814) [mysql-connector-java-5.1.38-bin.jar:5.1.38]
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478) [mysql-connector-java-5.1.38-bin.jar:5.1.38]
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625) [mysql-connector-java-5.1.38-bin.jar:5.1.38]
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551) [mysql-connector-java-5.1.38-bin.jar:5.1.38]
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861) [mysql-connector-java-5.1.38-bin.jar:5.1.38]
 at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073) [mysql-connector-java-5.1.38-bin.jar:5.1.38]
 at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009) [mysql-connector-java-5.1.38-bin.jar:5.1.38]
 at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094) [mysql-connector-java-5.1.38-bin.jar:5.1.38]
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994) [mysql-connector-java-5.1.38-bin.jar:5.1.38]
 at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) [bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
 at sun.reflect.GeneratedMethodAccessor425.invoke(Unknown Source) [?:?]
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:1.8.0_121]
 at java.lang.reflect.Method.invoke(Method.java:498) [?:1.8.0_121]
 at com.cenqua.crucible.hibernate.trackingstatements.TrackingStatementFactory$1.handleInvocation(TrackingStatementFactory.java:25) [fisheye.jar:?]
 at com.google.common.reflect.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:87) [guava-18.0.jar:?]
 at com.sun.proxy.$Proxy84.executeUpdate(Unknown Source) [?:?]
 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186) [hibernate-core-4.2.13.Final.jar:4.2.13.Final]
 ... 224 more
2018-02-27 11:35:45,464 WARN - Rolled back transaction: org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction@59b1fc14

anyway to easily clear up the DB row that causes this?

Thanks 

[Deleted user]

figured out how to do this in mysql

mysql> select * from cru_oauthcons;
+------------------+----------------------+--------------------+-------------------------------------------------------------+-------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------+---------------------+-------------------+-----------------------+--------------------------------+
| cru_oauthcons_id | cru_oauthcons_key | cru_oauthcons_name | cru_oauthcons_description | cru_oauthcons_signature | cru_oauthcons_public | cru_oauthcons_url | cru_oauthcons_three | cru_oauthcons_two | cru_oauthcons_twouser | cru_oauthcons_twoimpersonation |
+------------------+----------------------+--------------------+-------------------------------------------------------------+-------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------+---------------------+-------------------+-----------------------+--------------------------------+
| 1 | Bitbucket:7528607748 | Bitbucket | Atlassian Bitbucket at https://bitbucket.xxx.local | RSA_SHA1 | MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCtYniuIi5c8wLvJkdU4iGGpDwtKeCNO9yJFZDvqrtA0WVIWbz6UVm1d11VMc/baxLYFZi45jbUuo2Q9nhKG6ZZrAOaTxzWfL34555uk2Im7ed13hXQYHp9Oupu+70s0iwUDiqsRQCTMRWkNh6+1Y99OO4WL5wBSE+E0JjGqTieit5wIDAQAB | NULL | | | NULL | |
+------------------+----------------------+--------------------+-------------------------------------------------------------+-------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------+---------------------+-------------------+-----------------------+--------------------------------+
1 row in set (0.00 sec)


mysql> delete from cru_oauthcons where cru_oauthcons_id=1;s

[paul redmond]

wow, you just saved me pulling the last tuft of hair I have left.