XWiki initialization 50% failed

Help / Discuss
1

After the xwiki server restarts unexpectedly, the following error will appear when accessing xwiki XWiki initialization 50% …, I checked the log file catalina.out of tomcat and found the following error:

2023-01-03 14:00:03,547 [XWiki initialization] ERROR c.x.x.s.DBCPConnectionProvider - Could not create a DBCP pool. There is an error in the Hibernate configuration file, please review it. 
java.sql.SQLException: Cannot create PoolableConnectionFactory (null,  message from server: "Host '192.168.3.81' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'")
	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:653)
	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:531)
	at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:731)
	at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:225)
	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:107)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:246)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:146)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:101)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
	at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:175)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
	at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:173)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:127)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:86)
	at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:479)
	at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:85)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:709)
	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.build(HibernateStore.java:331)
	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.initHibernate(HibernateStore.java:250)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernateSynchronized(XWikiHibernateBaseStore.java:481)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:474)
	at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1008)
	at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:395)
	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2184)
	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2246)
	at com.xpn.xwiki.XWiki.getXClass(XWiki.java:7047)
	at com.xpn.xwiki.objects.BaseCollection.getXClass(BaseCollection.java:294)
	at org.xwiki.extension.xar.internal.job.diff.DocumentUnifiedDiffBuilder.isPrivateProperty(DocumentUnifiedDiffBuilder.java:256)
	at org.xwiki.extension.xar.internal.job.diff.DocumentUnifiedDiffBuilder.addObjectPropertyDiff(DocumentUnifiedDiffBuilder.java:246)
	at org.xwiki.extension.xar.internal.job.diff.DocumentUnifiedDiffBuilder.addObjectDiff(DocumentUnifiedDiffBuilder.java:225)
	at org.xwiki.extension.xar.internal.job.diff.DocumentUnifiedDiffBuilder.addObjectDiff(DocumentUnifiedDiffBuilder.java:202)
	at org.xwiki.extension.xar.internal.job.diff.DocumentUnifiedDiffBuilder.addObjectDiffs(DocumentUnifiedDiffBuilder.java:174)
	at org.xwiki.extension.xar.internal.job.diff.DocumentUnifiedDiffBuilder.diff(DocumentUnifiedDiffBuilder.java:85)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentCustomizationDetector.isCustomized(InstalledExtensionDocumentCustomizationDetector.java:95)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentCustomizationDetector.lambda$isCustomized$0(InstalledExtensionDocumentCustomizationDetector.java:86)
	at java.base/java.util.stream.MatchOps$1MatchSink.accept(MatchOps.java:90)
	at java.base/java.util.ArrayList$ArrayListSpliterator.tryAdvance(ArrayList.java:1632)
	at java.base/java.util.stream.ReferencePipeline.forEachWithCancel(ReferencePipeline.java:127)
	at java.base/java.util.stream.AbstractPipeline.copyIntoWithCancel(AbstractPipeline.java:502)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:488)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
	at java.base/java.util.stream.MatchOps$MatchOp.evaluateSequential(MatchOps.java:230)
	at java.base/java.util.stream.MatchOps$MatchOp.evaluateSequential(MatchOps.java:196)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.allMatch(ReferencePipeline.java:533)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentCustomizationDetector.isCustomized(InstalledExtensionDocumentCustomizationDetector.java:86)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.updateCustomizedFlag(InstalledExtensionDocumentListener.java:132)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.addExtensionDocument(InstalledExtensionDocumentListener.java:153)
	at java.base/java.util.HashMap$KeySpliterator.forEachRemaining(HashMap.java:1620)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.forEachExtensionDocument(InstalledExtensionDocumentListener.java:166)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.addExtensionDocuments(InstalledExtensionDocumentListener.java:147)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.lambda$addExtensionDocuments$1(InstalledExtensionDocumentListener.java:140)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.addExtensionDocuments(InstalledExtensionDocumentListener.java:140)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.onEvent(InstalledExtensionDocumentListener.java:115)
	at org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:320)
	at org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:285)
	at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117)
	at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:246)
	at org.xwiki.job.AbstractJob.run(AbstractJob.java:223)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLException: null,  message from server: "Host '192.168.3.81' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
	at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52)
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:374)
	at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:106)
	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:649)
	... 69 common frames omitted
2023-01-03 14:00:03,547 [XWiki initialization] ERROR c.x.x.o.BaseCollection         - Failed to get class [xwiki:XWiki.WikiMacroClass] 
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.WikiMacroClass()]
	at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1155)
	at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:395)
	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2184)
	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2246)
	at com.xpn.xwiki.XWiki.getXClass(XWiki.java:7047)
	at com.xpn.xwiki.objects.BaseCollection.getXClass(BaseCollection.java:294)
	at org.xwiki.extension.xar.internal.job.diff.DocumentUnifiedDiffBuilder.isPrivateProperty(DocumentUnifiedDiffBuilder.java:256)
	at org.xwiki.extension.xar.internal.job.diff.DocumentUnifiedDiffBuilder.addObjectPropertyDiff(DocumentUnifiedDiffBuilder.java:246)
	at org.xwiki.extension.xar.internal.job.diff.DocumentUnifiedDiffBuilder.addObjectDiff(DocumentUnifiedDiffBuilder.java:225)
	at org.xwiki.extension.xar.internal.job.diff.DocumentUnifiedDiffBuilder.addObjectDiff(DocumentUnifiedDiffBuilder.java:202)
	at org.xwiki.extension.xar.internal.job.diff.DocumentUnifiedDiffBuilder.addObjectDiffs(DocumentUnifiedDiffBuilder.java:174)
	at org.xwiki.extension.xar.internal.job.diff.DocumentUnifiedDiffBuilder.diff(DocumentUnifiedDiffBuilder.java:85)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentCustomizationDetector.isCustomized(InstalledExtensionDocumentCustomizationDetector.java:95)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentCustomizationDetector.lambda$isCustomized$0(InstalledExtensionDocumentCustomizationDetector.java:86)
	at java.base/java.util.stream.MatchOps$1MatchSink.accept(MatchOps.java:90)
	at java.base/java.util.ArrayList$ArrayListSpliterator.tryAdvance(ArrayList.java:1632)
	at java.base/java.util.stream.ReferencePipeline.forEachWithCancel(ReferencePipeline.java:127)
	at java.base/java.util.stream.AbstractPipeline.copyIntoWithCancel(AbstractPipeline.java:502)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:488)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
	at java.base/java.util.stream.MatchOps$MatchOp.evaluateSequential(MatchOps.java:230)
	at java.base/java.util.stream.MatchOps$MatchOp.evaluateSequential(MatchOps.java:196)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.allMatch(ReferencePipeline.java:533)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentCustomizationDetector.isCustomized(InstalledExtensionDocumentCustomizationDetector.java:86)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.updateCustomizedFlag(InstalledExtensionDocumentListener.java:132)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.addExtensionDocument(InstalledExtensionDocumentListener.java:153)
	at java.base/java.util.HashMap$KeySpliterator.forEachRemaining(HashMap.java:1620)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.forEachExtensionDocument(InstalledExtensionDocumentListener.java:166)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.addExtensionDocuments(InstalledExtensionDocumentListener.java:147)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.lambda$addExtensionDocuments$1(InstalledExtensionDocumentListener.java:140)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.addExtensionDocuments(InstalledExtensionDocumentListener.java:140)
	at org.xwiki.extension.xar.internal.doc.InstalledExtensionDocumentListener.onEvent(InstalledExtensionDocumentListener.java:115)
	at org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:320)
	at org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:285)
	at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117)
	at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:246)
	at org.xwiki.job.AbstractJob.run(AbstractJob.java:223)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:275)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
	at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:175)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
	at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:173)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:127)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:86)
	at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:479)
	at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:85)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:709)
	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.build(HibernateStore.java:331)
	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.initHibernate(HibernateStore.java:250)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernateSynchronized(XWikiHibernateBaseStore.java:481)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:474)
	at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1008)
	... 41 common frames omitted
Caused by: org.hibernate.HibernateException: Could not create a DBCP pool. There is an error in the Hibernate configuration file, please review it.
	at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:242)
	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:107)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:246)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:146)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:101)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
	... 58 common frames omitted
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (null,  message from server: "Host '192.168.3.81' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'")
	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:653)
	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:531)
	at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:731)
	at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:225)
	... 66 common frames omitted
Caused by: java.sql.SQLException: null,  message from server: "Host '192.168.3.81' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
	at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52)
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:374)
	at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:106)
	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:649)
	... 69 common frames omitted
2023-01-03 14:00:05,539 [XWiki initialization] ERROR c.x.x.i.XWikiInitializerJob    - Exception thrown during job execution 
java.lang.OutOfMemoryError: GC overhead limit exceeded
	at com.mysql.cj.protocol.ReadAheadInputStream.<init>(ReadAheadInputStream.java:241)
	at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:79)
	at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
	at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52)
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:374)
	at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:106)
	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:649)
	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:531)
	at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:731)
	at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:225)
	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:107)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:246)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:146)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:101)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
	at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:175)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
	at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:173)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:127)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:86)
03-Jan-2023 14:00:10.181 SEVERE [http-nio-8080-exec-3 - http://192.168.3.81:8080/xwiki/bin/view/Main/] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request
	java.lang.OutOfMemoryError: GC overhead limit exceeded
		at java.base/java.util.Arrays.copyOf(Arrays.java:3745)
		at java.base/java.lang.AbstractStringBuilder.ensureCapacityInternal(AbstractStringBuilder.java:172)
		at java.base/java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:538)
		at java.base/java.lang.StringBuffer.append(StringBuffer.java:317)
		at java.base/java.io.StringWriter.write(StringWriter.java:106)
		at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:625)
		at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
		at org.apache.velocity.runtime.directive.Foreach.renderBlock(Foreach.java:309)
		at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:279)
		at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)
		at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
		at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
		at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:331)
		at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:261)
		at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)
		at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
		at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:171)
		at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
		at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
		at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:331)
		at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:261)
		at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)
		at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
		at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:171)
		at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
		at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
		at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:331)
		at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:261)
		at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)
		at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
		at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:171)
		at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
03-Jan-2023 14:00:13.009 SEVERE [http-nio-8080-exec-4 - http://192.168.3.81:8080/xwiki/bin/view/Main/] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request
	java.lang.OutOfMemoryError: GC overhead limit exceeded
03-Jan-2023 14:00:23.037 SEVERE [http-nio-8080-exec-5 - http://192.168.3.81:8080/xwiki/bin/view/Main/] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request
	java.lang.OutOfMemoryError: Java heap space
03-Jan-2023 14:00:24.609 SEVERE [http-nio-8080-exec-6 - http://192.168.3.81:8080/xwiki/bin/view/Main/] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request
	java.lang.OutOfMemoryError: Java heap space
03-Jan-2023 14:00:35.717 SEVERE [http-nio-8080-exec-10 - http://192.168.3.81:8080/xwiki/bin/view/Main/] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request
	java.lang.OutOfMemoryError: Java heap space
03-Jan-2023 14:00:38.148 SEVERE [http-nio-8080-exec-1 - http://192.168.3.81:8080/xwiki/bin/view/Main/] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request
	java.lang.OutOfMemoryError: Java heap space
03-Jan-2023 14:00:41.612 SEVERE [http-nio-8080-exec-2 - http://192.168.3.81:8080/xwiki/bin/view/Main/] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request
	java.lang.OutOfMemoryError: Java heap space
03-Jan-2023 14:00:51.695 SEVERE [http-nio-8080-exec-3 - http://192.168.3.81:8080/xwiki/bin/view/Main/ - http://192.168.3.81:8080/xwiki/bin/view/Main/] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request
	java.lang.OutOfMemoryError: Java heap space
03-Jan-2023 14:01:04.751 SEVERE [http-nio-8080-exec-5 - http://192.168.3.81:8080/xwiki/bin/view/Main/ - http://192.168.3.81:8080/xwiki/bin/view/Main/] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request
	java.lang.OutOfMemoryError: Java heap space
03-Jan-2023 14:01:07.418 SEVERE [http-nio-8080-exec-4 - http://192.168.3.81:8080/xwiki/bin/view/Main/ - http://192.168.3.81:8080/xwiki/bin/view/Main/] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request
	java.lang.OutOfMemoryError: Java heap space
03-Jan-2023 14:01:08.564 SEVERE [http-nio-8080-exec-6 - http://192.168.3.81:8080/xwiki/bin/view/Main/ - http://192.168.3.81:8080/xwiki/bin/view/Main/] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request
	java.lang.OutOfMemoryError: Java heap space
03-Jan-2023 14:01:40.644 SEVERE [http-nio-8080-exec-7 - http://192.168.3.81:8080/xwiki/bin/view/Main/] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request
	java.lang.OutOfMemoryError: Java heap space
03-Jan-2023 14:02:33.540 SEVERE [http-nio-8080-exec-8 - http://192.168.3.81:8080/xwiki/bin/view/Main/] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request
	java.lang.OutOfMemoryError: Java heap space

My hibernate.cfg.xml configuration file is shown in the figure
微信截图_20230103141810

2

Hard to help with that since it looks like the consequence of something else.

Ideally, what you should share is the very first error you have in the log after the XWiki startup.

3

This is the first warning I found from catalina.out，thanks。

NOTE: Picked up JDK_JAVA_OPTIONS:  --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.util.concurrent=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
Java HotSpot(TM) 64-Bit Server VM warning: Ignoring option MaxPermSize; support was removed in 8.0
03-Jan-2023 13:25:44.827 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name:   Apache Tomcat/9.0.65
03-Jan-2023 13:25:44.829 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Jul 14 2022 12:28:53 UTC
03-Jan-2023 13:25:44.829 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.65.0
03-Jan-2023 13:25:44.829 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
03-Jan-2023 13:25:44.829 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            3.10.0-1160.36.2.el7.x86_64
03-Jan-2023 13:25:44.829 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
03-Jan-2023 13:25:44.829 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /usr/java/jdk-11.0.15.1
03-Jan-2023 13:25:44.829 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           11.0.15.1+2-LTS-10
03-Jan-2023 13:25:44.829 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
03-Jan-2023 13:25:44.830 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /usr/local/tomcat/apache-tomcat-9.0.65
03-Jan-2023 13:25:44.830 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /usr/local/tomcat/apache-tomcat-9.0.65
03-Jan-2023 13:25:44.837 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang=ALL-UNNAMED
03-Jan-2023 13:25:44.837 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.io=ALL-UNNAMED
03-Jan-2023 13:25:44.837 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util=ALL-UNNAMED
03-Jan-2023 13:25:44.837 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util.concurrent=ALL-UNNAMED
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/usr/local/tomcat/apache-tomcat-9.0.65/conf/logging.properties
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.awt.headless=true
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.security.egd=file:/dev/./urandom
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms512M
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024M
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:MaxPermSize=192m
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+UseParallelGC
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/usr/local/tomcat/apache-tomcat-9.0.65
03-Jan-2023 13:25:44.838 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/tomcat/apache-tomcat-9.0.65
03-Jan-2023 13:25:44.839 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/usr/local/tomcat/apache-tomcat-9.0.65/temp
03-Jan-2023 13:25:44.839 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [/usr/java/packages/lib:/usr/lib64:/lib64:/lib:/usr/lib]
03-Jan-2023 13:25:45.024 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
03-Jan-2023 13:25:45.039 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [333] milliseconds
03-Jan-2023 13:25:45.073 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
03-Jan-2023 13:25:45.073 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.65]
03-Jan-2023 13:25:45.089 INFO [main] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/usr/local/tomcat/apache-tomcat-9.0.65/webapps/xwiki.war]
2023-01-03 13:25:48,199 [main] INFO  iPropertiesConfigurationSource - Loading [xwiki.properties] from [file:/usr/local/tomcat/apache-tomcat-9.0.65/webapps/xwiki/WEB-INF/xwiki.properties] 
2023-01-03 13:25:48,336 [main] WARN  o.x.e.i.ServletEnvironment     - No permanent directory configured, fallbacking to temporary directory. You should set the "environment.permanentDirectory" configuration property in the xwiki.properties file. 
2023-01-03 13:25:48,336 [main] INFO  o.x.e.i.ServletEnvironment     - Using permanent directory [/usr/local/tomcat/apache-tomcat-9.0.65/work/Catalina/localhost/xwiki] 
2023-01-03 13:25:52,795 [main] INFO  o.x.s.s.i.EmbeddedSolr         - Updating Solr home directory at [/usr/local/tomcat/apache-tomcat-9.0.65/work/Catalina/localhost/xwiki/store/solr] 
2023-01-03 13:25:52,800 [main] INFO  o.x.s.s.i.EmbeddedSolr         - Starting embedded Solr server... 
2023-01-03 13:25:52,800 [main] INFO  o.x.s.s.i.EmbeddedSolr         - Using Solr home directory: [/usr/local/tomcat/apache-tomcat-9.0.65/work/Catalina/localhost/xwiki/store/solr] 
2023-01-03 13:25:53,462 [main] WARN  o.e.j.u.s.S.config             - Trusting all certificates configured for Client@7b4f1512[provider=null,keyStore=null,trustStore=null] 
2023-01-03 13:25:53,462 [main] WARN  o.e.j.u.s.S.config             - No Client EndPointIdentificationAlgorithm configured for Client@7b4f1512[provider=null,keyStore=null,trustStore=null] 
2023-01-03 13:25:53,626 [main] WARN  o.e.j.u.s.S.config             - Trusting all certificates configured for Client@631c244c[provider=null,keyStore=null,trustStore=null] 
2023-01-03 13:25:53,626 [main] WARN  o.e.j.u.s.S.config             - No Client EndPointIdentificationAlgorithm configured for Client@631c244c[provider=null,keyStore=null,trustStore=null] 
2023-01-03 13:25:53,684 [main] WARN  o.a.s.c.CoreContainer          - Not all security plugins configured!  authentication=disabled authorization=disabled.  Solr is only as secure as you make it. Consider configuring authentication/authorization before exposing Solr to users internal or external.  See https://s.apache.org/solrsecurity for more info 
2023-01-03 13:25:55,592 [main] INFO  o.x.s.s.i.EmbeddedSolr         - Started embedded Solr server. 
2023-01-03 13:25:56,821 [main] INFO  o.x.s.f.i.FilesystemStoreTools - Using filesystem store directory [/usr/local/tomcat/apache-tomcat-9.0.65/work/Catalina/localhost/xwiki/store/file] 
03-Jan-2023 13:25:56.917 INFO [main] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/usr/local/tomcat/apache-tomcat-9.0.65/webapps/xwiki.war] has finished in [11,828] ms
03-Jan-2023 13:25:56.918 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/usr/local/tomcat/apache-tomcat-9.0.65/webapps/ROOT]
03-Jan-2023 13:25:56.937 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/usr/local/tomcat/apache-tomcat-9.0.65/webapps/ROOT] has finished in [19] ms
03-Jan-2023 13:25:56.937 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/usr/local/tomcat/apache-tomcat-9.0.65/webapps/docs]
03-Jan-2023 13:25:56.947 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/usr/local/tomcat/apache-tomcat-9.0.65/webapps/docs] has finished in [10] ms
03-Jan-2023 13:25:56.948 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/usr/local/tomcat/apache-tomcat-9.0.65/webapps/examples]
03-Jan-2023 13:25:57.042 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/usr/local/tomcat/apache-tomcat-9.0.65/webapps/examples] has finished in [94] ms
03-Jan-2023 13:25:57.042 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/usr/local/tomcat/apache-tomcat-9.0.65/webapps/host-manager]
03-Jan-2023 13:25:57.054 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/usr/local/tomcat/apache-tomcat-9.0.65/webapps/host-manager] has finished in [12] ms
03-Jan-2023 13:25:57.054 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/usr/local/tomcat/apache-tomcat-9.0.65/webapps/manager]
03-Jan-2023 13:25:57.064 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/usr/local/tomcat/apache-tomcat-9.0.65/webapps/manager] has finished in [10] ms
03-Jan-2023 13:25:57.066 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
03-Jan-2023 13:25:57.074 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [12034] milliseconds
2023-01-03 13:26:03,989 [XWiki initialization] ERROR c.x.x.s.DBCPConnectionProvider - Could not create a DBCP pool. There is an error in the Hibernate configuration file, please review it. 
java.sql.SQLException: Cannot create PoolableConnectionFactory (null,  message from server: "Host '192.168.3.81' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'")
	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:653)
	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:531)
	at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:731)
	at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:225)
	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:107)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:246)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:146)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:101)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
	at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:175)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
	at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:173)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:127)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:86)
	at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:479)
	at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:85)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:709)
	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.build(HibernateStore.java:331)
	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.initHibernate(HibernateStore.java:250)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernateSynchronized(XWikiHibernateBaseStore.java:481)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:474)
	at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1008)
	at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:395)
	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2184)
	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2246)
	at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1459)
	at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1426)
	at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1335)
	at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1272)
	at com.xpn.xwiki.XWiki.<init>(XWiki.java:1245)
	at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:103)
	at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:246)
	at org.xwiki.job.AbstractJob.run(AbstractJob.java:223)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLException: null,  message from server: "Host '192.168.3.81' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
4

I was hoping to see examples of those “many connection errors” before that error but not luck, maybe it was in a previous run of XWiki ? Or maybe those errors did not have anything to do with XWiki.

In any case, looks like you need to do what the error is suggesting you to do to unlock your server.

5

After I execute mysqladmin -u root -p flush-hosts on the xwiki Mysql server and revisit xiwiki, this error will still be repeated
微信截图_20230103164822

6

Have you checked that the used password is correct? Has there been any recent change to your database server like an update? Which database server are you using? You seem to be using the MySQL connector, are you indeed using a MySQL database and not MariaDB?

7

Hello, I can log in to the mysql database normally through the command line using the mysql account password. The database server has not been updated recently. The only operation I have done is to change the time zone of the operating system. I am not sure if this is the reason. In addition, my MySQL database version is mysql:8.0.31

8

Not a solution, but I hit this almost each time I restart XWiki, see: MySQL Host is blocked because of many connection errors unblock with 'mysqladmin flush-hosts'

9

I tried using mysqladmin flush-hosts, but it didn’t work. Re-visit xwiki, still XWiki initialization 50% …, and the error log of Catalina.out is the same as before

10

Here is my relevant version,My mysql driver is mysql-connector-j-8.0.31.jar
xwiki：14.9
tomcat：9.0.65
mysql：8.0.31
Java:11.0.15.1

I can’t find where is his problem, please help me, thanks

11

For me I need to repeatedly flush and restart a couple of times, never understood what to do first.

12

So far, I don’t know why it goes wrong, my preliminary judgment is

  1. The jvm memory overflows, try to expand the memory, but the problem cannot be solved;
  2. The hibernate.cfg.xml configuration has not changed, but the log shows that the hibernate.cfg.xml configuration is incorrect
    But why it returned to normal in the end, I don’t know at the moment.
    So I don’t know if anyone can help us，thanks
13

My email: 404.xianjin@outlook.com, in the future, we will discuss more about technical issues, and grow and progress together

14

I think Mr Mortagne is right. To figure out what the problem is we need to focus on those connection errors.

What is the setup you use?

AFAICS you have your DB server running on IP 192.168.3.82:3306 and XWiki is running on 192.168.3.81:8080
Is this correct?

Host '192.168.3.81' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

This message appears to imply that XWiki, on initialization, is trying to connect to 192.168.3.81. If your database is served from 192.168.3.82 and the XWiki server with IP 192.168.3.81 has no database (and probably not port 3306 opened as well) then it’s not surprising you see these issues.

So the question now is: Why is XWiki connecting to the wrong IP address to look for a database on 192.168.3.81 when it’s correctly set up on 192.168.3.82 in hibernate.cfg.xml?

15

wow, you are right. My MySQL database runs at 192.168.3.82:3306, my xwiki runs at 192.168.3.81:8080/xwiki, and my tomcat 192.168.3.81:8080 is normal.
My xwiki is connected to 192.168.3.82, I need to execute flush hosts in the 192.168.3.81mysql database according to the error message

16

No, I don’t think the analysis by @Jan-Paul-Kleijn is correct. The message clearly says that the client 192.168.3.81 is blocked, this is not the IP of the database but the IP of the client.

17

Yes, the error message is that the client 192.168.3.81 is blocked from access by the MySQL database 192.168.3.82

environment:
Client: 192.168.3.81
MySQL database: 192.168.3.82:3306

The problem is, I need to execute flush hosts on the 82 machine, but when I finish executing, restart tomcat, re-initialize xwiki, still will still report an error. The error message is as above。

So far I don’t know exactly where the problem is, but now my system has been restored. As for how to get back to normal, I don’t know

18

Have you tried stop tomcat, flush hosts, start tomcat? In the other thread MySQL Host is blocked because of many connection errors unblock with 'mysqladmin flush-hosts' it is mentioned that it might be a shutdown issue, so I would suggest to make sure that the shutdown is before you flush hosts (I haven’t understood why that should be the case, I just want to make sure that this is not what’s causing your problems).

19

You could also try the steps described here to get more information about the connection errors.

21

I think this is a good way.
When the system reported an error, I created a new virtual environment. The client 10.19.100.88 tried to access 192.168.3.82:3306. The error message at that time was consistent with the above. At present, my official environment can initialize xwiki normally, and the newly created virtual environment can also initialize xwiki normally.
If this error still occurs later, I will try the method you mentioned. Maybe I didn’t close tomcat before flushing hosts. thank you