Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-4616

RS: chat with emojis on MySQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 14.2.6
    • Component/s: None
    • Labels:
      None

      Description

      2020-04-01 10:00:26.644 [ajp-nio2-8021-exec-26] ERROR DBRuntimeException ^%^ I185592-J32003 
      https://lms.xyz.de/auth/BusinessGroup/3244425268/toolchat/0
      Mozilla/5.0 (iPhone; CPU iPhone OS 13_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.5 Mobile/15E148 Safari/604.1
      **RedScreen** commit failed, rollback transaction
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_sendMessageForm</compname>
      		<compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass>
      		<extendedinfo>n/a</extendedinfo>
      		<event>
      			<class&gt;org.olat.core.gui.control.Event</class&gt;
      			<command>validation ok</command>
      			<tostring>com:validation ok,org.olat.core.gui.control.Event@d62b3f02</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.instantMessaging.ui.SendMessageForm</controllername>
      		<controllername>org.olat.instantMessaging.ui.ChatController</controllername>
      		<controllername>org.olat.instantMessaging.ui.ChatManagerController</controllername>
      		<controllername>org.olat.gui.control.OlatTopNavController</controllername>
      		<controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</controllername>
      	</controllerinfo>
      </dispatchinfo>
      
      org.olat.core.logging.DBRuntimeException: commit failed, rollback transaction
       at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:573)
       at org.olat.instantMessaging.manager.InstantMessagingServiceImpl.sendMessage(InstantMessagingServiceImpl.java:210)
       at org.olat.instantMessaging.ui.ChatController.doSendMessage(ChatController.java:308)
       at org.olat.instantMessaging.ui.ChatController.event(ChatController.java:249)
       at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:250)
       at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
       at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:247)
       at org.olat.core.gui.control.DefaultController.fireEvent(DefaultController.java:194)
       at org.olat.instantMessaging.ui.SendMessageForm.formOK(SendMessageForm.java:71)
       at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:389)
       at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:206)
       at org.olat.core.gui.components.AbstractComponent$1.run(AbstractComponent.java:240)
       at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
       at org.olat.core.gui.components.AbstractComponent.fireEvent(AbstractComponent.java:238)
       at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.fireValidation(FormWrapperContainer.java:119)
       at org.olat.core.gui.components.form.flexible.impl.Form.submit(Form.java:441)
       at org.olat.core.gui.components.form.flexible.impl.Form.submit(Form.java:428)
       at org.olat.instantMessaging.ui.SendMessageForm.formInnerEvent(SendMessageForm.java:88)
       at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:430)
       at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:206)
       at org.olat.core.gui.components.AbstractComponent$1.run(AbstractComponent.java:240)
       at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
       at org.olat.core.gui.components.AbstractComponent.fireEvent(AbstractComponent.java:238)
       at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.fireFormEvent(FormWrapperContainer.java:131)
       at org.olat.core.gui.components.form.flexible.impl.Form.fireFormEvent(Form.java:717)
       at org.olat.core.gui.components.form.flexible.impl.elements.FormLinkImpl.dispatchFormRequest(FormLinkImpl.java:241)
       at org.olat.core.gui.components.form.flexible.impl.FormItemImpl.doDispatchFormRequest(FormItemImpl.java:561)
       at org.olat.core.gui.components.form.flexible.impl.Form.evalFormRequest(Form.java:296)
       at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.doDispatchRequest(FormWrapperContainer.java:100)
       at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
       at org.olat.core.gui.components.Window.doDispatchToComponent(Window.java:1218)
       at org.olat.core.gui.components.Window.dispatchRequest(Window.java:400)
       at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:284)
       at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
       at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:263)
       at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:184)
       at org.olat.core.servlets.OpenOLATServlet.executeUserRequest(OpenOLATServlet.java:269)
       at org.olat.core.servlets.OpenOLATServlet.doPost(OpenOLATServlet.java:216)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
       at org.olat.core.servlets.OpenOLATServlet.service(OpenOLATServlet.java:160)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.olat.core.servlets.HeadersFilter.doFilter(HeadersFilter.java:95)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
       at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
       at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:479)
       at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
       at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
       at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1699)
       at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
       at org.apache.tomcat.util.net.AbstractEndpoint.processSocket(AbstractEndpoint.java:1050)
       at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$4.completed(Nio2Endpoint.java:630)
       at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$4.completed(Nio2Endpoint.java:608)
       at sun.nio.ch.Invoker.invokeUnchecked(Invoker.java:126)
       at sun.nio.ch.Invoker$2.run(Invoker.java:218)
       at sun.nio.ch.AsynchronousChannelGroupImpl$1.run(AsynchronousChannelGroupImpl.java:112)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
       at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
       at java.lang.Thread.run(Thread.java:748) Caused by: javax.persistence.RollbackException: Error while committing the transaction
       at org.hibernate.internal.ExceptionConverterImpl.convertCommitException(ExceptionConverterImpl.java:81)
       at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:104)
       at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:530) ... 70 more Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement
       at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
       at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
       at org.hibernate.internal.ExceptionConverterImpl.convertCommitException(ExceptionConverterImpl.java:65) ... 72 more Caused by: org.hibernate.exception.GenericJDBCException: could not execute statement
       at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
       at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200)
       at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3226)
       at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3751)
       at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:91)
       at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
       at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
       at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
       at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
       at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:348)
       at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40)
       at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:108)
       at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1344)
       at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:435)
       at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3221)
       at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2389)
       at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:447)
       at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183)
       at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
       at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281)
       at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101)
      ... 71 more Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x8A' for column 'msg_body'
       at row 1
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
       at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
       at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)
       at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)
       at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)
       at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:87)
       at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:87)
       at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
      ... 90 more
      

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            srosse Stéphane Rossé
            Tester:
            Mandy Menzel
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: