2022-02-08 10:26:12,569+0000 INFO [/opt/primekey/bin/start.sh] (process:1) uid=10001 gid=0(root) groups=0(root)
2022-02-08 10:26:12,914+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Detected 0.0 available core(s).
2022-02-08 10:26:12,932+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Detected 33676955648 bytes available host memory.
2022-02-08 10:26:12,977+0000 INFO [/opt/primekey/bin/start.sh] (process:1) MySQL/MariaDB database.
2022-02-08 10:26:14,430+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2022-02-08 10:26:14,442+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'SELECT 1' -> hit
2022-02-08 10:26:14,444+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2022-02-08 10:26:15,826+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2022-02-08 10:26:15,842+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'SELECT rowVersion FROM GlobalConfigurationData WHERE configurationId='UPGRADE'' -> hit
2022-02-08 10:26:15,844+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2022-02-08 10:26:15,884+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 -Xmx31780m -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-08 10:26:18,110+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-08 10:26:20,414+0000 WARN [org.jboss.as.server.deployment.scanner] (ServerService Thread Pool -- 4) 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-08 10:26:20,556+0000 INFO [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0039: Creating http management service using socket-binding (management-http)
2022-02-08 10:26:20,967+0000 INFO [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0003: Undertow 2.2.4.Final starting
2022-02-08 10:26:21,320+0000 INFO [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0012: Started server default-server.
2022-02-08 10:26:21,449+0000 INFO [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0018: Host default-host starting
2022-02-08 10:26:23,142+0000 INFO [org.infinispan.CONTAINER] (ServerService Thread Pool -- 46) ISPN000128: Infinispan version: Infinispan 'Corona Extra' 11.0.8.Final
2022-02-08 10:26:23,262+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-02-08 10:26:23,274+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-02-08 10:26:23,442+0000 INFO [org.infinispan.PERSISTENCE] (ServerService Thread Pool -- 46) ISPN000556: Starting user marshaller 'org.wildfly.clustering.infinispan.spi.marshalling.InfinispanProtoStreamMarshaller'
2022-02-08 10:26:27,610+0000 INFO [org.jboss.as.jpa] (MSC service thread 1-2) WFLYJPA0002: Read persistence.xml for ejbca
2022-02-08 10:26:29,446+0000 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 46) WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'ejbca.ear#ejbca'
2022-02-08 10:26:29,954+0000 ERROR [org.jboss.as.jsf] (MSC service thread 1-1) WFLYJSF0002: Could not load JSF managed bean class: org.ejbca.ui.web.admin.peerconnector.PeerConnectorsMBean
2022-02-08 10:26:29,955+0000 ERROR [org.jboss.as.jsf] (MSC service thread 1-1) WFLYJSF0002: Could not load JSF managed bean class: org.ejbca.ui.web.admin.peerconnector.PeerConnectorMBean
2022-02-08 10:26:32,402+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-08 10:26:32,420+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-08 10:26:32,460+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-08 10:26:32,493+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-08 10:26:32,495+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-08 10:26:33,041+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-02-08 10:26:36,052+0000 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 46) WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'ejbca.ear#ejbca'
2022-02-08 10:26:36,303+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-02-08 10:26:39,017+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-02-08 10:26:41,490+0000 SEVERE [javax.enterprise.resource.webcontainer.jsf.flow] (MSC service thread 1-1) Unable to obtain CDI 1.1 utilities for Mojarra
2022-02-08 10:26:41,495+0000 SEVERE [javax.enterprise.resource.webcontainer.jsf.application.view] (MSC service thread 1-1) Unable to obtain CDI 1.1 utilities for Mojarra
2022-02-08 10:26:42,629+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 54) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-02-08 10:26:42,632+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 53) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-02-08 10:26:42,633+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-02-08 10:26:42,632+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 55) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-02-08 10:26:42,633+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 48) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, GET]
2022-02-08 10:26:42,633+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-02-08 10:26:42,633+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 52) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-02-08 10:26:42,632+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 50) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, GET]
2022-02-08 10:26:42,629+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 62) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-02-08 10:26:42,663+0000 INFO [org.ejbca.core.ejb.StartupSingletonBean] (ServerService Thread Pool -- 66) Init, EJBCA 7.4.3.2 Community (67479006a69140e81d66e39871bed8255362effc) startup.
2022-02-08 10:26:43,114+0000 INFO [org.ejbca.core.ejb.StartupSingletonBean] (ServerService Thread Pool -- 66) BouncyCastle provider is from our ejbca.ear classloader.
2022-02-08 10:26:43,119+0000 INFO [org.ejbca.core.ejb.StartupSingletonBean] (ServerService Thread Pool -- 66) Registered AuthenticationTokens [OAuth2AuthenticationToken, PublicAccessAuthenticationToken, CertificateAuthenticationToken, CliAuthenticationToken, AlwaysAllowLocalAuthenticationToken]
2022-02-08 10:26:43,122+0000 INFO [org.cesecore.keys.token.CryptoTokenFactory] (ServerService Thread Pool -- 66) Class not found: se.primeKey.caToken.card.PrimeCAToken.
2022-02-08 10:26:43,122+0000 INFO [org.cesecore.keys.token.CryptoTokenFactory] (ServerService Thread Pool -- 66) Can not register se.primeKey.caToken.card.PrimeCAToken. This is normally not an error.
2022-02-08 10:26:43,144+0000 INFO [org.cesecore.keys.token.CryptoTokenFactory] (ServerService Thread Pool -- 66) Class not found: org.ejbca.keys.token.AWSKMSCryptoToken.
2022-02-08 10:26:43,144+0000 INFO [org.cesecore.keys.token.CryptoTokenFactory] (ServerService Thread Pool -- 66) Can not register org.ejbca.keys.token.AWSKMSCryptoToken. This is normally not an error.
2022-02-08 10:26:43,146+0000 INFO [org.cesecore.keys.token.CryptoTokenFactory] (ServerService Thread Pool -- 66) Class not found: org.cesecore.keys.token.p11ng.cryptotoken.Pkcs11NgCryptoToken.
2022-02-08 10:26:43,146+0000 INFO [org.cesecore.keys.token.CryptoTokenFactory] (ServerService Thread Pool -- 66) Can not register org.cesecore.keys.token.p11ng.cryptotoken.Pkcs11NgCryptoToken. This is normally not an error.
2022-02-08 10:26:43,176+0000 INFO [org.cesecore.dbprotection.ProtectedData] (ServerService Thread Pool -- 66) No database integrity protection available in this version of EJBCA.
2022-02-08 10:26:43,325+0000 INFO [org.ejbca.core.ejb.ca.caadmin.CAAdminSessionBean] (ServerService Thread Pool -- 66) Initialized CA: ManagementCA with expire time: 2032-02-08 09:18:42+00:00
2022-02-08 10:26:43,343+0000 INFO [org.cesecore.audit.AuditDevicesConfig] (ServerService Thread Pool -- 66) Registered audit device using implementation: org.cesecore.audit.impl.log4j.Log4jDevice
2022-02-08 10:26:43,343+0000 INFO [org.cesecore.audit.AuditDevicesConfig] (ServerService Thread Pool -- 66) Configured exporter AuditExporterDummy for device Log4jDevice
2022-02-08 10:26:43,349+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (ServerService Thread Pool -- 66) 2022-02-08 10:26:43+00:00;EJBCA_STARTING;SUCCESS;SERVICE;EJBCA;Application internal;;onap-ejbca-6885f79bdf-fvtkd;;msg=Init, EJBCA 7.4.3.2 Community (67479006a69140e81d66e39871bed8255362effc) startup.
2022-02-08 10:26:43,352+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (ServerService Thread Pool -- 66) 2022-02-08 10:26:43+00:00;LOG_MANAGEMENT_CHANGE;VOID;SECURITY_AUDIT;CORE;Application internal;;;;msg=No integrity protected security audit logger devices configured.
2022-02-08 10:26:43,362+0000 INFO [org.ejbca.core.ejb.authorization.AuthorizationSystemSessionBean] (ServerService Thread Pool -- 66) Roles or CAs exist, not intializing Super Administrator Role
2022-02-08 10:26:44,305+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (ServerService Thread Pool -- 66) Setting isUniqueCertificateSerialNumberIndex to: true
2022-02-08 10:26:44,348+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (ServerService Thread Pool -- 66) 2022-02-08 10:26:44+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;Internal upgrade;;;;resource0=/system_functionality/edit_systemconfiguration
2022-02-08 10:26:44,353+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (ServerService Thread Pool -- 66) 2022-02-08 10:26:44+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;Internal upgrade;;;;msg=Saved global configuration with id UPGRADE.
2022-02-08 10:26:44,406+0000 INFO [org.ejbca.core.ejb.upgrade.UpgradeSessionBean] (ServerService Thread Pool -- 66) Database content version: 7.4.3.2, current application version: 7.4.3.2 -> Upgrade is not needed.
2022-02-08 10:26:45,062+0000 INFO [org.cesecore.keys.token.SoftCryptoToken] (ServerService Thread Pool -- 66) Activated Crypto Token with ID 576586655.
2022-02-08 10:26:45,099+0000 INFO [org.cesecore.certificates.ocsp.cache.OcspSigningCache] (ServerService Thread Pool -- 66) No default responder was defined. OCSP requests for certificates issued by unknown CAs will return "unauthorized" as per RFC6960, Section 2.3
2022-02-08 10:26:45,101+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (ServerService Thread Pool -- 66) Reloading CA certificate cache.
2022-02-08 10:26:45,127+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (ServerService Thread Pool -- 66) Reloaded CA certificate cache with 1 certificates
2022-02-08 10:26:45,141+0000 INFO [org.ejbca.core.ejb.ocsp.OcspResponseCleanupSessionBean] (ServerService Thread Pool -- 66) OCSP clean up job is disabled.
2022-02-08 10:26:45,244+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 56) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-02-08 10:26:46,748+0000 WARN [io.undertow.servlet] (ServerService Thread Pool -- 63) UT015020: Path /* is secured for some HTTP methods, however it is not secured for [HEAD, POST, GET]
2022-02-08 10:26:46,822+0000 INFO [org.jboss.as.server] (ServerService Thread Pool -- 27) WFLYSRV0010: Deployed "ejbca.ear" (runtime-name : "ejbca.ear")
2022-02-08 10:26:46,823+0000 INFO [org.jboss.as.server] (ServerService Thread Pool -- 27) WFLYSRV0010: Deployed "jdbc-driver.jar" (runtime-name : "jdbc-driver.jar")
2022-02-08 10:26:46,880+0000 INFO [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0212: Resuming server
2022-02-08 10:26:46,886+0000 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0025: WildFly Full 22.0.1.Final (WildFly Core 14.0.1.Final) started in 30211ms - Started 5790 of 5915 services (283 services are lazy, passive or on-demand)
2022-02-08 10:26:46,889+0000 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http management interface listening on http://127.0.0.1:9990/management
2022-02-08 10:26:46,889+0000 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0054: Admin console is not enabled
2022-02-08 10:26:47,000+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Application /opt/primekey/appserver/standalone/deployments/ejbca.ear.deployed successfully started.
2022-02-08 10:26:47,007+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Setting up in-bound connectivity...
2022-02-08 10:26:50,545+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:26:50+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:26:54,320+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:26:54+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:26:58,048+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:26:58+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:27:01,668+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:01+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:27:01,756+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:01+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:27:05,408+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:05+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:27:05,547+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Using certificate profile: SERVER, with id: 9
2022-02-08 10:27:05,555+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Trying to add end entity:
2022-02-08 10:27:05,556+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Username: onap-ejbca-6885f79bdf-fvtkd
2022-02-08 10:27:05,556+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Password:
2022-02-08 10:27:05,556+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) DN: CN=onap-ejbca-6885f79bdf-fvtkd,O=EJBCA Container Quickstart,UID=c-0twwlqhlkjz7ka9wi
2022-02-08 10:27:05,556+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) CA Name: ManagementCA
2022-02-08 10:27:05,557+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) SubjectAltName: dnsName=onap-ejbca-6885f79bdf-fvtkd
2022-02-08 10:27:05,557+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Email: null
2022-02-08 10:27:05,557+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Type: 1
2022-02-08 10:27:05,558+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Token: JKS
2022-02-08 10:27:05,558+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Certificate profile: 9
2022-02-08 10:27:05,558+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) End entity profile: 1
2022-02-08 10:27:05,603+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:05+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/endentityprofilesrules/1/create_end_entity;resource1=/ra_functionality/create_end_entity
2022-02-08 10:27:05,658+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:05+00:00;RA_ADDENDENTITY;SUCCESS;RA;CORE;ejbca;430485574;;onap-ejbca-6885f79bdf-fvtkd;msg=Added end entity onap-ejbca-6885f79bdf-fvtkd.;caid=430485574;cardnumber=;certificateprofileid=9;endentityprofileid=1;status=10;subjectAltName=B64:ZG5zTmFtZT1vbmFwLWVqYmNhLTY4ODVmNzliZGYtZnZ0a2Q=;subjectDN=B64:VUlEPWMtMHR3d2xxaGxrano3a2E5d2ksQ049b25hcC1lamJjYS02ODg1Zjc5YmRmLWZ2dGtkLE89RUpCQ0EgQ29udGFpbmVyIFF1aWNrc3RhcnQ=;subjectEmail=;tokentype=3;type=1;username=onap-ejbca-6885f79bdf-fvtkd
2022-02-08 10:27:05,679+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) User 'onap-ejbca-6885f79bdf-fvtkd' has been added.
2022-02-08 10:27:05,680+0000 INFO [org.ejbca.ui.cli.ra.AddEndEntityCommand] (main) Note: If batch processing should be possible, also use 'ra setclearpwd onap-ejbca-6885f79bdf-fvtkd '.
2022-02-08 10:27:07,483+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@5d1cbeca: java.sql.SQLException: (conn=2077) 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:1316)
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-02-08 10:27:07,503+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@4a9e429e: java.sql.SQLException: (conn=2078) 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-02-08 10:27:07,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@35cc344c: java.sql.SQLException: (conn=2079) 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-02-08 10:27:09,367+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:09+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/endentityprofilesrules/1/edit_end_entity;resource1=/ra_functionality/edit_end_entity
2022-02-08 10:27:09,396+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:09+00:00;RA_EDITENDENTITY;SUCCESS;RA;CORE;ejbca;430485574;;onap-ejbca-6885f79bdf-fvtkd;msg=Edited end entity onap-ejbca-6885f79bdf-fvtkd, new status 10.
2022-02-08 10:27:09,411+0000 INFO [org.ejbca.ui.cli.ra.SetEndEntityStatusCommand] (main) New status for end entity onap-ejbca-6885f79bdf-fvtkd is 10
2022-02-08 10:27:12,965+0000 INFO [org.ejbca.ui.cli.ra.SetCleartextPasswordCommand] (main) Setting clear text password for user onap-ejbca-6885f79bdf-fvtkd
2022-02-08 10:27:13,002+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:13+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/endentityprofilesrules/1/edit_end_entity;resource1=/ra_functionality/edit_end_entity
2022-02-08 10:27:13,007+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:13+00:00;RA_EDITENDENTITY;SUCCESS;RA;CORE;ejbca;430485574;;onap-ejbca-6885f79bdf-fvtkd;msg=Password changed for end entity onap-ejbca-6885f79bdf-fvtkd.
2022-02-08 10:27:16,584+0000 INFO [org.ejbca.ui.cli.batch.BatchMakeP12Command] (main) Generating keys in directory /opt/primekey/tmp/tmp.0stS4MWclJ.
2022-02-08 10:27:16,655+0000 INFO [org.ejbca.ui.cli.batch.BatchMakeP12Command] (main) Loading configuration from defaults.
2022-02-08 10:27:16,656+0000 INFO [org.ejbca.ui.cli.batch.BatchMakeP12Command] (main) Generating RSA keys of size 2048 for onap-ejbca-6885f79bdf-fvtkd.
2022-02-08 10:27:17,328+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:17+00:00;CA_USERAUTH;SUCCESS;CA;EJBCA;ejbca;430485574;;onap-ejbca-6885f79bdf-fvtkd;msg=Authenticated user onap-ejbca-6885f79bdf-fvtkd.
2022-02-08 10:27:17,338+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:17+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca_functionality/create_certificate;resource1=/ca/430485574
2022-02-08 10:27:17,339+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:17+00:00;CERT_REQUEST;SUCCESS;CERTIFICATE;CORE;ejbca;430485574;;onap-ejbca-6885f79bdf-fvtkd;subjectdn=UID=c-0twwlqhlkjz7ka9wi,CN=onap-ejbca-6885f79bdf-fvtkd,O=EJBCA Container Quickstart;requestX500name=null;subjectaltname=dnsName=onap-ejbca-6885f79bdf-fvtkd;certprofile=9;keyusage=-1;notbefore=;notafter=;sequence=;publickey=MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAq+xycNTiYM9IjfnDNXtheXbzSpSf4a9bvD+6/BKh/wPsuH5kr778RBjv5lX/4RKKP9xPJQihHMJ5JMkVY9nlDWipY5UqqeKF5DHajCLI9WWfU1yhN6kyvmtu6TdQTv99BZ6CaYCN5CFhOkhXDKyIuukfw+DdbYUF1mqPn9eWhNt45xO/bYf9DjTeGI7NTCww5lph9TYVJFrYG36R3hrfLObpqVDiTkCmTWV3Bn8s4mUZfPBLJvRg759SZK9jrQ9zg+3ii+OrM9uHThoMkppihsowMZy3OQTVVatjzB4w8vH4wWzwpOPDPyUuyRIVvbaokbCgnmeVGTIP9bNvwtpdIQIDAQAB
2022-02-08 10:27:17,383+0000 INFO [org.cesecore.certificates.ca.internal.SernoGeneratorRandom] (default task-2) Using SHA1PRNG serialNumber RNG algorithm.
2022-02-08 10:27:17,473+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:17+00:00;CERT_STORED;SUCCESS;CERTIFICATE;CORE;ejbca;430485574;42A3B2D4406017F7C6C7F004DA8DAAB7F99ADF1F;onap-ejbca-6885f79bdf-fvtkd;msg=Certificate stored for username 'onap-ejbca-6885f79bdf-fvtkd', fp=aabe5e8d8daaf0fd2e5a36aa81945abc8aaa435a, subjectDN 'UID=c-0twwlqhlkjz7ka9wi,CN=onap-ejbca-6885f79bdf-fvtkd,O=EJBCA Container Quickstart', issuerDN 'UID=12345,CN=ManagementCA,O=EJBCA Container Quickstart', serialNo=42A3B2D4406017F7C6C7F004DA8DAAB7F99ADF1F.
2022-02-08 10:27:17,474+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:17+00:00;CERT_CREATION;SUCCESS;CERTIFICATE;CORE;ejbca;430485574;42A3B2D4406017F7C6C7F004DA8DAAB7F99ADF1F;onap-ejbca-6885f79bdf-fvtkd;subjectdn=UID=c-0twwlqhlkjz7ka9wi,CN=onap-ejbca-6885f79bdf-fvtkd,O=EJBCA Container Quickstart;certprofile=9;issuancerevocationreason=-1;cert=MIIEcDCCAtigAwIBAgIUQqOy1EBgF/fGx/AE2o2qt/ma3x8wDQYJKoZIhvcNAQELBQAwUzEVMBMGCgmSJomT8ixkAQEMBTEyMzQ1MRUwEwYDVQQDDAxNYW5hZ2VtZW50Q0ExIzAhBgNVBAoMGkVKQkNBIENvbnRhaW5lciBRdWlja3N0YXJ0MB4XDTIyMDIwODEwMTcxN1oXDTI0MDIwODEwMTcxNlowcDEjMCEGCgmSJomT8ixkAQEME2MtMHR3d2xxaGxrano3a2E5d2kxJDAiBgNVBAMMG29uYXAtZWpiY2EtNjg4NWY3OWJkZi1mdnRrZDEjMCEGA1UECgwaRUpCQ0EgQ29udGFpbmVyIFF1aWNrc3RhcnQwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCr7HJw1OJgz0iN+cM1e2F5dvNKlJ/hr1u8P7r8EqH/A+y4fmSvvvxEGO/mVf/hEoo/3E8lCKEcwnkkyRVj2eUNaKljlSqp4oXkMdqMIsj1ZZ9TXKE3qTK+a27pN1BO/30FnoJpgI3kIWE6SFcMrIi66R/D4N1thQXWao+f15aE23jnE79th/0ONN4Yjs1MLDDmWmH1NhUkWtgbfpHeGt8s5umpUOJOQKZNZXcGfyziZRl88Esm9GDvn1Jkr2OtD3OD7eKL46sz24dOGgySmmKGyjAxnLc5BNVVq2PMHjDy8fjBbPCk48M/JS7JEhW9tqiRsKCeZ5UZMg/1s2/C2l0hAgMBAAGjgZ4wgZswDAYDVR0TAQH/BAIwADAfBgNVHSMEGDAWgBQQjuupf7EEsFkAg2gdaNcRnunLxTAmBgNVHREEHzAdghtvbmFwLWVqYmNhLTY4ODVmNzliZGYtZnZ0a2QwEwYDVR0lBAwwCgYIKwYBBQUHAwEwHQYDVR0OBBYEFG4QmM1+FtHuoTIhyG8bD/rURzv9MA4GA1UdDwEB/wQEAwIFoDANBgkqhkiG9w0BAQsFAAOCAYEADezy5s8zYYcm6IZhaifJRqkNV5T2Ziw0wTyHeDQ628C5Co676QzoBCAn/Fl7XHazAsh7+BdsiUovb9Z5JhzHxSNyEEV6AzisPEV0H6krhBEIS/YhMxspUBvZ30BC4nZY3tn0jCW39Van5wjGWr/SpPchWvMj7IaPHqiQ7wXvNB0l4HAjdnmWCk1DvTJbkG4Pxr1NVptKCQ8pqpGPUcB9ZsQ62Oo55XUemVQeUXpMfeOfxitjB/LulN/msfI6A6FDxCvuT7MPlvFkj2A8BA9kiidhwTHEC4bc6sHchmVccsO5Xfdr3Vhh1WKBLwqLXwo8CGbzE/B8jzITSRJKk5rNbWDAz3hkVt327Oca3j4xEiw0qGdtEuLGUSIcdI9RVVSocz5PNdPrRbY91vPgCEnxl75LzZ6zuroEinkukXqDLTVP4aMQZqa7/uIIqO4Rw/+L82dhQqmYk5WKOsACjX9xoccf/tYTUsA7pqy0UcydvDOYX4GVlufIGBPBv3bhbGN8
2022-02-08 10:27:17,479+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:17+00:00;RA_EDITENDENTITY;SUCCESS;RA;CORE;Local admin call from EndEntityManagementSession.decRequestCounter;430485574;;onap-ejbca-6885f79bdf-fvtkd;msg=Edited end entity onap-ejbca-6885f79bdf-fvtkd, new status 40.
2022-02-08 10:27:17,480+0000 INFO [org.ejbca.core.ejb.ca.auth.EndEntityAuthenticationSessionBean] (default task-2) Changed status for 'onap-ejbca-6885f79bdf-fvtkd' to STATUS_GENERATED.
2022-02-08 10:27:17,551+0000 INFO [org.ejbca.ui.cli.batch.BatchMakeP12Command] (main) Created Keystore for 'onap-ejbca-6885f79bdf-fvtkd'.
2022-02-08 10:27:17,597+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:17+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/endentityprofilesrules/1/edit_end_entity;resource1=/ra_functionality/edit_end_entity
2022-02-08 10:27:17,598+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:17+00:00;RA_EDITENDENTITY;SUCCESS;RA;CORE;ejbca;430485574;;onap-ejbca-6885f79bdf-fvtkd;msg=Password changed for end entity onap-ejbca-6885f79bdf-fvtkd.
2022-02-08 10:27:17,604+0000 INFO [org.ejbca.ui.cli.batch.BatchMakeP12Command] (main) New user generated successfully - onap-ejbca-6885f79bdf-fvtkd.
2022-02-08 10:27:17,943+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Certificate stored in file
2022-02-08 10:27:18,318+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Generated TLS certificate with fingerprint 93b2c64cf81695e55a021a0437f2b7ac2cecc498e5d598e0859933e9c74605ca.
2022-02-08 10:27:18,327+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Importing keystore /opt/primekey/secrets/persistent/tls/onap-ejbca-6885f79bdf-fvtkd/server.jks to /opt/primekey/tmp/tmp.0stS4MWclJ/keystore.jks...
2022-02-08 10:27:18,327+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Entry for alias cacert successfully imported.
2022-02-08 10:27:18,327+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Entry for alias onap-ejbca-6885f79bdf-fvtkd successfully imported.
2022-02-08 10:27:18,327+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Import command completed: 2 entries successfully imported, 0 entries failed or cancelled
2022-02-08 10:27:35,693+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Will use application provided server side TLS keystore.
2022-02-08 10:27:37,544+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@c4ce6ca: java.sql.SQLException: (conn=2098) 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-02-08 10:27:39,023+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:39+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:27:42,630+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:27:42+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:27:42,742+0000 INFO [org.ejbca.ui.cli.ca.GetCaCertCommand] (main) Wrote CA certificate to '/opt/primekey/tmp/tmp.0stS4MWclJ/cacert.der' using DER encoding.
2022-02-08 10:27:51,910+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Certificate was added to keystore
2022-02-08 10:27:55,634+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-02-08 10:28:03,191+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Enabling HTTP listener on 0.0.0.0:8080.
2022-02-08 10:28:03,606+0000 INFO [org.ejbca.ui.web.pub.HealthCheckServlet] (default task-1) All IPs are authorized.
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1)
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) ###################################################################################################
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # Whenever you are ready for production: #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # Try out the commercially supported EJBCA Enterprise Cloud on AWS, fully featured with: #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # - Additional enrollment APIs such as a REST API, EST, ACME and more. #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # - Support for external Registration Authority and OCSP responders #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # - Hardware Security Module support #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # - Application updates #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # - ...and more! #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # #
2022-02-08 10:28:14,365+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-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # your specific needs. #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # https://aws.amazon.com/marketplace/seller-profile?id=7edf9048-58e6-4086-9d98-b8e0c1d78fce #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # https://www.primekey.com #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # sales@primekey.com #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) # #
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1) ###################################################################################################
2022-02-08 10:28:14,365+0000 INFO [/opt/primekey/bin/start.sh] (process:1)
2022-02-08 10:28:14,391+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting 5 seconds before signaling application readiness to ensure proper handling of PublicAccessAuthenticationToken.
2022-02-08 10:28:19,403+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Health check now reports application status at /ejbca/publicweb/healthcheck/ejbcahealth
2022-02-08 10:28:24,032+0000 INFO [org.cesecore.keys.util.SignWithWorkingAlgorithm] (default task-1) Signature algorithm 'SHA1WithRSA' working for provider 'BC version 1.68'.
2022-02-08 10:28:27,211+0000 INFO [org.apache.commons.configuration.PropertiesConfiguration] (default task-1) Reloading configuration. URL is file:/etc/ejbca/conf/web.properties
2022-02-08 10:28:27,301+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:28:27+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:28:34,222+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:28:34+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-02-08 10:28:34,228+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:28:34+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-02-08 10:28:37,846+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:28:37+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:28:37,999+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:28:37+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca_functionality/edit_ca;resource1=/ca/430485574
2022-02-08 10:28:38,010+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:28:38+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-02-08 10:28:38,164+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:28:38+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:28:38,220+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:28:38+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:28:41,555+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:28:41+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-02-08 10:28:41,558+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:28:41+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-02-08 10:28:45,167+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:28:45+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-02-08 10:28:45,170+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:28:45+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-02-08 10:28:48,942+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:28:48+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-02-08 10:28:48,947+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:28:48+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-02-08 10:28:52,390+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:28:52+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-02-08 10:28:52,397+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:28:52+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-02-08 10:29:00,084+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:29:00+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-02-08 10:29:00,087+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:29:00+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-02-08 10:29:03,645+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:29:03+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-02-08 10:29:03,648+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:29:03+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-02-08 10:29:07,373+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:29:07+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:29:10,937+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:29:10+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-02-08 10:29:10,940+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:29:10+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-02-08 10:29:21,822+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:29:21+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-02-08 10:29:21,824+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:29:21+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-02-08 10:29:25,611+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:29:25+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-02-08 10:29:25,615+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-2) 2022-02-08 10:29:25+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-02-08 10:29:29,284+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:29:29+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:29:32,791+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:29:32+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/endentityprofilesrules/1/edit_end_entity;resource1=/ra_functionality/edit_end_entity
2022-02-08 10:29:32,794+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:29:32+00:00;RA_EDITENDENTITY;SUCCESS;RA;CORE;ejbca;430485574;;Node123;msg=Password changed for end entity Node123.
2022-02-08 10:29:36,530+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:29:36+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/system_functionality/edit_systemconfiguration
2022-02-08 10:29:36,532+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:29:36+00:00;SYSTEMCONF_EDIT;SUCCESS;GLOBALCONF;CORE;ejbca;;;;msg=Saved global configuration with id 1.
2022-02-08 10:29:43,701+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:29:43+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:30:05,447+0000 INFO [org.cesecore.audit.impl.log4j.Log4jDevice] (default task-1) 2022-02-08 10:30:05+00:00;ACCESS_CONTROL;SUCCESS;ACCESSCONTROL;CORE;ejbca;;;;resource0=/ca/430485574
2022-02-08 10:31:22,657+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@559c83e8: java.sql.SQLException: (conn=2198) 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-02-08 10:31:45,130+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 1) Reloading CA certificate cache.
2022-02-08 10:31:45,140+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 1) Reloaded CA certificate cache with 1 certificates
2022-02-08 10:35:52,785+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@6c025ca5: java.sql.SQLException: (conn=2316) 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-02-08 10:35:52,791+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@27cc7bf9: java.sql.SQLException: (conn=2317) 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-02-08 10:35:58,153+0000 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-2) SQL Error: 1047, SQLState: 08S01
2022-02-08 10:35:58,154+0000 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-2) (conn=2332) WSREP has not yet prepared node for application use
2022-02-08 10:35:58,160+0000 ERROR [org.ejbca.core.ejb.config.HealthCheckSessionBean] (default task-2) Error creating connection to database.: javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not extract ResultSet
at org.hibernate@5.3.20.Final//org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
at org.hibernate@5.3.20.Final//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1575)
at org.hibernate@5.3.20.Final//org.hibernate.query.Query.getResultList(Query.java:132)
at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.container.QueryNonTxInvocationDetacher.getResultList(QueryNonTxInvocationDetacher.java:58)
at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.ejb.config.HealthCheckSessionBean.getDatabaseStatus(HealthCheckSessionBean.java:44)
at jdk.internal.reflect.GeneratedMethodAccessor236.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.as.ee@22.0.1.Final//org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:509)
at org.jboss.as.weld.common@22.0.1.Final//org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:79)
at org.jboss.as.weld.common@22.0.1.Final//org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:89)
at org.jboss.as.weld.common@22.0.1.Final//org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:102)
at org.jboss.as.ee@22.0.1.Final//org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3@22.0.1.Final//org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ee@22.0.1.Final//org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:40)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:53)
at org.jboss.as.ee@22.0.1.Final//org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3@22.0.1.Final//org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3@22.0.1.Final//org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3@22.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:230)
at org.jboss.as.ejb3@22.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:444)
at org.jboss.as.ejb3@22.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:162)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:509)
at org.jboss.weld.core@3.1.5.Final//org.jboss.weld.module.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:81)
at org.jboss.as.weld.common@22.0.1.Final//org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:89)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3@22.0.1.Final//org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3@22.0.1.Final//org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:47)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3@22.0.1.Final//org.jboss.as.ejb3.security.IdentityOutflowInterceptor.processInvocation(IdentityOutflowInterceptor.java:73)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3@22.0.1.Final//org.jboss.as.ejb3.security.SecurityDomainInterceptor.processInvocation(SecurityDomainInterceptor.java:44)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3@22.0.1.Final//org.jboss.as.ejb3.deployment.processors.StartupAwaitInterceptor.processInvocation(StartupAwaitInterceptor.java:22)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3@22.0.1.Final//org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3@22.0.1.Final//org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:67)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ee@22.0.1.Final//org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:60)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:438)
at org.wildfly.security.elytron-private@1.14.1.Final//org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:633)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:57)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation@1.6.0.Final//org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:53)
at org.jboss.as.ee@22.0.1.Final//org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:198)
at org.jboss.as.ee@22.0.1.Final//org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:191)
at org.jboss.as.ee@22.0.1.Final//org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:81)
at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.ejb.config.HealthCheckSessionLocal$$$view55.getDatabaseStatus(Unknown Source)
at deployment.ejbca.ear.healthcheck.war//org.ejbca.ui.web.pub.HealthCheckServlet.doAllHealthChecks(HealthCheckServlet.java:192)
at deployment.ejbca.ear.healthcheck.war//org.ejbca.ui.web.pub.HealthCheckServlet.getRateLimitedResult(HealthCheckServlet.java:136)
at deployment.ejbca.ear.healthcheck.war//org.ejbca.ui.web.pub.HealthCheckServlet.doGet(HealthCheckServlet.java:110)
at javax.servlet.api@2.0.0.Final//javax.servlet.http.HttpServlet.service(HttpServlet.java:503)
at javax.servlet.api@2.0.0.Final//javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at org.wildfly.extension.undertow@22.0.1.Final//org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
at io.undertow.core@2.2.4.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
at io.undertow.core@2.2.4.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.core@2.2.4.Final//io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:53)
at io.undertow.core@2.2.4.Final//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:59)
at io.undertow.core@2.2.4.Final//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
at io.undertow.core@2.2.4.Final//io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)
at io.undertow.core@2.2.4.Final//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
at io.undertow.core@2.2.4.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at org.wildfly.extension.undertow@22.0.1.Final//org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
at io.undertow.core@2.2.4.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
at io.undertow.core@2.2.4.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
at org.wildfly.extension.undertow@22.0.1.Final//org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)
at org.wildfly.extension.undertow@22.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
at org.wildfly.extension.undertow@22.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
at org.wildfly.extension.undertow@22.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
at org.wildfly.extension.undertow@22.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
at org.wildfly.extension.undertow@22.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
at io.undertow.servlet@2.2.4.Final//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
at io.undertow.core@2.2.4.Final//io.undertow.server.Connectors.executeRootHandler(Connectors.java:387)
at io.undertow.core@2.2.4.Final//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:841)
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 org.jboss.xnio@3.8.4.Final//org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1280)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.exception.JDBCConnectionException: could not extract ResultSet
at org.hibernate@5.3.20.Final//org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)
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.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:69)
at org.hibernate@5.3.20.Final//org.hibernate.loader.Loader.getResultSet(Loader.java:2265)
at org.hibernate@5.3.20.Final//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2028)
at org.hibernate@5.3.20.Final//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1990)
at org.hibernate@5.3.20.Final//org.hibernate.loader.Loader.doQuery(Loader.java:949)
at org.hibernate@5.3.20.Final//org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:351)
at org.hibernate@5.3.20.Final//org.hibernate.loader.Loader.doList(Loader.java:2787)
at org.hibernate@5.3.20.Final//org.hibernate.loader.Loader.doList(Loader.java:2770)
at org.hibernate@5.3.20.Final//org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2604)
at org.hibernate@5.3.20.Final//org.hibernate.loader.Loader.list(Loader.java:2599)
at org.hibernate@5.3.20.Final//org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338)
at org.hibernate@5.3.20.Final//org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2243)
at org.hibernate@5.3.20.Final//org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1069)
at org.hibernate@5.3.20.Final//org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:173)
at org.hibernate@5.3.20.Final//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1566)
... 115 more
Caused by: java.sql.SQLNonTransientConnectionException: (conn=2332) WSREP has not yet prepared node for application use
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:241)
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.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:225)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:145)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:159)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:113)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:504)
at org.hibernate@5.3.20.Final//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
... 129 more
Caused by: java.sql.SQLException: WSREP has not yet prepared node for application use
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:240)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:216)
... 134 more
2022-02-08 10:36:22,816+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@fe42223: java.sql.SQLException: (conn=2331) 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-02-08 10:36:22,820+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@3c339072: java.sql.SQLNonTransientConnectionException: (conn=2332) Connection is closed
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:241)
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: Connection is closed
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.cmdPrologue(AbstractQueryProtocol.java:1849)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:171)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:343)
... 9 more
2022-02-08 10:36:45,141+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 1) Reloading CA certificate cache.
2022-02-08 10:36:45,151+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 1) Reloaded CA certificate cache with 1 certificates
2022-02-08 10:40:22,946+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@4a833717: java.sql.SQLException: (conn=2437) 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-02-08 10:40:22,950+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@7d4bd5c7: java.sql.SQLException: (conn=2438) 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-02-08 10:40:52,981+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@2646141: java.sql.SQLException: (conn=2452) 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-02-08 10:41:45,152+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 1) Reloading CA certificate cache.
2022-02-08 10:41:45,158+0000 INFO [org.cesecore.certificates.certificate.CertificateStoreSessionBean] (EJB default - 1) Reloaded CA certificate cache with 1 certificates