Product: Confluence
Environment
| Operating System | Linux |
|---|---|
| Affect Version/s | 2.4.5 |
| JVM | |
| Database | MySQL 4.0.x |
| Application Server | Standalone |
Error Message
Cause: 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 execute JDBC batch update at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) caused by: java.sql.BatchUpdateException: Packet for query is too large (1238730 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1213)
Symptom
Diagnostics/Test
Root Cause
Installing the plugin involves sending a packet to the MySQL server that's larger than the server allows by default.
The problem is documented here.
Solution
Set max_allowed_packet to a suitable value on the MySQL server.