Loading...

Details

Type: Bug
Resolution: Fixed
Priority: Blocker
Fix Version/s: 11.5
Affects Version/s: 11.5-rc-1
Component/s: None
Labels:
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

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

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

2019_06_19.output_MySQL.log
570 kB
19/Jun/19 13:18

Issue Links

is duplicated by

XWIKI-16397 Subwikis cannot be properly created on MySQL 8 using version 8 connector

Closed

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

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates