2022-02-16 09:49:27,956+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) uid=10001 gid=0(root) groups=0(root)
2022-02-16 09:49:28,561+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) Detected 1.500 available core(s).
2022-02-16 09:49:28,575+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) Detected 1610612736 bytes available memory assigned to this container.
2022-02-16 09:49:28,635+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) MySQL/MariaDB database.
2022-02-16 09:49:30,441+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2022-02-16 09:49:31,417+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'SELECT 1' -> hit
2022-02-16 09:49:31,419+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2022-02-16 09:49:32,887+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2022-02-16 09:49:32,913+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) (conn=1585) WSREP has not yet prepared node for application use
2022-02-16 09:49:32,913+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2022-02-16 09:49:32,933+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) Creating database tables...
2022-02-16 09:49:34,266+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Loading SQL script '/opt/primekey/ejbca/doc/sql-scripts/create-tables-ejbca-mysql.sql' with 460 lines.
2022-02-16 09:49:34,469+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2022-02-16 09:49:34,517+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) (conn=1587) WSREP has not yet prepared node for application use
2022-02-16 09:49:34,518+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2022-02-16 09:49:34,537+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) Applying recommended database indexes...
2022-02-16 09:49:35,852+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Loading SQL script '/opt/primekey/ejbca/doc/sql-scripts/create-index-ejbca.sql' with 92 lines.
2022-02-16 09:49:36,445+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2022-02-16 09:49:36,458+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) (conn=1498) Duplicate key name 'auditrecorddata_idx2'
2022-02-16 09:49:36,460+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2022-02-16 09:49:36,485+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) Starting application server:
=========================================================================

  JBoss Bootstrap Environment

  JBOSS_HOME: /opt/primekey/wildfly-22.0.1.Final

  JAVA: java

  JAVA_OPTS:  -server   -Xms128m -Xmx1200m -Xss256k -XX:MetaspaceSize=160m -XX:MaxMetaspaceSize=256m -XX:+UseParallelGC -XX:GCTimeRatio=4 -XX:AdaptiveSizePolicyWeight=90 -XX:MinHeapFreeRatio=10 -XX:MaxHeapFreeRatio=20 -XX:+ExitOnOutOfMemoryError -Djdk.tls.ephemeralDHKeySize=2048 -Djava.net.preferIPv4Stack=true -Djava.security.egd=file:/dev/random -Dcontainer.database.name=mysql -Dcontainer.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect -Dhibernate.dialect.storage_engine=innodb -Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true  --add-exports=java.base/sun.nio.ch=ALL-UNNAMED --add-exports=jdk.unsupported/sun.misc=ALL-UNNAMED --add-exports=jdk.unsupported/sun.reflect=ALL-UNNAMED

=========================================================================

2022-02-16 09:49:38,832+0000 INFO  [org.jboss.as] (MSC service thread 1-1) WFLYSRV0049: WildFly Full 22.0.1.Final (WildFly Core 14.0.1.Final) starting
2022-02-16 09:49:42,031+0000 WARN  [org.jboss.as.server.deployment.scanner] (ServerService Thread Pool -- 16) WFLYDS0006: Reliable deployment behaviour is not possible when auto-deployment of exploded content is enabled (i.e. deployment without use of ".dodeploy"' marker files). Configuration of auto-deployment of exploded content is not recommended in any situation where reliability is desired. Configuring the deployment scanner's auto-deploy-exploded setting to "false" is recommended.
2022-02-16 09:49:42,245+0000 INFO  [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0039: Creating http management service using socket-binding (management-http)
2022-02-16 09:49:42,829+0000 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0003: Undertow 2.2.4.Final starting
2022-02-16 09:49:43,522+0000 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0012: Started server default-server.
2022-02-16 09:49:43,610+0000 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-3) WFLYUT0018: Host default-host starting
2022-02-16 09:49:43,913+0000 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0006: Undertow HTTP listener remoting listening on 127.0.0.1:4447
2022-02-16 09:49:46,935+0000 INFO  [org.infinispan.CONTAINER] (ServerService Thread Pool -- 46) ISPN000128: Infinispan version: Infinispan 'Corona Extra' 11.0.8.Final
2022-02-16 09:49:47,045+0000 INFO  [org.infinispan.CONFIG] (MSC service thread 1-4) ISPN000152: Passivation configured without an eviction policy being selected. Only manually evicted entities will be passivated.
2022-02-16 09:49:47,047+0000 INFO  [org.infinispan.CONFIG] (MSC service thread 1-4) ISPN000152: Passivation configured without an eviction policy being selected. Only manually evicted entities will be passivated.
2022-02-16 09:49:47,328+0000 INFO  [org.infinispan.PERSISTENCE] (ServerService Thread Pool -- 46) ISPN000556: Starting user marshaller 'org.wildfly.clustering.infinispan.spi.marshalling.InfinispanProtoStreamMarshaller'
2022-02-16 09:49:51,753+0000 INFO  [org.jboss.as.jpa] (MSC service thread 1-3) WFLYJPA0002: Read persistence.xml for ejbca
2022-02-16 09:49:55,624+0000 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 46) WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'ejbca.ear#ejbca'
2022-02-16 09:49:58,531+0000 ERROR [org.jboss.as.jsf] (MSC service thread 1-3) WFLYJSF0002: Could not load JSF managed bean class: org.ejbca.ui.web.admin.peerconnector.PeerConnectorsMBean
2022-02-16 09:49:58,533+0000 ERROR [org.jboss.as.jsf] (MSC service thread 1-3) WFLYJSF0002: Could not load JSF managed bean class: org.ejbca.ui.web.admin.peerconnector.PeerConnectorMBean
2022-02-16 09:50:00,643+0000 WARN  [org.jboss.as.ee] (MSC service thread 1-1) WFLYEE0007: Not installing optional component view-handler.org.apache.myfaces.tomahawk.application.ResourceViewHandlerWrapper due to an exception (enable DEBUG log level to see the cause)
2022-02-16 09:50:00,720+0000 WARN  [org.jboss.as.ee] (MSC service thread 1-1) WFLYEE0007: Not installing optional component exception-handler-factory.org.ejbca.ra.jsfext.RaExceptionHandlerFactory due to an exception (enable DEBUG log level to see the cause)
2022-02-16 09:50:00,733+0000 WARN  [org.jboss.as.ee] (MSC service thread 1-1) WFLYEE0007: Not installing optional component resource-handler.org.apache.myfaces.custom.captcha.CAPTCHAResourceHandlerWrapper due to an exception (enable DEBUG log level to see the cause)
2022-02-16 09:50:00,916+0000 WARN  [org.jboss.as.ee] (MSC service thread 1-1) WFLYEE0007: Not installing optional component resource-handler.org.apache.myfaces.tomahawk.resource.UncompressedResourceHandlerWrapper due to an exception (enable DEBUG log level to see the cause)
2022-02-16 09:50:00,919+0000 WARN  [org.jboss.as.ee] (MSC service thread 1-1) WFLYEE0007: Not installing optional component faces-context-factory.org.apache.myfaces.webapp.filter.TomahawkFacesContextFactory due to an exception (enable DEBUG log level to see the cause)
2022-02-16 09:50:02,627+0000 WARN  [org.jboss.as.ejb3] (MSC service thread 1-4) WFLYEJB0131: EJB org.ejbca.core.ejb.ca.auth.EndEntityAuthenticationSessionBean should not have a final or static method (decRemainingLoginAttempts)
2022-02-16 09:50:03,815+0000 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 46) WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'ejbca.ear#ejbca'
2022-02-16 09:50:04,322+0000 WARN  [org.hibernate.cfg.annotations.reflection.JPAOverriddenAnnotationReader] (ServerService Thread Pool -- 46) HHH000207: Property org.ejbca.core.ejb.approval.ApprovalData.subjectdn not found in class but described in <mapping-file/> (possible typo error)
2022-02-16 09:50:08,149+0000 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 46) SQL Error: 1205, SQLState: HY000
2022-02-16 09:50:08,149+0000 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 46) (conn=1535) Lock wait timeout exceeded; try restarting transaction
2022-02-16 09:50:08,154+0000 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 46) MSC000001: Failed to start service jboss.persistenceunit."ejbca.ear#ejbca": org.jboss.msc.service.StartException in service jboss.persistenceunit."ejbca.ear#ejbca": javax.persistence.PersistenceException: [PersistenceUnit: ejbca] Unable to build Hibernate SessionFactory
	at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:198)
	at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:128)
	at java.base/java.security.AccessController.doPrivileged(Native Method)
	at org.wildfly.security.elytron-private@1.14.1.Final//org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:664)
	at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:213)
	at org.jboss.threads@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
	at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
	at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
	at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
	at java.base/java.lang.Thread.run(Unknown Source)
	at org.jboss.threads@2.4.0.Final//org.jboss.threads.JBossThread.run(JBossThread.java:513)
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: ejbca] Unable to build Hibernate SessionFactory
	at org.hibernate@5.3.20.Final//org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:1327)
	at org.hibernate@5.3.20.Final//org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1253)
	at org.hibernate.jipijapa-hibernate5-3@22.0.1.Final//org.jboss.as.jpa.hibernate5.TwoPhaseBootstrapImpl.build(TwoPhaseBootstrapImpl.java:44)
	at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:170)
	... 10 more
Caused by: org.hibernate.PessimisticLockException: Error accessing table metadata
	at org.hibernate@5.3.20.Final//org.hibernate.dialect.MySQLDialect$3.convert(MySQLDialect.java:532)
	at org.hibernate@5.3.20.Final//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
	at org.hibernate@5.3.20.Final//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
	at org.hibernate@5.3.20.Final//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
	at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.convertSQLException(InformationExtractorJdbcDatabaseMetaDataImpl.java:98)
	at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getTables(InformationExtractorJdbcDatabaseMetaDataImpl.java:341)
	at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.getTablesInformation(DatabaseInformationImpl.java:120)
	at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:65)
	at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207)
	at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
	at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
	at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
	at org.hibernate@5.3.20.Final//org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
	at org.hibernate@5.3.20.Final//org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
	at org.hibernate@5.3.20.Final//org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1250)
	... 12 more
Caused by: java.sql.SQLException: (conn=1535) Lock wait timeout exceeded; try restarting transaction
	at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:262)
	at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:164)
	at deployment.jdbc-driver.jar//org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:258)
	at deployment.jdbc-driver.jar//org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:349)
	at deployment.jdbc-driver.jar//org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:595)
	at deployment.jdbc-driver.jar//org.mariadb.jdbc.MariaDbDatabaseMetaData.executeQuery(MariaDbDatabaseMetaData.java:508)
	at deployment.jdbc-driver.jar//org.mariadb.jdbc.MariaDbDatabaseMetaData.getTables(MariaDbDatabaseMetaData.java:693)
	at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getTables(InformationExtractorJdbcDatabaseMetaDataImpl.java:329)
	... 21 more
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
	at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1598)
	at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1460)
	at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1423)
	at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:178)
	at deployment.jdbc-driver.jar//org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:343)
	... 25 more

2022-02-16 09:50:08,218+0000 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "ejbca.ear")]) - failure description: {"WFLYCTL0080: Failed services" => {"jboss.persistenceunit.\"ejbca.ear#ejbca\"" => "javax.persistence.PersistenceException: [PersistenceUnit: ejbca] Unable to build Hibernate SessionFactory
    Caused by: javax.persistence.PersistenceException: [PersistenceUnit: ejbca] Unable to build Hibernate SessionFactory
    Caused by: org.hibernate.PessimisticLockException: Error accessing table metadata
    Caused by: java.sql.SQLException: (conn=1535) Lock wait timeout exceeded; try restarting transaction
    Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction"}}
2022-02-16 09:50:08,228+0000 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 27) WFLYSRV0010: Deployed "ejbca.ear" (runtime-name : "ejbca.ear")
2022-02-16 09:50:08,228+0000 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 27) WFLYSRV0010: Deployed "jdbc-driver.jar" (runtime-name : "jdbc-driver.jar")
2022-02-16 09:50:08,235+0000 INFO  [org.jboss.as.controller] (Controller Boot Thread) WFLYCTL0183: Service status report
WFLYCTL0186:   Services which failed to start:      service jboss.persistenceunit."ejbca.ear#ejbca": javax.persistence.PersistenceException: [PersistenceUnit: ejbca] Unable to build Hibernate SessionFactory
WFLYCTL0448: 904 additional services are down due to their dependencies being missing or failed
2022-02-16 09:50:08,326+0000 INFO  [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0212: Resuming server
2022-02-16 09:50:08,331+0000 ERROR [org.jboss.as] (Controller Boot Thread) WFLYSRV0026: WildFly Full 22.0.1.Final (WildFly Core 14.0.1.Final) started (with errors) in 31266ms - Started 4846 of 5915 services (932 services failed or missing dependencies, 283 services are lazy, passive or on-demand)
2022-02-16 09:50:08,335+0000 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http management interface listening on http://127.0.0.1:9990/management
2022-02-16 09:50:08,335+0000 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0054: Admin console is not enabled
2022-02-16 09:50:13,714+0000 INFO  [org.jboss.as.server] (management-handler-thread - 1) WFLYSRV0211: Suspending server with 3000 ms timeout.
2022-02-16 09:50:13,718+0000 INFO  [org.jboss.as.server] (Management Triggered Shutdown) WFLYSRV0241: Shutting down in response to management operation 'shutdown'
2022-02-16 09:50:09,558+0000 WARN  [/opt/primekey/bin/start.sh] (process:1) {
2022-02-16 09:50:09,558+0000 WARN  [/opt/primekey/bin/start.sh] (process:1) "result" => undefined
2022-02-16 09:50:09,558+0000 WARN  [/opt/primekey/bin/start.sh] (process:1) }
kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec ... or kill -l [sigspec]
2022-02-16 09:50:13,913+0000 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 22) WFLYJPA0011: Stopping Persistence Unit (phase 1 of 2) Service 'ejbca.ear#ejbca'
2022-02-16 09:50:14,217+0000 INFO  [org.infinispan.manager.DefaultCacheManager] (ServerService Thread Pool -- 22) Stopping cache manager null on null
2022-02-16 09:50:14,436+0000 INFO  [org.jboss.as] (MSC service thread 1-2) WFLYSRV0050: WildFly Full 22.0.1.Final (WildFly Core 14.0.1.Final) stopped in 618ms
2022-02-16 09:50:14,786+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) Stopped application server.