Licenses in Docker image of IRIS (store/intersystems/iris:2019.2.0.107.0-community)

Question

Question

Luis-Ángel Pére... · Jun 21, 2019

Hi! I am working in a java project (Spring Boot+ Maven + Hibernate) using jpa/hibernate to manage the persistance with the IRIS database from the Docker image (store/intersystems/iris:2019.2.0.107.0-community) and I've found an issue using the IRIS instance, when I define tables with relationships OneToMany, ManyToOne or ManyToMany and I try to fetch all the rows of the tables using the default method findAll (JpaRepository implements that method to get all the rows by default) the query automatically exceeds the limit of licenses availables. I've tested the same query using a local IRIS instance with a regular license (InterSystems IRIS 2018.1 Enterprise - Concurrent Users for x86-64 (Microsoft Windows):250, Non-Production Instance) and works perfectly.

Could be possible increase the number of licenses availables for the IRIS image in Docker?

Thank you in advance!

Discussion (11)1

Log in or sign up to continue

Dmitry Maslennikov Jun 25, 2019 to David Reche

Yes, it is, but in this case, it exceeded connections limit for one license unit and it is even just only 4 in comparing with 25 for ordinary versions.

And I think this message in the log should be changed to be more clear.

Another issue, here

USER> Write $SYSTEM.License.MaxConnections()
25

25 connections for ordinary version, but Community Edition, has only 4 connections and fails to start more.

And another problem is that reaching connections limit for just one user, changes state of the instance as with warn

root@d5eaa844235c:/# iris list

Configuration 'IRIS'   (default)
        directory:    /usr/irissys
        versionid:    2019.2.0.107.0com
        datadir:      /dur/config
        conf file:    iris.cpf  (SuperServer port = 51773, WebServer = 52773)
        status:       running, since Tue Jun 25 13:00:11 2019
        state:        warn
        product:      InterSystems IRIS

And this state used for HEALTHCHECK of the container, so, this container became as Unhealthy, which means in production such container should be killed, even it is actually in good condition.

$ docker-compose ps
        Name                   Command               State     
---------------------------------------------------------------
jdbc-jpa-rest_iris_1   /iris-main             Up (unhealthy)

2 0

Luis-Ángel Pére... Jun 21, 2019 to Dmitry Maslennikov

Hi Dmitry, It's true, it's not a problem of licenses, it's a problem of connections:

Before the select: only 1 connection used.

When the project execute the findAll query: Connections used = 5

It seems like a problem with the connection pool manager, it reserves connections for each query and when the connections achieve the maximum the execution is blockade.

0 0

Warlin Garcia Jun 24, 2019 to Luis-Ángel Pére...

The default value for connection pool size on boot is usually 10. You may want to set this value to 1 or 2 for testing purposes (if using the IRIS community version).

0 0

score 0 · Answer 1 · 2019-06-21T14:18:11-04:00

David Reche · Jun 21, 2019

I think the limit is 5 concurrent users. Anyone can confirm?

0 0

score 0 · Answer 2 · 2019-06-21T16:34:44-04:00

I don't see any realation between license capacity and how you describe you use it. Is it possible to get some reproducible excerpt which would prove what you said?

score 0 · Answer 3 · 2019-06-22T07:10:23-04:00

Dmitry Maslennikov Jun 22, 2019 to Luis-Ángel Pére...

Could you share your Java code?

0 0

score 0 · Answer 4 · 2019-06-24T08:45:24-04:00

Sure! You have it available here:

https://github.com/es-comunidad-intersystems/webinar-multimodelo/tree/master/jdbc-jpa-rest

It's a MAVEN project so you only need MAVEN installed in your PC and modify the actions.properties to define the parameters to access to the database.

score 0 · Answer 5 · 2019-06-25T09:50:04-04:00

so, my application.properties

in this case, I have only 4 connections on the server, without any issues with licenses

spring.datasource.driverClassName = com.intersystems.jdbc.IRISDriver
spring.datasource.url = jdbc:IRIS://127.0.0.1:9091/USER
spring.datasource.username = _SYSTEM
spring.datasource.password = 1234
spring.datasource.testOnBorrow = true
spring.datasource.testWhileIdle = true
spring.datasource.timeBetweenEvictionRunsMillis = 60000
spring.datasource.minEvictableIdleTimeMillis = 30000
spring.datasource.validationQuery = SELECT 1
spring.datasource.max-wait = 8000
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.InterSystemsIRISDialect
spring.jpa.hibernate.ddl-auto = create
spring.jpa.properties.hibernate.temp.use_jdbc_metadata_defaults=false = false
spring.datasource.hikari.maximumPoolSize = 4

score 0 · Answer 6 · 2019-06-24T10:31:11-04:00

Luis-Ángel Pére... Jun 24, 2019 to Warlin Garcia

Hi Warlin! thank you for your answer, I tried modifying the connection pool size to 1, 2 and 3 and the problem continued.

0 0

score 0 · Answer 7 · 2019-06-24T11:16:38-04:00

Which value did you modify?

The pool size takes couple values into account.

Which connection pooling are you using? If using default boot one it's Hikari and the value to change should be maximumPoolSize

score 0 · Answer 8 · 2019-06-25T03:35:19-04:00

I've modified spring.datasource.hikari.maximumPoolSize values (with differents values 1, 2, 3 and 4) and when the application execute a findAll or a query without the clause WHERE the execution is blockade.

In theory there are 2 free connections but the error returned is:

org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection