Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-32200

RWiki errors in logs on clean startup

    XMLWordPrintable

    Details

      Description

      After the hibernate upgrade there's a new block of errors relating to rwiki in the startup logs on a clean database.

      16-Feb-2017 00:35:54.834 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions SQL Error: 1091, SQLState: 42000
      16-Feb-2017 00:35:54.835 ERROR [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions Can't DROP 'name'; check that column/key exists
      16-Feb-2017 00:35:54.837 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning SQL Warning Code: 1091, SQLState: 42000
      16-Feb-2017 00:35:54.838 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning Can't DROP 'name'; check that column/key exists
      16-Feb-2017 00:35:54.840 WARN [localhost-startStop-1] uk.ac.cam.caret.sakai.rwiki.component.model.impl.SQLScriptMigration.executeSchemaScript Unsuccessful data migration statement: alter table rwikihistory drop index name
      16-Feb-2017 00:35:54.886 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning SQL Warning Code: 1831, SQLState: HY000
      16-Feb-2017 00:35:54.887 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning Duplicate index 'name_idx' defined on the table 'nightly_trunk.rwikihistory'. This is deprecated and will be disallowed in a future release.
      16-Feb-2017 00:35:54.898 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions SQL Error: 1054, SQLState: 42S22
      16-Feb-2017 00:35:54.898 ERROR [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions Unknown column 'rwikihistory.rwobjectid' in 'where clause'
      16-Feb-2017 00:35:54.899 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning SQL Warning Code: 1054, SQLState: 42S22
      16-Feb-2017 00:35:54.899 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning Unknown column 'rwikihistory.rwobjectid' in 'where clause'
      16-Feb-2017 00:35:54.900 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning SQL Warning Code: 1105, SQLState: HY000
      16-Feb-2017 00:35:54.900 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning Unknown error
      16-Feb-2017 00:35:54.900 WARN [localhost-startStop-1] uk.ac.cam.caret.sakai.rwiki.component.model.impl.SQLScriptMigration.executeSchemaScript Unsuccessful data migration statement: update rwikihistory, rwikiobject 	set 	rwikihistory.name = rwikiobject.name,	rwikihistory.realm = rwikiobject.realm,	rwikihistory.referenced = rwikiobject.referenced,	rwikihistory.owner = rwikiobject.owner,	rwikihistory.ownerRead = rwikiobject.ownerRead,	rwikihistory.ownerWrite = rwikiobject.ownerWrite,	rwikihistory.ownerAdmin = rwikiobject.ownerAdmin,	rwikihistory.groupRead = rwikiobject.groupRead,	rwikihistory.groupWrite = rwikiobject.groupWrite,	rwikihistory.groupAdmin = rwikiobject.groupAdmin,	rwikihistory.publicRead = rwikiobject.publicRead,	rwikihistory.publicWrite = rwikiobject.publicWrite,	rwikihistory.rwikiobjectid = rwikiobject.id  where rwikihistory.rwobjectid = rwikiobject.id and rwikihistory.rwikiobjectid is null
      16-Feb-2017 00:35:54.914 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions SQL Error: 1054, SQLState: 42S22
      16-Feb-2017 00:35:54.914 ERROR [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions Unknown column 'rwobjectid' in 'field list'
      16-Feb-2017 00:35:54.915 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning SQL Warning Code: 1054, SQLState: 42S22
      16-Feb-2017 00:35:54.915 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning Unknown column 'rwobjectid' in 'field list'
      16-Feb-2017 00:35:54.915 WARN [localhost-startStop-1] uk.ac.cam.caret.sakai.rwiki.component.model.impl.SQLScriptMigration.executeSchemaScript Unsuccessful data migration statement: update rwikihistory 	set 	rwikiobjectid = rwobjectid	where rwikiobjectid is null
      16-Feb-2017 00:35:54.934 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning SQL Warning Code: 1831, SQLState: HY000
      16-Feb-2017 00:35:54.934 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning Duplicate index 'rwikiobjectid_idx' defined on the table 'nightly_trunk.rwikihistory'. This is deprecated and will be disallowed in a future release.
      16-Feb-2017 00:35:54.942 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions SQL Error: 1054, SQLState: 42S22
      16-Feb-2017 00:35:54.942 ERROR [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions Unknown column 'content' in 'field list'
      16-Feb-2017 00:35:54.943 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning SQL Warning Code: 1054, SQLState: 42S22
      16-Feb-2017 00:35:54.943 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning Unknown column 'content' in 'field list'
      16-Feb-2017 00:35:54.943 WARN [localhost-startStop-1] uk.ac.cam.caret.sakai.rwiki.component.model.impl.SQLScriptMigration.executeSchemaScript Unsuccessful data migration statement: insert into rwikicurrentcontent ( id, rwikiid, content )  select id,id,content from rwikiobject 
      16-Feb-2017 00:35:54.948 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions SQL Error: 1054, SQLState: 42S22
      16-Feb-2017 00:35:54.948 ERROR [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions Unknown column 'content' in 'field list'
      16-Feb-2017 00:35:54.949 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning SQL Warning Code: 1054, SQLState: 42S22
      16-Feb-2017 00:35:54.949 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning Unknown column 'content' in 'field list'
      16-Feb-2017 00:35:54.950 WARN [localhost-startStop-1] uk.ac.cam.caret.sakai.rwiki.component.model.impl.SQLScriptMigration.executeSchemaScript Unsuccessful data migration statement: insert into rwikihistorycontent ( id, rwikiid, content )  select id, id, content from rwikihistory 
      16-Feb-2017 00:35:54.971 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions SQL Error: 1054, SQLState: 42S22
      16-Feb-2017 00:35:54.971 ERROR [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions Unknown column 'rwikihistory.user' in 'field list'
      16-Feb-2017 00:35:54.972 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning SQL Warning Code: 1054, SQLState: 42S22
      16-Feb-2017 00:35:54.972 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning Unknown column 'rwikihistory.user' in 'field list'
      16-Feb-2017 00:35:54.973 WARN [localhost-startStop-1] uk.ac.cam.caret.sakai.rwiki.component.model.impl.SQLScriptMigration.executeSchemaScript Unsuccessful data migration statement: update rwikihistory set rwikihistory.userid = rwikihistory.user
      16-Feb-2017 00:35:54.977 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions SQL Error: 1054, SQLState: 42S22
      16-Feb-2017 00:35:54.977 ERROR [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions Unknown column 'rwikiobject.user' in 'field list'
      16-Feb-2017 00:35:54.979 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning SQL Warning Code: 1054, SQLState: 42S22
      16-Feb-2017 00:35:54.980 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning Unknown column 'rwikiobject.user' in 'field list'
      16-Feb-2017 00:35:54.980 WARN [localhost-startStop-1] uk.ac.cam.caret.sakai.rwiki.component.model.impl.SQLScriptMigration.executeSchemaScript Unsuccessful data migration statement: update rwikiobject set rwikiobject.userid = rwikiobject.user
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  ern Earle R Nietzel
                  Reporter:
                  jonespm Matthew Jones
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code