Database query

[Gajanan Sasane]

Hi,
I just want to know when and why the following query is running and what is the effect or benefit of running Jira.
delete from pluginstate;

Thanks in Advance

[Pavel Junek]

Hi,

I would say that this query is mainly used for the problem with the start of Addons in Jira. You can look here, for example Jira startup fails with message that required plugins are not started 

Pavel

[Nic Brough -Adaptavist-]

Indeed.  I would want to question why you're asking this question, there's a problem behind it that you've not told us about!

(And yes, I'd only expect to see that being run when you've got apps misbehaving and you're trying to clear things out)

[Radek Dostál]

pluginstate stores a list of plugins being disabled/enabled, if I'm not mistaken and remember someone saying this right, this table does not receive rows automatically, I believe you have to first manually disable/enable a plugin in UPM for it to receive a row in pluginstate.

I imagine that if you delete all rows from it, then all plugins become "enabled" on your next jira start up, but truth be told I didn't touch thistable in too long a while, it's not really a very known or useful table unless you're having problems starting Jira due to some plugin timing out during start up.

You can see how it's used for example in this kba https://confluence.atlassian.com/jirakb/jira-startup-fails-with-message-that-required-plugins-are-not-started-254738702.html

What I don't see is the need to run that delete unless you have a very specific reason to, because plugin status should be managed by UPM specifically, not by someone disabling/enabling them in the db.