One Star

How to solve this problem

Hi
i am using Talend 3.0 version some time this error occur please tell how to solve this error..

Starting job Repeat_trouble_ticket_hsi_19_03_2010 at 11:41 05/04/2010.
connecting to socket on port 3474
connected
Exception in component tMysqlInput_5
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The driver was unable to create a connection due to an inability to establish the client portion of a socket.
This is usually caused by a limit on the number of sockets imposed by the operating system. This limit is usually configurable.
For Unix-based platforms, see the manual page for the 'ulimit' command. Kernel or system reconfiguration may also be required.
For Windows-based platforms, see Microsoft Knowledge Base Article 196271 (Q196271).
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2001)
at com.mysql.jdbc.Connection.<init>(Connection.java:716)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.GeneratedConstructorAccessor5.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at hsbb_assurance.repeat_trouble_ticket_hsi_19_03_2010_0_1.Repeat_trouble_ticket_hsi_19_03_2010.tMysqlInput_5Process(Repeat_trouble_ticket_hsi_19_03_2010.java:8933)
at hsbb_assurance.repeat_trouble_ticket_hsi_19_03_2010_0_1.Repeat_trouble_ticket_hsi_19_03_2010.tMysqlInput_4Process(Repeat_trouble_ticket_hsi_19_03_2010.java:2483)
at hsbb_assurance.repeat_trouble_ticket_hsi_19_03_2010_0_1.Repeat_trouble_ticket_hsi_19_03_2010.tMysqlInput_1Process(Repeat_trouble_ticket_hsi_19_03_2010.java:1267)
at hsbb_assurance.repeat_trouble_ticket_hsi_19_03_2010_0_1.Repeat_trouble_ticket_hsi_19_03_2010.runJobInTOS(Repeat_trouble_ticket_hsi_19_03_2010.java:10027)
at hsbb_assurance.repeat_trouble_ticket_hsi_19_03_2010_0_1.Repeat_trouble_ticket_hsi_19_03_2010.main(Repeat_trouble_ticket_hsi_19_03_2010.java:9918)
Caused by: java.net.BindException: Address already in use: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:168)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:262)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1926)
... 15 more
disconnected
Job Repeat_trouble_ticket_hsi_19_03_2010 ended at 11:41 05/04/2010.
1 REPLY
Community Manager

Re: How to solve this problem

Hello
It seems you are creating so many connections in the job, try to use tMysqlConnection to create the conneciton and use the same connection on tMysqlnput. See a related 2772
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business