Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-58675

Exceptions are thrown when deployed the mail portlet

    Details

    • Story Points:
      12
    • Fix Priority:
      3

      Description

      Steps to reproduce:

      1. Started the server and configure mail
      2. Deployed the Mail portlet
      3. Add one gmail account
      4. Refresh the page

      Expected result:
      No exception is thrown on the console.

      Actual result:
      Exceptions are thrown on the console:

      02:38:44,140 ERROR [liferay/mail_synchronizer-1][JDBCExceptionReporter:234] Incorrect string value: '\xF0\x9F\x91\x8C\xF0\x9F...' for column 'subject' at row 1
      02:38:44,679 ERROR [liferay/mail_synchronizer-1][ParallelDestination:55] Unable to process message {destinationName=liferay/mail_synchronizer, response=null, responseDestinationName=null, responseId=null, payload=null, values={defaultLocale=en_US, messagesPerPage=0, permissionChecker=com.liferay.portal.kernel.util.TransientValue@5b796f3a, principalName=20163, accountId=20779, siteDefaultLocale=en_US, password=********, folderId=0, groupId=0, userId=20163, command=synchronize, pageNumber=0, companyId=20118, messageId=0, themeDisplayLocale=en_US}}
      com.liferay.portal.kernel.messaging.MessageListenerException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
      	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:32)
      	at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:72)
      	at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:52)
      	at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:756)
      	at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:667)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
      	at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:33)
      	at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:177)
      	at com.liferay.portal.kernel.dao.orm.ClassLoaderSession.flush(ClassLoaderSession.java:282)
      	at com.liferay.portal.dao.orm.hibernate.PortletSessionFactoryImpl.closeSession(PortletSessionFactoryImpl.java:41)
      	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.closeSession(BasePersistenceImpl.java:92)
      	at com.liferay.mail.service.persistence.impl.MessagePersistenceImpl.updateImpl(MessagePersistenceImpl.java:1560)
      	at com.liferay.mail.service.persistence.impl.MessagePersistenceImpl.updateImpl(MessagePersistenceImpl.java:67)
      	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:335)
      	at com.liferay.mail.service.impl.MessageLocalServiceImpl.addMessage(MessageLocalServiceImpl.java:81)
      	at sun.reflect.GeneratedMethodAccessor1134.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:606)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:149)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:93)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:55)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:123)
      	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:173)
      	at com.sun.proxy.$Proxy786.addMessage(Unknown Source)
      	at com.liferay.mail.service.MessageLocalServiceUtil.addMessage(MessageLocalServiceUtil.java:63)
      	at com.liferay.mail.imap.IMAPAccessor.storeEnvelopes(IMAPAccessor.java:644)
      	at com.liferay.mail.imap.IMAPAccessor.storeEnvelopes(IMAPAccessor.java:597)
      	at com.liferay.mail.mailbox.IMAPMailbox.synchronize(IMAPMailbox.java:370)
      	at com.liferay.mail.messaging.MailSynchronizationMessageListener.synchronize(MailSynchronizationMessageListener.java:101)
      	at com.liferay.mail.messaging.MailSynchronizationMessageListener.doReceive(MailSynchronizationMessageListener.java:38)
      	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:26)
      	... 5 more
      Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
      	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
      	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
      	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
      	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.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
      	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
      	at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:174)
      	... 28 more
      Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xF0\x9F\x91\x8C\xF0\x9F...' for column 'subject' at row 1
      	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054)
      	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
      	at com.zaxxer.hikari.proxy.StatementProxy.executeBatch(StatementProxy.java:127)
      	at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeBatch(HikariPreparedStatementProxy.java)
      	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
      	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
      	... 34 more
      Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x91\x8C\xF0\x9F...' for column 'subject' at row 1
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
      	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)
      	... 39 more
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              yvonne.han Yvonne Han
              Reporter:
              yvonne.han Yvonne Han
              Participants of an Issue:
              Recent user:
              Esther Sanz
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 9 weeks, 3 days ago

                  Packages

                  Version Package
                  7.0.0 Alpha 2