image

🎉 🎉 RAPIDMINER 9.10 IS OUT!!! 🎉🎉

Download the latest version helping analytics teams accelerate time-to-value for streaming and IIOT use cases.

CLICK HERE TO DOWNLOAD

stream database communication error

franaffranaf Member Posts: 13 Contributor II
edited November 2018 in Help
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.

Answers

  • MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869   Unicorn
    Hi,

    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
Sign In or Register to comment.