How to reset all Confluence Data Center plugins back to their default state through the database
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Prelude information
The state of a Confluence plugin is stored in the table bandana with the bandanakey plugin.manager.state.Map.
If a plugin is in the default state, its entry will not appear in the 'plugin.manager.state.Map'.
For example, atlassian-failure-cache-plugin is enabled by default; therefore, the entry state for atlassian-failure-cache-plugin does not appear in the 'plugin.manager.state.Map' unless it is disabled. The same applies for plugins that are disabled by default.
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
How to Change a Plugin Back to Its Default State
The following is the process for resetting a plugin back to its default state:
Shutdown Confluence.
Backup your database in case you need to revert the changes.
Run the following query in your database:
1select BANDANAVALUE from BANDANA where BANDANAKEY = 'plugin.manager.state.Map';The result should be something similar to this:
1 2 3 4 5 6 7 8 9 10<map> <entry> <string>com.atlassian.atlassian-failure-cache-plugin</string> <boolean>false</boolean> </entry> <entry> <string>confluence.extra.chart</string> <boolean>false</boolean> </entry> </map>Use the following SQL query to delete all non-default plugin modifications:
1 2 3update BANDANA set BANDANAVALUE='<map/>' where BANDANAKEY='plugin.manager.state.Map';Restart Confluence
Was this helpful?