Confluence Plugin설치시 com.mysql.jdbc.PacketTooBigException 발생

사내에서 사용하는 Confluence (3.4.2버전) 의 Calendar Plugin이 드디어 나왔다.

관련 링크 : https://plugins.atlassian.com/plugin/details/153?versionId=21689

그동안 낮은 버전밖에 지원하지 않아서,
Calendar plugin을 설치되지 않는 최신 버전의 설치까지 망설였을 정도였는데,
간만에 검색해보니 최신버전이 어느샌가 나와있었던 것이다.

Universal Plugin Manager에서 Install 버튼을 누르는 순간. 에러가 발생하였다.
log를 뒤져보니..
아래와 같은 로그가 찍혀있었다.

중략..
Caused by: net.sf.hibernate.exception.GenericJDBCException: could not insert: [com.atlassian.confluence.plugin.persistence.PluginData#3866628]
        at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90)
        at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79)
        at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
        at net.sf.hibernate.persister.AbstractEntityPersister.convert(AbstractEntityPersister.java:1331)
        at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:472)
        at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
        at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
        at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2447)
        at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2433)
        at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2390)
        at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2259)
        at com.atlassian.confluence.plugin.persistence.hibernate.HibernatePluginDataDao.saveOrUpdate(HibernatePluginDataDao.java:60)
        ... 121 more
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1141938 > 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)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1940)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2395)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2313)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2298)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
        at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
        at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
        ... 128 more

뭐.. 그래도 간단히 해결할 수 있는 문제다.
MySQL 의 max_allowed_packet 설정을 변경하자.

shell> mysqld --max_allowed_packet=32M

관련 링크 : http://confluence.atlassian.com/display/CONFKB/Getting+PacketTooBigException+Error+%27Packet+for+query+is+too+large%27