An odd one, trying to install the Confluence Questions add-on onto the test instance and it the hangs. The last error in the logs is
[UpmAsynchronousTaskManager:thread-1] [upm.core.install.ObrPluginInstallHandler] installPluginInternal Failed to remove local OBR repository resources
If I restart confluence it faills to respond.
From my investigation, I could find that this issue may be caused because the database max packet size in MySQL is set to a low value. Is this the database that you are using?
If yes, I recommend to perform the following:
Set the MySQL packet size to a larger value (34M is the biggest known Confluence add-on - Gliffy) and restart MySQL Server. If you find this isn't large enough based on the size mentioned in the log, then you can set it larger than 34M, but 34M should be large enough to cover most cases.
shell> mysqld --max_allowed_packet=34M
Alternatively, you can do this on your MySQL server's settings by editing MySQL's
my.cnf file (often named
my.ini on Windows operating systems). Locate the
[mysqld]section in the file, and add/modify the following parameters:
[mysqld] ... max_allowed_packet = 34M ...
(i) Remember to restart MySQL services in order for the changes above to take effect. For more information, please refer to MySQL manual: http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html.
This information was taken from this KB.
I hope this helps.
Thanks for clarifying.
This might be a problem with the UPM as well. I could find a bug report with a similar behavior: https://ecosystem.atlassian.net/browse/UPM-1068
I recommend to upgrade the UPM to the latest version available since it could help fixing some bugs on the go.
Is the SQL server using the recommended settings such as the collation (
SQL_Latin1_General_CP1_CS_AS) and READ_COMMITTED_SNAPSHOT as stated in the documentation? If this problem happens in staging but not in production using the same confluence version, UPM version, then probably there is some misconfiguration in the database.
I hope this helps.
Perfect! Thanks sharing the results here :)
I'm sure this will help many others with the same issue.
Edit: I've created this KB. :)
Hey Community 👋, Following the recent release of the new editor, we will be releasing the ability for users to convert existing pages from the legacy editor to the new editor. We’ve been resp...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events