Details
-
Bug
-
Resolution: Fixed
-
Blocker
-
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
- Configure and create a fresh XWiki 11.5RC1 instance with MySQL 5.7
- Go to Wiki Index
- Click 'Create Wiki'
- Type a Pretty Name for the new subwiki (e.g. subwikiglobal)
- Select 'Standard Flavor'
- Click 'Next Step'
- Select an 'User Scope' and a 'Membership Type'
- 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
- is duplicated by
-
XWIKI-16397 Subwikis cannot be properly created on MySQL 8 using version 8 connector
- Closed