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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 11.5-rc-1
    • Fix Version/s: 11.5
    • Component/s: None
    • Environment:
      Windows 10 Pro 64 bit, Firefox 67, using a local instance of XWiki 11.5RC1 on MySQL 5.7
    • Tests:
      Integration
    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: