2022-04-20 10:41:51,437+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) uid=10001 gid=0(root) groups=0(root)
2022-04-20 10:41:51,645+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) Detected 1.500 available core(s).
2022-04-20 10:41:51,658+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) Detected 1610612736 bytes available memory assigned to this container.
2022-04-20 10:41:51,691+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) MySQL/MariaDB database.
2022-04-20 10:41:53,247+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2022-04-20 10:41:53,261+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) (conn=1765) Lock wait timeout exceeded; try restarting transaction
2022-04-20 10:41:53,286+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2022-04-20 10:41:53,296+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) Waiting for external database 'jdbc:mariadb://mariadb-galera:3306/ejbca' to become available.
2022-04-20 10:41:57,796+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2022-04-20 10:41:57,803+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'SELECT 1' -> hit
2022-04-20 10:41:57,804+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2022-04-20 10:41:59,392+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2022-04-20 10:41:59,400+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) (conn=1780) WSREP has not yet prepared node for application use
2022-04-20 10:41:59,401+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2022-04-20 10:41:59,420+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) Creating database tables...
2022-04-20 10:42:00,799+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-04-20 10:42:01,792+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2022-04-20 10:42:01,811+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) (conn=1738) Table 'accessrulesdata' already exists
2022-04-20 10:42:01,813+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2022-04-20 10:42:01,833+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) Applying recommended database indexes...
2022-04-20 10:42:03,192+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-04-20 10:42:03,792+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2022-04-20 10:42:03,818+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) (conn=1739) Duplicate key name 'auditrecorddata_idx2'
2022-04-20 10:42:03,819+0000 INFO  [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2022-04-20 10:42:03,845+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-04-20 10:42:06,101+0000 INFO  [org.jboss.as] (MSC service thread 1-2) WFLYSRV0049: WildFly Full 22.0.1.Final (WildFly Core 14.0.1.Final) starting
2022-04-20 10:42:09,497+0000 WARN  [org.jboss.as.server.deployment.scanner] (ServerService Thread Pool -- 21) 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-04-20 10:42:09,687+0000 INFO  [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0039: Creating http management service using socket-binding (management-http)
2022-04-20 10:42:10,307+0000 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0003: Undertow 2.2.4.Final starting
2022-04-20 10:42:11,008+0000 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-4) WFLYUT0012: Started server default-server.
2022-04-20 10:42:11,095+0000 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-4) WFLYUT0018: Host default-host starting
2022-04-20 10:42:11,301+0000 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-4) WFLYUT0006: Undertow HTTP listener remoting listening on 127.0.0.1:4447
2022-04-20 10:42:14,499+0000 INFO  [org.infinispan.CONTAINER] (ServerService Thread Pool -- 46) ISPN000128: Infinispan version: Infinispan 'Corona Extra' 11.0.8.Final
2022-04-20 10:42:14,608+0000 INFO  [org.infinispan.CONFIG] (MSC service thread 1-2) ISPN000152: Passivation configured without an eviction policy being selected. Only manually evicted entities will be passivated.
2022-04-20 10:42:14,610+0000 INFO  [org.infinispan.CONFIG] (MSC service thread 1-2) ISPN000152: Passivation configured without an eviction policy being selected. Only manually evicted entities will be passivated.
2022-04-20 10:42:14,824+0000 INFO  [org.infinispan.PERSISTENCE] (ServerService Thread Pool -- 46) ISPN000556: Starting user marshaller 'org.wildfly.clustering.infinispan.spi.marshalling.InfinispanProtoStreamMarshaller'
2022-04-20 10:42:18,987+0000 INFO  [org.jboss.as.jpa] (MSC service thread 1-4) WFLYJPA0002: Read persistence.xml for ejbca
2022-04-20 10:42:22,402+0000 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 46) WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'ejbca.ear#ejbca'
2022-04-20 10:42:24,925+0000 ERROR [org.jboss.as.jsf] (MSC service thread 1-4) WFLYJSF0002: Could not load JSF managed bean class: org.ejbca.ui.web.admin.peerconnector.PeerConnectorsMBean
2022-04-20 10:42:24,926+0000 ERROR [org.jboss.as.jsf] (MSC service thread 1-4) WFLYJSF0002: Could not load JSF managed bean class: org.ejbca.ui.web.admin.peerconnector.PeerConnectorMBean
2022-04-20 10:42:27,432+0000 WARN  [org.jboss.as.ee] (MSC service thread 1-4) 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-04-20 10:42:27,493+0000 WARN  [org.jboss.as.ee] (MSC service thread 1-4) 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-04-20 10:42:27,503+0000 WARN  [org.jboss.as.ee] (MSC service thread 1-4) 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-04-20 10:42:27,588+0000 WARN  [org.jboss.as.ee] (MSC service thread 1-4) 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-04-20 10:42:27,590+0000 WARN  [org.jboss.as.ee] (MSC service thread 1-4) 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-04-20 10:42:30,507+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-04-20 10:42:31,115+0000 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 46) WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'ejbca.ear#ejbca'
2022-04-20 10:42:31,897+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-04-20 10:42:35,635+0000 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 46) SQL Error: 1205, SQLState: HY000
2022-04-20 10:42:35,635+0000 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 46) (conn=1793) Lock wait timeout exceeded; try restarting transaction
2022-04-20 10:42:35,638+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=1793) 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-04-20 10:42:35,688+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=1793) Lock wait timeout exceeded; try restarting transaction
    Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction"}}
2022-04-20 10:42:35,698+0000 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 27) WFLYSRV0010: Deployed "ejbca.ear" (runtime-name : "ejbca.ear")
2022-04-20 10:42:35,699+0000 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 27) WFLYSRV0010: Deployed "jdbc-driver.jar" (runtime-name : "jdbc-driver.jar")
2022-04-20 10:42:35,704+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-04-20 10:42:35,805+0000 INFO  [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0212: Resuming server
2022-04-20 10:42:35,811+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 31406ms - Started 4846 of 5915 services (932 services failed or missing dependencies, 283 services are lazy, passive or on-demand)
2022-04-20 10:42:35,814+0000 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http management interface listening on http://127.0.0.1:9990/management
2022-04-20 10:42:35,815+0000 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0054: Admin console is not enabled
2022-04-20 10:42:41,115+0000 INFO  [org.jboss.as.server] (management-handler-thread - 1) WFLYSRV0211: Suspending server with 3000 ms timeout.
2022-04-20 10:42:41,119+0000 INFO  [org.jboss.as.server] (Management Triggered Shutdown) WFLYSRV0241: Shutting down in response to management operation 'shutdown'
2022-04-20 10:42:37,005+0000 WARN  [/opt/primekey/bin/start.sh] (process:1) {
2022-04-20 10:42:37,005+0000 WARN  [/opt/primekey/bin/start.sh] (process:1) "result" => undefined
2022-04-20 10:42:37,005+0000 WARN  [/opt/primekey/bin/start.sh] (process:1) }
kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec ... or kill -l [sigspec]
2022-04-20 10:42:41,308+0000 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 19) WFLYJPA0011: Stopping Persistence Unit (phase 1 of 2) Service 'ejbca.ear#ejbca'
2022-04-20 10:42:41,706+0000 INFO  [org.infinispan.manager.DefaultCacheManager] (ServerService Thread Pool -- 19) Stopping cache manager null on null
2022-04-20 10:42:41,934+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 733ms
2022-04-20 10:42:42,279+0000 INFO  [/opt/primekey/bin/start.sh] (process:1) Stopped application server.