2020-10-21 08:41:13.938 [http-nio-127.0.0.1-8088-exec-7] WARN   SqlExceptionHelper ^%^ I211-J187 ^%^ org.hibernate.engine.jdbc.spi.SqlExceptionHelper ^%^ 2260992 ^%^ 127.0.0.1 ^%^ https://olat.domain.net/auth/RepositoryEntry/3309568 ^%^ Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0 ^%^ SQL Error: 1366, SQLState: 22001
2020-10-21 08:41:13.939 [http-nio-127.0.0.1-8088-exec-7] ERROR  SqlExceptionHelper ^%^ I211-J188 ^%^ org.hibernate.engine.jdbc.spi.SqlExceptionHelper ^%^ 2260992 ^%^ 127.0.0.1 ^%^ https://olat.domain.net/auth/RepositoryEntry/3309568 ^%^ Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0 ^%^ Data truncation: Incorrect string value: '\xF0\x9F\x90\xB1\xE2\x80...' for column `www-olat1_openolat_db`.`o_mail`.`body` at row 1
2020-10-21 08:41:13.939 [http-nio-127.0.0.1-8088-exec-7] WARN   DBImpl ^%^ I211-J189 ^%^ org.olat.core.commons.persistence.DBImpl ^%^ 2260992 ^%^ 127.0.0.1 ^%^ https://olat.domain.net/auth/RepositoryEntry/3309568 ^%^ Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0 ^%^ Caught Exception in DBImpl.commit. 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) 	at org.olat.core.commons.services.notifications.manager.NotificationsManagerImpl.markPublisherNews(NotificationsManagerImpl.java:1014) 	at org.olat.core.util.mail.manager.MailManagerImpl.saveDBMessage(MailManagerImpl.java:1114) 	at org.olat.core.util.mail.manager.MailManagerImpl.sendMessage(MailManagerImpl.java:697) 	at org.olat.repository.RepositoryMailing.sendEmail(RepositoryMailing.java:204) 	at org.olat.resource.accesscontrol.manager.ACFrontendManager.allowAccesToResource(ACFrontendManager.java:511) 	at org.olat.resource.accesscontrol.manager.ACFrontendManager.accessResource(ACFrontendManager.java:386) 	at org.olat.resource.accesscontrol.provider.token.ui.TokenAccessController.formOK(TokenAccessController.java:120) 	at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:389) 	at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:214) 	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:124) 	at org.olat.core.gui.components.form.flexible.impl.Form.submit(Form.java:461) 	at org.olat.core.gui.components.form.flexible.impl.Form.submit(Form.java:448) 	at org.olat.core.gui.components.form.flexible.impl.elements.FormSubmit.dispatchFormRequest(FormSubmit.java:77) 	at org.olat.core.gui.components.form.flexible.impl.FormItemImpl.doDispatchFormRequest(FormItemImpl.java:568) 	at org.olat.core.gui.components.form.flexible.impl.Form.evalFormRequest(Form.java:316) 	at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.doDispatchRequest(FormWrapperContainer.java:105) 	at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193) 	at org.olat.core.gui.components.Window.doDispatchToComponent(Window.java:1249) 	at org.olat.core.gui.components.Window.dispatchRequest(Window.java:429) 	at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:310) 	at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193) 	at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:282) 	at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:194) 	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:652) 	at org.olat.core.servlets.OpenOLATServlet.service(OpenOLATServlet.java:160) 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) 	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:97) 	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:199) 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) 	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:616) 	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) 	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818) 	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1626) 	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 	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.PersistenceException: org.hibernate.exception.DataException: 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) 	... 57 more Caused by: org.hibernate.exception.DataException: could not execute statement 	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52) 	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) 	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:3255) 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3782) 	at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:107) 	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:102) 	at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1363) 	at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:454) 	at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3213) 	at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2381) 	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) 	... 56 more Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect string value: '\xF0\x9F\x90\xB1\xE2\x80...' for column `www-olat1_openolat_db`.`o_mail`.`body` at row 1 	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) 	at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:121) 	at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:121) 	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197) 	... 75 more
2020-10-21 08:41:13.940 [http-nio-127.0.0.1-8088-exec-7] WARN   ExceptionWindowController ^%^ I211-J190 ^%^ org.olat.core.gui.exception.ExceptionWindowController ^%^ 2260992 ^%^ 127.0.0.1 ^%^ https://olat.domain.net/auth/RepositoryEntry/3309568 ^%^ Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0 ^%^ ExceptionWindowController<init>: Throwable occurred, logging the full stacktrace: org.olat.core.logging.DBRuntimeException: commit failed, rollback transaction 	at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:573) 	at org.olat.core.commons.services.notifications.manager.NotificationsManagerImpl.markPublisherNews(NotificationsManagerImpl.java:1014) 	at org.olat.core.util.mail.manager.MailManagerImpl.saveDBMessage(MailManagerImpl.java:1114) 	at org.olat.core.util.mail.manager.MailManagerImpl.sendMessage(MailManagerImpl.java:697) 	at org.olat.repository.RepositoryMailing.sendEmail(RepositoryMailing.java:204) 	at org.olat.resource.accesscontrol.manager.ACFrontendManager.allowAccesToResource(ACFrontendManager.java:511) 	at org.olat.resource.accesscontrol.manager.ACFrontendManager.accessResource(ACFrontendManager.java:386) 	at org.olat.resource.accesscontrol.provider.token.ui.TokenAccessController.formOK(TokenAccessController.java:120) 	at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:389) 	at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:214) 	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:124) 	at org.olat.core.gui.components.form.flexible.impl.Form.submit(Form.java:461) 	at org.olat.core.gui.components.form.flexible.impl.Form.submit(Form.java:448) 	at org.olat.core.gui.components.form.flexible.impl.elements.FormSubmit.dispatchFormRequest(FormSubmit.java:77) 	at org.olat.core.gui.components.form.flexible.impl.FormItemImpl.doDispatchFormRequest(FormItemImpl.java:568) 	at org.olat.core.gui.components.form.flexible.impl.Form.evalFormRequest(Form.java:316) 	at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.doDispatchRequest(FormWrapperContainer.java:105) 	at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193) 	at org.olat.core.gui.components.Window.doDispatchToComponent(Window.java:1249) 	at org.olat.core.gui.components.Window.dispatchRequest(Window.java:429) 	at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:310) 	at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193) 	at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:282) 	at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:194) 	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:652) 	at org.olat.core.servlets.OpenOLATServlet.service(OpenOLATServlet.java:160) 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) 	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:97) 	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:199) 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) 	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:616) 	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) 	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818) 	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1626) 	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 	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) 	... 55 more Caused by: javax.persistence.PersistenceException: org.hibernate.exception.DataException: 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) 	... 57 more Caused by: org.hibernate.exception.DataException: could not execute statement 	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52) 	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) 	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:3255) 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3782) 	at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:107) 	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:102) 	at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1363) 	at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:454) 	at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3213) 	at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2381) 	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) 	... 56 more Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect string value: '\xF0\x9F\x90\xB1\xE2\x80...' for column `www-olat1_openolat_db`.`o_mail`.`body` at row 1 	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) 	at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:121) 	at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:121) 	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197) 	... 75 more
2020-10-21 08:41:13.941 [http-nio-127.0.0.1-8088-exec-7] ERROR  DBRuntimeException ^%^ I211-J191 ^%^ org.olat.core.logging.DBRuntimeException ^%^ 2260992 ^%^ 127.0.0.1 ^%^ https://olat.domain.net/auth/RepositoryEntry/3309568 ^%^ Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0 ^%^ **RedScreen** commit failed, rollback transaction ::_::<dispatchinfo>  <componentinfo>   <compname>ffo_main_null</compname>   <compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass>   <extendedinfo>n/a</extendedinfo>   <event>    <class>org.olat.core.gui.control.Event</class>    <command>validation ok</command>    <tostring>com:validation ok,org.olat.core.gui.control.Event@d62b3f02</tostring>   </event>  </componentinfo>  <controllerinfo>   <controllername>org.olat.resource.accesscontrol.provider.token.ui.TokenAccessController</controllername>   <controllername>org.olat.resource.accesscontrol.ui.AccessListController</controllername>   <controllername>org.olat.course.run.CourseRuntimeController</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.core.commons.services.notifications.manager.NotificationsManagerImpl.markPublisherNews(NotificationsManagerImpl.java:1014) 	at org.olat.core.util.mail.manager.MailManagerImpl.saveDBMessage(MailManagerImpl.java:1114) 	at org.olat.core.util.mail.manager.MailManagerImpl.sendMessage(MailManagerImpl.java:697) 	at org.olat.repository.RepositoryMailing.sendEmail(RepositoryMailing.java:204) 	at org.olat.resource.accesscontrol.manager.ACFrontendManager.allowAccesToResource(ACFrontendManager.java:511) 	at org.olat.resource.accesscontrol.manager.ACFrontendManager.accessResource(ACFrontendManager.java:386) 	at org.olat.resource.accesscontrol.provider.token.ui.TokenAccessController.formOK(TokenAccessController.java:120) 	at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:389) 	at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:214) 	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:124) 	at org.olat.core.gui.components.form.flexible.impl.Form.submit(Form.java:461) 	at org.olat.core.gui.components.form.flexible.impl.Form.submit(Form.java:448) 	at org.olat.core.gui.components.form.flexible.impl.elements.FormSubmit.dispatchFormRequest(FormSubmit.java:77) 	at org.olat.core.gui.components.form.flexible.impl.FormItemImpl.doDispatchFormRequest(FormItemImpl.java:568) 	at org.olat.core.gui.components.form.flexible.impl.Form.evalFormRequest(Form.java:316) 	at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.doDispatchRequest(FormWrapperContainer.java:105) 	at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193) 	at org.olat.core.gui.components.Window.doDispatchToComponent(Window.java:1249) 	at org.olat.core.gui.components.Window.dispatchRequest(Window.java:429) 	at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:310) 	at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193) 	at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:282) 	at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:194) 	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:652) 	at org.olat.core.servlets.OpenOLATServlet.service(OpenOLATServlet.java:160) 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) 	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:97) 	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:199) 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) 	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:616) 	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) 	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818) 	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1626) 	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 	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) 	... 55 more Caused by: javax.persistence.PersistenceException: org.hibernate.exception.DataException: 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) 	... 57 more Caused by: org.hibernate.exception.DataException: could not execute statement 	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52) 	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) 	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:3255) 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3782) 	at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:107) 	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:102) 	at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1363) 	at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:454) 	at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3213) 	at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2381) 	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) 	... 56 more Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect string value: '\xF0\x9F\x90\xB1\xE2\x80...' for column `www-olat1_openolat_db`.`o_mail`.`body` at row 1 	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347) 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) 	at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:121) 	at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:121) 	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197) 	... 75 more