Options
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