2022-03-29 09:56:46,956+0000 INFO [/opt/primekey/bin/start.sh] (process:1) uid=10001 gid=0(root) groups=0(root)
2022-03-29 09:56:47,162+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Detected 0.0 available core(s).
2022-03-29 09:56:47,177+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Detected 33672298496 bytes available host memory.
2022-03-29 09:56:47,221+0000 INFO [/opt/primekey/bin/start.sh] (process:1) MySQL/MariaDB database.
2022-03-29 09:56:48,716+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2022-03-29 09:56:48,738+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'SELECT 1' -> hit
2022-03-29 09:56:48,740+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2022-03-29 09:56:50,085+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2022-03-29 09:56:50,100+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'SELECT rowVersion FROM GlobalConfigurationData WHERE configurationId='UPGRADE'' -> hit
2022-03-29 09:56:50,103+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2022-03-29 09:56:50,135+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 -Xmx31776m -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-03-29 09:56:52,544+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-03-29 09:56:55,134+0000 WARN [org.jboss.as.server.deployment.scanner] (ServerService Thread Pool -- 19) 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-03-29 09:56:55,320+0000 INFO [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0039: Creating http management service using socket-binding (management-http)
2022-03-29 09:56:55,941+0000 INFO [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0003: Undertow 2.2.4.Final starting
2022-03-29 09:56:56,228+0000 INFO [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0012: Started server default-server.
2022-03-29 09:56:56,259+0000 INFO [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0018: Host default-host starting
2022-03-29 09:56:56,289+0000 INFO [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0006: Undertow HTTP listener remoting listening on 127.0.0.1:4447
2022-03-29 09:56:56,481+0000 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-2) WFLYDS0013: Started FileSystemDeploymentService for directory /opt/primekey/wildfly-22.0.1.Final/standalone/deployments
2022-03-29 09:56:58,118+0000 INFO [org.infinispan.CONTAINER] (ServerService Thread Pool -- 46) ISPN000128: Infinispan version: Infinispan 'Corona Extra' 11.0.8.Final
2022-03-29 09:56:58,241+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-03-29 09:56:58,244+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-03-29 09:56:58,402+0000 INFO [org.infinispan.PERSISTENCE] (ServerService Thread Pool -- 46) ISPN000556: Starting user marshaller 'org.wildfly.clustering.infinispan.spi.marshalling.InfinispanProtoStreamMarshaller'
2022-03-29 09:57:02,983+0000 INFO [org.jboss.as.jpa] (MSC service thread 1-1) WFLYJPA0002: Read persistence.xml for ejbca
2022-03-29 09:57:05,305+0000 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 46) WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'ejbca.ear#ejbca'
2022-03-29 09:57:06,324+0000 ERROR [org.jboss.as.jsf] (MSC service thread 1-2) WFLYJSF0002: Could not load JSF managed bean class: org.ejbca.ui.web.admin.peerconnector.PeerConnectorsMBean
2022-03-29 09:57:06,326+0000 ERROR [org.jboss.as.jsf] (MSC service thread 1-2) WFLYJSF0002: Could not load JSF managed bean class: org.ejbca.ui.web.admin.peerconnector.PeerConnectorMBean
2022-03-29 09:57:08,885+0000 WARN [org.jboss.as.ee] (MSC service thread 1-2) 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-03-29 09:57:08,930+0000 WARN [org.jboss.as.ee] (MSC service thread 1-2) 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-03-29 09:57:08,948+0000 WARN [org.jboss.as.ee] (MSC service thread 1-2) 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-03-29 09:57:08,971+0000 WARN [org.jboss.as.ee] (MSC service thread 1-2) 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-03-29 09:57:08,975+0000 WARN [org.jboss.as.ee] (MSC service thread 1-2) 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-03-29 09:57:10,558+0000 WARN [org.jboss.as.ejb3] (MSC service thread 1-2) WFLYEJB0131: EJB org.ejbca.core.ejb.ca.auth.EndEntityAuthenticationSessionBean should not have a final or static method (decRemainingLoginAttempts)
2022-03-29 09:57:12,131+0000 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 46) WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'ejbca.ear#ejbca'
2022-03-29 09:57:12,423+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 (possible typo error)
2022-03-29 09:57:16,565+0000 WARN [org.jboss.weld.Bootstrap] (MSC service thread 1-1) WELD-000146: BeforeBeanDiscovery.addAnnotatedType(AnnotatedType>) used for class com.sun.faces.flow.FlowDiscoveryCDIHelper is deprecated from CDI 1.1!
2022-03-29 09:57:18,771+0000 SEVERE [javax.enterprise.resource.webcontainer.jsf.flow] (MSC service thread 1-1) Unable to obtain CDI 1.1 utilities for Mojarra
2022-03-29 09:57:18,778+0000 SEVERE [javax.enterprise.resource.webcontainer.jsf.application.view] (MSC service thread 1-1) Unable to obtain CDI 1.1 utilities for Mojarra
2022-03-29 09:57:21,283+0000 INFO [org.ejbca.core.ejb.StartupSingletonBean] (ServerService Thread Pool -- 71) Init, EJBCA 7.4.3.2 Community (67479006a69140e81d66e39871bed8255362effc) startup.
2022-03-29 09:57:21,302+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 46) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-03-29 09:57:21,302+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 48) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-03-29 09:57:21,302+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 50) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-03-29 09:57:21,306+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 52) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, GET]
2022-03-29 09:57:21,302+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 59) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-03-29 09:57:21,302+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 51) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-03-29 09:57:21,306+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 63) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, GET]
2022-03-29 09:57:21,302+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 66) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-03-29 09:57:21,302+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 58) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-03-29 09:57:21,706+0000 INFO [org.ejbca.core.ejb.StartupSingletonBean] (ServerService Thread Pool -- 71) BouncyCastle provider is from our ejbca.ear classloader.
2022-03-29 09:57:21,712+0000 INFO [org.ejbca.core.ejb.StartupSingletonBean] (ServerService Thread Pool -- 71) Registered AuthenticationTokens [OAuth2AuthenticationToken, PublicAccessAuthenticationToken, CertificateAuthenticationToken, CliAuthenticationToken, AlwaysAllowLocalAuthenticationToken]
2022-03-29 09:57:21,714+0000 INFO [org.cesecore.keys.token.CryptoTokenFactory] (ServerService Thread Pool -- 71) Class not found: se.primeKey.caToken.card.PrimeCAToken.
2022-03-29 09:57:21,714+0000 INFO [org.cesecore.keys.token.CryptoTokenFactory] (ServerService Thread Pool -- 71) Can not register se.primeKey.caToken.card.PrimeCAToken. This is normally not an error.
2022-03-29 09:57:21,738+0000 INFO [org.cesecore.keys.token.CryptoTokenFactory] (ServerService Thread Pool -- 71) Class not found: org.ejbca.keys.token.AWSKMSCryptoToken.
2022-03-29 09:57:21,738+0000 INFO [org.cesecore.keys.token.CryptoTokenFactory] (ServerService Thread Pool -- 71) Can not register org.ejbca.keys.token.AWSKMSCryptoToken. This is normally not an error.
2022-03-29 09:57:21,739+0000 INFO [org.cesecore.keys.token.CryptoTokenFactory] (ServerService Thread Pool -- 71) Class not found: org.cesecore.keys.token.p11ng.cryptotoken.Pkcs11NgCryptoToken.
2022-03-29 09:57:21,739+0000 INFO [org.cesecore.keys.token.CryptoTokenFactory] (ServerService Thread Pool -- 71) Can not register org.cesecore.keys.token.p11ng.cryptotoken.Pkcs11NgCryptoToken. This is normally not an error.
2022-03-29 09:57:21,769+0000 INFO [org.cesecore.dbprotection.ProtectedData] (ServerService Thread Pool -- 71) No database integrity protection available in this version of EJBCA.
2022-03-29 09:57:21,911+0000 INFO [org.ejbca.core.ejb.ca.caadmin.CAAdminSessionBean] (ServerService Thread Pool -- 71) Initialized CA: ManagementCA with expire time: 2032-03-28 09:24:26+00:00
2022-03-29 09:57:21,928+0000 INFO [org.cesecore.audit.AuditDevicesConfig] (ServerService Thread Pool -- 71) Registered audit device using implementation: org.cesecore.audit.impl.log4j.Log4jDevice
2022-03-29 09:57:21,929+0000 INFO [org.cesecore.audit.AuditDevicesConfig] (ServerService Thread Pool -- 71) Configured exporter AuditExporterDummy for device Log4jDevice
2022-03-29 09:57:21,935+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (ServerService Thread Pool -- 71) 2022-03-29 09:57:21+00:00;EJBCA_STARTING;SUCCESS;SERVICE;EJBCA;Application internal;;onap-ejbca-97c5ff9ff-hrsct;;msg=Init, EJBCA 7.4.3.2 Community (67479006a69140e81d66e39871bed8255362effc) startup.
2022-03-29 09:57:21,939+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (ServerService Thread Pool -- 71) 2022-03-29 09:57:21+00:00;LOG_MANAGEMENT_CHANGE;VOID;SECURITY_AUDIT;CORE;Application internal;;;;msg=No integrity protected security audit logger devices configured.
2022-03-29 09:57:21,952+0000 INFO [org.ejbca.core.ejb.authorization.AuthorizationSystemSessionBean] (ServerService Thread Pool -- 71) Roles or CAs exist, not intializing Super Administrator Role
2022-03-29 09:57:23,123+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (ServerService Thread Pool -- 71) Setting isUniqueCertificateSerialNumberIndex to: true
2022-03-29 09:57:23,177+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (ServerService Thread Pool -- 71) 2022-03-29 09:57:23+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;Internal upgrade;;;;resource0=/system_functionality/edit_systemconfiguration
2022-03-29 09:57:23,184+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (ServerService Thread Pool -- 71) 2022-03-29 09:57:23+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;Internal upgrade;;;;msg=Saved global configuration with id UPGRADE.
2022-03-29 09:57:23,232+0000 INFO [org.ejbca.core.ejb.upgrade.UpgradeSessionBean] (ServerService Thread Pool -- 71) Database content version: 7.4.3.2, current application version: 7.4.3.2 -> Upgrade is not needed.
2022-03-29 09:57:23,757+0000 INFO [org.cesecore.keys.token.SoftCryptoToken] (ServerService Thread Pool -- 71) Activated Crypto Token with ID 1970472659.
2022-03-29 09:57:23,800+0000 INFO [org.cesecore.certificates.ocsp.cache.OcspSigningCache] (ServerService Thread Pool -- 71) No default responder was defined. OCSP requests for certificates issued by unknown CAs will return "unauthorized" as per RFC6960, Section 2.3
2022-03-29 09:57:23,807+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (ServerService Thread Pool -- 71) Reloading CA certificate cache.
2022-03-29 09:57:23,846+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (ServerService Thread Pool -- 71) Reloaded CA certificate cache with 1 certificates
2022-03-29 09:57:23,866+0000 INFO [org.ejbca.core.ejb.ocsp.OcspResponseCleanupSessionBean] (ServerService Thread Pool -- 71) OCSP clean up job is disabled.
2022-03-29 09:57:24,097+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 61) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-03-29 09:57:25,853+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 64) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-03-29 09:57:25,916+0000 INFO [org.jboss.as.server] (ServerService Thread Pool -- 27) WFLYSRV0010: Deployed "ejbca.ear" (runtime-name : "ejbca.ear")
2022-03-29 09:57:25,916+0000 INFO [org.jboss.as.server] (ServerService Thread Pool -- 27) WFLYSRV0010: Deployed "jdbc-driver.jar" (runtime-name : "jdbc-driver.jar")
2022-03-29 09:57:25,971+0000 INFO [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0212: Resuming server
2022-03-29 09:57:25,978+0000 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0025: WildFly Full 22.0.1.Final (WildFly Core 14.0.1.Final) started in 35047ms - Started 5790 of 5915 services (283 services are lazy, passive or on-demand)
2022-03-29 09:57:25,984+0000 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http management interface listening on http://127.0.0.1:9990/management
2022-03-29 09:57:25,985+0000 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0054: Admin console is not enabled
2022-03-29 09:57:27,259+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Application /opt/primekey/appserver/standalone/deployments/ejbca.ear.deployed successfully started.
2022-03-29 09:57:27,266+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Setting up in-bound connectivity...
2022-03-29 09:57:31,785+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:57:31+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 09:57:35,897+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:57:35+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 09:57:40,004+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:57:40+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 09:57:42,466+0000 WARN [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (ConnectionValidator) IJ030027: Destroying connection that is not valid, due to the following exception: org.mariadb.jdbc.MariaDbConnection@46751d9: java.sql.SQLException: (conn=1267) 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.execute(MariaDbStatement.java:484)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:74)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1285)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getInvalidConnections(BaseWrapperManagedConnectionFactory.java:1098)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.validateConnections(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1444)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.validator.ConnectionValidator$ConnectionValidatorRunner.run(ConnectionValidator.java:285)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
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)
... 9 more
2022-03-29 09:57:42,482+0000 WARN [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (ConnectionValidator) IJ030027: Destroying connection that is not valid, due to the following exception: org.mariadb.jdbc.MariaDbConnection@160a2e64: java.sql.SQLException: (conn=1268) 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.execute(MariaDbStatement.java:484)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:74)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1285)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getInvalidConnections(BaseWrapperManagedConnectionFactory.java:1098)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.validateConnections(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1444)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.validator.ConnectionValidator$ConnectionValidatorRunner.run(ConnectionValidator.java:285)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
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)
... 9 more
2022-03-29 09:57:42,489+0000 WARN [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (ConnectionValidator) IJ030027: Destroying connection that is not valid, due to the following exception: org.mariadb.jdbc.MariaDbConnection@7fe9f59b: java.sql.SQLException: (conn=1269) 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.execute(MariaDbStatement.java:484)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:74)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1285)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getInvalidConnections(BaseWrapperManagedConnectionFactory.java:1098)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.validateConnections(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1444)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.validator.ConnectionValidator$ConnectionValidatorRunner.run(ConnectionValidator.java:285)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
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)
... 9 more
2022-03-29 09:57:44,153+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 09:57:44+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 09:57:44,303+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 09:57:44+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 09:57:48,384+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:57:48+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 09:57:48,516+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Using certificate profile: SERVER, with id: 9
2022-03-29 09:57:48,526+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Trying to add end entity:
2022-03-29 09:57:48,526+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Username: onap-ejbca-97c5ff9ff-hrsct
2022-03-29 09:57:48,527+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Password:
2022-03-29 09:57:48,527+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) DN: CN=onap-ejbca-97c5ff9ff-hrsct,O=EJBCA Container Quickstart,UID=c-0mydclzdxvajp14wm
2022-03-29 09:57:48,527+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) CA Name: ManagementCA
2022-03-29 09:57:48,527+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) SubjectAltName: dnsName=onap-ejbca-97c5ff9ff-hrsct
2022-03-29 09:57:48,527+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Email: null
2022-03-29 09:57:48,527+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Type: 1
2022-03-29 09:57:48,527+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Token: JKS
2022-03-29 09:57:48,528+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Certificate profile: 9
2022-03-29 09:57:48,528+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) End entity profile: 1
2022-03-29 09:57:48,565+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:57:48+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/endentityprofilesrules/1/create_end_entity;resource1=/ra_functionality/create_end_entity
2022-03-29 09:57:48,613+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:57:48+00:00;RA_ADDENDENTITY;SUCCESS;RA;CORE;ejbca;430485574;;onap-ejbca-97c5ff9ff-hrsct;msg=Added end entity onap-ejbca-97c5ff9ff-hrsct.;caid=430485574;cardnumber=;certificateprofileid=9;endentityprofileid=1;status=10;subjectAltName=B64:ZG5zTmFtZT1vbmFwLWVqYmNhLTk3YzVmZjlmZi1ocnNjdA==;subjectDN=B64:VUlEPWMtMG15ZGNsemR4dmFqcDE0d20sQ049b25hcC1lamJjYS05N2M1ZmY5ZmYtaHJzY3QsTz1FSkJDQSBDb250YWluZXIgUXVpY2tzdGFydA==;subjectEmail=;tokentype=3;type=1;username=onap-ejbca-97c5ff9ff-hrsct
2022-03-29 09:57:48,638+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) User 'onap-ejbca-97c5ff9ff-hrsct' has been added.
2022-03-29 09:57:48,638+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Note: If batch processing should be possible, also use 'ra setclearpwd onap-ejbca-97c5ff9ff-hrsct '.
2022-03-29 09:57:52,351+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:57:52+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/endentityprofilesrules/1/edit_end_entity;resource1=/ra_functionality/edit_end_entity
2022-03-29 09:57:52,352+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:57:52+00:00;RA_EDITENDENTITY;SUCCESS;RA;CORE;ejbca;430485574;;onap-ejbca-97c5ff9ff-hrsct;msg=Edited end entity onap-ejbca-97c5ff9ff-hrsct, new status 10.
2022-03-29 09:57:52,361+0000 INFO [org.ejbca.ui.cli.ra.SetEndEntityStatusCommand] (main) New status for end entity onap-ejbca-97c5ff9ff-hrsct is 10
2022-03-29 09:57:56,034+0000 INFO [org.ejbca.ui.cli.ra.SetCleartextPasswordCommand] (main) Setting clear text password for user onap-ejbca-97c5ff9ff-hrsct
2022-03-29 09:57:56,070+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:57:56+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/endentityprofilesrules/1/edit_end_entity;resource1=/ra_functionality/edit_end_entity
2022-03-29 09:57:56,074+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:57:56+00:00;RA_EDITENDENTITY;SUCCESS;RA;CORE;ejbca;430485574;;onap-ejbca-97c5ff9ff-hrsct;msg=Password changed for end entity onap-ejbca-97c5ff9ff-hrsct.
2022-03-29 09:57:59,858+0000 INFO [org.ejbca.ui.cli.batch.BatchMakeP12Command] (main) Generating keys in directory /opt/primekey/tmp/tmp.uR8weefK08.
2022-03-29 09:57:59,925+0000 INFO [org.ejbca.ui.cli.batch.BatchMakeP12Command] (main) Loading configuration from defaults.
2022-03-29 09:57:59,925+0000 INFO [org.ejbca.ui.cli.batch.BatchMakeP12Command] (main) Generating RSA keys of size 2048 for onap-ejbca-97c5ff9ff-hrsct.
2022-03-29 09:58:00,673+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:58:00+00:00;CA_USERAUTH;SUCCESS;CA;EJBCA;ejbca;430485574;;onap-ejbca-97c5ff9ff-hrsct;msg=Authenticated user onap-ejbca-97c5ff9ff-hrsct.
2022-03-29 09:58:00,697+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:58:00+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca_functionality/create_certificate;resource1=/ca/430485574
2022-03-29 09:58:00,698+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:58:00+00:00;CERT_REQUEST;SUCCESS;CERTIFICATE;CORE;ejbca;430485574;;onap-ejbca-97c5ff9ff-hrsct;subjectdn=UID=c-0mydclzdxvajp14wm,CN=onap-ejbca-97c5ff9ff-hrsct,O=EJBCA Container Quickstart;requestX500name=null;subjectaltname=dnsName=onap-ejbca-97c5ff9ff-hrsct;certprofile=9;keyusage=-1;notbefore=;notafter=;sequence=;publickey=MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAo17yWb6fFtAxMzIWNqLy1pzrEOqD4EdoQ/ad9y68+F5tUgR8fxJuwW0s9v3kH8O+fH/pBGEzJNbxANFKak/SSykCcpfOszkaxAYZ/7HPVvHVV3vAHkozh9e2mgFRUUHGUo7C3cWtcRxsEE1qVk1XQtuOmuhbploTvMRscmeK8aA+hQxLeLc3gq7aVWaCrogTmGafL19sPyNaMQDl8j/0jo+5jOC0mJPBkvf9N4AFCxiyl2isma9G5TpruxhrNkdBdlu9V63l1VH2kJDy/52y1haPAyapDD13H1QGWX1L4Ph1GXZKraZzJbsksN/Ylma6a9uyg53fRqx7eBvlyHCvCwIDAQAB
2022-03-29 09:58:00,744+0000 INFO [org.cesecore.certificates.ca.internal.SernoGeneratorRandom] (default task-1) Using SHA1PRNG serialNumber RNG algorithm.
2022-03-29 09:58:00,825+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:58:00+00:00;CERT_STORED;SUCCESS;CERTIFICATE;CORE;ejbca;430485574;1B83B2D9DB7FCEEBF085C56E81A334997F58E275;onap-ejbca-97c5ff9ff-hrsct;msg=Certificate stored for username 'onap-ejbca-97c5ff9ff-hrsct', fp=1d87f3ce8f20f895472be61a14a2b401da79c0f5, subjectDN 'UID=c-0mydclzdxvajp14wm,CN=onap-ejbca-97c5ff9ff-hrsct,O=EJBCA Container Quickstart', issuerDN 'UID=12345,CN=ManagementCA,O=EJBCA Container Quickstart', serialNo=1B83B2D9DB7FCEEBF085C56E81A334997F58E275.
2022-03-29 09:58:00,827+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:58:00+00:00;CERT_CREATION;SUCCESS;CERTIFICATE;CORE;ejbca;430485574;1B83B2D9DB7FCEEBF085C56E81A334997F58E275;onap-ejbca-97c5ff9ff-hrsct;subjectdn=UID=c-0mydclzdxvajp14wm,CN=onap-ejbca-97c5ff9ff-hrsct,O=EJBCA Container Quickstart;certprofile=9;issuancerevocationreason=-1;cert=MIIEbjCCAtagAwIBAgIUG4Oy2dt/zuvwhcVugaM0mX9Y4nUwDQYJKoZIhvcNAQELBQAwUzEVMBMGCgmSJomT8ixkAQEMBTEyMzQ1MRUwEwYDVQQDDAxNYW5hZ2VtZW50Q0ExIzAhBgNVBAoMGkVKQkNBIENvbnRhaW5lciBRdWlja3N0YXJ0MB4XDTIyMDMyOTA5NDgwMFoXDTI0MDMyODA5NDc1OVowbzEjMCEGCgmSJomT8ixkAQEME2MtMG15ZGNsemR4dmFqcDE0d20xIzAhBgNVBAMMGm9uYXAtZWpiY2EtOTdjNWZmOWZmLWhyc2N0MSMwIQYDVQQKDBpFSkJDQSBDb250YWluZXIgUXVpY2tzdGFydDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAKNe8lm+nxbQMTMyFjai8tac6xDqg+BHaEP2nfcuvPhebVIEfH8SbsFtLPb95B/Dvnx/6QRhMyTW8QDRSmpP0kspAnKXzrM5GsQGGf+xz1bx1Vd7wB5KM4fXtpoBUVFBxlKOwt3FrXEcbBBNalZNV0LbjproW6ZaE7zEbHJnivGgPoUMS3i3N4Ku2lVmgq6IE5hmny9fbD8jWjEA5fI/9I6PuYzgtJiTwZL3/TeABQsYspdorJmvRuU6a7sYazZHQXZbvVet5dVR9pCQ8v+dstYWjwMmqQw9dx9UBll9S+D4dRl2Sq2mcyW7JLDf2JZmumvbsoOd30ase3gb5chwrwsCAwEAAaOBnTCBmjAMBgNVHRMBAf8EAjAAMB8GA1UdIwQYMBaAFBGomwraqQ7JNE+G0CztEwurp2iJMCUGA1UdEQQeMByCGm9uYXAtZWpiY2EtOTdjNWZmOWZmLWhyc2N0MBMGA1UdJQQMMAoGCCsGAQUFBwMBMB0GA1UdDgQWBBTPXCl4YH/xzkMKhGSK0rkQM/pXFjAOBgNVHQ8BAf8EBAMCBaAwDQYJKoZIhvcNAQELBQADggGBABttYq93v71wEWdVdQnZx6tueDrYovx7FO1olqudprbArbgdofi1H6GRmqnQAs2Uum6Y3pSXyk6+ykmh5X6rnz5a63F1MF5UiH2nUX0L1fJF0W8YTf6NcwO97igBdbTilyj6OijlBk93Z0VBt9ApbLWRl4ba4RWtDdVH/v9N/cGbliPziQIgdzxJFXyuDKhRTPNSuVHz1PCYN04/kcbCvIA7UZxRqc2toDTz8tM6PVBvv9nzAX3CMlYSWBexEfwx/VQeqWMGo5clyb/oltG+fbEK8tJlVvaD8TqpySyGn8758v1b+G3oUyhwRHP7DBxXjbK1AQ5Kg9psH2Wank5O88tNrpGV2OIgfC0L9UXeDxhq1CDa5NDF1b5rnwUacM74tQ4iBE684bhJURN6m+NuGJVFtWKHYCdczhKunACKslc+nZ4tTBRxGGndf9ve8o7kT2Eg2riid/x8fFZVhzzY6AcqjeIf3Z5+Hot4qqPp+JVCu+UubDYxM48pTcl383F5Bg==
2022-03-29 09:58:00,829+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:58:00+00:00;RA_EDITENDENTITY;SUCCESS;RA;CORE;Local admin call from EndEntityManagementSession.decRequestCounter;430485574;;onap-ejbca-97c5ff9ff-hrsct;msg=Edited end entity onap-ejbca-97c5ff9ff-hrsct, new status 40.
2022-03-29 09:58:00,830+0000 INFO [org.ejbca.core.ejb.ca.auth.EndEntityAuthenticationSessionBean] (default task-1) Changed status for 'onap-ejbca-97c5ff9ff-hrsct' to STATUS_GENERATED.
2022-03-29 09:58:00,923+0000 INFO [org.ejbca.ui.cli.batch.BatchMakeP12Command] (main) Created Keystore for 'onap-ejbca-97c5ff9ff-hrsct'.
2022-03-29 09:58:00,980+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:58:00+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/endentityprofilesrules/1/edit_end_entity;resource1=/ra_functionality/edit_end_entity
2022-03-29 09:58:00,980+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:58:00+00:00;RA_EDITENDENTITY;SUCCESS;RA;CORE;ejbca;430485574;;onap-ejbca-97c5ff9ff-hrsct;msg=Password changed for end entity onap-ejbca-97c5ff9ff-hrsct.
2022-03-29 09:58:00,989+0000 INFO [org.ejbca.ui.cli.batch.BatchMakeP12Command] (main) New user generated successfully - onap-ejbca-97c5ff9ff-hrsct.
2022-03-29 09:58:01,344+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Certificate stored in file
2022-03-29 09:58:01,763+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Generated TLS certificate with fingerprint 877c5d4f375ad49d4bbfad74f129591bf5ed0c6381b841c92d2d94466a4d8cd4.
2022-03-29 09:58:01,771+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Importing keystore /opt/primekey/secrets/persistent/tls/onap-ejbca-97c5ff9ff-hrsct/server.jks to /opt/primekey/tmp/tmp.uR8weefK08/keystore.jks...
2022-03-29 09:58:01,771+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Entry for alias cacert successfully imported.
2022-03-29 09:58:01,771+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Entry for alias onap-ejbca-97c5ff9ff-hrsct successfully imported.
2022-03-29 09:58:01,771+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Import command completed: 2 entries successfully imported, 0 entries failed or cancelled
2022-03-29 09:58:19,285+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Will use application provided server side TLS keystore.
2022-03-29 09:58:23,382+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:58:23+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 09:58:27,508+0000 WARN [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (ConnectionValidator) IJ030027: Destroying connection that is not valid, due to the following exception: org.mariadb.jdbc.MariaDbConnection@3ce3a070: java.sql.SQLException: (conn=1287) 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.execute(MariaDbStatement.java:484)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:74)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1285)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getInvalidConnections(BaseWrapperManagedConnectionFactory.java:1098)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.validateConnections(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1444)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.validator.ConnectionValidator$ConnectionValidatorRunner.run(ConnectionValidator.java:285)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
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)
... 9 more
2022-03-29 09:58:27,863+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:58:27+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 09:58:28,128+0000 INFO [org.ejbca.ui.cli.ca.GetCaCertCommand] (main) Wrote CA certificate to '/opt/primekey/tmp/tmp.uR8weefK08/cacert.der' using DER encoding.
2022-03-29 09:58:37,351+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Certificate was added to keystore
2022-03-29 09:58:41,496+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Enabling HTTPS listener on 0.0.0.0:8443 with optional client certificate authentication.
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.wildfly.extension.elytron.SSLDefinitions (jar:file:/opt/primekey/wildfly-22.0.1.Final/modules/system/layers/base/org/wildfly/extension/elytron/main/wildfly-elytron-integration-14.0.1.Final.jar!/) to method com.sun.net.ssl.internal.ssl.Provider.isFIPS()
WARNING: Please consider reporting this to the maintainers of org.wildfly.extension.elytron.SSLDefinitions
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
2022-03-29 09:58:47,783+0000 INFO [org.ejbca.ui.web.pub.HealthCheckServlet] (default task-1) All IPs are authorized.
2022-03-29 09:58:50,646+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Enabling HTTP listener on 0.0.0.0:8080.
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1)
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) ###################################################################################################
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # Whenever you are ready for production: #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # Try out the commercially supported EJBCA Enterprise Cloud on AWS, fully featured with: #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # - Additional enrollment APIs such as a REST API, EST, ACME and more. #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # - Support for external Registration Authority and OCSP responders #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # - Hardware Security Module support #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # - Application updates #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # - ...and more! #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # Feel free to contact us directly for a cloud, on-prem, embedded or hybrid solution that fits #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # your specific needs. #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # https://aws.amazon.com/marketplace/seller-profile?id=7edf9048-58e6-4086-9d98-b8e0c1d78fce #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # https://www.primekey.com #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # sales@primekey.com #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # #
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1) ###################################################################################################
2022-03-29 09:59:03,706+0000 INFO [/opt/primekey/bin/start.sh] (process:1)
2022-03-29 09:59:03,726+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting 5 seconds before signaling application readiness to ensure proper handling of PublicAccessAuthenticationToken.
2022-03-29 09:59:08,739+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Health check now reports application status at /ejbca/publicweb/healthcheck/ejbcahealth
2022-03-29 09:59:13,303+0000 INFO [org.cesecore.keys.util.SignWithWorkingAlgorithm] (default task-1) Signature algorithm 'SHA1WithRSA' working for provider 'BC version 1.68'.
2022-03-29 09:59:17,378+0000 INFO [org.apache.commons.configuration.PropertiesConfiguration] (default task-1) Reloading configuration. URL is file:/etc/ejbca/conf/web.properties
2022-03-29 09:59:17,523+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:59:17+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 09:59:26,426+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:59:26+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-03-29 09:59:26,432+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:59:26+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-03-29 09:59:31,093+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:59:31+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 09:59:31,476+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:59:31+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca_functionality/edit_ca;resource1=/ca/430485574
2022-03-29 09:59:34,036+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:59:34+00:00;CA_EDITING;SUCCESS;CA;CORE;ejbca;430485574;;;msg=CA with id 430485574 and name ManagementCA edited., 1;tokenproperties={certSignKey=signKey, crlSignKey=signKey, defaultKey=encryptKey};tokensequence=00000
2022-03-29 09:59:34,204+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:59:34+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 09:59:34,269+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 09:59:34+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 09:59:38,676+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 09:59:38+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-03-29 09:59:38,681+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 09:59:38+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-03-29 09:59:42,979+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 09:59:42+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-03-29 09:59:42,984+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 09:59:42+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-03-29 09:59:47,299+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 09:59:47+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-03-29 09:59:47,304+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 09:59:47+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-03-29 09:59:51,642+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 09:59:51+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-03-29 09:59:51,646+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 09:59:51+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-03-29 10:00:00,215+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:00+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-03-29 10:00:00,219+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:00+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-03-29 10:00:04,205+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:04+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-03-29 10:00:04,211+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:04+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-03-29 10:00:08,458+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:08+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 10:00:13,021+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:13+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-03-29 10:00:13,027+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:13+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-03-29 10:00:25,182+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:25+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-03-29 10:00:25,187+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:25+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-03-29 10:00:29,063+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:29+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-03-29 10:00:29,067+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:29+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-03-29 10:00:33,094+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:33+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 10:00:37,119+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:37+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/endentityprofilesrules/1/edit_end_entity;resource1=/ra_functionality/edit_end_entity
2022-03-29 10:00:37,121+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:37+00:00;RA_EDITENDENTITY;SUCCESS;RA;CORE;ejbca;430485574;;Node123;msg=Password changed for end entity Node123.
2022-03-29 10:00:41,123+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:41+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-03-29 10:00:41,127+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:41+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-03-29 10:00:48,741+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-03-29 10:00:48+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 10:01:11,909+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-03-29 10:01:11+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-03-29 10:01:57,651+0000 WARN [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (ConnectionValidator) IJ030027: Destroying connection that is not valid, due to the following exception: org.mariadb.jdbc.MariaDbConnection@4b3209ae: java.sql.SQLException: (conn=1400) 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.execute(MariaDbStatement.java:484)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:74)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1285)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getInvalidConnections(BaseWrapperManagedConnectionFactory.java:1098)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.validateConnections(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1444)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.validator.ConnectionValidator$ConnectionValidatorRunner.run(ConnectionValidator.java:285)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
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)
... 9 more
2022-03-29 10:02:23,851+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 1) Reloading CA certificate cache.
2022-03-29 10:02:23,863+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 1) Reloaded CA certificate cache with 1 certificates
2022-03-29 10:07:23,865+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 1) Reloading CA certificate cache.
2022-03-29 10:07:23,873+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 1) Reloaded CA certificate cache with 1 certificates
2022-03-29 10:07:57,839+0000 WARN [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (ConnectionValidator) IJ030027: Destroying connection that is not valid, due to the following exception: org.mariadb.jdbc.MariaDbConnection@340dbc6a: java.sql.SQLException: (conn=1557) 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.execute(MariaDbStatement.java:484)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:74)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1285)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getInvalidConnections(BaseWrapperManagedConnectionFactory.java:1098)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.validateConnections(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1444)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.validator.ConnectionValidator$ConnectionValidatorRunner.run(ConnectionValidator.java:285)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
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)
... 9 more
2022-03-29 10:12:23,878+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 2) Reloading CA certificate cache.
2022-03-29 10:12:23,888+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 2) Reloaded CA certificate cache with 1 certificates
2022-03-29 10:16:58,141+0000 WARN [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (ConnectionValidator) IJ030027: Destroying connection that is not valid, due to the following exception: org.mariadb.jdbc.MariaDbConnection@62022281: java.sql.SQLException: (conn=1792) 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.execute(MariaDbStatement.java:484)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:74)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1285)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getInvalidConnections(BaseWrapperManagedConnectionFactory.java:1098)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.validateConnections(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1444)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.validator.ConnectionValidator$ConnectionValidatorRunner.run(ConnectionValidator.java:285)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
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)
... 9 more
2022-03-29 10:17:23,890+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 1) Reloading CA certificate cache.
2022-03-29 10:17:23,903+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 1) Reloaded CA certificate cache with 1 certificates