The state of a Confluence plugin is stored in the bandana table with the bandanakey plugin.manager.state.Map . If the 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.

How to Change a Plugin Back to Its Default State

The following is the process for resetting a plugin back to its default state:

1. Identify the plugin key in Confluence Admin >> Manage Add On >> System. As you can see in the screenshot below, the plugin key is com.atlassian.atlassian-failure-cache-plugin.
2. Shutdown Confluence.
3. Backup your database in case you need to revert the changes.
4. Run the following query in your database:

   
   

    select BANDANAVALUE from BANDANA where BANDANAKEY = 'plugin.manager.state.Map';
   

5. The result should be something similar to this:

   
   

    <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>

   
   

   

6. Note the plugin key com.atlassian.atlassian-failure-cache-plugin in the result. Remove the "com.atlassian.atlassian-failure-cache-plugin" entry from the BANDANAVALUE to re-enable the plugin.
   

   
   

   update BANDANA 
   set BANDANAVALUE='<map>
     <entry>
       <string>confluence.extra.chart</string>
       <boolean>false</boolean>
     </entry>
   </map>'
   where BANDANAKEY='plugin.manager.state.Map';
   
   

7. Clear Plugin Cache
8. Restart Confluence