Increase Exasol session count limit

rango1000
Contributor

How can i increase the Exasol 6.2 session count limit of 30 total open sessions (EXA_ALL_SESSIONS)?

 

Thank you very much,

David

7 REPLIES 7

rango1000
Contributor

Is it possible to increase the parameter sys.EXA_METADATA => maxConnections?

kristof
SQL-Fighter

Not sure what you're trying to achieve or why 30 is your limit. Maybe you can elaborate?

Have you read the article about Session Management? https://docs.exasol.com/database_concepts/session_management.htm

rango1000
Contributor

Yes, i did read the article. Exasol is rejecting new sessions, if there are more than 30 open sessions (Error message: "exacs(3.0): Limit of active sessions has been reached."). I need more open sessions for a cluster computing setup.

exa-Chris
Community Manager
Community Manager

Dear Rango,
your question puzzles me a little bit. In your last question you where asking about a Single Node VM Ware installation and now you are looking for a cluster setup. Can you DM me to see where the problem is? A Community Edition is not intended to work in a cluster. Let us help you there.
Regards
Christian

Connecting Customers, Partners, Prospects and Exasolians is my passion. Apart from that I cycle, listen to music, and try to understand what all those technical discussions really mean...

kristof
SQL-Fighter

30 somehow rings a bell, but I don't remember what it exactly was. Probably the maximum recommended number of active sessions. But this shouldn't be a hard limit.

What's the result of this query in your system?

SELECT * FROM sys.EXA_METADATA em
WHERE PARAM_NAME IN ('maxConnections','maxStatements');

rango1000
Contributor

@kristof 

maxStatements 100 true
maxConnections 100 true

@exa-Chris 

It is just a single exasol node and more than 50 python script instances are trying to connect to it. If they do, they hit the error "Limit of active sessions has been reached."

exa-Chris
Community Manager
Community Manager

Hi Rango,
I will let someone reach out to you as quick as possible. But to put it in the words of a wiser man. May be:

Weisser Hai.jpg

 

 

 

 

 

 

Regards
exa-Chris

Connecting Customers, Partners, Prospects and Exasolians is my passion. Apart from that I cycle, listen to music, and try to understand what all those technical discussions really mean...