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

Title or URL too long for blog

    XMLWordPrintable

    Details

      Description

      Error during upgrade. It's only critical because it breaks the update process and following upgrades steps are not processed.

      2017-08-18 14:38:14,191 [ActiveMQ Session Task-1] ERROR SqlExceptionHelper  - ERROR: value too long for type character varying(1024)
      2017-08-18 14:38:14,194 [ActiveMQ Session Task-1] ERROR OLATUpgrade_12_0_0  - OLAT::ERROR ^%^ N2-E7 ^%^ org.olat.upgrade ^%^ n/a ^%^ n/a ^%^ n/a ^%^ n/a
      >>>stack of 1.cause::javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not execute statement
      ->  at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147)
          at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)
          at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:162)
          at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:787)
          at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:765)
          at org.olat.modules.webFeed.manager.FeedDAO.createFeed(FeedDAO.java:64)
          at org.olat.modules.webFeed.manager.FeedManagerImpl.importFeedFromXML(FeedManagerImpl.java:818)
          at org.olat.upgrade.OLATUpgrade_12_0_0.upgradeBlogXmlToDb(OLATUpgrade_12_0_0.java:152)
          at org.olat.upgrade.OLATUpgrade_12_0_0.doPostSystemInitUpgrade(OLATUpgrade_12_0_0.java:127)
          at org.olat.upgrade.UpgradeManagerImpl.doPostSystemInitUpgrades(UpgradeManagerImpl.java:78)
          at org.olat.upgrade.UpgradeManager.event(UpgradeManager.java:204)
      >>>stack of 2.cause::org.hibernate.exception.DataException: could not execute statement
      ->  at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:118)
          at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
          at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
          at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
          at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
          at org.hibernate.dialect.identity.GetGeneratedKeysDelegate.executeAndExtract(GetGeneratedKeysDelegate.java:57)
          at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:42)
          at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2909)
          at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3480)
          at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
          at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:626)
      >>>stack of 3.cause::org.postgresql.util.PSQLException: ERROR: value too long for type character varying(1024)
      -> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
         at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:622)
         at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:472)
         at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:429)
         at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
         at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:205)
         at org.hibernate.dialect.identity.GetGeneratedKeysDelegate.executeAndExtract(GetGeneratedKeysDelegate.java:57)
         at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:42)
      2017-08-18 14:38:14,194 [ActiveMQ Session Task-1] WARN  DBImpl  - OLAT::WARN ^%^ N2-W16 ^%^ org.olat.core.commons.persistence ^%^ n/a ^%^ n/a ^%^ n/a ^%^ n/a
      Caught Exception in DBImpl.commit.
      >>>stack of 1.cause::org.olat.core.logging.DBRuntimeException: Try to commit a transaction in error status
      -> at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:720)
         at org.olat.core.commons.persistence.DBImpl.commitAndCloseSession(DBImpl.java:671)
         at org.olat.upgrade.OLATUpgrade_12_0_0.upgradeBlogXmlToDb(OLATUpgrade_12_0_0.java:157)
         at org.olat.upgrade.OLATUpgrade_12_0_0.doPostSystemInitUpgrade(OLATUpgrade_12_0_0.java:127)
         at org.olat.upgrade.UpgradeManagerImpl.doPostSystemInitUpgrades(UpgradeManagerImpl.java:78)
         at org.olat.upgrade.UpgradeManager.event(UpgradeManager.java:204)
         at org.olat.core.util.event.AbstractEventBus$2.run(AbstractEventBus.java:171)
         at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
         at org.olat.core.util.event.AbstractEventBus.doFire(AbstractEventBus.java:168)
         at org.olat.core.util.event.AbstractEventBus.doFire(AbstractEventBus.java:141)
         at org.olat.commons.coordinate.cluster.jms.ClusterEventBus.serveMessage(ClusterEventBus.java:336)
      >>>stack of 2.cause::java.lang.Exception: olat_rtexception_stackgenerator
      -> at org.olat.core.logging.OLATRuntimeException.<init>(OLATRuntimeException.java:57)
         at org.olat.core.logging.OLATRuntimeException.<init>(OLATRuntimeException.java:79)
         at org.olat.core.logging.DBRuntimeException.<init>(DBRuntimeException.java:44)
         at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:720)
         at org.olat.core.commons.persistence.DBImpl.commitAndCloseSession(DBImpl.java:671)
         at org.olat.upgrade.OLATUpgrade_12_0_0.upgradeBlogXmlToDb(OLATUpgrade_12_0_0.java:157)
         at org.olat.upgrade.OLATUpgrade_12_0_0.doPostSystemInitUpgrade(OLATUpgrade_12_0_0.java:127)
         at org.olat.upgrade.UpgradeManagerImpl.doPostSystemInitUpgrades(UpgradeManagerImpl.java:78)
         at org.olat.upgrade.UpgradeManager.event(UpgradeManager.java:204)
         at org.olat.core.util.event.AbstractEventBus$2.run(AbstractEventBus.java:171
          at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
      

        Attachments

          Activity

            People

            Assignee:
            uhensler Urs Hensler
            Reporter:
            srosse Stéphane Rossé
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours
                2h