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. :)
Hi my Community friends! For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs