Cannot install Confluence Question (max_allowed_packet=64MB)

Hello everyone,

we are setting up our 2nd Confluence installation. For this we also want to install Confluence Questions. During the installation process of this plugin the following error occurs:

"An error occurred while installing the add-on. Configure your MySQL server with a higher max_allowed_packet as described in Database Setup for MySQL."

I've tried the UPM and the direct upload. In the mysql globals we've already configured a packet size of 64MB (67108864B). What issues can else exist that block the installation process?

Thanks in advance.

Best regards, Dominic

3 answers

1 accepted

0 votes
Accepted answer

In the mysql globals we've already configured a packet size of 64MB 
Did you restart MySQL to pick your change?

Yes, I did it. Afterwards I also restarted Confluence.

0 votes

Hey Dominic,

Would you mind running the following query against your MySQL database so we can make sure the database updated this value?

SELECT @@max_allowed_packet;

Please, let us know the value returned.

Best regards,

Eduardo Mallmann

Unfortunately this shows the same value as stated in my entry post (6710884)

 
[mysqld]

max_allowed_packet=40m

character-set-server=utf8

collation-server=utf8_bin

default-storage-engine=INNODB

innodb_log_file_size=256M

 

Add the above configurations in you my.cnf  or my.ini

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,118 views 17 14
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you