Cannot install Confluence Question (max_allowed_packet=64MB)

[Dominic Feig]

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

[Volodymyr Krupach · Accepted solution]

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

[Dominic Feig]

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

[raghavprabhu]

[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

[Mallmann]

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

[Dominic Feig]

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