Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-16489

Errors in console related to missing tables when creating a subwiki on MySQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 11.5
    • 11.5-rc-1
    • None
    • Windows 10 Pro 64 bit, Firefox 67, using a local instance of XWiki 11.5RC1 on MySQL 5.7
    • Integration
    • Unknown
    • N/A
    • N/A

    Description

      STEPS TO REPRODUCE

      1. Configure and create a fresh XWiki 11.5RC1 instance with MySQL 5.7
      2. Go to Wiki Index
      3. Click 'Create Wiki'
      4. Type a Pretty Name for the new subwiki (e.g. subwikiglobal)
      5. Select 'Standard Flavor'
      6. Click 'Next Step'
      7. Select an 'User Scope' and a 'Membership Type'
      8. Click 'Create'

      EXPECTED RESULTS

      The subwiki is created without any errors.

      ACTUAL RESULTS

      There are some errors in console. Partial stacktrace:

      2019-06-19 11:57:29,223 [com.xpn.xwiki.internal.WikiInitializerJob@2f5d80e4([initialization, wiki, subwikiglobal])] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1146, SQLState: 42S02 
      2019-06-19 11:57:29,224 [com.xpn.xwiki.internal.WikiInitializerJob@2f5d80e4([initialization, wiki, subwikiglobal])] ERROR o.h.e.j.s.SqlExceptionHelper   - Table 'subwikiglobal.xwikidbversion' doesn't exist 
      2019-06-19 11:57:29,230 [com.xpn.xwiki.internal.WikiInitializerJob@2f5d80e4([initialization, wiki, subwikiglobal])] ERROR .HibernateDataMigrationManager - Database subwikiglobal seems to be inaccessible, please check your configuration! 
      com.xpn.xwiki.store.migration.DataMigrationException: Failed to get the database version
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.getDBVersionFromDatabase(HibernateDataMigrationManager.java:139)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.getDataMigrationStatus(AbstractDataMigrationManager.java:422)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.getDatabaseStatus(AbstractDataMigrationManager.java:565)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:533)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:569)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:530)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:707)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:577)
      	at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:909)
      	at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:365)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2007)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2069)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1395)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1362)
      	at com.xpn.xwiki.internal.WikiInitializerJob.runInternal(WikiInitializerJob.java:108)
      	at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:236)
      	at org.xwiki.job.AbstractJob.run(AbstractJob.java:213)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      	at java.lang.Thread.run(Unknown Source)
      Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:826)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:889)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.getDBVersionFromDatabase(HibernateDataMigrationManager.java:124)
      	... 19 common frames omitted
      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      	at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
      	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1538)
      	at org.hibernate.query.Query.getResultList(Query.java:165)
      	at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:76)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$1.doInHibernate(HibernateDataMigrationManager.java:133)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$1.doInHibernate(HibernateDataMigrationManager.java:125)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:820)
      	... 21 common frames omitted
      Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
      	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.extract(ResultSetReturnImpl.java:69)
      	at org.hibernate.loader.Loader.getResultSet(Loader.java:2171)
      	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1934)
      	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1896)
      	at org.hibernate.loader.Loader.doQuery(Loader.java:936)
      	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:339)
      	at org.hibernate.loader.Loader.doList(Loader.java:2693)
      	at org.hibernate.loader.Loader.doList(Loader.java:2676)
      	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2510)
      	at org.hibernate.loader.Loader.list(Loader.java:2505)
      	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504)
      	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:396)
      	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
      	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1537)
      	at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1561)
      	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1529)
      	... 26 common frames omitted
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'subwikiglobal.xwikidbversion' doesn't exist
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
      	at java.lang.reflect.Constructor.newInstance(Unknown Source)
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
      	at com.mysql.jdbc.Util.getInstance(Util.java:408)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
      	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:2495)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
      	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
      	... 41 common frames omitted
      2019-06-19 11:57:29,241 [com.xpn.xwiki.internal.WikiInitializerJob@2f5d80e4([initialization, wiki, subwikiglobal])] ERROR c.x.x.XWiki                    - Failed to initialize mandatory document 
      com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [subwikiglobal:XWiki.Notifications.Code.NotificationFilterDisplayerClass]
      	at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1039)
      	at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:365)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2007)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2069)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1395)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1362)
      	at com.xpn.xwiki.internal.WikiInitializerJob.runInternal(WikiInitializerJob.java:108)
      	at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:236)
      	at org.xwiki.job.AbstractJob.run(AbstractJob.java:213)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      	at java.lang.Thread.run(Unknown Source)
      Caused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while switching to database subwikiglobal
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:575)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:530)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:707)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:577)
      	at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:909)
      	... 11 common frames omitted
      Caused by: com.xpn.xwiki.store.migration.DataMigrationException: Database subwikiglobal seems to be inaccessible, please check your configuration!
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.getDatabaseStatus(AbstractDataMigrationManager.java:570)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:533)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:569)
      	... 15 common frames omitted
      Caused by: com.xpn.xwiki.store.migration.DataMigrationException: Failed to get the database version
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.getDBVersionFromDatabase(HibernateDataMigrationManager.java:139)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.getDataMigrationStatus(AbstractDataMigrationManager.java:422)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.getDatabaseStatus(AbstractDataMigrationManager.java:565)
      	... 17 common frames omitted
      Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:826)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:889)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.getDBVersionFromDatabase(HibernateDataMigrationManager.java:124)
      	... 19 common frames omitted
      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      	at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
      	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1538)
      	at org.hibernate.query.Query.getResultList(Query.java:165)
      	at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:76)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$1.doInHibernate(HibernateDataMigrationManager.java:133)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$1.doInHibernate(HibernateDataMigrationManager.java:125)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:820)
      	... 21 common frames omitted
      Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
      	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.extract(ResultSetReturnImpl.java:69)
      	at org.hibernate.loader.Loader.getResultSet(Loader.java:2171)
      	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1934)
      	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1896)
      	at org.hibernate.loader.Loader.doQuery(Loader.java:936)
      	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:339)
      	at org.hibernate.loader.Loader.doList(Loader.java:2693)
      	at org.hibernate.loader.Loader.doList(Loader.java:2676)
      	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2510)
      	at org.hibernate.loader.Loader.list(Loader.java:2505)
      	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504)
      	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:396)
      	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
      	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1537)
      	at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1561)
      	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1529)
      	... 26 common frames omitted
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'subwikiglobal.xwikidbversion' doesn't exist
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
      	at java.lang.reflect.Constructor.newInstance(Unknown Source)
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
      	at com.mysql.jdbc.Util.getInstance(Util.java:408)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
      	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:2495)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
      	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
      	... 41 common frames omitted
      	

      However, in browser there were no errors and the subwiki could be accessed.

      The issue could not be reproduced in XWiki 11.4

      Attachments

        Issue Links

          Activity

            People

              tmortagne Thomas Mortagne
              iandriuta Ilie Andriuta
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: