Failed to install plugin atlassian-universal-plugin-manager-plugin-2.5.jar

[Mike Rowley]

I have tried installing this in the upgrade section and also downloading the latest file and uploading it. Audit log gives me failed to install plugin everytime. I am running confluence 3.5. ALso running Atlassian Universal Plugin Manager Plugin 1.2.4. Please help.

[hsuhailah · Accepted solution]

Looks like your instance are currently running on a very old version of Universal Plugin Manager. Atlassian Universal Plugin Manager Version 2.5 is compatible with Confluence 3.5 so I'd suggest you to download the plugin .jar and manually install it (through Upload Plugin). Before that, ensure that the configured base URL (Confluence Admin > General Configuration) matches the Confluence URL you accessed via the browser.

If the upload is still failing, you can try to check the <confluence-home>/logs/atlassian-confluence.log for this error:

caused by: java.sql.BatchUpdateException: Packet forquery is too large (1238730> 1048576). You can change thisvalue on the server by setting the max_allowed_packet' variable.

If this is found, you may refer to this KB on how to fix the problem: https://confluence.atlassian.com/pages/viewpage.action?pageId=179443425

[Mike Rowley]

Thanks for the response. Quick question, I am new to all this so bare with me. I am not seeing the max_allowed_packet variable in my "my.ini file." Is that expected and I just add that line of code to under the [mysqld] section? Thanks for your help.

[hsuhailah]

At times, max_allowed_packet variable is not included in "my.ini" file. Yeah, you can just add it under [mysqld]:

[mysqld]

max_allowed_packet=1024M

transaction-isolation=READ-COMMITTED

Ensure also that your MySQL database is set to READ-COMMITTED

[Mike Rowley]

ok added lines to file. Now when I go to plugins, upgrade, it shows the Universal plugin manager. I can actually click it and it will finally show the description details and the upgrade button. But when I hit upgrade, it goes through the install and then gives this message:

An unexpected error occurred. Please refer to the logs for more information.

I go to the Audit log and I see this:

Failed to install plugin https://marketplace.atlassian.com/download/plugins/com.atlassian.upm.atlassian-universal-plugin-manager-plugin/version/137530?from=upm

The audit log doesnt really give me any useful info. What should I do next to try and solve this issue?

[hsuhailah]

Audit log won't be able to tell you much on the issue. You can check the <confluence-home>/logs/atlassian-confluence.log to find the recent error related to installing the UPM plugin. For sanity check:

• Have you double check that the configured base URL (Confluence Admin > General Configuration) matches the Confluence URL you accessed via the browser?
• Also, have you tried to manually uploading the plugin .jar again?
• Have you restarted MySQL server & Confluence after making the changes in "my.ini" file?

[Mike Rowley]

Interesting I tried one of the options you gave and I got this error:

java.lang.RuntimeException: There was a problem evicting or flushing a PluginData object
at com.atlassian.confluence.plugin.persistence.hibernate.HibernatePluginDataDao.saveOrUpdate(HibernatePluginDataDao.java:65)

caused by: net.sf.hibernate.exception.GenericJDBCException: could not insert: [com.atlassian.confluence.plugin.persistence.PluginData#51118092]
at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90)

caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2271047 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3250)

I have added that file of max_allowed_packet and I had gone to my programs and stoped the jira 4.3.4 service and then started it again, assuming that is how you restart the confluence service. But apparently the max allowed packet setting isnt taking hold...

[hsuhailah]

Also, check out this alternative ways of upgrading the UPM: https://confluence.atlassian.com/display/UPM/Upgrading+the+Universal+Plugin+Manager#UpgradingtheUniversalPluginManager-AlternativewaysofupgradingtheUPM

[Mike Rowley]

Got it to work, thanks for all your help.