After making some tests with my RM setup I am running into a "too many connection" on my DB. Is there any operator I can use to close the connection once the process has run?
Read Database Nominal to Text Set Role Process Documents Tokenize, Transform Case, Filter Stopwords, Stem Store Wordlist Validation Naive Bayes, Apply Model, Performance Store Model Free Memory
--
The error comes and goes, I see it often after running my process a few times. I also have to say that I am not 100% sure it is RapidMiner fault,maybe some other script is running multiple connections and by chance at the same time RM tries to connect and there are no more connections available.
When you are not sure that RapidMiner is the cause, then please investigate the issue further. Most database servers offer the possibility to view the current connections. In MySQL for example, execute the following command (probably you must be the mysql root user):
SHOW PROCESSLIST
If it seems that RapidMiner is the cause, please post the output of the command (or a relevant excerpt), and please also post your process setup as described in the post linked from my signature.
OK, thanks. I will mark this as solved until I get more information about the issue and if the multiple open connections issue is caused by RapidMiner I reopen it so we can investigate further.
Contributor II
Answers
we have have fixed an issue like this some months ago, may I know which version of RapidMiner and which operators you are using?
Best regards,
Marius
Thanks for your reply. I am using v 5.2.008.
Operators:
Read Database
Nominal to Text
Set Role
Process Documents
Tokenize, Transform Case, Filter Stopwords, Stem
Store Wordlist
Validation
Naive Bayes, Apply Model, Performance
Store Model
Free Memory
--
The error comes and goes, I see it often after running my process a few times. I also have to say that I am not 100% sure it is RapidMiner fault,maybe some other script is running multiple connections and by chance at the same time RM tries to connect and there are no more connections available.
I will keep investigating.
Best regards,
Marius
I will mark this as solved until I get more information about the issue and if the multiple open connections issue is caused by RapidMiner I reopen it so we can investigate further.