Cannot add new translation to web content with image over 1MB

• Type: Bug
• Status: Closed
• Resolution: No Longer Reproducible
• Affects Version/s: 6.2.X EE
• Fix Version/s: 6.2.X EE
• Component/s: Content Display Widgets > Language widget
• Labels: None
• Bug Type: Regression Bug

When editing published web content that includes a large image (when based on a web content structure/template with an image field), a new translation cannot be added. It seems like any image over 1 MB will cause this to occur (attaching an image that reproduced the issue during testing).

This was fixed by LPS-62717, and fixed by LPS-60301.

Steps to reproduce:
1. Navigate to Web Content admin in the Control Panel
2. Create a new Web Content structure with at least an Image field
3. Create a new Web Content template based on the structure
4. Create and publish a new Web Content article based on the structure, uploading an image over 1 MB for the Image field
5. Edit the created article, and click to "Add Translation" (and choose any language not already added)
6. Save the new translation

Expected result: the new translation will be created and added to the article draft with no errors
Actual result: "Web Content is temporarily unavailable" error message appears, along with a stack trace in the console.

Stack trace is as follows:

18:51:00,552 ERROR [http-bio-8080-exec-8][JDBCExceptionReporter:82] Packet for query is too large (3060719 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
18:51:00,562 ERROR [http-bio-8080-exec-8][render_portlet_jsp:132] null
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (3060719 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3798)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2484)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2465)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
        at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1185)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1261)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:113)
        at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:104)