Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
stream database communication error
Contributor II
Hi all,
I´m trying to use "Stream Database" operator to read a large MySQL table. I've passed through various steps to don't go out of memory.
After that I'm receiving the following message:
"Cannot retrieve data from database:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
Communications link failure The last packet successfully received from the server was 998 milliseconds ago. The last packet sent successfully to the server was 230,709 milliseconds ago."
It appears AFTER the "Stream Database" operator appears to have run and a different and posterior operator is running. Perhaps, the process is trying to read another chunk of data.
I don't know how to solve this. Please, could you help me?
Many Thanks.
I´m trying to use "Stream Database" operator to read a large MySQL table. I've passed through various steps to don't go out of memory.
After that I'm receiving the following message:
"Cannot retrieve data from database:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
Communications link failure The last packet successfully received from the server was 998 milliseconds ago. The last packet sent successfully to the server was 230,709 milliseconds ago."
It appears AFTER the "Stream Database" operator appears to have run and a different and posterior operator is running. Perhaps, the process is trying to read another chunk of data.
I don't know how to solve this. Please, could you help me?
Many Thanks.
0
Answers
can you please test if the database connection works reliably with the Read Database operator (e.g. by placing it in a loop and reading some subsets of the data)?
Does your error occur sometimes, or each time you execute the process? Can you retrieve parts of the data before the error occurs?
Best,
Marius