MySQL is blocking a thread and hanging the UPM installation

Description

Hi Atlassians,

We're currently experiencing a blocking issue with MySQL and Active Objects.

ScriptRunner for Confluence uses Active Objects to save all the configurations a user has. Because of that, when the PluginEnabledEvent is fired, we essentially load the configurations from the instance. This works fine with all databases, except MySQL.

The issue happens when upgrading ScriptRunner for Confluence which contains dependant add-ons. This is very annoying since our customers have to essentially kill the instance and restart it to make it work.

When upgrading the following thread is running forever and blocks our load of our own active objects tables:

Which blocks our thread:

Environment

MySQL only

Testing Notes

Add notes...

Assignee

Unassigned

Reporter

Rafael Franco

Labels

None

Add-on Type

None

Team

None

CC

None

Risk factor

None

QA Kickoff Status

None

QA Demo Status

None

Components

Affects versions

Priority

Major
Configure