kandi background
Explore Kits

ironjacamar | The IronJacamar project

 by   ironjacamar Java Version: Current License: LGPL-2.1

 by   ironjacamar Java Version: Current License: LGPL-2.1

Download this library from

kandi X-RAY | ironjacamar Summary

ironjacamar is a Java library. ironjacamar has build file available, it has a Weak Copyleft License and it has high support. However ironjacamar has 170 bugs and it has 17 vulnerabilities. You can download it from GitHub, Maven.
IronJacamar implements the Java EE Connector Architecture 1.7 specification, and is certified in both the standalone profile, and full profile. IronJacamar is licensed under [GNU LESSER GENERAL PUBLIC LICENSE 2.1 (LGPL 2.1)](http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html "LGPL v2.1").
Support
Support
Quality
Quality
Security
Security
License
License
Reuse
Reuse

kandi-support Support

  • ironjacamar has a highly active ecosystem.
  • It has 28 star(s) with 105 fork(s). There are 8 watchers for this library.
  • It had no major release in the last 12 months.
  • There are 28 open issues and 52 have been closed. On average issues are closed in 157 days. There are 6 open pull requests and 0 closed requests.
  • It has a negative sentiment in the developer community.
  • The latest version of ironjacamar is current.
ironjacamar Support
Best in #Java
Average in #Java
ironjacamar Support
Best in #Java
Average in #Java

quality kandi Quality

  • ironjacamar has 170 bugs (15 blocker, 8 critical, 127 major, 20 minor) and 5311 code smells.
ironjacamar Quality
Best in #Java
Average in #Java
ironjacamar Quality
Best in #Java
Average in #Java

securitySecurity

  • ironjacamar has 1 vulnerability issues reported (0 critical, 0 high, 1 medium, 0 low).
  • ironjacamar code analysis shows 16 unresolved vulnerabilities (16 blocker, 0 critical, 0 major, 0 minor).
  • There are 158 security hotspots that need review.
ironjacamar Security
Best in #Java
Average in #Java
ironjacamar Security
Best in #Java
Average in #Java

license License

  • ironjacamar is licensed under the LGPL-2.1 License. This license is Weak Copyleft.
  • Weak Copyleft licenses have some restrictions, but you can use them in commercial projects.
ironjacamar License
Best in #Java
Average in #Java
ironjacamar License
Best in #Java
Average in #Java

buildReuse

  • ironjacamar releases are not available. You will need to build from source code and install.
  • Deployable package is available in Maven.
  • Build file is available. You can build the component from source.
  • It has 213919 lines of code, 12004 functions and 2393 files.
  • It has medium code complexity. Code complexity directly impacts maintainability of the code.
ironjacamar Reuse
Best in #Java
Average in #Java
ironjacamar Reuse
Best in #Java
Average in #Java
Top functions reviewed by kandi - BETA

kandi has reviewed ironjacamar and discovered the below as its top functions. This is intended to give you an instant insight into ironjacamar implemented functionality, and help decide if they suit your requirements.

  • Create and inject resources .
    • Read the definition from stdout .
      • Creates the work manager security .
        • Executes the JOIN command .
          • Deploy XA data source .
            • method to generate the SS edit
              • Generate the connection listener report .
                • Create config properties from a common data source
                  • Creates the control .
                    • Sends a message .

                      Get all kandi verified functions for this library.

                      Get all kandi verified functions for this library.

                      ironjacamar Key Features

                      The IronJacamar project

                      bitnami Keycloak docker is not starting- "Failed to delete PingData in database"

                      copy iconCopydownload iconDownload
                      kc-tests_postgresql_data
                      

                      Keycloak Starting with separate DB_SCHEMA an error occured

                      copy iconCopydownload iconDownload
                      Update to 13.0.0 fails due to liquibase error for non-default schema
                      

                      Unknown Error in ManyToOne Hibernate Mapping related to Foreign Composite Key on MySQL DB

                      copy iconCopydownload iconDownload
                      CREATE TABLE RESIDENTS (
                        -- ...
                        FOREIGN KEY (address, block, internal_id) REFERENCES REAL_STATES (address, block, internal_id)
                      );
                      
                      @Entity
                      @Table(name = "residents")
                      public class Resident implements Serializable {
                         // ...
                      
                         @ManyToOne
                         @JoinColumns({
                            @JoinColumn(name="address", referencedColumnName = "address"),
                            @JoinColumn(name="block", referencedColumnName = "block"),
                            @JoinColumn(name="internal_id", referencedColumnName = "internal_id")
                         })
                         private RealState realState;
                      }
                      
                      @Entity
                      @Table(name = "real_states")
                      public class RealState implements Serializable {
                         // ...
                         @OneToMany(mappedBy = "realState", fetch= FetchType.EAGER, cascade = CascadeType.ALL)
                         private List<Resident> resident;
                      }
                      
                      CREATE TABLE RESIDENTS (
                        -- ...
                        FOREIGN KEY (address, block, internal_id) REFERENCES REAL_STATES (address, block, internal_id)
                      );
                      
                      @Entity
                      @Table(name = "residents")
                      public class Resident implements Serializable {
                         // ...
                      
                         @ManyToOne
                         @JoinColumns({
                            @JoinColumn(name="address", referencedColumnName = "address"),
                            @JoinColumn(name="block", referencedColumnName = "block"),
                            @JoinColumn(name="internal_id", referencedColumnName = "internal_id")
                         })
                         private RealState realState;
                      }
                      
                      @Entity
                      @Table(name = "real_states")
                      public class RealState implements Serializable {
                         // ...
                         @OneToMany(mappedBy = "realState", fetch= FetchType.EAGER, cascade = CascadeType.ALL)
                         private List<Resident> resident;
                      }
                      
                      CREATE TABLE RESIDENTS (
                        -- ...
                        FOREIGN KEY (address, block, internal_id) REFERENCES REAL_STATES (address, block, internal_id)
                      );
                      
                      @Entity
                      @Table(name = "residents")
                      public class Resident implements Serializable {
                         // ...
                      
                         @ManyToOne
                         @JoinColumns({
                            @JoinColumn(name="address", referencedColumnName = "address"),
                            @JoinColumn(name="block", referencedColumnName = "block"),
                            @JoinColumn(name="internal_id", referencedColumnName = "internal_id")
                         })
                         private RealState realState;
                      }
                      
                      @Entity
                      @Table(name = "real_states")
                      public class RealState implements Serializable {
                         // ...
                         @OneToMany(mappedBy = "realState", fetch= FetchType.EAGER, cascade = CascadeType.ALL)
                         private List<Resident> resident;
                      }
                      

                      Keycloak docker service cannot connect to database

                      copy iconCopydownload iconDownload
                      version: "3.6"
                      services:
                        project-db:
                          container_name: project-maria-db
                          image: mariadb:10.5.8-focal
                          restart: always
                          ports:
                            - 3308:3306
                          volumes:
                            - /project/db:/data/db
                          environment:
                            - MYSQL_ROOT_PASSWORD=root
                            - MYSQL_DATABASE=project
                            - MYSQL_USER=user
                            - MYSQL_PASSWORD=password
                          networks:
                            - app-network
                      
                        project-keycloak:
                          container_name: project-keycloak
                          image: quay.io/keycloak/keycloak:10.0.1
                          restart: always
                          ports:
                            - 8180:8080
                          environment:
                            PROXY_ADDRESS_FORWARDING: "true"
                            DB_VENDOR: mariadb
                            DB_ADDR: project-db
                            DB_PORT: 3308
                            DB_DATABASE: project_keycloak
                            DB_USER: user
                            DB_PASSWORD: password
                            KEYCLOAK_USER: admin
                            KEYCLOAK_PASSWORD: admin
                          depends_on:
                            - project-db
                          networks:
                            - app-network
                      networks:
                        app-network:
                          driver: bridge
                      

                      Wildfly 21: bootable JAR can't find H2 JDBC driver/datasource classes

                      copy iconCopydownload iconDownload
                        <dependency>
                          <groupId>com.h2database</groupId>
                          <artifactId>h2</artifactId>
                          <scope>runtime</scope>
                        </dependency>
                      
                        <dependency>
                          <groupId>com.h2database</groupId>
                          <artifactId>h2</artifactId>
                          <scope>test</scope>
                        </dependency>
                      
                        <dependency>
                          <groupId>com.h2database</groupId>
                          <artifactId>h2</artifactId>
                          <scope>runtime</scope>
                        </dependency>
                      
                        <dependency>
                          <groupId>com.h2database</groupId>
                          <artifactId>h2</artifactId>
                          <scope>test</scope>
                        </dependency>
                      

                      wildfly-logstash does not send logs to logstash

                      copy iconCopydownload iconDownload
                      embed-server --server-config=standalone-ha.xml --std-out=echo
                      
                      /subsystem=logging/json-formatter=LOG-STASH:add(key-overrides={timestamp=@timestamp,message=@message,logger-name=@source,host-name=@source_host}, exception-output-type=formatted)
                      
                      /socket-binding-group=standard-sockets/remote-destination-outbound-socket-binding=log-stash:add(host=localhost, port=${env.port})
                      /subsystem=logging/socket-handler=LOGSTASH-SOCKET:add(named-formatter=LOG-STASH, outbound-socket-binding-ref=log-stash, level=DEBUG)
                      
                      /subsystem=logging/async-handler=LOGSTASH-ASYNC:add(queue-length=512, subhandlers=[LOGSTASH-SOCKET])
                      
                      /subsystem=logging/root-logger=ROOT:add-handler(name=LOGSTASH-ASYNC)
                      
                      stop-embedded-server
                      

                      Socket read interrupted during callback from Docker Java

                      copy iconCopydownload iconDownload
                      Thread thread = new Thread(() -> {
                          Thread streamingThread = Thread.currentThread();
                          try (DockerHttpClient.Response response = execute(request)) {
                              callback.onStart(() -> {
                                  streamingThread.interrupt();
                                  response.close();
                              });
                      
                              sourceConsumer.accept(response);
                              callback.onComplete();
                          } catch (Exception e) {
                              callback.onError(e);
                          }
                      }, "docker-java-stream-" + Objects.hashCode(request));
                      thread.setDaemon(true);
                      thread.start();
                      
                      @Override
                      public void onComplete() {
                          try {
                              close();
                          } catch (IOException e) {
                              throw new RuntimeException(e);
                          }
                      }
                      
                      @Override
                      public void onComplete() {
                          super.onComplete();
                          updateTest(FINISHED);
                      }
                      
                      @Override
                      public void onComplete() {
                          updateTest(FINISHED);
                          super.onComplete();
                      }
                      
                      Thread thread = new Thread(() -> {
                          Thread streamingThread = Thread.currentThread();
                          try (DockerHttpClient.Response response = execute(request)) {
                              callback.onStart(() -> {
                                  streamingThread.interrupt();
                                  response.close();
                              });
                      
                              sourceConsumer.accept(response);
                              callback.onComplete();
                          } catch (Exception e) {
                              callback.onError(e);
                          }
                      }, "docker-java-stream-" + Objects.hashCode(request));
                      thread.setDaemon(true);
                      thread.start();
                      
                      @Override
                      public void onComplete() {
                          try {
                              close();
                          } catch (IOException e) {
                              throw new RuntimeException(e);
                          }
                      }
                      
                      @Override
                      public void onComplete() {
                          super.onComplete();
                          updateTest(FINISHED);
                      }
                      
                      @Override
                      public void onComplete() {
                          updateTest(FINISHED);
                          super.onComplete();
                      }
                      
                      Thread thread = new Thread(() -> {
                          Thread streamingThread = Thread.currentThread();
                          try (DockerHttpClient.Response response = execute(request)) {
                              callback.onStart(() -> {
                                  streamingThread.interrupt();
                                  response.close();
                              });
                      
                              sourceConsumer.accept(response);
                              callback.onComplete();
                          } catch (Exception e) {
                              callback.onError(e);
                          }
                      }, "docker-java-stream-" + Objects.hashCode(request));
                      thread.setDaemon(true);
                      thread.start();
                      
                      @Override
                      public void onComplete() {
                          try {
                              close();
                          } catch (IOException e) {
                              throw new RuntimeException(e);
                          }
                      }
                      
                      @Override
                      public void onComplete() {
                          super.onComplete();
                          updateTest(FINISHED);
                      }
                      
                      @Override
                      public void onComplete() {
                          updateTest(FINISHED);
                          super.onComplete();
                      }
                      
                      Thread thread = new Thread(() -> {
                          Thread streamingThread = Thread.currentThread();
                          try (DockerHttpClient.Response response = execute(request)) {
                              callback.onStart(() -> {
                                  streamingThread.interrupt();
                                  response.close();
                              });
                      
                              sourceConsumer.accept(response);
                              callback.onComplete();
                          } catch (Exception e) {
                              callback.onError(e);
                          }
                      }, "docker-java-stream-" + Objects.hashCode(request));
                      thread.setDaemon(true);
                      thread.start();
                      
                      @Override
                      public void onComplete() {
                          try {
                              close();
                          } catch (IOException e) {
                              throw new RuntimeException(e);
                          }
                      }
                      
                      @Override
                      public void onComplete() {
                          super.onComplete();
                          updateTest(FINISHED);
                      }
                      
                      @Override
                      public void onComplete() {
                          updateTest(FINISHED);
                          super.onComplete();
                      }
                      

                      Springboot application doesn't get deployed on Wildfly

                      copy iconCopydownload iconDownload
                       <plugin>
                                      <groupId>org.wildfly.plugins</groupId>
                                      <artifactId>wildfly-maven-plugin</artifactId>
                                      <version>2.0.2.Final</version>
                                      <executions>
                                          <execution>
                                              <phase>install</phase>
                                              <goals>
                                                  <goal>deploy</goal>
                                              </goals>
                                          </execution>
                                      </executions>
                                      <configuration>
                                          <filename>${project.build.finalName}.war</filename>
                                          <hostname>${deploy.jboss.host}</hostname>
                                          <port>${deploy.jboss.port}</port>
                                          <username>${deploy.jboss.username}</username>
                                          <password>${deploy.jboss.password}</password>
                                      </configuration>
                                  </plugin>
                      
                      <?xml version="1.0" encoding="UTF-8"?>
                      <project xmlns="http://maven.apache.org/POM/4.0.0"
                          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
                          <modelVersion>4.0.0</modelVersion>
                          <parent>
                              <groupId>org.springframework.boot</groupId>
                              <artifactId>spring-boot-starter-parent</artifactId>
                              <version>2.2.6.RELEASE</version>
                              <relativePath /> <!-- lookup parent from repository -->
                          </parent>
                          <groupId>com.example</groupId>
                          <artifactId>hello</artifactId>
                          <version>0.0.1-SNAPSHOT</version>
                          <packaging>war</packaging>
                          <name>demo</name>
                          <description>Demo project for Spring Boot</description>
                      
                          <properties>
                              <java.version>1.8</java.version>
                          </properties>
                      
                          <dependencies>
                              <dependency>
                                  <groupId>org.springframework.boot</groupId>
                                  <artifactId>spring-boot-starter-web</artifactId>
                                  <exclusions>
                                      <exclusion>
                                          <groupId>org.springframework.boot</groupId>
                                          <artifactId>spring-boot-starter-tomcat</artifactId>
                                      </exclusion>
                                  </exclusions>
                              </dependency>
                              <dependency>
                                  <groupId>javax.servlet</groupId>
                                  <artifactId>javax.servlet-api</artifactId>
                                  <scope>provided</scope>
                              </dependency>
                              <dependency>
                                  <groupId>org.springframework.boot</groupId>
                                  <artifactId>spring-boot-starter-thymeleaf</artifactId>
                              </dependency>
                          </dependencies>
                          <build>
                              <plugins>
                                  <plugin>
                                      <groupId>org.springframework.boot</groupId>
                                      <artifactId>spring-boot-maven-plugin</artifactId>
                                      <executions>
                                          <execution>
                                              <goals>
                                                  <goal>repackage</goal>
                                              </goals>
                                          </execution>
                                      </executions>
                                  </plugin>
                              </plugins>
                              <finalName>demo</finalName>
                          </build>
                      </project>
                      

                      NameNotFoundException: connecting to remote queue via logstash

                      copy iconCopydownload iconDownload
                      <pooled-connection-factory connectors="netty" entries="java:jboss/exported/jms/RemoteConnectionFactory" name="RemoteConnectionFactory" user="admin" password="admin"/>
                      
                      <connection-factory name="RemoteConnectionFactory" entries="java:jboss/exported/jms/RemoteConnectionFactory" connectors="http-connector"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB java:jboss/exported/AuditTrailMDB"/>
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.apache.activemq.artemis.jndi.ActiveMQInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'tcp://localhost:5445?type=QUEUE_CF'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.wildfly.naming.client.WildFlyInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'http-remoting://127.0.0.1:8080'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_name => 'queueConnectionFactory'
                      
                      jndi_name => 'jms/RemoteConnectionFactory'
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/jboss-client.jar', 
                                      '/home/Alternant/logstash/dependencies/artemis-ra.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-impl.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-api.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-common-api.jar']
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/wildfly-client-all-7.1.0.GA-redhat-11.jar']
                      
                      <pooled-connection-factory connectors="netty" entries="java:jboss/exported/jms/RemoteConnectionFactory" name="RemoteConnectionFactory" user="admin" password="admin"/>
                      
                      <connection-factory name="RemoteConnectionFactory" entries="java:jboss/exported/jms/RemoteConnectionFactory" connectors="http-connector"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB java:jboss/exported/AuditTrailMDB"/>
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.apache.activemq.artemis.jndi.ActiveMQInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'tcp://localhost:5445?type=QUEUE_CF'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.wildfly.naming.client.WildFlyInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'http-remoting://127.0.0.1:8080'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_name => 'queueConnectionFactory'
                      
                      jndi_name => 'jms/RemoteConnectionFactory'
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/jboss-client.jar', 
                                      '/home/Alternant/logstash/dependencies/artemis-ra.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-impl.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-api.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-common-api.jar']
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/wildfly-client-all-7.1.0.GA-redhat-11.jar']
                      
                      <pooled-connection-factory connectors="netty" entries="java:jboss/exported/jms/RemoteConnectionFactory" name="RemoteConnectionFactory" user="admin" password="admin"/>
                      
                      <connection-factory name="RemoteConnectionFactory" entries="java:jboss/exported/jms/RemoteConnectionFactory" connectors="http-connector"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB java:jboss/exported/AuditTrailMDB"/>
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.apache.activemq.artemis.jndi.ActiveMQInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'tcp://localhost:5445?type=QUEUE_CF'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.wildfly.naming.client.WildFlyInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'http-remoting://127.0.0.1:8080'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_name => 'queueConnectionFactory'
                      
                      jndi_name => 'jms/RemoteConnectionFactory'
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/jboss-client.jar', 
                                      '/home/Alternant/logstash/dependencies/artemis-ra.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-impl.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-api.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-common-api.jar']
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/wildfly-client-all-7.1.0.GA-redhat-11.jar']
                      
                      <pooled-connection-factory connectors="netty" entries="java:jboss/exported/jms/RemoteConnectionFactory" name="RemoteConnectionFactory" user="admin" password="admin"/>
                      
                      <connection-factory name="RemoteConnectionFactory" entries="java:jboss/exported/jms/RemoteConnectionFactory" connectors="http-connector"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB java:jboss/exported/AuditTrailMDB"/>
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.apache.activemq.artemis.jndi.ActiveMQInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'tcp://localhost:5445?type=QUEUE_CF'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.wildfly.naming.client.WildFlyInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'http-remoting://127.0.0.1:8080'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_name => 'queueConnectionFactory'
                      
                      jndi_name => 'jms/RemoteConnectionFactory'
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/jboss-client.jar', 
                                      '/home/Alternant/logstash/dependencies/artemis-ra.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-impl.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-api.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-common-api.jar']
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/wildfly-client-all-7.1.0.GA-redhat-11.jar']
                      
                      <pooled-connection-factory connectors="netty" entries="java:jboss/exported/jms/RemoteConnectionFactory" name="RemoteConnectionFactory" user="admin" password="admin"/>
                      
                      <connection-factory name="RemoteConnectionFactory" entries="java:jboss/exported/jms/RemoteConnectionFactory" connectors="http-connector"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB java:jboss/exported/AuditTrailMDB"/>
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.apache.activemq.artemis.jndi.ActiveMQInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'tcp://localhost:5445?type=QUEUE_CF'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.wildfly.naming.client.WildFlyInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'http-remoting://127.0.0.1:8080'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_name => 'queueConnectionFactory'
                      
                      jndi_name => 'jms/RemoteConnectionFactory'
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/jboss-client.jar', 
                                      '/home/Alternant/logstash/dependencies/artemis-ra.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-impl.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-api.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-common-api.jar']
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/wildfly-client-all-7.1.0.GA-redhat-11.jar']
                      
                      <pooled-connection-factory connectors="netty" entries="java:jboss/exported/jms/RemoteConnectionFactory" name="RemoteConnectionFactory" user="admin" password="admin"/>
                      
                      <connection-factory name="RemoteConnectionFactory" entries="java:jboss/exported/jms/RemoteConnectionFactory" connectors="http-connector"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB java:jboss/exported/AuditTrailMDB"/>
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.apache.activemq.artemis.jndi.ActiveMQInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'tcp://localhost:5445?type=QUEUE_CF'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.wildfly.naming.client.WildFlyInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'http-remoting://127.0.0.1:8080'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_name => 'queueConnectionFactory'
                      
                      jndi_name => 'jms/RemoteConnectionFactory'
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/jboss-client.jar', 
                                      '/home/Alternant/logstash/dependencies/artemis-ra.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-impl.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-api.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-common-api.jar']
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/wildfly-client-all-7.1.0.GA-redhat-11.jar']
                      
                      <pooled-connection-factory connectors="netty" entries="java:jboss/exported/jms/RemoteConnectionFactory" name="RemoteConnectionFactory" user="admin" password="admin"/>
                      
                      <connection-factory name="RemoteConnectionFactory" entries="java:jboss/exported/jms/RemoteConnectionFactory" connectors="http-connector"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB java:jboss/exported/AuditTrailMDB"/>
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.apache.activemq.artemis.jndi.ActiveMQInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'tcp://localhost:5445?type=QUEUE_CF'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.wildfly.naming.client.WildFlyInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'http-remoting://127.0.0.1:8080'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_name => 'queueConnectionFactory'
                      
                      jndi_name => 'jms/RemoteConnectionFactory'
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/jboss-client.jar', 
                                      '/home/Alternant/logstash/dependencies/artemis-ra.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-impl.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-api.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-common-api.jar']
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/wildfly-client-all-7.1.0.GA-redhat-11.jar']
                      
                      <pooled-connection-factory connectors="netty" entries="java:jboss/exported/jms/RemoteConnectionFactory" name="RemoteConnectionFactory" user="admin" password="admin"/>
                      
                      <connection-factory name="RemoteConnectionFactory" entries="java:jboss/exported/jms/RemoteConnectionFactory" connectors="http-connector"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB java:jboss/exported/AuditTrailMDB"/>
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.apache.activemq.artemis.jndi.ActiveMQInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'tcp://localhost:5445?type=QUEUE_CF'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.wildfly.naming.client.WildFlyInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'http-remoting://127.0.0.1:8080'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_name => 'queueConnectionFactory'
                      
                      jndi_name => 'jms/RemoteConnectionFactory'
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/jboss-client.jar', 
                                      '/home/Alternant/logstash/dependencies/artemis-ra.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-impl.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-api.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-common-api.jar']
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/wildfly-client-all-7.1.0.GA-redhat-11.jar']
                      
                      <pooled-connection-factory connectors="netty" entries="java:jboss/exported/jms/RemoteConnectionFactory" name="RemoteConnectionFactory" user="admin" password="admin"/>
                      
                      <connection-factory name="RemoteConnectionFactory" entries="java:jboss/exported/jms/RemoteConnectionFactory" connectors="http-connector"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB java:jboss/exported/AuditTrailMDB"/>
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.apache.activemq.artemis.jndi.ActiveMQInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'tcp://localhost:5445?type=QUEUE_CF'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.wildfly.naming.client.WildFlyInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'http-remoting://127.0.0.1:8080'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_name => 'queueConnectionFactory'
                      
                      jndi_name => 'jms/RemoteConnectionFactory'
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/jboss-client.jar', 
                                      '/home/Alternant/logstash/dependencies/artemis-ra.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-impl.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-api.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-common-api.jar']
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/wildfly-client-all-7.1.0.GA-redhat-11.jar']
                      
                      <pooled-connection-factory connectors="netty" entries="java:jboss/exported/jms/RemoteConnectionFactory" name="RemoteConnectionFactory" user="admin" password="admin"/>
                      
                      <connection-factory name="RemoteConnectionFactory" entries="java:jboss/exported/jms/RemoteConnectionFactory" connectors="http-connector"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB"/>
                      
                      <jms-queue name="AuditTrailMDB" entries="queue/AuditTrailMDB java:jboss/exported/AuditTrailMDB"/>
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.apache.activemq.artemis.jndi.ActiveMQInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'tcp://localhost:5445?type=QUEUE_CF'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_context => { 
                       'java.naming.factory.initial' => 'org.wildfly.naming.client.WildFlyInitialContextFactory'
                       'java.naming.security.principal' => 'admin'
                       'java.naming.provider.url' => 'http-remoting://127.0.0.1:8080'
                       'java.naming.security.credentials' => 'admin'
                      }
                      
                      jndi_name => 'queueConnectionFactory'
                      
                      jndi_name => 'jms/RemoteConnectionFactory'
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/jboss-client.jar', 
                                      '/home/Alternant/logstash/dependencies/artemis-ra.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-impl.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-core-api.jar',
                                      '/home/Alternant/logstash/dependencies/ironjacamar-common-api.jar']
                      
                      require_jars=> ['/home/Alternant/logstash/dependencies/wildfly-client-all-7.1.0.GA-redhat-11.jar']
                      

                      Community Discussions

                      Trending Discussions on ironjacamar
                      • Keycloak giving Lock wait timeout exceeded error in case Save Events enable
                      • bitnami Keycloak docker is not starting- &quot;Failed to delete PingData in database&quot;
                      • How to integrate Ironjacamar with Spring Boot
                      • Error while running keycloak with docker [MySQL]
                      • Keycloak docker service cannot connect to database. Throwable while attempting to get a new connection: null : Unable to create connection
                      • Keycloak Starting with separate DB_SCHEMA an error occured
                      • Keycloak/Wildfly How to configure all console logs to JSON format
                      • Unknown Error in ManyToOne Hibernate Mapping related to Foreign Composite Key on MySQL DB
                      • What is the connection pool library use by JBoss 6.4 EAP?
                      • Keycloak docker service cannot connect to database
                      Trending Discussions on ironjacamar

                      QUESTION

                      Keycloak giving Lock wait timeout exceeded error in case Save Events enable

                      Asked 2022-Mar-14 at 04:40

                      I am using keycloak as an Identity broker in my project.

                      Environment setup: Keycloak version 16.1.1 deployed in k8s cluster with replica 2.

                      Cluster configuration:

                        - name: JGROUPS_DISCOVERY_PROTOCOL
                          value: kubernetes.KUBE_PING
                        - name: KUBERNETES_NAMESPACE
                          valueFrom:
                            fieldRef:
                              apiVersion: v1
                              fieldPath: metadata.namespace
                        - name: CACHE_OWNERS_COUNT
                          value: "2"
                        - name: CACHE_OWNERS_AUTH_SESSIONS_COUNT
                          value: "2"
                      

                      In keycloak setup we want to log Login and Logout events so I enabled the Save Events and added Save Types as below

                      Event config: enter image description here

                      Now when users login/logout from the application, I am getting below error in logs and the event is not getting saved, I am not getting this error all the time.

                      Error:

                      10:21:01,074 ERROR [io.undertow.request] (default task-17) UT005023: Exception handling request to /auth/realms/realm123/protocol/openid-connect/logout: org.keycloak.models.ModelException: org.hibernate.PessimisticLockException: could not execute statement
                          at org.keycloak.keycloak-model-jpa@16.1.1//org.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:84)
                          at org.keycloak.keycloak-model-jpa@16.1.1//org.keycloak.connections.jpa.JpaExceptionConverter.convert(JpaExceptionConverter.java:31)
                          at org.keycloak.keycloak-services@16.1.1//org.keycloak.transaction.JtaTransactionWrapper.lambda$handleException$0(JtaTransactionWrapper.java:65)
                          at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
                          at java.base/java.util.HashMap$ValueSpliterator.forEachRemaining(HashMap.java:1693)
                          at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
                          at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
                          at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
                          at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
                          at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
                          at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
                          at org.keycloak.keycloak-services@16.1.1//org.keycloak.transaction.JtaTransactionWrapper.handleException(JtaTransactionWrapper.java:67)
                          at org.keycloak.keycloak-services@16.1.1//org.keycloak.transaction.JtaTransactionWrapper.commit(JtaTransactionWrapper.java:92)
                          at org.keycloak.keycloak-services@16.1.1//org.keycloak.services.DefaultKeycloakTransactionManager.commit(DefaultKeycloakTransactionManager.java:136)
                          at org.keycloak.keycloak-services@16.1.1//org.keycloak.services.filters.AbstractRequestFilter.close(AbstractRequestFilter.java:64)
                          at org.keycloak.keycloak-services@16.1.1//org.keycloak.services.filters.AbstractRequestFilter.filter(AbstractRequestFilter.java:49)
                          at org.keycloak.keycloak-wildfly-extensions@16.1.1//org.keycloak.provider.wildfly.WildFlyRequestFilter.doFilter(WildFlyRequestFilter.java:39)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
                          at org.wildfly.security.elytron-web.undertow-server@1.10.1.Final//org.wildfly.elytron.web.undertow.server.ElytronRunAsHandler.lambda$handleRequest$1(ElytronRunAsHandler.java:68)
                          at org.wildfly.security.elytron-base@1.18.3.Final//org.wildfly.security.auth.server.FlexibleIdentityAssociation.runAsFunctionEx(FlexibleIdentityAssociation.java:103)
                          at org.wildfly.security.elytron-base@1.18.3.Final//org.wildfly.security.auth.server.Scoped.runAsFunctionEx(Scoped.java:161)
                          at org.wildfly.security.elytron-base@1.18.3.Final//org.wildfly.security.auth.server.Scoped.runAs(Scoped.java:73)
                          at org.wildfly.security.elytron-web.undertow-server@1.10.1.Final//org.wildfly.elytron.web.undertow.server.ElytronRunAsHandler.handleRequest(ElytronRunAsHandler.java:67)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
                          at io.undertow.core@2.2.14.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
                          at io.undertow.core@2.2.14.Final//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
                          at io.undertow.core@2.2.14.Final//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
                          at org.wildfly.security.elytron-web.undertow-server-servlet@1.10.1.Final//org.wildfly.elytron.web.undertow.server.servlet.CleanUpHandler.handleRequest(CleanUpHandler.java:38)
                          at io.undertow.core@2.2.14.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
                          at org.wildfly.extension.undertow@26.0.1.Final//org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
                          at io.undertow.core@2.2.14.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
                          at org.wildfly.extension.undertow@26.0.1.Final//org.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
                          at io.undertow.core@2.2.14.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
                          at org.wildfly.extension.undertow@26.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1544)
                          at org.wildfly.extension.undertow@26.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1544)
                          at org.wildfly.extension.undertow@26.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1544)
                          at org.wildfly.extension.undertow@26.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1544)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
                          at io.undertow.servlet@2.2.14.Final//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
                          at io.undertow.core@2.2.14.Final//io.undertow.server.Connectors.executeRootHandler(Connectors.java:387)
                          at io.undertow.core@2.2.14.Final//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
                          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.5.Final//org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1280)
                          at java.base/java.lang.Thread.run(Thread.java:829)
                      Caused by: org.hibernate.PessimisticLockException: could not execute statement
                          at org.hibernate@5.3.24.Final//org.hibernate.dialect.MySQLDialect$3.convert(MySQLDialect.java:532)
                          at org.hibernate@5.3.24.Final//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
                          at org.hibernate@5.3.24.Final//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
                          at org.hibernate@5.3.24.Final//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
                          at org.hibernate@5.3.24.Final//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178)
                          at org.hibernate@5.3.24.Final//org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3193)
                          at org.hibernate@5.3.24.Final//org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3707)
                          at org.hibernate@5.3.24.Final//org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:90)
                          at org.hibernate@5.3.24.Final//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
                          at org.hibernate@5.3.24.Final//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478)
                          at org.hibernate@5.3.24.Final//org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356)
                          at org.hibernate@5.3.24.Final//org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
                          at org.hibernate@5.3.24.Final//org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1472)
                          at org.hibernate@5.3.24.Final//org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:512)
                          at org.hibernate@5.3.24.Final//org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3310)
                          at org.hibernate@5.3.24.Final//org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2506)
                          at org.hibernate@5.3.24.Final//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:447)
                          at org.hibernate@5.3.24.Final//org.hibernate.resource.transaction.backend.jta.internal.JtaTransactionCoordinatorImpl.beforeCompletion(JtaTransactionCoordinatorImpl.java:352)
                          at org.hibernate@5.3.24.Final//org.hibernate.resource.transaction.backend.jta.internal.synchronization.SynchronizationCallbackCoordinatorNonTrackingImpl.beforeCompletion(SynchronizationCallbackCoordinatorNonTrackingImpl.java:47)
                          at org.hibernate@5.3.24.Final//org.hibernate.resource.transaction.backend.jta.internal.synchronization.RegisteredSynchronization.beforeCompletion(RegisteredSynchronization.java:37)
                          at org.wildfly.transaction.client@2.0.0.Final//org.wildfly.transaction.client.AbstractTransaction.performConsumer(AbstractTransaction.java:236)
                          at org.wildfly.transaction.client@2.0.0.Final//org.wildfly.transaction.client.AbstractTransaction.performConsumer(AbstractTransaction.java:247)
                          at org.wildfly.transaction.client@2.0.0.Final//org.wildfly.transaction.client.AbstractTransaction$AssociatingSynchronization.beforeCompletion(AbstractTransaction.java:292)
                          at org.jboss.jts//com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:76)
                          at org.jboss.jts//com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:360)
                          at org.jboss.jts//com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:91)
                          at org.jboss.jts//com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)
                          at org.jboss.jts//com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1295)
                          at org.jboss.jts//com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:128)
                          at org.jboss.jts.integration//com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:94)
                          at org.wildfly.transaction.client@2.0.0.Final//org.wildfly.transaction.client.LocalTransaction.commitAndDissociate(LocalTransaction.java:78)
                          at org.wildfly.transaction.client@2.0.0.Final//org.wildfly.transaction.client.ContextTransactionManager.commit(ContextTransactionManager.java:71)
                          at org.keycloak.keycloak-services@16.1.1//org.keycloak.transaction.JtaTransactionWrapper.commit(JtaTransactionWrapper.java:90)
                          ... 50 more
                      Caused by: java.sql.SQLException: (conn=64759) Lock wait timeout exceeded; try restarting transaction
                          at org.mariadb.jdbc//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:262)
                          at org.mariadb.jdbc//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:164)
                          at org.mariadb.jdbc//org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:258)
                          at org.mariadb.jdbc//org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:225)
                          at org.mariadb.jdbc//org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:145)
                          at org.mariadb.jdbc//org.mariadb.jdbc.ClientSidePreparedStatement.executeUpdate(ClientSidePreparedStatement.java:176)
                          at org.jboss.ironjacamar.jdbcadapters@1.5.3.Final//org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)
                          at org.hibernate@5.3.24.Final//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
                          ... 78 more
                      Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
                          at org.mariadb.jdbc//org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1598)
                          at org.mariadb.jdbc//org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1460)
                          at org.mariadb.jdbc//org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1423)
                          at org.mariadb.jdbc//org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:240)
                          at org.mariadb.jdbc//org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:216)
                          ... 82 more
                      

                      I am not getting this error if I disable Save Events

                      ANSWER

                      Answered 2022-Mar-14 at 04:40

                      The issue was with database which is MariaDB Opensource.

                      I checked in database with show processlist, I found that to many delete and insert query running on the table EVENT_ENTITY and table size was around 14GB.

                      I truncated the table EVENT_ENTITY as I don't required older events. After truncating records all is working as expected.

                      Source https://stackoverflow.com/questions/71221098

                      Community Discussions, Code Snippets contain sources that include Stack Exchange Network

                      Vulnerabilities

                      The IronJacamar container before 1.0.12.Final for JBoss Application Server, when allow-multiple-users is enabled in conjunction with a security domain, does not use the credentials supplied in a getConnection function call, which allows remote attackers to obtain access to an arbitrary datasource connection in opportunistic circumstances via an invalid connection attempt.

                      Install ironjacamar

                      You can download it from GitHub, Maven.
                      You can use ironjacamar like any standard Java library. Please include the the jar files in your classpath. You can also use any IDE and you can run and debug the ironjacamar component as you would do with any other Java program. Best practice is to use a build tool that supports dependency management such as Maven or Gradle. For Maven installation, please refer maven.apache.org. For Gradle installation, please refer gradle.org .

                      Support

                      For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

                      DOWNLOAD this Library from

                      Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from
                      over 430 million Knowledge Items
                      Find more libraries
                      Reuse Solution Kits and Libraries Curated by Popular Use Cases
                      Explore Kits

                      Save this library and start creating your kit

                      Share this Page

                      share link
                      Consider Popular Java Libraries
                      Try Top Libraries by ironjacamar
                      Compare Java Libraries with Highest Support
                      Compare Java Libraries with Highest Quality
                      Compare Java Libraries with Highest Security
                      Compare Java Libraries with Permissive License
                      Compare Java Libraries with Highest Reuse
                      Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from
                      over 430 million Knowledge Items
                      Find more libraries
                      Reuse Solution Kits and Libraries Curated by Popular Use Cases
                      Explore Kits

                      Save this library and start creating your kit

                      • © 2022 Open Weaver Inc.