-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 14.2.8
-
Component/s: Course, Repository, Catalog, Learning resources
-
Labels:None
-
Funded by:
The description is indexed and PostgreSQL cannot index with the standard settings and index a text longer than ~90'000 characters. I propose to limit the size of the description to 80'000 characters (HTML included).
2020-04-20 00:01:08.013 [ajp-nio2-8009-exec-23] ERROR DBRuntimeException ^%^ I242020-J34610 ^%^ org.olat.core.logging.DBRuntimeException https://openolat.xyz.de/auth/RepositoryEntry/96567351/Settings/0/Info/0 Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:75.0) Gecko/20100101 Firefox/75.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.repository.ui.settings.RepositoryEntryInfoController</controllername> <controllername>org.olat.course.config.ui.CourseSettingsController</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.repository.RepositoryManager.setDescriptionAndName(RepositoryManager.java:993) at org.olat.repository.ui.settings.RepositoryEntryInfoController.formOK(RepositoryEntryInfoController.java:368) 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.core.gui.components.form.flexible.impl.elements.FormSubmit.dispatchFormRequest(FormSubmit.java:72) 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:660) at org.olat.core.servlets.OpenOLATServlet.service(OpenOLATServlet.java:160) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) 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:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:528) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:476) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:810) at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1777) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.net.AbstractEndpoint.processSocket(AbstractEndpoint.java:1082) at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:569) at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:547) 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) ... 57 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) ... 59 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.update(AbstractEntityPersister.java:3421) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3283) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3695) at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:149) 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) ... 58 more Caused by: org.postgresql.util.PSQLException: ERROR: index row size 3192 exceeds maximum 2712 for index "descritpion_idx" Hint: Values larger than 1/3 of a buffer page cannot be indexed. Consider a function index of an MD5 hash of the value, or use full text indexing. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2505) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2241) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:310) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:447) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:368) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:158) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:124) 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) ... 78 more