Error: consider increasing net_wait_timeout

asked 2018-04-17 06:08:52 -0500

Shruthi gravatar image

updated 2018-04-23 22:22:39 -0500

metadaddy gravatar image

I am sending data from mariadb to odoo. My origin is JDBC query consumer and destination is Http Client. It is around 50k datas. Pipeline is running very slowly like data goes as a chunk of 1000 in few minutes. And after sometime i get the following error

Pipeline Status: RUNNING_ERROR: com.streamsets.pipeline.api.StageException: JDBC_77 - SQLNonTransientConnectionException attempting to execute query. Giving up after 1 errors as per stage configuration. First error: SQLState: 08 Error Code: 0 Message: (conn=315073) Server has closed the connection. If result set contain huge amount of data, Server expects client to read off the result set relatively fast. In this case, please consider increasing net_wait_timeout session variable / processing your result set faster (check Streaming result sets documentation for more information) Cause: java.sql.SQLException: Server has closed the connection. If result set contain huge amount of data, Server expects client to read off the result set relatively fast. In this case, please consider increasing net_wait_timeout session variable / processing your result set faster (check Streaming result sets documentation for more information) Cause: java.net.SocketException: Connection reset SQLState: 08 Error Code: 0 Message: Server has closed the connection. If result set contain huge amount of data, Server expects client to read off the result set relatively fast. In this case, please consider increasing net_wait_timeout session variable / processing your result set faster (check Streaming result sets documentation for more information) Cause: java.sql.SQLException: Server has closed the connection. If result set contain huge amount of data, Server expects client to read off the result set relatively fast. In this case, please consider increasing net_wait_timeout session variable / processing your result set faster (check Streaming result sets documentation for more information) Cause: java.net.SocketException: Connection reset

Whenever i get this error message it retries and starts to run again. Can anyone help me to solve this

edit retag flag offensive close merge delete

Comments

How have you configured the HTTP Client destination - is 'One Request per Batch' checked? If not, the destination is sending an HTTP request to the web service for every record, which is probably the cause of the problem.

metadaddy gravatar imagemetadaddy ( 2018-04-23 22:27:14 -0500 )edit