Hi, We userd Mendix 4.4.3.1, while running the some internal process, we are getting the issue with JDBC connectivity issue, could you please suggest where we can define the ConnectionPoolMaxActive in NITRA configuration file. As suggested by Infra team, that enrty should be in yaml file. however there is no entry for this in yaml file. Please suggest. PFB logs for more details. 2016-01-13 00:03:22.353 WARNING - ConnectionBus: Database connections: 50 active, 0 idle. 2016-01-13 00:03:22.353 ERROR - ConnectionBus: Opening JDBC connection to dbcloud041-scan.db.gen.local:1521 failed with SQLState: null Error code: 0 Message: Cannot get a connection, pool error Timeout waiting for idle object Retrying...(3/4) 2016-01-13 00:03:22.353 WARNING - ConnectionBus: Database connections: 50 active, 0 idle. 2016-01-13 00:03:22.353 ERROR - ConnectionBus: Opening JDBC connection to dbcloud041-scan.db.gen.local:1521 failed with SQLState: null Error code: 0 Message: Cannot get a connection, pool error Timeout waiting for idle object Retrying...(3/4) 2016-01-13 00:03:22.353 WARNING - ConnectionBus: Database connections: 50 active, 0 idle. 2016-01-13 00:03:22.353 ERROR - ConnectionBus: Opening JDBC connection to dbcloud041-scan.db.gen.local:1521 failed with SQLState: null Error code: 0 Message: Cannot get a connection, pool error Timeout waiting for idle object Retrying...(3/4) 2016-01-13 00:03:22.353 WARNING - ConnectionBus: Database connections: 50 active, 0 idle. 2016-01-13 00:03:22.353 ERROR - ConnectionBus: Opening JDBC connection to dbcloud041-scan.db.gen.local:1521 failed with SQLState: null Error code: 0 Message: Cannot get a connection, pool error Timeout waiting for idle object Retrying...(3/4) 2016-01-13 00:03:22.353 WARNING - ConnectionBus: Database connections: 50 active, 0 idle. 2016-01-13 00:03:22.353 ERROR - ConnectionBus: Opening JDBC connection to dbcloud041-scan.db.gen.local:1521 failed with SQLState: null Error code: 0 Message: Cannot get a connection, pool error Timeout waiting for idle object Retrying...(3/4) 2016-01-13 00:03:27.019 WARNING - ConnectionBus: Database connections: 50 active, 0 idle.
asked
Rahul Rode
2 answers
1
Have a look at the example m2ee configuration files at the Mendix GitHub for m2ee (in particular the full version at line 599).
answered
Nick van Wieren
1
Setting this number to higher than 50 does not seem to make a lot of sense in general. Unless your database server is some ridiculous beast with more than 50 cores it can't be a good idea performance wise to ever have this number of database sessions open.