Error "No buffer space available "

Anonymous — Wed, 26 Mar 2014 12:11:24 GMT

Hi,
I added 4GO of RAM and 3 processors on the remote desktop. Then when I executed the job Talend, I obtain the following error:
"Exception in component tMSSqlOutput_3
java.sql.SQLException: Network error IOException: No buffer space available (maximum connections reached?): connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:410)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at iac_dev.alim_mesures_meteo_temp_1_0.Alim_Mesures_METEO_Temp.tFileInputDelimited_3Process(Alim_Mesures_METEO_Temp.java:1648)
at iac_dev.alim_mesures_meteo_temp_1_0.Alim_Mesures_METEO_Temp.runJobInTOS(Alim_Mesures_METEO_Temp.java:5992)
at iac_dev.alim_mesures_meteo_temp_1_0.Alim_Mesures_METEO_Temp.runJob(Alim_Mesures_METEO_Temp.java:5783)
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.tFileList_1Process(Alim_Mesures_METEO.java:786)
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.runJobInTOS(Alim_Mesures_METEO.java:3675)

at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.main(Alim_Mesures_METEO.java:3463)
Caused by: java.net.SocketException: No buffer space available (maximum connections reached?): connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:307)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:257)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:311)

Exception in component tRunJob_3
java.lang.RuntimeException: Child job running failed
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.tFileList_1Process(Alim_Mesures_METEO.java:808)
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.runJobInTOS(Alim_Mesures_METEO.java:3675)
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.main(Alim_Mesures_METEO.java:3463)"

What is that you know the cause of this error?

Re: Error "No buffer space available "

willm1 — Wed, 26 Mar 2014 18:37:32 GMT

I first tempted to say your java heap size needs to be checked, but when I looked at the stack trace, I noted that this might be a DB issue...
Looks like it's a connection issue to Windows using RDP - http://stackoverflow.com/questions/10088363/java-net-socketexception-no-buffer-space-available-maximum-connections-reached

Re: Error "No buffer space available "

Anonymous — Thu, 27 Mar 2014 08:33:45 GMT

Hello,
Thank you for your answer. But what I have to make to solve the problem?

topic Re: Error "No buffer space available " in Talend Studio

Error "No buffer space available "

Re: Error "No buffer space available "

Re: Error "No buffer space available "