Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,360,795
Community Members
 
Community Events
168
Community Groups

Fisheye Application Links - getting save error

Deleted user Feb 27, 2018
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, 


fisheye.JPG

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 

1 answer

0 votes
Deleted user Feb 27, 2018

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

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Online AMA this week: Your project management questions answered by Jira Design Lead James Rotanson

We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...

197 views 1 6
Read article

Atlassian Community Events