Issue Summary

Uninstalling and reinstalling a Connect on Forge app can fail intermittently due to a database constraint violation. This happens when the installation state of the Connect side of the app is not cleared during the uninstallation process.

Note: this issue does not happen every time and it affects Confluence apps.

Steps to Reproduce

1. Install a Connect on Forge app using the CLI (forge install commnand)
2. Uninstall the app using the Manage Apps admin screen instead of the CLI
3. Attempt to install it again with forge install

Expected Results

The app is installed and no errors are seen.

Actual Results

On the CLI, the following generic error is thrown:

Error: Error performing sync with Connect: Something went wrong while trying to sync your app with Connect. Please contact Atlassian support. For more help on this issue, please reach out to support (https://developer.atlassian.com/support)  and provide them the following request ID: <>

On the product logs (internal), there is a database constraint violation error when attempting to insert the app information in the Connect table.

Workaround

Open a ticket with the Ecosystem Support team at https://developer.atlassian.com/support to check if you are affected by this issue and clear the install state of the app if needed. Please provide the following details for investigation:

• The verbose output of the install command
• The site URL
• The Connect app key and Forge app ID